PI70070: FPECMAIN GETS "FPEC4035W MORE THAN 100000 UNIQUE LONG STRINGS QUALIFYING FOR UNIQUE NAME PROCESSING FOUND IN THE INPUT DATA"

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Keywords:  FPECMAIN DB2PE DB2PM truncated truncation
  DB2PMFACCT_GENERAL FPEC4035W long strings
  .
  Customer running FPECMAIN to extract SMF records to load into
  DB2PMFACCT_GENERAL table sees truncation of data when receiving
  FPEC4035W  MORE THAN 100000 UNIQUE LONG STRINGS QUALIFYING FOR
  UNIQUE NAME PROCESSING FOUND IN THE INPUT DATA.
  .
  THIS CAN INDICATE AN INPUT DATA PROBLEM. UNIQUE NAME PROCESSING
  HAS BEEN SUSPENDED TO PREVENT PERFORMANCE DEGRADATION."
  .
  long names processing was stopped and after this short names
  were put in reports and FILE output instead of long ones.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - Batch Reporting                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. FPEC4035W message may appear         *
  *                      prematurely in OMPE Batch Reporter JOB  *
  *                      SUMMARY LOG because related counter     *
  *                      mistakenly incremented in attempt to    *
  *                      register already registered long        *
  *                      string.                                 *
  *                                                              *
  *                      2. Truncated or unique strings have     *
  *                      been externalized to VARCHAR type       *
  *                      fields of ACCOUNTING FILE instead of    *
  *                      available long strings.                 *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF.                              *
  ****************************************************************
  PROBLEM SUMMARY:
  1. FPEC4035W message may appear prematurely in OMPE Batch
  Reporter JOB SUMMARY LOG because related counter mistakenly
  incremented in attempt to register already registered long
  string. That may cause truncated short names appear in reports
  instead of unique short names.
  
  2. Truncated or unique short names have been externalized to
  VARCHAR type fields of ACCOUNTING FILE instead of available
  DB2 provided long names. That may complicate aggregation short
  identifiers mapping to their original long names.
  
  PROBLEM CONCLUSION:
  The code has been changed to fix these problems.
  
  KEYWORDS:
  OMPE BATCH ACCOUNTING REPORT FILE FPEC4035W
  

Problem conclusion

• The code has been changed to fix these problems.
  

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:

  UI45703 UI45704 UI45705 PI79525

Modules/Macros

• DGOAFBUF DGOAFDDF DGOAFGBP DGOAFGEN DGOAFISA DGOAFPCK FPECHE15
  FPEUFLNS FPEUFLN2 FPEUIFCI FPEUIFC2
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R511 PSY UI45703

     UP17/03/24 P F703

• R520 PSY UI45704

     UP17/03/24 P F703

• R530 PSY UI45705

     UP17/03/24 P F703

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.