PH37022: ERROR ADB5184E DURING LOAD WHEN ROW CHANGE TIMESTAMP COLUMN CHANGED FROM GENERATED BY DEFAULT TO GENERATED ALWAYS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When changing a row change timestamp column with
  GENERATED BY DEFAULT to GENERATED ALWAYS, the Load
  part of the WSL may fail with the following messages:
  
  DSNU053I  - DSNURWUF -FIELD 'DSN_RCTIMESTAMP' NOT
  FOUND
  
  ADBT015I ADBTEP2  Failure attempting to execute ADB2UTILwith
  parm >parms<
  ADB5184E The run is ending due to an error with a non-SQL
  command.
  

Local fix

• BYPASS/CIRCUMVENTION:
  NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS and Db2 Object Comparison Tool for z/OS *
  ****************************************************************
  * PROBLEM DESCRIPTION: An error occurs when using the LOAD     *
  *                      utility to load data into a row change  *
  *                      timestamp column.                       *
  ****************************************************************
  Changing a row change timestamp column with GENERATED BY DEFAULT
  to GENERATED ALWAYS results in UNLOAD, DROP, CREATE, and LOAD
  operations on the table in the WSL. When executing the LOAD part
  of the WSL, which attempts to insert data into the row change
  timestamp column, the tool reports the following information:
  
  FIELD 'DSN_RCTIMESTAMP' NOT FOUND
  
  The job ends with a return code 8 and the following message:
  ADBT015I ADBTEP2 Failure attempting to execute ADB2UTILwith
  parm >parms<
  ADB5184E The run is ending due to an error with a non-SQL
  command.
  
  Keyword: msgadb5184e;msgadbT015I
  

Problem conclusion

• The problem 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:

  UI76601

Modules/Macros

• ADB27AC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI76601

     UP21/08/10 P F108

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.