(*) Previous setup has not been detected. Creating the users... (*) Creating users ... (*) Creating instance ... DB2 installation is being initialized. Total number of tasks to be performed: 4 Total estimated time for all tasks to be performed: 309 second(s) Task #1 start Description: Setting default global profile registry variables Estimated time 1 second(s) Task #1 end Task #2 start Description: Initializing instance list Estimated time 5 second(s) Task #2 end Task #3 start Description: Configuring DB2 instances Estimated time 300 second(s) Task #3 end Task #4 start Description: Updating global profile registry Estimated time 3 second(s) Task #4 end The execution completed successfully. For more information see the DB2 installation log at "/tmp/db2icrt.log.72". DBI1446I The db2icrt command is running. DBI1070I Program db2icrt completed successfully. 03/02/2022 09:34:17 0 0 SQL1032N No start database manager command was issued. SQL1032N No start database manager command was issued. SQLSTATE=57019 (*) Cataloging existing databases (*) Applying Db2 license ... LIC1402I License added successfully. LIC1426I This product is now licensed for use as outlined in your License Agreement. USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF THE TERMS OF THE IBM LICENSE AGREEMENT, LOCATED IN THE FOLLOWING DIRECTORY: "/opt/ibm/db2/V11.5/license/en_US.iso88591" (*) Saving the checksum of the current nodelock file ... (*) Updating DBM CFG parameters ... DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed successfully. DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed successfully. DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed successfully. No Cgroup memory limit detected, instance memory will follow automatic tuning (*) Remounting /database with suid... (*) Nothing appears in the Db2 directory. will skip update/upgrade. (*) Code level is the same. No update/upgrade needed. DB2 State : Operable DB2 has not been started Starting DB2... 03/02/2022 09:34:29 0 0 SQL1063N DB2START processing was successful. SQL1063N DB2START processing was successful. (*) User chose to create testdb database (*) Creating database testdb ... DB20000I The CREATE DATABASE command completed successfully. DB20000I The ACTIVATE DATABASE command completed successfully. 03/02/2022 09:35:13 0 0 SQL1026N The database manager is already active. SQL1026N The database manager is already active. ### Enabling LOGARCHMETH1 Database Connection Information Database server = DB2/LINUXX8664 11.5.4.0 SQL authorization ID = DB2INST1 Local database alias = TESTDB DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully. SQL1363W One or more of the parameters submitted for immediate modification were not changed dynamically. For these configuration parameters, the database must be shutdown and reactivated before the configuration parameter changes become effective. ### Restarting DB2 03/02/2022 09:35:19 0 0 SQL1064N DB2STOP processing was successful. SQL1064N DB2STOP processing was successful. 03/02/2022 09:35:20 0 0 SQL1063N DB2START processing was successful. SQL1063N DB2START processing was successful. ### Making backup directory and performing backup Backup successful. The timestamp for this backup image is : 20220302093523 (*) Applying autoconfiguration for instance ... Database Connection Information Database server = DB2/LINUXX8664 11.5.4.0 SQL authorization ID = DB2INST1 Local database alias = TESTDB DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully. DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully. SQL1363W One or more of the parameters submitted for immediate modification were not changed dynamically. For these configuration parameters, the database must be shutdown and reactivated before the configuration parameter changes become effective. DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully. DB20000I The SQL command completed successfully. 03/02/2022 09:35:26 0 0 SQL1064N DB2STOP processing was successful. SQL1064N DB2STOP processing was successful. 03/02/2022 09:35:28 0 0 SQL1063N DB2START processing was successful. SQL1063N DB2START processing was successful. (*) Skipping TEXT_SEARCH setup for database testdb because TEXT_SEARCH is not configured for the instance ... ssh-keygen: generating new host keys: RSA1 RSA DSA ECDSA ED25519 (*) All databases are now active. (*) Setup has completed. (*) Running user-provided scripts ... (*) Running cdcsetup.sh ... waiting for db2inst1 exists . uid=1000(db2inst1) gid=1000(db2iadm1) groups=1000(db2iadm1) . Compile ASN tool ... Waiting for DB2 start ( testdb ) . Database Connection Information Database server = DB2/LINUXX8664 11.5.4.0 SQL authorization ID = DB2INST1 Local database alias = TESTDB . LINE MESSAGES FOR db2schema.bnd ------ -------------------------------------------------------------------- SQL0061W The binder is in progress. SQL0091N Binding was ended with "0" errors and "0" warnings. Backup successful. The timestamp for this backup image is : 20220302093551 DB20000I The RESTART DATABASE command completed successfully. Database Connection Information Database server = DB2/LINUXX8664 11.5.4.0 SQL authorization ID = DB2INST1 Local database alias = TESTDB DROP SPECIFIC FUNCTION ASNCDC.asncdcservice DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0204N "ASNCDC.ASNCDCSERVICE" is an undefined name. SQLSTATE=42704 CREATE FUNCTION ASNCDC.ASNCDCSERVICES(command VARCHAR(6), service VARCHAR(8)) RETURNS CLOB(100K) SPECIFIC asncdcservice EXTERNAL NAME 'asncdc!asncdcservice' LANGUAGE C PARAMETER STYLE SQL DBINFO DETERMINISTIC NOT FENCED RETURNS NULL ON NULL INPUT NO SQL NO EXTERNAL ACTION NO SCRATCHPAD ALLOW PARALLEL NO FINAL CALL DB20000I The SQL command completed successfully. CREATE TABLE ASNCDC.IBMQREP_COLVERSION( LSN VARCHAR( 16) FOR BIT DATA NOT NULL, TABLEID1 SMALLINT NOT NULL, TABLEID2 SMALLINT NOT NULL, POSITION SMALLINT NOT NULL, NAME VARCHAR(128) NOT NULL, TYPE SMALLINT NOT NULL, LENGTH INTEGER NOT NULL, NULLS CHAR( 1) NOT NULL, DEFAULT VARCHAR(1536), CODEPAGE INTEGER, SCALE INTEGER, VERSION_TIME TIMESTAMP NOT NULL WITH DEFAULT ) ORGANIZE BY ROW DB20000I The SQL command completed successfully. CREATE UNIQUE INDEX ASNCDC.IBMQREP_COLVERSIOX ON ASNCDC.IBMQREP_COLVERSION( LSN ASC, TABLEID1 ASC, TABLEID2 ASC, POSITION ASC) DB20000I The SQL command completed successfully. CREATE INDEX ASNCDC.IX2COLVERSION ON ASNCDC.IBMQREP_COLVERSION( TABLEID1 ASC, TABLEID2 ASC) DB20000I The SQL command completed successfully. CREATE TABLE ASNCDC.IBMQREP_TABVERSION( LSN VARCHAR( 16) FOR BIT DATA NOT NULL, TABLEID1 SMALLINT NOT NULL, TABLEID2 SMALLINT NOT NULL, VERSION INTEGER NOT NULL, SOURCE_OWNER VARCHAR(128) NOT NULL, SOURCE_NAME VARCHAR(128) NOT NULL, VERSION_TIME TIMESTAMP NOT NULL WITH DEFAULT ) ORGANIZE BY ROW DB20000I The SQL command completed successfully. CREATE UNIQUE INDEX ASNCDC.IBMQREP_TABVERSIOX ON ASNCDC.IBMQREP_TABVERSION( LSN ASC, TABLEID1 ASC, TABLEID2 ASC, VERSION ASC) DB20000I The SQL command completed successfully. CREATE INDEX ASNCDC.IX2TABVERSION ON ASNCDC.IBMQREP_TABVERSION( TABLEID1 ASC, TABLEID2 ASC) DB20000I The SQL command completed successfully. CREATE INDEX ASNCDC.IX3TABVERSION ON ASNCDC.IBMQREP_TABVERSION( SOURCE_OWNER ASC, SOURCE_NAME ASC) DB20000I The SQL command completed successfully. CREATE TABLE ASNCDC.IBMSNAP_APPLEVEL( ARCH_LEVEL CHAR( 4) NOT NULL WITH DEFAULT '1021') ORGANIZE BY ROW DB20000I The SQL command completed successfully. INSERT INTO ASNCDC.IBMSNAP_APPLEVEL(ARCH_LEVEL) VALUES ( '1021') Number of rows affected : 1 DB20000I The SQL command completed successfully. CREATE TABLE ASNCDC.IBMSNAP_CAPMON( MONITOR_TIME TIMESTAMP NOT NULL, RESTART_TIME TIMESTAMP NOT NULL, CURRENT_MEMORY INT NOT NULL, CD_ROWS_INSERTED INT NOT NULL, RECAP_ROWS_SKIPPED INT NOT NULL, TRIGR_ROWS_SKIPPED INT NOT NULL, CHG_ROWS_SKIPPED INT NOT NULL, TRANS_PROCESSED INT NOT NULL, TRANS_SPILLED INT NOT NULL, MAX_TRANS_SIZE INT NOT NULL, LOCKING_RETRIES INT NOT NULL, JRN_LIB CHAR( 10), JRN_NAME CHAR( 10), LOGREADLIMIT INT NOT NULL, CAPTURE_IDLE INT NOT NULL, SYNCHTIME TIMESTAMP NOT NULL, CURRENT_LOG_TIME TIMESTAMP NOT NULL WITH DEFAULT , LAST_EOL_TIME TIMESTAMP, RESTART_SEQ VARCHAR( 16) FOR BIT DATA NOT NULL WITH DEFAULT , CURRENT_SEQ VARCHAR( 16) FOR BIT DATA NOT NULL WITH DEFAULT , RESTART_MAXCMTSEQ VARCHAR( 16) FOR BIT DATA NOT NULL WITH DEFAULT , LOGREAD_API_TIME INT, NUM_LOGREAD_CALLS INT, NUM_END_OF_LOGS INT, LOGRDR_SLEEPTIME INT, NUM_LOGREAD_F_CALLS INT, TRANS_QUEUED INT, NUM_WARNTXS INT, NUM_WARNLOGAPI INT) ORGANIZE BY ROW DB20000I The SQL command completed successfully. CREATE UNIQUE INDEX ASNCDC.IBMSNAP_CAPMONX ON ASNCDC.IBMSNAP_CAPMON( MONITOR_TIME ASC) DB20000I The SQL command completed successfully. ALTER TABLE ASNCDC.IBMSNAP_CAPMON VOLATILE CARDINALITY DB20000I The SQL command completed successfully. CREATE TABLE ASNCDC.IBMSNAP_CAPPARMS( RETENTION_LIMIT INT, LAG_LIMIT INT, COMMIT_INTERVAL INT, PRUNE_INTERVAL INT, TRACE_LIMIT INT, MONITOR_LIMIT INT, MONITOR_INTERVAL INT, MEMORY_LIMIT SMALLINT, REMOTE_SRC_SERVER CHAR( 18), AUTOPRUNE CHAR( 1), TERM CHAR( 1), AUTOSTOP CHAR( 1), LOGREUSE CHAR( 1), LOGSTDOUT CHAR( 1), SLEEP_INTERVAL SMALLINT, CAPTURE_PATH VARCHAR(1040), STARTMODE VARCHAR( 10), LOGRDBUFSZ INT NOT NULL WITH DEFAULT 256, ARCH_LEVEL CHAR( 4) NOT NULL WITH DEFAULT '1021', COMPATIBILITY CHAR( 4) NOT NULL WITH DEFAULT '1021') ORGANIZE BY ROW DB20000I The SQL command completed successfully. INSERT INTO ASNCDC.IBMSNAP_CAPPARMS( RETENTION_LIMIT, LAG_LIMIT, COMMIT_INTERVAL, PRUNE_INTERVAL, TRACE_LIMIT, MONITOR_LIMIT, MONITOR_INTERVAL, MEMORY_LIMIT, SLEEP_INTERVAL, AUTOPRUNE, TERM, AUTOSTOP, LOGREUSE, LOGSTDOUT, CAPTURE_PATH, STARTMODE, COMPATIBILITY) VALUES ( 10080, 10080, 30, 300, 10080, 10080, 300, 32, 5, 'Y', 'Y', 'N', 'N', 'N', NULL, 'WARMSI', '1021' ) Number of rows affected : 1 DB20000I The SQL command completed successfully. CREATE TABLE ASNCDC.IBMSNAP_CAPSCHEMAS ( CAP_SCHEMA_NAME VARCHAR(128 OCTETS) NOT NULL ) ORGANIZE BY ROW DB20000I The SQL command completed successfully. CREATE UNIQUE INDEX ASNCDC.IBMSNAP_CAPSCHEMASX ON ASNCDC.IBMSNAP_CAPSCHEMAS (CAP_SCHEMA_NAME ASC) DB20000I The SQL command completed successfully. INSERT INTO ASNCDC.IBMSNAP_CAPSCHEMAS(CAP_SCHEMA_NAME) VALUES ( 'ASNCDC') Number of rows affected : 1 DB20000I The SQL command completed successfully. CREATE TABLE ASNCDC.IBMSNAP_CAPTRACE( OPERATION CHAR( 8) NOT NULL, TRACE_TIME TIMESTAMP NOT NULL, DESCRIPTION VARCHAR(1024) NOT NULL) ORGANIZE BY ROW DB20000I The SQL command completed successfully. CREATE INDEX ASNCDC.IBMSNAP_CAPTRACEX ON ASNCDC.IBMSNAP_CAPTRACE( TRACE_TIME ASC) DB20000I The SQL command completed successfully. ALTER TABLE ASNCDC.IBMSNAP_CAPTRACE VOLATILE CARDINALITY DB20000I The SQL command completed successfully. CREATE TABLE ASNCDC.IBMSNAP_PRUNCNTL( TARGET_SERVER CHAR(18) NOT NULL, TARGET_OWNER VARCHAR(128) NOT NULL, TARGET_TABLE VARCHAR(128) NOT NULL, SYNCHTIME TIMESTAMP, SYNCHPOINT VARCHAR( 16) FOR BIT DATA, SOURCE_OWNER VARCHAR(128) NOT NULL, SOURCE_TABLE VARCHAR(128) NOT NULL, SOURCE_VIEW_QUAL SMALLINT NOT NULL, APPLY_QUAL CHAR( 18) NOT NULL, SET_NAME CHAR( 18) NOT NULL, CNTL_SERVER CHAR( 18) NOT NULL, TARGET_STRUCTURE SMALLINT NOT NULL, CNTL_ALIAS CHAR( 8), PHYS_CHANGE_OWNER VARCHAR(128), PHYS_CHANGE_TABLE VARCHAR(128), MAP_ID VARCHAR(10) NOT NULL) ORGANIZE BY ROW DB20000I The SQL command completed successfully. CREATE UNIQUE INDEX ASNCDC.IBMSNAP_PRUNCNTLX ON ASNCDC.IBMSNAP_PRUNCNTL( SOURCE_OWNER ASC, SOURCE_TABLE ASC, SOURCE_VIEW_QUAL ASC, APPLY_QUAL ASC, SET_NAME ASC, TARGET_SERVER ASC, TARGET_TABLE ASC, TARGET_OWNER ASC) DB20000I The SQL command completed successfully. CREATE UNIQUE INDEX ASNCDC.IBMSNAP_PRUNCNTLX1 ON ASNCDC.IBMSNAP_PRUNCNTL( MAP_ID ASC) DB20000I The SQL command completed successfully. CREATE INDEX ASNCDC.IBMSNAP_PRUNCNTLX2 ON ASNCDC.IBMSNAP_PRUNCNTL( PHYS_CHANGE_OWNER ASC, PHYS_CHANGE_TABLE ASC) DB20000I The SQL command completed successfully. CREATE INDEX ASNCDC.IBMSNAP_PRUNCNTLX3 ON ASNCDC.IBMSNAP_PRUNCNTL( APPLY_QUAL ASC, SET_NAME ASC, TARGET_SERVER ASC) DB20000I The SQL command completed successfully. ALTER TABLE ASNCDC.IBMSNAP_PRUNCNTL VOLATILE CARDINALITY DB20000I The SQL command completed successfully. CREATE TABLE ASNCDC.IBMSNAP_PRUNE_LOCK( DUMMY CHAR( 1)) ORGANIZE BY ROW DB20000I The SQL command completed successfully. CREATE TABLE ASNCDC.IBMSNAP_PRUNE_SET( TARGET_SERVER CHAR( 18) NOT NULL, APPLY_QUAL CHAR( 18) NOT NULL, SET_NAME CHAR( 18) NOT NULL, SYNCHTIME TIMESTAMP, SYNCHPOINT VARCHAR( 16) FOR BIT DATA NOT NULL) ORGANIZE BY ROW DB20000I The SQL command completed successfully. CREATE UNIQUE INDEX ASNCDC.IBMSNAP_PRUNE_SETX ON ASNCDC.IBMSNAP_PRUNE_SET( TARGET_SERVER ASC, APPLY_QUAL ASC, SET_NAME ASC) DB20000I The SQL command completed successfully. ALTER TABLE ASNCDC.IBMSNAP_PRUNE_SET VOLATILE CARDINALITY DB20000I The SQL command completed successfully. CREATE TABLE ASNCDC.IBMSNAP_REGISTER( SOURCE_OWNER VARCHAR(128) NOT NULL, SOURCE_TABLE VARCHAR(128) NOT NULL, SOURCE_VIEW_QUAL SMALLINT NOT NULL, GLOBAL_RECORD CHAR( 1) NOT NULL, SOURCE_STRUCTURE SMALLINT NOT NULL, SOURCE_CONDENSED CHAR( 1) NOT NULL, SOURCE_COMPLETE CHAR( 1) NOT NULL, CD_OWNER VARCHAR(128), CD_TABLE VARCHAR(128), PHYS_CHANGE_OWNER VARCHAR(128), PHYS_CHANGE_TABLE VARCHAR(128), CD_OLD_SYNCHPOINT VARCHAR( 16) FOR BIT DATA, CD_NEW_SYNCHPOINT VARCHAR( 16) FOR BIT DATA, DISABLE_REFRESH SMALLINT NOT NULL, CCD_OWNER VARCHAR(128), CCD_TABLE VARCHAR(128), CCD_OLD_SYNCHPOINT VARCHAR( 16) FOR BIT DATA, SYNCHPOINT VARCHAR( 16) FOR BIT DATA, SYNCHTIME TIMESTAMP, CCD_CONDENSED CHAR( 1), CCD_COMPLETE CHAR( 1), ARCH_LEVEL CHAR( 4) NOT NULL, DESCRIPTION CHAR(254), BEFORE_IMG_PREFIX VARCHAR( 4), CONFLICT_LEVEL CHAR( 1), CHG_UPD_TO_DEL_INS CHAR( 1), CHGONLY CHAR( 1), RECAPTURE CHAR( 1), OPTION_FLAGS CHAR( 4) NOT NULL, STOP_ON_ERROR CHAR( 1) WITH DEFAULT 'Y', STATE CHAR( 1) WITH DEFAULT 'I', STATE_INFO CHAR( 8)) ORGANIZE BY ROW DB20000I The SQL command completed successfully. CREATE UNIQUE INDEX ASNCDC.IBMSNAP_REGISTERX ON ASNCDC.IBMSNAP_REGISTER( SOURCE_OWNER ASC, SOURCE_TABLE ASC, SOURCE_VIEW_QUAL ASC) DB20000I The SQL command completed successfully. CREATE INDEX ASNCDC.IBMSNAP_REGISTERX1 ON ASNCDC.IBMSNAP_REGISTER( PHYS_CHANGE_OWNER ASC, PHYS_CHANGE_TABLE ASC) DB20000I The SQL command completed successfully. CREATE INDEX ASNCDC.IBMSNAP_REGISTERX2 ON ASNCDC.IBMSNAP_REGISTER( GLOBAL_RECORD ASC) DB20000I The SQL command completed successfully. ALTER TABLE ASNCDC.IBMSNAP_REGISTER VOLATILE CARDINALITY DB20000I The SQL command completed successfully. CREATE TABLE ASNCDC.IBMSNAP_RESTART( MAX_COMMITSEQ VARCHAR( 16) FOR BIT DATA NOT NULL, MAX_COMMIT_TIME TIMESTAMP NOT NULL, MIN_INFLIGHTSEQ VARCHAR( 16) FOR BIT DATA NOT NULL, CURR_COMMIT_TIME TIMESTAMP NOT NULL, CAPTURE_FIRST_SEQ VARCHAR( 16) FOR BIT DATA NOT NULL) ORGANIZE BY ROW DB20000I The SQL command completed successfully. CREATE TABLE ASNCDC.IBMSNAP_SIGNAL( SIGNAL_TIME TIMESTAMP NOT NULL WITH DEFAULT , SIGNAL_TYPE VARCHAR( 30) NOT NULL, SIGNAL_SUBTYPE VARCHAR( 30), SIGNAL_INPUT_IN VARCHAR(500), SIGNAL_STATE CHAR( 1) NOT NULL, SIGNAL_LSN VARCHAR( 16) FOR BIT DATA) DATA CAPTURE CHANGES ORGANIZE BY ROW DB20000I The SQL command completed successfully. CREATE INDEX ASNCDC.IBMSNAP_SIGNALX ON ASNCDC.IBMSNAP_SIGNAL( SIGNAL_TIME ASC) DB20000I The SQL command completed successfully. ALTER TABLE ASNCDC.IBMSNAP_SIGNAL VOLATILE CARDINALITY DB20000I The SQL command completed successfully. CREATE TABLE ASNCDC.IBMSNAP_SUBS_COLS( APPLY_QUAL CHAR( 18) NOT NULL, SET_NAME CHAR( 18) NOT NULL, WHOS_ON_FIRST CHAR( 1) NOT NULL, TARGET_OWNER VARCHAR(128) NOT NULL, TARGET_TABLE VARCHAR(128) NOT NULL, COL_TYPE CHAR( 1) NOT NULL, TARGET_NAME VARCHAR(128) NOT NULL, IS_KEY CHAR( 1) NOT NULL, COLNO SMALLINT NOT NULL, EXPRESSION VARCHAR(1024) NOT NULL) ORGANIZE BY ROW DB20000I The SQL command completed successfully. CREATE UNIQUE INDEX ASNCDC.IBMSNAP_SUBS_COLSX ON ASNCDC.IBMSNAP_SUBS_COLS( APPLY_QUAL ASC, SET_NAME ASC, WHOS_ON_FIRST ASC, TARGET_OWNER ASC, TARGET_TABLE ASC, TARGET_NAME ASC) DB20000I The SQL command completed successfully. ALTER TABLE ASNCDC.IBMSNAP_SUBS_COLS VOLATILE CARDINALITY DB20000I The SQL command completed successfully. CREATE TABLE ASNCDC.IBMSNAP_SUBS_MEMBR( APPLY_QUAL CHAR( 18) NOT NULL, SET_NAME CHAR( 18) NOT NULL, WHOS_ON_FIRST CHAR( 1) NOT NULL, SOURCE_OWNER VARCHAR(128) NOT NULL, SOURCE_TABLE VARCHAR(128) NOT NULL, SOURCE_VIEW_QUAL SMALLINT NOT NULL, TARGET_OWNER VARCHAR(128) NOT NULL, TARGET_TABLE VARCHAR(128) NOT NULL, TARGET_CONDENSED CHAR( 1) NOT NULL, TARGET_COMPLETE CHAR( 1) NOT NULL, TARGET_STRUCTURE SMALLINT NOT NULL, PREDICATES VARCHAR(1024), MEMBER_STATE CHAR( 1), TARGET_KEY_CHG CHAR( 1) NOT NULL, UOW_CD_PREDICATES VARCHAR(1024), JOIN_UOW_CD CHAR( 1), LOADX_TYPE SMALLINT, LOADX_SRC_N_OWNER VARCHAR( 128), LOADX_SRC_N_TABLE VARCHAR(128)) ORGANIZE BY ROW DB20000I The SQL command completed successfully. CREATE UNIQUE INDEX ASNCDC.IBMSNAP_SUBS_MEMBRX ON ASNCDC.IBMSNAP_SUBS_MEMBR( APPLY_QUAL ASC, SET_NAME ASC, WHOS_ON_FIRST ASC, SOURCE_OWNER ASC, SOURCE_TABLE ASC, SOURCE_VIEW_QUAL ASC, TARGET_OWNER ASC, TARGET_TABLE ASC) DB20000I The SQL command completed successfully. ALTER TABLE ASNCDC.IBMSNAP_SUBS_MEMBR VOLATILE CARDINALITY DB20000I The SQL command completed successfully. CREATE TABLE ASNCDC.IBMSNAP_SUBS_SET( APPLY_QUAL CHAR( 18) NOT NULL, SET_NAME CHAR( 18) NOT NULL, SET_TYPE CHAR( 1) NOT NULL, WHOS_ON_FIRST CHAR( 1) NOT NULL, ACTIVATE SMALLINT NOT NULL, SOURCE_SERVER CHAR( 18) NOT NULL, SOURCE_ALIAS CHAR( 8), TARGET_SERVER CHAR( 18) NOT NULL, TARGET_ALIAS CHAR( 8), STATUS SMALLINT NOT NULL, LASTRUN TIMESTAMP NOT NULL, REFRESH_TYPE CHAR( 1) NOT NULL, SLEEP_MINUTES INT, EVENT_NAME CHAR( 18), LASTSUCCESS TIMESTAMP, SYNCHPOINT VARCHAR( 16) FOR BIT DATA, SYNCHTIME TIMESTAMP, CAPTURE_SCHEMA VARCHAR(128) NOT NULL, TGT_CAPTURE_SCHEMA VARCHAR(128), FEDERATED_SRC_SRVR VARCHAR( 18), FEDERATED_TGT_SRVR VARCHAR( 18), JRN_LIB CHAR( 10), JRN_NAME CHAR( 10), OPTION_FLAGS CHAR( 4) NOT NULL, COMMIT_COUNT SMALLINT, MAX_SYNCH_MINUTES SMALLINT, AUX_STMTS SMALLINT NOT NULL, ARCH_LEVEL CHAR( 4) NOT NULL) ORGANIZE BY ROW DB20000I The SQL command completed successfully. CREATE UNIQUE INDEX ASNCDC.IBMSNAP_SUBS_SETX ON ASNCDC.IBMSNAP_SUBS_SET( APPLY_QUAL ASC, SET_NAME ASC, WHOS_ON_FIRST ASC) DB20000I The SQL command completed successfully. ALTER TABLE ASNCDC.IBMSNAP_SUBS_SET VOLATILE CARDINALITY DB20000I The SQL command completed successfully. CREATE TABLE ASNCDC.IBMSNAP_SUBS_STMTS( APPLY_QUAL CHAR( 18) NOT NULL, SET_NAME CHAR( 18) NOT NULL, WHOS_ON_FIRST CHAR( 1) NOT NULL, BEFORE_OR_AFTER CHAR( 1) NOT NULL, STMT_NUMBER SMALLINT NOT NULL, EI_OR_CALL CHAR( 1) NOT NULL, SQL_STMT VARCHAR(1024), ACCEPT_SQLSTATES VARCHAR( 50)) ORGANIZE BY ROW DB20000I The SQL command completed successfully. CREATE UNIQUE INDEX ASNCDC.IBMSNAP_SUBS_STMTSX ON ASNCDC.IBMSNAP_SUBS_STMTS( APPLY_QUAL ASC, SET_NAME ASC, WHOS_ON_FIRST ASC, BEFORE_OR_AFTER ASC, STMT_NUMBER ASC) DB20000I The SQL command completed successfully. ALTER TABLE ASNCDC.IBMSNAP_SUBS_STMTS VOLATILE CARDINALITY DB20000I The SQL command completed successfully. CREATE TABLE ASNCDC.IBMSNAP_UOW( IBMSNAP_UOWID CHAR( 10) FOR BIT DATA NOT NULL, IBMSNAP_COMMITSEQ VARCHAR( 16) FOR BIT DATA NOT NULL, IBMSNAP_LOGMARKER TIMESTAMP NOT NULL, IBMSNAP_AUTHTKN VARCHAR(30) NOT NULL, IBMSNAP_AUTHID VARCHAR(128) NOT NULL, IBMSNAP_REJ_CODE CHAR( 1) NOT NULL WITH DEFAULT , IBMSNAP_APPLY_QUAL CHAR( 18) NOT NULL WITH DEFAULT ) ORGANIZE BY ROW DB20000I The SQL command completed successfully. CREATE UNIQUE INDEX ASNCDC.IBMSNAP_UOWX ON ASNCDC.IBMSNAP_UOW( IBMSNAP_COMMITSEQ ASC, IBMSNAP_LOGMARKER ASC) DB20000I The SQL command completed successfully. ALTER TABLE ASNCDC.IBMSNAP_UOW VOLATILE CARDINALITY DB20000I The SQL command completed successfully. CREATE TABLE ASNCDC.IBMSNAP_CAPENQ ( LOCK_NAME CHAR(9 OCTETS) ) ORGANIZE BY ROW DATA CAPTURE NONE COMPRESS NO DB20000I The SQL command completed successfully. CREATE OR REPLACE PROCEDURE ASNCDC.REMOVETABLE( in tableschema VARCHAR(128), in tablename VARCHAR(128) ) LANGUAGE SQL P1: BEGIN DECLARE stmtSQL VARCHAR(2048); DECLARE SQLCODE INT; DECLARE SQLSTATE CHAR(5); DECLARE RC_SQLCODE INT DEFAULT 0; DECLARE RC_SQLSTATE CHAR(5) DEFAULT '00000'; DECLARE CONTINUE HANDLER FOR SQLEXCEPTION, SQLWARNING, NOT FOUND VALUES (SQLCODE, SQLSTATE) INTO RC_SQLCODE, RC_SQLSTATE; -- delete ASN.IBMSNAP_PRUNCTL entries / source SET stmtSQL = 'DELETE FROM ASNCDC.IBMSNAP_PRUNCNTL WHERE SOURCE_OWNER=''' || tableschema || ''' AND SOURCE_TABLE=''' || tablename || ''''; EXECUTE IMMEDIATE stmtSQL; -- delete ASN.IBMSNAP_Register entries / source SET stmtSQL = 'DELETE FROM ASNCDC.IBMSNAP_REGISTER WHERE SOURCE_OWNER=''' || tableschema || ''' AND SOURCE_TABLE=''' || tablename || ''''; EXECUTE IMMEDIATE stmtSQL; -- drop CD Table / source SET stmtSQL = 'DROP TABLE ASNCDC.CDC_' || tableschema || '_' || tablename ; EXECUTE IMMEDIATE stmtSQL; -- delete ASN.IBMSNAP_SUBS_COLS entries /target SET stmtSQL = 'DELETE FROM ASNCDC.IBMSNAP_SUBS_COLS WHERE TARGET_OWNER=''' || tableschema || ''' AND TARGET_TABLE=''' || tablename || ''''; EXECUTE IMMEDIATE stmtSQL; -- delete ASN.IBMSNAP_SUSBS_MEMBER entries /target SET stmtSQL = 'DELETE FROM ASNCDC.IBMSNAP_SUBS_MEMBR WHERE TARGET_OWNER=''' || tableschema || ''' AND TARGET_TABLE=''' || tablename || ''''; EXECUTE IMMEDIATE stmtSQL; -- delete ASN.IBMQREP_COLVERSION SET stmtSQL = 'DELETE FROM ASNCDC.IBMQREP_COLVERSION col WHERE EXISTS (SELECT * FROM ASNCDC.IBMQREP_TABVERSION tab WHERE SOURCE_OWNER=''' || tableschema || ''' AND SOURCE_NAME=''' || tablename || '''AND col.TABLEID1 = tab.TABLEID1 AND col.TABLEID2 = tab.TABLEID2'; EXECUTE IMMEDIATE stmtSQL; -- delete ASN.IBMQREP_TABVERSION SET stmtSQL = 'DELETE FROM ASNCDC.IBMQREP_TABVERSION WHERE SOURCE_OWNER=''' || tableschema || ''' AND SOURCE_NAME=''' || tablename || ''''; EXECUTE IMMEDIATE stmtSQL; SET stmtSQL = 'ALTER TABLE ' || tableschema || '.' || tablename || ' DATA CAPTURE NONE'; EXECUTE IMMEDIATE stmtSQL; END P1 DB20000I The SQL command completed successfully. CREATE OR REPLACE PROCEDURE ASNCDC.ADDTABLE( in tableschema VARCHAR(128), in tablename VARCHAR(128) ) LANGUAGE SQL P1: BEGIN DECLARE SQLSTATE CHAR(5); DECLARE stmtSQL VARCHAR(2048); SET stmtSQL = 'ALTER TABLE ' || tableschema || '.' || tablename || ' DATA CAPTURE CHANGES'; EXECUTE IMMEDIATE stmtSQL; SET stmtSQL = 'CREATE TABLE ASNCDC.CDC_' || tableschema || '_' || tablename || ' AS ( SELECT ' || ' CAST('''' AS VARCHAR ( 16 ) FOR BIT DATA) AS IBMSNAP_COMMITSEQ, ' || ' CAST('''' AS VARCHAR ( 16 ) FOR BIT DATA) AS IBMSNAP_INTENTSEQ, ' || ' CAST ('''' AS CHAR(1)) ' || ' AS IBMSNAP_OPERATION, t.* FROM ' || tableschema || '.' || tablename || ' as t ) WITH NO DATA ORGANIZE BY ROW '; EXECUTE IMMEDIATE stmtSQL; SET stmtSQL = 'ALTER TABLE ASNCDC.CDC_' || tableschema || '_' || tablename || ' ALTER COLUMN IBMSNAP_COMMITSEQ SET NOT NULL'; EXECUTE IMMEDIATE stmtSQL; SET stmtSQL = 'ALTER TABLE ASNCDC.CDC_' || tableschema || '_' || tablename || ' ALTER COLUMN IBMSNAP_INTENTSEQ SET NOT NULL'; EXECUTE IMMEDIATE stmtSQL; SET stmtSQL = 'ALTER TABLE ASNCDC.CDC_' || tableschema || '_' || tablename || ' ALTER COLUMN IBMSNAP_OPERATION SET NOT NULL'; EXECUTE IMMEDIATE stmtSQL; SET stmtSQL = 'CREATE UNIQUE INDEX ASNCDC.IXCDC_' || tableschema || '_' || tablename || ' ON ASNCDC.CDC_' || tableschema || '_' || tablename || ' ( IBMSNAP_COMMITSEQ ASC, IBMSNAP_INTENTSEQ ASC ) PCTFREE 0 MINPCTUSED 0'; EXECUTE IMMEDIATE stmtSQL; SET stmtSQL = 'ALTER TABLE ASNCDC.CDC_' || tableschema || '_' || tablename || ' VOLATILE CARDINALITY'; EXECUTE IMMEDIATE stmtSQL; SET stmtSQL = 'INSERT INTO ASNCDC.IBMSNAP_REGISTER (SOURCE_OWNER, SOURCE_TABLE, ' || 'SOURCE_VIEW_QUAL, GLOBAL_RECORD, SOURCE_STRUCTURE, SOURCE_CONDENSED, ' || 'SOURCE_COMPLETE, CD_OWNER, CD_TABLE, PHYS_CHANGE_OWNER, ' || 'PHYS_CHANGE_TABLE, CD_OLD_SYNCHPOINT, CD_NEW_SYNCHPOINT, ' || 'DISABLE_REFRESH, CCD_OWNER, CCD_TABLE, CCD_OLD_SYNCHPOINT, ' || 'SYNCHPOINT, SYNCHTIME, CCD_CONDENSED, CCD_COMPLETE, ARCH_LEVEL, ' || 'DESCRIPTION, BEFORE_IMG_PREFIX, CONFLICT_LEVEL, ' || 'CHG_UPD_TO_DEL_INS, CHGONLY, RECAPTURE, OPTION_FLAGS, ' || 'STOP_ON_ERROR, STATE, STATE_INFO ) VALUES( ' || '''' || tableschema || ''', ' || '''' || tablename || ''', ' || '0, ' || '''N'', ' || '1, ' || '''Y'', ' || '''Y'', ' || '''ASNCDC'', ' || '''CDC_' || tableschema || '_' || tablename || ''', ' || '''ASNCDC'', ' || '''CDC_' || tableschema || '_' || tablename || ''', ' || 'null, ' || 'null, ' || '0, ' || 'null, ' || 'null, ' || 'null, ' || 'null, ' || 'null, ' || 'null, ' || 'null, ' || '''0801'', ' || 'null, ' || 'null, ' || '''0'', ' || '''Y'', ' || '''N'', ' || '''Y'', ' || '''NNNN'', ' || '''Y'', ' || '''A'',' || 'null ) '; EXECUTE IMMEDIATE stmtSQL; SET stmtSQL = 'INSERT INTO ASNCDC.IBMSNAP_PRUNCNTL ( ' || 'TARGET_SERVER, ' || 'TARGET_OWNER, ' || 'TARGET_TABLE, ' || 'SYNCHTIME, ' || 'SYNCHPOINT, ' || 'SOURCE_OWNER, ' || 'SOURCE_TABLE, ' || 'SOURCE_VIEW_QUAL, ' || 'APPLY_QUAL, ' || 'SET_NAME, ' || 'CNTL_SERVER , ' || 'TARGET_STRUCTURE , ' || 'CNTL_ALIAS , ' || 'PHYS_CHANGE_OWNER , ' || 'PHYS_CHANGE_TABLE , ' || 'MAP_ID ' || ') VALUES ( ' || '''KAFKA'', ' || '''' || tableschema || ''', ' || '''' || tablename || ''', ' || 'NULL, ' || 'NULL, ' || '''' || tableschema || ''', ' || '''' || tablename || ''', ' || '0, ' || '''KAFKAQUAL'', ' || '''SET001'', ' || ' (Select CURRENT_SERVER from sysibm.sysdummy1 ), ' || '8, ' || ' (Select CURRENT_SERVER from sysibm.sysdummy1 ), ' || '''ASNCDC'', ' || '''CDC_' || tableschema || '_' || tablename || ''', ' || ' ( SELECT CASE WHEN max(CAST(MAP_ID AS INT)) IS NULL THEN CAST(1 AS VARCHAR(10)) ELSE CAST(max(CAST(MAP_ID AS INT)) + 1 AS VARCHAR(10)) END AS MYINT from ASNCDC.IBMSNAP_PRUNCNTL ) ' || ' )'; EXECUTE IMMEDIATE stmtSQL; END P1 DB20000I The SQL command completed successfully. CREATE TABLE DB2INST1.TEST_TABLE (id INTEGER NOT NULL PRIMARY KEY) DB20000I The SQL command completed successfully. UPDATE ASNCDC.IBMSNAP_REGISTER SET STATE = 'A' WHERE SOURCE_OWNER = 'DB2INST1' AND SOURCE_TABLE = 'TEST_TABLE' SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. SQLSTATE=02000 VALUES ASNCDC.ASNCDCSERVICES('reinit','asncdc') 1 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- asncap is not running 1 record(s) selected. VALUES ASNCDC.ASNCDCSERVICES('start','asncdc') 1 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- start --> /database/config/db2inst1/sqllib/bin/asncap capture_schema=asncdc capture_server=TESTDB & 1 record(s) selected. VALUES ASNCDC.ASNCDCSERVICES('status','asncdc') 1 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2022-03-02-09.36.06.759304 ASN0600I "AsnCcmd" : "" : "Initial" : Program "capcmd 11.4.0 (Build 11.5.4.0 Level s2006161200, PTF DYN2006161200AMD64)" is starting. 2022-03-02-09.36.08.778514 ASN0520I "AsnCcmd" : "ASNCDC" : "Initial" : The STATUS command response: "HoldLThread" thread is in the "is waiting" state. 2022-03-02-09.36.08.778663 ASN0520I "AsnCcmd" : "ASNCDC" : "Initial" : The STATUS command response: "AdminThread" thread is in the "is resting" state. 2022-03-02-09.36.08.778765 ASN0520I "AsnCcmd" : "ASNCDC" : "Initial" : The STATUS command response: "PruneThread" thread is in the "is resting" state. 2022-03-02-09.36.08.778808 ASN0520I "AsnCcmd" : "ASNCDC" : "Initial" : The STATUS command response: "WorkerThread" thread is in the "is doing work" state. 1 record(s) selected. CALL ASNCDC.ADDTABLE('DB2INST1', 'TEST_TABLE' ) Return Status = 0 VALUES ASNCDC.ASNCDCSERVICES('reinit','asncdc') 1 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2022-03-02-09.36.08.997645 ASN0600I "AsnCcmd" : "" : "Initial" : Program "capcmd 11.4.0 (Build 11.5.4.0 Level s2006161200, PTF DYN2006161200AMD64)" is starting. 2022-03-02-09.36.11.021160 ASN0522I "AsnCcmd" : "ASNCDC" : "Initial" : The program received the "REINIT" command. 1 record(s) selected. done CDC setup completed. 2022-03-02-09.35.53.760104+000 I282952E542 LEVEL: Info PID : 14865 TID : 139704871675648 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : TESTDB HOSTNAME: 4db5f77c6e6f EDUID : 161 EDUNAME: db2loggw (TESTDB) 0 FUNCTION: DB2 UDB, data protection services, sqpLoggwEdu::sqlpLoggwMain, probe:2250 MESSAGE : Active read only logs files are being opened in buffered mode starting at log extent: DATA #1 : SQLPG_EXTENT_NUM, PD_TYPE_SQLPG_EXTENT_NUM, 4 bytes 6 2022-03-02-09.36.12.721056+000 I283495E721 LEVEL: Event PID : 14865 TID : 139700568319744 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : TESTDB APPHDL : 0-80 APPID: 172.29.0.1.56756.220302093654 HOSTNAME: 4db5f77c6e6f EDUID : 212 EDUNAME: db2agent (TESTDB) 0 FUNCTION: DB2 Common, Cryptography, cryptContextRealInit, probe:1941 DATA #1 : String, 37 bytes CPU flags(string): 0xfeda7217cf8bfbff DATA #2 : String, 37 bytes CPU flags(Uint64): 0xFEDA7217CF8BFBFF DATA #3 : String, 56 bytes Encryption hardware acceleration detected - Intel AES-NI DATA #4 : String, 56 bytes Encryption hardware acceleration detected - Intel RDrand 2022-03-02-09.36.20.064926+000 I284217E420 LEVEL: Warning PID : 14865 TID : 139704930395904 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 HOSTNAME: 4db5f77c6e6f EDUID : 15 EDUNAME: db2wlmtm 0 FUNCTION: DB2 UDB, base sys utilities, sqleTimedSleep, probe:1182 DATA #1 : unsigned integer, 8 bytes 1646213780091 DATA #2 : unsigned integer, 8 bytes 1646213780064 2022-03-02-09.36.50.042168+000 I284638E420 LEVEL: Warning PID : 14865 TID : 139704930395904 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 HOSTNAME: 4db5f77c6e6f EDUID : 15 EDUNAME: db2wlmtm 0 FUNCTION: DB2 UDB, base sys utilities, sqleTimedSleep, probe:1182 DATA #1 : unsigned integer, 8 bytes 1646213810066 DATA #2 : unsigned integer, 8 bytes 1646213810042 2022-03-02-09.36.55.953870+000 I285059E539 LEVEL: Event PID : 14865 TID : 139704808761088 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : TESTDB APPHDL : 0-52 APPID: *LOCAL.DB2.220302093626 AUTHID : DB2INST1 HOSTNAME: 4db5f77c6e6f EDUID : 187 EDUNAME: db2stmm (TESTDB) 0 FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : STMM CFG DB TESTDB : "Locklist" From: "6200" To: "10240" 2022-03-02-09.36.55.957284+000 I285599E534 LEVEL: Event PID : 14865 TID : 139704808761088 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : TESTDB APPHDL : 0-52 APPID: *LOCAL.DB2.220302093626 AUTHID : DB2INST1 HOSTNAME: 4db5f77c6e6f EDUID : 187 EDUNAME: db2stmm (TESTDB) 0 FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : STMM CFG DB TESTDB : "Maxlocks" From: "60" To: "98" 2022-03-02-09.36.55.960459+000 I286134E595 LEVEL: Event PID : 14865 TID : 139704808761088 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : TESTDB APPHDL : 0-52 APPID: *LOCAL.DB2.220302093626 AUTHID : DB2INST1 HOSTNAME: 4db5f77c6e6f EDUID : 187 EDUNAME: db2stmm (TESTDB) 0 FUNCTION: DB2 UDB, access plan manager, sqlra_resize_pckcache, probe:150 CHANGE : APM : Package Cache : FROM "6090792" : TO "8844165" : success IMPACT : None DATA #1 : String, 29 bytes Package Cache Resized (bytes) 2022-03-02-09.36.55.960633+000 I286730E540 LEVEL: Event PID : 14865 TID : 139704808761088 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : TESTDB APPHDL : 0-52 APPID: *LOCAL.DB2.220302093626 AUTHID : DB2INST1 HOSTNAME: 4db5f77c6e6f EDUID : 187 EDUNAME: db2stmm (TESTDB) 0 FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : STMM CFG DB TESTDB : "Pckcachesz" From: "1533" To: "2226" 2022-03-02-09.36.55.964002+000 I287271E549 LEVEL: Event PID : 14865 TID : 139704808761088 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : TESTDB APPHDL : 0-52 APPID: *LOCAL.DB2.220302093626 AUTHID : DB2INST1 HOSTNAME: 4db5f77c6e6f EDUID : 187 EDUNAME: db2stmm (TESTDB) 0 FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : STMM CFG DB TESTDB : "Database_memory" From: "445248" To: "457404" 2022-03-02-09.37.20.008241+000 I287821E420 LEVEL: Warning PID : 14865 TID : 139704930395904 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 HOSTNAME: 4db5f77c6e6f EDUID : 15 EDUNAME: db2wlmtm 0 FUNCTION: DB2 UDB, base sys utilities, sqleTimedSleep, probe:1182 DATA #1 : unsigned integer, 8 bytes 1646213840029 DATA #2 : unsigned integer, 8 bytes 1646213840006 2022-03-02-09.37.58.368062+000 I288242E540 LEVEL: Event PID : 14865 TID : 139704808761088 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : TESTDB APPHDL : 0-52 APPID: *LOCAL.DB2.220302093626 AUTHID : DB2INST1 HOSTNAME: 4db5f77c6e6f EDUID : 187 EDUNAME: db2stmm (TESTDB) 0 FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : STMM CFG DB TESTDB : "Locklist" From: "10240" To: "15360" 2022-03-02-09.37.58.376147+000 I288783E595 LEVEL: Event PID : 14865 TID : 139704808761088 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : TESTDB APPHDL : 0-52 APPID: *LOCAL.DB2.220302093626 AUTHID : DB2INST1 HOSTNAME: 4db5f77c6e6f EDUID : 187 EDUNAME: db2stmm (TESTDB) 0 FUNCTION: DB2 UDB, access plan manager, sqlra_resize_pckcache, probe:150 CHANGE : APM : Package Cache : FROM "8844165" : TO "9086525" : success IMPACT : None DATA #1 : String, 29 bytes Package Cache Resized (bytes) 2022-03-02-09.37.58.376923+000 I289379E540 LEVEL: Event PID : 14865 TID : 139704808761088 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : TESTDB APPHDL : 0-52 APPID: *LOCAL.DB2.220302093626 AUTHID : DB2INST1 HOSTNAME: 4db5f77c6e6f EDUID : 187 EDUNAME: db2stmm (TESTDB) 0 FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : STMM CFG DB TESTDB : "Pckcachesz" From: "2226" To: "2287"