Warehouse Release 3.02.5630

2008/06/04

The features in the 3.02.5630 release are:

. Fixed a problem with COPYing to a TEXT, FIXED or CSV file using more than one FORMAT.

This problem was caused by caching the file format and when the second or later format did not match

the first format, messages were issued. The fix now permits different formats to be written to a CSV, TEXT or FIXED file.

. . The Warehouse server has improved signal handling on all platforms except Windows.

The following improvements have been made for for non-Windows systems:

. The process id (pid) of the main Warehouse server process is now written to a file in the same directory in which the server program resides. The pid file is called WHSPID. Signals can be sent to Warehouse server processes by logging in as root (superuser) and using the kill command with the process as a parameter.

. If a child Warehouse server process (i.e. one that is processing requests from a Warehouse script or from DataBridger Studio) receives a SIGTERM signal, WHERR 20035 is sent to the client program and then the server process exits.

. If the main Warehouse server process receives a SIGTERM signal (the default for the kill command), all child processes are sent a SIGTERM and then the main server process exits. The following shell script can be used to kill all Warehouse server processes (change /home to the location of your Warehouse installation directory):

#! /bin/sh

#

kill `cat /home/taurus/whii/WHSPID`

. If the main Warehouse server process receives a SIGUSR1 signal (i.e. kill -SIGUSR1), a list of child processes is written to the file WHPROCS in the same directory as the server program.

. Fixed a problem with ALLBASE data types that allow nulls.

In prior releases, ALLBASE columns that began on an odd byte, had an even number of bytes and allowed nulls had a null indicator that was interpreted incorrectly.

. For IMAGE databases, added CIU option to OPEN statement that permits setting of critical item update (CIU) option in OPEN statement.

Using CIU=ON in the OPEN statement has the same effect as the statement: SET db CIU ON. OPEN example:

OPEN custdb IMAGE CUSTDB.DATA PASS=WRITER MODE=1 CIU=ON

. For ODBC and DB2 databases, added SCHEMA option to the OPEN statement that sets the default schema for the database.

This option is usually necessary when accessing an iSeries (AS/400) DB2 databae. Example:

OPEN custdb DB2 S1026C2A SCHEMA=CUSTOMERS

. On MPE/iX systems, fixed an abort with the MAKAP program when using single quotes instead of double quotes in an expression.

Version 2.09 of MAKAP fixes this problem.

. Implemented workaround for DB2/Red Hat problem where Warehouse aborted when attempting to open a DB2 database.

. Support for two new hardware platforms was added in this release.

The two new platforms are:

IBM iSeries (AS/400) Version 5 Release 4 (V5R4), Warehouse platform suffix -Q.

Sun SunOS 5.10 running on Intel (x86) architecture, Warehouse platform suffix –J.

. Fixed problem displaying correct indexes in DataBridger Studio.

Release 3.02.5630 is available now on all supported platforms.

ÿ