IV54849: KNP_POLL_DATA_COLLECTION TABLE ATTRIBUTES NOT SYNCHRONIZED

3.9.0-TIV-ITNMIP-Solaris-FP0005
3.9.0_INSTALL_NLS_FP0005
3.9.0_INSTALL_FP0005
3.9.0-TIV-ITNMIP-Windows-FP0005
3.9.0-TIV-ITNMIP-zLinux-FP0005
3.9.0-TIV-ITNMIP-Linux-FP0005
3.9.0-TIV-ITNMIP-AIX-FP0005
IBM Tivoli Network Manager IP Edition 3.9.0 Fix Pack 5, 3.9.0-TIV-ITNMIP-FP0005

APAR status

• Closed as program error.

Error description

• ENV: ITNM 3.9  with np agent and TDW in place.
  
  Problem: The table characteristics are not synchronized between
  the NCIM and TDW databases.  Some tables in TDW have a smaller
  varchar value than in the NCIM db.  This causes some fields to
  be truncated in the TDW database.
  Need to ensure that any data that is stored in the TDW database
  will not be truncated because of a difference in table
  characteristics
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All ITNM 3.9 users..                                         *
  * The users that use TDW to store performance data             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Some of the KNP_POLL_DATA_COLLECTION table have truncated    *
  * data on TDW due to the fields size don't match what is       *
  * defined at ITNM                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * | fix pack | 3.9.0-ITNMIP-FP0005                             *
  * Update the ITM agent on ITNM server. and ITNM agent support  *
  * on TEMS, TEPS and TEPD. The user also need to update the     *
  * KNP_POLL_DATA_COLLECTION table manually via command          *
  *  db2 "ALTER TABLE ITMUSER.KNP_POLL_DATA_COLLECTION ALTER     *
  * COLUMN DOMAIN_NAME SET DATA TYPE VARCHAR ( 64 ) ALTER COLUMN *
  * POLLER_NAME SET DATA TYPE VARCHAR ( 255 ) ALTER COLUMN       *
  * POLICY_NAME SET DATA TYPE VARCHAR ( 250 ) ALTER COLUMN       *
  * HOSTNAME SET DATA TYPE VARCHAR ( 255 ) ALTER COLUMN          *
  * INSTANCE_NAME SET DATA TYPE VARCHAR ( 255 ) ALTER COLUMN     *
  * IFNAME SET DATA TYPE VARCHAR ( 255 ) ALTER COLUMN            *
  * POLLDEF_NAME SET DATA TYPE VARCHAR ( 255 ) ALTER COLUMN OID  *
  * SET DATA TYPE VARCHAR ( 255 ) "                              *
  ****************************************************************
  

Problem conclusion

• After upgrading the agent and KNP_POLL_DATA_COLLECTION table it
  will no longer show truncated data on TDW
  

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:

Fix information

• Fixed component name

  TIV NETWK MGR I

• Fixed component ID

  5724S4500

Applicable component levels

• R390 PSN

     UP

• R390 PSY

     UP

• R401 PSN

     UP

• R401 PSY

     UP

• R410 PSN

     UP

• R410 PSY

     UP