Import restore issue

I am trying to setup the HDR for two identical Linux servers with IDS 11.50.FC1. I have inftest1 as the primary and inftest2 as secondary server. The setup was completed and I inserted a record into the inftest1. I wait and wait, but the record does not show up in inftest2. I restarted over with the HDR setup and realized the import physical restore in inftest2 has problem with the backup from inftest1. If I restore the inftest2’s backup back into inftest2, then there is no problem. This is the mistake that I made. I have two set of identical disk devices from inftest1 and inftest2. After a whole onbar backup from inftest1, I copied the backup file, ixbar.1 and oncfg_on.1 over the to the inftest2. After all, I issue the physical onbar –r -p command from inftest2, and it can’t read the reserved pages from rootdbs. Please advice anyone? Output from onbar_act.log 2010-08-26 15:32:51 32229 32227 /apps/informix/bin/onbar_d -r -p 2010-08-26 15:32:51 32229 32227 Successfully connected to Storage Manager. 2010-08-26 15:32:51 32229 32227 XBSA Error: (BSAGetObject) Backup object does not exist in Storage Manager. 2010-08-26 15:32:51 32229 32227 Object information: bar_objdesc obj_id 0 obj_name 'rootdbs' obj_type 'R' act_id 52 act_type 2 act_status 0 act_start '2010-08-26 15:32:51' act_end '2010-08-26 08:14:04' ins_time 0 rsam_time 4623210 seal_time 1282824844 prev_seal_time 1282762044 level 0 copyid hi:lo 914453120:0 req_act_id 52 logstream 0 est_pages hi:lo 0:0 first_log 73 chpt_log 73 last_log 0 partial_flag 0 do_query 0 ins_sm_id 0 ins_sm_name '' ins_verify 0 ins_verify_date '' restore order 0:0 objInfo '' retry 0 in_catalog 0 in_bootfile 0 child_pid 0 child_state 0 bkup_host '' backup_order 83 2010-08-26 15:32:51 32229 32227 (-43342) Cannot read reserved pages from rootdbs object. 2010-08-26 15:32:51 32229 32227 /apps/informix/bin/onbar_d complete, returning 100 (0x64) The devices are looking good from ism_watch in inftest2. Device type volume x/savelogs_tri file ISMLogs reading, done x/savedata_tri file ISMData reading, done

Tri, It certainly is possible to do an onbar imported restore. However, ontape is much easier to use for this purpose. You may just want to use it to start your HDR. Joe From: "TRI TRINH" <tri_trinh@hotmail.com> To: ids@iiug.org Date: 08/27/2010 07:54 AM Subject: Import restore issue [21069] Sent by: ids-bounces@iiug.org I am trying to setup the HDR for two identical Linux servers with IDS 11.50.FC1. I have inftest1 as the primary and inftest2 as secondary server. The setup was completed and I inserted a record into the inftest1. I wait and wait, but the record does not show up in inftest2. I restarted over with the HDR setup and realized the import physical restore in inftest2 has problem with the backup from inftest1. If I restore the inftest2?s backup back into inftest2, then there is no problem. This is the mistake that I made. I have two set of identical disk devices from inftest1 and inftest2. After a whole onbar backup from inftest1, I copied the backup file, ixbar.1 and oncfg_on.1 over the to the inftest2. After all, I issue the physical onbar ?r -p command from inftest2, and it can?t read the reserved pages from rootdbs. Please advice anyone? Output from onbar_act.log 2010-08-26 15:32:51 32229 32227 /apps/informix/bin/onbar_d -r -p 2010-08-26 15:32:51 32229 32227 Successfully connected to Storage Manager. 2010-08-26 15:32:51 32229 32227 XBSA Error: (BSAGetObject) Backup object does not exist in Storage Manager. 2010-08-26 15:32:51 32229 32227 Object information: bar_objdesc obj_id 0 obj_name 'rootdbs' obj_type 'R' act_id 52 act_type 2 act_status 0 act_start '2010-08-26 15:32:51' act_end '2010-08-26 08:14:04' ins_time 0 rsam_time 4623210 seal_time 1282824844 prev_seal_time 1282762044 level 0 copyid hi:lo 914453120:0 req_act_id 52 logstream 0 est_pages hi:lo 0:0 first_log 73 chpt_log 73 last_log 0 partial_flag 0 do_query 0 ins_sm_id 0 ins_sm_name '' ins_verify 0 ins_verify_date '' restore order 0:0 objInfo '' retry 0 in_catalog 0 in_bootfile 0 child_pid 0 child_state 0 bkup_host '' backup_order 83 2010-08-26 15:32:51 32229 32227 (-43342) Cannot read reserved pages from rootdbs object. 2010-08-26 15:32:51 32229 32227 /apps/informix/bin/onbar_d complete, returning 100 (0x64) The devices are looking good from ism_watch in inftest2. Device type volume x/savelogs_tri file ISMLogs reading, done x/savedata_tri file ISMData reading, done ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Tri, As Joe states, ontape is a lot easier. While this should not be a big deal for onbar, adding ism into the mix makes it difficult, as is it is not easy (you can do it, but it is a pain) due to the limitations in ism. If at all possible, use either ontape or get a more robust storage manager. The steps for using ontape should be fully detailed in the HDR documentation. Roger On Fri, Aug 27, 2010 at 9:18 AM, Joseph_Jurcazak@aotx.uscourts.gov < Joseph_Jurcazak@aotx.uscourts.gov> wrote: > Tri, > > It certainly is possible to do an onbar imported restore. However, ontape > is much easier to use for this purpose. You may just want to use it to > start your HDR. > > Joe > > From: "TRI TRINH" <tri_trinh@hotmail.com> > To: ids@iiug.org > Date: 08/27/2010 07:54 AM > Subject: Import restore issue [21069] > Sent by: ids-bounces@iiug.org > > I am trying to setup the HDR for two identical Linux servers with IDS > 11.50.FC1. I have inftest1 as the primary and inftest2 as secondary > server. > The setup was completed and I inserted a record into the inftest1. I wait > and > wait, but the record does not show up in inftest2. I restarted over with > the > HDR setup and realized the import physical restore in inftest2 has problem > > with the backup from inftest1. If I restore the inftest2?s backup back > into > inftest2, then there is no problem. This is the mistake that I made. > > I have two set of identical disk devices from inftest1 and inftest2. After > a > whole onbar backup from inftest1, I copied the backup file, ixbar.1 and > oncfg_on.1 over the to the inftest2. After all, I issue the physical onbar > ?r > -p command from inftest2, and it can?t read the reserved pages from > rootdbs. > Please advice anyone? > > Output from onbar_act.log > > 2010-08-26 15:32:51 32229 32227 /apps/informix/bin/onbar_d -r -p > 2010-08-26 15:32:51 32229 32227 Successfully connected to Storage Manager. > > 2010-08-26 15:32:51 32229 32227 XBSA Error: (BSAGetObject) Backup object > does > not exist in Storage Manager. > 2010-08-26 15:32:51 32229 32227 Object information: bar_objdesc > > obj_id 0 obj_name 'rootdbs' obj_type 'R' act_id 52 act_type 2 act_status 0 > > act_start '2010-08-26 15:32:51' act_end '2010-08-26 08:14:04' > > ins_time 0 rsam_time 4623210 seal_time 1282824844 prev_seal_time > 1282762044 > level 0 copyid hi:lo 914453120:0 req_act_id 52 > > logstream 0 est_pages hi:lo 0:0 first_log 73 chpt_log 73 last_log 0 > > partial_flag 0 do_query 0 ins_sm_id 0 ins_sm_name '' > > ins_verify 0 ins_verify_date '' restore order 0:0 > > objInfo '' > > retry 0 in_catalog 0 in_bootfile 0 child_pid 0 child_state 0 > > bkup_host '' backup_order 83 > 2010-08-26 15:32:51 32229 32227 (-43342) Cannot read reserved pages from > rootdbs object. > 2010-08-26 15:32:51 32229 32227 /apps/informix/bin/onbar_d complete, > returning > 100 (0x64) > > The devices are looking good from ism_watch in inftest2. > > Device type volume > x/savelogs_tri file ISMLogs reading, done > x/savedata_tri file ISMData reading, done > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0022154016fab40952048ece1191

