运行Capture程序的ID,需不需要对source表,CD表,CCD表等有select,或者select以外的权限?

平台是z/OS,DB2 V10.1 根据下边的文档说明,运行Capture程序的ID必须对所有的replication tables有SELECT, UPDATE, INSERT, and DELETE的权限,这里的replication tables包括了source表,CD表,CCD表这些吗?

z/OS®

The user ID used to run the Capture program must be registered with access to USS. That means the user ID must be defined to use z/OS UNIX or OS/390® UNIX (it must have an OMVS segment).

Also, ensure that the Capture load library is APF-authorized and that the user ID that runs the Capture program has the following privileges:

WRITE access to a temporary directory; either the /tmp directory or the directory specified by the TMPDIR environment variable.

SELECT, UPDATE, INSERT, and DELETE privileges for all replication tables on the Capture control server.

SELECT privilege for the DB2 catalog (SYSIBM.SYSTABLES, SYSIBM.SYSCOLUMNS. and SYSIBM.SYSPLAN).

TRACE privilege.

MONITOR1 and MONITOR2 privilege.

EXECUTE privilege for the Capture program packages.

Also, ensure that the user ID has WRITE access to the capture path directory (USS) or high-level qualifier (z/OS). To run the Capture program in the USS shell, the STEPLIB system variable must be set and it must include the Capture load library. The HFS path, /usr/lpp/db2repl_10_01/bin, must be in your PATH.

参与1

0同行回答

“答”则兼济天下,请您为题主分忧!

提问者

jiasenjason
系统工程师皮包公司

相关问题

相关资料

相关文章

问题状态

  • 发布时间:2017-02-20
  • 关注会员:1 人
  • 问题浏览:1041
  • X社区推广