PI92704: INZU521E DISPLAYS A WRONG LIST OF ALLOWED STARTING KEYWORDS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The INZU521E message issued when a date/time or timestamp
  user-defined format string does not start with an allowed
  keyword does not remind the relevant list of the allowed
  keywords for the involved data type. The indicated list merges
  the items allowed for all the date/time and timestamp formats
  instead which is misleading.
  
  PB51203
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of High Performance Unload                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * PI91438:                                                     *
  * Incorrect LOAD control cards are generated if a LOADOPT      *
  * option specifies "SHRLEVEL keyword". "keyword" is generated  *
  * instead of the expected "SHRLEVEL keyword" option. This      *
  * occurs if the keyword is different from NONE and CHANGE.     *
  *                                                              *
  * PI92553:                                                     *
  * A logical unload fails after the following message has been  *
  * issued:                                                      *
  *                                                              *
  * DSNT408I SQLCODE = -4742, ERROR: THE STATEMENT CANNOT BE     *
  * EXECUTED BY DB2 OR IN THE ACCELERATOR (REASON 4)             *
  *                                                              *
  * This occurs if all the following conditions are fulfilled:   *
  * - the fix for PI84324 (PB49786) has been applied             *
  * - the QUERY_ACCELERATION feature is applicable (i.e. DB2     *
  * FORCE is specified and neither - the DB2 HPU                 *
  * QUERY_ACCELERATION NONE option nor the DB2 setting           *
  * QUERY_ACCELERATION=NONE is specified                         *
  * - the involved SELECT statement is not a read-only statement *
  *                                                              *
  * PI92704:                                                     *
  * The INZU521E message issued when a date/time or timestamp    *
  * user-defined format string does not start with an allowed    *
  * keyword does not remind the relevant list of the allowed     *
  * keywords for the involved data type. The indicated list      *
  * merges the items allowed for all the date/time and timestamp *
  * formats instead which is misleading.                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the PTF for problem resolution                         *
  ****************************************************************
  

Problem conclusion

• Code has been changed to fix this problem
  

Temporary fix

• PI92553: Add the FOR READ ONLY clause to the involved SELECT
  statement.
  

Comments

APAR Information

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

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

  UI53554

Modules/Macros

• INZMQRY  INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI53554

     UP18/02/02 P F802

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.