Informix Ontape restorals fails from disk

Posted in 2004

Topics: Backup & Restore, Server Administration, Platform-Specific Issues

R Romero — 10 Feb 2004 10:06:10 -0800 — source: Usenet: comp.databases.informix

Gurus, Got a problem that I do not know how to address. I'm not an Informix dba, I'm just SysAdmin who's job is to make hotbackups work. Platform Solaris8 Informix Version 9.21.UC3 TAPEDEV /DBbackups/HotBackups/somefile <--backup to disk BLOCKSIZE 512K TAPESIZE 2048000 LTAPEDEV /dev/nullBLOCKSIZE 64 LTAPESIZE 1024000000 I've managed to "successfully" complete an archive using ontape -s -L0 with supposed good results. The "somefile" is a symlink to file.1/file.2/file.3 during backups. This portion of the backups seem to work. It is when I run the ontape -r that things seem to fail. The restorals will take file.1 and file.2 with no issue, but when I move the symlink to file.3, Informix complains that I it thinks I am attempting to use file.1 and keeps prompting me for tape #3. File.1 and File.2 are 2g in size and file.3 is about 1g in size. Are my parameters for TAPESIZE correct? What could I be missing that is causing my restorals to fail? Upgrading to Informix 9.4 is not a realistic solution. Thanks in advance for any ideas that may help. Randy Romero

Glossary

ontape