A fix is available
APAR status
Closed as program error.
Error description
Update sql got abend04e DSNILKDY:1002 when a CHANGE part lock (LKNMPART, func=03, stat=03, dura=41) failed due to invalid token (INVTOKEN IRLM rc/rsn=0010/0400, RLPRCB6=on). The invalid lock token would have been incorrectly obtained from an agent related pageset block.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL DB2 V12 for z/OS users that use * * partition by growth table spaces * **************************************************************** * PROBLEM DESCRIPTION: * * ABND=04E-00C90101 in DSNILKDY * * with ERQUAL1002 during change * * part lock request on a partition * * by growth table space. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** During a change part lock request on a partition by growth table space there is a timing window that may cause DB2 to lose track of the part lock on its last partition. This could cause an invalid lock token to be taken later and then ABEND=04E-00C90101 at DSNILKDY:1002.
Problem conclusion
Fixes made in DB2 to get the correct number of partitions for a partitioned by growth table space during a change lock request.
Temporary fix
Comments
APAR Information
APAR number
PI78862
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-03-27
Closed date
2017-09-13
Last modified date
2017-10-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI50288
Modules/Macros
DSNILKDY
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI50288
UP17/09/28 P F709
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":"12.0","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":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 October 2017