PI04737: CALL LINE COMMAND SQLCODEN480 ERROR: THE PROCEDURE HAS NOT YET BEEN CALLED ON DESCRIBE PROCEDURE STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' CALL 'Call the procedure'
  line command fails with a SQLCODE -480 / SQLCODEN480 and a
  message:
  DSNT408I SQLCODE = -480, ERROR:  THE PROCEDURE
  DBAC.PSDPDV.PSDPOSXN HAS NOT YET
           BEEN CALLED
  DSNT418I SQLSTATE   = 51030 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNXEDCP SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = -280  0  0  -1  0  0 SQL DIAGNOSTIC
   ADB2E2 in --------------------- DB2 Error Display 2 ----------
   Command ===>
  
      SQLCODE : -480                           DSNTIAR CODE :  0
  
  DESCRIBE
  
  DESCRIBE PROCEDURE PSDPDV.PSDPOSXN INTO SQLDA
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who uses the CALL 'Call the procedure'  *
  *                 line command on panel ADB21O 'Stored         *
  *                 Procedures'.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: A SQLCODE=-480 / SQLCODEN480 is         *
  *                      received when calling a procedure       *
  *                      defined with COMMIT ON RETURN YES:      *
  *                                                              *
  *                      DSNT408I SQLCODE = -480, ERROR:         *
  *                      THE PROCEDURE >procedure_name<          *
  *                      HAS NOT YET BEEN CALLED                 *
  *                      DSNT418I SQLSTATE   = 51030             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 is returning a SQLCODE=-480 / SQLCODEN480 on a DESCRIBE
  PROCEDURE if the procedure is defined with COMMIT ON RETURN YES.
  

Problem conclusion

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

  UI13412 UI13413

Modules/Macros

• ADBMAIN  ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI13412

     UP13/12/13 P F312

• RB10 PSY UI13413

     UP13/12/13 P F312

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.