PI51511: GEN U4038 ON ADB2REG FOR VA20/ADB7350E MODULE : ADB2CMF DETECTED AN ONCODE CONDITION 340 IN CONVERT_SRC_RECORD

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' GEN function ends with a
  U4038 on ADB2REG or ADB7350E Module : ADB2CMF detected
  an ONCODE condition 340 in CONVERT_SRC_RECORD.
  

Local fix

• Remove the parm 'VWCOLLIST='A', from the IN DD name in job step
  GENSQL.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use DDL or GEN on a VIEW.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: A DB2 Administration Tool for z/OS GEN  *
  *                      on a VIEW failed with:                  *
  *                       USER ABEND CODE 4038                   *
  *                       REASON CODE 00000001                   *
  *                      and error condition as below.           *
  *                                                              *
  *                      ERROR condition was raised              *
  *                      Traceback of user routines:             *
  *                      Compile Unit   Entry          Statement *
  *                                     CLEANUP        12830     *
  *                                     CREATE_VIEW    12579     *
  *                                     ADB2REG        1250      *
  *                                     GENERATE       2698      *
  *                                     REU0023        1674      *
  *                                     GENERATE       1751      *
  *                                     GEN_VIEWS      7222      *
  *                                     ADB2REP        1943      *
  *                                     ADB2GEN        2793      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  GEN on the VIEW failed with USER ABEND CODE 4038 REASON
  CODE 00000001. The GEN job generated unexpected VWCOLLIST='A'
  for GEN parameters.
  

Problem conclusion

• Problem is solved.
  

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:

  UI35041 UI35042 UI35043

Modules/Macros

•    ADB2GEN  ADB2GENX
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI35041

     UP16/02/12 P F602

• RB10 PSY UI35042

     UP16/02/12 P F602

• RB20 PSY UI35043

     UP16/02/12 P F602

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.