Specifying userid and password to connect to a remote database for Datapropagator programs running on the System i.

Technote (FAQ)


Question

How do the Datapropagator programs like the Apply program connect to a remote database that requires an userid and password?

Answer

The User profile used by the Datapropagator programs could be associated with a remote database name and its userid and password.

To do so please make sure that the system value QRETSVRSEC is 1.
DSPSYSVAL SYSVAL(QRETSVRSEC)

If it is 0 please change it as follows -
CHGSYSVAL SYSVAL(QRETSVRSEC) VALUE('1')

Associate a local userid or user profile with the remote database name that matches the database name specified in WRKRDBDIRE and its Remote userid and password using the command


ADDSVRAUTE USRPRF(<localuserid>) SERVER(<Remote_Server_name>) USRID(<Remote_userid>) PASSWORD(<Remote_Password>)

Then run the replication programs when signed on as the local user.

Please note that Datapropagator Apply has a USER Parameter in the STRDPRAPY command. This allows different Users to start Apply but still be able to use the SVRAUTE under a different user as long as they have *USE authority on that user profile.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

InfoSphere Replication Server
Misc

Software version:

8.1

Operating system(s):

OS/400, i5/OS

Reference #:

1404522

Modified date:

2013-05-16

Translate my page

Machine Translation

Content navigation