1
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.50.36 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 1
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
0BMC706707I PTFS:
BMC16815I PARAMETERS: ACM
BMC16815I PARAMETERS: SSID DEND WORKID RDACRJ.RD10405D
BMC16815I PARAMETERS: DASDDOPT DSD1QDOP
BMC16815I PARAMETERS: CATDOPT DCD1QDOP
BMC16815I PARAMETERS: STOPWAIT 3
BMC16815I PARAMETERS: STOPWTSECS 10
BMC16815I PARAMETERS: LOCK EXCLUSIVE
BMC16992I USING 'DSD1QDOP' AS OPTIONS FOR DASD MANAGER UTILITIES
BMC16943I USING 'DMD1QEND' FOR RUN OPTIONS
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16979I WORKLIST DSNAME IS 'ACM.DB2V13.V131.WLBASE01(RD10405D)'
BMC706708I DB2 RELEASE: 1315 MODE: NEW FUNCTION
BMC70925I CURRENT FUNCTION LEVEL V13R1M501 CATALOG LEVEL V13R1M501
BMC70926I HIGHEST ACTIVATED LEVEL V13R1M501 PREVIOUS FUNCTION LEVEL V13R1M500
BMC16806I PARAMETERS ACCEPTED, BEGINNING EXECUTION VERSION V13.01.00 BASE 05/31/2022 FOR BMC AMI Change Manager for Db2
BMC16971I AUTHID SWITCHING OPTION 'N' IS IN EFFECT. -AUTH NOT ALLOWED.
BMC16957I EXECUTION AUTHID IS RDACRJ
0:***********************************************************************
BMC70933I WORKID DESCRIPTION:
BMC16999I INITIAL WORKID STATUS FOR RD10405D IS 'N' (NOT STARTED
BMC16999I UPDATED WORKID STATUS FOR RD10405D IS 'S' (STARTED)
0:***********************************************************************
0:*** BMC AMI Change Manager for Db2 VERSION 13.01.00 BASE (05/31/2022)
0:***********************************************************************
0:*** BMC AMI Change Manager for Db2 13.01.00 BASE PTFs applied:
0:*** BQU3344
0:*** EXECUTION (AEX) 13.01.00 BASE PTFs applied:
0:*** NONE
0:***********************************************************************
0:* ALUIN PARMS: *
0:* SSID DEND *
0:* WORKID RDACRJ.RD10405D *
0:* INCLUDE (DATA SQL AMS ) *
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.50.36 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 2
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
0:* SORTDEVT SYSDA *
0:* SMSINCLUDE ( ) *
0:* IBMUNLOAD IBMLOAD NOUSENGTUL *
0:* IBMREORG NOUSENGTR *
0:* IBMREBUILD *
0:* STANDALONESTATS DB2STATSUPD TABLEALL *
0:* NOHISTORY *
0:* IBMCOPY *
0:* NOUTILCOPY *
0:* DYNUNLD *
0:* DYNCOPY *
0:* NOPARTCOPY *
0:* COPYDDN (COPY01 ) *
0:* NOREGENIDENTITY *
0:* SINGLEPHASE *
0:* NOVVALPROP *
0:* IBMCHECK *
0:* SYNCPOINT 10 *
0:* NODBRMLIB *
0:* ORDERBY *
0:* UNLOADTABLE *
0:* NOREORGALT *
0:* UNLOADEMPTY *
0:* NOSTOPCOMMIT *
0:* TABLEACCESS *
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.50.36 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 3
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
0:* NOAPPLCOVR *
0:* NOPARALLEL *
0:* REORGONLINE *
0:* REORGALL *
0:* REORGREF *
0:* SPANNEDRECS *
0:* NOBINDONIX *
0:* NOMOVETB *
0:* NODEFERCDC *
0:***********************************************************************
0:-TIME 000050 '2022-04-05-17.44.51.080131' 90576933
0:-SSID 000100 DEND 80514191
0:-JCLP 000150 MIGR MSSID DEND 45842323
BMC16511I -JCLP IGNORED IN THIS RUN. SKIPPING WORKLIST RECORDS UNTIL NEXT COMMAND
0:-WKID 000200 RDACRJ.RD10405D 26594972
0:-CENV 000250
: TABLE_COL_NAME_EXPANSION ON 24829915
BMC16815I PARAMETERS: DMD1QEND,DEND
BMC16822I CONTROL PASSED TO 'ALUZPARM'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16898I DEBUG: ALUZPARM 0
**********************************************************************
*** BMC Software Inc. ***
*** BMC AMI Change Manager for Db2 ***
*** Version: 13.01.00 BASE ***
**********************************************************************
BMC396397I CHECK ENVIRONMENT ROUTINE STARTED - 04/05/2022 17:50:36
** ALUIN: TABLE_COL_NAME_EXPANSION ON
BMC56301I KEYWORDS ACCEPTED
BMC56723I CONNECTING TO SSID 'DEND' USING PLAN 'ACMD1QXM'
BMC56464I INITIAL Db2 ATTACH SUCCESSFUL. SSID(4)=DEND.
BMC56464I Db2 PLAN 'ACMD1QXM' USED FOR THIS TASK. RC=0
BMC56464I Db2 CONNECTED. VERSION 13 IN NEW FUNCTION MODE
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.50.36 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 4
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
BMC56464I Db2 CURRENT FUNCTION LEVEL IS V13R1M501
BMC56464I Db2 CATALOG LEVEL IS V13R1M501
BMC56464I APPLCOMPAT IS V13R1M501
BMC56724I CONNECTION COMPLETED WITH SQLCODE 0, ERR 0, RC 0
BMC396480I ZPARM SPECIFIED IN DOPTS DMD1QEND IS DSNZPARM
BMC396400I CHECK ENVIRONMENT ROUTINE SUCCESSFUL RC=0
0:-SYNC 000300 END OF CHECK ENVIRONMENT SECTION 99414218
0:***********************************************************************
0:***********************************************************************
0:***********************************************************************
0:***********************************************************************
0:*** THE FOLLOWING MESSAGES ARE INFORMATIONAL AND WARNINGS ONLY ***
0:***********************************************************************
0:*BMC396243I DB2 VERSION 13 IN NEW FUNCTION MODE
0:*BMC56464I DB2 CURRENT FUNCTION LEVEL IS V13R1M501
0:*BMC56464I DB2 CATALOG LEVEL IS V13R1M501
0:*BMC56464I APPLCOMPAT IS V13R1M501
0:*BMC56464I APPLCOMPAT FROM DSNZPARM IS V13R1M501
0:*BMC396472W CREATE FOR TABLESPACE USING NON UNIVERSAL TABLESPACE SYNTAX
0:* ON FUNCTION LEVEL V12R1M504 OR GREATER MAY RESULT IN:
0:* PARTITION BY GROWTH UNIVERSAL TABLESPACE MAXPARTITIONS 256
0:* PARTITION BY RANGE UNIVERSAL TABLESPACE SEGSIZE <DEFAULT>
0:*BMC45460W TAPE STACKING DISABLED FOR IBM COPY AND DYNAMIC ALLOCATION
0:*BMC396431W PROCESSING DFSMS-ENCRYPTED OBJECTS OR OBJECTS THAT WILL BE
0:* ENCRYPTED AS A RESULT OF PROCESSING MIGHT REQUIRE THE
0:* KEYLABEL OR DATACLAS PARAMETER IN -AMS WORKLIST COMMANDS.
0:*BMC396476I FOR PARTITION BY RANGE TABLE SPACES THAT USE RELATIVE PAGE
0:* NUMBERING, DB2 REQUIRES THAT THE TABLESPACE AND THE INDEX
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.50.36 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 5
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
0:* SPACE USE EXTENDED ADDRESSIBILITY ENABLED DASD DEVICES
0:* (STOGROUPS).
0:*BMC45339W TAPES CANNOT BE STACKED AND MULTIPLE TAPE DRIVES MAY BE
0:* REQUIRED IF MULTITASKING IS USED TO UNLOAD AND LOAD
0:* PARTITIONED TABLE SPACES. TO DISABLE MULTITASKING AND TO
0:* ENABLE TAPE STACKING, ADD THE NOMTASK KEYWORD TO THE ALUIN
0:* INPUT STREAM.
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.50.36 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 6
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
0:***********************************************************************
0:*** END OF WARNING MESSAGES - WARNINGS WERE ISSUED ***
0:***********************************************************************
0:*** ORIGINATOR OF WORKLIST WAS WORKID RDACRJ.RD10405D ON SSID DEND ***
0:-MIGR 000350 PHASE-1 START OF SECTION TO BE RUN ON SENDING SYSTEM 38352787
0:-SYNC 000400 START OF EXECUTION SYNCPOINT 86376801
0:***********************************************************************
0:-UNLI 000450
: TEMPLATE SYRC
: DSN 'RDACRJ.DEND.RD10405D.SR000001'
: UNIT SYSDA
:
: UNLOAD FROM TABLE R1128C04.T@T128PBR2
: HEADER NONE
: (
: COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
:HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
:@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
:@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
:@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
:@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
:@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
:@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.50.36 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 7
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
:@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLFL@15@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
:@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
:@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
:@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
:@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLDF@20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
:@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
:@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
:@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
:@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: TIMESTAMP EXTERNAL(32)
: , COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
:@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: TIMESTAMP WITH TIME ZONE EXTERNAL(32)
: , COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
:@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: TIMESTAMP EXTERNAL(32)
: , COLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLC@28@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
:@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
:@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: CLOB
: , COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: BLOB
: , COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
:@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: CLOB
: , COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
:HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: XML
: )
: UNLDDN SYRC
: SPANNED YES
: EBCDIC CCSID(37,0,0)
: NOPAD MAXERR 1
: IMPLICIT_TZ -05:00
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.50.36 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 8
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: 38763186
BMC16815I PARAMETERS: DEND,RD10405D
BMC16822I CONTROL PASSED TO 'DSNUTILB'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16898I DEBUG: DSNUTILB 0
0DSNU000I 095 17:50:36.84 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
DSNU1044I 095 17:50:36.85 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 095 17:50:36.86 DSNUGUTC - TEMPLATE SYRC DSN 'RDACRJ.DEND.RD10405D.SR000001' UNIT SYSDA
DSNU1035I 095 17:50:36.86 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 095 17:50:36.86 DSNUGUTC - UNLOAD
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - FROM TABLE R1128C04.T@T128PBR2 HEADER NONE
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - (COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLFL@15@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLDF@20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T TIMESTAMP EXTERNAL(32),
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.24 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 9
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T TIMESTAMP WITH TIME ZONE EXTERNAL(32),
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T TIMESTAMP EXTERNAL(32),
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLC@28@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T CLOB,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T BLOB,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGH
T@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T CLOB,
DSNU650I *DEND 095 17:50:36.87 DSNUUGMS - COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T XML) UNLDDN SYRC SPANNED YES EBCDIC CCSID(37, 0, 0)
NOPAD MAXERR 1 IMPLICIT_TZ -5:0
DSNU1038I 095 17:51:24.22 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=SYRC
DDNAME=SYS00008
DSN=RDACRJ.DEND.RD10405D.SR000001
DSNU253I 095 17:51:24.26 DSNUUNLD - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR TABLE
R1128C04.T@T128PBR2
DSNU252I 095 17:51:24.26 DSNUUNLD - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS UNLOADED=0 FOR TABLESPACE
R1128C04.T128PBR2
DSNU250I 095 17:51:24.26 DSNUUNLD - UNLOAD PHASE COMPLETE, ELAPSED TIME=00:00:47
DSNU010I 095 17:51:24.27 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
0:-SYNC 000500 END OF UNLOAD TABLES SECTION 53302971
0:***********************************************************************
0:-SETS 000550 SET CURRENT SQLID = 'RDACRJ4' 76602437
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 000600 CREATE DATABASE R1128C30
: STOGROUP SYSDEFLT
: BUFFERPOOL BP8K0
: 71408394
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SETS 000650 SET CURRENT SQLID = USER 95314987
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SYNC 000700 END OF DATABASE SECTION 29545590
0:***********************************************************************
0:-SETS 000750 SET CURRENT SQLID = 'RDACRJ4' 76471365
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.24 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 10
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 000800 CREATE LOB TABLESPACE T128P2L3 IN R1128C30
: USING STOGROUP R1EAV
: PRIQTY 1440
: SECQTY 720
: GBPCACHE SYSTEM
: BUFFERPOOL BP8K0
: DSSIZE 4G
: 05268805
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 000850 CREATE LOB TABLESPACE T128P2L4 IN R1128C30
: USING STOGROUP R1EAV
: PRIQTY 1440
: SECQTY 720
: GBPCACHE SYSTEM
: BUFFERPOOL BP8K0
: DSSIZE 4G
: 05267269
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 000900 CREATE LOB TABLESPACE T128P2L5 IN R1128C30
: USING STOGROUP R1EAV
: PRIQTY 1440
: SECQTY 720
: GBPCACHE SYSTEM
: BUFFERPOOL BP8K0
: DSSIZE 4G
: 05202757
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 000950 CREATE LOB TABLESPACE T128P2L6 IN R1128C30
: USING STOGROUP R1EAV
: PRIQTY 1440
: SECQTY 720
: GBPCACHE SYSTEM
: BUFFERPOOL BP8K0
: DSSIZE 4G
: 05201221
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 001000 CREATE LOB TABLESPACE T128P2L1 IN R1128C30
: USING STOGROUP R1EAV
: PRIQTY 1440
: SECQTY 720
: GBPCACHE SYSTEM
: BUFFERPOOL BP8K0
: DSSIZE 4G
: 10983611
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.24 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 11
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 001050 CREATE LOB TABLESPACE T128P2L2 IN R1128C30
: USING STOGROUP R1EAV
: PRIQTY 1440
: SECQTY 720
: GBPCACHE SYSTEM
: BUFFERPOOL BP8K0
: DSSIZE 4G
: 10985147
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 001100 CREATE TABLESPACE T128PBR2 IN R1128C30
: NUMPARTS 2
: (PART 1
: USING STOGROUP R1EAV
: PRIQTY 1440
: SECQTY 720
: PCTFREE 0 FOR UPDATE -1
: DSSIZE 1G
: ,PART 2
: USING STOGROUP R1EAV
: PRIQTY 1440
: SECQTY 720
: PCTFREE 0 FOR UPDATE -1
: DSSIZE 1G
: )
: CCSID EBCDIC
: BUFFERPOOL BP1
: LOCKSIZE ANY
: LOCKMAX 10
: CLOSE NO
: SEGSIZE 4
: PAGENUM RELATIVE
: DSSIZE 1G
: 11397415
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SETS 001150 SET CURRENT SQLID = USER 11764523
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SYNC 001200 END OF CREATE TABLESPACE SECTION 21677747
0:***********************************************************************
0:-SQL 001250 CREATE TABLE RDACRJ4.T@T128PBR2
: (
: COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CH
: ARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: CHAR(1) NOT NULL WITH DEFAULT
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.24 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 12
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: 'A'
: , COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
: CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: VARCHAR(15) NOT NULL WITH DEFAULT
: 'SEATTLE'
: , COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
: CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: CLOB(1073741824)
: INLINE LENGTH 0
: WITH DEFAULT
: , COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: BINARY(4) NOT NULL WITH DEFAULT
: BX'0102'
: , COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: VARBINARY(5) NOT NULL WITH DEFAULT
: BX'030405'
: , COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
: CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: BLOB(1073741824)
: INLINE LENGTH 0
: WITH DEFAULT
: , COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: SMALLINT NOT NULL WITH DEFAULT
: 55
: , COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: INTEGER NOT NULL WITH DEFAULT
: 1969
: , COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: BIGINT NOT NULL WITH DEFAULT
: 9223372036854775804
: , COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: DECIMAL(5,2) NOT NULL WITH DEFAULT
: 123.67
: , COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: DECIMAL(10,1) NOT NULL WITH DEFAULT
: 123456789.0
: , COLFL@15@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: FLOAT NOT NULL WITH DEFAULT
: 10.2E1
: , COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: REAL NOT NULL WITH DEFAULT
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.24 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 13
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: 5.4E-075
: , COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: FLOAT NOT NULL WITH DEFAULT
: 5.4E-78
: , COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: DECFLOAT(16) WITH DEFAULT
: , COLDF@20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: DECFLOAT(34) WITH DEFAULT
: , COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: DATE NOT NULL WITH DEFAULT
: '2013-01-02'
: , COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: TIME NOT NULL WITH DEFAULT
: '12.57.00'
: , COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: TIMESTAMP NOT NULL WITH DEFAULT
: '2015-01-01-00.00.00.000000'
: , COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: TIMESTAMP WITH TIME ZONE NOT NULL WITH DEFAULT
: '2015-01-02-05.30.00.000000-08:30'
: , COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: TIMESTAMP NOT NULL WITH DEFAULT
: '2015-01-02-05.30.00.000000'
: , COLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
: CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: CHAR(2) WITH DEFAULT
: , COLC@28@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
: CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: CHAR(2) FOR BIT DATA WITH DEFAULT
: , COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: VARCHAR(4) NOT NULL WITH DEFAULT
: , COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: VARCHAR(4) FOR BIT DATA WITH DEFAULT
: , COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: CLOB(1073741824)
: INLINE LENGTH 0
: WITH DEFAULT
: , COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
: HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.24 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 14
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: XML NOT NULL
: )
: CCSID EBCDIC
: IN R1128C30.T128PBR2
: PARTITION BY
: ( COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
: (PARTITION 1 ENDING AT (2000)
: ,PARTITION 2 ENDING AT (2010)
: )
: 07033474
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 001300 LABEL ON RDACRJ4.T@T128PBR2
: (COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUN
: DRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
: RED@T
: IS 'D'
: ,COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUN
: DRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
: RED@T
: IS 'E'
: ,COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
: RED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
: RED@T
: IS 'F'
: )
: 59380357
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 001350 COMMENT ON RDACRJ4.T@T128PBR2
: (COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDR
: ED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
: RED@T
: IS 'COL 1 127'
: ,COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
: RED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
: RED@T
: IS 'COL 2 127'
: ,COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
: RED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUND
: RED@T
: IS 'COL 3 127'
: ) 05138706
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 001400 CREATE AUXILIARY TABLE
: RDACRJ4.T@T128PBR2L3
: IN R1128C30.T128P2L3
: STORES RDACRJ4.T@T128PBR2
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.28 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 15
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: COLUMN COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
: NE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
: NE@HUNDRED@T
: PART 1
: 42016305
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 001450 CREATE AUXILIARY TABLE
: RDACRJ4.T@T128PBR2L4
: IN R1128C30.T128P2L4
: STORES RDACRJ4.T@T128PBR2
: COLUMN COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
: NE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
: NE@HUNDRED@T
: PART 2
: 42015022
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 001500 CREATE AUXILIARY TABLE
: RDACRJ4.T@T128PBR2L5
: IN R1128C30.T128P2L5
: STORES RDACRJ4.T@T128PBR2
: COLUMN COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@
: ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
: NE@HUNDRED@T
: PART 1
: 14110752
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 001550 CREATE AUXILIARY TABLE
: RDACRJ4.T@T128PBR2L6
: IN R1128C30.T128P2L6
: STORES RDACRJ4.T@T128PBR2
: COLUMN COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@
: ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
: NE@HUNDRED@T
: PART 2
: 14109469
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 001600 CREATE AUXILIARY TABLE
: RDACRJ4.T@T128PBR2L1
: IN R1128C30.T128P2L1
: STORES RDACRJ4.T@T128PBR2
: COLUMN COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
: NE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
: NE@HUNDRED@T
: PART 1
: 42278197
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.28 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 16
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
0:-SQL 001650 CREATE AUXILIARY TABLE
: RDACRJ4.T@T128PBR2L2
: IN R1128C30.T128P2L2
: STORES RDACRJ4.T@T128PBR2
: COLUMN COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
: NE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
: NE@HUNDRED@T
: PART 2
: 42276914
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SYNC 001700 END OF TABLE SECTION 91789030
0:***********************************************************************
0:-SQL 001750 CREATE UNIQUE INDEX
: RDACRJ4.I@T128PBR22
: ON RDACRJ4.T@T128PBR2
: ( COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
: USING STOGROUP R1EAV
: PRIQTY 12
: SECQTY 12
: BUFFERPOOL BP0
: CLOSE YES
: PIECESIZE 4194304 K
: 10584101
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 001800 ALTER TABLE RDACRJ4.T@T128PBR2
: ADD CONSTRAINT PK@T128PBR2
: PRIMARY KEY (COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARA
: CTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARAC
: TERS@ONE@HUNDRED@T,
: COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARA
: CTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARAC
: TERS@ONE@HUNDRED@T)
: 99403208
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 001850 CREATE INDEX
: RDACRJ4.I@T128PBR2L3
: ON RDACRJ4.T@T128PBR2L3
: PADDED
: USING STOGROUP SYSDEFLT
: PRIQTY -1
: SECQTY -1
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.28 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 17
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: BUFFERPOOL BP0
: CLOSE YES
: PIECESIZE 4194304 K
: 01130958
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 001900 CREATE INDEX
: RDACRJ4.I@T128PBR2L4
: ON RDACRJ4.T@T128PBR2L4
: PADDED
: USING STOGROUP SYSDEFLT
: PRIQTY -1
: SECQTY -1
: BUFFERPOOL BP0
: CLOSE YES
: PIECESIZE 4194304 K
: 01195216
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 001950 CREATE INDEX
: RDACRJ4.I@T128PBR2L5
: ON RDACRJ4.T@T128PBR2L5
: PADDED
: USING STOGROUP SYSDEFLT
: PRIQTY -1
: SECQTY -1
: BUFFERPOOL BP0
: CLOSE YES
: PIECESIZE 4194304 K
: 01196498
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 002000 CREATE INDEX
: RDACRJ4.I@T128PBR2L6
: ON RDACRJ4.T@T128PBR2L6
: PADDED
: USING STOGROUP SYSDEFLT
: PRIQTY -1
: SECQTY -1
: BUFFERPOOL BP0
: CLOSE YES
: PIECESIZE 4194304 K
: 17382612
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 002050 CREATE INDEX
: RDACRJ4.I@T128PBR2L1
: ON RDACRJ4.T@T128PBR2L1
: PADDED
: USING STOGROUP SYSDEFLT
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.28 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 18
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: PRIQTY -1
: SECQTY -1
: BUFFERPOOL BP0
: CLOSE YES
: PIECESIZE 4194304 K
: 17383882
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 002100 CREATE INDEX
: RDACRJ4.I@T128PBR2L2
: ON RDACRJ4.T@T128PBR2L2
: PADDED
: USING STOGROUP SYSDEFLT
: PRIQTY -1
: SECQTY -1
: BUFFERPOOL BP0
: CLOSE YES
: PIECESIZE 4194304 K
: 17448140
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 002150 CREATE UNIQUE INDEX
: RDACRJ4.I@T128PBR23
: ON RDACRJ4.T@T128PBR2
: ( COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
: NOT PADDED
: USING STOGROUP R1EAV
: PRIQTY 12
: SECQTY 12
: BUFFERPOOL BP0
: CLOSE YES
: PIECESIZE 4194304 K
: 01276496
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 002200 CREATE UNIQUE INDEX
: RDACRJ4.I@T128PBR24
: ON RDACRJ4.T@T128PBR2
: ( COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
: HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
: INCLUDE
: ( COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
: NOT PADDED
: USING STOGROUP SYSDEFLT
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.28 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 19
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: PRIQTY -1
: SECQTY -1
: BUFFERPOOL BP0
: CLOSE YES
: PIECESIZE 4194304 K
: 83684506
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SYNC 002250 AUTOMATIC SYNC POINT 71276645
0:-SQL 002300 CREATE INDEX
: RDACRJ4.I@T128PBR25
: ON RDACRJ4.T@T128PBR2
: (
: SUBSTR( COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY
: @EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T, 1, 3
: )
: ,
: DATE( COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@E
: IGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
: )
: USING STOGROUP SYSDEFLT
: PRIQTY -1
: SECQTY -1
: BUFFERPOOL BP1
: CLOSE YES
: PIECESIZE 4194304 K
: 46947416
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 002350 CREATE INDEX
: RDACRJ4.I@T128PBR21
: ON RDACRJ4.T@T128PBR2
: ( COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
: CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
: NOT PADDED
: USING STOGROUP R1EAV
: PRIQTY 12
: SECQTY 12
: BUFFERPOOL BP0
: CLOSE YES
: PIECESIZE 4194304 K
: 24910753
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 002400 CREATE INDEX
: RDACRJ4.I@T128PBR26
: ON RDACRJ4.T@T128PBR2
: (
: COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.29 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 20
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: RACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T * COLIN@11@ON
: E@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE
: @HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: ,
: COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
: RACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T - 1
: )
: USING STOGROUP R1EAV
: PRIQTY 96
: SECQTY 48
: BUFFERPOOL BP0
: CLOSE YES
: PIECESIZE 4194304 K
: 57102322
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SYNC 002450 END OF CREATE INDEX SECTION 44006859
0:***********************************************************************
0:-SQL 002500 ALTER TABLE RDACRJ4.T@T128PBR2
: ADD CONSTRAINT UC@T128PBR2
: UNIQUE (COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARA
: CTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARAC
: TERS@ONE@HUNDRED@T)
: 38690960
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SYNC 002550 END OF UNIQUE CONSTRAINTS SECTION 13116438
0:***********************************************************************
0:-LOAD 002600
: TEMPLATE SYRC
: DSN 'RDACRJ.DEND.RD10405D.SR000001'
: UNIT SYSDA
:
: LOAD DATA REPLACE
: INDDN SYRC
: ERRDDN SYSER001
: DISCARDS 1
: DISCARDDN SYSDS001
: EBCDIC CCSID(37,0,0)
: FORMAT SPANNED YES
: WORKDDN SYSUT001
: LOG NO
: ENFORCE NO
: REUSE
: INTO TABLE RDACRJ4.T@T128PBR2
: IGNOREFIELDS YES
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.29 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 21
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: (
: COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CH
:ARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) CHAR(1),
: COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
:HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) VARCHAR,
: COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) BINARY,
: COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) VARBINARY,
: COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) SMALLINT,
: COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) INTEGER,
: COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) BIGINT,
: COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) DECIMAL,
: COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) DECIMAL,
: COLFL@15@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) FLOAT(53),
: COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) FLOAT(21),
: COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) FLOAT(53),
: NULL001 POSITION(*) CHAR(1),
: COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) DECFLOAT(16)
: NULLIF NULL001=X'FF',
: NULL002 POSITION(*) CHAR(1),
: COLDF@20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) DECFLOAT(34)
: NULLIF NULL002=X'FF',
: COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) DATE EXTERNAL,
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.29 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 22
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) TIME EXTERNAL,
: COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) TIMESTAMP EXTERNAL(32),
: COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) TIMESTAMP WITH TIME ZONE EXTERNAL(32),
: COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) TIMESTAMP EXTERNAL(32),
: NULL003 POSITION(*) CHAR(1),
: COLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
:HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) CHAR(2)
: NULLIF NULL003=X'FF',
: NULL004 POSITION(*) CHAR(1),
: COLC@28@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
:HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) CHAR(2)
: NULLIF NULL004=X'FF',
: COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) VARCHAR,
: NULL005 POSITION(*) CHAR(1),
: COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) VARCHAR
: NULLIF NULL005=X'FF',
: NULL006 POSITION(*) CHAR(1),
: COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
:HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) CLOB
: NULLIF NULL006=X'FF',
: NULL007 POSITION(*) CHAR(1),
: COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
:HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) BLOB
: NULLIF NULL007=X'FF',
: NULL008 POSITION(*) CHAR(1),
: COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
:CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) CLOB
: NULLIF NULL008=X'FF',
: COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CH
:ARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: POSITION(*) XML)
: 54503458
BMC16815I PARAMETERS: DEND,RD10405D
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.29 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 23
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
BMC16822I CONTROL PASSED TO 'DSNUTILB'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16970I CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
BMC16898I DEBUG: DSNUTILB 4
0BMC16820W SUBTASK DSNUTILB RC NOT 0, RETURN CODE WAS: X'00000004'
0DSNU000I 095 17:51:29.29 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
DSNU1044I 095 17:51:29.30 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 095 17:51:29.31 DSNUGUTC - TEMPLATE SYRC DSN 'RDACRJ.DEND.RD10405D.SR000001' UNIT SYSDA
DSNU1035I 095 17:51:29.31 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 095 17:51:29.31 DSNUGUTC - LOAD DATA REPLACE INDDN SYRC ERRDDN SYSER001 DISCARDS 1 DISCARDDN SYSDS001
EBCDIC CCSID(37, 0, 0) FORMAT SPANNED YES WORKDDN SYSUT001 LOG NO ENFORCE NO REUSE
DSNU650I *DEND 095 17:51:29.32 DSNURWI - INTO TABLE RDACRJ4.T@T128PBR2 IGNOREFIELDS YES
DSNU650I *DEND 095 17:51:29.32 DSNURWI - (COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CH
ARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) CHAR(1),
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) VARCHAR,
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) BINARY,
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) VARBINARY,
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) SMALLINT,
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) INTEGER,
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) BIGINT,
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) DECIMAL,
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) DECIMAL,
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLFL@15@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) FLOAT(53),
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) FLOAT(21),
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) FLOAT(53),
DSNU650I *DEND 095 17:51:29.32 DSNURWI - NULL001 POSITION(*) CHAR(1),
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) DECFLOAT(16) NULLIF NULL001=X'FF',
DSNU650I *DEND 095 17:51:29.32 DSNURWI - NULL002 POSITION(*) CHAR(1),
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLDF@20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) DECFLOAT(34) NULLIF NULL002=X'FF',
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) DATE EXTERNAL,
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.31 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 24
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) TIME EXTERNAL,
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) TIMESTAMP EXTERNAL(32),
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) TIMESTAMP WITH TIME ZONE EXTERNAL(32),
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) TIMESTAMP EXTERNAL(32),
DSNU650I *DEND 095 17:51:29.32 DSNURWI - NULL003 POSITION(*) CHAR(1),
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) CHAR(2) NULLIF NULL003=X'FF',
DSNU650I *DEND 095 17:51:29.32 DSNURWI - NULL004 POSITION(*) CHAR(1),
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLC@28@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) CHAR(2) NULLIF NULL004=X'FF',
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) VARCHAR,
DSNU650I *DEND 095 17:51:29.32 DSNURWI - NULL005 POSITION(*) CHAR(1),
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) VARCHAR NULLIF NULL005=X'FF',
DSNU650I *DEND 095 17:51:29.32 DSNURWI - NULL006 POSITION(*) CHAR(1),
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) CLOB NULLIF NULL006=X'FF',
DSNU650I *DEND 095 17:51:29.32 DSNURWI - NULL007 POSITION(*) CHAR(1),
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
HRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) BLOB NULLIF NULL007=X'FF',
DSNU650I *DEND 095 17:51:29.32 DSNURWI - NULL008 POSITION(*) CHAR(1),
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) CLOB NULLIF NULL008=X'FF',
DSNU650I *DEND 095 17:51:29.32 DSNURWI - COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CH
ARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T POSITION(*) XML)
DSNU1038I 095 17:51:29.37 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=SYRC
DDNAME=SYS00009
DSN=RDACRJ.DEND.RD10405D.SR000001
DSNU350I *DEND 095 17:51:30.98 DSNURRST - EXISTING RECORDS DELETED FROM TABLESPACE
DSNU304I *DEND 095 17:51:31.23 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=0 FOR TABLE RDACRJ4.T@T128PBR2
DSNU1147I *DEND 095 17:51:31.23 DSNURWT - (RE)LOAD PHASE STATISTICS - TOTAL NUMBER OF RECORDS LOADED=0 FOR TABLESPACE
R1128C30.T128PBR2
DSNU302I 095 17:51:31.23 DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=0
DSNU300I 095 17:51:31.23 DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED TIME=00:00:01
DSNU1383I *DEND 095 17:51:31.23 DSNURINV - DYNAMIC STATEMENT CACHE WAS INVALIDATED,
REASON = OBJECT IN RESTRICTIVE STATE
DSNU380I *DEND 095 17:51:31.24 DSNUGSRX - TABLESPACE R1128C30.T128PBR2 PARTITION 1 IS IN COPY PENDING
DSNU380I *DEND 095 17:51:31.24 DSNUGSRX - TABLESPACE R1128C30.T128PBR2 PARTITION 2 IS IN COPY PENDING
DSNU381I *DEND 095 17:51:31.24 DSNUGSRX - TABLESPACE R1128C30.T128P2L3 IS IN COPY PENDING
DSNU381I *DEND 095 17:51:31.24 DSNUGSRX - TABLESPACE R1128C30.T128P2L4 IS IN COPY PENDING
DSNU381I *DEND 095 17:51:31.24 DSNUGSRX - TABLESPACE R1128C30.T128P2L5 IS IN COPY PENDING
DSNU381I *DEND 095 17:51:31.24 DSNUGSRX - TABLESPACE R1128C30.T128P2L6 IS IN COPY PENDING
DSNU381I *DEND 095 17:51:31.24 DSNUGSRX - TABLESPACE R1128C30.T128P2L1 IS IN COPY PENDING
DSNU381I *DEND 095 17:51:31.24 DSNUGSRX - TABLESPACE R1128C30.T128P2L2 IS IN COPY PENDING
DSNU380I *DEND 095 17:51:31.24 DSNUGSRX - TABLESPACE R1128C30.XTXT0000 PARTITION 1 IS IN COPY PENDING
DSNU380I *DEND 095 17:51:31.24 DSNUGSRX - TABLESPACE R1128C30.XTXT0000 PARTITION 2 IS IN COPY PENDING
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.31 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 25
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
DSNU010I 095 17:51:31.24 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=4
0:-SYNC 002650 LOAD TB RDACRJ4.T@T128PBR2 COMPLETE 79008138
0:-SYNC 002700 END OF LOAD TABLES SECTION 61090539
0:***********************************************************************
0:*SQL 002750 ALTER TABLE RDACRJ4.T@T128PBR2
0:* FOREIGN KEY FK@T128PBR2
0:*( COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
0:*@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
0:*, COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
0:*@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
0:* REFERENCES RDACRJ4.T@T04TCP
0:* ON DELETE RESTRICT
0:*
0:*
0:-SYNC 002800 END OF FOREIGN KEYS SECTION 79901525
0:***********************************************************************
0:-SETP 002850 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
: ,"SESSION_USER","R1UDT","R1UDF","R198573" 63438759
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 002900 ALTER TABLE RDACRJ4.T@T128PBR2
: ADD CONSTRAINT CK@T128PBR2 CHECK (
: COLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
: CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T <> 'AA'
: )
: 90091327
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SETP 002950 SET CURRENT PATH = SYSTEM PATH 90714802
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SYNC 003000 END OF CHECK CONSTRAINTS SECTION 29715932
0:***********************************************************************
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.31 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 26
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
0:-CHEK 003050
: CHECK DATA TABLESPACE R1128C30.T128PBR2
: ERRDDN SYSER001 WORKDDN SYSUT001
: EXCEPTIONS 0
: SORTDEVT SYSDA
: 96815248
BMC16815I PARAMETERS: DEND,RD10405D
BMC16822I CONTROL PASSED TO 'DSNUTILB'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16970I CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
BMC16898I DEBUG: DSNUTILB 4
0BMC16820W SUBTASK DSNUTILB RC NOT 0, RETURN CODE WAS: X'00000004'
0DSNU000I 095 17:51:31.40 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
DSNU1044I 095 17:51:31.41 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 095 17:51:31.41 DSNUGUTC - CHECK DATA TABLESPACE R1128C30.T128PBR2 ERRDDN SYSER001 WORKDDN SYSUT001
EXCEPTIONS 0 SORTDEVT SYSDA
DSNU727I *DEND 095 17:51:31.41 DSNUKINP - TABLESPACE 'R1128C30.T128PBR2' IS NOT CHECK PENDING
DSNU749I 095 17:51:31.41 DSNUK001 - CHECK DATA COMPLETE,ELAPSED TIME=00:00:00
DSNU010I 095 17:51:31.42 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=4
0:-SYNC 003100 CHECK DATA FOR TS R1128C30.T128PBR2 COMPLETE 11303406
0:-SYNC 003150 END OF CHECK DATA SECTION 24204699
0:***********************************************************************
0:-COPY 003200
: TEMPLATE DCPYLOCP
: DSN 'RDACRJ.&UT..&SN..P&PART..LP000001'
: UNIT SYSDA
: COPY TABLESPACE R1128C30.T128P2L3
: COPYDDN (DCPYLOCP)
: 91200417
BMC16815I PARAMETERS: DEND,RD10405D
BMC16822I CONTROL PASSED TO 'DSNUTILB'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16970I CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
BMC16898I DEBUG: DSNUTILB 0
0DSNU000I 095 17:51:31.51 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
DSNU1044I 095 17:51:31.52 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 095 17:51:31.53 DSNUGUTC - TEMPLATE DCPYLOCP DSN 'RDACRJ.&UT..&SN..P&PART..LP000001' UNIT SYSDA
DSNU1035I 095 17:51:31.53 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.31 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 27
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
0DSNU050I 095 17:51:31.53 DSNUGUTC - COPY TABLESPACE R1128C30.T128P2L3 COPYDDN(DCPYLOCP)
DSNU1038I 095 17:51:31.59 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=DCPYLOCP
DDNAME=SYS00010
DSN=RDACRJ.RD10405D.T128P2L3.P00000.LP000001
DSNU400I 095 17:51:31.71 DSNUBBID - COPY PROCESSED FOR TABLESPACE R1128C30.T128P2L3
NUMBER OF PAGES=21
AVERAGE PERCENT FREE SPACE PER PAGE = 1.00
PERCENT OF CHANGED PAGES = 0.00
ELAPSED TIME=00:00:00
DSNU428I *DEND 095 17:51:31.73 DSNUBAFI - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE R1128C30.T128P2L3
DSNU010I 095 17:51:31.74 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
0:-SYNC 003250 COPY FOR TS R1128C30.T128P2L3 COMPLETE 51040916
0:-COPY 003300
: TEMPLATE DCPYLOCP
: DSN 'RDACRJ.&UT..&SN..P&PART..LP000002'
: UNIT SYSDA
: COPY TABLESPACE R1128C30.T128P2L4
: COPYDDN (DCPYLOCP)
: 91134879
BMC16815I PARAMETERS: DEND,RD10405D
BMC16822I CONTROL PASSED TO 'DSNUTILB'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16970I CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
BMC16898I DEBUG: DSNUTILB 0
0DSNU000I 095 17:51:31.84 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
DSNU1044I 095 17:51:31.86 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 095 17:51:31.86 DSNUGUTC - TEMPLATE DCPYLOCP DSN 'RDACRJ.&UT..&SN..P&PART..LP000002' UNIT SYSDA
DSNU1035I 095 17:51:31.86 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 095 17:51:31.86 DSNUGUTC - COPY TABLESPACE R1128C30.T128P2L4 COPYDDN(DCPYLOCP)
DSNU1038I 095 17:51:31.92 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=DCPYLOCP
DDNAME=SYS00011
DSN=RDACRJ.RD10405D.T128P2L4.P00000.LP000002
DSNU400I 095 17:51:32.01 DSNUBBID - COPY PROCESSED FOR TABLESPACE R1128C30.T128P2L4
NUMBER OF PAGES=21
AVERAGE PERCENT FREE SPACE PER PAGE = 1.00
PERCENT OF CHANGED PAGES = 0.00
ELAPSED TIME=00:00:00
DSNU428I *DEND 095 17:51:32.02 DSNUBAFI - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE R1128C30.T128P2L4
DSNU010I 095 17:51:32.03 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
0:-SYNC 003350 COPY FOR TS R1128C30.T128P2L4 COMPLETE 51171988
0:-COPY 003400
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.32 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 28
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: TEMPLATE DCPYLOCP
: DSN 'RDACRJ.&UT..&SN..P&PART..LP000003'
: UNIT SYSDA
: COPY TABLESPACE R1128C30.T128P2L5
: COPYDDN (DCPYLOCP)
: 91069341
BMC16815I PARAMETERS: DEND,RD10405D
BMC16822I CONTROL PASSED TO 'DSNUTILB'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16970I CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
BMC16898I DEBUG: DSNUTILB 0
0DSNU000I 095 17:51:32.12 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
DSNU1044I 095 17:51:32.13 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 095 17:51:32.14 DSNUGUTC - TEMPLATE DCPYLOCP DSN 'RDACRJ.&UT..&SN..P&PART..LP000003' UNIT SYSDA
DSNU1035I 095 17:51:32.14 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 095 17:51:32.14 DSNUGUTC - COPY TABLESPACE R1128C30.T128P2L5 COPYDDN(DCPYLOCP)
DSNU1038I 095 17:51:32.19 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=DCPYLOCP
DDNAME=SYS00012
DSN=RDACRJ.RD10405D.T128P2L5.P00000.LP000003
DSNU400I 095 17:51:32.30 DSNUBBID - COPY PROCESSED FOR TABLESPACE R1128C30.T128P2L5
NUMBER OF PAGES=21
AVERAGE PERCENT FREE SPACE PER PAGE = 1.00
PERCENT OF CHANGED PAGES = 0.00
ELAPSED TIME=00:00:00
DSNU428I *DEND 095 17:51:32.32 DSNUBAFI - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE R1128C30.T128P2L5
DSNU010I 095 17:51:32.32 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
0:-SYNC 003450 COPY FOR TS R1128C30.T128P2L5 COMPLETE 51303060
0:-COPY 003500
: TEMPLATE DCPYLOCP
: DSN 'RDACRJ.&UT..&SN..P&PART..LP000004'
: UNIT SYSDA
: COPY TABLESPACE R1128C30.T128P2L6
: COPYDDN (DCPYLOCP)
: 91003803
BMC16815I PARAMETERS: DEND,RD10405D
BMC16822I CONTROL PASSED TO 'DSNUTILB'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16970I CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
BMC16898I DEBUG: DSNUTILB 0
0DSNU000I 095 17:51:32.46 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
DSNU1044I 095 17:51:32.47 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 095 17:51:32.47 DSNUGUTC - TEMPLATE DCPYLOCP DSN 'RDACRJ.&UT..&SN..P&PART..LP000004' UNIT SYSDA
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.36 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 29
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
DSNU1035I 095 17:51:32.47 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 095 17:51:32.48 DSNUGUTC - COPY TABLESPACE R1128C30.T128P2L6 COPYDDN(DCPYLOCP)
DSNU1038I 095 17:51:34.87 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=DCPYLOCP
DDNAME=SYS00013
DSN=RDACRJ.RD10405D.T128P2L6.P00000.LP000004
DSNU400I 095 17:51:36.70 DSNUBBID - COPY PROCESSED FOR TABLESPACE R1128C30.T128P2L6
NUMBER OF PAGES=21
AVERAGE PERCENT FREE SPACE PER PAGE = 1.00
PERCENT OF CHANGED PAGES = 0.00
ELAPSED TIME=00:00:04
DSNU428I *DEND 095 17:51:36.73 DSNUBAFI - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE R1128C30.T128P2L6
DSNU010I 095 17:51:36.73 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
0:-SYNC 003550 COPY FOR TS R1128C30.T128P2L6 COMPLETE 51434132
0:-COPY 003600
: TEMPLATE DCPYLOCP
: DSN 'RDACRJ.&UT..&SN..P&PART..LP000005'
: UNIT SYSDA
: COPY TABLESPACE R1128C30.T128P2L1
: COPYDDN (DCPYLOCP)
: 90938271
BMC16815I PARAMETERS: DEND,RD10405D
BMC16822I CONTROL PASSED TO 'DSNUTILB'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16970I CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
BMC16898I DEBUG: DSNUTILB 0
0DSNU000I 095 17:51:36.85 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
DSNU1044I 095 17:51:36.86 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 095 17:51:36.87 DSNUGUTC - TEMPLATE DCPYLOCP DSN 'RDACRJ.&UT..&SN..P&PART..LP000005' UNIT SYSDA
DSNU1035I 095 17:51:36.87 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 095 17:51:36.87 DSNUGUTC - COPY TABLESPACE R1128C30.T128P2L1 COPYDDN(DCPYLOCP)
DSNU1038I 095 17:51:36.92 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=DCPYLOCP
DDNAME=SYS00014
DSN=RDACRJ.RD10405D.T128P2L1.P00000.LP000005
DSNU400I 095 17:51:36.98 DSNUBBID - COPY PROCESSED FOR TABLESPACE R1128C30.T128P2L1
NUMBER OF PAGES=21
AVERAGE PERCENT FREE SPACE PER PAGE = 1.00
PERCENT OF CHANGED PAGES = 0.00
ELAPSED TIME=00:00:00
DSNU428I *DEND 095 17:51:37.01 DSNUBAFI - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE R1128C30.T128P2L1
DSNU010I 095 17:51:37.01 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
0:-SYNC 003650 COPY FOR TS R1128C30.T128P2L1 COMPLETE 51171988
0:-COPY 003700
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.37 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 30
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: TEMPLATE DCPYLOCP
: DSN 'RDACRJ.&UT..&SN..P&PART..LP000006'
: UNIT SYSDA
: COPY TABLESPACE R1128C30.T128P2L2
: COPYDDN (DCPYLOCP)
: 90872733
BMC16815I PARAMETERS: DEND,RD10405D
BMC16822I CONTROL PASSED TO 'DSNUTILB'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16970I CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
BMC16898I DEBUG: DSNUTILB 0
0DSNU000I 095 17:51:37.09 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
DSNU1044I 095 17:51:37.10 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 095 17:51:37.10 DSNUGUTC - TEMPLATE DCPYLOCP DSN 'RDACRJ.&UT..&SN..P&PART..LP000006' UNIT SYSDA
DSNU1035I 095 17:51:37.10 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 095 17:51:37.10 DSNUGUTC - COPY TABLESPACE R1128C30.T128P2L2 COPYDDN(DCPYLOCP)
DSNU1038I 095 17:51:37.14 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=DCPYLOCP
DDNAME=SYS00015
DSN=RDACRJ.RD10405D.T128P2L2.P00000.LP000006
DSNU400I 095 17:51:37.21 DSNUBBID - COPY PROCESSED FOR TABLESPACE R1128C30.T128P2L2
NUMBER OF PAGES=21
AVERAGE PERCENT FREE SPACE PER PAGE = 1.00
PERCENT OF CHANGED PAGES = 0.00
ELAPSED TIME=00:00:00
DSNU428I *DEND 095 17:51:37.23 DSNUBAFI - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE R1128C30.T128P2L2
DSNU010I 095 17:51:37.23 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
0:-SYNC 003750 COPY FOR TS R1128C30.T128P2L2 COMPLETE 51303060
0:-COPY 003800
: TEMPLATE DCPYLOCP
: DSN 'RDACRJ.&UT..&SN..P&PART..LP000007'
: UNIT SYSDA
: COPY TABLESPACE R1128C30.T128PBR2
: COPYDDN (DCPYLOCP)
: 93951388
BMC16815I PARAMETERS: DEND,RD10405D
BMC16822I CONTROL PASSED TO 'DSNUTILB'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16970I CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
BMC16898I DEBUG: DSNUTILB 0
0DSNU000I 095 17:51:37.33 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
DSNU1044I 095 17:51:37.34 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 095 17:51:37.35 DSNUGUTC - TEMPLATE DCPYLOCP DSN 'RDACRJ.&UT..&SN..P&PART..LP000007' UNIT SYSDA
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.37 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 31
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
DSNU1035I 095 17:51:37.35 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 095 17:51:37.35 DSNUGUTC - COPY TABLESPACE R1128C30.T128PBR2 COPYDDN(DCPYLOCP)
DSNU1038I 095 17:51:37.37 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=DCPYLOCP
DDNAME=SYS00016
DSN=RDACRJ.RD10405D.T128PBR2.P00000.LP000007
DSNU400I 095 17:51:37.46 DSNUBBID - COPY PROCESSED FOR TABLESPACE R1128C30.T128PBR2
NUMBER OF PAGES=6
AVERAGE PERCENT FREE SPACE PER PAGE = 0.00
PERCENT OF CHANGED PAGES = 33.33
ELAPSED TIME=00:00:00
DSNU428I *DEND 095 17:51:37.47 DSNUBAFI - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE R1128C30.T128PBR2
DSNU010I 095 17:51:37.48 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
0:-SYNC 003850 COPY FOR TS R1128C30.T128PBR2 COMPLETE 52031844
0:-COPY 003900
: XMLTBO RDACRJ4
: XMLTBN T@T128PBR2
: XMLCOL COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EI
: GHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: TEMPLATE DCPYLOCP
: TEMPLATE DCPYLOCP
: DSN 'RDACRJ.&UT..&SN..P&PART..LP000008'
: UNIT SYSDA
: COPY TABLESPACE XML.TS
: COPYDDN (DCPYLOCP)
: 74390147
BMC16805W HASH CHECK FAILED - COMMAND MODIFIED BY USER
BMC16815I PARAMETERS: DEND,RD10405D
BMC16822I CONTROL PASSED TO 'DSNUTILB'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16970I CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
BMC16898I DEBUG: DSNUTILB 0
0DSNU000I 095 17:51:37.57 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
DSNU1044I 095 17:51:37.58 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 095 17:51:37.58 DSNUGUTC - TEMPLATE DCPYLOCP DSN 'RDACRJ.&UT..&SN..P&PART..LP000008' UNIT SYSDA
DSNU1035I 095 17:51:37.58 DSNUJTDR - TEMPLATE STATEMENT PROCESSED SUCCESSFULLY
0DSNU050I 095 17:51:37.58 DSNUGUTC - COPY TABLESPACE R1128C30.XTXT0000 COPYDDN(DCPYLOCP)
DSNU1038I 095 17:51:37.63 DSNUGDYN - DATASET ALLOCATED. TEMPLATE=DCPYLOCP
DDNAME=SYS00017
DSN=RDACRJ.RD10405D.XTXT0000.P00000.LP000008
DSNU400I 095 17:51:37.71 DSNUBBID - COPY PROCESSED FOR TABLESPACE R1128C30.XTXT0000
NUMBER OF PAGES=4
AVERAGE PERCENT FREE SPACE PER PAGE = 0.00
PERCENT OF CHANGED PAGES = 2.22
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.37 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 32
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
ELAPSED TIME=00:00:00
DSNU428I *DEND 095 17:51:37.72 DSNUBAFI - DB2 IMAGE COPY SUCCESSFUL FOR TABLESPACE R1128C30.XTXT0000
DSNU010I 095 17:51:37.73 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
0:-SYNC 003950 COPY FOR TS R1128C30.T128PBR2 COMPLETE 52097380
0:-SYNC 004000 END OF COPY SECTION 27133996
0:***********************************************************************
0:-SETP 004050 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
: ,"SYSIBMADM" 56186103
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 004100 CREATE VIEW RDACRJ4.V5@T128PBR2
: ( COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
: HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
: CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
: CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
: CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLFL@15@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLDF@20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.37 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 33
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
: CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLC@28@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
: CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
: HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
: AS SELECT *
: FROM RDACRJ4.T@T128PBR2
: 96120416
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SETP 004150 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
: ,"SYSIBMADM" 56120567
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 004200 CREATE VIEW RDACRJ4.V4@T128PBR2
: ( COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
: HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
: CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLCL@3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
: CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLVBI@8@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
: CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLDE@13@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLNU@14@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.37 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 34
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLFL@15@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLDF@20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLDT@21@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
: CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLC@28@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@
: CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLVC@29@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT
: @CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
: HARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T )
: AS SELECT COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWEN
: TY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EI
: GHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLCL
: @3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHRACTE
: RS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLBIN@7@ONE@HUN
: DRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUND
: RED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLVBI@8@ONE@HUNDRED@TWENTY
: @EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@
: EIGHT@CHARACTERS@ONE@HUNDRED@T , COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARA
: CTERS@ONE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARA
: CTERS@ONE@HUNDRED@T , COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@
: HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@H
: UNDRED@T , COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWE
: NTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T ,
: COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
: RACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLDE@13@ON
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.37 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 35
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: E@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE
: @HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLNU@14@ONE@HUNDRED@T
: WENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TW
: ENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLFL@15@ONE@HUNDRED@TWENTY@EIGHT
: @CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@
: CHARACTERS@ONE@HUNDRED@T , COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS
: @ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@
: ONE@HUNDRED@T , COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRE
: D@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED
: @T , COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EI
: GHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLDF@
: 20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTER
: S@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLDT@21@ONE@HUND
: RED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDR
: ED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLTI@22@ONE@HUNDRED@TWENTY@
: EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@E
: IGHT@CHARACTERS@ONE@HUNDRED@T , COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARA
: CTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARAC
: TERS@ONE@HUNDRED@T , COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@H
: UNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HU
: NDRED@T , COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWEN
: TY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , C
: OLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHR
: ACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLC@28@ONE@
: HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@
: HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLVC@29@ONE@HUNDRED@TW
: ENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWE
: NTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@
: CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
: HARACTERS@ONE@HUNDRED@T , COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@
: ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
: NE@HUNDRED@T , COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: WENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@
: T
: FROM RDACRJ4.T@T128PBR2
: 71731536
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SETP 004250 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
: ,"SYSIBMADM" 56055031
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 004300 CREATE VIEW RDACRJ4.V3@T128PBR2
: AS SELECT COLC@1@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWEN
: TY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
: , COLVC@2@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EI
: GHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLCL
: @3@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHRACTE
: RS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLBIN@7@ONE@HUN
: DRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUND
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.37 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 36
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: RED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLVBI@8@ONE@HUNDRED@TWENTY
: @EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@
: EIGHT@CHARACTERS@ONE@HUNDRED@T , COLBL@9@ONE@HUNDRED@TWENTY@EIGHT@CHARA
: CTERS@ONE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARA
: CTERS@ONE@HUNDRED@T , COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@
: HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@H
: UNDRED@T , COLIN@11@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWE
: NTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T ,
: COLBI@12@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
: RACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLDE@13@ON
: E@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE
: @HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLNU@14@ONE@HUNDRED@T
: WENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TW
: ENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLFL@15@ONE@HUNDRED@TWENTY@EIGHT
: @CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@
: CHARACTERS@ONE@HUNDRED@T , COLRE@16@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS
: @ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@
: ONE@HUNDRED@T , COLDB@17@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRE
: D@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED
: @T , COLDF@19@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EI
: GHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLDF@
: 20@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTER
: S@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLDT@21@ONE@HUND
: RED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDR
: ED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLTI@22@ONE@HUNDRED@TWENTY@
: EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@E
: IGHT@CHARACTERS@ONE@HUNDRED@T , COLTS@23@ONE@HUNDRED@TWENTY@EIGHT@CHARA
: CTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARAC
: TERS@ONE@HUNDRED@T , COLTS@24@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@H
: UNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HU
: NDRED@T , COLTS@25@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWEN
: TY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , C
: OLC@26@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHR
: ACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLC@28@ONE@
: HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHRACTERS@ONE@
: HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLVC@29@ONE@HUNDRED@TW
: ENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWE
: NTY@EIGHT@CHARACTERS@ONE@HUNDRED@T , COLVC@31@ONE@HUNDRED@TWENTY@EIGHT@
: CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@C
: HARACTERS@ONE@HUNDRED@T , COLCL@32@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@
: ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@O
: NE@HUNDRED@T, COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TW
: ENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
:
: FROM RDACRJ4.T@T128PBR2
: 65323940
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SETP 004350 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
: ,"SYSIBMADM" 55989495
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.37 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 37
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 004400 CREATE VIEW RDACRJ4.V2@T128PBR2
: AS SELECT *
: FROM RDACRJ4.T@T128PBR2
: 60777820
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SETP 004450 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
: ,"SYSIBMADM" 55923959
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 004500 CREATE VIEW RDACRJ4.V1@T128PBR2
: ( A1
: , A2
: , A3
: , A4
: , A5
: , A6
: , A7
: , A8
: , A9
: , A10
: , A11
: , A12
: , A13
: , A14
: , A15
: , A16
: , A17
: , A18
: , A19
: , A20
: , A21
: , A22
: , A23
: , A24
: , A25
: , A26
: , A27 )
: AS SELECT *
: FROM RDACRJ4.T@T128PBR2
: 58445972
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SETP 004550 SET CURRENT PATH = SYSTEM PATH 24007090
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SYNC 004600 END OF CREATE VIEW NOT DEPENDENT ON MQT SECTION 15531780
0:***********************************************************************
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.37 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 38
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
0:-SETS 004650 SET CURRENT SQLID = 'RDACRJ4' 09428037
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SETP 004700 SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC"
: ,"SYSIBMADM" 55728631
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SQL 004750 CREATE TRIGGER RDACRJ4.TR@T128PBR2
: AFTER
: UPDATE
: OF COLBIN@7@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@
: HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@H
: UNDRED@T
: ON RDACRJ4.T@T128PBR2
: REFERENCING NEW AS N@VAR
: FOR EACH ROW MODE DB2SQL
: UPDATE RDACRJ4.T@T128PBR2 SET COLSI@10@ONE@HUNDRED@TWENTY@EIGHT@CHARA
: CTERS@ONE@HUNDRED@TWENTY@EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARAC
: TERS@ONE@HUNDRED@T = 60
: WHERE COLTI@22@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY
: @EIGHT@CRACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T =
: '11.11.00'
: 71203551
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SETS 004800 SET CURRENT SQLID = USER 62553643
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SETP 004850 SET CURRENT PATH = SYSTEM PATH 24203698
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
0:-SYNC 004900 END OF TRIGGER SECTION 70815338
0:***********************************************************************
0:-RNST 004950
: RUNSTATS TABLESPACE R1128C30.T128PBR2
: HISTORY NONE
: INDEX (ALL)
: TABLE ALL
: 73962273
BMC16815I PARAMETERS: DEND,RD10405D
BMC16822I CONTROL PASSED TO 'DSNUTILB'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16970I CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
BMC16898I DEBUG: DSNUTILB 0
0DSNU000I 095 17:51:37.93 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.38 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 39
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
DSNU1044I 095 17:51:37.95 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 095 17:51:37.95 DSNUGUTC - RUNSTATS TABLESPACE R1128C30.T128PBR2 HISTORY NONE INDEX(ALL) TABLE ALL
DSNU610I *DEND 095 17:51:38.40 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR R1128C30.T128PBR2 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.41 DSNUSUPT - SYSTABSTATS CATALOG UPDATE FOR RDACRJ4.T@T128PBR2 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.43 DSNUSUPC - SYSCOLSTATS CATALOG UPDATE FOR RDACRJ4.T@T128PBR2 SUCCESSFUL
DSNU604I *DEND 095 17:51:38.43 DSNUSEF2 - TABLESPACE IS EMPTY
DSNU610I *DEND 095 17:51:38.43 DSNUSUTB - SYSTABLES CATALOG UPDATE FOR RDACRJ4.T@T128PBR2 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.45 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.T@T128PBR2 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.45 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR R1128C30.T128PBR2 SUCCESSFUL
DSNU1374I *DEND 095 17:51:38.45 DSNUSEF2 - SAMPLE SIZE USED :
ROWS SAMPLED = 0
PAGES SAMPLED = 0
SAMPLE RATE USED = 100.00
REPEATABLE = 0
DSNU610I *DEND 095 17:51:38.45 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I_DOCIDT@T128PBR2 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.45 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR22 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.46 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR23 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.46 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR24 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.46 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR21 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.46 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR25 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.46 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR26 SUCCESSFUL
DSNU604I *DEND 095 17:51:38.46 DSNUSEOF - INDEXSPACE IS EMPTY
DSNU610I *DEND 095 17:51:38.46 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.I_DOCIDT@T128PBR2 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.46 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I_DOCIDT@T128PBR2 SUCCESSFUL
DSNU604I *DEND 095 17:51:38.46 DSNUSEOF - INDEXSPACE IS EMPTY
DSNU610I *DEND 095 17:51:38.46 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.I@T128PBR22 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.46 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR22 SUCCESSFUL
DSNU604I *DEND 095 17:51:38.46 DSNUSEOF - INDEXSPACE IS EMPTY
DSNU610I *DEND 095 17:51:38.46 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.I@T128PBR23 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.46 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR23 SUCCESSFUL
DSNU604I *DEND 095 17:51:38.46 DSNUSEOF - INDEXSPACE IS EMPTY
DSNU610I *DEND 095 17:51:38.46 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.I@T128PBR24 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.46 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR24 SUCCESSFUL
DSNU604I *DEND 095 17:51:38.46 DSNUSEOF - INDEXSPACE IS EMPTY
DSNU610I *DEND 095 17:51:38.46 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.I@T128PBR21 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.46 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR21 SUCCESSFUL
DSNU604I *DEND 095 17:51:38.46 DSNUSEOF - INDEXSPACE IS EMPTY
DSNU610I *DEND 095 17:51:38.47 DSNUSUKT - SYSKEYTARGETS CATALOG UPDATE FOR RDACRJ4.I@T128PBR25 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.47 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR25 SUCCESSFUL
DSNU604I *DEND 095 17:51:38.47 DSNUSEOF - INDEXSPACE IS EMPTY
DSNU610I *DEND 095 17:51:38.47 DSNUSUKT - SYSKEYTARGETS CATALOG UPDATE FOR RDACRJ4.I@T128PBR26 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.47 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR26 SUCCESSFUL
DSNU620I *DEND 095 17:51:38.47 DSNUSEOF - RUNSTATS CATALOG TIMESTAMP = 2022-04-05-17.51.37.963050
DSNU010I 095 17:51:38.48 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
0:-SYNC 005000 STATS FOR TS R1128C30.T128PBR2 COMPLETE 60041444
0:-RNST 005050
: XMLTBO RDACRJ4
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.38 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 40
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: XMLTBN T@T128PBR2
: XMLCOL COLXML@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@TWENTY@EI
: GHT@CHARACTERS@ONE@HUNDRED@TWENTY@EIGHT@CHARACTERS@ONE@HUNDRED@T
:
:
: RUNSTATS TABLESPACE XML.TS
: HISTORY NONE
: INDEX (ALL)
: TABLE ALL
: 15001993
BMC16805W HASH CHECK FAILED - COMMAND MODIFIED BY USER
BMC16815I PARAMETERS: DEND,RD10405D
BMC16822I CONTROL PASSED TO 'DSNUTILB'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16970I CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
BMC16898I DEBUG: DSNUTILB 0
0DSNU000I 095 17:51:38.57 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
DSNU1044I 095 17:51:38.58 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 095 17:51:38.58 DSNUGUTC - RUNSTATS TABLESPACE R1128C30.XTXT0000 HISTORY NONE INDEX(ALL) TABLE ALL
DSNU610I *DEND 095 17:51:38.62 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR R1128C30.XTXT0000 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.62 DSNUSUPT - SYSTABSTATS CATALOG UPDATE FOR RDACRJ4.XT@T128PBR2 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.62 DSNUSUPC - SYSCOLSTATS CATALOG UPDATE FOR RDACRJ4.XT@T128PBR2 SUCCESSFUL
DSNU604I *DEND 095 17:51:38.62 DSNUSEF2 - TABLESPACE IS EMPTY
DSNU610I *DEND 095 17:51:38.62 DSNUSUTB - SYSTABLES CATALOG UPDATE FOR RDACRJ4.XT@T128PBR2 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.62 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.XT@T128PBR2 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.63 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR R1128C30.XTXT0000 SUCCESSFUL
DSNU1374I *DEND 095 17:51:38.63 DSNUSEF2 - SAMPLE SIZE USED :
ROWS SAMPLED = 0
PAGES SAMPLED = 0
SAMPLE RATE USED = 100.00
REPEATABLE = 0
DSNU610I *DEND 095 17:51:38.63 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I_NODEIDXT@T128PBR2 SUCCESSFUL
DSNU604I *DEND 095 17:51:38.63 DSNUSEOF - INDEXSPACE IS EMPTY
DSNU610I *DEND 095 17:51:38.63 DSNUSUKT - SYSKEYTARGETS CATALOG UPDATE FOR RDACRJ4.I_NODEIDXT@T128PBR2 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.63 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I_NODEIDXT@T128PBR2 SUCCESSFUL
DSNU620I *DEND 095 17:51:38.63 DSNUSEOF - RUNSTATS CATALOG TIMESTAMP = 2022-04-05-17.51.38.594650
DSNU010I 095 17:51:38.64 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
0:-SYNC 005100 STATS FOR TS R1128C30.T128PBR2 COMPLETE 59975908
0:-RNST 005150
: RUNSTATS TABLESPACE R1128C30.T128P2L3
: HISTORY NONE
: INDEX (ALL)
: 66232122
BMC16815I PARAMETERS: DEND,RD10405D
BMC16822I CONTROL PASSED TO 'DSNUTILB'
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.38 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 41
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16970I CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
BMC16898I DEBUG: DSNUTILB 0
0DSNU000I 095 17:51:38.74 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
DSNU1044I 095 17:51:38.76 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 095 17:51:38.77 DSNUGUTC - RUNSTATS TABLESPACE R1128C30.T128P2L3 HISTORY NONE INDEX(ALL)
DSNU610I *DEND 095 17:51:38.81 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR R1128C30.T128P2L3 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.81 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR R1128C30.T128P2L3 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.81 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L3 SUCCESSFUL
DSNU604I *DEND 095 17:51:38.81 DSNUSEOF - INDEXSPACE IS EMPTY
DSNU610I *DEND 095 17:51:38.81 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L3 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.81 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L3 SUCCESSFUL
DSNU620I *DEND 095 17:51:38.81 DSNUSEOF - RUNSTATS CATALOG TIMESTAMP = 2022-04-05-17.51.38.782912
DSNU010I 095 17:51:38.82 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
0:-SYNC 005200 STATS FOR TS R1128C30.T128P2L3 COMPLETE 45003036
0:-RNST 005250
: RUNSTATS TABLESPACE R1128C30.T128P2L4
: HISTORY NONE
: INDEX (ALL)
: 66297659
BMC16815I PARAMETERS: DEND,RD10405D
BMC16822I CONTROL PASSED TO 'DSNUTILB'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16970I CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
BMC16898I DEBUG: DSNUTILB 0
0DSNU000I 095 17:51:38.92 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
DSNU1044I 095 17:51:38.94 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 095 17:51:38.94 DSNUGUTC - RUNSTATS TABLESPACE R1128C30.T128P2L4 HISTORY NONE INDEX(ALL)
DSNU610I *DEND 095 17:51:38.97 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR R1128C30.T128P2L4 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.97 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR R1128C30.T128P2L4 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.97 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L4 SUCCESSFUL
DSNU604I *DEND 095 17:51:38.97 DSNUSEOF - INDEXSPACE IS EMPTY
DSNU610I *DEND 095 17:51:38.97 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L4 SUCCESSFUL
DSNU610I *DEND 095 17:51:38.97 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L4 SUCCESSFUL
DSNU620I *DEND 095 17:51:38.98 DSNUSEOF - RUNSTATS CATALOG TIMESTAMP = 2022-04-05-17.51.38.948891
DSNU010I 095 17:51:38.98 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
0:-SYNC 005300 STATS FOR TS R1128C30.T128P2L4 COMPLETE 45068828
0:-RNST 005350
: RUNSTATS TABLESPACE R1128C30.T128P2L5
: HISTORY NONE
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.39 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 42
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
: INDEX (ALL)
: 66363196
BMC16815I PARAMETERS: DEND,RD10405D
BMC16822I CONTROL PASSED TO 'DSNUTILB'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16970I CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
BMC16898I DEBUG: DSNUTILB 0
0DSNU000I 095 17:51:39.07 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
DSNU1044I 095 17:51:39.09 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 095 17:51:39.09 DSNUGUTC - RUNSTATS TABLESPACE R1128C30.T128P2L5 HISTORY NONE INDEX(ALL)
DSNU610I *DEND 095 17:51:39.13 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR R1128C30.T128P2L5 SUCCESSFUL
DSNU610I *DEND 095 17:51:39.13 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR R1128C30.T128P2L5 SUCCESSFUL
DSNU610I *DEND 095 17:51:39.13 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L5 SUCCESSFUL
DSNU604I *DEND 095 17:51:39.13 DSNUSEOF - INDEXSPACE IS EMPTY
DSNU610I *DEND 095 17:51:39.13 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L5 SUCCESSFUL
DSNU610I *DEND 095 17:51:39.13 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L5 SUCCESSFUL
DSNU620I *DEND 095 17:51:39.13 DSNUSEOF - RUNSTATS CATALOG TIMESTAMP = 2022-04-05-17.51.39.108672
DSNU010I 095 17:51:39.14 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
0:-SYNC 005400 STATS FOR TS R1128C30.T128P2L5 COMPLETE 45134620
0:-RNST 005450
: RUNSTATS TABLESPACE R1128C30.T128P2L6
: HISTORY NONE
: INDEX (ALL)
: 66428733
BMC16815I PARAMETERS: DEND,RD10405D
BMC16822I CONTROL PASSED TO 'DSNUTILB'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16970I CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
BMC16898I DEBUG: DSNUTILB 0
0DSNU000I 095 17:51:39.23 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
DSNU1044I 095 17:51:39.24 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 095 17:51:39.25 DSNUGUTC - RUNSTATS TABLESPACE R1128C30.T128P2L6 HISTORY NONE INDEX(ALL)
DSNU610I *DEND 095 17:51:39.29 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR R1128C30.T128P2L6 SUCCESSFUL
DSNU610I *DEND 095 17:51:39.29 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR R1128C30.T128P2L6 SUCCESSFUL
DSNU610I *DEND 095 17:51:39.29 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L6 SUCCESSFUL
DSNU604I *DEND 095 17:51:39.29 DSNUSEOF - INDEXSPACE IS EMPTY
DSNU610I *DEND 095 17:51:39.29 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L6 SUCCESSFUL
DSNU610I *DEND 095 17:51:39.29 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L6 SUCCESSFUL
DSNU620I *DEND 095 17:51:39.30 DSNUSEOF - RUNSTATS CATALOG TIMESTAMP = 2022-04-05-17.51.39.264362
DSNU010I 095 17:51:39.30 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
0:-SYNC 005500 STATS FOR TS R1128C30.T128P2L6 COMPLETE 45200412
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.39 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 43
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
0:-RNST 005550
: RUNSTATS TABLESPACE R1128C30.T128P2L1
: HISTORY NONE
: INDEX (ALL)
: 66494264
BMC16815I PARAMETERS: DEND,RD10405D
BMC16822I CONTROL PASSED TO 'DSNUTILB'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16970I CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
BMC16898I DEBUG: DSNUTILB 0
0DSNU000I 095 17:51:39.41 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
DSNU1044I 095 17:51:39.43 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 095 17:51:39.43 DSNUGUTC - RUNSTATS TABLESPACE R1128C30.T128P2L1 HISTORY NONE INDEX(ALL)
DSNU610I *DEND 095 17:51:39.48 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR R1128C30.T128P2L1 SUCCESSFUL
DSNU610I *DEND 095 17:51:39.48 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR R1128C30.T128P2L1 SUCCESSFUL
DSNU610I *DEND 095 17:51:39.49 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L1 SUCCESSFUL
DSNU604I *DEND 095 17:51:39.49 DSNUSEOF - INDEXSPACE IS EMPTY
DSNU610I *DEND 095 17:51:39.49 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L1 SUCCESSFUL
DSNU610I *DEND 095 17:51:39.49 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L1 SUCCESSFUL
DSNU620I *DEND 095 17:51:39.49 DSNUSEOF - RUNSTATS CATALOG TIMESTAMP = 2022-04-05-17.51.39.441871
DSNU010I 095 17:51:39.50 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
0:-SYNC 005600 STATS FOR TS R1128C30.T128P2L1 COMPLETE 45264668
0:-RNST 005650
: RUNSTATS TABLESPACE R1128C30.T128P2L2
: HISTORY NONE
: INDEX (ALL)
: 66559801
BMC16815I PARAMETERS: DEND,RD10405D
BMC16822I CONTROL PASSED TO 'DSNUTILB'
BMC16898I DEBUG: CONNECTED WITH USER: RDACRJ
BMC16970I CURRENT SQLID REESTABLISHED VIA: SET CURRENT SQLID = USER
BMC16898I DEBUG: DSNUTILB 0
0DSNU000I 095 17:51:39.60 DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = RD10405D
DSNU1044I 095 17:51:39.61 DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I 095 17:51:39.62 DSNUGUTC - RUNSTATS TABLESPACE R1128C30.T128P2L2 HISTORY NONE INDEX(ALL)
DSNU610I *DEND 095 17:51:39.66 DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR R1128C30.T128P2L2 SUCCESSFUL
DSNU610I *DEND 095 17:51:39.66 DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR R1128C30.T128P2L2 SUCCESSFUL
DSNU610I *DEND 095 17:51:39.66 DSNUSUIP - SYSINDEXPART CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L2 SUCCESSFUL
DSNU604I *DEND 095 17:51:39.66 DSNUSEOF - INDEXSPACE IS EMPTY
DSNU610I *DEND 095 17:51:39.66 DSNUSUCO - SYSCOLUMNS CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L2 SUCCESSFUL
DSNU610I *DEND 095 17:51:39.67 DSNUSUIX - SYSINDEXES CATALOG UPDATE FOR RDACRJ4.I@T128PBR2L2 SUCCESSFUL
1 **** B M C E X E C U T I O N F O R D B 2 ****
**** V E R S I O N: V13.01.00
(C) COPYRIGHT 1991 - 2022 BMC SOFTWARE, INC.
2022-04-05 17.51.39 ON SYSID DB2B WORKLIST EXECUTION LOG PAGE 44
0------------------------------------------------------------------------------------------------------------------------------------
LINE PREFIX : DENOTES WORKLIST INPUT STATEMENTS
------------------------------------------------------------------------------------------------------------------------------------
DSNU620I *DEND 095 17:51:39.67 DSNUSEOF - RUNSTATS CATALOG TIMESTAMP = 2022-04-05-17.51.39.628859
DSNU010I 095 17:51:39.67 DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0
0:-SYNC 005700 STATS FOR TS R1128C30.T128P2L2 COMPLETE 45330460
0:-SYNC 005750 END OF TABLESPACE STATISTICS SECTION 92291657
0:***********************************************************************
BMC16999I UPDATED WORKID STATUS FOR RD10405D IS 'C' (COMPLETE)
0BMC16833I END OF WORKLIST EXECUTION