RE: IDS admin tasks

If you are capturing the rows on a regular basis then it straightforward to generate the number of days left before a dbspace fills, another big extent will be allocated etc. FWIW if you move your logs to online.yymmdd then at least a std ls will give you them in the right order, OK online.yyyymmdd for allow for the rollover. 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: jeffm@lysander.co.uk [mailto:jeffm@lysander.co.uk] > Sent: 30 March 1999 15:11 > To: informix-list@iiug.org > Subject: RE: IDS admin tasks > > > 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 >