PH15547: COLUMN CHANGE DEFAULT NULL / NOT NULL LOAD RECORDS DISCARDED INVALID DSN_NULL_IND or INPUT INVALID FOR DATE/TIMEINT S04E

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses two issues during execution of a change when
  a column's NULL/NOT NULL attribute is changed, and NOPAD=YES
  was used to Unload the data:
  
  
  1. If a column is changed from 'INTEGER WITH DEFAULT NULL'to
  'INTEGER NOT NULL WITH DEFAULT n', the Load step
  may discard all rows with the following message:
  
  DSNU318I  -ssid nnn timestamp DSNURWBF - RECORD (1) WILL BE
  DISCARDED DUE TO INVALID 'DSN_NULL_IND_nnnnn' COLUMN
   SPECIFICATION FOR >schema<.>table<
  
  2.  If a column is changed from INTEGER WITH DEFAULT n
  to INTEGER NOT NULL WITH DEFAULT n, the Load step
  may discard all rows with the following messages:
  
  DSNU310I  -ssid nnn timestamp DSNURCON - RECORD (1) WILL BE
  DISCARDED DUE TO '>column<' CONVERSION ERROR FOR
  >schema<.>table<
  ERROR CODE '14 - INPUT IS INVALID FOR DATE/TIME'
  
  The job may also end with an S04E abend, and with message
  ADB5184E/msgadb5184e:
  
   ADB5184E The run is ending due to an error with a non-SQL
  command.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS and Db2 Object Comparison Tool for z/OS *
  *                 who use compare with the NOPAD option to     *
  *                 do data conversion.                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: Changing NULL/NOT NULL data             *
  *                      definitions, and using the NOPAD        *
  *                      option, may cause the load utility      *
  *                      to fail during the run job.             *
  ****************************************************************
  This APAR addresses two related problems which occur when the
  NOPAD option is used to unload data when executing the change:
  
  1- When changing a column from INTEGER WITH DEFAULT NULL
  to INTEGER NOT NULL WITH DEFAULT n, the load step in the run
  job may fail with Db2 discarding all records with the following
  message:
  
  DSNU318I -ssid nnn timestamp DSNURWBF - RECORD (1) WILL BE
  DISCARDED DUE TO INVALID 'DSN_NULL_IND_nnnnn' COLUMN
  SPECIFICATION FOR >schema<.>table<
  
  
  2- When changing a column from INTEGER WITH DEFAULT n to
  INTEGER NOT NULL WITH DEFAULT n, the load step in the run job
  may fail with the following messages:
  
  DSNU310I -ssid nnn timestamp DSNURCON - RECORD (1) WILL BE
  DISCARDED DUE TO '>column<' CONVERSION ERROR FOR
  >schema<.>table<
  ERROR CODE '14 - INPUT IS INVALID FOR DATE/TIME'
  
  An S04E abend may also result, as well as message
  ADB5184E/msgadb5184e:
  
  ADB5184E The run is ending due to an error with a non-SQL
  command.
  

Problem conclusion

• The issue has been resolved.
  

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:

  010PC2Ÿ UI66296

Modules/Macros

• ADB27AC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI66296

     UP19/11/12 P F911

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.