Wednesday, April 9, 2014

My experiments in creating ITCAM RRT scripts






Some pre-reqs, the following processes have to be running.

Or else the server name will not appear in one of the configuration panels.

[root@nc9118041057 bin]# cinfo -r

*********** Thu Oct 17 06:19:49 EDT 2013 ******************
User: root Groups: root bin daemon sys adm disk wheel
Host name : nc9118041057         Installer Lvl:06.30.02.00
CandleHome: /opt/IBM/ITM
***********************************************************
Host          Prod  PID    Owner  Start  ID    ..Status
nc9118041057  ms    7415   root   Oct11  TEMS  ...running
nc9118041057  hd    7769   root   Oct11  None  ...running
nc9118041057  kf    9041   root   Oct11  None  ...running
nc9118041057  lz    9752   root   Oct11  None  ...running
nc9118041057  cq    27376  root   Oct11  None  ...running
nc9118041057  t4    15187  root   05:21  None  ...running
nc9118041057  t6    795    root   05:23  None  ...running
nc9118041057  t3    17018  root   05:25  None  ...running
nc9118041057  t5    633    root   05:26  None  ...running
nc9118041057  sy    26358  root   05:56  None  ...running
nc9118041057  pa    2469   root   06:19  None  ...running

1. How to get the RRT CRT and WRT Fcast tables created.

They get automatically created - but they may not have data.

The summarized tables - will be created but can contain 0 zero data.

The WRT and RRT LT Status and Fcast tables    **** got created ******  after these servers from right to left were configured.










2. If the RRT_LT_Fcast, and RRT_LT_Status has data in the DB ( 675 and so on ), but the summarized tables
RRT_LT_Fcast_H,
RRT_LT_Status_H  does not ??
why ?
This is because the Warehouse interval timing has to be changed to reasonable time - or else wait for the Warehouse collection interval for the records tobe seen.

Samples below.


count from RRT_LT_Status and RRT_LT_Fcast show  675 and 0 ??




Change the frequency of WPA as shown.



Change the frequency of uploads  to 1 minute and 15 minutes and wait for 15 minutes.


How to get the RRT_Transaction_Status Summarized tables created.




Here you will see that the History Summarized tables are not created.

So set the SPA and Pruning attributes.








Go to history panel and check that the Summarization and others are configured.


wait for a few minutes.

you will see that the summarized tables got created.




Once I changed it for RRT and WRT -  within few minutes - I was able to see the data in the Hourly tables.






3. If the Transaction _Over_TIme   issue comes up
then Transaction_Over_Time
                the change for RRT and the WRT is in the file
                /opt/IBM/ITM/li6263/cq/sqllib

                kpi_kcj.sql
                this is our file                  in here - replace the occurences of RRT_Transaction_Over_Time
                there are 4 lines ( but each line has 2 such words )
                grep -i RRT_Transaction_Ovcer_Time will tell - 4 lines.
                but If I search in vi - it will be 8 entries - little confusing.
                I hve to replace them to RRT_Transaction_Status


Rebuild the cq
start cq
and then bring up the browser
and you wll see that the charts are rendered oK ?





4. How to install the 7.3.0.1

First install the ITCAm  7.3.0 and then install the ITCAM  7.3.0.1 IF0020  from the IBM Fix Central
get 7.3.0.1-TIV-CAMRT-IF0020

5 . How to create a RRT Script.



Click on the briefcase button.







Click on the "Create New Transaction"



Now right click on the newly created item and "Create new transaction"




Click on Profiles and attach this to it.





Go to Transaction tab and then click on "ADD".









Go to the lower panel and change the script interval to 1 minute - meaning to run every minute.

Go to Distribution and attach the EM_RBOT and the server under to the left panel.

Go to the Application panel and then  enter the "Command to invoke ": and enter your command to be run.






This lists the new transaction.

Now, check if the transaction tables in DB were created.

This should take care of the creation of history and tasks for ITCAM agents.

1 comment:

  1. WE'RE HIRING NEW LIVE WEBCAM MODELS!
    PROFIT MORE THAN $10,000 EVERY WEEK.
    SIGN-UP AS A BONGA MODELS WEBCAM MODEL TODAY!

    ReplyDelete