Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see UNLOAD PLUS for DB2 13.1.

Example 15 — Unloading LOB and XML data; using nonstandard null indicators

This example illustrates unloading LOB and XML data and using nonstandard null indicators with UNLOAD PLUS.

This example consists of the following cases:

  • Case 1 uses DIRECT NO processing and writes the LOB and XML data directly to the unload data set (SYSREC).
  • Case 2 uses DIRECT YES and specifies referenced files to which UNLOAD PLUS will write LOB and XML data.

UNLOAD PLUS automatically includes the PRESERVE WHITESPACE keywords in the Db2 LOAD control cards for the XML column (message BMC51809I). If you do not want to preserve white space during the load, change the control cards before you run them.

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

The following table describes the key command options for this job:

Command options used in JCL

Description

DIRECT NO

Tells UNLOAD PLUS to use Db2 dynamic SQL to process the SELECT statements and read the table data (case 1 only)

DIRECT YES

Tells UNLOAD PLUS to use internal processing to process the SELECT statements and read the table data (case 2 only)

FORMAT STANDARD

Provides output data in Db2 internal format except date, time, and timestamp data types, which are in external format

Either FORMAT STANDARD or FORMAT INTERNAL is required when unloading LOB or XML data.

OUTPUT

Specifies the dynamic allocation options for the referenced files (case 2 only)

DSNTYPE

Specifies the type of referenced file to which UNLOAD PLUS will load (case 2 only)

DSNAME

Specifies the data set name or data set name pattern for the referenced file (case 2 only)

SUBSETS

Specifies how many referenced files to allocate per base table space partition or per simple or segmented table space (case 2 only)

NULLTYPE L2

Specifies that the null indicator is two bytes long, preceding the column

NULLCHAR HIVAL

Tells UNLOAD PLUS to fill the null indicator field with high values

CNTLCARDS DB2LOAD 'REPLACE'

Tells UNLOAD PLUS to write Db2 LOAD control statements

UNLOAD PLUS adds 'REPLACE' to the Db2 LOAD control statement.

SELECT

Names the columns to unload

INTO

Specifies names and characteristics of output fields (case 2 only)

CLOBF

Specifies the output descriptor of the referenced file to which UNLOAD PLUS is to unload this column (case 2 only)

FROM

Specifies the table to unload

The following figure shows the JCL for example 15, case 1:

//UNLOA15A EXEC PGM=ADUUMAIN,REGION=0M,
//            PARM=(DEHJ,'ADUXM15','NEW ',,'MSGLEVEL(1)',ADU$OPTS)
//STEPLIB  DD DISP=SHR,DSN=<product.libraries>
//         DD DISP=SHR,DSN=DB2.DSNEXIT
//         DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSREC   DD DSN=ADU.EXAMP15A.SYSREC,DISP=(NEW,CATLG),
//            UNIT=SYSDA,SPACE=(CYL,(3,1),RLSE)
//SYSCNTL  DD DSN=ADU.EXAMP15A.SYSCNTL,DISP=(NEW,CATLG),
//            UNIT=SYSDA,SPACE=(CYL,(3,1),RLSE)
//UTPRINT  DD SYSOUT=*  
//SYSUDUMP DD SYSOUT=*  
//SYSPRINT DD SYSOUT=*
//*
//SYSIN    DD *  
 UNLOAD
  DIRECT NO
  FORMAT STANDARD
  NULLTYPE L2  
  NULLCHAR HIVAL  
  CNTLCARDS DB2LOAD 'REPLACE '
   SELECT   
    COL_SMALL,   
    COL_INTEGER,  
    COL_FLOAT,  
    COL_CHAR,
    COL_VCHAR,
    COL_DATE,
    COL_TIME,
    COL_TIMESTAMP,  
    COL_XML,  
    COL_CLOB  
     FROM ADU.TADU_XML4K_NULL_32K_PLUS_C
//*

The following figure shows the JCL for example 15, case 2:

