Re: onmode -F

I am running Online 7.20 on HPUX 10.20. It is the database server for our SAP R/3 application. It gets hit pretty hard. I run onmode -F every half hour using this simple script. From time to time I uncomment the onstat -g to monitor the results. This script will miss if the database happens to be in another state (ie. checkpoint required) but running every half hour, missing one run has never hurt me. Scott Patterson Sr DBA/DA pattersons@norand.com #! /bin/csh # # ??/??/?? sbp creation # 03/31/97 sbp check if database is online #======================================================= # set online=`onstat - |grep -c "On-Line"` if ($online) then #onstat -g seg onmode -F #onstat -g segendif > Hi, > > in "Performance Guide Version 7.2" I found recommandation to run onmode > -F using cron facility. > Does anyone has experience with this, and how often should I execute > onmode -F using cron?> I am using Informix OnLine7.22 on AIX4.2. > > Thanks in advance, > Zeljan > > +--------------------------------------------------------+ > | CC Computer Consulting d.o.o. | > +--------------------------+-----------------------------+ > | Zeljan Silje | e-mail: zeljan@laus.hr | > | CC Computer Consulting | Tel: +385 (20) 411-136 | > | Janjevska 15 | +385 (1) 6552-330 | > | 20 000 Dubrovnik | Fax: +385 (20) 411-136 | > | Hrvatska (Croatia) | URL: http://www.laus.hr | > +--------------------------+-----------------------------+ >