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
> > > > > >
> > > > > > Thank 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
