A database account that Content Platform Engine uses to access DB2® for z/OS®.
This account is initially created as an operating system account.
Procedure
- Make sure you have already created the operating system
account cpedbuser for DB2 for z/OS. This procedure grants
database permissions to that operating system account.
- Use your database tools to grant the following permissions
to the already-created cpedbuser:
- Content Platform Engine database user (DB2 for z/OS)
- Unique identifier
- cpedbuser
- Description
- The cpedbuser must have DBADM authority of the DB2 instance that will be used by the workflow system software.
- DB2 for z/OS does not allow underscores in account names.
- In a farmed or cluster configuration, each workflow system must be configured to use the same
database user name.
- Minimum required permissions
Grant the following database permissions to this user:
- GRANT DBADM ON DATABASE cpe_databasename TO cpedbuser
- GRANT USE OF STOGROUP storagegroupname TO cpedbuser
- GRANT USE OF BUFFERPOOL buffer_pool_name TO cpedbuser
- GRANT EXECUTE ON PACKAGE NULLID.* TO cpedbuser
- GRANT SELECT ON SYSIBM.SYSINDEXES TO cpedbuser
- GRANT SELECT ON SYSIBM.SYSDUMMY1 TO cpedbuser
- GRANT SELECT ON SYSIBM.SYSSEQUENCES TO cpedbuser
- GRANT SELECT ON SYSIBM.SYSTABLES TO cpedbuser
- GRANT SELECT ON SYSIBM.SYSVIEWS TO cpedbuser
- GRANT SELECT ON SYSIBM.SYSDATABASE TO cpedbuser
- (Required if you want to use data source sharing) GRANT CREATEIN, ALTERIN, DROPIN ON SCHEMA * TO
cpedbuser
Record this value in your customized Installation and Upgrade Worksheet. To find this property,
search the worksheet for instances of cpedbuser.