PH60668: A SQLCODE -243 MAY BE ISSUED INCORRECTLY FOR A SIMPLE STATEMENT USED AS 'SENSITIVE STATIC SCROLL' CURSOR.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A SQLCODE -243 may be issued incorrectly for a simple statement
  used as 'SENSITIVE STATIC SCROLL' CURSOR.
  The issue may happen when QUERY_ACCEL_OPTIONS 11 is ON and when
  Accelerator Modeling is ON.
  Both static and dynamic queries are affected, as long as the
  statement has attribute 'SENSITIVE STATIC SCROLL'.
  
  ADDITIONAL SYMPTOMS:
  SQLCODE243 SQLSENSITIVE SQLSCROLL
  

Local fix

• BYPASS/CIRCUMVENTION:
  Please try to either don't use QUERY_ACCEL_OPTIONS 11 or don't
  use Accelerator Modeling (ACCELMODEL). For static statements,
  please try to bind with EXPLAIN(YES) instead of editing zPARMs.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 12 and 13 for z/OS users who use     *
  *                 IBM Db2 Analytics Accelerator V7.            *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE -243 may occur for SQL query    *
  *                      with SENSITIVE STATIC SCROLL            *
  *                      scrollable CURSOR.                      *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  SQLCODE -243 may occur for a static
    or dynamic SQL query when ALL of the
    following conditions apply:
    (1) Db2z subsystem parameter
        ACCELMODEL = YES for Db2
        Accelerator Modeling,
    (2) Db2z subsystem parameter
        QUERY_ACCEL_OPTIONS value 11
        is ON(USE ONLY NEW
        ACCELERATOR_TYPE),
    (3) the query uses a SENSITIVE
        STATIC SCROLL scrollable cursor,
    (4) for static query, EXPLAIN(NO)
        bind option is used (NO is the
        default),
        for dynamic query, CURRENT
        EXPLAIN MODE = NO (NO is the
        default).
    For a static query, the -243 occurs
    during BIND / REBIND PACKAGE for
    application.
    For a dynamic query, the -243 occurs
    at execution-time during full
    PREPARE for the dynamic query.
  
  Additional Keywords:
      IDAAV7R1/K IDAAV7R5/K
      SQLCODE243 SQLSENSITIVE SQLSCROLL
      SQLACCELMODEL SQLEXPLAIN
  

Problem conclusion

• Db2 V12 and V13 code for Accelerator Modeling was changed to
  not issue SQLCODE -243 for a query with a SENSITIVE STATIC
  SCROLL cursor , allowing the BIND/REBIND PACKAGE for static
  query and full PREPARE for dynamic query to succeed.
  

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:

  UI97204 UI97205

Modules/Macros

• DSNXOBZO
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI97204

     UP24/06/14 P F406

• RD10 PSY UI97205

     UP24/06/14 P F406

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.