Table Detail Report
DM_RESIZING_TEMP
Column Section | Top of Page |
Table-level Detail
Description: | Will contain physical data statistics for any given object at any time. |
Definition: | Will contain physical data statistics for any given object at any time like total space, unused space and so forth |
Table Type: | ACTIVITY |
Column Detail - DM_RESIZING_TEMP
Column Name | Type | Null? | Definition |
---|---|---|---|
LUB | DOUBLE | Y | Last used block for a given object |
LUEBI | DOUBLE | Y | Last used extent block id for a given object |
LUEFI | DOUBLE | Y | Last used extent file id for a given object |
OWNER | VARCHAR(20) | Y | The name of the owner |
SEGMENT_NAME | VARCHAR(40) | N | The name of the object |
SEGMENT_TYPE | VARCHAR(20) | N | The type of the object |
TABLESPACE_NAME | VARCHAR(30) | N | The name of the table space |
TBLOCKS | DOUBLE | Y | Total blocks allocated for a given object in a given tablespace |
TBYTES | DOUBLE | Y | Total bytes allocated for a given object in a given tablespace |
UBLOCKS | DOUBLE | Y | Unused blocks (free) for a given object in a given tablespace |
UBYTES | DOUBLE | Y | Unused bytes (free) for a given object in a given tablespace |
DM_SCHEMA_LOG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | DM SCHEMA LOG |
Definition: | Log for downtime schema estimates. |
Table Type: | ACTIVITY |
Column Detail - DM_SCHEMA_LOG
Column Name | Type | Null? | Definition |
---|---|---|---|
GEN_DT_TM | DATETIME | Y | Date and time downtime estimates were generated. |
OCD | DOUBLE | N | OCD number. |
RUN_ID | DOUBLE | N | Primary key. |
SCHEMA_DATE | DATETIME | Y | Schema date. |
Relationship Detail - DM_SCHEMA_LOG
Parent Column in DM_SCHEMA_LOG (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RUN_ID | DM_SCHEMA_OP_LOG | RUN_ID |
DM_SCHEMA_OP_LOG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | DM SCHEMA OP LOG |
Definition: | Downtime schema estimator operation log. |
Table Type: | ACTIVITY |
Column Detail - DM_SCHEMA_OP_LOG
Column Name | Type | Null? | Definition |
---|---|---|---|
ACT_DURATION | DOUBLE | Y | Actual duration of operation. |
BEGIN_DT_TM | DATETIME | Y | Date and time the operation was started. |
END_DT_TM | DATETIME | Y | Date and time the operation finished. |
ERROR_MSG | VARCHAR(255) | Y | Error message received if the DDL command failed |
EST_DURATION | DOUBLE | Y | Estimated duration. |
FILENAME | VARCHAR(80) | Y | File name of DDL file containing the operation. |
OBJ_NAME | VARCHAR(30) | Y | Object name. |
OP_ID | DOUBLE | N | Primary key. |
OP_TYPE | VARCHAR(80) | Y | Operation type. |
ROW_CNT | DOUBLE | Y | Count of rows on table. |
RUN_ID | DOUBLE | N | Run ID of parent run. |
STATUS | VARCHAR(80) | Y | Status. |
TABLE_NAME | VARCHAR(30) | Y | TABLE NAME |
Relationship Detail - DM_SCHEMA_OP_LOG
Child Column in DM_SCHEMA_OP_LOG(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RUN_ID | DM_SCHEMA_LOG | RUN_ID |
DM_SCRIPT_MIGRATION_STAGE
Column Section | Top of Page |
Table-level Detail
Description: | DM SCRIPT MIGRATION STAGE |
Definition: | Stores information about custom CCL scripts selected to be migrated from one domain to another. |
Table Type: | ACTIVITY |
Column Detail - DM_SCRIPT_MIGRATION_STAGE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
COMMENT_TEXT | VARCHAR(2000) | Y | Holds comments stored about this script. |
COMMIT_COMPILE_DT_TM | DATETIME | Y | Holds the Compile date for this script at the time of commit. |
COMMIT_DT_TM | DATETIME | Y | Holds the date the user committed this object to be migrated. |
COMMIT_UPDT_ID | DOUBLE | N | Holds the updt_id for the user who committed this entry. |
DM_SCRIPT_MIGRATION_STAGE_ID | DOUBLE | N | Primary Key for the Table. |
MIGRATION_COMPILE_DT_TM | DATETIME | Y | Holds the CCL compile date in the source environment at the time the component was merged. |
MIGRATION_DT_TM | DATETIME | Y | Holds the date this script was migrated to the TARGET environment. |
MIGRATION_UPDT_ID | DOUBLE | N | Holds the updt_id for the user who migrated this component into the TARGET environment. |
SCRIPT_GROUP_NBR | DOUBLE | N | Holds the group owner designated for the CCL Script to be migrated. |
SCRIPT_NAME | VARCHAR(40) | N | Holds the name of the CCL Script to be migrated. |
TARGET_ENVIRONMENT_ID | DOUBLE | N | Holds the environment ID for the TARGET environment for migrating this script. (This value may come from the Admin DM_ENVIRONMENT table) |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
DM_SCRIPT_STAT
Column Section | Top of Page |
Table-level Detail
Description: | DM SCRIPT STAT |
Definition: | Holds statistical information about all parent/request & child objects |
Table Type: | ACTIVITY |
Column Detail - DM_SCRIPT_STAT
Column Name | Type | Null? | Definition |
---|---|---|---|
DATA_NAME | VARCHAR(60) | N | Descriptive modifier that further describes the type of the object |
DATA_VALUE | DOUBLE | N | Contains a sum of similar data names occurring within the same object |
SCHEMA_DATE | DATETIME | N | Rev date from DM_SCHEMA_VERSION |
SCRIPT_NAME | VARCHAR(80) | N | The script name of the object that the statistics were generated for |
USER_NAME | VARCHAR(30) | N | Shows what user is accessing the table, either a BATCH or an individual user |