PK05572: ADMIN TOOL GEN AND DDL LINE COMMANDS DO NOT WORK FOR SQL STORED PROCEDURES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The GEN and DDL line commands do not work for SQL STORED
  PROCEDURES
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administartion Tool, who run    *
  *                 GEN to produce DDL for Stored Procedures     *
  *                 implemented in SQL, are affected.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: The GEN and DDL line commands do not    *
  *                      work for SQL STORED PROCEDURES.         *
  *                      .*                                      *
  *                      GEN rejects requests to produce DDL     *
  *                      for SQL stored procedures and issues    *
  *                      a warning message.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  GEN AND DDL line commands do not work for SQL STORED PROCEDURES.
  

Problem conclusion

• The ADB2REE and ABD2REG modules have been changed to remove
  the reported restriction.
  

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

•    ADB2RE   ADB2REE  ADB2REG  ADB2REZ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK04850

     UP05/06/30 P F506

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.