Content Platform Engine, Version 5.2.1   Database:  DB2 for z/OS        Operating systems:  Linux on System z

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

  1. 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.
  2. 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
  3. Icon representing the worksheet Record this value in your customized Installation and Upgrade Worksheet. To find this property, search the worksheet for instances of cpedbuser.


Last updated: March 2016
p8ppi213.htm

© Copyright IBM Corporation 2013, 2016.