archecker issue
Posted in 2009
Platform HP L3000
OS HPUX 11.23
IDS 10.00.FC8
After performing the following command
$INFORMIXDIR/bin/ontape -v -t STDIO -s -L 0 > <filename>
to a local directory, the command is successful and the file created is 18+ GB.
I then use the following command to do a table level restore
cat -u <filename> | \\\\
$INFORMIXDIR/bin/archecker -t -X -f ./rest1 -l phys -v -s
And the command is successful in restoring the table contents to the new table
named in the schema command file.
I repeat the process to a windows 2000 server to a directory mounted with the
following command
/usr/bin/cifsmount //<domain.name>/images <mount_point> -U <userid> -P <passwd>
The mount is successful, the ontape command creates the archive file 18+ GB;
however the archecker process starts but stops.
contents of ac_msg.log
2009-10-15 15:39:52
-----------------------------------------
STATUS: IBM Informix Dynamic Server Version 10.00.FC8
Program Name: archecker
Version: 8.0
Released: 2008-01-25 23:08:02
CSDK: IBM Informix CSDK Version 2.90
ESQL: IBM Informix-ESQL Version 2.90.FN431
Compiled: 01/25/08 23:09 on HP-UX B.11.11 U
STATUS: Arguments [-t -X -f ./rest1 -l phys -v -s]
STATUS: AC_STORAGE /tmp
STATUS: AC_MSGPATH /tmp/ac_msg.log
STATUS: AC_VERBOSE on
STATUS: AC_TAPEDEV STDIO
STATUS: AC_TAPEBLOCK 64 KB
STATUS: AC_LTAPEDEV /dump_dir/llogs/logfile
STATUS: AC_LTAPEBLOCK 64 KB
STATUS: AC_SCHEMA ./rest1
STATUS: Extracting table vonroll:outbound_ship_id into vonroll:arc_outb_sid_2
WARNING: Source table [outbound_ship_id] has no storage option
ERROR: No storage space to scan
STATUS: Tape type: Archive Backup Tape
STATUS: OnLine version: IBM Informix Dynamic Server Version 10.00.FC8
STATUS: Archive date: Thu Oct 15 15:20:31 2009
STATUS: Archive level: 0
STATUS: Tape blocksize: 65536
STATUS: Tape size: 0
STATUS: Tape number in series: 1
TIME: [2009-10-15 15:39:53] Phys Tape 1 started
STATUS: starting to scan dbspace 1 created on 2009-10-15 15:20:31.
STATUS: Archive timestamp 0X2C31C7D5.
STATUS: starting to scan dbspace 3 created on 2009-10-15 15:20:31.
STATUS: Archive timestamp 0X2C31C7D5.
STATUS: Read/Write End Of Medium enabled: blocks = 25775
TIME: [2009-10-15 15:41:56] Tape 1 completed
STATUS: Scan PASSED
STATUS: Control page checks PASSED
STATUS: Table checks PASSED
STATUS: Table extraction commands 1
STATUS: Tables found on archive 0
STATUS: Tables not located on archive 1
STATUS: LOADED: vonroll:arc_outb_sid_2 produced 0 rows
TIME: [2009-10-15 15:41:56] Physical Extraction Completed
TIME: [2009-10-15 15:41:56] Unload Completed
STATUS: archecker completed Physical Restore pid = 28555 exit code: 3
The screen message tells me that archecker has reached the <eof>
When I do an ls -l of the file on the mounted filesystem, the OS reports the
size of the file as 1.6+ GB. I then did a mv <filename> <new_filename>; ls -l
and the size returns to 18+ GB
Any ideas?
Thanks