Category: Accounting
Database: DBC
View Column | Data Type | Format | Comment |
---|---|---|---|
DatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The DatabaseName field stores the DatabaseName of the table. |
TableName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The TableName field stores the TableName of the table. |
CurPerm | BIGINT | --,---,---,---,---,---,--9 | The CurPerm field stores the Current Physical Size of the table in bytes. |
CurPermWithoutFallback | BIGINT | --,---,---,---,---,---,--9 | The CurPermWithoutFallback field stores the Current Physical Size of the table without fallback in bytes. |
CurPermCDS | DECIMAL(28,3) | --(25).9(3) | The CurPermCDS field stores the Logical (CDS) Size of the table in bytes. It excludes Fallback subtable. |
CompressionFactor | FLOAT | -9.99999999999999E-999 | The CompressionFactor field stores the X value which is 1:X times when compared to the physical size of the table. |
LastCollectTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The LastCollectTimeStamp field stores the Last statistics collection time stamp. |
CurrentTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The CurrentTimeStamp field stores the Current TimeStamp value. |
IsValid | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | The IsValid field indicates if for the table collect stats has been run or not. |