Re: Looking For An Accurate Online Access Test
From: "Brett Schubert" <BSchubert@bigpond.com> > >Thanks! >Okay now tell me how I can determine if the logical logs are full in a >script. Well, duh... >tbstat - >doesn't seem to be able to do this. Even though this is a case when you >can't access the database. You wanted to know a way of seeing if the database was up. tbstat - is the least you need. Maybe your boss was using tbstat -l because that's how you see if the logs are full? If you upgrade to IDS.7.3x or IDS.2000, you get access to the sysmaster database which allows you to query that sort of thing via SQL. There is a (very limited) equivalent for later versions of 5, I don't know if it allows monitoring of the logs. >Obnoxio The Clown <obnoxio@hotmail.com> wrote in message >news:8i7m2l$efh$1@news.xmission.com... > > > > From: "Brett Schubert" <BSchubert@bigpond.com> > > > > > >The boss currently uses a script with: > > > > > >"tbstat -l" > > > > > >to determine whether there the database is up (online) and allowing sql > > >access (insert, update, delete, select). This is on a cron job. > > > > > >I would like to ask if there is a better way of determining whether the > > >Online engine is allowing access to the database (online). > > > > tbstat - > > > > ? ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
You can tell whether the engine is online using 'tbstat -' 'tbstat -l' might give you additional information about whether you should try to do any work. There is NO test that you can perform that will tell you whether the system will be able to do ALL the work you want to do. In article <8icrvg$9tp$1@news.xmission.com>, Obnoxio The Clown <obnoxio@hotmail.com> writes > >From: "Brett Schubert" <BSchubert@bigpond.com> >> >>Thanks! >>Okay now tell me how I can determine if the logical logs are full in a >>script. > >Well, duh... > >>tbstat - >>doesn't seem to be able to do this. Even though this is a case when you >>can't access the database. > >You wanted to know a way of seeing if the database was up. tbstat - is the >least you need. Maybe your boss was using tbstat -l because that's how you >see if the logs are full? > >If you upgrade to IDS.7.3x or IDS.2000, you get access to the sysmaster >database which allows you to query that sort of thing via SQL. There is a >(very limited) equivalent for later versions of 5, I don't know if it allows >monitoring of the logs. > >>Obnoxio The Clown <obnoxio@hotmail.com> wrote in message >>news:8i7m2l$efh$1@news.xmission.com... >> > >> > From: "Brett Schubert" <BSchubert@bigpond.com> >> > > >> > >The boss currently uses a script with: >> > > >> > >"tbstat -l" >> > > >> > >to determine whether there the database is up (online) and allowing sql >> > >access (insert, update, delete, select). This is on a cron job. >> > > >> > >I would like to ask if there is a better way of determining whether the >> > >Online engine is allowing access to the database (online). >> > >> > tbstat - >> > >> > ? > > >________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > Andrew Lennard andy@kontron.demon.co.uk
Andy Lennard <andy@kontron.demon.co.uk> wrote in message news:joQ$WNAdYhS5Ewas@kontron.demon.co.uk... > You can tell whether the engine is online using 'tbstat -' > 'tbstat -l' might give you additional information about whether you > should try to do any work. > There is NO test that you can perform that will tell you whether the > system will be able to do ALL the work you want to do. > This is what I really wanted to know. I didn't want to waste time writing a relatively complex script, if there was a simple test available. Looks like I have too anyway. I will attempt this using a combination of the message logs (for logs full messages) and "tbstat -". Thanks for the info mate. Your reply was appreciated ;-) > > In article <8icrvg$9tp$1@news.xmission.com>, Obnoxio The Clown > <obnoxio@hotmail.com> writes > > > >From: "Brett Schubert" <BSchubert@bigpond.com> > >> > >>Thanks! > >>Okay now tell me how I can determine if the logical logs are full in a > >>script. > > > >Well, duh... > > > >>tbstat - > >>doesn't seem to be able to do this. Even though this is a case when you > >>can't access the database. > > > >You wanted to know a way of seeing if the database was up. tbstat - is the > >least you need. Maybe your boss was using tbstat -l because that's how you > >see if the logs are full? > > > >If you upgrade to IDS.7.3x or IDS.2000, you get access to the sysmaster > >database which allows you to query that sort of thing via SQL. There is a > >(very limited) equivalent for later versions of 5, I don't know if it allows > >monitoring of the logs. > > > >>Obnoxio The Clown <obnoxio@hotmail.com> wrote in message > >>news:8i7m2l$efh$1@news.xmission.com... > >> > > >> > From: "Brett Schubert" <BSchubert@bigpond.com> > >> > > > >> > >The boss currently uses a script with: > >> > > > >> > >"tbstat -l" > >> > > > >> > >to determine whether there the database is up (online) and allowing sql > >> > >access (insert, update, delete, select). This is on a cron job. > >> > > > >> > >I would like to ask if there is a better way of determining whether the > >> > >Online engine is allowing access to the database (online). > >> > > >> > tbstat - > >> > > >> > ? > > > > > >________________________________________________________________________ > >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > > > Andrew Lennard andy@kontron.demon.co.uk