Warehouse Release 3.00.4410

10/22/2004

The features in the 3.00.4410 release are:

. An issue with updating an ODBC data source that was read with an

ORDER BY has been fixed. This problem was created in version

3.00.3440.

. An issue with reading MPE/iX message files after a system failure

has been fixed. When a message file that was open during a system

failure is read for the first time after the system is restarted

MPE returns file system error 151. This caused a Warehouse script

to stop processing. Warehouse now ignores file system error 151.

. An issue with spaces in file and directory names on Windows has

been fixed. When creating a job control database on a Windows

system, Warehouse writes the name of the Warehouse client program

and spool file directories into the job control database. If

any of these has spaces in the name, subsequent job control

operations could fail. This problem was been fixed by using

Windows short file names. For more information see:

http://support.microsoft.com/default.aspx?scid=kb;en-us;142982

. Support for Oracle CLOB and BLOB data has been added. This was

done by adding two new data types (ORACLE CLOB and ORACLE BLOB)

and by enhancing the Warehouse Oracle interface to insert, update,

and delete CLOB/BLOB data in Oracle data bases.

Oracle did not fully support CLOB/BLOB data until release 8.1 of

Oracle. To handle CLOB/BLOB data Warehouse dynamically loads

the Oracle OCI functions needed for CLOB/BLOB support. This

allows Warehouse to operate exactly as before when CLOB/BLOBs

are not used. If Warehouse cannot dynamically load the OCI

functions necessary, then tables with CLOB/BLOB data will not

be accessible with Warehouse.

. The -showinfo parameter has been added to Warehouse to display

the Warehouse operating environment. When either the Warehouse

client or server is run with -showinfo, the operating environment

is displayed.

The syntax is:

warehouse -showinfo [output-file]

If output-file is specified, the information is written to a file.

The -showinfo information looks like this:

Program version : Warehouse 3.00.4377-W

Program name : d:\wh\current\whide\wh.exe

Warehouse home : d:\wh\current\whide\

Operating system : MS Windows

System ID : 000cf1d8eda7

Validation status : Production

System name : CAESAR

User login name : Administrator

Word size : 32 bits (Little endian)

Current date and time : 10-OCT-2004 08:23:52

File system : Static

Posix libraries : Unavailable

TurboIMAGE : Unavailable

ODBC libraries : Available

Oracle : Available (Dynamic)

Oracle 8 features : Available (Dynamic)

Program version - This is version of the Warehouse program.

Program name - This is the name of Warehouse program.

Warehouse client program - Indicates the name of the

Warehouse client program. Only the Warehouse server displays

this value. It is necessary for the server to be able to

find the client program when using DataBridger Studio job

control features.

Warehouse program type - Indicates the type of the

Warehouse program. This value is "Server" for the Warehouse

server program and is not displayed for the Warehouse client

program.

Warehouse home - This is the directory where Warehouse looks

for its files. This includes the validation file MSG999 and

configuration files such as CHARMAPS.

Operating system - This is operating system under which the

Warehouse program was compiled. It corresponds to the last

character of the Warehouse version as follows:

A - DEC Alpha (No longer supported)

C - SCO (No longer supported)

F - HP-UX 11

H - HP-UX

I - SGI Irix

L - Linux

M - MPE/iX

R - IBM RS/6000

S - SunOS

V - DEC VMS (No longer supported)

W - MS Windows

X - Unknown

System ID - This is the unique system ID for the system on

which Warehouse is running.

Validation status - Shows the status of the Warehouse

validation as follows:

Production Indicates Warehouse has been

validated for production.

Expires on <date> Indicates a demonstration version

that expires on the date shown.

Expired on <date> Indicates an expired demonstration

version that expired on the date

shown.

Needs validation Indicates that Warehouse needs to be

validated before it can be run.

System name - This is the system name of the system on which

Warehouse is running. This name is determined by the system

network configuration. This name may be important when

setting up the AUTHFILE for Warehouse server access.