thanks for the advise! I just never experience the ontape before. I will try it. Do I need to modify anything in the onconfig file to switch from onbar to ontape?

Tri, Yes, TAPEDEV and LTAPEDEV will need to be set and you might need to look at TAPESIZE and LTAPESIZE.If you wish to continue with ism, take a look at the following link from IBM for performing an imported restore using onbar/ism. http://www-01.ibm.com/support/docview.wss?uid=swg21416790&myns=swgimgmt&mynp=OCS SGU8G&mync=R As you can see, using ontape would be easier. Roger On Fri, Aug 27, 2010 at 9:46 AM, TRI TRINH <tri_trinh@hotmail.com> wrote: > thanks for the advise! I just never experience the ontape before. I will > try > it. Do I need to modify anything in the onconfig file to switch from onbar > to > ontape? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --000e0cd51cf07f2dd2048ece7d5f

For the entire process, you can follow Mr. Ford's helpful article: http://www.informix-dba.com/2010/08/informix-hdr-will-save-your-butt.html With his example, you won't have to worry about the "TAPEDEV" parameters. Joe From: "TRI TRINH" <tri_trinh@hotmail.com> To: ids@iiug.org Date: 08/27/2010 08:47 AM Subject: Re: Import restore issue [21072] Sent by: ids-bounces@iiug.org thanks for the advise! I just never experience the ontape before. I will try it. Do I need to modify anything in the onconfig file to switch from onbar to ontape? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Use ontape to STDIO because it doesn't require any configuration: Backup: ontape -s -t STDIO >archive_for_hdr_setup.ontape Physical restore: ontape -p -t STDIO <archive_for_hdr_setup.ontape Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, 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 Fri, Aug 27, 2010 at 9:46 AM, TRI TRINH <tri_trinh@hotmail.com> wrote: > thanks for the advise! I just never experience the ontape before. I will > try > it. Do I need to modify anything in the onconfig file to switch from onbar > to > ontape? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016e642db9af9f633048ecf4efd

Thank you all! It's just that I never experience the ontape utility. This is a good opportunity for me to try ontape. Thanks again.

Hi, I did import restore and it requires some configuration from the source DB instance...ixbar.xx, onconfig, sqlhosts. ixbar.xx -- this compose of the backup you have done and the ISM will ask about this if you restore. if it's too big, trim it on the date you want to restore. You will need the logical logs. you will need to configure(add) your destination machine on the ISM side. you will need to set the IFXCLIENT=source machine, (although you are in the destination machine). Given the error you provided, it looks like it is not a DB issue but your backup looks not there. Or you haven't set the IFXCLIENT-(original source machine were you have done your backup).

Thank you Jack! I have another hot project in the last few days. I will get back to the HDR project soon. I will try both ontape and onbar. Again, thank you for the tips. tri

Hi, I was able to restore the database from inftest1 (prim) to inftest2 (sec) by ontape utility. But I still have problem with the "onmode -d secondary inftest1.newpiper.net" from inftest2 server. Please check out the output from below and advice. Thanks From inftest1 "onmode -d primary inftest2.newpiper.net" onstat -d 13:43:20 DR: new type = primary, secondary server name = inftest2.newpiper.net 13:43:20 DR: Cannot connect to secondary server 13:43:20 DR: Turned off on primary server While the instance in Fast Recovery mode from inftest2, I did "onmode -d secondary inftest1.newpiper.net" Output from online.log 13:45:01 DR: Reservation of the last logical log for log backup turned off 13:45:01 DR: new type = secondary, primary server name = inftest1.newpiper.net 13:45:01 DR: Owner of the disk is set as demo_on. 13:45:01 Cannot create SMX pipes 13:45:01 DR: Trying to connect to primary server = inftest1.newpiper.net 13:45:01 DR: Cannot connect to primary server 13:45:01 DR: Turned off on secondary server I look around and I think the command I apply is correct "onmode -d secondary inftest1.newpiper.net" http://www-01.ibm.com/support/docview.wss?uid=swg1IC60274 http://www-01.ibm.com/support/docview.wss?uid=swg21422644&myns=swgimgmt&mynp=OCS SGU8G&mync=R

