PH52696: DRL0350E OVERFLOW OCCURRED IN DB2 COLUMNS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DRL0350E Overflow occurred in Db2 columns
  for table DRL.CICS_S_STOR_DSA_D fields
  GETMAINS and FREEMAINS.
  
  for table CP_DB2_PACK_M field
  PKG_COUNT.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All customers using:                         *
  *                 IBM Z Decision Support Version 1.9.0         *
  *                 and IBM Z Performance and Capacity           *
  *                 Analytics Version 3.1.0 getting overflow     *
  *                 conditions collecting CICS, MVSPM or         *
  *                 Capacity Planning Db2 data.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: During a collect, the following         *
  *                      messages are issued.                    *
  *                      DRL0350E Overflow occurred in Db2       *
  *                      column GETMAINS in table                *
  *                      CICS_S_STOR_DSA_D.                      *
  *                      DRL0350E Overflow occurred in Db2       *
  *                      column FREEMAINS in table               *
  *                      CICS_S_STOR_DSA_D.                      *
  *                      DRL0350E Overflow occurred in Db2       *
  *                      column SERVED_NO in table               *
  *                      MVSPM_WLM_SERVED_H.                     *
  *                      DRL0350E Overflow occurred in Db2       *
  *                      column PKG_COUNT in table               *
  *                      CP_DB2_PACK_M.                          *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTFs.                     *
  ****************************************************************
  The values being collected in the columns:
  GETMAINS in table CICS_S_STOR_DSA_D,
  FREEMAINS in table CICS_S_STOR_DSA_D,
  SERVED_NO in table MVSPM_WLM_SERVED_H,
  PKG_COUNT in table CP_DB2_PACK_M,
  are too large for an INTEGER field.
  

Problem conclusion

• The fields:
  GETMAINS in table CICS_S_STOR_DSA_D,
  FREEMAINS in table CICS_S_STOR_DSA_D,
  SERVED_NO in table MVSPM_WLM_SERVED_H,
  PKG_COUNT in table CP_DB2_PACK_M,
  are changed to FLOAT.
  This is done across all table levels for consistency of
  reporting.
  

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:

  UI91068 UI91069 UI91070 UI91071 UI91072 UI91073 UI91074

Modules/Macros

• DRLRS072 DRLTC814 DRLTCPD1 DRLTMPWX
  

Fix information

• Fixed component name

  TDS FOR Z/OS

• Fixed component ID

  569510100

Applicable component levels

• R901 PSY UI91068

     UP23/03/29 P F303

• R9A0 PSY UI91069

     UP23/03/29 P F303

• R9A2 PSY UI91070

     UP23/03/29 P F303

• RC01 PSY UI91071

     UP23/03/29 P F303

• RCA0 PSY UI91072

     UP23/03/29 P F303

• RCA2 PSY UI91073

     UP23/03/29 P F303

• RCA8 PSY UI91074

     UP23/03/29 P F303

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.