alter statement in HDR scenerio
Sunita Raina asked whether ALTER TABLE to row-level locking must be run on both servers of an HDR pair. Ajay Gupta and Vamshi Krishna Maram said only the primary, as changes are replicated. Nilesh Bhavsar added the secondary is read-only and receives changes via logical logs. Marcus Haarmann noted DDL replicates fine but the primary may hold locks until the secondary applies it, causing an error on an immediate ALTER after CREATE TABLE.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi, I need to know if intance A (primary)is replicating to instance b (secondary) on two different boxes, do I need to run alter statement on both or only on primary. I have to alter tables to row level locking from page level. So my question is do I run alters on both or just primary. This replication is only primary to secondary. Thanks, Sunita
You need to run alter statement only on Primary.
hi, you Jsu need to change it on Primary, As all transactions are getting replicated this also will get changed in secondary. Thanks Vamshi
Hi All, I would like to add something, As you know Secondary server/box in replication is in Read-Only mode. On primary server one can always give DDLs for create table, alter table but not on Secondary. Changes made on primary are applied to Secondary using Logical Logs. Thanks, Nilesh
Hi, Another thing to mention: DDL is replicated to the secondary without any problem (as is a chunk add e.g), but there might occur locks on the primary until the secondary instance has execute the DDL. We once had the problem the immediately after a create table, we got an error when altering that table (e.g. to add a foreign key). I am not sure which version we had at that time, and this problem might have been solved in the meantime. Marcus -----Original Message----- From: NILESH BHAVSAR [mailto:nilesh_bhavsar@satyam.com] Sent: Friday, February 01, 2008 7:21 PM To: ids@iiug.org Subject: Re: alter statement in HDR scenerio [11125] Hi All, I would like to add something, As you know Secondary server/box in replication is in Read-Only mode. On primary server one can always give DDLs for create table, alter table but not on Secondary. Changes made on primary are applied to Secondary using Logical Logs. Thanks, Nilesh ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!