PI70920: ACCELERATED QUERY USING TIMEZONE OR CURRENT TIMEZONE TERMINATES WITH SQLCODE104N

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Accelerated query using TIMEZONE or CURRENT TIMEZONE terminates
  with sqlcode104n independent if AOT or usual IDAA enabled table.
  
  Create table tb18898a
  ( BEGIN_REC_TSTAMP timestamp
  ) in ACCELERATOR <name>
  ;
  set current query acceleration enable
  ;
  SELECT  DATE(BEGIN_REC_TSTAMP + CURRENT TIMEZONE)
  FROM TB18898A WITH UR
  ;
  receive:
  
  DSNT408I SQLCODE =   -104, SQLSTATE = 42601, SYNTAX ERROR OR
  ACCESS RULE VIOLATION FROM ??? TOKENS ) keyword
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 for z/OS users of QUERY ACCELERATION *
  *                 who run queries with CURRENT TIMEZONE        *
  *                 specified.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 for z/OS may incorrectly result     *
  *                      in SQLCODE -104 on queries using        *
  *                      CURRENT TIMEZONE when query             *
  *                      acceleration is enabled.                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 for z/OS may incorrectly result in SQLCODE -104 when
  running queries using CURRENT TIMEZONE when query acceleration
  is enabled because DB2 for z/OS fails to block offloading
  of such queries.
  

Problem conclusion

• DB2 for z/OS has been modified to block offloading queries
  using CURRENT TIMEZONE.
  
  ADDITIONAL KEYWORDS:
  SQLCODE104 IDAAV4R1/K IDAAV5R1/K IDAAV6R1/K IDAAV7R1/K
  

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:

  UI44005

Modules/Macros

•    DSNXOBAM DSNXOEX1 DSNXOOS1
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI44005

     UP17/02/02 P F702

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.