480 likes | 929 Views
Install TSM Monitoring and Reporting. Lin Li Systems Engineer Central Ohio Tivoli User Group Meeting October 14, 2010. Agenda. Install TSM 6.2 Reporting and Monitoring. TSM 6.2 Monitoring Configuration. Reporting. TSM RM Installation. Create two users - db2inst1 - itmuser.
E N D
Install TSM Monitoring and Reporting Lin Li Systems Engineer Central Ohio Tivoli User Group Meeting October 14, 2010
Agenda Install TSM 6.2 Reporting and Monitoring TSM 6.2 Monitoring Configuration Reporting
TSM RM Installation Create two users - db2inst1 - itmuser
TSM RM Configuration Monitor server, Tivoli enterprise portal (TEP) server, Warehouse proxy, Summarization and pruning agent, Reporting agent,
TSM RM Configuration (cont.) #cd /opt/tivoli/tsm/itm/bin #CandleManage
TSM RM Configuration (cont.) Create db2 database named WAREHOUS, # db2 update dbm cfg using DFTDBPATH /home/itmuser DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed successfully. # db2 create database WAREHOUS using codeset utf-8 territory US DB20000I The CREATE DATABASE command completed successfully. # db2 connect to WAREHOUS Database Connection Information Database server = DB2/LINUX 9.5.0 SQL authorization ID = ROOT Local database alias = WAREHOUS
TSM RM Configuration (cont.) SQL script for collecting historical data, # cat KHD_DB2_crt_BP_TBSP.sql -- CREATE a Bufferpool of page size 8K CREATE BUFFERPOOL ITMBUF8K IMMEDIATE SIZE 2501 PAGESIZE 8 K; -- CREATE a Regular Tablespace using the 8K Bufferpool CREATE REGULAR TABLESPACE ITMREG8K PAGESIZE 8 K MANAGED BY SYSTEM USING ('itmreg8k') BUFFERPOOL ITMBUF8k; -- CREATE a System tablespace using the 8K Bufferpool CREATE SYSTEM TEMPORARY TABLESPACE ITMSYS8K PAGESIZE 8 K MANAGED BY SYSTEM USING ('itmsys8k') BUFFERPOOL ITMBUF8k; -- CREATE a User tablespace using the 8K Bufferpool CREATE USER TEMPORARY TABLESPACE ITMUSER8K PAGESIZE 8 K MANAGED BY SYSTEM USING ('itmuser8k') BUFFERPOOL ITMBUF8k;
TSM RM Configuration (cont.) Run SQL script, # db2 -stvf KHD_DB2_crt_BP_TBSP.sql CREATE BUFFERPOOL ITMBUF8K IMMEDIATE SIZE 2501 PAGESIZE 8 K DB20000I The SQL command completed successfully. CREATE REGULAR TABLESPACE ITMREG8K PAGESIZE 8 K MANAGED BY SYSTEM USING ('itmreg8k') BUFFERPOOL ITMBUF8k DB20000I The SQL command completed successfully. CREATE SYSTEM TEMPORARY TABLESPACE ITMSYS8K PAGESIZE 8 K MANAGED BY SYSTEM USING ('itmsys8k') BUFFERPOOL ITMBUF8k DB20000I The SQL command completed successfully. CREATE USER TEMPORARY TABLESPACE ITMUSER8K PAGESIZE 8 K MANAGED BY SYSTEM USING ('itmuser8k') BUFFERPOOL ITMBUF8k DB20000I The SQL command completed successfully
TSM RM Configuration (cont.) Grant itmuser permissions, # db2 "GRANT CONNECT ON DATABASE TO USER itmuser" DB20000I The SQL command completed successfully. # db2 "GRANT CREATETAB ON DATABASE TO USER itmuser" DB20000I The SQL command completed successfully
TSM Monitoring Launch http://tsmmon:1920///cnp/kdh/lib/cnp.html - need java plugin
TSM Reporting http://tsmmon:16310
TSM R & M Conclusion - Monitoring - Reporting