PI77902: DB2 ADMIN TOOL - CMBATCH CREATION OF A STORED PROCEDURE ENDS WITH RC12

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Creation of a stored procedure fails with RC=12. Based on the
  output provided by CMBatch it's impossible to get to know
  what's wrong.
  
  ALTER PROCEDURE gets the same error message as the CREATE Proc
  stmt.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
  *                 who use the Change Management Batch          *
  *                 (CM Batch) interface to import change        *
  *                 statements.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: When importing change statements using  *
  *                      Change Management Batch interface,      *
  *                      issues with delimiter location and      *
  *                      error ADB9600E when processing a        *
  *                      CREATE PROCEDURE statement are          *
  *                      addressed.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When importing change statements using the CM Batch interface,
  the following problems may be encountered:
  
  1. A statement or part of a Statement entered beyond the
  delimiter is ignored when more than one statement is entered
  on a given line.
  
  2. When the only statement in the  DDL file, or the last
  statement in the DDL file, does not end with a delimiter, that
  statement is ignored.
  
  3. Processing a CREATE PROCEDURE statement results in error
  ADB9600E / msgadb9600e:
  
  ADB9600E Change Management can not import statements that are
  in the delta change file. Contact IBM Software Support and
  provide the delta change  file.
  
  4. Importing a DDL file with a CREATE PROCEDURE statement
  fails if there is more than one blank between the words CREATE
  and PROCEDURE.
  
  5. Importing a DDL file with a record starting with CREATE in
  position 1 and the statement continuing in the next record
  fails with the following message:
  
  ADB2CID - Now terminating
  

Problem conclusion

• Problems have 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:

Modules/Macros

•    ADBCRCM  ADB2CID  ADB2ISQ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI46779

     UP17/04/29 P F704

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.