New release of utils2_ak
Posted in 2022
Topics: High Availability & Replication, Jobs, Consulting & Announcements
Folks: I have uploaded an update to my utils2_ak package today. Here's what's new: May 3, 2022: dbcopy.ec: Changed Usage output to write to stdout to simplify piping to less/ more. Removed old debug trace. Added new -J option to alter the target table to TYPE(RAW) before the copy and alter it back to TYPE(STANDARD) when the copy completes. If the target is already a RAW table -J is ignored and the table's type is preserved either way. Dbcopy will exit if the alter cannot be processed. The new -J option can make dbcopy run even faster than ever without having to separately script altering the table type. Note that if dbcopy should crash there is a possibility that the target table will be left in RAW mode. The -J option, like the -R option ( Begin transactions with the WITHOUT REPLICATION clause), should not be used on systems with RSS or HDR secondaries and when used in an ER environment should be followed by a "cdr sync" order. If you think of any improvements or additional options to any of my utilities, please let me know. It's likely that I will put the request into my queue. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------ #Informix