PH54056: DB2 13 FOR Z/OS NEW FUNCTION FOR THE BIND QUERY COMMAND

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Db2 13 for z/OS new function for the BIND QUERY command.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 13 for z/OS users using BIND QUERY                   *
  * and statement-level plan hints for the                       *
  * queries from SQL PL packages.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Currently Db2 subcommand BIND QUERY                          *
  * will issue DSNT281I error message                            *
  * when processing a statement from                             *
  * DSN_USERQUERY_TABLE with the                                 *
  * DSN_USERQUERY_TABLE.TYPE='N'. It                             *
  * results in that Db2 can't populate                           *
  * the access plan hint for the                                 *
  * statements from a SQL PL package with                        *
  * the SYSPACKAGE.TYPE='N' thus can't                           *
  * enforce statement-level hints on the                         *
  * statements from SQL PL packages.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Currently Db2 subcommand BIND QUERY will issue DSNT281I error
  message when processing a statement from DSN_USERQUERY_TABLE
  with the DSN_USERQUERY_TABLE.TYPE='N'. It results in that Db2
  can't populate the access plan hint for the statements from a
  SQL PL package with the SYSPACKAGE.TYPE='N' thus can't
  enforce statement-level hints on the statements from SQL PL
  packages.
  PH54056 will relax this restriction on BIND QUERY subcommand
  and allow to enforce statement-level hints on the statements
  from SQL PL packages.
  

Problem conclusion

Temporary fix

Comments

• PH54056 will relax this restriction on BIND QUERY subcommand
  and allow to enforce statement-level hints on the statements
  from SQL PL packages.
  

APAR Information

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

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

  UI93723

Modules/Macros

• DSNXOBNQ
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RD10 PSY UI93723

     UP23/10/04 P F310

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.