IBM Tivoli Monitoring, Version 6.3

Affected attribute groups and supporting scripts

Table 1 shows the attribute groups and summary tables affected for this monitoring agent, the names of the SQL scripts provided to assist in the upgrade process, the types of warehouse databases for which the scripts must be run, and the types of changes (cases) to which the scripts apply.

Table 1. Scripts for affected attribute groups and summary tables for the Monitoring Agent for UNIX OS
Attribute group or summary table	File	DB2®	Oracle	MS SQL Server	Case 1	Case 3
N_F_S_and_R_P_C_Statistics_D	kux_61migr_N_F_S_and_R_P_C_Statistics_D.sql	X			X	X
N_F_S_and_R_P_C_Statistics_H	kux_61migr_N_F_S_and_R_P_C_Statistics_H.sql	X			X	X
N_F_S_and_R_P_C_Statistics_M	kux_61migr_N_F_S_and_R_P_C_Statistics_M.sql	X			X	X
N_F_S_and_R_P_C_Statistics_Q	kux_61migr_N_F_S_and_R_P_C_Statistics_Q.sql	X			X	X
N_F_S_and_R_P_C_Statistics_W	kux_61migr_N_F_S_and_R_P_C_Statistics_W.sql	X			X	X
N_F_S_and_R_P_C_Statistics_Y	kux_61migr_N_F_S_and_R_P_C_Statistics_Y.sql	X			X	X
N_F_S_and_R_P_C_Statistics	kux_61migr_UNIX_OS_Agent_Case-1.sql	X	X	X	X
System_D	kux_61migr_System_D.sql	X				X
System_H	kux_61migr_System_H.sql	X				X
System_M	kux_61migr_System_M.sql	X				X
System_Q	kux_61migr_System_Q.sql	X				X
System_W	kux_61migr_System_W.sql	X				X
System_Y	kux_61migr_System_Y.sql	X				X
Note: The raw table System does not need to be modified even though the corresponding summary tables are modified.

The following types of warehouse objects are affected by these scripts. Review the scripts before running them:

Case-1.sql
These scripts affect raw tables, summary tables, and summary views.
Case-2_Drop.sql
These scripts affect the summary tables, summary views, and the Summarization and Pruning agent WAREHOUSEMARKER table.
Case-2_Truncate.sql
These scripts affect the summary tables and the Summarization and Pruning agent WAREHOUSEMARKER table.

Feedback