Tri- It appears that Informix is unable to route to the other server. What do your sqlhosts files look like? If the network name of the servers are inftest*.newpiper.net and the server names are inftest* in your sqlhosts, you need to use the server names, not the network names. Also, HADR requires a trusted connection between the two servers. If you don't have that already set up, there are several way to do so. The easiest is hosts.equiv. --EEM > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > TRI TRINH > Sent: Wednesday, September 01, 2010 12:52 PM > To: ids@iiug.org > Subject: Re: Import restore issue [21093] > > Hi, > > I was able to restore the database from inftest1 (prim) to inftest2 > (sec) by > ontape utility. But I still have problem with the "onmode -d secondary > inftest1.newpiper.net" from inftest2 server. Please check out the > output from > below and advice. Thanks > > >From inftest1 "onmode -d primary inftest2.newpiper.net" > > onstat -d> > 13:43:20 DR: new type = primary, secondary server name = > inftest2.newpiper.net > 13:43:20 DR: Cannot connect to secondary server > 13:43:20 DR: Turned off on primary server > > While the instance in Fast Recovery mode from inftest2, I did "onmode - > d > secondary inftest1.newpiper.net" > > Output from online.log > > 13:45:01 DR: Reservation of the last logical log for log backup turned > off > 13:45:01 DR: new type = secondary, primary server name = > inftest1.newpiper.net > 13:45:01 DR: Owner of the disk is set as demo_on. > 13:45:01 Cannot create SMX pipes > 13:45:01 DR: Trying to connect to primary server = > inftest1.newpiper.net > 13:45:01 DR: Cannot connect to primary server > 13:45:01 DR: Turned off on secondary server > > I look around and I think the command I apply is correct "onmode -d > secondary > inftest1.newpiper.net" > > http://www-01.ibm.com/support/docview.wss?uid=swg1IC60274 > > http://www- > 01.ibm.com/support/docview.wss?uid=swg21422644&myns=swgimgmt&mynp=OCSSG > U8G&mync=R > > > *********************************************************************** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum.

>>From inftest1 "onmode -d primary inftest2.newpiper.net" This doesn't look like a DBSERVERNAME or DBSERVERALIAS to me, it looks like a server name. You want to invoke onmode -d primary and onmode -d secondary commands with the DBSERVERNAME or a DBSERVERALIAS of the Informix engine you want to start HDR with. Andrew ----- Original Message ----- From: "TRI TRINH" <tri_trinh@hotmail.com> To: <ids@iiug.org> Sent: Wednesday, September 01, 2010 12:51 PM Subject: Re: Import restore issue [21093] > Hi, > > I was able to restore the database from inftest1 (prim) to inftest2 (sec) > by > ontape utility. But I still have problem with the "onmode -d secondary > inftest1.newpiper.net" from inftest2 server. Please check out the output > from > below and advice. Thanks > >>From inftest1 "onmode -d primary inftest2.newpiper.net" > > onstat -d> > 13:43:20 DR: new type = primary, secondary server name = > inftest2.newpiper.net > 13:43:20 DR: Cannot connect to secondary server > 13:43:20 DR: Turned off on primary server > > While the instance in Fast Recovery mode from inftest2, I did "onmode -d > secondary inftest1.newpiper.net" > > Output from online.log > > 13:45:01 DR: Reservation of the last logical log for log backup turned off > 13:45:01 DR: new type = secondary, primary server name = > inftest1.newpiper.net > 13:45:01 DR: Owner of the disk is set as demo_on. > 13:45:01 Cannot create SMX pipes > 13:45:01 DR: Trying to connect to primary server = inftest1.newpiper.net > 13:45:01 DR: Cannot connect to primary server > 13:45:01 DR: Turned off on secondary server > > I look around and I think the command I apply is correct "onmode -d > secondary > inftest1.newpiper.net" > > http://www-01.ibm.com/support/docview.wss?uid=swg1IC60274 > > http://www-01.ibm.com/support/docview.wss?uid=swg21422644&myns=swgimgmt&mynp=OCS SGU8G&mync=R > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

From the beginning, I thought if I have them identical that would simplify things. I set the DBSERVERNAME and DBSERVERALIASES with the same names from both servers. Here is the situation. Please tell me what can I do. sqlhosts from inftest1 demo_on onsoctcp inftest1.newpiper.net demo_on k=0 demo_shm onsoctcp inftest1.newpiper.net demo_shm k=0 sqlhosts from inftest2 demo_on onsoctcp inftest2.newpiper.net demo_on k=0 demo_shm onsoctcp inftest2.newpiper.net demo_shm k=0 ---------------------------------------- onconfig from inftest1 and inftest2 have the same dbservername and dbserveraliases DBSERVERNAME demo_on DBSERVERALIASES demo_shm SERVERNUM 1 onconfig from inftest2 DBSERVERNAME demo_on DBSERVERALIASES demo_shm SERVERNUM 2

