********************************************************************** * * RECOVERY MANAGER * VERSION 12.1 * December 2016 * ********************************************************************** -AUTH 001000 &DVAUTHP * * * * -SQL 004000 CREATE TABLE BMCARM.ARM_CRRDRPT ( MEMBER CHAR(8) , CRRDR_POINT TIMESTAMP NOT NULL, RBA VARCHAR(10) FOR BIT DATA, LRSN VARCHAR(10) FOR BIT DATA ) IN BMCARM.BMCARMCR * -SQL 004100 COMMENT ON BMCARM.ARM_CRRDRPT (MEMBER IS 'SSID OR DS MEMBER NAME', CRRDR_POINT IS 'TIMESTAMP OF COORDINATED RECOVERY POINT', RBA IS 'RBA OF COORDINATED RECOVERY POINT', LRSN IS 'LRSN OF COORDINATED RECOVERY POINT' ) * *--------------------------------------------------------------------- *- DEFINE RECOVERY MANAGER ESTIMATION TABLES *--------------------------------------------------------------------- * -SQL 004200 CREATE TABLE BMCARM.BMCRMD_UTIL_RUN (UTILITY_RUN_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY ,VERSION INTEGER NOT NULL ,SSID CHAR (004) NOT NULL ,DCTOKEN CHAR (008) NOT NULL ,START_TIMESTAMP TIMESTAMP ,END_TIMESTAMP TIMESTAMP ,RUN_TYPE CHAR (001) NOT NULL ,MIRRORING_USED CHAR (001) NOT NULL WITH DEFAULT ,NUM_TS_TO_SAVE SMALLINT NOT NULL ,TOLOGPOINT VARCHAR (010) FOR BIT DATA ,ELAP_SEC_EST INTEGER NOT NULL WITH DEFAULT ,AVG_TS_SEC INTEGER NOT NULL WITH DEFAULT ,AVG_TS_SEC_EST INTEGER NOT NULL WITH DEFAULT ,NUM_JOBS INTEGER NOT NULL WITH DEFAULT ,NUM_TS_RECOV INTEGER NOT NULL WITH DEFAULT ,NUM_IX_RECOV INTEGER NOT NULL WITH DEFAULT ,NUM_BYTES_RECOV DOUBLE NOT NULL WITH DEFAULT ) IN BMCARM.BMCESTUR * -SQL 004300 CREATE TABLE BMCARM.BMCRMD_JOB (JOB_ID INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY ,UTILITY_RUN_ID INTEGER NOT NULL ,JOBNAME CHAR (008) NOT NULL ,START_TIMESTAMP TIMESTAMP ,END_TIMESTAMP TIMESTAMP ,JOB_TYPE CHAR (001) NOT NULL ,DC_RET_CODE INTEGER NOT NULL WITH DEFAULT ,ELAP_SEC_EST INTEGER NOT NULL WITH DEFAULT ,NUM_TS_RECOV INTEGER NOT NULL WITH DEFAULT ,NUM_IX_RECOV INTEGER NOT NULL WITH DEFAULT ,NUM_BYTES_EST DOUBLE NOT NULL WITH DEFAULT ,NUM_BYTES_RECOV DOUBLE NOT NULL WITH DEFAULT ,TAF_EST REAL NOT NULL WITH DEFAULT ,DAF_EST REAL NOT NULL WITH DEFAULT ,LRF_EST REAL NOT NULL WITH DEFAULT ,MLT_EST SMALLINT NOT NULL WITH DEFAULT ,LSC_EST REAL NOT NULL WITH DEFAULT ,RF_EST REAL NOT NULL WITH DEFAULT ,SCT_EST REAL NOT NULL WITH DEFAULT ,OMF_EST REAL NOT NULL WITH DEFAULT ,SRF_EST REAL NOT NULL WITH DEFAULT ,CRF_EST REAL NOT NULL WITH DEFAULT ,ARF_EST REAL NOT NULL WITH DEFAULT ,SWF_EST REAL NOT NULL WITH DEFAULT ,CWF_EST REAL NOT NULL WITH DEFAULT ,AWF_EST REAL NOT NULL WITH DEFAULT ,KSC_EST REAL NOT NULL WITH DEFAULT ,BSWF_EST REAL NOT NULL WITH DEFAULT ,WWF_EST REAL NOT NULL WITH DEFAULT ,NUM_LOGS_RESTORED INTEGER NOT NULL WITH DEFAULT ,LOG_RECS_SORTED DOUBLE NOT NULL WITH DEFAULT ,LOG_RECS_PROCESSED DOUBLE NOT NULL WITH DEFAULT ,LOG_RECS_APPLIED DOUBLE NOT NULL WITH DEFAULT ,LOG_BYTES_SORTED DOUBLE NOT NULL WITH DEFAULT ,NUM_E35_LOG_WAITS DOUBLE NOT NULL WITH DEFAULT ,E35_WAIT_LOG_SEC REAL NOT NULL WITH DEFAULT ,MAX_E35_LOG_WAIT REAL NOT NULL WITH DEFAULT ,MAX_E35_KEY_WAIT REAL NOT NULL WITH DEFAULT ,SPI_BYTES_READ DOUBLE NOT NULL WITH DEFAULT ,SPI_ALLOC_SEC REAL NOT NULL WITH DEFAULT ,NUM_SPI_WAITS DOUBLE NOT NULL WITH DEFAULT ,SPI_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_SPI_WAIT REAL NOT NULL WITH DEFAULT ,FCI_BYTES_READ DOUBLE NOT NULL WITH DEFAULT ,FCI_ALLOC_SEC REAL NOT NULL WITH DEFAULT ,NUM_FCI_WAITS DOUBLE NOT NULL WITH DEFAULT ,FCI_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_FCI_WAIT REAL NOT NULL WITH DEFAULT ,ICI_BYTES_READ DOUBLE NOT NULL WITH DEFAULT ,ICI_ALLOC_SEC REAL NOT NULL WITH DEFAULT ,NUM_ICI_WAITS DOUBLE NOT NULL WITH DEFAULT ,ICI_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_ICI_WAIT REAL NOT NULL WITH DEFAULT ,CAI_BYTES_READ DOUBLE NOT NULL WITH DEFAULT ,CAI_ALLOC_SEC REAL NOT NULL WITH DEFAULT ,NUM_CAI_WAITS DOUBLE NOT NULL WITH DEFAULT ,CAI_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_CAI_WAIT REAL NOT NULL WITH DEFAULT ,SPO_BYTES_WRITTEN DOUBLE NOT NULL WITH DEFAULT ,SPO_SNAP_SEC REAL NOT NULL WITH DEFAULT ,SPO_ALLOC_SEC REAL NOT NULL WITH DEFAULT ,NUM_SPO_WAITS DOUBLE NOT NULL WITH DEFAULT ,SPO_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_SPO_WAIT REAL NOT NULL WITH DEFAULT ,FCO_BYTES_WRITTEN DOUBLE NOT NULL WITH DEFAULT ,FCO_ALLOC_SEC REAL NOT NULL WITH DEFAULT ,NUM_FCO_WAITS DOUBLE NOT NULL WITH DEFAULT ,FCO_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_FCO_WAIT REAL NOT NULL WITH DEFAULT ,CAO_BYTES_WRITTEN DOUBLE NOT NULL WITH DEFAULT ,CAO_ALLOC_SEC REAL NOT NULL WITH DEFAULT ,NUM_CAO_WAITS DOUBLE NOT NULL WITH DEFAULT ,CAO_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_CAO_WAIT REAL NOT NULL WITH DEFAULT ,NUM_KEY_BYTES DOUBLE NOT NULL WITH DEFAULT ,NUM_E15_KEY_WAITS DOUBLE NOT NULL WITH DEFAULT ,E15_WAIT_KEY_SEC REAL NOT NULL WITH DEFAULT ,MAX_E15_KEY_WAIT REAL NOT NULL WITH DEFAULT ,NUM_E35_KEY_WAITS DOUBLE NOT NULL WITH DEFAULT ,E35_WAIT_KEY_SEC REAL NOT NULL WITH DEFAULT ,INCOMPLETE_FLAG CHAR (001) NOT NULL WITH DEFAULT ,LSF_EST REAL NOT NULL WITH DEFAULT ,NBS_EST REAL NOT NULL WITH DEFAULT ,OOMF_EST REAL NOT NULL WITH DEFAULT ,ONBAF_EST REAL NOT NULL WITH DEFAULT ,ONBA_EST REAL NOT NULL WITH DEFAULT ,TC_EST REAL NOT NULL WITH DEFAULT ,RPK_EST REAL NOT NULL WITH DEFAULT ,ATR_EST REAL NOT NULL WITH DEFAULT ) IN BMCARM.BMCESTJB * -SQL 004400 CREATE TABLE BMCARM.BMCRMD_PHASE (JOB_ID INTEGER NOT NULL ,STEPNAME CHAR (008) NOT NULL ,PHASENO INTEGER NOT NULL ,UTILITY_RUN_ID INTEGER NOT NULL ,PHASE_TYPE CHAR (001) NOT NULL ,PHASE_RC INTEGER NOT NULL ,START_TIMESTAMP TIMESTAMP ,END_TIMESTAMP TIMESTAMP ,ELAP_SEC_EST INTEGER NOT NULL WITH DEFAULT ,CPU_SEC REAL NOT NULL ,WAIT_SEC REAL NOT NULL ,CAT_READ_SEC INTEGER NOT NULL WITH DEFAULT ,SYSCOPY_READ_SEC INTEGER NOT NULL WITH DEFAULT ,SYSTP_READ_SEC INTEGER NOT NULL WITH DEFAULT ,SYSIP_READ_SEC INTEGER NOT NULL WITH DEFAULT ,SYNC_SEC INTEGER NOT NULL WITH DEFAULT ,DDSCAN_SEC INTEGER NOT NULL WITH DEFAULT ,SYSLGRNX_READ_SEC INTEGER NOT NULL WITH DEFAULT ,PLANPHS_SEC INTEGER NOT NULL WITH DEFAULT ,PLANSHD_SEC INTEGER NOT NULL WITH DEFAULT ,LOG_ALLOC_SEC_TP REAL NOT NULL WITH DEFAULT ,LOG_ALLOC_SEC_DS REAL NOT NULL WITH DEFAULT ,LOG_FILES_READ_TP INTEGER NOT NULL WITH DEFAULT ,LOG_FILES_READ_DS INTEGER NOT NULL WITH DEFAULT ,LOG_RECS_READ DOUBLE NOT NULL WITH DEFAULT ,LOG_BYTES_READ DOUBLE NOT NULL WITH DEFAULT ,LOG_RECS_TO_SORT DOUBLE NOT NULL WITH DEFAULT ,LOG_BYTES_TO_SORT DOUBLE NOT NULL WITH DEFAULT ,E15_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_E15_WAIT REAL NOT NULL WITH DEFAULT ,NUM_DATASETS INTEGER NOT NULL WITH DEFAULT ) IN BMCARM.BMCESTPH * -SQL 004500 CREATE TABLE BMCARM.BMCRMD_TS (JOB_ID INTEGER NOT NULL ,DBNAME CHAR (008) NOT NULL ,TSNAME CHAR (008) NOT NULL ,UTILITY_RUN_ID INTEGER NOT NULL ,START_TIMESTAMP TIMESTAMP NOT NULL ,END_TIMESTAMP TIMESTAMP NOT NULL ,OPERATION CHAR (001) NOT NULL ,SUCCESS CHAR (001) NOT NULL ,TOTAL_ELAP_EST INTEGER NOT NULL WITH DEFAULT ,RUNSTATS_RUN CHAR (001) NOT NULL ) IN BMCARM.BMCESTTS * -SQL 004600 CREATE TABLE BMCARM.BMCRMD_TS_PART (JOB_ID INTEGER NOT NULL ,DBNAME CHAR (008) NOT NULL ,TSNAME CHAR (008) NOT NULL ,DSNUM SMALLINT NOT NULL ,START_TIMESTAMP TIMESTAMP ,END_TIMESTAMP TIMESTAMP ,OPERATION CHAR (001) NOT NULL ,NUM_BYTES_EST DOUBLE NOT NULL WITH DEFAULT ,ELAP_SEC_EST INTEGER NOT NULL WITH DEFAULT ,MERGE_ELAP_EST INTEGER NOT NULL WITH DEFAULT ,MERGE_ELAP_SEC INTEGER NOT NULL WITH DEFAULT ,SNAP_ELAP_EST INTEGER NOT NULL WITH DEFAULT ,SNAP_ELAP_SEC INTEGER NOT NULL WITH DEFAULT ,UNLOAD_ELAP_EST INTEGER NOT NULL WITH DEFAULT ,UNLOAD_ELAP_SEC INTEGER NOT NULL WITH DEFAULT ,RESTORE_ELAP_EST INTEGER NOT NULL WITH DEFAULT ,RESTORE_ELAP_SEC INTEGER NOT NULL WITH DEFAULT ,MERGE_CPU_SEC REAL NOT NULL WITH DEFAULT ,SNAP_CPU_SEC REAL NOT NULL WITH DEFAULT ,UNLOAD_CPU_SEC REAL NOT NULL WITH DEFAULT ,RESTORE_CPU_SEC REAL NOT NULL WITH DEFAULT ,OV_LOGRNG_START VARCHAR (010) FOR BIT DATA ,OV_LOGRNG_END VARCHAR (010) FOR BIT DATA ,OV_LOGRNG_BYTES DOUBLE NOT NULL WITH DEFAULT ,LOG_RECS_SORTED DOUBLE NOT NULL WITH DEFAULT ,LOG_RECS_PROCESSED DOUBLE NOT NULL WITH DEFAULT ,LOG_RECS_APPLIED DOUBLE NOT NULL WITH DEFAULT ,LOG_BYTES_SORTED DOUBLE NOT NULL WITH DEFAULT ,NUM_E35_LOG_WAITS DOUBLE NOT NULL WITH DEFAULT ,E35_WAIT_LOG_SEC REAL NOT NULL WITH DEFAULT ,MAX_E35_LOG_WAIT REAL NOT NULL WITH DEFAULT ,SPI_BYTES_READ DOUBLE NOT NULL WITH DEFAULT ,SPI_ALLOC_SEC REAL NOT NULL WITH DEFAULT ,NUM_SPI_WAITS DOUBLE NOT NULL WITH DEFAULT ,SPI_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_SPI_WAIT REAL NOT NULL WITH DEFAULT ,FCI_BYTES_READ DOUBLE NOT NULL WITH DEFAULT ,FCI_ALLOC_SEC REAL NOT NULL WITH DEFAULT ,NUM_FCI_WAITS DOUBLE NOT NULL WITH DEFAULT ,FCI_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_FCI_WAIT REAL NOT NULL WITH DEFAULT ,ICI_BYTES_READ DOUBLE NOT NULL WITH DEFAULT ,ICI_ALLOC_SEC REAL NOT NULL WITH DEFAULT ,NUM_ICI_WAITS DOUBLE NOT NULL WITH DEFAULT ,ICI_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_ICI_WAIT REAL NOT NULL WITH DEFAULT ,CAI_BYTES_READ DOUBLE NOT NULL WITH DEFAULT ,CAI_ALLOC_SEC REAL NOT NULL WITH DEFAULT ,NUM_CAI_WAITS DOUBLE NOT NULL WITH DEFAULT ,CAI_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_CAI_WAIT REAL NOT NULL WITH DEFAULT ,SPO_BYTES_WRITTEN DOUBLE NOT NULL WITH DEFAULT ,SPO_SNAP_SEC REAL NOT NULL WITH DEFAULT ,SPO_ALLOC_SEC REAL NOT NULL WITH DEFAULT ,NUM_SPO_WAITS DOUBLE NOT NULL WITH DEFAULT ,SPO_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_SPO_WAIT REAL NOT NULL WITH DEFAULT ,FCO_BYTES_WRITTEN DOUBLE NOT NULL WITH DEFAULT ,FCO_ALLOC_SEC REAL NOT NULL WITH DEFAULT ,NUM_FCO_WAITS DOUBLE NOT NULL WITH DEFAULT ,FCO_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_FCO_WAIT REAL NOT NULL WITH DEFAULT ,CAO_BYTES_WRITTEN DOUBLE NOT NULL WITH DEFAULT ,CAO_ALLOC_SEC REAL NOT NULL WITH DEFAULT ,NUM_CAO_WAITS DOUBLE NOT NULL WITH DEFAULT ,CAO_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_CAO_WAIT REAL NOT NULL WITH DEFAULT ) IN BMCARM.BMCESTTP * -SQL 004700 CREATE TABLE BMCARM.BMCRMD_KEYSORT (JOB_ID INTEGER NOT NULL ,DBNAME CHAR (008) NOT NULL ,TSNAME CHAR (008) NOT NULL ,SORTID INTEGER NOT NULL ,IXGROUP SMALLINT NOT NULL ,START_TIMESTAMP TIMESTAMP ,TERM_INPUT_TIME TIMESTAMP ,END_TIMESTAMP TIMESTAMP ,REL_START_EST INTEGER NOT NULL WITH DEFAULT ,ELAP_SEC_EST INTEGER NOT NULL WITH DEFAULT ,TOTAL_ELAP_EST INTEGER NOT NULL WITH DEFAULT ) IN BMCARM.BMCESTKY * -SQL 004800 CREATE TABLE BMCARM.BMCRMD_TSP_SORT (JOB_ID INTEGER NOT NULL ,DBNAME CHAR (008) NOT NULL ,TSNAME CHAR (008) NOT NULL ,DSNUM SMALLINT NOT NULL ,SORTID INTEGER NOT NULL ,E15_BYTES_WRITTEN DOUBLE NOT NULL WITH DEFAULT ,NUM_E15_WAITS DOUBLE NOT NULL WITH DEFAULT ,E15_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_E15_WAIT REAL NOT NULL WITH DEFAULT ) IN BMCARM.BMCESTTR * -SQL 004900 CREATE TABLE BMCARM.BMCRMD_IX_PART (JOB_ID INTEGER NOT NULL ,DBNAME CHAR (008) NOT NULL ,TSNAME CHAR (008) NOT NULL ,IXSPNAME CHAR (008) NOT NULL ,PART SMALLINT NOT NULL ,START_TIMESTAMP TIMESTAMP ,END_TIMESTAMP TIMESTAMP ,REL_START_EST INTEGER NOT NULL WITH DEFAULT ,OPERATION CHAR (001) NOT NULL ,SUCCESS CHAR (001) NOT NULL ,NUM_BYTES_EST DOUBLE NOT NULL WITH DEFAULT ,ELAP_SEC_EST INTEGER NOT NULL WITH DEFAULT ,BUILD_ELAP_EST INTEGER NOT NULL WITH DEFAULT ,BUILD_ELAP_SEC INTEGER NOT NULL WITH DEFAULT ,BUILD_CPU_SEC REAL NOT NULL WITH DEFAULT ,WRKEYS_ELAP_EST INTEGER NOT NULL WITH DEFAULT ,WRKEYS_ELAP_SEC INTEGER NOT NULL WITH DEFAULT ,WRKEYS_CPU_SEC REAL NOT NULL WITH DEFAULT ,MERGE_ELAP_EST INTEGER NOT NULL WITH DEFAULT ,MERGE_ELAP_SEC INTEGER NOT NULL WITH DEFAULT ,SNAP_ELAP_EST INTEGER NOT NULL WITH DEFAULT ,SNAP_ELAP_SEC INTEGER NOT NULL WITH DEFAULT ,MERGE_CPU_SEC REAL NOT NULL WITH DEFAULT ,SNAP_CPU_SEC REAL NOT NULL WITH DEFAULT ,OV_LOGRNG_START VARCHAR (010) FOR BIT DATA ,OV_LOGRNG_END VARCHAR (010) FOR BIT DATA ,OV_LOGRNG_BYTES DOUBLE NOT NULL WITH DEFAULT ,LOG_RECS_SORTED DOUBLE NOT NULL WITH DEFAULT ,LOG_RECS_PROCESSED DOUBLE NOT NULL WITH DEFAULT ,LOG_RECS_APPLIED DOUBLE NOT NULL WITH DEFAULT ,LOG_BYTES_SORTED DOUBLE NOT NULL WITH DEFAULT ,NUM_E35_LOG_WAITS DOUBLE NOT NULL WITH DEFAULT ,E35_WAIT_LOG_SEC REAL NOT NULL WITH DEFAULT ,MAX_E35_LOG_WAIT REAL NOT NULL WITH DEFAULT ,SPI_BYTES_READ DOUBLE NOT NULL WITH DEFAULT ,SPI_ALLOC_SEC REAL NOT NULL WITH DEFAULT ,NUM_SPI_WAITS DOUBLE NOT NULL WITH DEFAULT ,SPI_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_SPI_WAIT REAL NOT NULL WITH DEFAULT ,FCI_BYTES_READ DOUBLE NOT NULL WITH DEFAULT ,FCI_ALLOC_SEC REAL NOT NULL WITH DEFAULT ,NUM_FCI_WAITS DOUBLE NOT NULL WITH DEFAULT ,FCI_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_FCI_WAIT REAL NOT NULL WITH DEFAULT ,CAI_BYTES_READ DOUBLE NOT NULL WITH DEFAULT ,CAI_ALLOC_SEC REAL NOT NULL WITH DEFAULT ,NUM_CAI_WAITS DOUBLE NOT NULL WITH DEFAULT ,CAI_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_CAI_WAIT REAL NOT NULL WITH DEFAULT ,SPO_BYTES_WRITTEN DOUBLE NOT NULL WITH DEFAULT ,SPO_SNAP_SEC REAL NOT NULL WITH DEFAULT ,SPO_ALLOC_SEC REAL NOT NULL WITH DEFAULT ,NUM_SPO_WAITS DOUBLE NOT NULL WITH DEFAULT ,SPO_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_SPO_WAIT REAL NOT NULL WITH DEFAULT ,FCO_BYTES_WRITTEN DOUBLE NOT NULL WITH DEFAULT ,FCO_ALLOC_SEC REAL NOT NULL WITH DEFAULT ,NUM_FCO_WAITS DOUBLE NOT NULL WITH DEFAULT ,FCO_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_FCO_WAIT REAL NOT NULL WITH DEFAULT ,CAO_BYTES_WRITTEN DOUBLE NOT NULL WITH DEFAULT ,CAO_ALLOC_SEC REAL NOT NULL WITH DEFAULT ,NUM_CAO_WAITS DOUBLE NOT NULL WITH DEFAULT ,CAO_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_CAO_WAIT REAL NOT NULL WITH DEFAULT ) IN BMCARM.BMCESTIP * -SQL 005000 CREATE TABLE BMCARM.BMCRMD_IXP_SORT (JOB_ID INTEGER NOT NULL ,DBNAME CHAR (008) NOT NULL ,TSNAME CHAR (008) NOT NULL ,IXSPNAME CHAR (008) NOT NULL ,PART SMALLINT NOT NULL ,SORTID INTEGER NOT NULL ,E35_BYTES_WRITTEN DOUBLE NOT NULL WITH DEFAULT ,NUM_E35_WAITS DOUBLE NOT NULL WITH DEFAULT ,E35_WAIT_SEC REAL NOT NULL WITH DEFAULT ,MAX_E35_WAIT REAL NOT NULL WITH DEFAULT ) IN BMCARM.BMCESTIS * -SQL 005100 CREATE TABLE BMCARM.BMCRMD_JOB_RESTART (IDENTIFIER CHAR(45) NOT NULL ,JOBNAME CHAR(8) ,STEPNAME CHAR(8) ,STATUS CHAR(8) NOT NULL ,EVENT CHAR(8) ,OBJECTSET CHAR(27) ,UTILID CHAR(16) ,RC INTEGER ,START_TIME TIMESTAMP ,END_TIME TIMESTAMP ) IN BMCARM.BMCJOBRS VOLATILE -SQL 005200 CREATE TABLE BMCARM.BMCRMD_RECOVERY_EXCEPTIONS (RUN_TIME TIMESTAMP NOT NULL ,OSNAME VARCHAR(27) NOT NULL ,RECOVERY_POINT VARCHAR(60) NOT NULL ,LOGMARK_NAME VARCHAR(40) ,REC_POINT_VERSION CHAR(8) ,BACKOUT CHAR(4) NOT NULL ,EXCEPTION_TITLE VARCHAR(70) NOT NULL ,OBJ_TYPE CHAR(1) ,OBJ_QUAL1 VARCHAR(128) ,OBJ_QUAL2 VARCHAR(128) ,INSTANCE CHAR(1) ,PARTITION CHAR(4) ,RESOURCE VARCHAR(80) ,DSNUM CHAR(4) ,DATE CHAR(8) ,TIME CHAR(8) ,VOLSER CHAR(6) ,DSNAME VARCHAR(44) ) IN BMCARM.BMCRECEX * *--------------------------------------------------------------------- *- ALTER BMCARM.ARM_CRRDRPT FOR V11 *--------------------------------------------------------------------- * -SQL 005210 ALTER TABLE BMCARM.ARM_CRRDRPT ALTER COLUMN RBA SET DATA TYPE VARCHAR(10) -SQL 005220 ALTER TABLE BMCARM.ARM_CRRDRPT ALTER COLUMN LRSN SET DATA TYPE VARCHAR(10) * *--------------------------------------------------------------------- *- ALTER BMCARM.BMCRMD_UTIL_RUN FOR V11 *--------------------------------------------------------------------- * -SQL 005230 ALTER TABLE BMCARM.BMCRMD_UTIL_RUN ALTER COLUMN TOLOGPOINT SET DATA TYPE VARCHAR(10) * *--------------------------------------------------------------------- *- ALTER BMCARM.BMCRMD_IX_PART FOR V11 *--------------------------------------------------------------------- * -SQL 005240 ALTER TABLE BMCARM.BMCRMD_IX_PART ALTER COLUMN OV_LOGRNG_START SET DATA TYPE VARCHAR(10) -SQL 005250 ALTER TABLE BMCARM.BMCRMD_IX_PART ALTER COLUMN OV_LOGRNG_END SET DATA TYPE VARCHAR(10) * *--------------------------------------------------------------------- *- ALTER BMCARM.BMCRMD_TS_PART FOR V11 *--------------------------------------------------------------------- * -SQL 005260 ALTER TABLE BMCARM.BMCRMD_TS_PART ALTER COLUMN OV_LOGRNG_START SET DATA TYPE VARCHAR(10) -SQL 005270 ALTER TABLE BMCARM.BMCRMD_TS_PART ALTER COLUMN OV_LOGRNG_END SET DATA TYPE VARCHAR(10) *