Logical Log Files are Full
A site on IDS 11.50.FC8GE/HP-UX 11.11 had the server blocked (CKPT REQ) because logical logs were full and their ONBar backup system was down. Advice: free the logs immediately with 'ontape -a -t /path/to/dir' (and optionally add a logical log or two via onparams), then switch to ontape disk backups by setting TAPEDEV/LTAPEDEV to a directory/file, with 'ontape -s -L 0' for the level-0; log backups can be driven by ALARMPROGRAM. When ontape then hit a 2GB file-size limit (errno 27), the suggested fix was to set TAPESIZE/LTAPESIZE below 2GB so output is split across multiple files. The poster confirmed logs were backing up.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi all,
We are in the situation. Please take a look to see if you can help. We are
running IDS version 11.50.FC8GE in HPUX 11.11.
Weve been having issue with backup system and now our logical log files are
full now. The backup system is still down and we want to redirect our backup
to disk. However, we cant get the logical log to backup, so we can shut down
the engine to reconfigure the backup to disk.
Here is the engine status:
IBM Informix Dynamic Server Version 11.50.FC8GE -- On-Line (CKPT REQ) -- Up 28
days 17:01:26 -- 10240564 KbytesBlocked:CKPT
c0000000549b3a50 523 U------ 472040 125:960003 20000 20000 100.00
c0000000549b3ab8 524 U------ 472041 204:420003 20000 20000 100.00
c0000000549b3b20 525 U---C-L 472042 213:420003 20000 20000 100.00
c0000000549b3b88 526 U------ 471044 125:980003 20000 20000 100.00
c0000000549b3bf0 527 U------ 471045 204:440003 20000 20000 100.00
From console.log:
2014-11-14 09:30:57 Servername:baan_socl
<<IBM Informix Dynamic Server>>> Logical Log Files are Full -- Backup is Needed
2014-11-14 09:31:02 Servername:baan_socl
<<IBM Informix Dynamic Server>>> Logical Log Files are Full -- Backup is Needed
2014-11-14 09:31:07 Servername:baan_socl
<<IBM Informix Dynamic Server>>> Logical Log Files are Full -- Backup is Needed
If you use onspace to add more chunks for logical logs would that help?
ontape -a -t /path/to/dir_to/hold/logs
You may or may not be able to add logs. You don't have to add more
chunks. For now just use onparams to add a logical log or two from the
rootdbs or some other dbspace. You can always drop it later when it is no
longer needed.
FWIW, my rule of thumb is to have enough logical logs so that you can last
at least four days without backing logs up, just in case something like
this happens over a holiday weekend.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Fri, Nov 14, 2014 at 10:07 AM, TRI TRINH <tri_trinh@hotmail.com> wrote:
> Hi all,
>
> We are in the situation. Please take a look to see if you can help. We are
> running IDS version 11.50.FC8GE in HPUX 11.11.
>
> Weve been having issue with backup system and now our logical log files
> are
> full now. The backup system is still down and we want to redirect our
> backup
> to disk. However, we cant get the logical log to backup, so we can shut
> down
> the engine to reconfigure the backup to disk.
>
> Here is the engine status:
> IBM Informix Dynamic Server Version 11.50.FC8GE -- On-Line (CKPT REQ) --> Up 28
> days 17:01:26 -- 10240564 Kbytes
> Blocked:CKPT
>
> c0000000549b3a50 523 U------ 472040 125:960003 20000 20000 100.00
> c0000000549b3ab8 524 U------ 472041 204:420003 20000 20000 100.00
> c0000000549b3b20 525 U---C-L 472042 213:420003 20000 20000 100.00
> c0000000549b3b88 526 U------ 471044 125:980003 20000 20000 100.00
> c0000000549b3bf0 527 U------ 471045 204:440003 20000 20000 100.00
>
> >From console.log:
>
> 2014-11-14 09:30:57 Servername:baan_socl
>
> <<IBM Informix Dynamic Server>>> Logical Log Files are Full -- Backup is
> Needed
>
> 2014-11-14 09:31:02 Servername:baan_socl
>
> <<IBM Informix Dynamic Server>>> Logical Log Files are Full -- Backup is
> Needed
>
> 2014-11-14 09:31:07 Servername:baan_socl
>
> <<IBM Informix Dynamic Server>>> Logical Log Files are Full -- Backup is
> Needed
>
> If you use onspace to add more chunks for logical logs would that help?
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a11347e0a567ef90507d37390
Thank you. We have them backing up to a temp location.
Hi Art,
Thank you very much for your advice. Normally we use onbar to backup the whole
database to disk storage, but the back system is down right now.
We would like to use ontape to backup the whole database to local disk. To do
so we are going to update the parameter "TAPEDEV /dev/null" to "TAPEDEV
/dump/informix/". Since we never have experience with ontape, please provide
some advises. Thank you very much.
Hi,
backup to local disk using ontape is pretty easy.
Just set up the correct path incl. filename in onconfig as TAPEDEV.
Then, with a shell script, prepare the output file using
touch /path_to_file/filename
chown informix:informix /path_to_file/filename
chmod 660 /path_to_file/filename
Then, just start ontape -s -L 0 (maybe with a cron job, which will capture the
output in a file and send it to admin with a local mail client)
Log Backup is also possible using ontape
- define LTAPEDEV as a directory
- register an alarmprogram which executes ontape -a when a log is full
Also possible: make a backup to a remote server
- check rsh support on the remote server (rsh server "ls -ls" should be
executable without password and return without error)
(use hosts.equiv file to accept the rsh commands on remote system)
- set TAPEDEV to servername:/path_to_file/filename
Trigger backup from DB server using ontape -s -L 0
Also, you can put (depending on your version) a beckup/restore filter like
gzip/gunzip,
which is executed as a pipe during backup/restore.
For this feature, you have to set two commands, one to compress, one to
decompress.
There is no possibility to set command line options (so gzip and gzip -d does
not work, use gzip and gunzip or any equivalent compression program
which is able to compress stdin to stdout).
Hope this helps, good luck !
Marcus Haarmann
----- Ursprüngliche Mail -----
Von: "TRI TRINH" <tri_trinh@hotmail.com>
An: ids@iiug.org
Gesendet: Freitag, 14. November 2014 17:37:52
Betreff: Re: Logical Log Files are Full [34171]
Hi Art,
Thank you very much for your advice. Normally we use onbar to backup the whole
database to disk storage, but the back system is down right now.
We would like to use ontape to backup the whole database to local disk. To do
so we are going to update the parameter "TAPEDEV /dev/null" to "TAPEDEV
/dump/informix/". Since we never have experience with ontape, please provide
some advises. Thank you very much.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Thank you very much you two. tri
That will work. No sweat.
Art
On Nov 14, 2014 11:38 AM, "TRI TRINH" <tri_trinh@hotmail.com> wrote:
> Hi Art,
> Thank you very much for your advice. Normally we use onbar to backup the
> whole
> database to disk storage, but the back system is down right now.
>
> We would like to use ontape to backup the whole database to local disk. To
> do
> so we are going to update the parameter "TAPEDEV /dev/null" to "TAPEDEV
> /dump/informix/". Since we never have experience with ontape, please
> provide
> some advises. Thank you very much.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a11c3c832db4a5f0507d4d8d5
Hi again,
The ontape command hit the 2GB file size issue in HP-UX 11.11 and IDS
11.50.FC8GE. I google the 2GB issue, and there is a lot of comments for IDS
version 7. If you know good solution for our version, please advise. Thank you.
/apps/informix/etc $ontape -s -L 0
Archive failed - function write to tape failed code -1 errno 27
Program over.
76256 ERROR -1, ERRNO 27 FROM ONTAPE, WHEN WRITING > 2GB.
Use a smaller tapesize and then when it calls for a new tape move the old
file out of way and keep going, you will end up with XX 2GB files
There are plenty of scripts out there to do this for you
Cheers
Paul
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of TRI
> TRINH
> Sent: Monday, November 17, 2014 8:47 AM
> To: ids@iiug.org
> Subject: Re: Logical Log Files are Full [34180]
>
> Hi again,
>
> The ontape command hit the 2GB file size issue in HP-UX 11.11 and IDS
> 11.50.FC8GE. I google the 2GB issue, and there is a lot of comments for
IDS
> version 7. If you know good solution for our version, please advise. Thank
> you.
>
> /apps/informix/etc $ontape -s -L 0
> Archive failed - function write to tape failed code -1 errno 27
>
> Program over.
>
> 76256 ERROR -1, ERRNO 27 FROM ONTAPE, WHEN WRITING > 2GB.
>
>
> **********************************************************
> *********************
> Forum Note: Use "Reply" to post a response in the discussion forum.
If you iset LTAPEDEV to a directory name and set LTAPESIZE to something
less than 2GB all will be well.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Mon, Nov 17, 2014 at 9:52 AM, Paul Watson <paul@oninit.com> wrote:
> Use a smaller tapesize and then when it calls for a new tape move the old
> file out of way and keep going, you will end up with XX 2GB files
>
> There are plenty of scripts out there to do this for you
>
> Cheers
> Paul
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> TRI
> > TRINH
> > Sent: Monday, November 17, 2014 8:47 AM
> > To: ids@iiug.org
> > Subject: Re: Logical Log Files are Full [34180]
> >
> > Hi again,
> >
> > The ontape command hit the 2GB file size issue in HP-UX 11.11 and IDS
> > 11.50.FC8GE. I google the 2GB issue, and there is a lot of comments for
> IDS
> > version 7. If you know good solution for our version, please advise.
> Thank
> > you.
> >
> > /apps/informix/etc $ontape -s -L 0
> > Archive failed - function write to tape failed code -1 errno 27
> >
> > Program over.
> >
> > 76256 ERROR -1, ERRNO 27 FROM ONTAPE, WHEN WRITING > 2GB.
> >
> >
> > **********************************************************
> > *********************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e0158b61c2ca5d705080f31ab