PI93802: ABEND04E RC00C90101 DSNXEBR ERQUAL5123 OCCURS FOR A SELECT INTO STATEMENT WITH RS USE AND KEEP EXCLUSIVE LOCKS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00C90101 DSNXEBR ERQUAL5123 occurs for a SELECT INTO
  statement WITH RS USE AND KEEP EXCLUSIVE LOCKS or WITH RS USE
  AND KEEP EXCLUSIVE LOCKS
  

Local fix

• Remove USE AND KEEP EXCLUSIVE LOCKS or USE AND KEEP UPDATE LOCKS
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users of the SELECT                      *
  * INTO statement WITH RS USE AND KEEP                          *
  * EXCLUSIVE LOCKS or WITH RS USE AND                           *
  * KEEP UPDATE LOCKS.                                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * An ABEND04E RC00C90101 at DSNXEBR                            *
  * ERQUAL5123 can occur when using                              *
  * the SELECT INTO statement WITH RS                            *
  * USE AND KEEP EXCLUSIVE LOCKS or                              *
  * WITH RS USE AND KEEP UPDATE LOCKS.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  An ABEND04E RC00C90101 at location DSNXEBR ERQUAL5123
  can occur for a query that contains a SELECT INTO statement
  WITH RS USE AND KEEP EXCLUSIVE LOCKS or
  WITH RS USE AND KEEP UPDATE LOCKS specified.
  
  The following example helps to illustrate a failing case.
  
  Step 1. Create Table T1 with an index I11.
  
    CREATE TABLE T1(
                     VAL1 INTEGER,
                     VAL2 CHAR(8),
                     VAL3 CHAR(8),
                     VAL4 INT,
                     VAL5 SMALLINT,
                     VAL6 CHAR(1));
  
    CREATE UNIQUE INDEX I11 ON T1(VAL1);
  
  
  Step 2. Insert a row of data into Table T1.
  
    INSERT INTO T1 VALUES( 1,'ONE','111',1999,90,'A');
  
  
  Step 3. Execute the following SELECT INTO statement.
  
    EXEC SQL
       SELECT VAL4  INTO :INTVAR FROM T1 WHERE VAL1 = 1
       WITH RS USE AND KEEP EXCLUSIVE LOCKS;
  
  This query will result in the above mentioned ABEND.
  
  The expected or correct result is correct result INTVAR=1999.
  

Problem conclusion

• The code in Db2 bind time has been modified to
  correct the conditions leading to the reported
  problems.
  
  Additional Keywords: ABEND04E RC00C90101 SQLSELECTINTO
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI54437

Modules/Macros

• DSNXGRTM
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI54437

     UP18/03/29 P F803

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.