IDS Forum

Re: Error in TLR with Archecker

Posted By: Art Kagel
Date: Thursday, 15 January 2009, at 11:17 a.m.

In Response To: Re: Error in TLR with Archecker (VIKAS HIVARKAR)

It LOOKS like the archive is damaged. Archecker is reading what it thinks
are chunk numbers and is seeing garbage in the tape/file. Assuming the file
is OK, I though maybe if the block size is off then every page after the
first input block would be offset somewhat. But you are correct, archecker
is reading with a block size of 32K, that was clear in the original output
you posted, so that's not it.

AC_IXBAR is the archive pointer if you used onbar to make the archive. If
you used ontape then ones uses AC_TAPEDEV instead as you have. Something's
not right. Try an earlier or even more recent archive, just for fun, with
the same config file. If that works then the problem is archive
corruption. If not, then open a case with IBM.

Oo, one question, did you make the archive to STDIO or to a pipe and
compress the archive? If so, 11.10 had a problem with it's archecker not
being able to restore from such an archive!!!!! Again open a case with IBM.

Art

On Thu, Jan 15, 2009 at 11:03 AM, VIKAS HIVARKAR
<vikas.hivarkar@gmail.com>wrote:

> Hello Art,
>
> onstat -c |grep BLK on my test server
> TAPEBLK 32 # Tape block size (Kbytes)
> LTAPEBLK 32 # Log tape block size (Kbytes)
>
> Always been the same value.
>
> I've not set the values for AC_TAPEBLOCK & AC_LTAPEDEV so that it takes the
> the default values for their corresponding ONCONFIG configuration
> parameters.
> I've also tried setting them 32.
>
> The ac_config.lt2 file has following
>
> AC_MSGPATH /tmp/ac_msg.log # archecker message log
> AC_STORAGE /tmp # Directory used for temp storage
> AC_VERBOSE 1 # 1 verbose messages 0 terse messages
> AC_RESTORE_FILTER /bin/gunzip
> AC_IXBAR /dev/testdb_2_L0
>
> I'm really confused between the parameter AC_IXBAR and AC_TAPEDEV.
> Against which of these do i set the path for level 0 archive file which is
> to
> be used for restoration.
>
> One of ppts at http://presentations.oninit.com/public/2006IDUGEMEA/H14.ppt
> says that AC_IXBAR is location for ixbar file, defines what backup to use.
> so i tried with this option as well.
>
> Not sure what am i doing wrong but still getting the errors in the
> ac_msg.log
> file
>
> TIME: [2009-01-15 16:42:21] All old validation files removed.
> STATUS: Dropping old log control tables
> STATUS: CLIENT_LOCALE not set, assuming [en_us.819]
> STATUS: Temporary workspace has been set
> STATUS: Target table [vikas] already created
> STATUS: SQL [SET INDEXES, TRIGGERS, CONSTRAINTS FOR vikas DISABLED]
> STATUS: Extracting table test:emp into test:vikas
> STATUS: Archive file /dev/testdb_2_L0
> STATUS: Tape type: Archive Backup Tape
> STATUS: OnLine version: IBM Informix Dynamic Server Version 11.10.FC3
> STATUS: Archive date: Sun Jan 11 22:00:01 2009
> STATUS: Archive level: 0
> STATUS: Tape blocksize: 32768
> STATUS: Tape size: 2147483647
> STATUS: Tape number in series: 1
> TIME: [2009-01-15 16:42:21] Phys Tape 1 started
> ERROR: Invalid chunk number 4795
> ERROR: Invalid chunk number 14656
> ERROR: Invalid chunk number 7912
> ERROR: Invalid chunk number 619
> ERROR: Invalid chunk number 7599
>
> on the console where i ran the archecker command the last line shows
> .............Bus Error
>
> Thanks,
> Vikas
> -----------------------------------------------------------------------
> Does the block size match the one that was used to create the archive?
>
> Art
>
> On Thu, Jan 15, 2009 at 6:56 AM, VIKAS HIVARKAR
> <vikas.hivarkar@gmail.com>wrote:
>
> > Thanks for the help Andreas,
> >
> > I've changed the INFORMIXSERVER to lt2 in order to use the tcp connection
> > and
> > the restore started BUT failed with errors
> >
> > STATUS: CLIENT_LOCALE not set, assuming [en_us.819]
> > STATUS: Temporary workspace has been set
> > STATUS: Extracting table test:emp into test:vikas
> > WARNING: Source table [emp] has no storage option
> > WARNING: No storage space to scan
> > STATUS: Tape type: Archive Backup Tape
> > STATUS: OnLine version: IBM Informix Dynamic Server Version 11.10.FC3
> > STATUS: Archive date: Sun Jan 11 22:00:01 2009
> > STATUS: Archive level: 0
> > STATUS: Tape blocksize: 32768
> > STATUS: Tape size: 2147483647
> > STATUS: Tape number in series: 1
> > TIME: [2009-01-15 12:35:54] Phys Tape 1 started
> > ERROR: Invalid chunk number 4795
> > ERROR: Invalid chunk number 14656
> > ERROR: Invalid chunk number 7912
> > .....
> >
> > I've even tried adding "set workspace to datadbs2" at the end of
> > ac_schema.sql
> > file.
> >
> > I'm sure that the emp table was created in datadbs2 as the test database
> is
> > on
> > datadbs2 dbspace and i created the emp table with "create table emp ---
> sql
> > statement with out any in dbspace option.
> >
> > what am i missing here?
> >
> > Vikas.
> >
> > --------------------------
> > Did you use tcp connection to the server?
> >
> > Andreas
> >
> > On Thursday 15 January 2009 11:40:47 VIKAS HIVARKAR wrote:
> > > Hi,
> > >
> > > IDS 11.10.FC3 on solaris 10
> > >
> > > I'm testing a table level restore using archecker and getting the
> > following
> > > error.
> > >
> > > STATUS: IBM Informix Dynamic Server Version 11.10.FC3
> > > Program Name: archecker
> > > Version: 8.0
> > > Released: 2008-12-09 01:42:51
> > > CSDK: IBM Informix CSDK Version 3.00
> > > ESQL: IBM Informix-ESQL Version 3.00.FC3
> > > Compiled: 12/09/08 01:43 on SunOS 5.9 Generic_122300-31
> > >
> > > STATUS: Arguments [-t -s -f /export/home/informix/vikas/ac_schema.sql
> > > -lphys] STATUS: AC_STORAGE /tmp
> > > STATUS: AC_MSGPATH /tmp/ac_msg.log
> > > STATUS: AC_VERBOSE on
> > > STATUS: AC_TAPEDEV /dev/testdb_2_L0
> > > STATUS: AC_TAPEBLOCK 32 KB
> > > STATUS: AC_LTAPEDEV /dev/null
> > > STATUS: AC_LTAPEBLOCK 32 KB
> > > STATUS: AC_RESTORE_FILTER /bin/gunzip
> > > STATUS: AC_SCHEMA /export/home/informix/vikas/ac_schema.sql
> > > STATUS: CLIENT_LOCALE not set, assuming [en_us.819]
> > > ERROR: "CONNECT" failed
> > > ERROR: -27000: (rgetlmsg() returned -1227)
> > > ERROR: Unable to make a connection for test.vikas
> > > CRITICAL ERROR: Connection to the database 'test@lt2_shm' has failed
> > > (SQLCODE: -27000).
> > > STATUS: Restore disabled for test:emp into test:vikas
> > > CRITICAL ERROR: Unable to continue -- no tables to restore.
> > > STATUS: archecker completed Physical Restore pid = 18354 exit code: 3
> > >
> > > testdb_2_L0 is yesterdays level 0 file created by ontape, which has the
> > emp
> > > tble.
> > > I have droped the emp table just now before starting the archecker
> test.
> > >
> > > I'm able to connect to test database using dbaccess and also from other
> > > servers.
> > >
> > > The ac_schema.sql looks like:
> > > database test;
> > >
> > > create table emp
> > > (
> > > c1 integer,
> > > c2 char(10)
> > > );
> > >
> > > create table vikas
> > > (
> > > c1 integer,
> > > c2 char(10)
> > > );
> > >
> > > insert into vikas
> > > select * from emp;
> > >
> > > trying to get some clue from finderr for 27000 but
> > > I'm missing some thing simple, Pls if any one could guide.
> > >
> > > Regards
> > > Vikas.
> >
> >
> >
> >
>
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (art@iiug.org)
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.

