PM90035: GEN FUNCTION APAR PM84458: IMPROVEMENTS TO MESSAGES AND DOCUMENT ATION.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' APAR PM84458 introduced
  changes to the behaviour of the product which need to be better
  documented such as the inclusion of CREATE TABLE "ADB model
  table nn" /  DROP TABLE "ADB model table nn" statements around a
  CREATE STORED PROCEDURE which uses the 'AS LOCATOR' syntax.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the 'GEN - Generate SQL for     *
  *                 function from DB2 catalog' line command      *
  *                 on panels ADB21O ' Stored Procedures' /      *
  *                 ADB21F ' Functions' to generate DDL for      *
  *                 a stored procedure / user defined function.  *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      APAR PM84458 introduced changes to the  *
  *                      behavior of the product but did not     *
  *                      provide documentation to support the    *
  *                      inclusion of 'model table' in the       *
  *                      CREATE TABLE "ADB model table nn" /     *
  *                      DROP TABLE "ADB model table nn"         *
  *                      statements when using 'AS LOCATOR'      *
  *                      in the CREATE STORED PROCEDURE          *
  *                      syntax.                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A detailed description does not exist for 'model table' when
  generating DDL for a stored procedure / user defined function.
  

Problem conclusion

• Program has been updated and applied to users generating a
  User Defined Function (UDF) or Native Stored Procedure (NSP)
  that has a transition table parameter.
  
  The transition table parameter is a parameter defined as
     TABLE LIKE table-name AS LOCATOR.
  
  DB2 Admin Tool will generate
     TABLE LIKE admin-model-table-name AS LOCATOR
  instead of generating
     TABLE LIKE table-name AS LOCATOR .
  
  DB2 Admin Tool will create a model table for each transition
  table parameter.  The model table will have the same column
  structure as the transition table parameter.  The model
  tables will be created for a stored procedure or user-
  defined function, the stored procedure or user-defined
  function will then be created referencing the model table
  name in the parameter list, and then the model tables will
  be dropped.  Each model table name begins with 'ADB model
  table'.
  
  Information for the model table comes from the SYSIBM.SYSPARMS
  catalog table for a NSP / UDF that only shows the structure of
  the model table.  A user can not use the related DDL for a
  model table to create a model table, and can not use DDL to
  create the NSP / UDF if the NSP / UDF contains a model table
  in the parm list.
  

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  ADB2REH
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK97962

     UP13/09/28 P F309

• RA20 PSY UK97937

     UP13/09/28 P F309

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.