|
Below is the latest content available from this feed:
Re: MEDIAN function
Posted by: art.kagel@gmail.com (Art Kagel) - Fri, 03 Sep 2010 06:47:47 EDT
No median function. But the SQL for a median isn't hard:
create table valtest( value int ); insert into valtest values( 1 ); insert into valtest values( 1 ); insert into valtest values( 2 ); insert into valtest values( 2 ); insert into valtest values( 2 ); insert into valtest values( 2 ); insert into valtest values( 2 ); insert into valtest values( 3 ); insert into valtest values( 4 ); insert into valtest values( 4 ); insert into valtest values( 5 ); insert into valtest values( 5 );
select first 1 t.value from valtest t, (
select first 1 value, count(*) from valtest group by 1 order by 2 desc) as m where t.value = m.value;
value
2
1 row(s) retrieved.
Or using temp table: > select value, count(*) med from valtest group by 1 into temp vt;
5 row(s) retrieved into temp table.
> select first 1 t.value > from valtest t, vt m > where t.value = m.value > and m.med = (select max(med) from vt);
value
2
1 row(s) retrieved.
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 11:36 PM, Walter Lowich <walterlowich@yahoo.com>wrote:
> Does Informix have a function to compute the median value for a given > column > or columns ? If so, how does it operate ? If not, has anyone written such a > function ? > > Thanks. > > Walt Lowich > > > > > > >
--0016368e1b8a880fc7048f58a8bc
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org 2. Include the bracketed message number in the subject line: [21162]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
MEDIAN function
Posted by: walterlowich@yahoo.com (Walter Lowich) - Thu, 02 Sep 2010 23:36:12 EDT
Does Informix have a function to compute the median value for a given column or columns ? If so, how does it operate ? If not, has anyone written such a function ?
Thanks.
Walt Lowich
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org 2. Include the bracketed message number in the subject line: [21161]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
functional index - create with parallel sort
Posted by: cesar_inacio_martins@yahoo.com.br (Cesar Inacio Martins) - Thu, 02 Sep 2010 21:50:46 EDT
Hi,
IDS 11.50 FC7
If a table have a functional Index, and the table don't have fragmentation, but the PSORT_NPROCS is set with value > 1 (or PDQ >1), the index is created by only one and single thread. Why this creation don't run with more sort threads in parallel? Once the functions are "NOT VARIANT" , I don't see why not...
There is some reason , what I don't see ?
Cesar
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org 2. Include the bracketed message number in the subject line: [21160]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: What does "Dirty Read Last Committed" mean?
Posted by: xieyexieye@gmail.com (STEPHEN XIE) - Thu, 02 Sep 2010 21:29:26 EDT
Uday Kale, thank you very much!
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org 2. Include the bracketed message number in the subject line: [21159]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: RE: Import restore issue
Posted by: art.kagel@gmail.com (Art Kagel) - Thu, 02 Sep 2010 17:49:25 EDT
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 of stores_demo database to UNBUFFERED LOG. ontape -s -L 0 ## Now take a REAL archive of the 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 > > > > > > >
--001636c5a6d483d436048f4dc8af
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org 2. Include the bracketed message number in the subject line: [21158]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: RE: Import restore issue
Posted by: art.kagel@gmail.com (Art Kagel) - Thu, 02 Sep 2010 17:46:36 EDT
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 > > > > > > >
--001636c5a579f5ea4e048f4dbd06
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org 2. Include the bracketed message number in the subject line: [21157]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: RE: Import restore issue
Posted by: tri_trinh@hotmail.com (TRI TRINH) - Thu, 02 Sep 2010 17:43:51 EDT
Got it. I will drop and recreate the database. I got your
create database dbname with log;
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org 2. Include the bracketed message number in the subject line: [21156]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: RE: Import restore issue
Posted by: aford@networkip.net (Andrew Ford) - Thu, 02 Sep 2010 17:40:13 EDT
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 > > > > >
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org 2. Include the bracketed message number in the subject line: [21155]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: RE: Import restore issue
Posted by: tri_trinh@hotmail.com (TRI TRINH) - Thu, 02 Sep 2010 17:31:52 EDT
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
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org 2. Include the bracketed message number in the subject line: [21154]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: RE: Import restore issue
Posted by: tri_trinh@hotmail.com (TRI TRINH) - Thu, 02 Sep 2010 17:20:58 EDT
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
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org 2. Include the bracketed message number in the subject line: [21153]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: RE: Import restore issue
Posted by: aford@networkip.net (Andrew Ford) - Thu, 02 Sep 2010 17:12:20 EDT
> 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 > > > > >
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org 2. Include the bracketed message number in the subject line: [21152]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: RE: Import restore issue
Posted by: art.kagel@gmail.com (Art Kagel) - Thu, 02 Sep 2010 17:08:44 EDT
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 > > > > > > >
--001636c5adae967e43048f4d359b
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org 2. Include the bracketed message number in the subject line: [21151]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: RE: Import restore issue
Posted by: art.kagel@gmail.com (Art Kagel) - Thu, 02 Sep 2010 17:04:01 EDT
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 > > > > > > >
--001636c5adae13f91d048f4d254e
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org 2. Include the bracketed message number in the subject line: [21150]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: RE: Import restore issue
Posted by: tri_trinh@hotmail.com (TRI TRINH) - Thu, 02 Sep 2010 17:00:37 EDT
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
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org 2. Include the bracketed message number in the subject line: [21149]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
RE: ontape restore issue
Posted by: wyzaj@bethelcollege.edu (Wyza, Jonathon) - Thu, 02 Sep 2010 16:58:15 EDT
I couldn't get it to go online. If I told it to go to single user mode it said it had to be in quiesscient mode, if I tried to tell it to go online it said it had to be in single user mode or quisscient mode.
Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcollege.edu ============================== SLES 11x64 & IDS 11.50.FC6
"Don't document the problem, fix it." - Atli Björgvin Oddsson
-----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Andrew Ford Sent: Thursday, September 02, 2010 4:51 PM To: ids@iiug.org Subject: Re: ontape restore issue [21146]
After the restore, when the DR server is in fast recovery, do you bring it online? Or are you shutting it down and restarting?
Andrew
----- Original Message ----- From: "Wyza, Jonathon" <wyzaj@bethelcollege.edu> To: <ids@iiug.org> Sent: Thursday, September 02, 2010 3:40 PM Subject: ontape restore issue [21144]
> So I set up a secondary box that will eventually our DR server. I > created a duplicate chunk layout and then used an ontape pipe over ssh > to do a recovery, but now I get the following when I attempt to start > the server up: > > 16:34:19 IBM Informix Dynamic Server Started. > 16:34:19 Segment locked: addr=0x44000000, size=269832192 > > Thu Sep 2 16:34:20 2010 > > 16:34:20 Warning: pid 13450: cannot load NULL library name at address > 0x488ff000 > 16:34:20 Event alarms enabled. ALARMPROG = > '/opt/informix/etc/alarmprogram.sh' > 16:34:20 Booting Language <c> from module <> > 16:34:20 Loading Module <CNULL> > 16:34:20 Booting Language <builtin> from module <> > 16:34:20 Loading Module <BUILTINNULL> > 16:34:26 DR: DRAUTO is 0 (Off) > 16:34:26 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) > 16:34:26 Event notification facility epoll enabled. > 16:34:26 IBM Informix Dynamic Server Version 11.50.FC6 Software Serial > Number > AAA#B000000 > 16:34:27 Assert Warning: chunk failed sanity check > > 16:34:27 IBM Informix Dynamic Server Version 11.50.FC6 > 16:34:27 Who: Session(1, informix@cxtrain, 0, 0x54d4b028) > > Thread(8, main_loop(), 54d08028, 1) > > File: rspartn.c Line: 9368 > 16:34:27 Results: Chunk 2 is being taken OFFLINE. > 16:34:27 Action: If this chunk is the only one in the temporary > dbspace, drop and re-create > > the temporary dbspace. Otherwise, drop and re-create the chunk. > 16:34:27 stack trace for pid 13450 written to > /opt/informix/tmp/af.3f00a53 > 16:34:27 See Also: /opt/informix/tmp/af.3f00a53 > 16:34:27 chunk failed sanity check > > 16:34:28 I/O error, Primary Chunk '/opt/informix/dev/dbstemp' -- > Offline > (sanity) > 16:34:28 IBM Informix Dynamic Server Initialized -- Shared Memory > Initialized. > > 16:34:28 Warning: Invalid (non-existent/blobspace/disabled) dbspace > listed > > in DBSPACETEMP: 'dbstemp' > 16:34:28 Physical Recovery Started at Page (1:261738). > 16:34:28 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored. > 16:34:28 Logical Recovery Started. > 16:34:28 10 recovery worker threads will be started. > 16:34:29 Logical Recovery has reached the transaction cleanup phase. > 16:34:29 Logical Recovery Complete. > > 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks > > 16:34:30 oninit: Fatal error in shared memory initialization > > 16:34:30 IBM Informix Dynamic Server Stopped. > > Also here is the layout of devices on live vs new dr: > LIVE: > > brw-rw---- 1 informix informix 253, 101 Sep 2 16:31 dbs1.1 > brw-rw---- 1 informix informix 253, 111 Sep 2 16:31 dbs1.1m > brw-rw---- 1 informix informix 253, 102 Jun 14 18:42 dbs1.2 > brw-rw---- 1 informix informix 253, 112 Jun 14 18:42 dbs1.2m > brw-rw---- 1 informix informix 253, 100 Sep 2 16:35 dbsroot1.1 > brw-rw---- 1 informix informix 253, 110 Sep 2 16:35 dbsroot1.1m > brw-rw---- 1 informix informix 253, 103 Sep 2 16:31 dbstemp > > DR: > > brw-rw---- 1 informix informix 253, 101 2010-09-02 16:27 dbs1.1 > brw-rw---- 1 informix informix 253, 111 2010-09-02 16:27 dbs1.1m > brw-rw---- 1 informix informix 253, 102 2010-09-02 16:27 dbs1.2 > brw-rw---- 1 informix informix 253, 112 2010-09-02 16:27 dbs1.2m > brw-rw---- 1 informix informix 253, 100 2010-09-02 16:28 dbsroot1.1 > brw-rw---- 1 informix informix 253, 110 2010-09-02 16:28 dbsroot1.1m > brw-rw---- 1 informix informix 253, 103 2010-09-01 16:34 dbstemp > > the chunks point to raw logical volumes of exactly identical sizes. > > Jonathon Wyza > CX & CBORD System Administrator > CX Programmer/Analyst > Administrative Computing > Bethel College > (574)-257-3381 > AIM: Iamwyza > jonathon.wyza@bethelcollege.edu<mailto:jonathon.wyza@bethelcollege.edu> > ============================== > SLES 11x64 & IDS 11.50.FC6 > > "Don't document the problem, fix it." > - Atli Björgvin Oddsson > > >
> >
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org 2. Include the bracketed message number in the subject line: [21148]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
RE: ontape restore issue
Posted by: wyzaj@bethelcollege.edu (Wyza, Jonathon) - Thu, 02 Sep 2010 16:57:10 EDT
I'll try that.
> Then you can go back and replay logical logs next.
How do you do that?
Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcollege.edu ============================== SLES 11x64 & IDS 11.50.FC6
"Don't document the problem, fix it." - Atli Björgvin Oddsson
-----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Jonathan Smaby Sent: Thursday, September 02, 2010 4:51 PM To: ids@iiug.org Subject: RE: ontape restore issue [21145]
Jonathon,
Restore to pipe-session has never worked for me. I ontape -s -L 0 to file on an NFS shared mount point.
To restore try:
# ontape -r -p
For a physical restore. Then you can go back and replay logical logs next.
HTH
--- Jonathan Smaby Pomona College
-----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Wyza, Jonathon Sent: Thursday, September 02, 2010 1:40 PM To: ids@iiug.org Subject: ontape restore issue [21144]
So I set up a secondary box that will eventually our DR server. I created a duplicate chunk layout and then used an ontape pipe over ssh to do a recovery, but now I get the following when I attempt to start the server up:
16:34:19 IBM Informix Dynamic Server Started. 16:34:19 Segment locked: addr=0x44000000, size=269832192
Thu Sep 2 16:34:20 2010
16:34:20 Warning: pid 13450: cannot load NULL library name at address 0x488ff000 16:34:20 Event alarms enabled. ALARMPROG = '/opt/informix/etc/alarmprogram.sh' 16:34:20 Booting Language <c> from module <> 16:34:20 Loading Module <CNULL> 16:34:20 Booting Language <builtin> from module <> 16:34:20 Loading Module <BUILTINNULL> 16:34:26 DR: DRAUTO is 0 (Off) 16:34:26 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) 16:34:26 Event notification facility epoll enabled. 16:34:26 IBM Informix Dynamic Server Version 11.50.FC6 Software Serial Number AAA#B000000 16:34:27 Assert Warning: chunk failed sanity check
16:34:27 IBM Informix Dynamic Server Version 11.50.FC6 16:34:27 Who: Session(1, informix@cxtrain, 0, 0x54d4b028)
Thread(8, main_loop(), 54d08028, 1)
File: rspartn.c Line: 9368 16:34:27 Results: Chunk 2 is being taken OFFLINE. 16:34:27 Action: If this chunk is the only one in the temporary dbspace, drop and re-create
the temporary dbspace. Otherwise, drop and re-create the chunk. 16:34:27 stack trace for pid 13450 written to /opt/informix/tmp/af.3f00a53 16:34:27 See Also: /opt/informix/tmp/af.3f00a53 16:34:27 chunk failed sanity check
16:34:28 I/O error, Primary Chunk '/opt/informix/dev/dbstemp' -- Offline (sanity) 16:34:28 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
16:34:28 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
in DBSPACETEMP: 'dbstemp' 16:34:28 Physical Recovery Started at Page (1:261738). 16:34:28 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored. 16:34:28 Logical Recovery Started. 16:34:28 10 recovery worker threads will be started. 16:34:29 Logical Recovery has reached the transaction cleanup phase. 16:34:29 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
16:34:30 oninit: Fatal error in shared memory initialization
16:34:30 IBM Informix Dynamic Server Stopped.
Also here is the layout of devices on live vs new dr: LIVE:
brw-rw---- 1 informix informix 253, 101 Sep 2 16:31 dbs1.1 brw-rw---- 1 informix informix 253, 111 Sep 2 16:31 dbs1.1m brw-rw---- 1 informix informix 253, 102 Jun 14 18:42 dbs1.2 brw-rw---- 1 informix informix 253, 112 Jun 14 18:42 dbs1.2m brw-rw---- 1 informix informix 253, 100 Sep 2 16:35 dbsroot1.1 brw-rw---- 1 informix informix 253, 110 Sep 2 16:35 dbsroot1.1m brw-rw---- 1 informix informix 253, 103 Sep 2 16:31 dbstemp
DR:
brw-rw---- 1 informix informix 253, 101 2010-09-02 16:27 dbs1.1 brw-rw---- 1 informix informix 253, 111 2010-09-02 16:27 dbs1.1m brw-rw---- 1 informix informix 253, 102 2010-09-02 16:27 dbs1.2 brw-rw---- 1 informix informix 253, 112 2010-09-02 16:27 dbs1.2m brw-rw---- 1 informix informix 253, 100 2010-09-02 16:28 dbsroot1.1 brw-rw---- 1 informix informix 253, 110 2010-09-02 16:28 dbsroot1.1m brw-rw---- 1 informix informix 253, 103 2010-09-01 16:34 dbstemp
the chunks point to raw logical volumes of exactly identical sizes.
Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcollege.edu<mailto:jonathon.wyza@bethelcollege.edu> ============================== SLES 11x64 & IDS 11.50.FC6
"Don't document the problem, fix it." - Atli Björgvin Oddsson
------------------------------------------------------------- This message has been scanned by Postini anti-virus software.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org 2. Include the bracketed message number in the subject line: [21147]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: ontape restore issue
Posted by: aford@networkip.net (Andrew Ford) - Thu, 02 Sep 2010 16:51:54 EDT
After the restore, when the DR server is in fast recovery, do you bring it online? Or are you shutting it down and restarting?
Andrew
----- Original Message ----- From: "Wyza, Jonathon" <wyzaj@bethelcollege.edu> To: <ids@iiug.org> Sent: Thursday, September 02, 2010 3:40 PM Subject: ontape restore issue [21144]
> So I set up a secondary box that will eventually our DR server. I created > a > duplicate chunk layout and then used an ontape pipe over ssh to do a > recovery, > but now I get the following when I attempt to start the server up: > > 16:34:19 IBM Informix Dynamic Server Started. > 16:34:19 Segment locked: addr=0x44000000, size=269832192 > > Thu Sep 2 16:34:20 2010 > > 16:34:20 Warning: pid 13450: cannot load NULL library name at address > 0x488ff000 > 16:34:20 Event alarms enabled. ALARMPROG = > '/opt/informix/etc/alarmprogram.sh' > 16:34:20 Booting Language <c> from module <> > 16:34:20 Loading Module <CNULL> > 16:34:20 Booting Language <builtin> from module <> > 16:34:20 Loading Module <BUILTINNULL> > 16:34:26 DR: DRAUTO is 0 (Off) > 16:34:26 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) > 16:34:26 Event notification facility epoll enabled. > 16:34:26 IBM Informix Dynamic Server Version 11.50.FC6 Software Serial > Number > AAA#B000000 > 16:34:27 Assert Warning: chunk failed sanity check > > 16:34:27 IBM Informix Dynamic Server Version 11.50.FC6 > 16:34:27 Who: Session(1, informix@cxtrain, 0, 0x54d4b028) > > Thread(8, main_loop(), 54d08028, 1) > > File: rspartn.c Line: 9368 > 16:34:27 Results: Chunk 2 is being taken OFFLINE. > 16:34:27 Action: If this chunk is the only one in the temporary dbspace, > drop > and re-create > > the temporary dbspace. Otherwise, drop and re-create the chunk. > 16:34:27 stack trace for pid 13450 written to /opt/informix/tmp/af.3f00a53 > 16:34:27 See Also: /opt/informix/tmp/af.3f00a53 > 16:34:27 chunk failed sanity check > > 16:34:28 I/O error, Primary Chunk '/opt/informix/dev/dbstemp' -- Offline > (sanity) > 16:34:28 IBM Informix Dynamic Server Initialized -- Shared Memory > Initialized. > > 16:34:28 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed > > in DBSPACETEMP: 'dbstemp' > 16:34:28 Physical Recovery Started at Page (1:261738). > 16:34:28 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored. > 16:34:28 Logical Recovery Started. > 16:34:28 10 recovery worker threads will be started. > 16:34:29 Logical Recovery has reached the transaction cleanup phase. > 16:34:29 Logical Recovery Complete. > > 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks > > 16:34:30 oninit: Fatal error in shared memory initialization > > 16:34:30 IBM Informix Dynamic Server Stopped. > > Also here is the layout of devices on live vs new dr: > LIVE: > > brw-rw---- 1 informix informix 253, 101 Sep 2 16:31 dbs1.1 > brw-rw---- 1 informix informix 253, 111 Sep 2 16:31 dbs1.1m > brw-rw---- 1 informix informix 253, 102 Jun 14 18:42 dbs1.2 > brw-rw---- 1 informix informix 253, 112 Jun 14 18:42 dbs1.2m > brw-rw---- 1 informix informix 253, 100 Sep 2 16:35 dbsroot1.1 > brw-rw---- 1 informix informix 253, 110 Sep 2 16:35 dbsroot1.1m > brw-rw---- 1 informix informix 253, 103 Sep 2 16:31 dbstemp > > DR: > > brw-rw---- 1 informix informix 253, 101 2010-09-02 16:27 dbs1.1 > brw-rw---- 1 informix informix 253, 111 2010-09-02 16:27 dbs1.1m > brw-rw---- 1 informix informix 253, 102 2010-09-02 16:27 dbs1.2 > brw-rw---- 1 informix informix 253, 112 2010-09-02 16:27 dbs1.2m > brw-rw---- 1 informix informix 253, 100 2010-09-02 16:28 dbsroot1.1 > brw-rw---- 1 informix informix 253, 110 2010-09-02 16:28 dbsroot1.1m > brw-rw---- 1 informix informix 253, 103 2010-09-01 16:34 dbstemp > > the chunks point to raw logical volumes of exactly identical sizes. > > Jonathon Wyza > CX & CBORD System Administrator > CX Programmer/Analyst > Administrative Computing > Bethel College > (574)-257-3381 > AIM: Iamwyza > jonathon.wyza@bethelcollege.edu<mailto:jonathon.wyza@bethelcollege.edu> > ============================== > SLES 11x64 & IDS 11.50.FC6 > > "Don't document the problem, fix it." > - Atli Björgvin Oddsson > > > > >
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org 2. Include the bracketed message number in the subject line: [21146]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
RE: ontape restore issue
Posted by: Jonathan.Smaby@pomona.edu (Jonathan Smaby) - Thu, 02 Sep 2010 16:51:13 EDT
Jonathon,
Restore to pipe-session has never worked for me. I ontape -s -L 0 to file on an NFS shared mount point.
To restore try:
# ontape -r -p
For a physical restore. Then you can go back and replay logical logs next.
HTH
--- Jonathan Smaby Pomona College
-----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Wyza, Jonathon Sent: Thursday, September 02, 2010 1:40 PM To: ids@iiug.org Subject: ontape restore issue [21144]
So I set up a secondary box that will eventually our DR server. I created a duplicate chunk layout and then used an ontape pipe over ssh to do a recovery, but now I get the following when I attempt to start the server up:
16:34:19 IBM Informix Dynamic Server Started. 16:34:19 Segment locked: addr=0x44000000, size=269832192
Thu Sep 2 16:34:20 2010
16:34:20 Warning: pid 13450: cannot load NULL library name at address 0x488ff000 16:34:20 Event alarms enabled. ALARMPROG = '/opt/informix/etc/alarmprogram.sh' 16:34:20 Booting Language <c> from module <> 16:34:20 Loading Module <CNULL> 16:34:20 Booting Language <builtin> from module <> 16:34:20 Loading Module <BUILTINNULL> 16:34:26 DR: DRAUTO is 0 (Off) 16:34:26 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) 16:34:26 Event notification facility epoll enabled. 16:34:26 IBM Informix Dynamic Server Version 11.50.FC6 Software Serial Number AAA#B000000 16:34:27 Assert Warning: chunk failed sanity check
16:34:27 IBM Informix Dynamic Server Version 11.50.FC6 16:34:27 Who: Session(1, informix@cxtrain, 0, 0x54d4b028)
Thread(8, main_loop(), 54d08028, 1)
File: rspartn.c Line: 9368 16:34:27 Results: Chunk 2 is being taken OFFLINE. 16:34:27 Action: If this chunk is the only one in the temporary dbspace, drop and re-create
the temporary dbspace. Otherwise, drop and re-create the chunk. 16:34:27 stack trace for pid 13450 written to /opt/informix/tmp/af.3f00a53 16:34:27 See Also: /opt/informix/tmp/af.3f00a53 16:34:27 chunk failed sanity check
16:34:28 I/O error, Primary Chunk '/opt/informix/dev/dbstemp' -- Offline (sanity) 16:34:28 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
16:34:28 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
in DBSPACETEMP: 'dbstemp' 16:34:28 Physical Recovery Started at Page (1:261738). 16:34:28 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored. 16:34:28 Logical Recovery Started. 16:34:28 10 recovery worker threads will be started. 16:34:29 Logical Recovery has reached the transaction cleanup phase. 16:34:29 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
16:34:30 oninit: Fatal error in shared memory initialization
16:34:30 IBM Informix Dynamic Server Stopped.
Also here is the layout of devices on live vs new dr: LIVE:
brw-rw---- 1 informix informix 253, 101 Sep 2 16:31 dbs1.1 brw-rw---- 1 informix informix 253, 111 Sep 2 16:31 dbs1.1m brw-rw---- 1 informix informix 253, 102 Jun 14 18:42 dbs1.2 brw-rw---- 1 informix informix 253, 112 Jun 14 18:42 dbs1.2m brw-rw---- 1 informix informix 253, 100 Sep 2 16:35 dbsroot1.1 brw-rw---- 1 informix informix 253, 110 Sep 2 16:35 dbsroot1.1m brw-rw---- 1 informix informix 253, 103 Sep 2 16:31 dbstemp
DR:
brw-rw---- 1 informix informix 253, 101 2010-09-02 16:27 dbs1.1 brw-rw---- 1 informix informix 253, 111 2010-09-02 16:27 dbs1.1m brw-rw---- 1 informix informix 253, 102 2010-09-02 16:27 dbs1.2 brw-rw---- 1 informix informix 253, 112 2010-09-02 16:27 dbs1.2m brw-rw---- 1 informix informix 253, 100 2010-09-02 16:28 dbsroot1.1 brw-rw---- 1 informix informix 253, 110 2010-09-02 16:28 dbsroot1.1m brw-rw---- 1 informix informix 253, 103 2010-09-01 16:34 dbstemp
the chunks point to raw logical volumes of exactly identical sizes.
Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcollege.edu<mailto:jonathon.wyza@bethelcollege.edu> ============================== SLES 11x64 & IDS 11.50.FC6
"Don't document the problem, fix it." - Atli Björgvin Oddsson
------------------------------------------------------------- This message has been scanned by Postini anti-virus software.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org 2. Include the bracketed message number in the subject line: [21145]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
ontape restore issue
Posted by: wyzaj@bethelcollege.edu (Wyza, Jonathon) - Thu, 02 Sep 2010 16:40:45 EDT
So I set up a secondary box that will eventually our DR server. I created a duplicate chunk layout and then used an ontape pipe over ssh to do a recovery, but now I get the following when I attempt to start the server up:
16:34:19 IBM Informix Dynamic Server Started. 16:34:19 Segment locked: addr=0x44000000, size=269832192
Thu Sep 2 16:34:20 2010
16:34:20 Warning: pid 13450: cannot load NULL library name at address 0x488ff000 16:34:20 Event alarms enabled. ALARMPROG = '/opt/informix/etc/alarmprogram.sh' 16:34:20 Booting Language <c> from module <> 16:34:20 Loading Module <CNULL> 16:34:20 Booting Language <builtin> from module <> 16:34:20 Loading Module <BUILTINNULL> 16:34:26 DR: DRAUTO is 0 (Off) 16:34:26 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled) 16:34:26 Event notification facility epoll enabled. 16:34:26 IBM Informix Dynamic Server Version 11.50.FC6 Software Serial Number AAA#B000000 16:34:27 Assert Warning: chunk failed sanity check
16:34:27 IBM Informix Dynamic Server Version 11.50.FC6 16:34:27 Who: Session(1, informix@cxtrain, 0, 0x54d4b028)
Thread(8, main_loop(), 54d08028, 1)
File: rspartn.c Line: 9368 16:34:27 Results: Chunk 2 is being taken OFFLINE. 16:34:27 Action: If this chunk is the only one in the temporary dbspace, drop and re-create
the temporary dbspace. Otherwise, drop and re-create the chunk. 16:34:27 stack trace for pid 13450 written to /opt/informix/tmp/af.3f00a53 16:34:27 See Also: /opt/informix/tmp/af.3f00a53 16:34:27 chunk failed sanity check
16:34:28 I/O error, Primary Chunk '/opt/informix/dev/dbstemp' -- Offline (sanity) 16:34:28 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
16:34:28 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
in DBSPACETEMP: 'dbstemp' 16:34:28 Physical Recovery Started at Page (1:261738). 16:34:28 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored. 16:34:28 Logical Recovery Started. 16:34:28 10 recovery worker threads will be started. 16:34:29 Logical Recovery has reached the transaction cleanup phase. 16:34:29 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
16:34:30 oninit: Fatal error in shared memory initialization
16:34:30 IBM Informix Dynamic Server Stopped.
Also here is the layout of devices on live vs new dr: LIVE:
brw-rw---- 1 informix informix 253, 101 Sep 2 16:31 dbs1.1 brw-rw---- 1 informix informix 253, 111 Sep 2 16:31 dbs1.1m brw-rw---- 1 informix informix 253, 102 Jun 14 18:42 dbs1.2 brw-rw---- 1 informix informix 253, 112 Jun 14 18:42 dbs1.2m brw-rw---- 1 informix informix 253, 100 Sep 2 16:35 dbsroot1.1 brw-rw---- 1 informix informix 253, 110 Sep 2 16:35 dbsroot1.1m brw-rw---- 1 informix informix 253, 103 Sep 2 16:31 dbstemp
DR:
brw-rw---- 1 informix informix 253, 101 2010-09-02 16:27 dbs1.1 brw-rw---- 1 informix informix 253, 111 2010-09-02 16:27 dbs1.1m brw-rw---- 1 informix informix 253, 102 2010-09-02 16:27 dbs1.2 brw-rw---- 1 informix informix 253, 112 2010-09-02 16:27 dbs1.2m brw-rw---- 1 informix informix 253, 100 2010-09-02 16:28 dbsroot1.1 brw-rw---- 1 informix informix 253, 110 2010-09-02 16:28 dbsroot1.1m brw-rw---- 1 informix informix 253, 103 2010-09-01 16:34 dbstemp
the chunks point to raw logical volumes of exactly identical sizes.
Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcollege.edu<mailto:jonathon.wyza@bethelcollege.edu> ============================== SLES 11x64 & IDS 11.50.FC6
"Don't document the problem, fix it." - Atli Björgvin Oddsson
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org 2. Include the bracketed message number in the subject line: [21144]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: RE: Import restore issue
Posted by: aford@networkip.net (Andrew Ford) - Thu, 02 Sep 2010 16:27:11 EDT
> 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 > > > > >
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org 2. Include the bracketed message number in the subject line: [21143]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
> 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 > > > > >
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to ids@iiug.org 2. Include the bracketed message number in the subject line: [21143]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
|
|
|
Subscribe to this feed
|
| You can subscribe to this RSS feed in a number of ways, including the following:
Drag the orange RSS button into your News Reader
Drag the URL of the RSS feed into your News Reader
Cut and paste the URL of the RSS feed into your News Reader
>v
|
|