Problem:
How to get events from System iSeries Navigator (Management Central).
In Management Central I've set a few metrics to monitor my iSeries server, e.g. "Disk Arm Utilization", "CPU Utilization" or "User Pool Faults".
On these metrics I've set thresholds when metrics get a bad value.
OK, but I would like to see these problems on IBM ITM.
How to do it?
Solution:
1. First, I have to set thresholds, as I've wrote above.
In Management Central, you can see this:
2. Next, in ITM I builded new situatuation:
Done :)
---
If you like this or not - please write any comments below, thanks:)
or if you have any questions please send me email. I'll try to explain more.
Problem:
Sometimes you can get problem with jobs which have MSGW status.
In the job you can see message:
Message . . . . : Reached maximum number of spooled records for file QPRINT
in library QGPL. (C R NOMAX 1-999999)
Solution:
1. Check what is the number of spooled records.
On console type: CHGPRTF FILE(QPRINT) and next press F4 key, then F10 key.
Next Page Down key a few times where you can find position "Max spooled output records". You can change this value to bigger.
2. To change, you can use this command also:
On console type:
CHGPRTF FILE(QPRINT) MAXRCDS(1000000)
but before check that QPRINT object isn't loked:
WRKOBJLCK OBJ(QPRINT) OBJTYPE(*FILE)
Be careful - don't use *NOMAX value.
---
If you like this or not - please write any comments below, thanks:)
or if you have any questions please send me email. I'll try to explain more.
Problem:
How to monitor size of Tivoli Data Warehouse database (TDWH) to reduce space.
I think that a lot of you have a problem with too rapidly growing size of data collected in Data Warehouse database.
Especially when you test new data collections, and some of them after a while you remove, back out of them.
After my tests and under normally work I have to reorganize top of tables (20 tables) to reduce space.
Of course, you can calculate the amount of data being collected and warehoused by the Tivoli agents in yours TDWH. You can use for it by this spreadsheet:
https://www-304.ibm.com/software/brandcatalog/ismlibrary/details?catalog.label=1TW10TM1Y,
but do you have time for it or do you want to use it? :)
Solution:
1. I use ITCAM Agent for DB2, where I used "Customized SQLs" group.
Default, I used properties file: kudcussql.properties where I defined new entries: SELECTSQL
[SELECTSQL]
SQL_ID=sql2
SQL_TEXT= select sum(((decimal(float(t.fpages)/ ( 1024 / (b.pagesize/1024)),9,2)) - (decimal(float(t.npages)/ ( 1024 / (b.pagesize/1024)),9,2)))) as SUMA from syscat.tables t, syscat.tablespaces b where t.tbspace=b.tbspace and tabschema='ITMUSER' and ((float(t.npages)/ ( 1024 / (b.pagesize/1024)) * 100)) / (float(t.fpages)/ ( 1024 / (b.pagesize/1024))) between 1 and 95;
SQL_ID - this is unique name SQL definition
SQL_TEXT - this is my SQL statement
In ITM, you can see this:
2. Next, in ITM I builded new situatuation:
This situation will fired when attribute "First Number Value" will be bigger than 5000 (5GB). After that I reorganize my 20 top of tables to reduce space.
---
If you like this or not - please write any comments below, thanks:)
or if you have any questions please send me email. I'll try to explain more.
