Field Name | Start | Length | Display | Type | Default Column Header | Description |
---|---|---|---|---|---|---|
SQLOWNID | 29 | 8 | A/N | SQL/DS OWNER ID | SQL owner identifier; this can be the same as user ID Identifies the owner of the DBSPACE | |
SQLDBNAM | 37 | 8 | A/N | DATABASE NAME | Name of the SQL database | |
SQLSPOOL | 45 | 2 | 99909 | BINP | STORAGE POOL NUMBER | Storage pool number |
SQLSTYPE | 47 | XX | BIT | DBSPACE TYPE | The type of DBSPACE. Values: X'01'=Private; only the owner can access this information. X'02'=Public; anyone can access this information. | |
SQLSNAML | 48 | 1 | XX | BIT | DBSPACE NAME LEN | The length of the DBSPACE name |
SQLSNAME | 49 | 18 | A/N | DBSPACE NAME | The name of the DBSPACE | |
SQLSPACE | 67 | 2 | 99909 | BINP | DBSPACE NUMBER | A number assigned to the DBSPACE to uniquely identify it |
SQLPAGES | 69 | 4 | 9,999,999,909 | BINS | DBSPACE PAGES OWNED | Pages of storage owned |
SQLDAYS | 73 | 2 | 99909 | BINP | DAYS OWNED | The number of days you are charged for owning the DBSPACE |
SQLSTOR$ | 185 | 4 | 99,999,990.99 | BINS | COST FOR PAGES OWNED | Charge for pages owned |