From: Scott Adderson (EMP) (Scott.Adderson@eml.ericsson.se)
Date: Tue Feb 11 2003 - 08:06:14 EST
Thanks to all who responded, in particular to Brent Kwasnica and Peter van Eck.
Also: Martin Lodhal, Dimitri Avgoustakis, Aaron Bennet, Chris Wong, Vince Taylor, Ward Edwards, Dale Whittemore, Richard Goodwin, Bill Hassel, Joe Reeves, Glen Bauder, Brett Geer, Della Schmidt and Leslie O'Donnell.
The main problem was lack of knowledge of the system or it's history as the original admins and DBA's were laid off well before we got hold of the server, taking their skills with them.
The summary answer was a backup of the Informix logical logs was required. As we appear to have an Informix 5 system dating back to 1994, I needed to use 'tbtape -a' to archive the logs. 'tbtape -c' will then set continuous logging to 4mm DAT once it has been cleared. 'ontape' is the command for later systems.
By setting the LPTAPEDEV config in /usr/informix/etc/tbconfig to /dev/null the logs will be thrown away. As we have a static, view only legacy database, that's probably what I'll do.
As an additional complication, the system had forked too many processes as a result of the logs being full to su to informix user, so I had to pull the informix .profile information into the root user session to run the commands. This then cleared down the logs and allowed informix to free up the processes, bringing the system back online.
Some useful links sent through:
Informix mail list:
<http://www.iiug.org/resources/informix-list.html> http://www.iiug.org/resources/informix-list.html
Informix log management scripts:
http://www.prstech.com/downloads.shtml <http://www.prstech.com/downloads.shtml>
Thanks again for all the help.
Scott
-----Original Message-----
From: Scott Adderson (EMP) [mailto:Scott.Adderson@eml.ericsson.se]
Sent: 07 February 2003 15:52
To: 'hpux-admin@dutchworks.nl'
Subject: [HPADM] HP-UX 9.04/Informix legacy system - 'logical log files are full'
Hi Admins,
We've got an old, inherited, unsupported HP-UX 9.04 legacy data system running on an HP 800/H70 from a closed site running a Product Database Management application called 'MTMS'. It's only used for viewing legacy data as far as I'm aware. All the admins that used to run this system have long since been laid off, so any help gratefully received!
It appears to be running an Informix database and was reporting that the /usr file system was full. I've been onto the system and copied out and cleared down some large log files in that partition and it's back available again.
One of the log files I've cleared down was /usr/informix/online.log. This increases every five seconds with a line that reads 'Logical Log Files are Full - - Backup is Needed' and of course will fill up the /usr partition again before too long.
Can anyone assist with how to fix the message? I would guess I'm looking for some logs to copy off and clear down, but as the system is unsupported and we don't have any HP-UX 9 media I'm reluctant to do anything without some advice!
TIA, I will summarise,
Scott
---------------------------------------------
Scott Adderson
Senior Engineer, Unix & CAD Support
Ericsson Mobile Communications (UK)
scott.adderson@eml.ericsson.se
--
---> Please post QUESTIONS and SUMMARIES only!! <---
To subscribe/unsubscribe to this list, contact majordomo@dutchworks.nl
Name: hpux-admin@dutchworks.nl Owner: owner-hpux-admin@dutchworks.nl
Archives: ftp.dutchworks.nl:/pub/digests/hpux-admin (FTP, browse only)
http://www.dutchworks.nl/htbin/hpsysadmin (Web, browse & search)
This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 11:02:26 EDT