PK32599: DDL ON ALIAS RECEIVES ONCODE150 STRINGSIZE CONDITION FROM ADB2REG CREATE_ALIAS STATEMENT 852 OR 898

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool using DDL line command on ALIAS
  name in panel adb21a can produce oncode150 stringsize error.
  .
  Error is only seen when ALIAS refers to a remote table name
  with a long location name ( three part ALIAS names ). DDL is
  produced ok.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool, who  use   *
  *                 GEN and have objects having remote aliases   *
  *                 with 16 character location names,  may  be   *
  *                 affected.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: STRINGSIZE abend occurred when DDL for  *
  *                      the  remote  aliases with 16 character  *
  *                      location names was generated and used.  *
  *                      .*                                      *
  *                      Changes have been made to  ADB2REG  to  *
  *                      allow for the full location names.      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fix.
  

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

•    ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK20015

     UP06/11/30 P F611

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.