New utility versions.
Posted in 2000
I have uploaded and Walt has installed new versions of my packages: utils2_ak and myexport. A description of the changes/additions follows: Myexport (README.1st Dated October 17, 2000): A bug in the -o option was repaired to work correctly with absolute or relative paths. Parallel export and import are now fully implemented with the new (non-dbexport/dbimport compatible) flag -p. Recognized by both myexport and myimport. Both wait for the background loads/extractions to complete. New -e extention causes myimport to assume that the database already exists and does not need to be recreated. Great for updating an existing development server. -T <dbspace_file> extension to myimport takes a file containing dbspace name pairs. It causes all references to the first dbspace of each pair to be remapped to the second dbspace in all ON ... clauses. Perfect for porting from a production server to a development server with different dbspaces or for reorging or migrating a database to a new server with an 'improved' layout. Note that the mapping is done using sed and all mappings are applied sequentially so the order of maps in the file will control the outcome. Utils2_ak (README.1st Dated October 25, 2000): dostats: Removed spurious timings for tables not updated when running updates for stored procedures only. Fixed dostats to ignore the renamed stored procedure with an invalid name that is created when upgrading a 7.3 instance to 9.2x. myschema: Fixed the output of initial SERIAL column value and added a new option, -c, which along with including or excluding the -a option gives on good control over whether the current next value (from sysptnhdr.serialv) or the MAX(col) value is used. Added source protection to some more files to correct compile problems on AIX. Have fun Art S. Kagel