RE: IDS admin tasks

I quite like backups:-) and update stats occasionally and the odd oncheck is nice once in a while Paul Watson # WF Software Ltd # Any answer given Tel: +44 1463 674729 # could be totally Fax: +44 1463 678729 # fictitious www.wfsoftware.com # > -----Original Message----- > From: Surfer! [mailto:surfer@nevis-view.demon.co.uk] > Sent: 29 March 1999 12:36 > To: informix-list@iiug.org > Subject: IDS admin tasks > > > > I'm looking to build a list of daily/weekly/monthly tasks in > managing an > IDS system (one instance, 8GB data). > > Obvious regular ones include: > Reviewing free space in dbspaces > Ensuring enough log files > Checking for errors in message file > > Others include > Investigating performance problems > Liaising with Informix support > Assisting in migration to Solaris 2.6 (from 2.5.1) > Assisting in installing later versions of the engine > (currently > 7.30 and 7.31 is on the way I believe) > > All constructive contributions welcome! > > TIA > > > > Surfer! > URL: http://www.nevis-vieww.demon.co.uk > Email: surfer@nevis-vieww.demon.co.uk > Hopeful anti-spam: alter double 'w' to single 'w' to view > site & send Email. >

In article <7do5gd$l8r$1@news.xmission.com>, Watson, Paul <Paul.Watson@bskyb.com> writes > >I quite like backups:-) Forgot that as someone else is going it! >and update stats occasionally >and the odd oncheck is nice once in a while Even nicer when Informix 7.31 arrives and it finds any broken indexes properly - but thanks for the reminders! <snip> Surfer! URL: http://www.nevis-vieww.demon.co.uk Email: surfer@nevis-vieww.demon.co.uk Hopeful anti-spam: alter double 'w' to single 'w' to view site & send Email.

Capture number of rows of at least your main tables as a periodical snapshot. This way when asked to perform a future 'sizing' exercise you can be more accurate than 'well, if they all grow by 30%...'. Also, clear down your online log nightly by MOVING it to an archive location nightly named to include the date (eg : onlinelog.3103) and keep these for 60 days or so - makes things easier to find. Just some suggestions, but I've found these two useful. In article <7do5gd$l8r$1@news.xmission.com>, "Watson, Paul" <Paul.Watson@bskyb.com> wrote: > > I quite like backups:-) > and update stats occasionally > and the odd oncheck is nice once in a while > > Paul Watson # > WF Software Ltd # Any answer given > Tel: +44 1463 674729 # could be totally > Fax: +44 1463 678729 # fictitious > www.wfsoftware.com # > > > -----Original Message----- > > From: Surfer! [mailto:surfer@nevis-view.demon.co.uk] > > Sent: 29 March 1999 12:36 > > To: informix-list@iiug.org > > Subject: IDS admin tasks > > > > > > > > I'm looking to build a list of daily/weekly/monthly tasks in > > managing an > > IDS system (one instance, 8GB data). > > > > Obvious regular ones include: > > Reviewing free space in dbspaces > > Ensuring enough log files > > Checking for errors in message file > > > > Others include > > Investigating performance problems > > Liaising with Informix support > > Assisting in migration to Solaris 2.6 (from 2.5.1) > > Assisting in installing later versions of the engine > > (currently > > 7.30 and 7.31 is on the way I believe) > > > > All constructive contributions welcome! > > > > TIA > > > > > > > > Surfer! > > URL: http://www.nevis-vieww.demon.co.uk > > Email: surfer@nevis-vieww.demon.co.uk > > Hopeful anti-spam: alter double 'w' to single 'w' to view > > site & send Email. > > > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own