> I set the DBSERVERNAME and DBSERVERALIASES with the same names from > both servers. This will not work, the DBSERVERNAMEs will need to be unique to each engine. Why not set the DBSERVERNAME of the engine running on inftest1 to inftest1 and inftest2 on inftest2. After this is completed, onmode -d primary inftest2 and onmode -d secondary inftest1 should work. Andrew ----- Original Message ----- From: "TRI TRINH" <tri_trinh@hotmail.com> To: <ids@iiug.org> Sent: Wednesday, September 01, 2010 2:25 PM Subject: Re: Import restore issue [21096] > >From the beginning, I thought if I have them identical that would > >simplify > things. I set the DBSERVERNAME and DBSERVERALIASES with the same names > from > both servers. Here is the situation. Please tell me what can I do. > > sqlhosts from inftest1 > > demo_on onsoctcp inftest1.newpiper.net demo_on k=0 > demo_shm onsoctcp inftest1.newpiper.net demo_shm k=0 > > sqlhosts from inftest2 > > demo_on onsoctcp inftest2.newpiper.net demo_on k=0 > demo_shm onsoctcp inftest2.newpiper.net demo_shm k=0 > ---------------------------------------- > > onconfig from inftest1 and inftest2 have the same dbservername and > dbserveraliases > > DBSERVERNAME demo_on > DBSERVERALIASES demo_shm > SERVERNUM 1> > onconfig from inftest2 > > DBSERVERNAME demo_on > DBSERVERALIASES demo_shm > SERVERNUM 2> > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Try this instead: onconfig from inftest1 DBSERVERNAME demo_on DBSERVERALIASES demo_shm SERVERNUM 1 onconfig from inftest2 DBSERVERNAME demo_backup DBSERVERALIASES demo_backshm SERVERNUM 2 sqlhosts on inftest1 demo_on onsoctcp inftest1.newpiper.net demo_on k=0 demo_shm onsoctcp inftest1.newpiper.net demo_shm k=0 demo_back onsoctcp inftest2.newpiper.net demo_on k=0 sqlhosts from inftest2 demo_back onsoctcp inftest2.newpiper.net demo_on k=0 demo_backshm onsoctcp inftest2.newpiper.net demo_shm k=0 demo_on onsoctcp inftest1.newpiper.net demo_on k=0 on the primary: onmode -d primary demo_back on the secondary: onmode -d secondary demo_on --EEM Also, if demo_shm is supposed to mean shared memory: demo_on onipcshm inftest1.newpiper.net fake_service > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > TRI TRINH > Sent: Wednesday, September 01, 2010 2:26 PM > To: ids@iiug.org > Subject: Re: Import restore issue [21096] > > >From the beginning, I thought if I have them identical that would > simplify > things. I set the DBSERVERNAME and DBSERVERALIASES with the same names > from > both servers. Here is the situation. Please tell me what can I do. > > sqlhosts from inftest1 > > demo_on onsoctcp inftest1.newpiper.net demo_on k=0 > demo_shm onsoctcp inftest1.newpiper.net demo_shm k=0 > > sqlhosts from inftest2 > > demo_on onsoctcp inftest2.newpiper.net demo_on k=0 > demo_shm onsoctcp inftest2.newpiper.net demo_shm k=0 > ---------------------------------------- > > onconfig from inftest1 and inftest2 have the same dbservername and > dbserveraliases > > DBSERVERNAME demo_on > DBSERVERALIASES demo_shm > SERVERNUM 1> > onconfig from inftest2 > > DBSERVERNAME demo_on > DBSERVERALIASES demo_shm > SERVERNUM 2> > > *********************************************************************** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum.

Thank you all! Looking at the online.log from both servers. It seems like they are talking now. I inserted a record from inftest1 and will check it out tomorrow. I used the configuration that provided by Everett. Tomorrow, I will save Everett's configuration and try Andrew's configuration. It's kind of exciting when there is a working result. I will sure spend time and play with the setup. Thanks again. online.log from inftest1. 17:09:33 Logical Log 77 Complete, timestamp: 0x4f4b67. 17:09:33 DR: Sending log 77, size 5000 pages, 53.24 percent used 17:09:34 DR: Sending log 78 (current), size 5000 pages, 0.06 percent used 17:09:35 DR: Sending Logical Logs Completed 17:09:36 DR: Primary server operational 17:09:38 Checkpoint Completed: duration was 1 seconds. 17:09:38 Wed Sep 1 - loguniq 78, logpos 0x4018, timestamp: 0x4f4b8c Interval: 11233 17:09:38 Maximum server connections 0 17:09:38 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 31, Llog used 56 online.log from inftest2 17:09:34 Logical Log 77 Complete, timestamp: 0x4f4cf9. 17:09:36 Btree scanners disabled. 17:09:37 DR: HDR secondary server operational 17:09:38 Checkpoint Completed: duration was 0 seconds. 17:09:38 Wed Sep 1 - loguniq 78, logpos 0x4018, timestamp: 0x4f4d0f Interval: 11234

High five for Tri! > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > TRI TRINH > Sent: Wednesday, September 01, 2010 4:29 PM > To: ids@iiug.org > Subject: Re: Import restore issue [21099] > > Thank you all! > > Looking at the online.log from both servers. It seems like they are > talking > now. I inserted a record from inftest1 and will check it out tomorrow. > I used > the configuration that provided by Everett. Tomorrow, I will save > Everett's > configuration and try Andrew's configuration. It's kind of exciting > when there > is a working result. I will sure spend time and play with the setup. > Thanks > again. > > online.log from inftest1. > > 17:09:33 Logical Log 77 Complete, timestamp: 0x4f4b67. > 17:09:33 DR: Sending log 77, size 5000 pages, 53.24 percent used > 17:09:34 DR: Sending log 78 (current), size 5000 pages, 0.06 percent > used > 17:09:35 DR: Sending Logical Logs Completed > 17:09:36 DR: Primary server operational > 17:09:38 Checkpoint Completed: duration was 1 seconds. > 17:09:38 Wed Sep 1 - loguniq 78, logpos 0x4018, timestamp: 0x4f4b8c > Interval: > 11233 > > 17:09:38 Maximum server connections 0 > 17:09:38 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns > blocked 0, > Plog used 31, Llog used 56 > > online.log from inftest2 > > 17:09:34 Logical Log 77 Complete, timestamp: 0x4f4cf9. > 17:09:36 Btree scanners disabled. > 17:09:37 DR: HDR secondary server operational > 17:09:38 Checkpoint Completed: duration was 0 seconds. > 17:09:38 Wed Sep 1 - loguniq 78, logpos 0x4018, timestamp: 0x4f4d0f > Interval: > 11234 > > > *********************************************************************** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum.

