As the final piece of this four-part tutorial, we will demonstrate how to install and configure the Spark SQL JDBC preview driver. This video will also show you how you can obtain the Spark SQL. Contains links to download DB2® 9.7 Fix Pack 1, servers, extenders, clients and drivers in Fix Central for AIX, HP-UX, Linux, Solaris, and Windows operating systems. On OS/2 and Windows 3.x you must use the Install ODBC Driver icon to install both the DB2 CLI/ODBC driver and the ODBC driver manager. To access the DB2 database from ODBC: The Microsoft, Visigenic, or other ODBC Driver Manager must already be installed (this is done by default during the installation of DB2).

The script content on this page is for navigation purposes only and does not alter the content in any way.

Learn about the requirements and how to install Oracle GoldenGate with a DB2 z/OS database.

Topics:

System Services
Memory Requirements
Disk Requirements for DB2 z/OS
Operating System Privileges for DB2 z/OS
Database Configuration for DB2 z/OS
Database User for Oracle GoldenGate Processes
Choosing an Installation Operating System
Installing Extract Components on DB2 z/OS

Parent topic:Installing Oracle GoldenGate for Heterogeneous Databases

5.1 System Services

Activate UNIX System Services (USS) only if required to install the executables for the Extract support modules.

Oracle GoldenGate supports Sysplex data sharing.

5.2 Memory Requirements

Oracle GoldenGate requires the following memory resources on the local system.

On the remote system

The amount of memory that is required for Oracle GoldenGate depends on the amount of data being processed, the number of Oracle GoldenGate processes running, the amount of RAM available to Oracle GoldenGate, and the amount of disk space that is available to Oracle GoldenGate for storing pages of RAM temporarily on disk when the operating system needs to free up RAM (typically when a low watermark is reached). This temporary storage of RAM to disk is commonly known as swapping or paging. Depending on the platform, the term swap space can be a swap partition, a swap file, or a shared memory segment (IBM i platforms).

Modern servers have sufficient RAM combined with sufficient swap space and memory management systems to run Oracle GoldenGate. However, increasing the amount of RAM available to Oracle GoldenGate may significantly improve its performance, as well as that of the system in general.

Typical Oracle GoldenGate installations provide RAM in multiples of gigabytes to prevent excessive swapping of RAM pages to disk. The more contention there is for RAM the more swap space that is used.

Excessive swapping to disk causes performance issues for the Extract process in particular, because it must store data from each open transaction until a commit record is received. If Oracle GoldenGate runs on the same system as the database, the amount of RAM that is available becomes critical to the performance of both.

RAM and swap usage are controlled by the operating system, not the Oracle GoldenGate processes. The Oracle GoldenGate cache manager takes advantage of the memory management functions of the operating system to ensure that the Oracle GoldenGate processes work in a sustained and efficient manner. In most cases, users need not change the default Oracle GoldenGate memory management configuration.

For more information about evaluating Oracle GoldenGate memory requirements, see the CACHEMGR parameter in the Reference for Oracle GoldenGate.

Install Ibm Db2 Odbc Driver On Windows 7

On the DB2 host system

Allocate approximately 10-50 MB of virtual memory for each Oracle GoldenGate log reader, oggreadx, that is invoked depending on the size of the log buffer. There is one invocation per Extract process on the remote system. To adjust the maximum log buffer size, use the TRANLOGOPTIONS BUFSIZE parameter in the Extract parameter file.

When setting up the Wotkload Manager (WLM) environment for the Extract log read components, it is recommended to set NUMTCB in the range of 10-40 depending on your environment. This is based on the IBM general guidelines available here:

lhttps://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/perf/src/tpc/db2z_assignprocfunc2wlmappenv.html

5.3 Disk Requirements for DB2 z/OS

On the DB2 host system

(Only applicable if you are installing stored procedures.) Assign a zFS (zSeries file systems) or hierarchical file system volume. To determine the size of the Oracle GoldenGate download file, examine the size of zOSPrograms.zip on the remote DB2 system after extracting the installation image.

5.4 Operating System Privileges for DB2 z/OS

The remote host requires privileges to use the chmod +rw command on the sub-directories in the Oracle GoldenGate product directory.

Table 5-1 shows the other required operating system privileges for Oracle GoldenGate:

Table 5-1 Operating System Privileges

DB2 z/OS User Privilege	Extract	Stored Procedures	Replicat
`CONNECT` to the remote DB2 subsystem.	X	X	X

5.5 Database Configuration for DB2 z/OS

No special DB2 z/OS database settings are required for Oracle GoldenGate.

5.6 Database User for Oracle GoldenGate Processes

Oracle GoldenGate requires a database user account. Create this account and assign privileges according to the following guidelines.

Assign the DB2 privileges listed in Table 5-2 to the user by which Extract and Replicat will be running. These are in addition to any permissions that DB2 ODBC requires. All Extract privileges apply to initial-load and log-based Extract processes, except where noted.

Table 5-2 Privileges Needed by Oracle GoldenGate for DB2 z/OS

User privilege Extract Replicat

User privilege	Extract	Replicat
`MONITOR2` (does not apply to initial-load Extract)	X
`SELECT ON` the following `SYSIBM` tables: `SYSTABLES` `SYSCOLUMNS` `SYSTABLEPART` `SYSKEYS` `SYSINDEXES` `SYSCOLAUTH` `SYSDATABASE` `SYSFOREIGNKEYS` `SYSPARMS` `SYSRELS` `SYSROUTINES` `SYSSYNONYMS` `SYSTABAUTH` `SYSAUXRELS` But note that you can get the Start Orb back by using one of several third-party programs,either free or very inexpensive (Classic Shell at and Start8 at; my personal preference is Start8, but they are both very good).And going from one interface to the other is very easy; there are several ways, but simply pressing the Windows key is perhaps the easiest.I use

MONITOR2

(does not apply to initial-load Extract)

SELECT ON the following SYSIBM tables:

SYSTABLES

SYSCOLUMNS

SYSTABLEPART

SYSKEYS

SYSINDEXES

SYSCOLAUTH

SYSDATABASE

SYSFOREIGNKEYS

SYSPARMS

SYSRELS

SYSROUTINES

SYSSYNONYMS

SYSTABAUTH

SYSAUXRELS

But note that you can get the Start Orb back by using one of several third-party programs,either free or very inexpensive (Classic Shell at and Start8 at; my personal preference is Start8, but they are both very good).And going from one interface to the other is very easy; there are several ways, but simply pressing the Windows key is perhaps the easiest.I use

Install Db2 Driver On Windows