Creating a database user for Db2 for z/OS
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 cpedbuser:
- DBADM ON DATABASE cpe_databasename
- USE OF STOGROUP storagegroupname
- USE OF BUFFERPOOL
- EXECUTE ON PACKAGE NULLID.*
- SELECT ON SYSIBM.SYSINDEXES
- SELECT ON SYSIBM.SYSDUMMY1
- SELECT ON SYSIBM.SYSSEQUENCES
- SELECT ON SYSIBM.SYSTABLES
- SELECT ON SYSIBM.SYSVIEWS
- SELECT ON SYSIBM.SYSDATABASE
- (Required if you want to use data source sharing) CREATEIN, ALTERIN, DROPIN ON SCHEMA *
Record this value in your customized Installation and Upgrade Worksheet. To find this property, search the worksheet for instances of cpedbuser.