//UNLOA15B EXEC PGM=ADUUMAIN,REGION=0M,
//            PARM=(DEHJ,'ADUXM15','NEW ',,'MSGLEVEL(1)',ADU$OPTS)
//STEPLIB  DD DISP=SHR,DSN=<product.libraries>
//         DD DISP=SHR,DSN=DB2.DSNEXIT
//         DD DISP=SHR,DSN=DB2.DSNLOAD
//SYSREC   DD DSN=ADU.EXAMP15B.SYSREC,DISP=(NEW,CATLG),
//            UNIT=SYSDA,SPACE=(CYL,(3,1),RLSE)
//SYSCNTL  DD DSN=ADU.EXAMP15B.SYSCNTL,DISP=(NEW,CATLG),
//            UNIT=SYSDA,SPACE=(CYL,(3,1),RLSE)
//UTPRINT  DD SYSOUT=*  
//SYSUDUMP DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//*  
//SYSIN    DD *  
 UNLOAD
  DIRECT YES
  FORMAT STANDARD
  OUTPUT CLOB01  DSNAME('ADU.EXAMP15B.CLOB')  
           DSNTYPE(PDS) DIR (100) SPACE (10,10) SUBSETS 1
           UNIT WORK  
  OUTPUT XML001  DSNAME('ADU.EXAMP15B.XML')
           DSNTYPE(PDS) DIR (100) SPACE (10,10) SUBSETS 1
           UNIT WORK
  NULLTYPE L2  
  NULLCHAR HIVAL
  CNTLCARDS DB2LOAD 'REPLACE '
   SELECT
    COL_SMALL,
    COL_INTEGER,
    COL_FLOAT,
    COL_CHAR,
    COL_VCHAR,
    COL_DATE,
    COL_TIME,
    COL_TIMESTAMP,
    COL_XML,
    COL_CLOB  
     INTO
     COL_SMALL,
     COL_INTEGER,
     COL_FLOAT,   
     COL_CHAR,
     COL_VCHAR,
     COL_DATE,
     COL_TIME,
     COL_TIMESTAMP,
     COL_XML   CHAR (45) CLOBF   XML001,
     COL_CLOB  CHAR (45) CLOBF   CLOB01
      FROM ADU.TADU_XML4K_NULL_32K_PLUS_C
//*

SYSPRINT for example 15, case 1

