PI50786: DB2 ADMINISTRATION TOOL FOR Z/OS WHEN RUNNING WSL CREATED TO ALT COLUMNS OF A TABLE USING UNLOAD WITH NOPAD RESULTS IN ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS when running WSL created
  to ALTer columns of a table using UNLOAD with NOPAD results
  in records being discarded during subsequent LOAD due to
  incorrect computed offsets in the modified SYSPUNCH file with
  message msgDSNU318I :
  DSNU318I  <ssid> - 280 05:12:45.75 DSNURWBF - RECORD (n) WILL
  BE DISCARDED DUE TO INVALID '<spec>' COLUMN
  SPECIFICATION FOR schema.table_name
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
  *                 who ALTer columns of a table using UNLOAD    *
  *                 with NOPAD.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a customer alters a column from    *
  *                      NOT NULL to NULL, the LOAD utility      *
  *                      discarded all rows with the following   *
  *                      error message:                          *
  *                      RECORD (nnn) WILL BE DISCARDED DUE      *
  *                      TO INVALID >spec< COLUMN SPECIFICATION  *
  *                      FOR >schema<.>table_name<               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When customer ALTer table column from NOT NULL to NULL, the LOAD
  utility discarded all rows with the following error message:
   RECORD (nnn) WILL BE DISCARDED DUE TO
   INVALID >spec< COLUMN SPECIFICATION FOR >schema<.>table_name<
  

Problem conclusion

• The problem has been fixed.
  

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:

  UI34128 UI34129

Modules/Macros

•    ADB27AC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI34128

     UP16/01/07 P F601

• RB20 PSY UI34129

     UP16/01/07 P F601

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.