PH65474: Enhancement to ifcid 350

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Enhancement to ifcid 350
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 13 for z/OS users of the Db2 trace   *
  *                 facility and IFCID 350.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR introduces support for        *
  *                      externalizing the current schema name   *
  *                      applied to a dynamic SQL statement in   *
  *                      the trace record IFCID350.              *
  ****************************************************************
  This APAR introduces support for externalizing the current
  schema name applied to a dynamic SQL statement in the trace
  record IFCID350.
  

Problem conclusion

Temporary fix

Comments

• This APAR adds support for externalizing the current schema
  name applied to a dynamic SQL statement in the trace
  record IFCID350.
  Below is the assembly language mapping of QW0350 :
  QW0350 DSECT
  ...
  QW0350TL DS F TOTAL LENGTH OF THE SQL STATEMENT
  QW0350TY DS XL2 Statement information
  QW0350DY EQU X'8000' Statement is dynamic
  QW0350SC EQU X'4000' Statement is static
  QW0350SI DS CL8 Statement Identifier
  QW0350CC DS XL2 Original source CCSID for parser
  QW0350CurrSch_Off DS H Offset to Current Schema ,
                         0 for static SQL
  *
  QW0350CurrSch DSECT Use ifQW0350CurrSch_Off¬=0
  QW0350CurrSch_len DS H Current Schema Length
  QW0350CurrSch_Var DS 0CL128 %U Current Schema
  

APAR Information

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

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

  UO02623

Modules/Macros

• DSNDQW04 DSNHXLTR DSNXEDSC
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RD10 PSY UO02623

     UP25/04/05 P F504  

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.