A fix is available
APAR status
Closed as program error.
Error description
ABEND0C4 RC00000010 DSNXOCSK +4868 when ACCESS CONTROL is active for a table and apar PI16260 is applied. ADDITIONAL SYMPTOMS/KEYWORDS: ============================= ABEND0C4 RC0000003B DSNSLD4 DSNSVSFB at offset06BA ABEND0C4 RC00000010 DSNIDM DSNB1RTR at offset039C ABEND0C4 RC00000038 DSNSLD4 DSNSVSVB at offset0B94 ABEND0C6 RC00000006 DSNXGRDS DSNXEIST at offset0A0E
Local fix
Restore apar PI16260
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 10 and 11 for z/OS users using * * materialized view, table expression * * or common table expression with outer * * joins and row or column access control * * with PI16260 applied. * **************************************************************** * PROBLEM DESCRIPTION: ABND04E at DSNXEDS1.DSNSVSFB * * OFFSET +08FA or ABEND0C4 RC00000010 * * at DSNXGRDS.DSNXOCSK OFFSET +4868 * * may occur with UI21017 (V10) * * or UI21018 (V11) for an SQL statement * * that satisfies all of the following * * conditions: * * 1. The SQL statement contains * * outer joins and table expressions, * * materialized view or common table * * expressions. * * 2. The SQL statement references * * a table which is activated for * * row or column access control. * **************************************************************** * RECOMMENDATION: * **************************************************************** For Example, CREATE TABLE T1 (SSN CHAR(11), SALARY DEC(8,2)); CREATE TABLE T2 (SSN CHAR(11), SALARY DEC(8,2)); CREATE UNIQUE INDEX T2IX ON T2(SSN,SALARY); CREATE PERMISSION T2SSN_PERM ON T2 FOR ROWS WHERE SSN = '000000000' ENFORCED FOR ALL ACCESS ENABLE; COMMIT; ALTER TABLE T2 ACTIVATE ROW ACCESS CONTROL; SELECT Y.CX FROM ( SELECT T1.SSN FROM T1 LEFT JOIN T2 ON T1.SSN = T2.SSN AND T1.SALARY= T2.SALARY) Y(CX) UNION ALL SELECT X.CY FROM (SELECT RAND(),SSN FROM T1)X(CX, CY); Abend may occur for the SQL statement above when table T2 is activated for row or column access control. The abend occurs because DB2 does not free the storage correctly when it performs query rewrite.
Problem conclusion
DB2 has been modified to correctly process the aforementioned SQL statement, so there will be no ABEND. Additional keywords: SQLCTE SQLTBLX SQLJOIN SQLOJ SQLTBLEXPR SQLPERMISSION SQLMASK SQLCOLUMNMASK SQLACCESS SQLCONTROL SQLVIEW
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PI38595
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED PER
PE
YesPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2015-04-08
Closed date
2015-07-10
Last modified date
2015-08-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI29293 UI29294
Modules/Macros
DSNXOB2 DSNXOCU DSNXOMTX DSNXOTDA
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":"10.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":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
03 August 2015