PM63285: DB2 ADMIN TOOL FOR Z/OS WHEN CALLING AN SP WITH LOB OUTPUT PARAMETER RECEIVES SQLCODEN452 AND DATA SET ALLOCATION ERRORS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When DB2 Administration Tool for z/OS CALLing Stored Procedure
  from Panel ADB21O
  with LOB output parameter it receives SQLCODE-452 (SQLCODEN452)
  and data set allocation errors:
  .
  IKJ56709I INVALID DATA SET NAME, '.ADB.LOB.Ddate.Ttime'
  IKJ56701I MISSING DATA SET NAME OR *+
  IKJ56701I MISSING NAME OF DATA SET TO BE ALLOCATED
  IKJ56247I FILE ADBTLOBF NOT FREED, IS NOT ALLOCATED
  .
  ADB2E1 in --------------------- DB2 Error Display 1
  --------------------- hh:mm
  Command ===>
  Rollback done
     SQLCODE : -452                           DSNTIAR CODE :  0
  
  DSNT408I SQLCODE = -452, ERROR:  UNABLE TO ACCESS THE FILE
  REFERENCED BY HOST
           VARIABLE .ADB.LOB.Ddate.Ttime(R0000000). REASON CODE:
   13
  DSNT418I SQLSTATE   = 428A1 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNOLFRV SQL PROCEDURE DETECTING ERROR
  DSNT416I SQLERRD    = 100  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
  DSNT416I SQLERRD    = X'00000064'  X'00000000'  X'00000000'
  X'FFFFFFFF'
           X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION
  .
  It also results in the following messages in SYSLOG:
  .
  IKJ56231I UTILITY DATA SET NOT ALLOCATED, SYSTEM OR INSTALLATION
  ERROR+
  IKJ56231I TEXT UNIT X'0002' CONTAINS INVALID PARAMETER
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the 'CALL - Call' line command  *
  *                 on a stored procedure on panel ADB21O        *
  *                 'Stored Procedures' defined with a LOB       *
  *                 data type and parm type OUT.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the 'CALL - Call' line       *
  *                      command on a stored procedure           *
  *                      from Panel ADB21O an                    *
  *                      SQLCODE=-452 / SQLCODEN452              *
  *                      is received together with a data        *
  *                      set allocation message:                 *
  *                                                              *
  *                      DSNT408I SQLCODE = -452,                *
  *                      ERROR:  UNABLE TO ACCESS THE            *
  *                      FILE REFERENCED BY HOST                 *
  *                      VARIABLE '>dataset name<'               *
  *                      REASON CODE: 13                         *
  *                      DSNT418I SQLSTATE = 428A1               *
  *                      SQLSTATE RETURN CODE                    *
  *                                                              *
  *                      IKJ56709I INVALID DATA SET              *
  *                      NAME, '>dataset name<'                  *
  *                      IKJ56701I MISSING DATA SET              *
  *                      NAME OR *+                              *
  *                      IKJ56701I MISSING NAME OF               *
  *                      DATA SET TO BE ALLOCATED                *
  *                      FILE >lobfile name< NOT FREED,          *
  *                      IS NOT ALLOCATED                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When DB2 Administration Tool for z/OS calls a Stored Procedure
  with the LOB output parameter from Panel ADB21O 'Stored
  Procedures' an SQLCODE=-452 / SQLCODEN452 is received
  together with a data set allocation message:
  
  DSNT408I SQLCODE = -452, ERROR:  UNABLE TO ACCESS THE
  FILE REFERENCED BY HOST VARIABLE .>dataset name<.
  REASON CODE: 13
  DSNT418I SQLSTATE = 428A1
  SQLSTATE RETURN CODE
  
  IKJ56709I INVALID DATA SET
  NAME, '>dataset name<'
  IKJ56701I MISSING DATA SET
  NAME OR *+
  IKJ56701I MISSING NAME OF
  DATA SET TO BE ALLOCATED
  FILE >lobfile name< NOT FREED,
  IS NOT ALLOCATED
  

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:

  UK79468

Modules/Macros

•    ADBMAIN
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK79468

     UP12/06/13 P F206

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.