Zero Downtime Installation Guide for IBM Db2

10.5

Back Next

Create a User for Oracle GoldenGate on Windows

Create a dedicated user for Oracle GoldenGate on both the source system and the target system. You can use the same user name on both systems or different user names. Assign the user to the groups DB2ADMINS and DB2USERS. A database administrator must grant DBA permissions to this user.

The following steps describe how to set up a user on a Windows system. The steps might vary based on the version of Windows that you use.

On the source system, open

Control Panel

, and click

Administrative Tools

Double-click

Computer Management

In the Computer Management window, expand

Local Users and Groups

Right-click

Users

and select

New User

In the New User dialog box, type a user name, such as

Clear the

User must change password at next login

check box.

Select the

User cannot change password

check box.

Select the

Password never expires

check box.

Click

Create

The New User dialog box closes, and the GG user appears in the list.

Assign the user to user groups.

In the

Computer Management

window, right-click the

user.

In the

GG Properties

dialog box, click

Member Of

Click

Add

In the

Select Groups

dialog box, specify the following groups:

DB2USERS

and

DB2ADMNS

Click

The dialog box closes.

In the

GG Properties

dialog box, click

Repeat all steps on the target system.

A database administrator must grant DBA privileges to this user on both systems.

GRANT DBADM ON DATABASE TO USER GG

The user can now use stored procedures and the db2readlogAPI.

Prepare the Environment for IBM Db2 Databases

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Zero Downtime Installation Guide for IBM Db2

Zero Downtime Installation Guide for IBM Db2

Create a User for Oracle GoldenGate on Windows

Create a User for Oracle GoldenGate on Windows