 |
IDS Forum
RE: Informix Database testing
Posted By: Alexandre Marini
Date: Wednesday, 24 July 2013, at 12:11 p.m.
In Response To: Re: Informix Database testing (medkba)
Hello.
You´re facing this issue mainly because the primary (rootdbs) chunk is not found by your operational system:
Cannot Open Primary Chunk '/db/ewso/root/root1', errno = 2
The errno.h description for that OS error is:
#define ENOENT 2 /* No such file or directory */
As Art Kagel suggested, you should have done a copy in a blocking way in Informix, to ensure data is not modified.
Remember that you can always do a backup + restore on the other side, and then you can enable an ER between the two servers, to check+repair your tables. The last part (ER) can even being done between different servers, an OSes. That way, you can migrate everything online, with a minimun, or even none downtime of your applications.
Regards.
Alexandre Marini
IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10
IBM Information Management Informix Technical Professional
IBM Infosphere DataStage Technical Professional
Informix Senior DBA - Orizon Brasil
BRIUG website administrator
Informix independent consultant
> To: ids@iiug.org
> From: medkba@gmail.com
> Subject: Re: Informix Database testing [30922]
> Date: Wed, 24 Jul 2013 11:32:28 -0400
>
> 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
> > 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:06 AM, medkba <medkba@gmail.com> wrote:
> >
> > > Server administrator copied from source server to destination server.
> > What
> > > I understand if the database online and we copied informix db files to
> > > destination server and we may not startup database due to data file
> > corrupt
> > > or some other reason. Am I correct?
> > >
> > > Thank you very much
> > >
> > > On Wed, Jul 24, 2013 at 10:54 PM, Art Kagel <art.kagel@gmail.com> wrote:
> > >
> > > > ?? I'm not sure that I understand the question, but I'll try to answer
> > > > with a guess.
> > > >
> > > > The only way to copy the server safely while it is online (without
> > > blocking
> > > > it) and be able to restore the files to another machine and bring the
> > > copy
> > > > up is to use ontape or onbar to make a full archive of the source
> > server,
> > > > restore that archive to the target machine, modify the sqlhosts file
> > (and
> > > > possibly the onconfig file). Then you can start up the copy.
> > > >
> > > > 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 10:44 AM, medkba <medkba@gmail.com> wrote:
> > > >
> > > > > Art,
> > > > >
> > > > > If it is source database online at the same copy to destination
> > source
> > > > then
> > > > > we cannot able to bring up destination server.
> > > > >
> > > > > No issue if partial data copy to destination server.
> > > > >
> > > > > Is it possible to bring up destination server database?
> > > > >
> > > > > Thank you very much
> > > > >
> > > > > On Wed, Jul 24, 2013 at 10:26 PM, Art Kagel <art.kagel@gmail.com>
> > > wrote:
> > > > >
> > > > > > No. As I stated in my last, the source server has to be either
> > > > completely
> > > > > > offline, or have completed a full checkpoint, having flushed
> > > everything
> > > > > > modified in memory to disk, and blocked from further modifications
> > on
> > > > > disk
> > > > > > in order for a file level copy to succeed in producing a usable
> > copy
> > > of
> > > > > the
> > > > > > server's storage. The checkpoint and block are accomplished with
> > the
> > > > > > onmode -c block command and the block released with onmode -c
> > > unblock.
> > > > > > While the server is blocked, transactions can continue against
> > > memory,
> > > > > > however, eventually, if the block lasts for a long time and the
> > > server
> > > > is
> > > > > > busy, then when all buffer cache pages become dirty (ie modified)
> > and
> > > > new
> > > > > > data needs to be read in from disk, all transactions and most
> > queries
> > > > > will
> > > > > > also be blocked until the server block is released.
> > > > > >
> > > > > > 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 10:16 AM, medkba <medkba@gmail.com> wrote:
> > > > > >
> > > > > > > Hi All,
> > > > > > >
> > > > > > > Source database is up and running at the same time Storage
> > > > > administrator
> > > > > > > copy all the data (binary, raw device and other files) to
> > > destination
> > > > > > > server but the OS and version and patch both are same as source
> > and
> > > > > > > destination.
> > > > > > >
> > > > > > > I am having doubt if the the database online. Is it copy properly
> > > on
> >
> > > > the
> > > > > > > destination server and able to up the database or not.
> > > > > > >
> > > > > > > My informix verison is 11.50 FC9 HP-UX
> > > > > > >
> > > > > > > SQLHOSTS file i have changed destination server name but the
> > source
> > > > > file
> > > > > > is
> > > > > > > up and running.
> > > > > > >
> > > > > > > Is it ok to change only the destination server name on the
> > SQLHOSTS
> > > > > file?
> > > > > > > or miss out some other information to startup the database.
> > > > > > >
> > > > > > > Please advise
> > > > > > >
> > > > > > > Than
> k you very much
> > > > > > >
> > > > > > > Regards
> > > > > > > Baskaran
> > > > > > >
> > > > > > > On Wed, Jul 24, 2013 at 10:07 PM, Art Kagel <art.kagel@gmail.com
> > >
> > > > > wrote:
> > > > > > >
> > > > > > > > IF and only IF the source database engine was offline or
> > blocked
> > > > > > (onmode
> > > > > > > -c
> > > > > > > > block) can a copy of the chunk files result in an engine that
> > > will
> > > > > run
> > > > > > > > properly unless you are very very lucky!
> > > > > > > >
> > > > > > > > That said, you will have to change the hostname in the sqlhosts
> > > > file,
> > > > > > > but,
> > > > > > > > assuming that the chunk files were restored to the same path
> > they
> > > > > came
> > > > > > > from
> > > > > > > > or that the links for the chunk paths were properly linked up
> > to
> > > > the
> > > > > > > > corresponding copy, then unless you want to change the
> > servername
> > > > or
> > > > > > have
> > > > > > > > another server online on that machine and need to change the
> > > > > > > servernumber,
> > > > > > > > all should work.
> > > > > > > >
> > > > > > > > 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 4:54 AM, medkba <medkba@gmail.com>
> > > wrote:
> > > > > > > >
> > > > > > > > > Hi All,
> > > > > > > > >
> > > > > > > > > We are having one server running informix database and system
> > > > admin
> > > > > > > > copied
> > > > > > > > > all the files (binary with data) to other server same
> > > > > configruation.
> > > > > > > > >
> > > > > > > > > Do I need to change any configuration before startup
> > database?
> > > > > > > > >
> > > > > > > > > Any standard practice needs to do this
> > > > > > > > >
> > > > > > > > > Thank you very much
> > > > > > > > >
> > > > > > > > > Regards
> > > > > > > > > Baskaran
> > > > > > > > >
> > > > > > > > > --089e0158ab6cae68cd04e23e0d42
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
> *******************************************************************************
> > > > > > > > > Forum Note: Use "Reply" to post a response in the discussion
> > > > forum.
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > > --001a1133e414b78fef04e2426d01
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
> *******************************************************************************
> > > > > > > > Forum Note: Use "Reply" to post a response in the discussion
> > > forum.
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > > --001a11c34dec850cdf04e24289bd
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
> *******************************************************************************
> > > > > > > Forum Note: Use "Reply" to post a response in the discussion
> > forum.
> > > > > > >
> > > > > > >
> > > > > >
> > > > > > --047d7b3439a478642e04e242afdc
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
> *******************************************************************************
> > > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > > >
> > > > > >
> > > > >
> > > > > --089e013c6b84fe6a4804e242d954
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
> *******************************************************************************
> > > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > > >
> > > > >
> > > >
> > > > --089e013d1cf8fbd75304e2431237
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
> *******************************************************************************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > > --089e013d100c631aec04e243408f
> > >
> > >
> > >
> > >
> >
> >
> *******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --089e013d1cf885696504e24372ac
> >
> >
> >
> >
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --14dae93d9300df4a3604e2439ce1
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Messages In This Thread
IDS Forum is maintained by Administrator with WebBBS 5.12.
|
|
