PH32428: WITH IZDS/IZPCA TABLES TCP_FTP_CLIENT_H/D/W, COLUMN LOCAL_PORT PREVENTS SUMMARIZATION OF DATA AT THE HOURLY,DAILY,WEEKLY LEVEL.

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• With IzDS/IzPCA tables TCP_FTP_CLIENT_H/D/W, column LOCAL_PORT
  prevents summarization of data at the hourly,daily,weekly level.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: TDSz/IZDS/IZPCA users of the TCP/IP for z/OS *
  *                 component.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Data at the hourly, daily and weekly    *
  *                      levels for the tables TCP_FTP_CLIENT_*  *
  *                      is not being summarized.                *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  The values in the TCP_FTP_CLIENT_* tables are not summarizing to
  hourly, daily and weekly level due to columns LOCAL_PORT and
  FOREIGN_PORT being in the primary keys which is causing the
  data to be too granular.
  

Problem conclusion

Temporary fix

Comments

• Alter fields LOCAL_PORT and FOREIGN_PORT to non-primary keys in
  tables TCP_FTP_CLIENT_D, TCP_FTP_CLIENT_H and
  TCP_FTP_CLIENT_W to allow summarization of the data.
  

APAR Information

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

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

  UI75689 UI75690 UI75692 UI75693 UI75696 UI75697 UI75698 UI75699
  UI75701 UI75702

Modules/Macros

• DRLJCPL5 DRLTTFTC DRLUTFTC
  

Fix information

• Fixed component name

  TDS FOR Z/OS

• Fixed component ID

  569510100

Applicable component levels

• R801 PSY UI75689

     UP21/06/09 P F106

• R802 PSY UI75696

     UP21/06/09 P F106

• R80A PSY UI75693

     UP21/06/09 P F106

• R810 PSY UI75692

     UP21/06/09 P F106

• R8A0 PSY UI75690

     UP21/06/09 P F106

• R8A9 PSY UI75697

     UP21/06/09 P F106

• R901 PSY UI75698

     UP21/06/09 P F106

• R9A0 PSY UI75699

     UP21/06/09 P F106

• RC01 PSY UI75701

     UP21/06/09 P F106

• RCA0 PSY UI75702

     UP21/06/09 P F106

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.