Oninit cdi / Archive
Talk to an expert →

archecker

Posted in 2010

Topics: Error Codes & Troubleshooting, Connectivity: ESQL/C, 4GL & Embedded SQL, Networking & sqlhosts Configuration, Platform-Specific Issues, Versions, Editions & End-of-Life

hugo — — source: Usenet: comp.databases.informix

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

↪ replying to hugo
jrenaut — — source: Usenet: comp.databases.informix

On Mar 23, 1:01 pm, "hugo" <grij...@cespt.gob.mx> wrote: > 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 Assuming the error code is correct (-27000) I would suggest maybe trying to switch your INFORMIXSERVER from pentshm to pentium (so switch from shared memory connection to your tli connection). However, I believe the table level restore would require the instance to be online as I thought it used SQL to insert the rows into the new destination table. I will admit I've not used/played around with the table restore portion of archecker though. But switching INFORMIXSERVER seems like an easy enough thing to test. IBM Informix Advanced Support APD Team

↪ replying to hugo
david@smooth1.co.uk — — source: Usenet: comp.databases.informix

On 23 Mar, 18:01, "hugo" <grij...@cespt.gob.mx> wrote: > 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 Did you export DBSERVERNAME in your environment or get it from the onconfig file? DBSERVERNAME should not be set in your environment. Does dbaccess cis@pentshm work from the UNIX prompt where you try the restore?

Related threads

Glossary