AREASUMMARY Request

The AREASUMMARY request produces a list of files showing the AREASIZE value, the number of uncrunched and crunched rows, the total segments, and the file name. The default output option is SPO.

<areasummary request>

                     ┌◄──────────────────────────────────────┐
── AREASUMMARY ── : ─┴─┬─<output option>───────────────────┬─┴─────────┤
                       ├─ FAMILYNAME ─┬─ = ──<family name>─┤
                       ├─ PACKNAME ───┘                    │
                       ├─ SIZE ── = ──<integer>────────────┤
                       └─ SORT ────────────────────────────┘

Explanation

For more information about <output option> refer to “Output Options” earlier in this section.

SIZE = <integer>

Specifies the minimum number of segments per area of files to be included in the report. For crunched files with just one area allocated, if the number of segments in that area is less than the specified size, the file is reported. If the SIZE clause is not specified, AREASUMMARY reports on all files.

SORT

Causes the output to be sorted in descending order by the size of the full areas. Crunched files with just one area allocated are sorted by the last area. The potential size of full areas in such files is reported in parentheses.

FILEDATA Modifiers

The following modifiers are used to specify the disk family to be reported on, as discussed under “FILEDATA Modifiers” later in this section.

  • FAMILYNAME

  • PACKNAME