PI78171: DB2 DOES NOT BLOCK QUERIES REFERENCING COLUMNS WITH DATATYPE TIMESTAMP(0) FROM OFFLOADING: SQLCODE -206 OCCURS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 does not block queries referencing columns with datatype
  timestamp(0) from offloading.  Query results in SQLCODE -206:
  SQL error: SQLCODE = -206, SQLSTATE = 42703, SQLERRMC =
  ACC001.TS0. SQLCODE=-206, SQLSTATE=42703, DRIVER=4.17.30
                                                         (d41216)
  IDAAV5R1/K IDAAV6R1/K
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 11 for z/OS users of Query           *
  *                 Acceleration.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: A query referencing a timestamp(0)      *
  *                      column is mistakenly offloaded to an    *
  *                      accelerator and SQLCODE -206 is         *
  *                      returned.                               *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Before the fix, a query referencing a timestamp(0) column was
  mistakenly offloaded to an accelerator and SQLCODE -206 was
  returned.
  
  For example:
  
      CREATE TABLE TS1 (
          PK              INTEGER         NOT NULL,
          TS0    TIMESTAMP(0)
         );
  
      INSERT statement;
  
      SET CURRENT QUERY ACCELERATION = ALL;
      SELECT PK, TS0 FROM TS1 FOR FETCH ONLY;
  
      The above query returned SQLCODE -206.
  
  After the fix, DB2 will not offload the query to an accelerator
  and ill return SQLCODE -4742 with reason code 11.
  -4742 with reason code 11.
  
  Additional keywords: IDAAV5R1/K IDAAV6R1/K
                       SQLCODE206 SQLCODE4742
  

Problem conclusion

• With this PI78171 fix, DB2 will return SQLCODE -4742
  reason code 11 for a query referencing a timestamp(0)
  column when acceleration is enabled.
  

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:

  UI47657 UI47658

Modules/Macros

• DSNXOEX1 DSNXOOS1
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI47657

     UP17/06/15 P F706

• RB10 PSY UI47658

     UP17/06/15 P F706

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.