A fix is available
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 number
PM63285
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-04-25
Closed date
2012-06-11
Last modified date
2012-07-02
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 July 2012