PQ75456: THREE PROBLEMS: ONCODE=350 WHEN RUNNING A WORKLIST JOB, ADBTEP2 FAILED TO STOP FOR NEGATIVE RC, COMMAS AS DECIMALS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• .*
  IBM0361W ONCODE=350 message occurred when running a job
  from the created Worklist for adding a new column to
  the primary key and the clustering index.
  .*
  SQLCODE 170 occurred where commas are used as decimals
  .*
  When programs are executed under ADBTEP2 using the
  DSN RUN command, for example RUN PROGRAM(ADB27AC), the
  return code set by the program is not being propagated
  back to ADBTEP2, when an ABEND occurs, such as a B37.
  Instead DSN is intercepting the ABEND and returns
  a negative return code to ADBTEP2. Return codes of
  4 or less allow processing to continue in ADBTEP2.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 ADMIN TOOL who use Worklist,    *
  *                 ADBTEP2, Commas as Decimals may be affected. *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following problems are addressed:   *
  *                      .*                                      *
  *                      IBM0361W ONCODE=350 message occurred    *
  *                      when running a job from the created     *
  *                      Worklist for adding a new column to     *
  *                      the primary key and the clustering      *
  *                      index.                                  *
  *                      .*                                      *
  *                      SQLCODE 170 occurred where commas are   *
  *                      used as decimals (only reported cases   *
  *                      are addressed).                         *
  *                      .*                                      *
  *                      When programs are executed under        *
  *                      ADBTEP2 using the DSN RUN command,      *
  *                      for example RUN PROGRAM(ADB27AC), the   *
  *                      return code set by the program is not   *
  *                      being propagated back to ADBTEP2, when  *
  *                      an ABEND occurs, such as a B37. Instead *
  *                      DSN is intercepting the ABEND and       *
  *                      returns a negative return code to       *
  *                      ADBTEP2. Return codes of 4 or less allo *
  *                      processing to continue in ADBTEP2.      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• More cases of "commas as decimals" problems may be discovered
  later and they will be addressed accordingly.
  

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:

  UQ79172 UQ79173

Modules/Macros

•    ADBTCL   ADB2M1   ADB21    ADB21D   ADB21S
  ADB21T   ADB27AC  ADB27ALT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R410 PSY UQ79172

     UP03/08/11 P F308

• R420 PSY UQ79173

     UP03/08/11 P F308

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.