IY95967: SSM/ASM AGENT UNABLE TO SUPPORT MS SQL SERVER 2005 CORRECTLY

IBM Tivoli 4.0.0-TIV-SSM-FP0010
IBM Tivoli 4.0.0-TIV-SSM-FP0011
IBM Netcool System Service Monitor SSM 4.0 Fix Pack 12 README 4.0.0-TIV-SSM-FP0012
IBM Netcool System Service Monitor SSM 4.0 Fix Pack 13 README 4.0.0-TIV-SSM-FP0013
IBM Netcool System Service Monitor SSM 4.0 Fix Pack 14 README 4.0.0-TIV-SSM-FP0014
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 1 README 4.0.0.14-TIV-SSM-IF0001
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 2 README 4.0.0.14-TIV-SSM-IF0002
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 3 README 4.0.0.14-TIV-SSM-IF0003
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 4 README 4.0.0.14-TIV-SSM-IF0004
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 5 README 4.0.0.14-TIV-SSM-IF0005
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 6 README 4.0.0.14-TIV-SSM-IF0006
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 7 README 4.0.0.14-TIV-SSM-IF0007
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 8 README 4.0.0.14-TIV-SSM-IF0008
IBM Netcool System Service Monitor SSM 4.0 Interim Fix 1 README 4.0.0.15-TIV-SSM-IF0001

APAR status

• Closed as program error.

Error description

• Customer are running ASM Agent 3.2.1 with the patches provided
  in PMR
  52771,999,616.
  ASM agent is running on Windows 2003 Server with MS SQL Server
  2005.
  The details on the enviroment has been provided in PMR
  52771,999,616.
  Using a MIB Explorer to browse the ASM, under "private >
  networkharmonics > applications > sqlsvr", these do NOT have any
  information (i.e. rows are blank):
  "sqlsvrStatistics > sqlsvrDbFilesTable"
  "sqlsvrStatistics > sqlsvrDbPerfTable"
  "sqlsvrStatistics > sqlsvrDbLocksTable"
  "sqlsvrStatistics > sqlsvrDbCacheMgrTable"
  

Local fix

• No Fix yet
  

Problem summary

• Ensure that all table/row data are populated (i.e. not
  missing) for MSSQL 2005.
  

Problem conclusion

• Fix for this is available in fix pack 3.2.0-TIV-SSM-LA0748 and
  above.
  

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

  NETCOOL SYS SVC

• Fixed component ID

  5724P4300

Applicable component levels

• R320 PSY

     UP