Example 21 — Loading LOB and XML data

This example is a LOAD REPLACE of a partitioned table space that contains LOB and XML columns.

The table space has the following indexes:

  • A non-unique clustering index
  • A unique index on the row ID column
  • A document ID index (because the table contains an XML column)

Also participating in this job are the following table spaces:

  • Four LOB table spaces and their auxiliary indexes
  • An implicitly created XML table space and its node ID index

Related topics

SHRLEVEL considerations

Additional FORMAT BMCUNLOAD restrictions and considerations

Examples of LOADPLUS jobs

This job loads LOB and XML data from referenced files. The SYSREC in this example shows the referenced file names, and the field specification shows the use of BLOBF and CLOBF with the CHAR data type for the LOB and XML data.

Dynamic allocation is active for primary copies of the base table space, the LOB table spaces, and the XML table space. LOADPLUS produces a copy for each table space, and COPYLVL FULL tells LOADPLUS to produce a single copy for all partitions.

Message 50041I indicates the status of zIIP processing. For this example, the ZIIP installation option is ENABLED, but an XBM subsystem was not specified. LOADPLUS automatically located an available XBM subsystem to provide zIIP processing.

The following figure shows the DDL for example 21:

//        JOBCARD
//********************** AMUEX21 *************************************
//********************************************************************
//*******           Loading LOB and XML data       *******************
//********************************************************************
//*  Replace "DB2SYS" by your DB2 subsystem name.                     *
//*  Use your DB2 product install libraries for STEPLIBS :            *
//*     PRODUCT.LIBRARIES                                             *
//*     DB2.DSNEXIT                                                   *
//*     DB2.DSNLOAD                                                   *
//*==================================================================
//CREATDDL EXEC PGM=IKJEFT01,REGION=4096K
//STEPLIB  DD   DISP=SHR,DSN=DB2.DSNEXIT
//         DD   DISP=SHR,DSN=DB2.DSNLOAD
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN  DD *
  DSN SYSTEM(DB2SYS)
  RUN PROGRAM(DSNTEP2)
  END
//SYSIN    DD  *
CREATE DATABASE D2UDSSL4;
 COMMIT ;

CREATE TABLESPACE S2UDSSL4 IN D2UDSSL4
   USING STOGROUP SYSDEFLT
   COMPRESS NO
   BUFFERPOOL BP32K
   NUMPARTS  2;
 COMMIT;


CREATE TABLE AMU.TABLE_AMU_MIXED_NO_TABLE_PARTITION
  (COL_INTEGER     INTEGER,
   COL2_CLOB       CLOB(10M) FOR SBCS DATA ,
   COL3_BLOB       BLOB(10M),
   COL4_XML        XML,
   COL5_ROWID      ROWID NOT NULL GENERATED ALWAYS
  )
  IN D2UDSSL4.S2UDSSL4
   PARTITION BY
   ( COL_INTEGER )
       (PARTITION  1 ENDING AT (      3500),
        PARTITION  2 ENDING AT (2147483646)
       );

   CREATE INDEX AMU.IXLOBMN4
             ON AMU.TABLE_AMU_MIXED_NO_TABLE_PARTITION
           ( COL_INTEGER )
             USING STOGROUP SYSDEFLT
                   PRIQTY    1200
                   SECQTY   1200
                   ERASE NO
             FREEPAGE    0
             PCTFREE  5
             GBPCACHE CHANGED
             BUFFERPOOL BP0
             CLOSE YES
             CLUSTER;
  COMMIT;

   CREATE UNIQUE INDEX AMU.IXLOBRI4
             ON AMU.TABLE_AMU_MIXED_NO_TABLE_PARTITION
           ( COL5_ROWID ) ;
 COMMIT;

 CREATE LOB TABLESPACE SLLBS401 IN D2UDSSL4
   USING STOGROUP SYSDEFLT
   BUFFERPOOL BP0
   DSSIZE 1G;
 COMMIT;

 CREATE AUX TABLE AMU.AUXTABLE_FOR_CLOB_AMU_MIXED_NO_TABLE_PARTITION_1
    IN D2UDSSL4.SLLBS401
    STORES AMU.TABLE_AMU_MIXED_NO_TABLE_PARTITION
    COLUMN COL2_CLOB PART 1;
 COMMIT ;

 CREATE UNIQUE INDEX AMU.IXD2L401
        ON AMU.AUXTABLE_FOR_CLOB_AMU_MIXED_NO_TABLE_PARTITION_1
        USING STOGROUP SYSDEFLT;
 COMMIT;

 CREATE LOB TABLESPACE SLLBS402 IN D2UDSSL4
   USING STOGROUP SYSDEFLT
   BUFFERPOOL BP16K0
   DSSIZE 2G;
 COMMIT;

 CREATE AUX TABLE AMU.AUXTABLE_FOR_CLOB_AMU_MIXED_NO_TABLE_PARTITION_2
    IN D2UDSSL4.SLLBS402
    STORES AMU.TABLE_AMU_MIXED_NO_TABLE_PARTITION
    COLUMN COL2_CLOB PART 2;
 COMMIT ;

 CREATE UNIQUE INDEX AMU.IXD2L402
        ON AMU.AUXTABLE_FOR_CLOB_AMU_MIXED_NO_TABLE_PARTITION_2
        USING STOGROUP SYSDEFLT;
 COMMIT;

 CREATE LOB TABLESPACE SLLBS411 IN D2UDSSL4
   USING STOGROUP SYSDEFLT
   BUFFERPOOL BP16K0
   DSSIZE 8G;
 COMMIT;

 CREATE AUX TABLE AMU.AUXTABLE_FOR_BLOB_AMU_MIXED_NO_TABLE_PARTITION_1
    IN D2UDSSL4.SLLBS411
    STORES AMU.TABLE_AMU_MIXED_NO_TABLE_PARTITION
    COLUMN COL3_BLOB PART 1;
 COMMIT ;

 CREATE UNIQUE INDEX AMU.IXD2L411
        ON AMU.AUXTABLE_FOR_BLOB_AMU_MIXED_NO_TABLE_PARTITION_1
        USING STOGROUP SYSDEFLT;
 COMMIT;

 CREATE LOB TABLESPACE SLLBS412 IN D2UDSSL4
   USING STOGROUP SYSDEFLT
   BUFFERPOOL BP16K0
   DSSIZE 16G;
 COMMIT;

 CREATE AUX TABLE AMU.AUXTABLE_FOR_BLOB_AMU_MIXED_NO_TABLE_PARTITION_2
    IN D2UDSSL4.SLLBS412
    STORES AMU.TABLE_AMU_MIXED_NO_TABLE_PARTITION
    COLUMN COL3_BLOB PART 2;
 COMMIT ;

 CREATE UNIQUE INDEX AMU.IXD2L412
        ON AMU.AUXTABLE_FOR_BLOB_AMU_MIXED_NO_TABLE_PARTITION_2
        USING STOGROUP SYSDEFLT;
 COMMIT;
