IDS Forum

Re: Informix Database testing

Posted By: medkba
Date: Wednesday, 24 July 2013, at 10:12 p.m.

In Response To: RE: Informix Database testing (Andrew Ford)

Hi,

Is the any possibility to bring up instanace?

Thank you very much
On Thu, Jul 25, 2013 at 1:26 AM, Andrew Ford <andrew@informix-dba.com>wrote:

> No need for a tape drive. You can run an ontape backup to STDIO and send it
> over the network via ssh (or similar) as input to an ontape restore on your
> test box.
>
> production_server> ontape -s -L 0 -F -t STDIO | ssh informix@testing_server
> ". some_script_to_setup_env.sh; ontape -p -t STDIO"
>
> This is an online backup with no blocking of your production instance, the
> only impact will be the additional load of performing the backup and
> sending
> it over the network.
>
> This assumes that the exact version of the production instance it installed
> on the testing server, the ONCONFIG is populated correctly and the same
> chunk paths exist on the testing server as the production server (you may
> have to create links).
>
> You're going to have to figure out why the testing server thinks
> /db/ewso/root/root1 is returning errno = 2 when attempting to access it.
>
> Andrew
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> medkba
> Sent: Wednesday, July 24, 2013 11:42 AM
> To: ids@iiug.org
> Subject: Re: Informix Database testing [30926]
>
> [1]
> This machine no instance running it is brand new machine. But other server
> (machine) this instance is running (i.e. source server).
> I tried to find INFORMIXTMP file but couldn't find this file.
>
> [2]
> I have verified chunk is available ('/db/ewso/root/root1') but cannot open
> the Chunk file. I suspect may be corrupt file or some other issue
>
> We cannot shutdown databaase because operational database. Is it possible
> to
> use onmode -c block then copy all the os level copy to destination server.
> Is it correct method?
>
> Destination server don't have tape drive so that I cannot restore from tape
> (backup data).
>
> Please advise
>
> Thank you very much
>
> On Thu, Jul 25, 2013 at 12:29 AM, Art Kagel <art.kagel@gmail.com> wrote:
>
> > OK, these are the two important messages during the startup failure:
> >
> > This first one is warning you that there is a shared memory
> > communications file in /INFORMIXTMP which seems to indicated that
> > there is another running instance on this machine using the onipcshm
> > service name "informix_sv". If that is true then you need to modify
> > the sqlhosts file so that this copied instance uses a different
> > service name. If there is no such instance delete the named file. If
> > there are no other Informix instances at all on the machine, then just
> delete all files in /INFORMIXTMP.
> >
> > 23:17:07 Warning: shared-memory connection file
> > '/INFORMIXTMP/.inf.informix_sv' is overwritten. This file might
> >
> > belong to another instance of IDS server. If the service name of the
> > IDS
> >
> > database server is not unique in the environment of the host computer
> > where
> >
> > the database server resides, rename the service.
> >
> > This next one is telling you that the root dbspace chunk listed in
> > ROOTPATH does not exist which is the meaning of errno 2!
> >
> > 23:17:07 Warning: stat() failed for chunk file /db/ewso/root/root1
> >
> > 23:17:07 Cannot Open Primary Chunk '/db/ewso/root/root1', errno = 2
> >
> > Art
> >
> > Art S. Kagel
> > Advanced DataTools (www.advancedatatools.com)
> > Blog: http://informix-myview.blogspot.com/
> >
> > Disclaimer: Please keep in mind that my own opinions are my own
> > opinions and do not reflect on my employer, Advanced DataTools, the
> > IIUG, nor any other organization with which I am associated either
> > explicitly, implicitly, or by inference. Neither do those opinions
> > reflect those of other individuals affiliated with any entity with
> > which I am affiliated nor those of the entities themselves.
> >
> > On Wed, Jul 24, 2013 at 11:32 AM, medkba <medkba@gmail.com> wrote:
> >
> > > Thank you for the confirmation.
> > >
> > > Any way, I have to start informix database but I got the below
> > > errors. It means that we cannot bring up database
> > >
> > > informix@whx003n$ oninit -v
> > > Checking group membership to determine server run mode...succeeded
> > > Reading configuration file
> > > '/informixIDS/etc/onconPROD82'...succeeded
> > > Creating /INFORMIXTMP/.infxdirs...succeeded
> > > Checking config parameters...succeeded Allocating and attaching to
> > > shared memory...succeeded Creating resident pool 221846
> > > kbytes...succeeded Allocating 800016 kbytes for buffer pool of 2K
> > > page size...succeeded Creating infos file
> > > "/informixIDS/etc/.infos.prod08_amk82"...succeeded
> > > Linking conf file "/informixIDS/etc/.conf.prod08_amk82"...succeeded
> > > Initializing rhead structure...succeeded Writing to infos
> > > file...succeeded Initialization of Encryption...succeeded
> > > Initializing ASF...succeeded Initializing Dictionary Cache and SPL
> > > Routine Cache...succeeded Bringing up ADM VP...succeeded Creating VP
> > > classes...succeeded Onlining 5 additional cpu vps...succeeded
> > > Onlining 4 IO vps...succeeded Forking main_loop thread...succeeded
> > > Initializing DR structures...succeeded Forking 1 'ipcshm' listener
> > > threads...succeeded Forking 1 'soctcp' listener threads...succeeded
> > > Starting tracing...succeeded Initializing 127 flushers...succeeded
> > > oninit: Fatal error in shared memory initialization
> > > WARNING: server initialization failed, or possibly timed out (if -w
> > > was used).
> > > Check the message log, online.log, for errors.
> > >
> > > informix@whx003n$ onstat -m
> > >
> > > shared memory not initialized for INFORMIXSERVER 'prod08_ews82'
> > >
> > > Message Log File: /log/informix/IDS/online.log
> > >
> > > 23:17:00 Event alarms enabled. ALARMPROG =
> > > '/app/informix_server/IDS1150FC9/etc/no_log.sh'
> > >
> > > 23:17:00 Booting Language <c> from module <>
> > >
> > > 23:17:00 Loading Module <CNULL>
> > >
> > > 23:17:00 Booting Language <builtin> from module <>
> > >
> > > 23:17:00 Loading Module <BUILTINNULL>
> > >
> > > 23:17:06 DR: DRAUTO is 0 (Off)
> > >
> > > 23:17:06 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
> > >
> > > 23:17:06 Fast poll /dev/poll enabled.
> > >
> > > 23:17:07 Warning: shared-memory connection file
> > > '/INFORMIXTMP/.inf.informix_sv' is overwritten. This file might
> > >
> > > belong to another instance of IDS server. If the service name of the
> IDS
>
> > >
> > > database server is not unique in the environment of the host computer
> > where
> > >
> > > the database server resides, rename the service.
> > >
> > > 23:17:07 IBM Informix Dynamic Server Version 11.50.FC9 Software Serial
> > > Number AAA#B000000
> > >
> > > 23:17:07 Warning: stat() failed for chunk file /db/ewso/root/root1
> > >
> > > 23:17:07 Cannot Open Primary Chunk '/db/ewso/root/root1', errno = 2
> > >
> > > 23:17:07 oninit: Fatal error in shared memory initialization
> > >
> > > 23:17:07 IBM Informix Dynamic Server Stopped.
> > >
> > > 23:17:07 mt_shm_remove: WARNING: may not have removed all/correct
> > segments
> > >
> > > Thank you very much
> > >
> > > On Wed, Jul 24, 2013 at 11:20 PM, Art Kagel <art.kagel@gmail.com>
> wrote:
>
> > >
> > > > Yes, exactly. Not necessarily corruption, however, there will be data
> > in
> > > > memory that was never written to disk including index pages modified
> by
> > > > transactions. That will mean that even if the server starts up, your
> > data
> > > > may not be accessible because there will be data records not listed
> in
>
> > > the
> > > > on-disk copy of the index pages that were modified. Similarly,
> indexes
>
> > > may
> > > > point to data row locations that were deleted or even overwritten by
> > > > completely different rows after deletion. Referential integrity may
> > have
> > > > been broken when new child rows were flushed to disk but their new
> > parent
> > > > rows were not, etc.
> > > >
> > > > DO NOT TRUST THAT COPY!
> > > >
> > > > Art
> > > >
> > > > Art S. Kagel
> >
> > --001a11c3ca14de913004e2446703
> >
> >
> >
> >
>
> ****************************************************************************
> ***
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a11c3a9689ed4c204e2449476
>
>
> ****************************************************************************
> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--001a11c2257865d43f04e24c8fe2

