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:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.