/*

The following figure shows the JCL for example 21:

///BMCLOAD1 EXEC PGM=AMUUMAIN,
//            PARM='DB2SYS,AMUEX21,NEW,,MSGLEVEL(1)'
//STEPLIB  DD DISP=SHR,DSN=PRODUCT.LIBRARIES
//         DD DSN=DB2.DSNEXIT,DISP=SHR
//         DD DSN=DB2.DSNLOAD,DISP=SHR
//SYSPRINT DD DSN=AMU.EXAMPL21.SYSPRINT,
//           UNIT=SYSDA,SPACE=(CYL,(1,1)),DISP=(NEW,CATLG)
//UTPRINT  DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSUT1   DD UNIT=WORK,SPACE=(CYL,(20,10)),DISP=(NEW,DELETE)
//SORTOUT  DD UNIT=WORK,SPACE=(CYL,(20,10)),DISP=(NEW,PASS)
//SORTWK01 DD UNIT=WORK,SPACE=(CYL,(20,10)),DISP=(NEW,PASS)
//SORTWK02 DD UNIT=WORK,SPACE=(CYL,(20,10)),DISP=(NEW,PASS)
//SORTWK03 DD UNIT=WORK,SPACE=(CYL,(20,10)),DISP=(NEW,PASS)
//SORTWK04 DD UNIT=WORK,SPACE=(CYL,(20,10)),DISP=(NEW,PASS)
//SYSERR   DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,DELETE)
//SYSDISC  DD UNIT=WORK,SPACE=(CYL,(1,1)),DISP=(NEW,DELETE)
//*
//SYSREC   DD DSN=AMU.INPUT.EXAMPL21.SYSREC,DISP=SHR
//SYSIN    DD  *
LOAD DATA INDDN SYSREC
REPLACE
    COPY YES
    EBCDIC CCSID(37,65534,65534)
  INTO TABLE

  AMU.TABLE_AMU_MIXED_NO_TABLE_PARTITION
      (
   COL_INTEGER POSITION(1:4) INTEGER
   ,COL2_CLOB POSITION(5:47)   CHAR   CLOBF
   ,COL3_BLOB POSITION(48:83)  CHAR   BLOBF
   ,COL4_XML  POSITION(84:109) CHAR   CLOBF
  )

DDTYPE    LOCPFCPY ACTIVE YES DSNPAT
                          'AMU.EXAMP022.LOCPFCPY.&DDNAME'
DDTYPE    LOCPLCPY ACTIVE YES DSNPAT
                  'AMU.EXAMP022.LOCPLCPY.&DDNAME'
          UNIT CART
DDTYPE    LOCPXCPY ACTIVE YES DSNPAT
                  'AMU.EXAMP022.LOCPXCPY.&DDNAME'
          UNIT CART
//

SYSREC for example 21

The following figure shows a portion of the SYSREC for example 21:

....ADU.VQA.EBCDIC.CLOB.F0T1BYTE.DATA(CLOB0001)ADU.VQA.BLOB.F0T1BYTE.DATA(BLOB0001)ADU.VQA.XML.DATA(XMLL3201)
....ADU.VQA.EBCDIC.CLOB.F0T1BYTE.DATA(CLOB0002)ADU.VQA.BLOB.F0T1BYTE.DATA(BLOB0002)ADU.VQA.XML.DATA(XMLL3202)
....ADU.VQA.EBCDIC.CLOB.F0T1BYTE.DATA(CLOB0003)ADU.VQA.BLOB.F0T1BYTE.DATA(BLOB0003)ADU.VQA.XML.DATA(XMLL3203)
....ADU.VQA.EBCDIC.CLOB.F0T1BYTE.DATA(CLOB0004)ADU.VQA.BLOB.F0T1BYTE.DATA(BLOB0004)ADU.VQA.XML.DATA(XMLL3204)
....ADU.VQA.EBCDIC.CLOB.F0T1BYTE.DATA(CLOB0005)ADU.VQA.BLOB.F0T1BYTE.DATA(BLOB0001)ADU.VQA.XML.DATA(XMLL3205)
....ADU.VQA.EBCDIC.CLOB.F0T1BYTE.DATA(CLOB0006)ADU.VQA.BLOB.F0T1BYTE.DATA(BLOB0002)ADU.VQA.XML.DATA(XMLL3206)
....ADU.VQA.EBCDIC.CLOB.F0T1BYTE.DATA(CLOB0007)ADU.VQA.BLOB.F0T1BYTE.DATA(BLOB0003)ADU.VQA.XML.DATA(XMLL3207)
....ADU.VQA.EBCDIC.CLOB.F0T1BYTE.DATA(CLOB0008)ADU.VQA.BLOB.F0T1BYTE.DATA(BLOB0004)ADU.VQA.XML.DATA(XMLL3208)
....ADU.VQA.EBCDIC.CLOB.F0T1BYTE.DATA(CLOB0001)ADU.VQA.BLOB.F0T1BYTE.DATA(BLOB0001)ADU.VQA.XML.DATA(XMLL3201)
....ADU.VQA.EBCDIC.CLOB.F0T1BYTE.DATA(CLOB0002)ADU.VQA.BLOB.F0T1BYTE.DATA(BLOB0002)ADU.VQA.XML.DATA(XMLL3202)
....ADU.VQA.EBCDIC.CLOB.F0T1BYTE.DATA(CLOB0003)ADU.VQA.BLOB.F0T1BYTE.DATA(BLOB0003)ADU.VQA.XML.DATA(XMLL3203)
....ADU.VQA.EBCDIC.CLOB.F0T1BYTE.DATA(CLOB0004)ADU.VQA.BLOB.F0T1BYTE.DATA(BLOB0004)ADU.VQA.XML.DATA(XMLL3204)
....ADU.VQA.EBCDIC.CLOB.F0T1BYTE.DATA(CLOB0005)ADU.VQA.BLOB.F0T1BYTE.DATA(BLOB0001)ADU.VQA.XML.DATA(XMLL3205)
....ADU.VQA.EBCDIC.CLOB.F0T1BYTE.DATA(CLOB0006)ADU.VQA.BLOB.F0T1BYTE.DATA(BLOB0002)ADU.VQA.XML.DATA(XMLL3206)
....ADU.VQA.EBCDIC.CLOB.F0T1BYTE.DATA(CLOB0007)ADU.VQA.BLOB.F0T1BYTE.DATA(BLOB0003)ADU.VQA.XML.DATA(XMLL3207)
....ADU.VQA.EBCDIC.CLOB.F0T1BYTE.DATA(CLOB0008)ADU.VQA.BLOB.F0T1BYTE.DATA(BLOB0004)ADU.VQA.XML.DATA(XMLL3208)
...

SYSPRINT for example 21

The following figure shows the SYSPRINT output for example 21:

1                          *************  B M C   L O A D P L U S   F O R   D B 2    V13R1.00 ************
                                             (C) COPYRIGHT 1990 - 2022 BMC SOFTWARE, INC.
                           LOADPLUS TECHNOLOGY IS PROTECTED BY U.S. PATENT NUMBERS 7,664,790 AND 7,930,291
-BMC50001I UTILITY EXECUTION STARTING    2/15/2022    1:54:25 ...
 BMC50002I UTILITY ID = 'AMUEX21'.  DB2 SUBSYSTEM ID = 'DEJM'.  OPTION MODULE = 'AMU$OPTS'.
 BMC50471I z/OS 2.4.0,PID=HBB77C0,DFSMS FOR Z/OS=2.4.0,DB2=13.1.510
 BMC50471I REGION=0M,BELOW 16M=8824K,ABOVE 16M=1029208K,IEFUSI=NO,CPUs=7,GPs=5,zIIPs=2
 BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040296M,MEMLIMIT SET BY:REGION=0
 BMC50471I SMFID=DB2B,JOBID=J0151374,JOB=AMUEX21,STEP=BMCLOAD1,CPU=8561-615 (z15)/1.71
0
 BMC50471I LOADPLUS FOR DB2--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I DB2 UTILITIES COMMON CODE--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I SOLUTION COMMON CODE--V13.01.00 BASE
 BMC50471I   MAINT: BPJ1541  BPJ1713  BPJ2211
 BMC50471I BMCSORT ENGINE--V02.04.01
 BMC50471I   MAINT: BPJ0691  BPJ0718  BPJ0881  BPJ0922  BPJ0996  BPJ1164  BPJ1309  BPJ1386  BPJ1497  BPJ1594  BPJ1724  BPJ1809
 BMC50471I          BPJ1833  BPJ1891  BPJ1905  BPJ2109  BPJ2232  BPJ2297
 BMC50471I BMC STATS API--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I EXTENDED BUFFER MANAGER--V06.02.01
 BMC50471I   MAINT: BPE0443  BPE0445  BPE0447  BPE0449  BPE0450  BPE0451  BPE0452  BPE0455  BPE0456  BPE0457  BPE0460  BPE0463
 BMC50471I          BPE0467  BPE0468  BPE0469  BPE0473  BPE0474  BPE0475  BPE0479  BPE0480  BPE0482  BPE0487  BPE0488  BPE0489
 BMC50471I          BPE0493  BPE0497  BPE0498  BPE0501  BPE0503  BPE0507  BPE0512  BPE0513  BPE0517  BPE0518  BPE0519  BPE0523
 BMC50471I          BPE0524  BPE0527  BPE0528  BPE0530  BPE0531  BPE0534  BPE0535  BPE0540  BPE0541  BPE0542  BPE0545  BPE0549
 BMC50471I          BPE0551  BPE0552  BPE0555  BPE0557  BPE0560
 BMC50471I High-speed Apply Engine--V13.01.00 BASE
 BMC50471I   NO MAINTENANCE TO REPORT
0
 BMC50471I APCOMMIT=2500                           FORCE=NONE                              RULES=BMC
 BMC50471I APDOPTS=                                IBUFFS=20                               SDUMP=YES
 BMC50471I APMULTIROW=100                          IDCACHE=1000                            SHORTMEMORY=CONTINUE
 BMC50471I APMXAGNT=10                             IDCDDN=SYSIDCIN                         SHRLEVEL=(NONE,NONE)
 BMC50471I APRETLIM=COUNT                          IDERROR=DISCARD                         SMAX=16
 BMC50471I APRETVAL=5                              INDDN=SYSREC                            SMCORE=(0K,0K)
 BMC50471I AUTOENUMROWS=YES                        INFORI=NO                               SORTDEVT=(,SYSALLDA)
 BMC50471I AVAILPAGEPCT=0                          INLINECP=YES                            SORTNUM=32
 BMC50471I CBUFFS=30                               INVALIDATECACHE=YES                     SQLDELAY=3
 BMC50471I CENTURY=(1950,2049)                     KEEPDICTIONARY=NO                       SQLRETRY=100
 BMC50471I CHEKPEND=YES                            LBUFFS=20                               SSIGNRPAUSE=NO
 BMC50471I COPYDDN=(BMCCPY,BMCCPZ)                 LOADDN=SORTOUT                          SSREPORT=REPORT_SWITCH
 BMC50471I COPYLVL=FULL                            LOBAVGPCT=50                            STOP@CMT=YES
 BMC50471I COPYPEND=YES                            LOCKROW=YES                             STOPDELAY=1
 BMC50471I COPYSUBSET=NO                           LONGNAMETRUNC=MIDDLE                    STOPRETRY=300
 BMC50471I DELFILES=(YES,NO)                       MAPDDN=SYSMAP                           TAPEDISP=DELETE
 BMC50471I DISCARDLIMRC=8                          MAXP=5                                  TOTALPAGEPCT=30
 BMC50471I DISCARDRC=0                             MAXSORTMEMORY=0                         TSSAMPLEPCT=100
 BMC50471I DISCDDN=SYSDISC                         MAXTAPE=3                               UPDMAXA_AUTHID=USER
 BMC50471I DRNDELAY=1                              MGEXTENT=CONTINUE                       UPDMAXA=NO
 BMC50471I DRNRETRY=255                            MINSORTMEMORY=0                         UXSTATE=SUP
 BMC50471I DRNWAIT=NONE                            MSGLEVEL=1                              WBUFFS=(20,10)
 BMC50471I DSNUEXIT=(NONE,ASM)                     OPNDB2ID=YES                            WORKDDN=SYSUT1
 BMC50471I DSNUTILB=YES                            ORIGDISP=DELETE                         WORKUNIT=SYSALLDA
 BMC50471I ENFORCE=CHECK                           PAUSEDISCARDRC=4                        WRLOG=YES
 BMC50471I ERRDDN=SYSERR                           PLAN=AMUQA                              XBLKS=3
 BMC50471I EXCLDUMP=(X37,X22,X06)                  PREFORMAT=NO                            XMLAVGSIZE=10240
 BMC50471I FASTSWITCH=NO                           PRELOAD=LOAD                            ZEROROWRC=0
 BMC50471I FILECHK=WARN                            RCVYDDN=(BMCRCY,BMCRCZ)                 ZIIP=ENABLED
 BMC50471I FORCE_AT=(START,3)                      REDEFINE=YES
 BMC50471I FORCE_RPT=NO                            RENMMAX=30
0
 BMC50471I APCOLLECTION=
 BMC50471I APOWNER=
0
 BMC50470I DDTYPE   = LOAD                               WORK                                 SORTWORK
 BMC50470I ACTIVE   = YES                                YES                                  NO
 BMC50470I IFALLOC  = USE                                USE                                  USE
 BMC50470I SMS      = NO                                 NO                                   NO
 BMC50470I SMSUNIT  = NO                                 NO                                   NO
 BMC50470I SIZEPCT  = (100,100)                          (100,100)                            (100,100)
 BMC50470I UNIT     = (SYSALLDA,SYSALLDA)                (SYSALLDA,SYSALLDA)                  (SYSALLDA,SYSALLDA)
 BMC50470I UNITCNT  = (0,0)                              (0,0)                                N/A
 BMC50470I VOLCNT   = (25,25)                            (25,25)                              N/A
 BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK))          ((30000,TRK),(30000,TRK))            N/A
 BMC50470I DSNTYPE  = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I DATACLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I MGMTCLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I STORCLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I THRESHLD = 0                                  0                                    0
 BMC50470I MAXEXTSZ = ((0,K),(0,K))                      ((0,K),(0,K))                        N/A
 BMC50470I EXPDT    = N/A                                N/A                                  N/A
 BMC50470I RETPD    = N/A                                N/A                                  N/A
 BMC50470I GDGLIMIT = N/A                                N/A                                  N/A
 BMC50470I GDGEMPTY = N/A                                N/A                                  N/A
 BMC50470I GDGSCRAT = N/A                                N/A                                  N/A
0
 BMC50470I DDTYPE   = ERROR                              DISCARD                              LOCPFCPY
 BMC50470I ACTIVE   = YES                                YES                                  YES
 BMC50470I IFALLOC  = USE                                USE                                  USE
 BMC50470I SMS      = NO                                 NO                                   NO
 BMC50470I SMSUNIT  = NO                                 NO                                   NO
 BMC50470I SIZEPCT  = (100,100)                          (100,100)                            (100,100)
 BMC50470I UNIT     = (SYSALLDA,SYSALLDA)                (SYSALLDA,SYSALLDA)                  (SYSALLDA,SYSALLDA)
 BMC50470I UNITCNT  = (0,0)                              (0,0)                                (0,0)
 BMC50470I VOLCNT   = (25,25)                            (25,25)                              (25,25)
 BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK))          ((30000,TRK),(30000,TRK))            ((30000,TRK),(30000,TRK))
 BMC50470I DSNTYPE  = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I DATACLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I MGMTCLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I STORCLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I THRESHLD = 0                                  0                                    0
 BMC50470I MAXEXTSZ = ((0,K),(0,K))                      ((0,K),(0,K))                        ((0,K),(0,K))
 BMC50470I EXPDT    =
 BMC50470I RETPD    =
 BMC50470I GDGLIMIT = N/A                                N/A                                  5
 BMC50470I GDGEMPTY = N/A                                N/A                                  NO
 BMC50470I GDGSCRAT = N/A                                N/A                                  NO
0
 BMC50470I DDTYPE   = LOCBFCPY                           REMPFCPY                             REMBFCPY
 BMC50470I ACTIVE   = NO                                 NO                                   NO
 BMC50470I IFALLOC  = USE                                USE                                  USE
 BMC50470I SMS      = NO                                 NO                                   NO
 BMC50470I SMSUNIT  = NO                                 NO                                   NO
 BMC50470I SIZEPCT  = (100,100)                          (100,100)                            (100,100)
 BMC50470I UNIT     = (SYSALLDA,SYSALLDA)                (SYSALLDA,SYSALLDA)                  (SYSALLDA,SYSALLDA)
 BMC50470I UNITCNT  = (0,0)                              (0,0)                                (0,0)
 BMC50470I VOLCNT   = (25,25)                            (25,25)                              (25,25)
 BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK))          ((30000,TRK),(30000,TRK))            ((30000,TRK),(30000,TRK))
 BMC50470I DSNTYPE  = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I DATACLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I MGMTCLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I STORCLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I THRESHLD = 0                                  0                                    0
 BMC50470I MAXEXTSZ = ((0,K),(0,K))                      ((0,K),(0,K))                        ((0,K),(0,K))
 BMC50470I EXPDT    =
 BMC50470I RETPD    =
 BMC50470I GDGLIMIT = 5                                  5                                    5
 BMC50470I GDGEMPTY = NO                                 NO                                   NO
 BMC50470I GDGSCRAT = NO                                 NO                                   NO
0
 BMC50470I DDTYPE   = SYSMAP                             LOCPLCPY                             LOCBLCPY
 BMC50470I ACTIVE   = YES                                YES                                  NO
 BMC50470I IFALLOC  = USE                                USE                                  USE
 BMC50470I SMS      = NO                                 NO                                   NO
 BMC50470I SMSUNIT  = NO                                 NO                                   NO
 BMC50470I SIZEPCT  = (100,100)                          (100,100)                            (100,100)
 BMC50470I UNIT     = (SYSALLDA,SYSALLDA)                (SYSALLDA,SYSALLDA)                  (SYSALLDA,SYSALLDA)
 BMC50470I UNITCNT  = (0,0)                              (0,0)                                (0,0)
 BMC50470I VOLCNT   = (25,25)                            (25,25)                              (25,25)
 BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK))          ((30000,TRK),(30000,TRK))            ((30000,TRK),(30000,TRK))
 BMC50470I DSNTYPE  = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I DATACLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I MGMTCLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I STORCLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I THRESHLD = 0                                  0                                    0
 BMC50470I MAXEXTSZ = ((0,K),(0,K))                      ((0,K),(0,K))                        ((0,K),(0,K))
 BMC50470I EXPDT    = N/A
 BMC50470I RETPD    = N/A
 BMC50470I GDGLIMIT = N/A                                5                                    5
 BMC50470I GDGEMPTY = N/A                                NO                                   NO
 BMC50470I GDGSCRAT = N/A                                NO                                   NO
0
 BMC50470I DDTYPE   = REMPLCPY                           REMBLCPY                             LOCPXCPY
 BMC50470I ACTIVE   = NO                                 NO                                   YES
 BMC50470I IFALLOC  = USE                                USE                                  USE
 BMC50470I SMS      = NO                                 NO                                   NO
 BMC50470I SMSUNIT  = NO                                 NO                                   NO
 BMC50470I SIZEPCT  = (100,100)                          (100,100)                            (100,100)
 BMC50470I UNIT     = (SYSALLDA,SYSALLDA)                (SYSALLDA,SYSALLDA)                  (SYSALLDA,SYSALLDA)
 BMC50470I UNITCNT  = (0,0)                              (0,0)                                (0,0)
 BMC50470I VOLCNT   = (25,25)                            (25,25)                              (25,25)
 BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK))          ((30000,TRK),(30000,TRK))            ((30000,TRK),(30000,TRK))
 BMC50470I DSNTYPE  = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I DATACLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I MGMTCLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I STORCLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I THRESHLD = 0                                  0                                    0
 BMC50470I MAXEXTSZ = ((0,K),(0,K))                      ((0,K),(0,K))                        ((0,K),(0,K))
 BMC50470I EXPDT    =
 BMC50470I RETPD    =
 BMC50470I GDGLIMIT = 5                                  5                                    5
 BMC50470I GDGEMPTY = NO                                 NO                                   NO
 BMC50470I GDGSCRAT = NO                                 NO                                   NO
0
 BMC50470I DDTYPE   = LOCBXCPY                           REMPXCPY                             REMBXCPY
 BMC50470I ACTIVE   = NO                                 NO                                   NO
 BMC50470I IFALLOC  = USE                                USE                                  USE
 BMC50470I SMS      = NO                                 NO                                   NO
 BMC50470I SMSUNIT  = NO                                 NO                                   NO
 BMC50470I SIZEPCT  = (100,100)                          (100,100)                            (100,100)
 BMC50470I UNIT     = (SYSALLDA,SYSALLDA)                (SYSALLDA,SYSALLDA)                  (SYSALLDA,SYSALLDA)
 BMC50470I UNITCNT  = (0,0)                              (0,0)                                (0,0)
 BMC50470I VOLCNT   = (25,25)                            (25,25)                              (25,25)
 BMC50470I AVGVOLSP = ((30000,TRK),(30000,TRK))          ((30000,TRK),(30000,TRK))            ((30000,TRK),(30000,TRK))
 BMC50470I DSNTYPE  = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I DATACLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I MGMTCLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I STORCLAS = (NONE,NONE)                        (NONE,NONE)                          (NONE,NONE)
 BMC50470I THRESHLD = 0                                  0                                    0
 BMC50470I MAXEXTSZ = ((0,K),(0,K))                      ((0,K),(0,K))                        ((0,K),(0,K))
 BMC50470I EXPDT    =
 BMC50470I RETPD    =
 BMC50470I GDGLIMIT = 5                                  5                                    5
 BMC50470I GDGEMPTY = NO                                 NO                                   NO
 BMC50470I GDGSCRAT = NO                                 NO                                   NO
0
 BMC50483I LOAD       DSNPAT=&UID..BMC.&TS.&DDNAME
 BMC50483I WORK       DSNPAT=&UID..BMC.&TS.&DDNAME
 BMC50483I SORTWORK   DSNPAT=NONE
 BMC50483I ERROR      DSNPAT=&UID..BMC.&TS.&DDNAME
 BMC50483I DISCARD    DSNPAT=&UID..BMC.&TS.&DDNAME
 BMC50483I SYSMAP     DSNPAT=&UID..BMC.&TS.&DDNAME
0
 BMC50483I LOCPFCPY   DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
 BMC50483I LOCBFCPY   DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
 BMC50483I REMPFCPY   DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
 BMC50483I REMBFCPY   DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
0
 BMC50483I LOCPLCPY   DSNPAT=&UID.&DDNAME.&TS..T&TIME
 BMC50483I LOCBLCPY   DSNPAT=&UID.&DDNAME.&TS..T&TIME
 BMC50483I REMPLCPY   DSNPAT=&UID.&DDNAME.&TS..T&TIME
 BMC50483I REMBLCPY   DSNPAT=&UID.&DDNAME.&TS..T&TIME
0
 BMC50483I LOCPXCPY   DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
 BMC50483I LOCBXCPY   DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
 BMC50483I REMPXCPY   DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
 BMC50483I REMBXCPY   DSNPAT=&UID.&DDNAME.&TS..F&PART..T&TIME
0

 BMC50471I DB2 DSNHDECP MODULE SETTINGS:
 BMC50471I VERSION                 = 1210
 BMC50471I SUBSYSTEM DEFAULT       = DEJM
 BMC50471I CHARACTER SET           = ALPHANUM
 BMC50471I DATE FORMAT             = USA
 BMC50471I TIME FORMAT             = USA
 BMC50471I LOCAL DATE LENGTH       = 0
 BMC50471I LOCAL TIME LENGTH       = 0
 BMC50471I DECIMAL POINT           = PERIOD
 BMC50471I DECIMAL ARITHMETIC      = 15
 BMC50471I DELIMITER               = DEFAULT
 BMC50471I SQL DELIMITER           = DEFAULT
 BMC50471I ENCODING SCHEME         = EBCDIC
 BMC50471I APPL. ENCODING SCHEME   = EBCDIC
 BMC50471I MIXED                   = NO
 BMC50471I EBCDIC CCSID            = (37,65534,65534)
 BMC50471I ASCII CCSID             = (819,65534,65534)
 BMC50471I UNICODE CCSID           = (367,1208,1200)
 BMC50471I IMPLICIT TIME ZONE      = CURRENT (-06:00)


 BMC50658I DB2 CURRENT FUNCTION LEVEL IS V12R1M509
 BMC50659I DB2 CATALOG LEVEL IS V12R1M509
 BMC50660I DB2 HIGHEST ACTIVATED FUNCTION LEVEL IS V12R1M509
 BMC50661I DB2 CODE LEVEL IS V12R1M510

 BMC50471I BMC_BMCUTIL       ='BMCUTIL.CMN_BMCUTIL'
 BMC50471I BMC_BMCSYNC       ='BMCUTIL.CMN_BMCSYNC'
 BMC50471I BMC_BMCHIST       ='BMCUTIL.CMN_BMCHIST'
 BMC50471I BMC_BMCDICT       ='BMCUTIL.CMN_BMCDICT'
 BMC50471I BMC_BMCSMARTSWITCH='BMCUTIL.CMN_BMCSWITCH'
 BMC50471I BMC_BMCSSTRACKING ='BMCUTIL.CMN_BMCSSTRACK'
0
0
 BMC50102I
 BMC50102I
 BMC50102I  LOAD DATA INDDN SYSREC
 BMC50102I  REPLACE
 BMC50102I      COPY YES
 BMC50102I      EBCDIC CCSID(37,65534,65534)
 BMC50102I    INTO TABLE
 BMC50102I
 BMC50102I    AMU.TABLE_AMU_MIXED_NO_TABLE_PARTITION
 BMC50102I        (
 BMC50102I     COL_INTEGER POSITION(1:4) INTEGER
 BMC50102I    ,COL2_CLOB POSITION(5:47)   CHAR   CLOBF
 BMC50102I    ,COL3_BLOB POSITION(48:83)  CHAR   BLOBF
 BMC50102I    ,COL4_XML  POSITION(84:109) CHAR   CLOBF
 BMC50102I    )
 BMC50102I
 BMC50102I  DDTYPE    LOCPFCPY ACTIVE YES DSNPAT
 BMC50102I                            'AMU.QA.LOCPFCPY.AMUEX21.COPY1.&SSID'
 BMC50102I  DDTYPE    LOCPLCPY ACTIVE YES DSNPAT
 BMC50102I                    'AMU.QA.LOCPLCPY.AMUEX21.COPY1.&SSID.&DDNAME'
 BMC50102I            UNIT CART
 BMC50102I  DDTYPE    LOCPXCPY ACTIVE YES DSNPAT
 BMC50102I                    'AMU.QA.LOCPXCPY.AMUEX21.COPY1.&SSID.&DDNAME'
 BMC50102I            UNIT CART

 BMC51424I ANALYZE PHASE WILL BE PERFORMED DUE TO DYNAMIC WORK FILE ALLOCATION
 BMC51421I NO FIELD SPECIFICATION FOR COLUMN 'COL5_ROWID                    '.  VALUE IS DEFAULTED
 BMC51421I NO FIELD SPECIFICATION FOR COLUMN 'DB2_GENERATED_DOCID_FOR_XML   '.  VALUE IS DEFAULTED
 BMC51561I CALCULATED NUMBER OF INPUT RECORDS = 4354 USING A SCALING FACTOR OF 100%
 BMC50109I 'TABLE CONTAINS XML' OPTION SPECIFIED.  OPTION 'INLINE YES' IGNORED
 BMC50004I UTILINIT PHASE COMPLETE.  ELAPSED TIME = 00:00:00
 BMC54003I SMARTSWITCH RULE: ALLOW_SWITCH  COMMENT: GAM CHANGED AFTER ACCIDENTAL CHANGE BY CAT

 BMC50183I SMARTSWITCH PRECLUDED FROM SWITCHING.  REASON SYSPRINT IS NOT ALLOCATED TO A JES DATA SET
 BMC50004I NGTUTIL PHASE COMPLETE.  ELAPSED TIME = 00:00:00

 BMC50199I LOAD PLUS PROCESSING CONTINUES

 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I ANALYZE PHASE COMPLETE.  ELAPSED TIME = 00:00:00

 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50425I &JOBNAME  = AMUEX21   &STEPNAME = BMCLOAD1  &DB       = D2UDSSL4  &TS       = S2UDSSL4  &UID      = BMCJXS
 BMC50425I &RESUME   = N         &REPLACE  = Y         &DATE     = 021522    &TIME     = 015425    &SSID     = DEJM
 BMC50425I &UTIL     = AMUEX21   &UTILPFX  = AMUEX21   &UTILSFX  =           &DATE8    = 02152022  &GRPNM    = DEJM
 BMC50425I &VCAT     = DEJMCAT   &TIME4    = 0154      &DATEJ    = 2022046   &JDATE    = 22046

 BMC50445I LOAD PLUS DYNAMIC FILE ALLOCATION REPORT

 BMC50446I                                                       UNIT OR                      KBYTES   KBYTES     ALOC      ALOC
 BMC50447I DDNAME   DSNAME                                       DATACLAS MGMTCLAS STORCLAS      PRI      SEC      PRI       SEC

 BMC50448I BMCCPY   AMU.QA.LOCPFCPY.AMUEX21.COPY1.DEJM           SYSALLDA                        640       64       14         2  TRK
 BMC50448I LLP00001 AMU.QA.LOCPLCPY.AMUEX21.COPY1.DEJM.LLP00001  CART                       11207200  1120720        0         0  TAP
 BMC50448I LLP00002 AMU.QA.LOCPLCPY.AMUEX21.COPY1.DEJM.LLP00002  CART                       11215920  1121592        0         0  TAP
 BMC50448I LLP00003 AMU.QA.LOCPLCPY.AMUEX21.COPY1.DEJM.LLP00003  CART                       11215920  1121592        0         0  TAP
 BMC50448I LLP00004 AMU.QA.LOCPLCPY.AMUEX21.COPY1.DEJM.LLP00004  CART                       11215920  1121592        0         0  TAP

 BMC50466W TEMPORARY DATASET NOT RECOMMENDED FOR DDNAME = 'SYSERR'
 BMC50466W TEMPORARY DATASET NOT RECOMMENDED FOR DDNAME = 'SYSDISC'
 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50474I BELOW 16M = 8424K, ABOVE 16M = 1013136K, CPUS = 5
 BMC50479I TOTAL PAGES: 12446594, ALLOWED: 3733978; AVAILABLE PAGES: 4873587, ALLOWED: 0
 BMC51499I COMBINED OPTIMIZATION, RC=0, #SORTS=2, #READERS=1, #INDEX TASKS=4, #PROBE TASKS=0, #LOB TASKS=4, #XML TASKS=2,
           TIME=2708480
 BMC51499I COMBINED OPTIMIZATION, RC=20, #SORTS=2, #READERS=1, #INDEX TASKS=3, #PROBE TASKS=0, #LOB TASKS=4, #XML TASKS=2,
           TIME=2737493
 BMC51499I COMBINED OPTIMIZATION, RC=20, #SORTS=1, #READERS=1, #INDEX TASKS=4, #PROBE TASKS=0, #LOB TASKS=4, #XML TASKS=2,
           TIME=2708480
 BMC51500I COMBINED ANALYZE, #SORTS=2, #READERS=1, #INDEX TASKS=4, #PROBE TASKS=0, #LOB TASKS=4, #XML TASKS=2
 BMC50486I 12: BMCSORT STARTED, 296K BELOW 16M, 1320K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 10: BMCSORT STARTED, 460K BELOW 16M, 1484K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 11: BMCSORT STARTED, 304K BELOW 16M, 1328K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC50486I 13: BMCSORT STARTED, 476K BELOW 16M, 1500K TOTAL MEMORY, 0 PAGES HYPERSPACE
 BMC51453I EXISTING ROWS IN TABLESPACE 'D2UDSSL4.S2UDSSL4' DELETED
 BMC50481I 1: READ TASK COMPLETE.  ELAPSED TIME = 00:00:20
 BMC51510I 1: READ TASK, XBLK XFERS = 6, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51478I PRELOAD STATISTICS:  5000 PHYSICAL (5000 LOGICAL) RECORDS READ FROM SYSREC
 BMC50482I 2: LOAD COMPLETE.  ELAPSED TIME = 00:00:16  DSN = 'DEJMCAT.DSNDBD.D2UDSSL4.S2UDSSL4.I0001.A001'
 BMC50477I 2: PARTITION =    1, ROWS/KEYS = 3500, I/O WAITS = 12 ,DDNAME = SYS00023
 BMC50482I 8: LOAD COMPLETE.  ELAPSED TIME = 00:00:20  DSN = 'DEJMCAT.DSNDBD.D2UDSSL4.XTAB0000.I0001.A002'
 BMC50477I 8: PARTITION =    2, ROWS/KEYS = 10321, I/O WAITS = 24 ,DDNAME = SYS00013
 BMC50482I 3: LOAD COMPLETE.  ELAPSED TIME = 00:00:02  DSN = 'DEJMCAT.DSNDBD.D2UDSSL4.S2UDSSL4.I0001.A002'
 BMC50477I 3: PARTITION =    2, ROWS/KEYS = 1500, I/O WAITS = 11 ,DDNAME = SYS00029
 BMC50481I 6: LOB TASK COMPLETE.  ELAPSED TIME = 00:00:21
 BMC51510I 6: LOB TASK, XBLK XFERS = 1501, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50481I 7: LOB TASK COMPLETE.  ELAPSED TIME = 00:00:21
 BMC51510I 7: LOB TASK, XBLK XFERS = 3502, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50481I 4: LOB TASK COMPLETE.  ELAPSED TIME = 00:00:21
 BMC51474I LOAD STATISTICS:  10321 ROWS LOADED INTO TABLE SPACE 'D2UDSSL4.XTAB0000' PARTITION 2
 BMC51474I LOAD STATISTICS:  1500 ROWS LOADED INTO TABLE SPACE 'D2UDSSL4.S2UDSSL4' PARTITION 2
 BMC50481I 3: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:21
 BMC51510I 4: LOB TASK, XBLK XFERS = 1501, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50481I 8: XML TASK COMPLETE.  ELAPSED TIME = 00:00:20
 BMC51510I 3: SORT TASK, XBLK XFERS = 5, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50482I 9: LOAD COMPLETE.  ELAPSED TIME = 00:00:20  DSN = 'DEJMCAT.DSNDBD.D2UDSSL4.XTAB0000.I0001.A001'
 BMC50477I 9: PARTITION =    1, ROWS/KEYS = 24054, I/O WAITS = 36 ,DDNAME = SYS00014
 BMC51510I 8: XML TASK, XBLK XFERS = 1546, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51474I LOAD STATISTICS:  3500 ROWS LOADED INTO TABLE SPACE 'D2UDSSL4.S2UDSSL4' PARTITION 1
 BMC50481I 2: DATA TASK COMPLETE.  ELAPSED TIME = 00:00:21
 BMC51474I LOAD STATISTICS:  24054 ROWS LOADED INTO TABLE SPACE 'D2UDSSL4.XTAB0000' PARTITION 1
 BMC51510I 2: SORT TASK, XBLK XFERS = 10, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50481I 5: LOB TASK COMPLETE.  ELAPSED TIME = 00:00:21
 BMC50481I 9: XML TASK COMPLETE.  ELAPSED TIME = 00:00:20
 BMC51510I 9: XML TASK, XBLK XFERS = 3607, EMPTY WAITS = 0, FULL WAITS = 0
 BMC51510I 5: LOB TASK, XBLK XFERS = 3502, EMPTY WAITS = 0, FULL WAITS = 0
 BMC50481I 10: INDEX SORT COMPLETE.  ELAPSED TIME = 00:00:21
 BMC50481I 13: INDEX SORT COMPLETE.  ELAPSED TIME = 00:00:21
 BMC50481I 11: INDEX SORT COMPLETE.  ELAPSED TIME = 00:00:21
 BMC50481I 12: INDEX SORT COMPLETE.  ELAPSED TIME = 00:00:21
 BMC50482I 11: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEJMCAT.DSNDBD.D2UDSSL4.IXD2L411.I0001.A001'
 BMC50477I 11: PARTITION =    0, ROWS/KEYS = 3500, I/O WAITS = 7 ,DDNAME = SYS00036
 BMC50482I 12: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEJMCAT.DSNDBD.D2UDSSL4.IXD2L412.I0001.A001'
 BMC50477I 12: PARTITION =    0, ROWS/KEYS = 1500, I/O WAITS = 7 ,DDNAME = SYS00035
 BMC51476I BUILD STATISTICS:  3500 KEYS LOADED INTO INDEX 'AMU.IXD2L411'
 BMC50481I 11: INDEX TASK COMPLETE.  ELAPSED TIME = 00:00:22
 BMC50482I 10: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEJMCAT.DSNDBD.D2UDSSL4.IXLOBMN4.I0001.A001'
 BMC50477I 10: PARTITION =    0, ROWS/KEYS = 5000, I/O WAITS = 7 ,DDNAME = SYS00034
 BMC51476I BUILD STATISTICS:  1500 KEYS LOADED INTO INDEX 'AMU.IXD2L412'
 BMC50481I 12: INDEX TASK COMPLETE.  ELAPSED TIME = 00:00:22
 BMC51510I 11: INDEX TASK, XBLK XFERS = 2, EMPTY WAITS = 0, FULL WAITS = 3
 BMC51510I 12: INDEX TASK, XBLK XFERS = 1, EMPTY WAITS = 0, FULL WAITS = 2
 BMC50482I 13: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEJMCAT.DSNDBD.D2UDSSL4.IRNODEID.I0001.A001'
 BMC50477I 13: PARTITION =    0, ROWS/KEYS = 56875, I/O WAITS = 10 ,DDNAME = SYS00037
 BMC51476I BUILD STATISTICS:  56875 KEYS LOADED INTO INDEX 'AMU.I_NODEIDXTABLE_AMU_MIXED_N000'
 BMC50481I 13: INDEX TASK COMPLETE.  ELAPSED TIME = 00:00:22
 BMC51510I 13: INDEX TASK, XBLK XFERS = 153, EMPTY WAITS = 0, FULL WAITS = 154
 BMC50482I 10: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEJMCAT.DSNDBD.D2UDSSL4.IRDOCIDT.I0001.A001'
 BMC50477I 10: PARTITION =    0, ROWS/KEYS = 5000, I/O WAITS = 7 ,DDNAME = SYS00043
 BMC50482I 10: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEJMCAT.DSNDBD.D2UDSSL4.IXLOBRI4.I0001.A001'
 BMC50477I 10: PARTITION =    0, ROWS/KEYS = 5000, I/O WAITS = 7 ,DDNAME = SYS00046
 BMC50482I 10: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEJMCAT.DSNDBD.D2UDSSL4.IXD2L401.I0001.A001'
 BMC50477I 10: PARTITION =    0, ROWS/KEYS = 3500, I/O WAITS = 7 ,DDNAME = SYS00049
 BMC50482I 10: BUILD COMPLETE.  ELAPSED TIME = 00:00:00  DSN = 'DEJMCAT.DSNDBD.D2UDSSL4.IXD2L402.I0001.A001'
 BMC50477I 10: PARTITION =    0, ROWS/KEYS = 1500, I/O WAITS = 7 ,DDNAME = SYS00052
 BMC51476I BUILD STATISTICS:  5000 KEYS LOADED INTO INDEX 'AMU.IXLOBMN4'
 BMC51476I BUILD STATISTICS:  5000 KEYS LOADED INTO INDEX 'AMU.I_DOCIDTABLE_AMU_MIXED_NO000'
 BMC51476I BUILD STATISTICS:  5000 KEYS LOADED INTO INDEX 'AMU.IXLOBRI4'
 BMC51476I BUILD STATISTICS:  3500 KEYS LOADED INTO INDEX 'AMU.IXD2L401'
 BMC51476I BUILD STATISTICS:  1500 KEYS LOADED INTO INDEX 'AMU.IXD2L402'
 BMC50481I 10: INDEX TASK COMPLETE.  ELAPSED TIME = 00:00:24
 BMC51510I 10: INDEX TASK, XBLK XFERS = 12, EMPTY WAITS = 0, FULL WAITS = 9
 BMC50476I DDNAME = SYSERR, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51586W MAXASSIGNEDVAL FOR IDENTITY COLUMN 'DB2_GENERATED_DOCID_FOR_XML' OF TABLE 'AMU.TABLE_AMU_MIXED_NO_TABLE_PARTITION' HAS
           BEEN RESET TO 5000.  PREVIOUS VALUE WAS 0
 BMC50476I DDNAME = SYSREC, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51507I XBLKS = 52, XFERS = 15174, EMPTY WAITS = 0, FULL WAITS =168
 BMC50476I DDNAME = SYSDISC, I/OS = 0, I/O WAITS = 0, RDB LOCK WAITS = 0
 BMC51472I COMBINED PHASE STATISTICS:  5000 ROWS SELECTED FOR SPACE 'D2UDSSL4.S2UDSSL4', 0 ROWS SELECTED BUT DISCARDED DUE TO ERRORS
 BMC51479I COMBINED PHASE STATISTICS:  0 PHYSICAL (0 LOGICAL) RECORDS DISCARDED TO SYSDISC
 BMC51474I LOAD STATISTICS:  3500 ROWS LOADED INTO TABLE SPACE 'D2UDSSL4.S2UDSSL4' PARTITION 1
 BMC51474I LOAD STATISTICS:  1500 ROWS LOADED INTO TABLE SPACE 'D2UDSSL4.S2UDSSL4' PARTITION 2
 BMC51475I LOAD STATISTICS:  5000 ROWS LOADED INTO TABLE SPACE 'D2UDSSL4.S2UDSSL4'
 BMC51474I LOAD STATISTICS:  24054 ROWS LOADED INTO TABLE SPACE 'D2UDSSL4.XTAB0000' PARTITION 1
 BMC51474I LOAD STATISTICS:  10321 ROWS LOADED INTO TABLE SPACE 'D2UDSSL4.XTAB0000' PARTITION 2
 BMC51475I LOAD STATISTICS:  34375 ROWS LOADED INTO TABLE SPACE 'D2UDSSL4.XTAB0000'
 BMC50370I STARTING 1 IMAGE COPY TASKS
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEJMCAT.DSNDBD.D2UDSSL4.S2UDSSL4.I0001.A001'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEJMCAT.DSNDBD.D2UDSSL4.S2UDSSL4.I0001.A002'
 BMC50476I DDNAME = BMCCPY, I/OS = 7, I/O WAITS = 3, RDB LOCK WAITS = 0
 BMC50376I 90 PAGES COPIED TO DATASET = 'AMU.QA.LOCPFCPY.AMUEX21.COPY1.DEJM'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEJMCAT.DSNDBD.D2UDSSL4.XTAB0000.I0001.A001'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEJMCAT.DSNDBD.D2UDSSL4.XTAB0000.I0001.A002'
 BMC50476I DDNAME = XLP00001, I/OS = 1093, I/O WAITS = 1080, RDB LOCK WAITS = 0
 BMC50376I 32505 PAGES COPIED TO DATASET = 'AMU.QA.LOCPXCPY.AMUEX21.COPY1.DEJM.XLP00001'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEJMCAT.DSNDBD.D2UDSSL4.SLLBS401.I0001.A001'
 BMC50476I DDNAME = LLP00001, I/OS = 30, I/O WAITS = 29, RDB LOCK WAITS = 0
 BMC50376I 3537 PAGES COPIED TO DATASET = 'AMU.QA.LOCPLCPY.AMUEX21.COPY1.DEJM.LLP00001'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEJMCAT.DSNDBD.D2UDSSL4.SLLBS402.I0001.A001'
 BMC50476I DDNAME = LLP00002, I/OS = 52, I/O WAITS = 50, RDB LOCK WAITS = 0
 BMC50376I 1521 PAGES COPIED TO DATASET = 'AMU.QA.LOCPLCPY.AMUEX21.COPY1.DEJM.LLP00002'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEJMCAT.DSNDBD.D2UDSSL4.SLLBS411.I0001.A001'
 BMC50476I DDNAME = LLP00003, I/OS = 119, I/O WAITS = 118, RDB LOCK WAITS = 0
 BMC50376I 3521 PAGES COPIED TO DATASET = 'AMU.QA.LOCPLCPY.AMUEX21.COPY1.DEJM.LLP00003'
 BMC50375I FULL IMAGE COPY STARTED FOR DATASET = 'DEJMCAT.DSNDBD.D2UDSSL4.SLLBS412.I0001.A001'
 BMC50476I DDNAME = LLP00004, I/OS = 52, I/O WAITS = 52, RDB LOCK WAITS = 0
 BMC50376I 1521 PAGES COPIED TO DATASET = 'AMU.QA.LOCPLCPY.AMUEX21.COPY1.DEJM.LLP00004'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSUT1  ', DSNAME = 'SYS22046.T015415.RA000.AMUEX21.R0263267'
 BMC50318I DATASET SUCCESSFULLY DELETED, DDNAME = 'SYSERR  ', DSNAME = 'SYS22046.T015415.RA000.AMUEX21.R0263273'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I COMBINED PHASE COMPLETE.  ELAPSED TIME = 00:00:44

 BMC50501I DB2 OBJECT STATISTICS
0BMC50515I TABLESPACE  D2UDSSL4.S2UDSSL4  PARTS   = 2         TABLES  = 1     SEGSIZE = 32    DSSIZE =    4G    PAGESIZE = 32K
 BMC50516I             PART  NACTIVE       CARD   EXTENTS   DBCARD PCOMP   KSAVED  PSAVED
 BMC50517I                1       49       3500         2        0     0        0       0
 BMC50517I                2       41       1500         1        0     0        0       0
 BMC50518I   TABLE     AMU.TABLE_AMU_MIXED_NO_TABLE_PARTITION
 BMC50519I             ROWAVG    NPAGES       CARD   PCTPAGES
 BMC50520I                 58        28       5000         31
0BMC50525I     INDEX   AMU.IXLOBMN4
0BMC50526I             FIRST KEY COLUMN = COL_INTEGER
0BMC50527I             CLUSTER = Y   UNIQUE = D   COMPRESS = N   PAGESIZE = 4K   KEYLEN =    5   COLCOUNT = 1
 BMC50528I             PART   NACTIVE       CARD   EXTENTS   LEVELS
 BMC50529I                0        24       5000         1        2
0BMC50525I     INDEX   AMU.I_DOCIDTABLE_AMU_MIXED_NO000
0BMC50526I             FIRST KEY COLUMN = DB2_GENERATED_DOCID_FOR_XML
0BMC50527I             CLUSTER = N   UNIQUE = N   COMPRESS = N   PAGESIZE = 4K   KEYLEN =    9   COLCOUNT = 1
 BMC50528I             PART   NACTIVE       CARD   EXTENTS   LEVELS
 BMC50529I                0        31       5000         1        2
0BMC50525I     INDEX   AMU.IXLOBRI4
0BMC50526I             FIRST KEY COLUMN = COL5_ROWID
0BMC50527I             CLUSTER = N   UNIQUE = U   COMPRESS = N   PAGESIZE = 4K   KEYLEN =   19   COLCOUNT = 1
 BMC50528I             PART   NACTIVE       CARD   EXTENTS   LEVELS
 BMC50529I                0        38       5000         1        2
0BMC50515I TABLESPACE  D2UDSSL4.XTAB0000  PARTS   = 2         TABLES  = 1     SEGSIZE = 32    DSSIZE =    4G    PAGESIZE = 16K
 BMC50516I             PART  NACTIVE       CARD   EXTENTS   DBCARD PCOMP   KSAVED  PSAVED
 BMC50517I                1    22743      24054        15        0     0        0       0
 BMC50517I                2     9762      10321        14        0     0        0       0
 BMC50518I   TABLE     AMU.XTABLE_AMU_MIXED_NO000
 BMC50519I             ROWAVG    NPAGES       CARD   PCTPAGES
 BMC50520I               9921     32502      34375         99
0BMC50525I     INDEX   AMU.I_NODEIDXTABLE_AMU_MIXED_N000
0BMC50526I             FIRST KEY COLUMN = DOCID                         
0BMC50527I             CLUSTER = Y   UNIQUE = N   COMPRESS = N   PAGESIZE = 4K   KEYLEN =  159   COLCOUNT = 2
 BMC50528I             PART   NACTIVE       CARD   EXTENTS   LEVELS
 BMC50529I                0       722      56875         3        3
0BMC50515I TABLESPACE  D2UDSSL4.SLLBS401  PARTS   = 0         TABLES  = 1     SEGSIZE = 16    DSSIZE =    1G    PAGESIZE = 4K
 BMC50516I             PART  NACTIVE       CARD   EXTENTS   DBCARD PCOMP   KSAVED  PSAVED
 BMC50517I                0     3537       3500         6        0     0        0       0
 BMC50518I   TABLE     AMU.AUXTABLE_FOR_CLOB_AMU_MIXED_NO_TABLE_PARTITION_1
 BMC50519I             ROWAVG    NPAGES       CARD   PCTPAGES
 BMC50520I                  0      3537       3500         99
0BMC50525I     INDEX   AMU.IXD2L401
0BMC50526I             FIRST KEY COLUMN = AUXID
0BMC50527I             CLUSTER = N   UNIQUE = U   COMPRESS = N   PAGESIZE = 4K   KEYLEN =   19   COLCOUNT = 2
 BMC50528I             PART   NACTIVE       CARD   EXTENTS   LEVELS
 BMC50529I                0        31       3500         1        2
0BMC50515I TABLESPACE  D2UDSSL4.SLLBS402  PARTS   = 0         TABLES  = 1     SEGSIZE = 16    DSSIZE =    2G    PAGESIZE = 16K
 BMC50516I             PART  NACTIVE       CARD   EXTENTS   DBCARD PCOMP   KSAVED  PSAVED
 BMC50517I                0     1521       1500         6        0     0        0       0
BMC50518I   TABLE     AMU.AUXTABLE_FOR_CLOB_AMU_MIXED_NO_TABLE_PARTITION_2
 BMC50519I             ROWAVG    NPAGES       CARD   PCTPAGES
 BMC50520I                  0      1521       1500         99
0BMC50525I     INDEX   AMU.IXD2L402
0BMC50526I             FIRST KEY COLUMN = AUXID
0BMC50527I             CLUSTER = N   UNIQUE = U   COMPRESS = N   PAGESIZE = 4K   KEYLEN =   19   COLCOUNT = 2
 BMC50528I             PART   NACTIVE       CARD   EXTENTS   LEVELS
 BMC50529I                0        16       1500         1        2
0BMC50515I TABLESPACE  D2UDSSL4.SLLBS411  PARTS   = 0         TABLES  = 1     SEGSIZE = 16    DSSIZE =    8G    PAGESIZE = 16K
 BMC50516I             PART  NACTIVE       CARD   EXTENTS   DBCARD PCOMP   KSAVED  PSAVED
 BMC50517I                0     3521       3500        11        0     0        0       0
 BMC50518I   TABLE     AMU.AUXTABLE_FOR_BLOB_AMU_MIXED_NO_TABLE_PARTITION_1
 BMC50519I             ROWAVG    NPAGES       CARD   PCTPAGES
 BMC50520I                  0      3521       3500         99
0BMC50525I     INDEX   AMU.IXD2L411
0BMC50526I             FIRST KEY COLUMN = AUXID
0BMC50527I             CLUSTER = N   UNIQUE = U   COMPRESS = N   PAGESIZE = 4K   KEYLEN =   19   COLCOUNT = 2
 BMC50528I             PART   NACTIVE       CARD   EXTENTS   LEVELS
 BMC50529I                0        31       3500         1        2
0BMC50515I TABLESPACE  D2UDSSL4.SLLBS412  PARTS   = 0         TABLES  = 1     SEGSIZE = 16    DSSIZE =   16G    PAGESIZE = 16K
 BMC50516I             PART  NACTIVE       CARD   EXTENTS   DBCARD PCOMP   KSAVED  PSAVED
 BMC50517I                0     1521       1500         8        0     0        0       0
 BMC50518I   TABLE     AMU.AUXTABLE_FOR_BLOB_AMU_MIXED_NO_TABLE_PARTITION_2
 BMC50519I             ROWAVG    NPAGES       CARD   PCTPAGES
 BMC50520I                  0      1521       1500         99
0BMC50525I     INDEX   AMU.IXD2L412
0BMC50526I             FIRST KEY COLUMN = AUXID
0BMC50527I             CLUSTER = N   UNIQUE = U   COMPRESS = N   PAGESIZE = 4K   KEYLEN =   19   COLCOUNT = 2
 BMC50528I             PART   NACTIVE       CARD   EXTENTS   LEVELS
 BMC50529I                0        16       1500         1        2
 BMC50290I DB2 REAL-TIME-STATISTICS -RESET STATS- FUNCTION FOR LOAD UTILITY SUCCESSFUL FOR ALL OBJECTS
 BMC50004I UTILTERM PHASE COMPLETE.  ELAPSED TIME = 00:00:00

0BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*