Server Secondary
The poster asked whether temporary tables can be created on the secondary server in an Informix HDR (High-Availability Data Replication) pair. Answer: yes, but only non-logged ones — the tables must be created explicitly WITH NO LOG (e.g. CREATE TEMP TABLE ... WITH NO LOG, or SELECT ... INTO TEMP ... WITH NO LOG), and temporary dbspaces must be configured. Since the secondary is read-only, any operation requiring logging is prohibited. The poster confirmed this answered his question.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi all: In an architecture Informix HDR it is possible to create temporary tables in the secondary server ???? Thanks _________________________________________________________________ MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/
only if they are non-logged tables. = "Juan Pablo" = <in4mixperu@hotma = il.com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect Server Secondary [9456] = 06/27/2007 10:28 = AM = = = Please respond to = ids@iiug.org = = = Hi all: In an architecture Informix HDR it is possible to create temporary tabl= es in the secondary server ???? Thanks _________________________________________________________________ MSN Amor: busca tu =BD naranja http://latam.msn.com/amor/ ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
Hola Pablo
Si podes crear tablas temporales lo único que debes agregar es en la sentencia
"with no log"
Create temp table aaa
(campo 1 char(10)) with no log;
o
Select * from table1
into temp table auxiliar with no log;
Saludos Mauricio Rapari
-----Mensaje original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]En nombre de Juan
Pablo
Enviado el: Miércoles, 27 de Junio de 2007 12:29 p.m.
Para: ids@iiug.org
Asunto: Server Secondary [9456]
Hi all:
In an architecture Informix HDR it is possible to create temporary tables in
the secondary server ????
Thanks
_________________________________________________________________
MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Hi, The answer is yes, but only if the temp tables are created WITH NO LOG; That means you have to have explicitly created temp dbspaces, and you have to explicitly create the temp tables to not be logged. You can only do things on the secondary that do not require any logging. Any logged action is prohibited. Cheers, Dick Snoke Executive IT Specialist IBM Software Group - ChannelWorks dsnoke@us.ibm.com (404) 487-1595 "Juan Pablo" <in4mixperu@hotmail.com> Sent by: ids-bounces@iiug.org 06/27/2007 11:28 AM Please respond to ids@iiug.org To ids@iiug.org cc Subject Server Secondary [9456] Hi all: In an architecture Informix HDR it is possible to create temporary tables in the secondary server ???? Thanks _________________________________________________________________ MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/ ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Clarisimo Mauricio.... muchas gracias por la atencion.
Saludos
>From: "Mauricio Rapari" <mrapari@aguasbonaerenses.com.ar>
>Reply-To: ids@iiug.org
>To: ids@iiug.org
>Subject: RE: Server Secondary [9458]
>Date: Wed, 27 Jun 2007 12:54:42 -0400 (EDT)
>
>Hola Pablo
>Si podes crear tablas temporales lo único que debes agregar es en la
>sentencia
>"with no log"
>
>Create temp table aaa
>(campo 1 char(10)) with no log;>
>o
>
>Select * from table1
>into temp table auxiliar with no log;>
>Saludos Mauricio Rapari
>
>-----Mensaje original-----
>De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]En nombre de Juan
>Pablo
>Enviado el: Miércoles, 27 de Junio de 2007 12:29 p.m.
>Para: ids@iiug.org
>Asunto: Server Secondary [9456]
>
>Hi all:
>In an architecture Informix HDR it is possible to create temporary tables
>in
>the secondary server ????
>
>Thanks
>
>_________________________________________________________________
>MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/
>
>
>*******************************************************************************
>Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
_________________________________________________________________
MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/
Thanks Richard and thanks all's bye >From: "Richard Snoke" <dsnoke@us.ibm.com> >Reply-To: ids@iiug.org >To: ids@iiug.org >Subject: Re: Server Secondary [9459] >Date: Wed, 27 Jun 2007 13:09:51 -0400 (EDT) > >Hi, > >The answer is yes, but only if the temp tables are created WITH NO LOG; >That means you have to have explicitly created temp dbspaces, and you have >to explicitly create the temp tables to not be logged. You can only do >things on the secondary that do not require any logging. Any logged >action is prohibited. > >Cheers, >Dick Snoke >Executive IT Specialist >IBM Software Group - ChannelWorks >dsnoke@us.ibm.com >(404) 487-1595 > >"Juan Pablo" <in4mixperu@hotmail.com> >Sent by: ids-bounces@iiug.org >06/27/2007 11:28 AM >Please respond to >ids@iiug.org > >To >ids@iiug.org >cc > >Subject >Server Secondary [9456] > >Hi all: >In an architecture Informix HDR it is possible to create temporary tables >in >the secondary server ???? > >Thanks > >_________________________________________________________________ >MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/ > > >******************************************************************************* > >Forum Note: Use "Reply" to post a response in the discussion forum. > > >******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/