Ontape error. Archive failing. Please help!

[Luke Morgan]

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

[Rainer von Bongartz]

we need a bit more infos

1.) your $ONCONFIG

2.) your online log (relevant parts)

regards
Rainer

[Frédéric Devos]

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

[Luke Morgan]

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

[Rainer von Bongartz]

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

[Frédéric Devos]

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

[Frédéric Devos]

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