New RFE

Folks: I have created a new RFE described as follows: It is significantly faster to load a table in TYPE(RAW) mode than TYPE(STANDARD) mode. However, this option is not practical for sites using HDR and/or RSS secondary servers for replication as RAW mode tables do not replicate forcing the site to break and reestablish replication from scratch producing a period of time during which there is no secondary backup for the primary server. But in most of these situations the table being loaded is needed on all copies of the server precluding using this method. I would suggest an option to the ALTER TABLE <table name> TYPE (STANDARD); that would copy the data to the secondaries in the background after altering the primary copy of the table to standard. Suggested syntax: ALTER TABLE <table name> TYPE( STANDARD WITH REPLICATION ); Here's the link to the RFE record: http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=107441 If you think this might be useful to you please vote for it. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.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 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.