replication question

informix 11.70.FCx Sun solaris bla bla bla A silly question as its Christmas. Below is an extract from the IBM website regarding SQL statements permitted to be run when Enterprise Replication is active. I have a requirement to create an index on a replicated table. However a colleague will be doing this who is not a DBA so I need to make the release for him bulletproof. The documentation states that ADD INDEX is permitted which is new one on me. I assume they meant CREATE INDEX. Correct or not? Regards Andy G SQL statements and replicationYou can run most SQL statements while replication is active. For some statements, however, you must set alter mode or stop replication.You can run the following SQL statements with no limitations while Enterprise Replication is active: ADD INDEXALTER INDEX . . . TO CLUSTERALTER FRAGMENT ALTER INDEX ALTER TABLE (except for the primary key)CREATE CLUSTER INDEXCREATE SYNONYM CREATE TRIGGER CREATE VIEW DROP INDEX DROP SYNONYM DROP TRIGGER DROP VIEW RENAME COLUMNRENAME DATABASERENAMETABLESET object mode (no disabling of primary key constraint)START VIOLATIONS TABLE STOP VIOLATIONS TABLE TRUNCATE TABLE

Yes, you can run a CREATE INDEX, CREATE CLUSTER INDEX, and CREATE UNIQUE INDEX on a server that is participating in ER. Indeed, since you are running 11.70, if you have set up Flexible Grid, you can issue the create command through the grid and have it created on all nodes participating for that table concurrently. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Dec 20, 2012 at 9:03 AM, Andrew Grantham <agrantha@hotmail.com>wrote: > informix 11.70.FCx > Sun solaris bla bla bla > > A silly question as its Christmas. Below is an extract from the IBM website > regarding SQL statements permitted to be run when Enterprise Replication is > active. I have a requirement to create an index on a replicated table. > However > a colleague will be doing this who is not a DBA so I need to make the > release > for him bulletproof. The documentation states that ADD INDEX is permitted > which is new one on me. I assume they meant CREATE INDEX. Correct or not? > > Regards > > Andy G > > SQL statements and replicationYou can run most SQL statements while > replication is active. For some statements, however, you must set alter > mode > or stop replication.You can run the following SQL statements with no > limitations while Enterprise Replication is active: ADD INDEXALTER INDEX . > . . > TO CLUSTERALTER FRAGMENT ALTER INDEX ALTER TABLE (except for the primary > key)CREATE CLUSTER INDEXCREATE SYNONYM CREATE TRIGGER CREATE VIEW DROP > INDEX > DROP SYNONYM DROP TRIGGER DROP VIEW RENAME COLUMNRENAME DATABASERENAME> TABLESET object mode (no disabling of primary key constraint)START > VIOLATIONS > TABLE STOP VIOLATIONS TABLE TRUNCATE TABLE > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d0447f05e1b2cb104d149a381