PH29024: DB2 ADMIN TOOL: ADB1646E DURING GEN FOR A STORED PROCEDURE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Admin Tool: ADB1646E During GEN for a stored procedure
  
  Error occurred processing STP request
              Reason code = 8
  
  The error only occurs during GEN of a stored procedure with
  certain combinations:
  
  Has simple comments (?comment)
  GEN option SQLCMTS = Y
  When original procedure is created, PACKAGE OWNER is columns 1-3
  
  
  Example
  
  RESULT SETS 1
    QUALIFIER QUAL1
    VALIDATE BIND
    DISABLE DEBUG MODE
    COMMIT ON RETURN NO
    CALLED ON NULL INPUT
    LANGUAGE SQL
    PACKAGE OWNER JOHN
  
  BEGIN
  
  ----------------------------------------------------------------
  -- some comments..
  ----------------------------------------------------------------
  
  etc
  

Local fix

• Move the package owner so it starts in col4/5
  
  RESULT SETS 1
    QUALIFIER QUAL1
    VALIDATE BIND
    DISABLE DEBUG MODE
    COMMIT ON RETURN NO
    CALLED ON NULL INPUT
    LANGUAGE SQL
      PACKAGE OWNER JOHN                <=================
  
  BEGIN
  
  ----------------------------------------------------------------
  -- some comments..
  ----------------------------------------------------------------
  
  etc
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS Reverse Engineering (GEN) function      *
  ****************************************************************
  * PROBLEM DESCRIPTION: RC1000 during generation of a stored    *
  *                      procedure with simple comments          *
  ****************************************************************
  If a stored procedure was created with simple comments
  (for example, --comment01), depending on the spacing used
  during the original CREATE PROCEDURE statement, DDL generation
  might fail with RC1000. The following errors are also returned:
  
  ADB1646E An error has occurred while generating DDL for an
  object.
  ADB1873E Processing ended but not all supplied catrows were
  used.
              Reason code = 24
  

Problem conclusion

• The problem has been resolved.
  

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:

  UI72550 010PC2Ÿ 010PC2Ÿ 010PC2Ÿ

Modules/Macros

• ADB2REH
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI72550

     UP20/12/01 P F011

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.