DBPowerSuite Release 7.9 June 17, 2009 Program Enhancements ----------------------------------------------------------------- 1. Postgres Administrative Schema I added the ability to drop objects across schema. Bugs Fixed ----------------------------------------------------------------- 1. libpsOpenClient dGetProceduresList did not initialize row data before getting it from the database. It was preventing psCopyProcedures from working when using ASE 15 client library. DBPowerSuite Release 7.8 June 13, 2008 Program Enhancements ----------------------------------------------------------------- 1. psCopySchema This program copies schema and data from one Sybase database to another. The program no longer requires a simultaneous connection to both the source and target Sybase servers. 2. psCopyTables No longer requires the target server to be reachable. 3. psCopyTableData No longer requires the target server to be available. 4. psCopyIndices No longer requires the target server to be available. Bugs Fixed ----------------------------------------------------------------- 1. psKillProcesses This program now accomodates Sybase 15's larger column sizes. 2. psListDevices Now takes into account ASE 15's sysdevices and sysusages definitions. 3. licensing There was a problem in computing the license expiration date for 30 year licenses. I ran into the Y2038 bug. Known Issues -------------------------------------------------------------------- 1. psListSegments Does not work with ASE 15.0. There is a bug in the Sybase 15 client which does not allow me to make ordinary SQL calls after I call a dbreadpage(). DBPowerSuite Release 7.7 January 24, 2008 Program Enhancements ----------------------------------------------------------------- 1. Postgres Scripts Additional postgres scripts and libraries involving improved tsearch ranking library. 2. Red Hat EL5-64 Bit New package available for RHEL5 x86_64 computers. Comes with full Sybase open client for 64 bit Linux. API Enhancements ----------------------------------------------------------------- 1. libpsUCommon Enhancements to the uDivide function. --------------------------------------------------------------------------- DBPowerSuite Release 7.6 November 25, 2007 Program Enhancements ----------------------------------------------------------------- 1. psGWriteSQL A very useful program to write SQL statements based on a printf() format and a list of database objects. 2. psOSQL Added timemscomment command. This command prefixes SQL result sets with timestamps accurate to the millisecond. 3. Added several new Postgres scripts. API Enhancements ----------------------------------------------------------------- 1. StopWatch You can now make the StopWatch include CPU times for all the child processes. The swGlanceAtCPU() functions now have an extra output argument will tells you if the delta CPU time is exactly 0. 2. UFile Now has an attribute to turn on millisecond timestamp prefixes. 3. libpsUCommon Added uDivide(). This function safely divides a numerator by a denominator. uDivide properly considers when the numerator or denominator are close to min and max floating point values. 4. libpsLinux, libpsSolaris, libpsMac, libpsLinux64, libpsLinuxAlpha sysGetCPUTime has an added argument and logic to include the CPU times of child processes. Bugs Fixed ----------------------------------------------------------------- 1. psShowDiskPerformance An older version of Linux on the Alpha psShowPerformance 64 bit platforms does not have a working internal CPU clock. This absence of the clock resulted in absurdly high transaction rates because the OS returned 0 for a CPU time delta. Also, the Alpha platform core dumps when multiplying a number by 1.0002 millions of times. Apparently, the Alpha cores instead of truncating insignificant digits. While I cannot solve the Alpha's problem, I made the the problem go away by coding psShowPerformance and psShowDiskPerformance to multiply by 1.0 instead of 1.0002. 2. Sorting Algorithm One of the algorithms which sorts database object names for display purposes now works properly. ----------------------------------------------------------------- DBPowerSuite Release 7.5 November 2, 2007 Program Enhancements ----------------------------------------------------------------- 1. psShowDiskPerformance Exercises disks and determines their write and read I/O rates. 2. psShowPerformance Added the computer name to the report. 3. libpsUCommon Added uSyncDirectory(). See below. Added uRewindFile(). 4. libpsLinux, libpsLinux64 Add sysSyncDirectory(). This libpsLinuxAlpha, functions fsyncs a directory. libpsSolaris, libpsMac You need this function if your program creates, closes, and then opens the same file during its execution. Reopening a file will not work unless the directory itself knows the file exists. Caching prevents the directory from knowing immediately. A call to sysSyncDirectory() forces any cached data to write to the directory node. 5. psSetODBCDrivers.csh This script now also replaces the keyword USER_NAME in the odbc.ini_template and odbcinst.ini_template files with ${USER}. It already does ODBC_DIR and HOME_DIR. ------------------------------------------------------------------------------ DBPowerSuite Release 7.4 October 20, 2007 Program Enhancements ----------------------------------------------------------------- 1. psOListIndices New program. Lists indices at an ODBC data source. 2. psGChangeTablespaces Writes a SQL script to move indices and tables to different tablespaces. 3. psGReindex Writes a SQL script to rebuild indices. 4. psShowPerformance Exercises CPU and memory and shows you performance times. 5. Point In Time Recovery Added several shell scripts that backup a Postgres cluster and archive its WAL segment files to a remote computer. ------------------------------------------------------------------------------ DBPowerSuite Release 7.3 July 18, 2007 System Enhancements ----------------------------------------------------------------- Added Red Hat 5 platform. DBPowerSuite Release 7.2 March 1, 2007 System Enhancements ----------------------------------------------------------------- 1. System enhanced to easily link with Data Direct ODBC drivers. 2. System environment startup scripts simplified to choose ODBC environment. 3. Include full Postgres 8.2.1 Server for Solaris 8 environment. 4. Include Postgres ODBC 8.2.0 driver for all environments except Mac. This driver does not have a query size limit. 5. DBPowerSuite now available in 64-bits on Linux Intel platforms. Program Enhancements ----------------------------------------------------------------- 1. psOSQL You can now send the output of SQL to a file without worrying about the size of the results exceeding the operating system's maximum file length. psOSQL automatically creates a new file if the amount of data exceeds your specified amount. See the new -Q command line argument. 2. psOSQL The "des" describe tables command now displays "Octet-Len" and "Buffer-Len" information for each column. 3. psOSQL The "fky" command is new. It displays the names and columns involved in foreign keys. 4. psOSQL The "pdes" command is new. It displays the arguments, return values and result columns for functions and stored procedures. 5. psOLoader You can now convert incoming hex binary string data into outgoing octal string data. Postgres bytea datatype requires octal strings. Most other databases, when requested to output their binary columns in text, represent binary data as hex strings. 6. psOLoader You can now tell psOLoader to expect the fields in the incoming text file to match an alphabetically sorted list of columns in the text file's matching database table. 7. psOLoader You can optionally tell psOLoader to return a successful code if the table does not exist in the database. 6. psODropIndices This program writes a psOSQL script to drop all the indices for list of tables. 8. psOListTables New program. This program lists the table names in your specified schema to a text file. You can use this text file as input to programs like psGTruncateTables and psGUpdateStatistics. 9. psOListViews New program. This program lists the view names in your specified schema to a text file. 10. psConvertFileToUpperCase New program. This program converts a file to upper case. 11. psConvertFileToLowerCase New program. This program converts a file to lower case. 12. psUpgradeSourceCode.csh New script. This script search and replaces old to new strings for all source code text files in a directory. 13. psUpgradeSourceCodeInDirs.csh New script. This script searches all the first level subdirectories in directory and replaces old to new strings in all the source code text files in those subdirectories. API Enchancements ------------------------------------------------------------------ 1. libpsODBC Added UFileStatement::osSetAfterRowCallback method. A UFileStatement object calls this callback after each write operation to the underlying UFile. This gives the calling application the opportunity to check the size of the UFile, and change the UFile's output stream if desired. 2. libpsODBC All the ODBC catalog statement methods are now virtual. This means you can add you own logic to retrieve catalog information instead of relying on the ODBC driver to return the information. 3. libpsODBC Added Postgres ODBC catalog statement class. Existing Postgres ODBC driver does not return SQL_DATA_TYPE codes for table columns. The new catalog statement class determines the SQL data type code from the Postgres data type name. 4. libpsODBC The UFileStatement class now limits unicode SQL_WLONGVARCHAR types to the maximum image/text length. 5. libpsODBC Introduced ocsSort() overloaded methods to sort table and column names lists. Most ODBC drivers' implementations of SQLTables and SQLColumns do not sort these lists. 6. libpsODBC Added several OCatalogStatements methods to return foreign key and procedure/function column information. 7. libpsODBC The underlying unixODBC odbc.ini file now contains reasonable defaults for maxcharsize and maxlongvarcharsize. Previously, the Postgres driver would default these values to 254 bytes. 8. libpsUCommon Added the function uAdd1ToFileExtension. This function appends a _n to the end of a file name. If the file name already has a _n, then the function replaces the _n with _(n + 1). 9. libpsUCommon Added several hex and octal to binary conversion functions. Programs Bugs Fixed ----------------------------------------------------------- 1. psGCheckRIConstraints The program would core dump when writing the PL/SQL code for a table containing composite column keys. 2. psGCheckRIConstraints This program now handles keys that have columns that are Oracle date types. 3. psGDeleteRIViolators The program would core dump when writing the PL/SQL code for a table containing composite column keys. 4. psGDeleteRIViolators The program now considers object names that are reserved words, and therefore surrounds them in quotes when generating SQL code. 5. psGDeleteRIContraints The program now considers object names that are reserved words, and therefore surrounds them in quotes when generating SQL code. ----------------------------------------------------------------- ----------------------------------------------------------------- DBPowerSuite Release 7.1 June 26, 2006 System Enhancements ----------------------------------------------------------------- 1. New bundle compiled specifically under RHE 4. DBPowerSuite Release 7.0 April 15, 2006 System Enhancements ----------------------------------------------------------- 1. DBPowerSuite now works on Macintosh OS X 10.4.3. 2. DBPowerSuite supports iODBC drivers on Macintosh. 3. MySQL 5.0.19, fully compiled, is now bundled with DBPowerSuite. 4. DBPowerSuite now supports Sybase 15.0. This means DBPowerSuite supports the new datatypes for Sybase 15 as well as the larger object names. 5. All Sybase and ODBC programs are now ready to run. You do not need a ODBC or Sybase client installed on your computer. Program Enhancements ----------------------------------------------------------- 1. psEstimateSpace Now takes into account the various page sizes in Sybase. 2. psListTablesForWeb Now defaults to a white background. 3. psDocumentAPI Now defaults to a white background. 4. psDocumentPrograms Now defaults to a white background. Programs Bugs Fixed ----------------------------------------------------------- 1. psDocumentAPI Program was incorrectly trying to read subdirectories within source directories. API Enhancements ----------------------------------------------------------- 1. libpsMac New. Contains all the operating specfic calls for Macintosh computers.