Thank you all! Looking at the online.log from both servers. It seems like they are talking now. I inserted a record from inftest1 and will check it out tomorrow. I used the configuration that provided by Everett. Tomorrow, I will save Everett's configuration and try Andrew's configuration. It's kind of exciting when there is a working result. I will sure spend time and play with the setup. Thanks again. online.log from inftest1. 17:09:33 Logical Log 77 Complete, timestamp: 0x4f4b67. 17:09:33 DR: Sending log 77, size 5000 pages, 53.24 percent used 17:09:34 DR: Sending log 78 (current), size 5000 pages, 0.06 percent used 17:09:35 DR: Sending Logical Logs Completed 17:09:36 DR: Primary server operational 17:09:38 Checkpoint Completed: duration was 1 seconds. 17:09:38 Wed Sep 1 - loguniq 78, logpos 0x4018, timestamp: 0x4f4b8c Interval: 11233 17:09:38 Maximum server connections 0 17:09:38 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 31, Llog used 56 online.log from inftest2 17:09:34 Logical Log 77 Complete, timestamp: 0x4f4cf9. 17:09:36 Btree scanners disabled. 17:09:37 DR: HDR secondary server operational 17:09:38 Checkpoint Completed: duration was 0 seconds. 17:09:38 Wed Sep 1 - loguniq 78, logpos 0x4018, timestamp: 0x4f4d0f Interval: 11234

> I inserted a record from inftest1 and will check it out tomorrow. HOW WILL YOU SLEEP TONIGHT? DON'T YOU WANT TO SEE THE MAGIC OF HDR AFTER ALL THE WORK YOU PUT IN? Looks like it worked, BTW. Andrew ----- Original Message ----- From: "TRI TRINH" <tri_trinh@hotmail.com> To: <ids@iiug.org> Sent: Wednesday, September 01, 2010 4:28 PM Subject: Re: Import restore issue [21099] > Thank you all! > > Looking at the online.log from both servers. It seems like they are > talking > now. I inserted a record from inftest1 and will check it out tomorrow. I > used > the configuration that provided by Everett. Tomorrow, I will save > Everett's > configuration and try Andrew's configuration. It's kind of exciting when > there > is a working result. I will sure spend time and play with the setup. > Thanks > again. > > online.log from inftest1. > > 17:09:33 Logical Log 77 Complete, timestamp: 0x4f4b67. > 17:09:33 DR: Sending log 77, size 5000 pages, 53.24 percent used > 17:09:34 DR: Sending log 78 (current), size 5000 pages, 0.06 percent used > 17:09:35 DR: Sending Logical Logs Completed > 17:09:36 DR: Primary server operational > 17:09:38 Checkpoint Completed: duration was 1 seconds. > 17:09:38 Wed Sep 1 - loguniq 78, logpos 0x4018, timestamp: 0x4f4b8c > Interval: > 11233 > > 17:09:38 Maximum server connections 0 > 17:09:38 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked > 0, > Plog used 31, Llog used 56 > > online.log from inftest2 > > 17:09:34 Logical Log 77 Complete, timestamp: 0x4f4cf9. > 17:09:36 Btree scanners disabled. > 17:09:37 DR: HDR secondary server operational > 17:09:38 Checkpoint Completed: duration was 0 seconds. > 17:09:38 Wed Sep 1 - loguniq 78, logpos 0x4018, timestamp: 0x4f4d0f > Interval: > 11234 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

= From: "TRI TRINH" <tri_trinh@hotmail.com> = = To: ids@iiug.org = = Date: 09/01/2010 05:29 PM = = Subject: Re: Import restore issue [21099] = = Sent by: ids-bounces@iiug.org = = Thank you all! Looking at the online.log from both servers. It seems like they are tal= king now. I inserted a record from inftest1 and will check it out tomorrow. = I used the configuration that provided by Everett. Tomorrow, I will save Evere= tt's configuration and try Andrew's configuration. It's kind of exciting whe= n there is a working result. I will sure spend time and play with the setup. Th= anks again. online.log from inftest1. 17:09:33 Logical Log 77 Complete, timestamp: 0x4f4b67. 17:09:33 DR: Sending log 77, size 5000 pages, 53.24 percent used 17:09:34 DR: Sending log 78 (current), size 5000 pages, 0.06 percent us= ed 17:09:35 DR: Sending Logical Logs Completed 17:09:36 DR: Primary server operational 17:09:38 Checkpoint Completed: duration was 1 seconds. 17:09:38 Wed Sep 1 - loguniq 78, logpos 0x4018, timestamp: 0x4f4b8c Interval: 11233 17:09:38 Maximum server connections 0 17:09:38 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns bloc= ked 0, Plog used 31, Llog used 56 online.log from inftest2 17:09:34 Logical Log 77 Complete, timestamp: 0x4f4cf9. 17:09:36 Btree scanners disabled. 17:09:37 DR: HDR secondary server operational 17:09:38 Checkpoint Completed: duration was 0 seconds. 17:09:38 Wed Sep 1 - loguniq 78, logpos 0x4018, timestamp: 0x4f4d0f Interval: 11234 ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