User login name - This is the name of the login user as

indicated by the system. This name may be important when

setting up the AUTHFILE for Warehouse server access.

Word size - indicates the hardware environment under which

the Warehouse program was compiled. Currently all supported

platforms are 32 bits. Big endian indicates forward byte

ordering (e.g. 0x01020304 is stored as 0x01 0x02 0x03 0x04)

and Little endian indicates backward byte ordering (e.g.

0x01020304 is stored as 0x04 0x03 0x02 0x01)

Current date and time - Indicates the system clock time

as determined by the C library. This may be different

than other methods of determining the system time,

particularly on MPE/iX.

OS Date conflicts - Indicates the system clock as determined

by operating system calls conflicts with the C library clock.

This time is only displayed if there is a conflict with

C library date and time. This value is often displayed

on MPE/iX when the TZ environment variable is not set or

is set incorrectly.

File system - Indicates which file system is used by the

Warehouse program. This is always "Static" except on

HP-UX platforms. The values are:

Static Indicates the standard file

system.

Static (Dyn load err) Indicates the standard file

system after an attempt to

dynamically load the HP-UX

64-bit file system failed.

(Only used on HP-UX)

Dynamic Indicates the standard file

system was dynamically loaded.

Dynamic 64 bit Indicates the HP-UX 64-bit file

system was dynamically loaded.

(Only used on HP-UX)

Posix libraries - Indicates whether the Posix libraries

are used. The value of the does not matter, except on

MPE/iX. On MPE/iX, it is possible some file operations

may generate different results if the Posix libraries

are used. On MPE/iX, both Posix and non-Posix versions

of Warehouse are shipped.

HP-UX Trusted system - (Only on HP-UX) Indicates if the

system is considered a trusted system. Trusted systems

use a different method for password verification when

a client connects to the Warehouse server. A trusted

system is indicated by the presence of the file

/tcb/files/auth/system/default

TurboIMAGE - Indicates whether IMAGE is available or

not. Always "Available" on MPE/iX, and always

"Unavailable" on other platforms. This may chance

some day we implement Eloquence.

ODBC libraries - Indicates whether the ODBC are available

or not. Always "Available" on Windows, and always

"Unavailable" on other platforms except for IBM RS/6000.

On the IBM RS/6000, "Available" indicates that DB2

may be accessed and "Unavailable" indicates that DB2

may not be accessed.

Oracle - Indicates whether the Oracle is available and

the method used to link the Oracle libraries. Values

are:

Unavailable Indicates Oracle is not

available with this Warehouse

program.

Unavailable (Dynamic) Indicates Oracle is not

available with this Warehouse

program after an attempt

was made to dynamically load

the Oracle OCI calls. This

may be able to be corrected

by setting environment variables

such as ORACLE_HOME.

Available (Static) Indicates Oracle is available

with this Warehouse program

and the Oracle OCI libraries

were linked at compile time.

Available (Dynamic) Indicates Oracle is available

with this Warehouse program

and the Oracle OCI libraries

were linked at run time.

Oracle 8 features - Indicates whether the Oracle 8.1

OCI features are available. These features are necessary

for accessing CLOB and BLOB data in tables. These

features are always dynamically loaded.

Unavailable (Dynamic) Indicates Oracle 8.1 OCI

features for CLOB/BLOB access

are not available after an attempt

was made to dynamically load

the Oracle OCI calls. It may be

possible to correct this by

setting environment variables

such as WHORACLE8LIB.

Available (Dynamic) Indicates Oracle 8.1 OCI

features for CLOB/BLOB access

are available after linking

them at run time.

. The -serverinfo parameter has been added to Warehouse to

display the Warehouse operating environment for a remote

Warehouse server.

The syntax is:

warehouse -serverinfo [server-name]

If server-name is specified, information is displayed for the

server. If server-name is not specified, the user is prompted

for the server name. The information displayed is the same

as the -showinfo information documented above.

Release 3.00.4410 is available now on all supported platforms.