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