The magic of HRD did not create magic. I tested many times by insert a record into the inftest1(prim) by dbaccess, but it never replicate to inftest2(sec). I have another question. After I promoted inftest2 to secondary by “onmode -d secondary demo_on”, the engine change to Read-Only(Sec) mode. When the engine in “Read-Only” mode, I can’t do the dbaccess nor the ODBC. In order to access tables in inftest2(sec), I have to shut down the primary, change the secondary server to standard, and change it to online mode. Is there any ways to access tables when engine is in “read only” mode? Once the inftest2(sec) is in “online” mode, I can’t promote it back to secondary server with the command “onmode -d secondary demo_on”. I have to do the backup and restore over again. Is that any way to synch them up without backup and restore? [informix@inftest1 etc]$ onstat -g dri IBM Informix Dynamic Server Version 11.50.FC1 -- On-Line (Prim) -- Up 00:55:07 -- 39728 Kbytes Data Replication: Type State Paired server Last DR CKPT (id/pg) Supports Proxy Writes primary on demo_back 80 / 165 NA DRINTERVAL 30 DRTIMEOUT 30 DRAUTO 0 DRLOSTFOUND /apps/informix/etc/dr.lostfound DRIDXAUTO 0 ENCRYPT_HDR 0 [informix@inftest2 etc]$ onstat -g dri IBM Informix Dynamic Server Version 11.50.FC1 -- Read-Only (Sec) -- Up 00:33:07 -- 64304 Kbytes Data Replication: Type State Paired server Last DR CKPT (id/pg) Supports Proxy Writes HDR Secondary on demo_on 80 / 165 N DRINTERVAL 30 DRTIMEOUT 30 DRAUTO 0 DRLOSTFOUND /apps/informix/etc/dr.lostfound DRIDXAUTO 0 ENCRYPT_HDR 0

> The magic of HRD did not create magic. I tested many times by insert a > record > into the inftest1(prim) by dbaccess, but it never replicate to > inftest2(sec). Do your databases have logging enabled? > I have another question. After I promoted inftest2 to secondary by > “onmode -d > secondary demo_on”, the engine change to Read-Only(Sec) mode. So far so good. > When the engine in “Read-Only” mode, I can’t do the dbaccess nor the ODBC. > In > order to access tables in inftest2(sec), I have to shut down the primary, > change the secondary > server to standard, and change it to online mode. Is there any ways to > access > tables when engine is in “read only” mode? Not so good, you should definitely be able to connect to the secondary while it is in readonly mode. Post the sqlhosts files from both engines, the DBSERVERNAME and DBSERVERALIAS for both engines and the dbaccess command you are using. > Once the inftest2(sec) is in “online” mode, I can’t promote it back to > secondary server with the command “onmode -d secondary demo_on”. I have to > do > the backup and restore over again. Is that any way to synch them up > without > backup and restore? Backup and restore is the only way if both engines are concurrently operating in online mode. Andrew ----- Original Message ----- From: "TRI TRINH" <tri_trinh@hotmail.com> To: <ids@iiug.org> Sent: Thursday, September 02, 2010 2:56 PM Subject: Re: RE: Import restore issue [21142] > The magic of HRD did not create magic. I tested many times by insert a > record > into the inftest1(prim) by dbaccess, but it never replicate to > inftest2(sec). > > I have another question. After I promoted inftest2 to secondary by > “onmode -d > secondary demo_on”, the engine change to Read-Only(Sec) mode. When the > engine > in “Read-Only” mode, I can’t do the dbaccess nor the ODBC. In order to > access > tables in inftest2(sec), I have to shut down the primary, change the > secondary > server to standard, and change it to online mode. Is there any ways to > access > tables when engine is in “read only” mode? > > Once the inftest2(sec) is in “online” mode, I can’t promote it back to > secondary server with the command “onmode -d secondary demo_on”. I have to > do > the backup and restore over again. Is that any way to synch them up > without > backup and restore? > > [informix@inftest1 etc]$ onstat -g dri > > IBM Informix Dynamic Server Version 11.50.FC1 -- On-Line (Prim) -- Up > 00:55:07 > -- 39728 Kbytes> > Data Replication: > Type State Paired server Last DR CKPT (id/pg) Supports Proxy Writes > primary on demo_back 80 / 165 NA > > DRINTERVAL 30 > DRTIMEOUT 30 > DRAUTO 0 > DRLOSTFOUND /apps/informix/etc/dr.lostfound > DRIDXAUTO 0 > ENCRYPT_HDR 0> > [informix@inftest2 etc]$ onstat -g dri > > IBM Informix Dynamic Server Version 11.50.FC1 -- Read-Only (Sec) -- Up > 00:33:07 -- 64304 Kbytes> > Data Replication: > Type State Paired server Last DR CKPT (id/pg) Supports Proxy Writes > HDR Secondary on demo_on 80 / 165 N > > DRINTERVAL 30 > DRTIMEOUT 30 > DRAUTO 0 > DRLOSTFOUND /apps/informix/etc/dr.lostfound > DRIDXAUTO 0 > ENCRYPT_HDR 0> > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

I tried to use the onmonitor utility to check the logging of the engines, but I don’t what the issue here. They are linux servers, and I am using putty. Is there any other way to check the logging status? [informix@inftest1 etc]$ onmonitor Termcap entry too long Termcap entry too long Segmentation fault [informix@inftest1 etc]$ export TERM=vt100 [informix@inftest1 etc]$ onmonitor Termcap entry too long Too many tc= indirections Program stopped at "tb4_main.4gl", line number 71. FORMS statement error number -1170. The type of your terminal is unknown to the system. [informix@inftest1 etc]$ Sqlhosts from inftest1 demo_on onsoctcp inftest1.newpiper.net demo_on k=0 demo_shm onsoctcp inftest1.newpiper.net demo_shm k=0 demo_back onsoctcp inftest2.newpiper.net demo_on k=0 Sqlhosts from inftest2 demo_back onsoctcp inftest2.newpiper.net demo_on k=0 demo_backshm onsoctcp inftest2.newpiper.net demo_shm k=0 demo_on onsoctcp inftest1.newpiper.net demo_on k=0 onconfig from inftest1 DBSERVERNAME demo_on DBSERVERALIASES demo_shm Onconfig from inftest2 DBSERVERNAME demo_back DBSERVERALIASES demo_backshm I just do dbaccess. I have no problem to do dbaccess from inftest1 and inftest2 when the servers are in online mode. I only have problem with dbaccess when inftest2 is in “readonly” mode (after I promote it to secondary). After applying dbaccess command I selected “Query –language” - “Select database” then the error popped up. Here is the error. 329: Database not found or no system permission. 128: ISAM error: no logging

