RE: archecker [215]
Answered: green (hollow confidence) — The single archived message is the asker's own follow-up reporting archecker now runs correctly, but the actual fix (likely a sqlhosts/INFORMIXSERVER protocol mismatch) is not shown in the archived reply chain.
Advisory only.
Posted in 2010
Thanks to all,
The archecker command now runs correctly.
Environment in which they run:
Sqlhosts
pentium ontlitcp pentium sqlexec
#pentshm onipcshm pentium pentshm
Environment Variables
DBSERVERNAME=Pentium
INFORMIXSERVER=pentium
#INFORMIXSERVER=pentshm old
The instance was star On-Line again.
Hugo Grijalva
CESPT Tijuana
_____
From: hugo [mailto:grijalv@cespt.gob.mx]
Sent: Tuesday, March 23, 2010 11:01 AM
To: informix-list@iiug.org
Subject: archecker
I'm restore table with archecker.
archecker -tvsdX -f resmwh.sql
The command ouput its:
IBM Informix Dynamic Server Version 11.50.FC3
Program Name: archecker
Version: 8.0
Released: 2008-10-28 00:19:58
CSDK: IBM Informix CSDK Version 3.50
ESQL: IBM Informix-ESQL Version 3.50.FN193
Compiled: 10/28/08 00:20 on SunOS 5.9 Generic_122300-31
AC_STORAGE /tmp
AC_MSGPATH /tmp/ac_msg.log
AC_VERBOSE on
AC_TAPEDEV /dev/rmt/0
AC_TAPEBLOCK 256 KB
AC_LTAPEDEV /dev/rmt/0
AC_LTAPEBLOCK 256 KB
Dropping old log control tables
Restore only physical image of archive
CRITICAL ERROR: Connection to the database 'cis@pentshm' has failed
(SQLCODE: -2
7000).
Restore disabled for cis:resmwh into cis:resmwh_target_ok
CRITICAL ERROR: Unable to continue -- no tables to restore.
My environment is:
Server: Sparc Sun V890
S.O : Solaris sparc 9 (5.9)
IDS: 11.50.FC3
Sqlhosts
pentium ontlitcp pentium sqlexec
pentshm onipcshm pentium pentshm
DBSERVERNAME=pentium
INFORMIXSERVER=pentshm
Not valid option to the off-line instance
Any idea?
Hugo Grijalva
CESPT Tijuana