PI67767: IFCID 55 CONTAINS AN INCORRECT VALUE FOR QW0055NI_OFF

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• IFCID 055 has an incorrect value for QW0055NI_Off.  This is the
  scenario:  Start a performance trace for IFCID 55  (SET CURRENT
  SQLID) for an ID longer than 8 bytes. The generated IFCID 55
  trace record is processed via IFI READA.  The IFI return area
  correctly shows a truncated value for the 8-byte field QW0055NI.
  In this case, field QW0055NI_Off should contain the offset to
  DSECT QW0055NI_D with the un-truncated value.   Instead, the
  offset value in QW0055NI_Off is 2, and points into QW0055OI.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 and DB2 11 for z/OS users of the  *
  *                 IFCID 55 trace.                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Incorrect IFCID 55 (IFCID055) trace     *
  *                      records can be returned when non-       *
  *                      alphanumeric Unicode characters are     *
  *                      written for the CURRENT SQLID special   *
  *                      register.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Incorrect IFCID 55 trace records can be returned when
  non-alphanumeric Unicode characters are written for the
  CURRENT SQLID special register.
  
  The following example helps to illustrate the problem.
  
  Start a performance trace for IFCID 55. Specify that the trace
  output should be in Unicode, and then issue the SQL statement:
  
    SET CURRENT SQLID = 'IBMDB2$¢';
  
  Note that some non-alphanumeric characters in Unicode may need
  more than one byte per character to be represented and that the
  new SQLID 'IBMDB2$¢' is longer than eight bytes in Unicode
  because of this.
  
  The IFCID 55 trace record shows a truncated value correctly for
  the new SQLID field QW0055NI. However, the value of the field
  QW0055NI_Off (offset from QW0055 to the new SQLID field) is
  incorrect. Also, the field QW0055NI_Len (length of the new
  SQLID field) is missing in the trace record.
  
  The above errors occur because DB2 does not set the fields
  QW0055NI_Off and QW0055NI_Len for the IFCID055 trace record
  properly.
  

Problem conclusion

• DB2 code has been modified to set the fields QW0055NI_Off and
  QW0055NI_Len correctly to prevent the incorrect IFCID055 trace
  records.
  
  Please note, APAR PI67898 provides the solution for DB2 12.
  
  
  Additional Keywords: IFCID055 SQLCCSID DB2INCORR/K INCORROUT
                       SQLINCORR SQLINCORROUT
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UI41910 UI41911

Modules/Macros

• DSNXRSPG DSNXRSP9 DSNXRST
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI41910

     UP16/11/08 P F611 Ž

• RB10 PSY UI41911

     UP16/11/08 P F611 Ž

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.