A fix is available
APAR status
Closed as program error.
Error description
When using the STEPLIB to include the V10 SDSNLOAD for the TSO BIND job with the V9 DB2 following abend occur. ABEND0C4 from DSNTBAP due to invalid SIBBGENERICL length field. Other ABEND0C4 from various modules are possible. DSNWVAPR DSNSVBK DSNSVSTK ABEND04E RC00E2000E from DSNSFBK . RCIBGENERIC_LEN length field was also incorrect causing more overlay. DB2OVRLAY/K
Local fix
Use the same release TSO with DB2 code.
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 for z/OS executing a * * REMOTE BIND/REBIND across different * * subsystem versions. * **************************************************************** * PROBLEM DESCRIPTION: THE PROBLEM THIS FIX ADDRESSES HAS THE * * FOLLOWING REPORTED SYMPTOMS: * * * * ABEND0C4 RC00000010 * * CSECT DSNSVBK OFFSET0E16 * * * * also possible is * * * * Incorrect error messages when * * using a new V10 function on a * * previous version subsystem * * like V9 * * * * PROBLEM SCENARIO: * * * * The reported error occurred when * * attempting a REMOTE BIND from a V10 * * subsystem to a V9 subsystem. An * * overlay can occur causing the said * * abend. * * * * Additionally, an incorrect error * * message can occur when using a new * * V10 bind parameter with a previous * * version subsystem. * * Here is an example: * * * * Binding from a V10 subsystem to a * * V9 subsystem using the 'APCOMPARE' * * parameter might give you an 'invalid * * keyword' error instead of message * * DSNT263I - csect-name bind-type FOR * * object-type = object-name FAILED * * BECAUSE THE bind-type DEPENDS ON * * FUNCTIONS IN A LATER DB2 RELEASE * * WITH MARK release-dependency-mark * * OR HIGHER. * **************************************************************** * RECOMMENDATION: * **************************************************************** SUMMARY OF DB2 EVENTS: When executing the BIND from a V10 subsystem, DB2 used storage in a control block that was not a compatible size with the V9 DB2 subsystem and subsequently overlaid other storage causing the abend. Additionally, DB2 could use the wrong message handler when a new bind parameter from V10 is passed to a subsystem on a previous DB2 release.
Problem conclusion
DB2 V9 is fixed so that the control block used for the BIND/REBIND is now a compatible size across subsystems. Also, in V10, the error messages have been changed to display the correct message when a new V10 bind parameter is used on a subsystem running a previous release of DB2. ADDITIONAL KEYWORDS: BIND REBIND SQLSTORAGE DB2COEXIST/K DB2OVRLAY/K DB2MIGV10/K
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PM86225
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2013-04-03
Closed date
2013-05-20
Last modified date
2013-07-15
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK94460 UK94461
Modules/Macros
DSN@CP68 DSNECP00 DSNECP08 DSNECP10 DSNECP12 DSNECP13 DSNECP14 DSNECP16 DSNECP17 DSNECP18 DSNECP19 DSNECP20 DSNECP21 DSNECP22 DSNECP23 DSNECP24 DSNECP25 DSNECP26 DSNECP27 DSNECP28 DSNECP29 DSNECP30 DSNECP31 DSNECP40 DSNECP41 DSNECP42 DSNECP44 DSNECP45 DSNECP46 DSNECP47 DSNECP50 DSNECP51 DSNECP54 DSNECP55 DSNECP60 DSNECP61 DSNECP62 DSNECP63 DSNECP66 DSNECP67 DSNECP68 DSNECP69 DSNTBAP DSNTBAP1 DSNTBAP2
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
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":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
15 July 2013