Messages In This Thread

• Informix Database testing
  medkba -- Wednesday, 24 July 2013, at 4:54 a.m.
  • RE: Informix Database testing
    Alexandre Marini -- Wednesday, 24 July 2013, at 7:16 a.m.
    • RE: Informix Database testing
      medkba -- Wednesday, 24 July 2013, at 7:42 a.m.
      • RE: Informix Database testing
        Alexandre Marini -- Wednesday, 24 July 2013, at 8:04 a.m.
  • Re: Informix Database testing
    Art Kagel -- Wednesday, 24 July 2013, at 10:07 a.m.
    • Re: Informix Database testing
      medkba -- Wednesday, 24 July 2013, at 10:16 a.m.
      • Re: Informix Database testing
        Art Kagel -- Wednesday, 24 July 2013, at 10:26 a.m.
        • Re: Informix Database testing
          medkba -- Wednesday, 24 July 2013, at 10:44 a.m.
          • Re: Informix Database testing
            Art Kagel -- Wednesday, 24 July 2013, at 10:54 a.m.
            • Re: Informix Database testing
              medkba -- Wednesday, 24 July 2013, at 11:06 a.m.
              • Re: Informix Database testing
                Art Kagel -- Wednesday, 24 July 2013, at 11:20 a.m.
                • Re: Informix Database testing
                  medkba -- Wednesday, 24 July 2013, at 11:32 a.m.
                  • RE: Informix Database testing
                    Alexandre Marini -- Wednesday, 24 July 2013, at 12:11 p.m.
                  • Re: Informix Database testing
                    Art Kagel -- Wednesday, 24 July 2013, at 12:29 p.m.
                    • Re: Informix Database testing
                      medkba -- Wednesday, 24 July 2013, at 12:41 p.m.
                      • Re: Informix Database testing
                        medkba -- Wednesday, 24 July 2013, at 12:51 p.m.
                        • Re: Informix Database testing
                          medkba -- Wednesday, 24 July 2013, at 12:55 p.m.
                      • RE: Informix Database testing
                        Andrew Ford -- Wednesday, 24 July 2013, at 1:26 p.m.
                        • Re: Informix Database testing
                          medkba -- Wednesday, 24 July 2013, at 10:12 p.m.
                          • Re: Informix Database testing
                            Art Kagel -- Thursday, 25 July 2013, at 7:39 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.