The following figure shows the SYSPRINT for example 15, case 1:

                                *****  B M C   U N L O A D   P L U S   F O R   D B 2    V11R1.00 *****
                                             (C) COPYRIGHT 1991 - 2013 BMC SOFTWARE, INC.
 BMC50001I UTILITY EXECUTION STARTING   10/28/2013   13:14:12 ...
 BMC50002I UTILITY ID = 'ADUXM15'.  DB2 SUBSYSTEM ID = 'DEHJ'.  OPTION MODULE = 'ADU$OPTS'.
 BMC50471I z/OS 2.1.0,PID=HBB7790,DFSMS FOR Z/OS=2.1.0,DB2=11.1.0
 BMC50471I REGION=0M,BELOW 16M=8840K,ABOVE 16M=1414792K,IEFUSI=NO,CPUS=3
 BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040313M,MEMLIMIT SET BY:REGION=0

 BMC50471I UNLOAD PLUS FOR DB2--V11.01.00
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I DB2 UTILITIES COMMON CODE--V11.01.00
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I SOLUTION COMMON CODE--V11.01.00
 BMC50471I   MAINT: BPJ0661  BPJ0667  BPJ0671  BPJ0674  BPJ0675  BPJ0676  BPJ0682  BPJ0686  BPJ0689  BPJ0697
 BMC50471I BMCSORT ENGINE--V02.04.01
 BMC50471I   MAINT: BPJ0691
 BMC50471I BMC STATS API--V11.01.00
 BMC50471I   MAINT: BPU5409  BPU5534  BPU5674
 BMC50471I EXTENDED BUFFER MANAGER--V06.01.00
 BMC50471I   MAINT: BPE0401  BPE0403  BPE0405  BPE0407  BPE0410  BPE0412  BPE0416

 BMC50471I ANALYZE=(DB2STATS,NOLIMIT)              FORCE_RPT=NO                            SMAX=16
 BMC50471I CENTURY=(1950,2049)                     FORCE=NONE                              SMCORE=(0K,0K)
 BMC50471I CHANGE_CONSISTENT=NO                    HISTORY=YES                             SORTNUM=32
 BMC50471I CHANGE_QUIESCE=NO                       IBUFFS=25                               SQLDELAY=3
 BMC50471I CMAX=16                                 INLINE=NO                               SQLRETRY=100
 BMC50471I CMRATIO=50                              LOADDECP=NO                             TAPEDISP=DELETE
 BMC50471I CONSTRULES=BMC                          LOCKROW=YES                             TASKMAX=200%
 BMC50471I CURRENTDEGREE=NONE                      MAXP=5                                  UBUFFS=25
 BMC50471I DELFILES=YES                            MSGLEVEL=1                              UNLDMAX=200%
 BMC50471I DRNDELAY=1                              NULLCHAR=X'6F'                          UNLOADDN_ACTIVE=(YES,NO)
 BMC50471I DRNRETRY=255                            NULLTYPE=T1                             UNLOADDN=(SYSREC,SYSRED)
 BMC50471I DRNWAIT=NONE                            OPNDB2ID=YES                            USELRECL=NO
 BMC50471I DSPLOCKS=DRNFAIL                        PLAN=ADUQA                              UXSTATE=SUP
 BMC50471I EXCLDUMP=(X37,X22,X06)                  RECFM=AUTO                              WORKUNIT=SYSALLDA
 BMC50471I FILEREFDN=SYSREF                        ROWSETSZ=100                            ZIIP=ENABLED
 BMC50471I FILL=NO                                 SDUMP=YES                               ZONEDDECOVP=(C,D)
 BMC50471I FORCE_AT=(START,3)                      SHRLEVEL=REFERENCE


 BMC50471I TAPES=NONE

 BMC50470I OUTPUT   = SYSREC                             SYSRED                               SYSREF
 BMC50470I UNIT     = SYSALLDA                           SYSALLDA                             SYSALLDA
 BMC50470I VOLCNT   = 25                                 25                                   25
 BMC50470I GDGLIMIT = 5                                  5                                    5
 BMC50470I GDGEMPTY = NO                                 NO                                   NO
 BMC50470I GDGSCRAT = NO                                 NO                                   NO
 BMC50470I STORCLAS = NONE                               NONE                                 NONE
 BMC50470I DATACLAS = NONE                               NONE                                 NONE
 BMC50470I MGMTCLAS = NONE                               NONE                                 NONE
 BMC50470I UNITCNT  = 0                                  0                                    0
 BMC50470I SPACE    = CYL                                CYL                                  CYL
 BMC50470I PCTPRIM  = AUTO                               AUTO                                 AUTO
 BMC50470I MAXPRIM  = 0                                  0                                    0
 BMC50470I MAXSECD  = 0                                  0                                    0
 BMC50470I FILESZPCT  100                                100                                  100
 BMC50470I NBRSECD  = AUTO                               AUTO                                 AUTO
 BMC50470I DISKRETN = NONE                               NONE                                 NONE
 BMC50470I DISKEXPD = NONE                               NONE                                 NONE
 BMC50470I RETPD    = NONE                               NONE                                 NONE
 BMC50470I EXPDT    = 99000                              99000                                99000
 BMC50470I TRTCH    = NONE                               NONE                                 NONE
 BMC50470I DSNTYPE  = NONE                               NONE                                 PDS
 BMC50483I SYSREC     VOLUMES=NONE
 BMC50483I SYSRED     VOLUMES=NONE
 BMC50483I SYSREF     VOLUMES=NONE

 BMC50483I SYSREC     DSNAME=&USERID.&TYPE.S&SELNUM
 BMC50483I SYSRED     DSNAME=&USERID.&TYPE.S&SELNUM
 BMC50483I SYSREF     DSNAME=&USERID.BMC


 BMC50471I DB2 DSNHDECP MODULE SETTINGS:
 BMC50471I VERSION                 = 1110
 BMC50471I SUBSYSTEM DEFAULT       = DEHJ
 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 (-05:00)

 BMC50028I DB2 MODE = NFM
 BMC50471I BMC_BMCUTIL       ='BMCUTIL.CMN_BMCUTIL'
 BMC50471I BMC_BMCSYNC       ='BMCUTIL.CMN_BMCSYNC'
 BMC50471I BMC_BMCHIST       ='BMCUTIL.CMN_BMCHIST'
 BMC50471I BMC_BMCXCOPY      ='BMCUTIL.CMN_BMCXCOPY'


 BMC50102I  UNLOAD
 BMC50102I   DIRECT NO
 BMC50102I   FORMAT STANDARD
 BMC50102I   NULLTYPE L2
 BMC50102I   NULLCHAR HIVAL
 BMC50102I   CNTLCARDS DB2LOAD 'REPLACE '
 BMC50102I    SELECT
 BMC50102I     COL_SMALL,
 BMC50102I     COL_INTEGER,
 BMC50102I     COL_FLOAT,
 BMC50102I     COL_CHAR,
 BMC50102I     COL_VCHAR,
 BMC50102I     COL_DATE,
 BMC50102I     COL_TIME,
 BMC50102I     COL_TIMESTAMP,
 BMC50102I     COL_XML,
 BMC50102I     COL_CLOB
 BMC50102I      FROM ADU.TADU_XML4K_NULL_32K_PLUS_C

 BMC51654I DIRECT NO IN EFFECT

 BMC50109I 'DIRECT NO' OPTION SPECIFIED.  OPTION 'SHRLEVEL' IGNORED
 BMC51689I ESTIMATED ROWS FOR SELECT 1 IS 0

 BMC50004I UTILINIT PHASE COMPLETE.  ELAPSED TIME = 00:00:00

 BMC51639I FOR DDNAME 'SYSREC' DSN=ADU.EXAMP15A.SYSREC,DCB=(RECFM=VBS,BLKSIZE=27993,LRECL=32756)
 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50474I BELOW 16M = 8508K, ABOVE 16M = 1408716K, CPUS = 3
 BMC51702I MAX TASKS = 1
 BMC51664I 1: SELECT STATEMENT NO. 1, ROWS = 1
 BMC50476I DDNAME = SYSREC, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51676I UNLOAD STATISTICS:  1 ROWS PROCESSED FOR SELECT STATEMENT NO. 1, 0 DISCARDED
 BMC51674I UNLOAD STATISTICS:  1 RECORDS WRITTEN TO DDNAME 'SYSREC'
 BMC51675I UNLOAD STATISTICS:  0 RECORDS DISCARDED DUE TO ERRORS
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I UNLOAD PHASE COMPLETE.  ELAPSED TIME = 00:00:00


 BMC51639I FOR DDNAME 'SYSCNTL' DSN=ADU.EXAMP15A.SYSCNTL,DCB=(RECFM=FB,BLKSIZE=3120,LRECL=80)
 BMC51801I LOAD TABLE STATEMENTS WRITTEN TO DDNAME 'SYSCNTL'

 BMC51810I LOAD DATA INDDN SYSREC
 BMC51809I REPLACE
 BMC51940I      EBCDIC CCSID(37,65534,65534)
 BMC51811I   INTO TABLE
 BMC51809I RDAMZL3.$TABLE1
 BMC51819I     (     BMC_NULL1 POSITION(1) CHAR(2)
 BMC51813I ,COL_SMALL POSITION(3:4) SMALLINT
 BMC51814I       NULLIF BMC_NULL1=X'FFFF'
 BMC51819I     ,     BMC_NULL2 POSITION(5) CHAR(2)
 BMC51813I ,COL_INTEGER POSITION(7:10) INTEGER
 BMC51814I       NULLIF BMC_NULL2=X'FFFF'
 BMC51819I     ,     BMC_NULL3 POSITION(11) CHAR(2)
 BMC51815I ,COL_FLOAT POSITION(13:20) FLOAT  (53)
 BMC51814I       NULLIF BMC_NULL3=X'FFFF'
 BMC51819I     ,     BMC_NULL4 POSITION(21) CHAR(2)
 BMC51815I ,COL_CHAR POSITION(23:32) CHAR  (10)
 BMC51814I       NULLIF BMC_NULL4=X'FFFF'
 BMC51819I     ,     BMC_NULL5 POSITION(33) CHAR(2)
 BMC51813I ,COL_VCHAR POSITION(35:*) VARCHAR
 BMC51814I       NULLIF BMC_NULL5=X'FFFF'
 BMC51819I     ,     BMC_NULL6 POSITION(*) CHAR(2)
 BMC51815I ,COL_DATE POSITION(*:*+9) DATE  EXTERNAL(10)
 BMC51814I       NULLIF BMC_NULL6=X'FFFF'
 BMC51819I     ,     BMC_NULL7 POSITION(*) CHAR(2)
 BMC51815I ,COL_TIME POSITION(*:*+7) TIME  EXTERNAL(8)
 BMC51814I       NULLIF BMC_NULL7=X'FFFF'
 BMC51819I     ,     BMC_NULL8 POSITION(*) CHAR(2)
 BMC51815I ,COL_TIMESTAMP POSITION(*:*+25) TIMESTAMP  EXTERNAL(26)
 BMC51814I       NULLIF BMC_NULL8=X'FFFF'
 BMC51819I     ,     BMC_NULL9 POSITION(*) CHAR(2)
 BMC51813I ,COL_XML POSITION(*:*) XML
 BMC51809I       PRESERVE WHITESPACE
 BMC51814I       NULLIF BMC_NULL9=X'FFFF'
 BMC51819I     ,     BMC_NULL10 POSITION(*) CHAR(2)
 BMC51813I ,COL_CLOB POSITION(*:*) CLOB
 BMC51814I       NULLIF BMC_NULL10=X'FFFF'
 BMC51809I )

 BMC50476I DDNAME = SYSCNTL, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0

