Review CPU, Memory, IO, contentions
Latches, Locks, Wait Events
Database Objects Status (Invalid)
Verify Database Backups

IDS 9 - AIX 5.3

Hi all,

Actually I am from DB2 UDB. For an adhoc situation my manager wants me to write a shell script for the above.

Any help will be appreciated.


Reagards
DBFinder

CPU utilization you can get from

TOP command or VMSTAT


Memory utilization for informix

do


Onstat -|awk '{print $(NF-1) }'

this will solve your memory purpose;



Backups :


online logs in informix records message about Backup started and backup ended/aborted/successful;


it depends on which backup utility you use to take backup ie either onbar or ontape;

Thanks, good info.

Can some one help me with locks ( currently held locks ) and application owning these locks ?

Regards

with onstat -k
it will list active locks, type of lock ( exclusive, shared, for update etc..), tcb of the owner's session, locked object

This needs a bit of practice to read, but this is fast.
Else you can pick a more human readable info with a join on sid with syslocks and syssessions from the sysmaster database.

On a larger point of view, you will monitoring a lot of things with the many options of onstat. check the doc

Why don't you install Open Admin Tool to have a graphical view of this and muuuuuch more.

It is free and can be found there

Hope this helps
Eric

Thanks,

Actually I still needed it. I will try this today !

Thanks again

Yes, I will manage it with SQL joins ( and filters of course) to cook it. Especially X locks.

Well I will install it in my personal lab, @ work it is not my decision.

How can we set SQL queries output to Tabular text form. Currently it is coming like a list. Like other databases , eg oracle, db2 , mssql ??

Also if I can find invalid objects in the database ??

Database Objects Status (Invalid)

Thanks for your time
DBFinder

1) to have the flat thing:
unload to filename DELIMITER "thecharacter you want"
SELECT ...
FROM ...

2) what do you mean for invalid objects ?
Eric

1) could not understand this : sorry ! can you write an example ??

2) Actually invalid objects means as in db2 and oracle, if we drop the table, the view on top of this table is marked INVALID.
Same with triggers.

Regards

I figured this out. Lots thanks to you.

Is there a way to specify console instead of filename ??

Regards

Hi,

sorry for the late response, but yesterday was holiday here in France.
1) unload will require a file handle as argument, so you can "unload to /dev/tty/pts2" for instance. Beware, you will have to filter out "database selected" "xxx rows unloaded" and other eventual error message.
2) you can also used instead
ouput to pipe " awk ' { some script } '" without headings
but if the result line is longer thant 80 character, the data will be presented as
1 row per column
3) take a look at the sqsl utility, available for free in the iiug software repository. In addition to find bunches of useful utilities, I think sqsl is what you want because it allows you to format the data.
you'll find what it is here and dowload it here


4) I need to figure out. At my knowlege there is no way to dected in a direct manner such invalid objects. But I may be wrong. If someone has ideas, welcome :-)

regards
Eric

Best
Eric

Thanks Eric,

Your effort appreciated. Not a rush, I will be helping informix dba complete his assignment given by his manager in next two weeks.
Invalid objects are usually searched for as a part of monitoring jobs. I am originally DB2 DBA.

Regards