1. Oracle GoldenGate Classic Documentation
  2. Prepare
  3. Prepare Your Database for Oracle GoldenGate Classic Architecture
  4. Db2 z/OS
  5. Database User for Oracle GoldenGate Processes

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 the following table to the user. 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.

The following authorities can be provided by granting either SYSCTRL or DBADM plus SQLADM authority to the user running the Oracle GoldenGate processes.

Table 3-2 Privileges Needed by Oracle GoldenGate for Db2 z/OS

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

X

X

SELECT on source tablesFoot 1

X

INSERT, UPDATE, DELETE on target tables

X

CREATE TABLEFoot 2

X

EXECUTE on ODBC plan (default is DSNACLI)

X

Privileges required by SQLEXEC procedures or queries that you will be using.Foot 3

X

X

Footnote 1

SELECT on source tables required only if tables contain LOB columns, or for an initial-load Extract, if used.

Footnote 2

Required if using ADD CHECKPOINTTABLE in GGSCI to use the database checkpoint feature.

Footnote 3

SQLEXEC enables stored procedures and queries to be executed by an Oracle GoldenGate process.