PI12058: INCORRECT LOAD STATEMENTS IN SYSPUNCH PRODUCED BY UNLOAD UTILITYON MULTIPLE TABLES WITH LOB COLUMNS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Unload Spanned Yes of a tablespace with two tables having each a
  LOB column produces a syspunch which contains incorrect load
  statements for the second table .
  In the reported case, we have the following two tables:
  CREATE TABLE PM92640S.TBWILOB1
  (F1                   INTEGER NOT NULL,
  F2                   CHAR(10) NOT NULL WITH DEFAULT,
  F3                   CHAR(10) NOT NULL WITH DEFAULT,
  FCLOB                CLOB(1G) NOT NULL WITH DEFAULT,
  ROW_ID               ROWID NOT NULL GENERATED ALWAYS,
  FEND                 TIMESTAMP NOT NULL WITH DEFAULT)
  IN PM92640S.TS0001
  .
  CREATE TABLE PM92640S.TBWILOB2
  (F1                   INTEGER NOT NULL,
  F2                   CHAR(10) NOT NULL WITH DEFAULT,
  F3                   CHAR(10) NOT NULL WITH DEFAULT,
  FCLOB                CLOB(1G) NOT NULL WITH DEFAULT,
  ROW_ID               ROWID NOT NULL GENERATED ALWAYS,
  FEND                 TIMESTAMP NOT NULL WITH DEFAULT)
  IN PM92640S.TS0001
  .
  After UNLOAD, the SYSPUNCH contains the following:
  LOAD DATA INDDN EMYJ7MQE LOG NO  RESUME YES
  EBCDIC  CCSID(00277,00000,00000)
  FORMAT SPANNED YES INTO TABLE "PM92640S"."TBWILOB1"
  ("F1" POSITION(  00003:00006) INTEGER
  , "F2" POSITION(  00007:00016) CHAR(00010)
  , "F3" POSITION(  00017:00026) CHAR(00010)
  , "FEND" POSITION(  00027:00052) TIMESTAMP EXTERNAL(026)
  , "FCLOB" POSITION(  *)           CLOB)
  INTO TABLE "PM92640S"."TBWILOB2"
  WHEN(00001:00002) = X'000C'
  NUMRECS  1 IGNOREFIELDS YES
  ( "F1" POSITION(  *)           INTEGER
  , "F2" POSITION(  *)           CHAR(00010)
  , "F3" POSITION(  *)           CHAR(00010)
  , "FEND" POSITION(  *)           TIMESTAMP EXTERNAL(026)
  , "FCLOB" POSITION(  *)           CLOB)
  The subsequent Load would fail on the second table with
  DSNU318I  @ 042 02:42:06.15 DSNURWBF - RECORD (2) WILL BE
  DISCARDED DUE TO INVALID 'FCLOB' COLUMN SPECIFICATION
  SYSADM.BASETB2
  The problem was caused by a local internal flag not being reset
  properly before processing the second table.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS and DB2 11 for z/OS      *
  *                 users of UNLOAD utility with SPANNED YES     *
  ****************************************************************
  * PROBLEM DESCRIPTION: MSGDSNU318I during LOAD utility using   *
  *                      the SYSPUNCH data set from an UNLOAD    *
  *                      SPANNED YES of a table space with two   *
  *                      tables each having a LOB column.        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An UNLOAD SPANNED YES of a table space with two tables, each
  having a LOB column, produced a SYSPUNCH in which the first
  field for the second table was set with position(*). A
  subsequent LOAD using the statement in this SYSPUNCH failed with
  message DSNU318I - RECORD 'n' WILL BE DISCARDED DUE TO INVALID
  field-name COLUMN SPECIFICATION FOR table-name.
  
  The problem was caused by an internal flag not being reset
  properly before processing the second table.
  

Problem conclusion

• The UNLOAD SPANNED YES code have been modified to correct the
  reported problem.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI16620 UI16621

Modules/Macros

•    DSNUULGL
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI16620

     UP14/04/16 P F404

• RB10 PSY UI16621

     UP14/04/16 P F404

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.