I believe there is a dbamon.sh utility in the IIUG download section that may
do what you want. It may require a bit of fine-tuning to do what you want, but
it does do some interesting things with both Informix and Unix commands. If
you can't find it, let me know and I will post it.
Neil Truby wrote:
> andy lennard wrote:
> >
> > Hi,
> > I have responsibility for a system that has no full-time DBA and I'd
> > like to put together a 'cron-ish' script to check whether the database
> > is happy.
> >
> > I was wondering if anyone can help me find out whether an 'ontape -c'
> > is actually doing anything? The system is Sun Solaris 2.6, with 7.23UC4.
> You can see if it's clocking up CPU via ps. If it's writing to tape you
> can do an mt -f /dev/rmt/0 status and see if it's busy. You can run
> onstat -u, identify the ontape from its flags, and have a look to see if> it's clocking up any activity.
>
> Neil Truby
> Chase Manhattan Bank
> Bournemouth, UK