DM_STAT_RESEND_RETRY



Column Section Top of Page


Table-level Detail

Description: Data Management Statistics Resend Retry
Definition: This table will keep track of the XML files that failed the MSACLIENT call. In the future this table can be used to keep track of the regenerated XML files.
Table Type: ACTIVITY





Column Detail - DM_STAT_RESEND_RETRY


Column Name Type Null? Definition
BATCH_INDEX_NBR DOUBLE N File number index of the individual file within a chunked dataset. Always 1 for a non-chunked dataset.
BATCH_SIZE_NBR DOUBLE N Number of files belonging to a group for a single chunked dataset. Always 1 for a non-chunked dataset.
CCTS_RESEND_RETRY_CNT DOUBLE N Defines which files still need to be sent.
DM_STAT_RESEND_RETRY_ID DOUBLE N Uniquely identifies a given row on the dm_stat_resend_retry table.
FILE_NAME VARCHAR(100) N Contains the name of the XML file.
REGENERATE_CNT DOUBLE N Contains the number of times the XML file was regenerated.
REGENERATE_DT_TM DATETIME N Contains the date and time when the XML file was regenerated.
REGENERATE_IND DOUBLE N Indicates whether XML file was regenerated.
RESEND_RETRY_CNT DOUBLE N Contains the number of times the XML file failed to be sent.
RESEND_RETRY_DT_TM DATETIME N Contains the date and time the XML file was resent.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.


DM_STAT_SNAPS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Statistical Snapshots
Definition: This table is the parent for all database monitoring snapshots.
Table Type: ACTIVITY





Column Detail - DM_STAT_SNAPS


Column Name Type Null? Definition
CLIENT_MNEMONIC VARCHAR(10) N Mnemonic taken from the DM_INFO.INFO_CHAR column where INFO_DOMAIN = 'DATA MANAGEMENT', INFO_NAME = 'CLIENT MNEMONIC'
DM_STAT_SNAP_ID DOUBLE N Primary key popped from the DM_SEQ sequence.
DOMAIN_NAME VARCHAR(20) N Domain name as taken from req_data->domain
NODE_NAME VARCHAR(30) N Node name as taken from the CURNODE variable.
SNAPSHOT_TYPE VARCHAR(100) N Indicates the type of snapshot taken. Allows the table to be used on various types of snapshots. (system stats, score reports, etc.)
STAT_SNAP_DT_TM DATETIME N Indicates the DATE time that the snapshot was taken.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - DM_STAT_SNAPS




Parent Column in DM_STAT_SNAPS (PK) Child Table Name Child Column Name
Children: DM_STAT_SNAP_ID DM_STAT_SNAPS_VALUES DM_STAT_SNAP_ID


DM_STAT_SNAPS_SQL



Column Section Top of Page


Table-level Detail

Description: Data Management Statistics Snapshot SQL
Definition: Stores the unique SQL entries flagged for a poor score or shareable memory through the MSA TOP SQL process, including their hash value and full SQL Text.
Table Type: ACTIVITY





Column Detail - DM_STAT_SNAPS_SQL


Column Name Type Null? Definition
CREATE_DT_TM DATETIME N Contains the date and time the row was created.
DM_STAT_SNAPS_SQL_ID DOUBLE N Uniquely identifies an SQL statement that has been flagged for a poor score or shareable memory through the MSA TOP SQL process, including their hash value and full SQL text.
SQL_IDENT DOUBLE N This value is generated based on the SQL text.
SQL_TEXT LONGTEXT Y The full SQL Text of this SQL entry.
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_STAT_SNAPS_VALUES



Column Section Relationship Section Top of Page


Table-level Detail

Description: Statistical Snapshot Values
Definition: Name value pair table for generically storing database statistics. This is an activity table.
Table Type: ACTIVITY





Column Detail - DM_STAT_SNAPS_VALUES


Column Name Type Null? Definition
DM_STAT_SNAP_ID DOUBLE N The snapshot id from the DM_STAT_SNAPS table.
STAT_CLOB_VAL LONGTEXT Y stat clob value
STAT_DATE_DT_TM DATETIME Y Used to store the statistic value if a date. STAT_TYPE will be set to 3 if this column is populated.
STAT_NAME VARCHAR(80) N Name of the statistic captured.
STAT_NUMBER_VAL DOUBLE Y Used to store the statistic value if a number. STAT_TYPE will be set to 1 if this column is populated.
STAT_SEQ DOUBLE N Used to indicate time periods if this parameter can have multiple values for a single date.
STAT_STR_VAL VARCHAR(255) Y Used to store the statistic value if a string. STAT_TYPE will be set to 2 if this column is populated.
STAT_TYPE DOUBLE N Used to indicate the data type for the statistic. A value of 1 indicates that the STAT_NUMBER_VAL is populated. 2 indicates that the STAT_STR_VAL is populated. 3 indicates that the STAT_DATE_DT_TM is populated.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - DM_STAT_SNAPS_VALUES


Child Column in DM_STAT_SNAPS_VALUES(FK) Parent Table Name Parent Column Name
Parents: DM_STAT_SNAP_ID DM_STAT_SNAPS DM_STAT_SNAP_ID