SYSPRINT for example 15, case 2

The following figure shows the SYSPRINT for example 15, case 2:

                                *****  B M C   U N L O A D   P L U S   F O R   D B 2    V11R1.00 *****
                                             (C) COPYRIGHT 1991 - 2013 BMC SOFTWARE, INC.
 BMC50001I UTILITY EXECUTION STARTING   10/28/2013   13:14:13 ...
 BMC50002I UTILITY ID = 'ADUXM15'.  DB2 SUBSYSTEM ID = 'DEHJ'.  OPTION MODULE = 'ADU$OPTS'.
 BMC50471I z/OS 2.1.0,PID=HBB7790,DFSMS FOR Z/OS=2.1.0,DB2=11.1.0
 BMC50471I REGION=0M,BELOW 16M=8840K,ABOVE 16M=1414792K,IEFUSI=NO,CPUS=3
 BMC50471I MEMLIMIT=17592186040320M,AVAILABLE=17592186040313M,MEMLIMIT SET BY:REGION=0

 BMC50471I UNLOAD PLUS FOR DB2--V11.01.00
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I DB2 UTILITIES COMMON CODE--V11.01.00
 BMC50471I   NO MAINTENANCE TO REPORT
 BMC50471I SOLUTION COMMON CODE--V11.01.00
 BMC50471I   MAINT: BPJ0661  BPJ0667  BPJ0671  BPJ0674  BPJ0675  BPJ0676  BPJ0682  BPJ0686  BPJ0689  BPJ0697
 BMC50471I BMCSORT ENGINE--V02.04.01
 BMC50471I   MAINT: BPJ0691
 BMC50471I BMC STATS API--V11.01.00
 BMC50471I   MAINT: BPU5409  BPU5534  BPU5674
 BMC50471I EXTENDED BUFFER MANAGER--V06.01.00
 BMC50471I   MAINT: BPE0401  BPE0403  BPE0405  BPE0407  BPE0410  BPE0412  BPE0416

 BMC50471I ANALYZE=(DB2STATS,NOLIMIT)              FORCE_RPT=NO                            SMAX=16
 BMC50471I CENTURY=(1950,2049)                     FORCE=NONE                              SMCORE=(0K,0K)
 BMC50471I CHANGE_CONSISTENT=NO                    HISTORY=YES                             SORTNUM=32
 BMC50471I CHANGE_QUIESCE=NO                       IBUFFS=25                               SQLDELAY=3
 BMC50471I CMAX=16                                 INLINE=NO                               SQLRETRY=100
 BMC50471I CMRATIO=50                              LOADDECP=NO                             TAPEDISP=DELETE
 BMC50471I CONSTRULES=BMC                          LOCKROW=YES                             TASKMAX=200%
 BMC50471I CURRENTDEGREE=NONE                      MAXP=5                                  UBUFFS=25
 BMC50471I DELFILES=YES                            MSGLEVEL=1                              UNLDMAX=200%
 BMC50471I DRNDELAY=1                              NULLCHAR=X'6F'                          UNLOADDN_ACTIVE=(YES,NO)
 BMC50471I DRNRETRY=255                            NULLTYPE=T1                             UNLOADDN=(SYSREC,SYSRED)
 BMC50471I DRNWAIT=NONE                            OPNDB2ID=YES                            USELRECL=NO
 BMC50471I DSPLOCKS=DRNFAIL                        PLAN=ADUQA                              UXSTATE=SUP
 BMC50471I EXCLDUMP=(X37,X22,X06)                  RECFM=AUTO                              WORKUNIT=SYSALLDA
 BMC50471I FILEREFDN=SYSREF                        ROWSETSZ=100                            ZIIP=ENABLED
 BMC50471I FILL=NO                                 SDUMP=YES                               ZONEDDECOVP=(C,D)
 BMC50471I FORCE_AT=(START,3)                      SHRLEVEL=REFERENCE


 BMC50471I TAPES=NONE

 BMC50470I OUTPUT   = SYSREC                             SYSRED                               SYSREF
 BMC50470I UNIT     = SYSALLDA                           SYSALLDA                             SYSALLDA
 BMC50470I VOLCNT   = 25                                 25                                   25
 BMC50470I GDGLIMIT = 5                                  5                                    5
 BMC50470I GDGEMPTY = NO                                 NO                                   NO
 BMC50470I GDGSCRAT = NO                                 NO                                   NO
 BMC50470I STORCLAS = NONE                               NONE                                 NONE
 BMC50470I DATACLAS = NONE                               NONE                                 NONE
 BMC50470I MGMTCLAS = NONE                               NONE                                 NONE
 BMC50470I UNITCNT  = 0                                  0                                    0
 BMC50470I SPACE    = CYL                                CYL                                  CYL
 BMC50470I PCTPRIM  = AUTO                               AUTO                                 AUTO
 BMC50470I MAXPRIM  = 0                                  0                                    0
 BMC50470I MAXSECD  = 0                                  0                                    0
 BMC50470I FILESZPCT  100                                100                                  100
 BMC50470I NBRSECD  = AUTO                               AUTO                                 AUTO
 BMC50470I DISKRETN = NONE                               NONE                                 NONE
 BMC50470I DISKEXPD = NONE                               NONE                                 NONE
 BMC50470I RETPD    = NONE                               NONE                                 NONE
 BMC50470I EXPDT    = 99000                              99000                                99000
 BMC50470I TRTCH    = NONE                               NONE                                 NONE
 BMC50470I DSNTYPE  = NONE                               NONE                                 PDS
 BMC50483I SYSREC     VOLUMES=NONE
 BMC50483I SYSRED     VOLUMES=NONE
 BMC50483I SYSREF     VOLUMES=NONE

 BMC50483I SYSREC     DSNAME=&USERID.&TYPE.S&SELNUM
 BMC50483I SYSRED     DSNAME=&USERID.&TYPE.S&SELNUM
 BMC50483I SYSREF     DSNAME=&USERID.BMC


 BMC50471I DB2 DSNHDECP MODULE SETTINGS:
 BMC50471I VERSION                 = 1110
 BMC50471I SUBSYSTEM DEFAULT       = DEHJ
 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 (-05:00)

 BMC50028I DB2 MODE = NFM
 BMC50471I BMC_BMCUTIL       ='BMCUTIL.CMN_BMCUTIL'
 BMC50471I BMC_BMCSYNC       ='BMCUTIL.CMN_BMCSYNC'
 BMC50471I BMC_BMCHIST       ='BMCUTIL.CMN_BMCHIST'
 BMC50471I BMC_BMCXCOPY      ='BMCUTIL.CMN_BMCXCOPY'


 BMC50102I  UNLOAD
 BMC50102I   DIRECT YES
 BMC50102I   FORMAT STANDARD
 BMC50102I   OUTPUT CLOB01  DSNAME('ADU.EXAMP15B.CLOB')
 BMC50102I            DSNTYPE(PDS) DIR (100) SPACE (10,10) SUBSETS 1
 BMC50102I            UNIT WORK
 BMC50102I   OUTPUT XML001  DSNAME('ADU.EXAMP15B.XML')
 BMC50102I            DSNTYPE(PDS) DIR (100) SPACE (10,10) SUBSETS 1
 BMC50102I            UNIT WORK
 BMC50102I   NULLTYPE L2
 BMC50102I   NULLCHAR HIVAL
 BMC50102I   CNTLCARDS DB2LOAD 'REPLACE '
 BMC50102I    SELECT
 BMC50102I     COL_SMALL,
 BMC50102I     COL_INTEGER,
 BMC50102I     COL_FLOAT,
 BMC50102I     COL_CHAR,
 BMC50102I     COL_VCHAR,
 BMC50102I     COL_DATE,
 BMC50102I     COL_TIME,
 BMC50102I     COL_TIMESTAMP,
 BMC50102I     COL_XML,
 BMC50102I     COL_CLOB
 BMC50102I      INTO
 BMC50102I      COL_SMALL,
 BMC50102I      COL_INTEGER,
 BMC50102I      COL_FLOAT,
 BMC50102I      COL_CHAR,
 BMC50102I      COL_VCHAR,
 BMC50102I      COL_DATE,
 BMC50102I      COL_TIME,
 BMC50102I      COL_TIMESTAMP,
 BMC50102I      COL_XML   CHAR (45) CLOBF   XML001,
 BMC50102I      COL_CLOB  CHAR (45) CLOBF   CLOB01
 BMC50102I       FROM ADU.TADU_XML4K_NULL_32K_PLUS_C

 BMC51654I DIRECT YES IN EFFECT

 BMC51687I ESTIMATED ROWS FOR TABLE SPACE DADUXMLC.SADUXMLC PART 0 IS 1656 FROM HURBA
 BMC51688I ESTIMATED ROWS FOR TABLE     ADU.TADU_XML4K_NULL_32K_PLUS_C IS 1656 FROM TABLESPACE
 BMC51689I ESTIMATED ROWS FOR SELECT 1 IS 1656

 BMC50004I UTILINIT PHASE COMPLETE.  ELAPSED TIME = 00:00:00


 BMC50445I UNLOAD PLUS DYNAMIC FILE ALLOCATION REPORT

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

 BMC50448I SYS00013 ADU.EXAMP15B.XML                             WORK                              0        0       10        10  CYL
 BMC50448I SYS00014 ADU.EXAMP15B.CLOB                            WORK                              0        0       10        10  CYL

 BMC51639I FOR DDNAME 'SYSREC' DSN=ADU.EXAMP15B.SYSREC,DCB=(RECFM=VB,BLKSIZE=27993,LRECL=194)

 BMC50894I PAGE EXTERNALIZATION PROCESS STARTING AT  10/28/2013  13:14:14

 BMC50650I ESTABLISHING A POINT OF CONSISTENCY FOR:
 BMC50651I SPACE DADUXMLC.SADUXMLC PART(0) PSID(0002)
 BMC50651I SPACE DADUXMLC.XTAD0000 PART(0) PSID(0005)
 BMC50651I SPACE DADUXMLC.ADUTSE02 PART(0) PSID(000D)
 BMC50651I SPACE DADUXMLC.IRNODEID PART(0) PSID(0009)
 BMC50651I SPACE DADUXMLC.IXLOB2 PART(0) PSID(0011)

 BMC50895I PAGE EXTERNALIZATION PROCESS COMPLETE.  ELAPSED TIME =  00:00:00

 BMC50041I 0: ZIIP  ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50474I BELOW 16M = 8468K, ABOVE 16M = 1391616K, CPUS = 3
 BMC51701I MAX TASKS = 1, MAX PARTITIONS PER TASK = 1, SORTWKS PER TASK = 0, MAX OPEN PARTITIONS PER TASK = 1
 BMC50655I 2: BUF MGR TOTAL GETS = 1
 BMC50656I 2: BUF MGR FOR INDEX = DEHJCAT.DSNDBD.DADUXMLC.IRNODEID.I0001.A001, GETS = 1, PUTS = 0, DPUTS = N/A
 BMC50655I 3: BUF MGR TOTAL GETS = 1
 BMC50656I 3: BUF MGR FOR INDEX = DEHJCAT.DSNDBD.DADUXMLC.IXLOB2.I0001.A001, GETS = 1, PUTS = 0, DPUTS = N/A
 BMC50477I 1: PARTITION =    0, ROWS/KEYS = 1, I/O WAITS = 2 ,DDNAME = SYS00020
 BMC50478I 1: RDB LOCK WAITS = 0
 BMC50476I DDNAME = SYSREC, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC51686I UNLOADING OF DATASET 'DEHJCAT.DSNDBD.DADUXMLC.SADUXMLC.I0001.A001' READ 3 PAGES
 BMC51672I UNLOAD STATISTICS:  1 ROWS PROCESSED FROM SPACE 'DADUXMLC.SADUXMLC', 0 NOT SELECTED, 0 DISCARDED
 BMC51674I UNLOAD STATISTICS:  1 RECORDS WRITTEN TO DDNAME 'SYSREC'
 BMC51675I UNLOAD STATISTICS:  0 RECORDS DISCARDED DUE TO ERRORS
 BMC51674I UNLOAD STATISTICS:  1 XML COLUMNS WRITTEN TO FILEREF DS 'ADU.EXAMP15B.XML'
 BMC51674I UNLOAD STATISTICS:  1 LOB COLUMNS WRITTEN TO FILEREF DS 'ADU.EXAMP15B.CLOB'
 BMC50041I 0: ZIIP NOT ENABLED (0) USING XBM SUBSYSTEM XBMB
 BMC50004I UNLOAD PHASE COMPLETE.  ELAPSED TIME = 00:00:01


 BMC51639I FOR DDNAME 'SYSCNTL' DSN=ADU.EXAMP15B.SYSCNTL,DCB=(RECFM=FB,BLKSIZE=3120,LRECL=80)
 BMC51801I LOAD TABLE STATEMENTS WRITTEN TO DDNAME 'SYSCNTL'

 BMC51810I LOAD DATA INDDN SYSREC
 BMC51809I REPLACE
 BMC51940I      EBCDIC CCSID(37,65534,65534)
 BMC51811I   INTO TABLE
 BMC51809I ADU.TADU_XML4K_NULL_32K_PLUS_C
 BMC51819I     (     BMC_NULL1 POSITION(1) CHAR(2)
 BMC51813I ,COL_SMALL POSITION(3:4) SMALLINT
 BMC51814I       NULLIF BMC_NULL1=X'FFFF'
 BMC51819I     ,     BMC_NULL2 POSITION(5) CHAR(2)
 BMC51813I ,COL_INTEGER POSITION(7:10) INTEGER
 BMC51814I       NULLIF BMC_NULL2=X'FFFF'
 BMC51819I     ,     BMC_NULL3 POSITION(11) CHAR(2)
 BMC51815I ,COL_FLOAT POSITION(13:20) FLOAT  (53)
 BMC51814I       NULLIF BMC_NULL3=X'FFFF'
 BMC51819I     ,     BMC_NULL4 POSITION(21) CHAR(2)
 BMC51815I ,COL_CHAR POSITION(23:32) CHAR  (10)
 BMC51814I       NULLIF BMC_NULL4=X'FFFF'
 BMC51819I     ,     BMC_NULL5 POSITION(33) CHAR(2)
 BMC51813I ,COL_VCHAR POSITION(35:*) VARCHAR
 BMC51814I       NULLIF BMC_NULL5=X'FFFF'
 BMC51819I     ,     BMC_NULL6 POSITION(*) CHAR(2)
 BMC51815I ,COL_DATE POSITION(*:*+9) DATE  EXTERNAL(10)
 BMC51814I       NULLIF BMC_NULL6=X'FFFF'
 BMC51819I     ,     BMC_NULL7 POSITION(*) CHAR(2)
 BMC51815I ,COL_TIME POSITION(*:*+7) TIME  EXTERNAL(8)
 BMC51814I       NULLIF BMC_NULL7=X'FFFF'
 BMC51819I     ,     BMC_NULL8 POSITION(*) CHAR(2)
 BMC51815I ,COL_TIMESTAMP POSITION(*:*+25) TIMESTAMP  EXTERNAL(26)
 BMC51814I       NULLIF BMC_NULL8=X'FFFF'
 BMC51819I     ,     BMC_NULL9 POSITION(*) CHAR(2)
 BMC51966I ,COL_XML POSITION(*:*+44) CHAR(45) CLOBF
 BMC51809I       PRESERVE WHITESPACE
 BMC51814I       NULLIF BMC_NULL9=X'FFFF'
 BMC51819I     ,     BMC_NULL10 POSITION(*) CHAR(2)
 BMC51966I ,COL_CLOB POSITION(*:*+44) CHAR(45) CLOBF
 BMC51814I       NULLIF BMC_NULL10=X'FFFF'
 BMC51809I )

 BMC50476I DDNAME = SYSCNTL, I/OS = 1, I/O WAITS = 1, RDB LOCK WAITS = 0
 BMC50006I UTILITY EXECUTION COMPLETE, RETURN CODE = 0

Related topic

Examples-of-UNLOAD-PLUS-jobs

 

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