A fix is available
APAR status
Closed as program error.
Error description
During abend, DB2 was trying to insert a record into a catalog table SYSIBM.SYSTABAUTH. According to the DDL of SYSTABAUTH, the first column is VARCHAR (128), the length is x'80'. But the length trying to move is x'400', thus DB2 abend. Additional Symptoms: ABEND0C4-00000004 DSNXAANC + 1C9A
Local fix
remove UK53070
Problem summary
**************************************************************** * USERS AFFECTED: Users that have applied PK92315. * **************************************************************** * PROBLEM DESCRIPTION: V8: * * - ABEND04E RC00C90101 at DSNIZMOS:5002 * * - ABEND04E RC00E50001 at DSNSVSGM+0334 * * - ABEND04E RC00E70005 at DSNXAAPC:P120 * * - ABEND0C4 RC00000004 at DSNSVSTK+05D8 * * - ABEND0C4 RC00000004 at DSNXAAPC+1D96 * * V9: * * - ABEND04E RC00C90101 at DSNIBNRF:5002 * * - ABEND04E RC00E70005 at DSNXAAPC:P120 * * - ABEND0C4 RC00000004 at DSNXASPC+090C * **************************************************************** * RECOMMENDATION: * **************************************************************** With PK92315 (UK53070 V8, UK53071 V9) applied, during an authorization check an abend occurred with dump titles like the following: V8: XXXX,ABND=04E-00C90101,U=YYYYYYY ,M=(N), C=810.DMC -DSNIISRT,M=DSNTFRCV, LOC=DSNIDM .DSNIZMOS:5002 XXXX,ABND=04E-00E50001,U=YYYYYYYY,M=(N),C=810.LOCN=ZZZZZZZZZZZ ,LOC=DSNSLD4 .DSNSVSGM+0334 XXXX,ABND=04E-00E70005,U=YYYYYYYY,M=(N),C=810.LOCN=ZZZZZZZZZZZ ,LOC=DSNXAUTH.DSNXAAPC:P120 XXXX,ABND=0C4-00000004,U=YYYYYY ,M=(N),C=810.SCC -SHUTDOWN,M=DSNTFRCV,LOC=DSNSLD1 .DSNSVSTK+05D8 XXXX,ABND=0C4-00000004,U=YYYYYYY ,M=(N),C=810.RDS -SQL ,M=DSNTFRCV,LOC=DSNXAUTH.DSNXAAPC+1D96 V9: XXXX,ABND=04E-00C90101,U=YYYYYY ,M=(N),C=910.DMC -DSNIISRT,M=DSNTFRCV,LOC=DSNIDM .DSNIBNRF:5002 XXXX,ABND=04E-00E70005,U=YYYYYY ,M=(N),C=910.RDS -SQL ,M=DS NTFRCV,LOC=DSNXAUTH.DSNXAAPC:P120 XXXX,ABND=0C4-00000010,U=YYYYYB ,M=(N),C=910.LOCN=ZZZZZZZZZZ ,LOC=DSNXAUTH.DSNXASPC+090C The V9, 0C4 at DSNXASPC+090C occurred because the authid type (user or role) was not included in the building of the package and routine authorization caches. This resulted in an overlay of the next cache entry. The rest of the abends are related to the use of an invalid length for a varchar field. It is invalid because it was not initialized on entry to the module.
Problem conclusion
Code has been changed to initialize the length field and to include the authid type in the V9 package and routine authorization cache builds. If you are using an external security system other than RACF (DSNXRXAC) to perform authorization on DB2 resources using the access control authorization exit (DSNX@XAC), contact its vendor to ensure it uses this exit's interface as documented in the DB2 Administration Guide.
Temporary fix
Comments
APAR Information
APAR number
PM05218
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
810
Status
CLOSED PER
PE
YesPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-01-15
Closed date
2010-04-08
Last modified date
2010-10-12
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK55934 UK55936
Modules/Macros
DSNXAANC DSNXAAPC DSNXAPAC DSNXA02 DSNXINIT
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":"8.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":"8.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
12 October 2010