PH37764: BATCH ACCOUNTING SAVE, INCORRECT DATA TYPE OF COLUMN RID_POOL_FAIL_NOTC

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Batch Accounting SAVE, incorrect data type of column
  RID_POOL_FAIL_NOTC
  

Local fix

• Update HLQ.TKO2SAMP(DGOAUPDB) change DECIMAL(19,0) to DOUBLE
  PRECISION as the following:
  Before:
   ALTER TABLE DB2PMSACCT_GENERAL ADD COLUMN
   RID_POOL_FAIL_NOTC DECIMAL(19,0)
   NOT NULL WITH DEFAULT;
  After:
   ALTER TABLE DB2PMSACCT_GENERAL ADD COLUMN
   RID_POOL_FAIL_NOTC DOUBLE PRECISION
   NOT NULL WITH DEFAULT;
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2 PM                *
  *                 users of component:                          *
  *                 - Batch report SAVE file / PDB               *
  ****************************************************************
  * PROBLEM DESCRIPTION: Incorrect data type for column          *
  *                      RID_POOL_FAIL_NOTC in module DGOAUPDB   *
  ****************************************************************
  * RECOMMENDATION: Apply PTF.                                   *
  ****************************************************************
  Incorrect data type in ALTER table DB2PMSACCT_GENERAL statement
  for column RID_POOL_FAIL_NOTC in module TKO2SAMP(DGOAUPDB)
  

Problem conclusion

• Data type for RID_POOL_FAIL_NOTC in DGOAUPDB for table
  DB2PMSACCT_GENERAL changed from DECIMAL to DOUBLE PRECISION
  
  Keywords:
  OMPE BATCH DGOAUPDB PDB SAVE
  

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:

Modules/Macros

• DGOAUPDB DGOVMSTR FPEVDB2C FPEVDB2I KD5AGENT KO2ABROW KO2ACONB
  KO2APCL2 KO2APCLK KO2APCLS KO2APHLR KO2CCAFB KO2CDIN2 KO2CDINK
  KO2CDINS KO2CIF12 KO2CIF1K KO2CIF1S KO2CIF22 KO2CIF2K KO2CIF2S
  KO2CIF32 KO2CIF3K KO2CIF3S KO2CIF42 KO2CIF4K KO2CIF4S KO2CIF52
  KO2CIF5K KO2CIF5S KO2CIF62 KO2CIF6K KO2CIF6S KO2CIF72 KO2CIF7K
  KO2CIF7S KO2CIF82 KO2CIF8K KO2CIF8S KO2CIF92 KO2CIF9K KO2CIF9S
  KO2CIFAB KO2CIFBB KO2CIFCB KO2CIFDB KO2CIFEB KO2CIFI2 KO2CIFIK
  KO2CIFIS KO2CMVSF KO2CTHB2 KO2CTHBK KO2CTHBS KO2CTHC2 KO2CTHCK
  KO2CTHCS KO2CTHD2 KO2CTHDK KO2CTHDS KO2CTHE2 KO2CTHEK KO2CTHES
  KO2CTHJ2 KO2CTHJK KO2CTHJS KO2CTHN2 KO2CTHNK KO2CTHNS KO2CTHO2
  KO2CTHOK KO2CTHOS KO2DATA  KO2HHQIB KO2HPR1B KO2HSQIB KO2HWLMB
  KO2INCAP KO2NDRVB KO2OAPIB KO2OCMCB KO2OENDB KO2OINTB KO2OQAL2
  KO2OQALK KO2OQALS KO2ORCVB KO2OROUB KO2OTH8B KO2OTHGB KO2WTCA2
  KO2WTCAK KO2WTCAS KO2XSY22 KO2XSY2K KO2XSY2S KO2XTHS2 KO2XTHSK
  KO2XTHSS KO2ZAPI  KO2ZASY  KO2ZIFI  KO2ZRTO  KO2ZSYN  KO2ZTDC
  KO2ZTOP  KO2ZTRK  KO2ZWTO  KO2ZZRM
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R540 PSY UI76444

     UP21/07/27 P F107

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.