A fix is available
APAR status
Closed as program error.
Error description
==Dump title DB2DUMP.PM06818.FTPAUTO.D120629.T025424 "DBL1,ABND=04E-00E20002,U=V4498BI ,M=(N),C=910.RDS -SQL ,DISTRBUTED,LOC=DSNXOCU .DSNSVSVB+06CC" abend of 00E20002 occurred in routine of "Check input parameters." ,and for the block address of x'49_429DB800' In both dumps, RDS control block CAT's BLKSIZE in SM block prefix was overlaid. overlaid block BLKPSIZE=x'00000001' should be x'00000D10' DB2DUMP.PM06818.FTPAUTO.D120629.T025424 _29DB7E8 FFFFF908 00000001 | ..9..... | _29DB7F0 00000000 2665CA47 777B0048 00000000 | .........#...... | _29DB800 20200000 00000D08 C3C1E340 00010000 | ........CAT .... | _29DB810 00000010 00000000 00160000 46160000 | ................ | _29DB820 00000000 01C60001 00000000 00000000 | .....F.......... | _29DB830 00280900 01000000 00000000 599A6F0A | ..............?. | _29DB840 00000000 599A6EE0 00E20000 00000000 | ......>..S...... | _29DB850.:49_429DB86F. LENGTH(X'20')--All bytes contain X'00' _29DC500 00000000 00000000 03030303 637115A9 | ...............z | _29DC510 00000D10 00000FC8 00000000 2558B1A7 | .......H.......x |
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: All users of DB2 for z/OS who have queries * * that have a LIKE, range, or BETWEEN * * predicate containing a column expression, * * where the column in the column expression * * is from a table with a partitioning index * **************************************************************** * PROBLEM DESCRIPTION: A query that has a LIKE, range, or * * BETWEEN predicate containing a column * * expression--where the column in the * * column expression is from a table with * * a partitioning index--can cause an * * abend ABEND04E RC00E20002 at * * DSNXOCU.DSNSVSVB+06CC * **************************************************************** * RECOMMENDATION: * **************************************************************** A query that has a LIKE, range, or BETWEEN predicate containing a column expression--where the column in the column expression is from a table with a partitioning index--can cause an abend ABEND04E RC00E20002 at DSNXOCU.DSNSVSVB+06CC. For example, SELECT ... FROM T1 ... WHERE UPPER ( T1.COL1 ) LIKE 'A%' AND ... T1 has a partitioning index on it. Such a predicate can cause a zero to be used as an index into the CAT array, resulting in two bytes of storage at '1A'x before the 'CAT' eyecatcher to be overlaid. This overlaid storage is referenced later, resulting in the abend. Additional Keywords: SQLLIKE SQLRANGE SQLBETWEEN SQLSTORAGE DB2OVRLAY/K
Problem conclusion
Code is updated to avoid indexing into the array mentioned above with a zero.
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PM68478
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
2012-07-10
Closed date
2012-08-21
Last modified date
2012-10-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK81223 UK81224
Modules/Macros
DSNXOPRS
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:
01 October 2012