topic Re: Ontape error. Archive failing. Please help! in Operating System - HP-UX

Ontape error. Archive failing. Please help!

Luke Morgan — Thu, 09 Aug 2001 08:03:08 GMT

Hi,
This is an Informix question really, but I'm
hoping someone can help me. I am backing up
a database using ontape -s, and it has failed
with the message
ISAM error, out of disk space.

Does ontape write to disk before it writes to
tape? The database is 40Gb and its being backed
up to DLT8000 tape drive with compression switched on.

Any help or advice would be greatly appreciated.

Thanks

Luke

Re: Ontape error. Archive failing. Please help!

Rainer von Bongartz — Thu, 09 Aug 2001 08:17:26 GMT

we need a bit more infos

1.) your $ONCONFIG

2.) your online log (relevant parts)

regards
Rainer

Re: Ontape error. Archive failing. Please help!

Frédéric Devos — Thu, 09 Aug 2001 08:26:53 GMT

Hi,

Are you really writing to the DLT :

grep TAPEDEV /opt/informix/etc/onconfig

If so, take a look to the log file to determine what's wrong with the backup

Re: Ontape error. Archive failing. Please help!

Luke Morgan — Thu, 09 Aug 2001 08:35:55 GMT

This is the appropriate portion of the log file.
16:56:59 Checkpoint Completed: duration was 32 seconds.
16:57:00 Level 0 Archive started on rootdbs, plogdbs, llogdbs, temp1dbs, temp2dbs, temp3dbs, temp4dbs, data1dbs, edi_dbs
17:07:59 Checkpoint Completed: duration was 39 seconds.
17:18:34 Checkpoint Completed: duration was 29 seconds.
17:21:26 Logical Log 7773 Complete.
17:21:27 Logical Log 7773 - Backup Started
17:21:27 Process exited with return code 127: /bin/sh /bin/sh -c /usr/informix/log_full.sh 2 23 "Logical Log 7773 Complete." "Logical Log 7773 Complete."
17:22:50 Logical Log 7773 - Backup Completed
17:22:50 Process exited with return code 127: /bin/sh /bin/sh -c /usr/informix/log_full.sh 2 18 "Log Backup completed: 7773." "Logical Log 7773 - Backup Completed"
17:28:57 Checkpoint Completed: duration was 15 seconds.
17:39:23 Checkpoint Completed: duration was 16 seconds.
17:49:41 Checkpoint Completed: duration was 11 seconds.
17:59:21 Archive on rootdbs, plogdbs, llogdbs, temp1dbs, temp2dbs, temp3dbs, temp4dbs, data1dbs, edi_dbs ABORTED.
17:59:21 ISAM error: no free disk space

17:59:22 Process exited with return code 127: /bin/sh /bin/sh -c /usr/informix/log_full.sh 3 6 "Internal Subsystem failure: 'Archive'" "Archive on rootdbs, plogdbs, ll
17:59:59 Checkpoint Completed: duration was 11 seconds.
18:08:43 Logical Log 7774 Complete.
18:08:44 Process exited with return code 127: /bin/sh /bin/sh -c /usr/informix/log_full.sh 2 23 "Logical Log 7774 Complete." "Logical Log 7774 Complete."

Attached is $ONCONFIG

Re: Ontape error. Archive failing. Please help!

Rainer von Bongartz — Thu, 09 Aug 2001 09:06:20 GMT

Luke,

INFX sure uses temporary dbspaces and your rootdbs while performing archives.

First check with onstat -d and then think if you really need to backup your temporary db spaces

regards
Rainer

Re: Ontape error. Archive failing. Please help!

Frédéric Devos — Fri, 10 Aug 2001 07:58:02 GMT

Hi

In your onconfig file, i see you have another backup device. Try to backup on the other device. Maybe the problem is coming from the device.

Regards

Re: Ontape error. Archive failing. Please help!

Frédéric Devos — Fri, 10 Aug 2001 08:02:54 GMT

Meaning of the error code 127 :
-127 ISAM error: no primary key.

The ISAM processor was called for a function that requires a unique
primary-key index, but no such index exists for this file. For C-ISAM
programs, review the design of the data file; it was created with a
zero-part primary index (that is, for retrieval by record-number
sequence). If that is not the case, the index might be damaged; run the
bcheck or secheck utility. If the error recurs, please note all
circumstances and contact Informix Technical Support.

Regards