IBM Support

PI38595: ABEND0C4 RC00000010 DSNXOCSK +4868 WHEN ACCESS CONTROL IS ACTIVE FOR A TABLE AND APAR PI16260 IS APP 15/04/08 PTF PECHANGE

A fix is available

Subscribe

You can track all active APARs for this component.

 

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

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

  • RA10 PSY UI29293

       UP15/07/25 P F507 ®

  • RB10 PSY UI29294

       UP15/07/25 P F507 ®

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