Messages In This Thread

• Error in TLR with Archecker
  VIKAS HIVARKAR -- Thursday, 15 January 2009, at 5:40 a.m.
  • Re: Error in TLR with Archecker
    Andreas Breitfeld -- Thursday, 15 January 2009, at 5:53 a.m.
    • Re: Error in TLR with Archecker
      VIKAS HIVARKAR -- Thursday, 15 January 2009, at 6:56 a.m.
      • Re: Error in TLR with Archecker
        VIKAS HIVARKAR -- Thursday, 15 January 2009, at 9:19 a.m.
      • Re: Error in TLR with Archecker
        Art Kagel -- Thursday, 15 January 2009, at 10:36 a.m.
        • Re: Error in TLR with Archecker
          VIKAS HIVARKAR -- Thursday, 15 January 2009, at 11:03 a.m.
          • Re: Error in TLR with Archecker
            Art Kagel -- Thursday, 15 January 2009, at 11:17 a.m.
            • Re: Error in TLR with Archecker
              VIKAS HIVARKAR -- Thursday, 15 January 2009, at 11:35 a.m.
            • Re: Error in TLR with Archecker
              John Miller iii -- Thursday, 15 January 2009, at 11:47 a.m.
              • Re: Error in TLR with Archecker
                VIKAS HIVARKAR -- Thursday, 15 January 2009, at 12:00 p.m.
  • Re: Error in TLR with Archecker
    Art Kagel -- Thursday, 15 January 2009, at 10:35 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.