PM63199: KHD ERROR CRITICAL Situation on FILL AREA after UTF8 conversion in Warehouse Proxy agent

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           *
  ****************************************************************
  * 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 DPTHEXC UTF8
  

Temporary fix

Comments

APAR Information

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

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

  PM65481 UK79260

Modules/Macros

• KO2APCAA KO2APCAK KO2APCA2 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

• R510 PSY UK79260

     UP12/06/05 P F206

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.