The following table details various column names along with their descriptions.
|
Col |
Column Name |
Len |
Coltype |
Description |
|---|---|---|---|---|
|
1 |
MODEL_ID |
4 |
INTEGER |
ID of the containing model |
|
2 |
TBNAME |
16 |
CHAR |
DATA_STORE_INDEX |
|
3 |
ID |
4 |
INTEGER |
Unique identifier |
|
4 |
ORG_ID |
4 |
INTEGER |
Original object identifier |
|
5 |
NAME |
8 |
CHAR |
Name of the data store |
|
6 |
DB2_BUFFERPOOL |
1 |
CHAR |
Buffer pool assignment:
|
|
7 |
VSAM_CAT_NAME |
8 |
CHAR |
Name of the VSAM catalog |
|
8 |
DB2_CLOSE |
1 |
CHAR |
Close when not in use?
|
|
9 |
DB2_SUBPAGES |
1 |
CHAR |
Number of subpages per page, 1, 2, 4, 8, S - 16 |
|
10 |
ERASE_OLD_ |
1 |
CHAR |
Erase old data during Create?
|
|
11 |
UNIT_ALLOC |
1 |
CHAR |
Unit for allocation quantity:
|
|
12 |
USE_DEFAULT_ |
1 |
CHAR |
Use default data set properties?
|
|
13 |
FREE_PAGE_FREQ |
4 |
INTEGER |
Free page frequency |
|
14 |
FREE_SPACE_PCT |
4 |
INTEGER |
Free space percentage |
|
15 |
PRIME_ALLOC |
4 |
INTEGER |
Primary allocation quantity |
|
16 |
SECOND_ALLOC |
4 |
INTEGER |
Secondary allocation quantity |
|
17 |
DATABASE_ID |
4 |
INTEGER |
ID of the database. Join with DATA_BASE. |
|
18 |
STORAGE_GRP_ID |
4 |
INTEGER |
ID of the storage group that contains the indexspace. Join with STORAGE_GROUP. Zero if the indexspace is not contained by a storage group. |
|
Copyright © 2013 CA.
All rights reserved.
|
|