Column Name | Data Type | Description | |
location_name | char(32) | The name of the location | |
data_usage | char(1) | Y if data location N if not | |
jrnl_usage | char(1) | Y if journal location N if not | |
ckpt_usage | char(1) | Y if checkpoint location N if not | |
work_usage | char(1) | Y if work location N if not | |
dump_usage | char(1) | Y if dump location N if not | |
awork_usage | char(1) | Y if auxiliary work location N if not | |
location_area | char(128) | The location of the area, either: II_CHECKPOINT II_DATABASE II_WORK II_JOURNAL II_DUMP or directory name | |
security_label | char(8) | Empty string This column is deprecated. | |
raw_pct | integer | Percentage of the raw device allocated to this location | |
status | integer | What the location is used for: Bitmasks as follows: | |
0x00000001 | General purpose | ||
0x00000002 | Dump | ||
0x00000008 | Database | ||
0x00000010 | Work | ||
0x00000020 | Auxiliary work | ||
0x00000040 | Journal | ||
0x00000200 | Checkpoint | ||