You have something VERY wrong going on. HDR replication is magical, updates, inserts, deletes all replicate in fractions of a second once the transaction is committed. That may be the problem, in DBACCESS in menu mode, when you perform any update/insert/delete, then dbaccess performs a BEGIN WORK; for you behind the scenes. If you do not COMMIT WORK; the transaction is never committed and so is not sent to the secondary servers! If you exit dbaccess without committing, then the engine will ROLLBACK WORK; automatically when the connection to the server is broken. Also, data on HDR secondaries are ALWAYS available for reading (ie SELECT), and you can set up the ONCONFIG file to make the secondary server updatable so that records updated on any updatable secondary server are updated on the primary and replicate out to all secondary servers. This works automatically and you should not have to do anything to make it happen. Something is not right with your configuration. I would suggest that you open a support case with IBM Informix Support or contact a competent Informix Consultancy for help. There are several around ;-) including Advanced DataTools Corp. among them. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, 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 Thu, Sep 2, 2010 at 3:56 PM, TRI TRINH <tri_trinh@hotmail.com> wrote: > The magic of HRD did not create magic. I tested many times by insert a > record > into the inftest1(prim) by dbaccess, but it never replicate to > inftest2(sec). > > I have another question. After I promoted inftest2 to secondary by “onmode > -d > secondary demo_on”, the engine change to Read-Only(Sec) mode. When the > engine > in “Read-Only” mode, I can’t do the dbaccess nor the ODBC. In order to > access > tables in inftest2(sec), I have to shut down the primary, change the > secondary > server to standard, and change it to online mode. Is there any ways to > access > tables when engine is in “read only” mode? > > Once the inftest2(sec) is in “online” mode, I can’t promote it back to > secondary server with the command “onmode -d secondary demo_on”. I have to > do > the backup and restore over again. Is that any way to synch them up without > backup and restore? > > [informix@inftest1 etc]$ onstat -g dri > > IBM Informix Dynamic Server Version 11.50.FC1 -- On-Line (Prim) -- Up > 00:55:07 > -- 39728 Kbytes> > Data Replication: > Type State Paired server Last DR CKPT (id/pg) Supports Proxy Writes > primary on demo_back 80 / 165 NA > > DRINTERVAL 30 > DRTIMEOUT 30 > DRAUTO 0 > DRLOSTFOUND /apps/informix/etc/dr.lostfound > DRIDXAUTO 0 > ENCRYPT_HDR 0> > [informix@inftest2 etc]$ onstat -g dri > > IBM Informix Dynamic Server Version 11.50.FC1 -- Read-Only (Sec) -- Up > 00:33:07 -- 64304 Kbytes> > Data Replication: > Type State Paired server Last DR CKPT (id/pg) Supports Proxy Writes > HDR Secondary on demo_on 80 / 165 N > > DRINTERVAL 30 > DRTIMEOUT 30 > DRAUTO 0 > DRLOSTFOUND /apps/informix/etc/dr.lostfound > DRIDXAUTO 0 > ENCRYPT_HDR 0> > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5adae13f91d048f4d254e

dbaccess sysmaster - select * from sysdatabases; Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, 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 Thu, Sep 2, 2010 at 5:00 PM, TRI TRINH <tri_trinh@hotmail.com> wrote: > I tried to use the onmonitor utility to check the logging of the engines, > but > I don’t what the issue here. They are linux servers, and I am using putty. > Is > there any other way to check the logging status? > > [informix@inftest1 etc]$ onmonitor > Termcap entry too long > Termcap entry too long > Segmentation fault > [informix@inftest1 etc]$ export TERM=vt100 > [informix@inftest1 etc]$ onmonitor > Termcap entry too long > Too many tc= indirections > > Program stopped at "tb4_main.4gl", line number 71. > FORMS statement error number -1170. > The type of your terminal is unknown to the system. > [informix@inftest1 etc]$ > > Sqlhosts from inftest1 > > demo_on onsoctcp inftest1.newpiper.net demo_on k=0 > demo_shm onsoctcp inftest1.newpiper.net demo_shm k=0 > demo_back onsoctcp inftest2.newpiper.net demo_on k=0 > > Sqlhosts from inftest2 > > demo_back onsoctcp inftest2.newpiper.net demo_on k=0 > demo_backshm onsoctcp inftest2.newpiper.net demo_shm k=0 > demo_on onsoctcp inftest1.newpiper.net demo_on k=0 > > onconfig from inftest1 > > DBSERVERNAME demo_on > DBSERVERALIASES demo_shm> > Onconfig from inftest2 > > DBSERVERNAME demo_back > DBSERVERALIASES demo_backshm> > I just do dbaccess. I have no problem to do dbaccess from inftest1 and > inftest2 when the servers are in online mode. I only have problem with > dbaccess when inftest2 is in “readonly” mode (after I promote it to > secondary). After applying dbaccess command I selected “Query –language” - > “Select database” then the error popped up. Here is the error. > > 329: Database not found or no system permission. > 128: ISAM error: no logging> > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5adae967e43048f4d359b

