This chapter lists the hardware and software requirements for installing the gateway. It includes the following sections:
The following Oracle Transparent Gateway for DB2 resource requirements are discussed in this chapter:
CPU
Disk space
Virtual memory
The gateway requires any processor that can run the required z/OS operating systems listed in "Software Requirements".
The following are the disk space requirements:
Temp z/fs: 600 MB.
If you want to further reduce the requirement of temporary z/fs disk space, then delete the zip file after uncompressing it, and before running the installer. After running the Oracle installer, if you are sure you would not need to configure another gateway instance, then you can delete the installer home which is the result of uncompressing the zip file.
Permanent z/fs: 220 MB with locale builder, 166 MB without locale builder
Permanent Data Set Space: 200 cylinders
Each concurrent user of the gateway increases the virtual memory consumption, and it varies depending on:
The number and complexity of SQL statements referring to tables through the gateway
The number of columns and column sizes of those tables
The configured network buffer size
The number of open cursors and the HS_RPC_FETCH_SIZE
initialization parameter
Oracle recommends defining 0M
for the REGION
parameter in the Oracle Transparent Gateway for DB2 address space.
Oracle also recommends defining 0M
for the REGION
parameter in the Oracle Net address space.
Oracle Transparent Gateway for DB2 has requirements for the following:
The system software configuration described in the following requirements is supported by Oracle, as long as the underlying system software products are supported by their respective vendors. Verify the latest support status with your system software vendors.
An operational z/OS UNIX System Services (USS) is required.
Oracle recommends running Oracle Transparent Gateway for DB2 at the most current operating system service level.
If you are using the current version of the Oracle Transparent Gateway for DB2 to access DB2 v7.1 you need to apply the following DB2 maintenance:
APAR PK20664: SQLCODE330 ON DESCRIBE OF A PREPARED STATEMENT USING BIND OPTION ENCODING(UNICODE)
. The corresponding PTF
is UK13641
.
The Oracle Server which is to act as the Oracle integrating server requires the latest patch set for Oracle Database 10g and Oracle9i release 9.2.
When you install Oracle Net, you have additional software and hardware requirements.
Oracle Net Protocol | Product | Required Protocol Release |
---|---|---|
Oracle Net IBM TCP/IP | z/OS | 1.4 or higher |