Informix Database testing

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

Hello. As any other database engine I know, if you copy all the necessary files, utilities, pre-reqs, and supposing your engine is not using raw devices, and both machines are at least of the same arch types, and OSes are in good compatible levels (not needed to be equal, but cannot be too different, also), a simple copy and start would bring up the engine, of course. Of course, machines should have at least, equal configurations (memory, and disk spaces). Hope this helps. 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: Informix Database testing [30907] > Date: Wed, 24 Jul 2013 04:54:25 -0400 > > 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. >

Hello, informix is using raw devices and we need to change anything onconfig and sqlhosts file Thank you Regards Baskaran On Jul 24, 2013 7:17 PM, "Alexandre Marini" <alexandre@briug.org> wrote: > Hello. > > As any other database engine I know, if you copy all the necessary files, > utilities, pre-reqs, and supposing your engine is not using raw devices, > and > both machines are at least of the same arch types, and OSes are in good > compatible levels (not needed to be equal, but cannot be too different, > also), > a simple copy and start would bring up the engine, of course. Of course, > machines should have at least, equal configurations (memory, and disk > spaces). > > Hope this helps. > > 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: Informix Database testing [30907] > > Date: Wed, 24 Jul 2013 04:54:25 -0400 > > > > 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. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e013d100cdef62304e2406512

Ok, the best way to do it will be using a backup+restore process, then (same arch + same OS + at least the same memory and disk configurations, in both machines). Google for "informix information center backup and restore guide", according to your Informix version. Eg: Informix information center V11.5 -> Informix 11.50 If you need some specific help, just ask us ok? Just remember to specify your box architecture and Informix Version in your messages. 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 [30910] > Date: Wed, 24 Jul 2013 07:42:15 -0400 > > Hello, informix is using raw devices and we need to change anything > onconfig and sqlhosts file > Thank you > Regards > Baskaran > On Jul 24, 2013 7:17 PM, "Alexandre Marini" <alexandre@briug.org> wrote: > > > Hello. > > > > As any other database engine I know, if you copy all the necessary files, > > utilities, pre-reqs, and supposing your engine is not using raw devices, > > and > > both machines are at least of the same arch types, and OSes are in good > > compatible levels (not needed to be equal, but cannot be too different, > > also), > > a simple copy and start would bring up the engine, of course. Of course, > > machines should have at least, equal configurations (memory, and disk > > spaces). > > > > Hope this helps. > > > > 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: Informix Database testing [30907] > > > Date: Wed, 24 Jul 2013 04:54:25 -0400 > > > > > > 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. > > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --089e013d100cdef62304e2406512 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

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

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

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

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

?? 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 > > > > *********************************************************************

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

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

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 -vChecking 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 re

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 en

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

[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

For some updates, No files in this directory informix@whx003n$ cd INFORMIXTMP informix@whx003n$ ls -lltotal 0 informix@whx003n$ pwd /INFORMIXTMP informix@whx003n$ ls -lltotal 0 informix@whx003n$ On Thu, Jul 25, 2013 at 12:41 AM, medkba <medkba@gmail.com> wrote: > [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 n

sqlhost entry as below prod08_amk82 onipcshm whxd003ifx-new informix_sv prod08_ews82 onsoctcp whxd003ifx-new informix_sv On Thu, Jul 25, 2013 at 12:51 AM, medkba <medkba@gmail.com> wrote: > For some updates, No files in this directory > > informix@whx003n$ cd INFORMIXTMP > informix@whx003n$ ls -ll> total 0 > informix@whx003n$ pwd > /INFORMIXTMP > informix@whx003n$ ls -ll> total 0 > informix@whx003n$ > > On Thu, Jul 25, 2013 at 12:41 AM, medkba <medkba@gmail.com> wrote: > > > [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 in

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

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

backup and restore! 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:12 PM, medkba <medkba@gmail.com> wrote: > 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: