Informix Logo Архив конференции ukr.comp.dbms.informix
Пред. по дате ] [ След. по дате ] [ Пред. по нити ] [ След. по нити ][ Индекс по датам ][ Индекс по нитям ]

Problem with temp table in rootdbs.

From "Andrzej K." <krakus@2com.pl>
Date Mon, 24 Jun 2002 12:46:48 +0200
Organization ATCOM ISP http://www.atcom.pl

Hi,

we have IDS 7.31.FD3 with replication server.

When I write:
CREATE TEMP TABLE tab1(field1 int) WITH NO LOG;
the table is created in tempdbs3.

But if I write:
CREATE TEMP TABLE tab2(field2 int);
the table is created in rootdbs.

I change DBSPACETEMP
DBSPACETEMP=tempdbs3
into
DBSPACETEMP=tempdbs3, dbs4

The dbspace tempdbs3 is no logged, but dbs4 is logged.
It's works fine on primary server. The table tab1 is created in tempdbs3
and table tab2 in dbs4 !!
But on replication server I have problem:

onstat -m | tail
12:51:20  Warning: Logging dbspace 'dbs4' ignored in DBSPACETEMP on DR
secondary
.
12:51:26  Warning: Logging dbspace 'dbs4' ignored in DBSPACETEMP on DR
secondary
.
12:51:28  Warning: Logging dbspace 'dbs4' ignored in DBSPACETEMP on DR
secondary
.
12:51:29  Warning: Logging dbspace 'dbs4' ignored in DBSPACETEMP on DR
secondary
.
12:51:31  Warning: Logging dbspace 'dbs4' ignored in DBSPACETEMP on DR
secondary
.
12:51:33  Warning: Logging dbspace 'dbs4' ignored in DBSPACETEMP on DR
secondary
.
12:51:37  Warning: Logging dbspace 'dbs4' ignored in DBSPACETEMP on DR
secondary
.
12:51:38  Warning: Logging dbspace 'dbs4' ignored in DBSPACETEMP on DR
secondary
.
12:51:39  Warning: Logging dbspace 'dbs4' ignored in DBSPACETEMP on DR
secondary
.
12:51:41  Warning: Logging dbspace 'dbs4' ignored in DBSPACETEMP on DR
secondary
.
12:51:49  Warning: Logging dbspace 'dbs4' ignored in DBSPACETEMP on DR
secondary
.

Any idea?
TIA
Andrzej Kurowski






Украинская баннерная сеть
Home ] Hosted by No-MORE