 |
Архив конференции 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
Украинская баннерная сеть