> 329: Database not found or no system permission. > 128: ISAM error: no logging This might indicate that the database on the secondary that you are trying to connect to does not have logging enabled. On the primary (the one you can connect to) you can database sysmaster;select name, is_logging from sysdatabases; When you created your test databases did you create them like this: create database dbname with log; or did you create them like this: create database dbname; The second create table statement will create a database without logging, which will not work with HDR. Andrew ----- Original Message ----- From: "TRI TRINH" <tri_trinh@hotmail.com> To: <ids@iiug.org> Sent: Thursday, September 02, 2010 4:00 PM Subject: Re: RE: Import restore issue [21149] >I tried to use the onmonitor utility to check the logging of the engines, >but > I don’t what the issue here. They are linux servers, and I am using putty. > Is > there any other way to check the logging status? > > [informix@inftest1 etc]$ onmonitor > Termcap entry too long > Termcap entry too long > Segmentation fault > [informix@inftest1 etc]$ export TERM=vt100 > [informix@inftest1 etc]$ onmonitor > Termcap entry too long > Too many tc= indirections > > Program stopped at "tb4_main.4gl", line number 71. > FORMS statement error number -1170. > The type of your terminal is unknown to the system. > [informix@inftest1 etc]$ > > Sqlhosts from inftest1 > > demo_on onsoctcp inftest1.newpiper.net demo_on k=0 > demo_shm onsoctcp inftest1.newpiper.net demo_shm k=0 > demo_back onsoctcp inftest2.newpiper.net demo_on k=0 > > Sqlhosts from inftest2 > > demo_back onsoctcp inftest2.newpiper.net demo_on k=0 > demo_backshm onsoctcp inftest2.newpiper.net demo_shm k=0 > demo_on onsoctcp inftest1.newpiper.net demo_on k=0 > > onconfig from inftest1 > > DBSERVERNAME demo_on > DBSERVERALIASES demo_shm> > Onconfig from inftest2 > > DBSERVERNAME demo_back > DBSERVERALIASES demo_backshm> > I just do dbaccess. I have no problem to do dbaccess from inftest1 and > inftest2 when the servers are in online mode. I only have problem with > dbaccess when inftest2 is in “readonly” mode (after I promote it to > secondary). After applying dbaccess command I selected “Query –language” - > “Select database” then the error popped up. Here is the error. > > 329: Database not found or no system permission. > 128: ISAM error: no logging> > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Dbacces from inftest1 name stores_demo partnum 1048887 owner informix created 05/26/2010 is_logging 0 is_buff_log 0 is_ansi 0 is_nls 0 flags -12288 While the inftest2 engine is in “readonly” mode. I can do dbaccess and select “sysmaster@demo_back” to check for the logging of stores_demo database (result below). But if I select the “<stores_demo@demo_back>” database, I get error below. Eventhough the stores_demo database is in logging mode, and the error said "no logging". name stores_demo partnum 1048887 owner informix created 05/26/2010 is_logging 0 is_buff_log 0 is_ansi 0 is_nls 0 flags -12288 329: Database not found or no system permission. 128: ISAM error: no logging

Is 1 is logging or 0 is logging? Can I modify the database from not logging to logging or I have to create a new database? name sysmaster is_logging 1 name sysutils is_logging 1 name sysuser is_logging 1 name sysadmin is_logging 1 name stores_demo is_logging 0

is_logging of 0 means no logging. You can change the logging mode of a database, but being a test system it would be easier to drop/recreate the stores_demo db. Andrew ----- Original Message ----- From: "TRI TRINH" <tri_trinh@hotmail.com> To: <ids@iiug.org> Sent: Thursday, September 02, 2010 4:31 PM Subject: Re: RE: Import restore issue [21154] > Is 1 is logging or 0 is logging? Can I modify the database from not > logging to > logging or I have to create a new database? > > name sysmaster > is_logging 1 > > name sysutils > is_logging 1 > > name sysuser > is_logging 1 > > name sysadmin > is_logging 1 > > name stores_demo > is_logging 0 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Got it. I will drop and recreate the database. I got your create database dbname with log;

The stores_demo database is NOT in logging mode, that's why the sysdatabases record's is_logging columns is set to zero! Non-logged databases do not replicate and you cannot access them on a secondary server, not even the data that was restored from the primary during the ontape -p run! Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, 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 Thu, Sep 2, 2010 at 5:20 PM, TRI TRINH <tri_trinh@hotmail.com> wrote: > Dbacces from inftest1 > > name stores_demo > partnum 1048887 > owner informix > created 05/26/2010 > is_logging 0 > is_buff_log 0 > is_ansi 0 > is_nls 0 > flags -12288 > > While the inftest2 engine is in “readonly” mode. I can do dbaccess and > select > “sysmaster@demo_back” to check for the logging of stores_demo database > (result > below). But if I select the “<stores_demo@demo_back>” database, I get > error > below. Eventhough the stores_demo database is in logging mode, and the > error > said "no logging". > > name stores_demo > partnum 1048887 > owner informix > created 05/26/2010 > is_logging 0 > is_buff_log 0 > is_ansi 0 > is_nls 0 > flags -12288 > > 329: Database not found or no system permission.> > 128: ISAM error: no logging> > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5a579f5ea4e048f4dbd06

You have to change the logging mode of the stores_demo database to UNBUFFERED LOG on the primary then take a new archive after the log change and restore that. You can do the log change using a "FAKE" archive: ontape -F -s -L 0 -U stores_demo ## Change the logging mode ofstores_demo database to UNBUFFERED LOG. ontape -s -L 0 ## Now take a REAL archive ofthe server and restore that to the secondary and reinitialize the secondary as you did before. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, 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 Thu, Sep 2, 2010 at 5:31 PM, TRI TRINH <tri_trinh@hotmail.com> wrote: > Is 1 is logging or 0 is logging? Can I modify the database from not logging > to > logging or I have to create a new database? > > name sysmaster > is_logging 1 > > name sysutils > is_logging 1 > > name sysuser > is_logging 1 > > name sysadmin > is_logging 1 > > name stores_demo > is_logging 0 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5a6d483d436048f4dc8af

Hi all! I just want to let you know that I got the HDR to work. I inserted a record into inftest1(prim) and it sent the record over to inftest2(sec). I have a long way to play with the setup. Thank you all and enjoy the holiday weekend. tri