PM65481: KHD ERROR CRITICAL...FILL AREA AFTER UTF8

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The customer noticed that KHD_Error_Critical Situation is
  raised for WPA every 5 minutes:
  . . .
  Tue Nov  1 13:55:07 2011 KO41041    Enterprise situation
  KHD_Error_Critical:zfcuxe71:Warehouse<UNKNOWN> is true.
  . . .
  (4EAF9573.0002-B:khdxjdbc.cpp,2048,"SQL_BindInputParameter")
  ERROR: The value (@?) in the column FILL_AREA after UTF8
  conversion has a length (3) greater than the column size (2)
  . . .
  
  After recreating all NTH datasets error messages were gone away,
  but not for long...
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   The component that transfers DB2         *
  *                     monitoring data collected by the         *
  *                     OMEGAMON collector to the TEMA           *
  *                 -   Tivoli Enterprise Monitoring Agent       *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1.Attribute FILL_AREA in table DPTHEXC  *
  *                      might have garbage that looks like      *
  *                      UTF8 data resulting in "ERROR: The      *
  *                      value (@ ) in the column FILL_AREA      *
  *                      after UTF8 conversion has a length (3)  *
  *                      greater than the column size (2)" from  *
  *                      Warehouse Proxy agent.                  *
  *                                                              *
  *                      2. The following attributes are not in  *
  *                      use or not initialized, and they might  *
  *                      have garbage data:                      *
  *                      - Attribute STAT_IND in table DPTHEXC   *
  *                      - Attribute NOTUSED in table REALTHDA   *
  *                      - Attribute QWHSLOCNVA in table         *
  *                      DPSRMSUB                                *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  1. Attribute FILL_AREA in table DPTHEXC was not in use and was
  not initialized resulting in possible garbage data.
  
  2. The following attributes are not in use or not initialized,
  and they might have garbage data:
  - Attribute STAT_IND in table DPTHEXC
  - Attribute NOTUSED in table REALTHDA
  - Attribute QWHSLOCNVA in table DPSRMSUB
  
  PROBLEM CONCLUSION:
  1. Initialize attribute FILL_AREA in table DPTHEXC with blanks.
  
  2. Initialize the following attributes:
  - Attribute STAT_IND in table DPTHEXC
  - Attribute NOTUSED in table REALTHDA
  - Attribute QWHSLOCNVA in table DPSRMSUB
  

Problem conclusion

• 1. Initialize attribute FILL_AREA in table DPTHEXC with blanks.
  
  2. Initialize the following attributes:
  - Attribute STAT_IND in table DPTHEXC
  - Attribute NOTUSED in table REALTHDA
  - Attribute QWHSLOCNVA in table DPSRMSUB
  
  KEYWORDS : FILL_AREA UTF8 TDW DATA WAREHOUSE NOTUSED QWHSLOCNVA
             STAT_IND
  

Temporary fix

Comments

APAR Information

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

  PM63199

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

  UK81274

Modules/Macros

• KO2APCJA KO2APCJK KO2APCJ2 KO2APCOA KO2APCOK
  KO2APCO2 KO2APC4A KO2APC4K KO2APC42
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R511 PSY UK81274

     UP12/08/25 P F208

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.