RE: Simple HDR question

So even if I try, Informix won't allow me, right ? -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Fernando Nunes Sent: Wednesday, February 04, 2004 12:16 PM To: informix-list@iiug.org Subject: Re: Simple HDR question Dirk Moolman wrote: > This is a multi-part message in MIME format. ... but it shouldn't be... > Does the replicant (secondary) of an HDR system allow updates ? No. You can't do INSERT, UPDATES, DELETES or temp tables with logging. In other words... "read only" Regards. ________________________________ << ella for Spam Control >> has removed 1115 Spam messages and set aside 201 Newsletters for me You can use it too - and it's FREE! www.ellaforspam.com sending to informix-list

Dirk Moolman wrote: > So even if I try, Informix won't allow me, right ? Yep: -140 ISAM error: operation illegal on a DR secondary. A DR secondary server is meant for read-only operations. Any kind of write operation to a nontemporary dbspace is not allowed. For example, you cannot create a table in a regular dbspace, and you cannot do an insert, update, or delete operation on a table in a regular dbspace. Review your application logic and rewrite it to remove any operations that would write to a nontemporary dbspace. Normally you'll see this. Regards

>> > Does the replicant (secondary) of an HDR system allow updates ? > > > > No. You can't do INSERT, UPDATES, DELETES or temp tables with logging. > > In other words... "read only" > > So even if I try, Informix won't allow me, right ? > > > That is correct - for example: 140: ISAM error: operation illegal on a DR Secondary Hal Maner M Systems International, Inc. www.msystemsintl.com