PI18139: PANEL ADB2GEN GEN FUNCTION GENERATES MSG IBM0441W ONCODE=150

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS GEN function generates
  error message:
  IBM0441W  ONCODE=150  The STRINGSIZE condition was raised.
           From entry point GET_SYSPARM at statement 5345 at
           compile unit address 1AE7C22A.
           From entry point GET_RUN_PARM at statement 3925 at
           compile unit at address 1AE8229A.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Generate (GEN) function     *
  *                 on a table when the WLM environment name     *
  *                 is more than 18 bytes.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the WLM environment name is        *
  *                      more than 18 bytes, and the GEN         *
  *                      command is executed on a table to       *
  *                      generate the DDL, the GEN command       *
  *                      fails with an ONCODE=150 /              *
  *                      ONCODE150:                              *
  *                                                              *
  *                      ONCODE=150  The STRINGSIZE condition    *
  *                      was raised.                             *
  *                      From entry point GET_SYSPARM at         *
  *                      statement 5406 at compile unit offset   *
  *                      address >offset_address<                *
  *                      From entry point GET_RUN_PARM at        *
  *                      statement 3972 at compile unit          *
  *                      offset at address >offset_address<.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When the WLM environment name is more than 18 bytes, and the
  GEN command is executed on a table to generate the DDL, the
  GEN command fails with an ONCODE=150 / ONCODE150.
  

Problem conclusion

• Problem has been resolved.
  NOTE:  APAR PI31779 has been opened to address the following:
  
  1- When Object Compare source and target are from a version
     table entry, the compare job will fail with error message
     ADB7350E / msgadb7350e and ONCODE 8094 / ONCODE8094:
  
     ADB7350E Module : ADB2CMF detected an ONCODE condition
       8094 in READ_SRC_OBJECT at 5513
  
     However, if only the source is from a version table entry,
     the compare job fails with error message ADB7350E /
     msgadb7350e and ONCODE 520 /ONCODE520:
  
     ADB7350E Module : ADB2CMF detected an ONCODE condition
       520 in COMPARE_UDF_INST at 5329
  

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:

Modules/Macros

•    ADBALT   ADBCCM   ADBCCME  ADBCCMM  ADBCDTS
  ADBCP    ADBCVC   ADBCVCP  ADBCVCT  ADBCVEX  ADBCVEY  ADBCVIC
  ADBCVOC  ADBMAIN  ADBVFC   ADBVFCA  ADBVFCF  ADB2CDC  ADB2CMF
  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB2DEP  ADB2IGN  ADB2MSK
  ADB2RE   ADB2REC  ADB2REE  ADB2REG  ADB2REH  ADB2REM  ADB2REP
  ADB2RER  ADB2RES  ADB2RET  ADB2REU  ADB2REY  ADB2REZ  ADB2RGC
  ADB2RPT  ADB2WCL  ADB2WVL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI24415

     UP15/01/18 P F501

• RB10 PSY UI24416

     UP15/01/18 P F501

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.