RSS Feed: IDS Forum: IDS

The IDS Forum is a discussion forum to communicate about all aspects of the Informix Dynamic Server (IDS) Engine

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]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *