Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

Error message incorrect while configuring repository

  • 1.  Error message incorrect while configuring repository

    Posted Mon June 01, 2020 01:26 PM
    When configuring the first time the repository, when using a generic user, it says: 
    Error:

    "MYUSER" does not have the privilege to perform operation "CREATE BUFFERPOOL".. SQLCODE=-552, SQLSTATE=42502, DRIVER=4.26.14

    For a Db2 repository database, the user must have DBADM or SYSCTRL privilege. To configure the repository by a normal Db2 user, refer to this procedure
    However, after checking the documentation, in order to create a bufferpool it is necessary SYSADM or SYSCTRL authorities: 
    The privileges held by the authorization ID of the statement must include SYSCTRL or SYSADM authority.
    https://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000912.html
    For this reason, the error message should just say SYSCTRL privilege.



    ------------------------------
    Andres Gomez Casanova
    IBM Champion 2015-2020
    DBA senior
    Bogota, Colombia
    ------------------------------

    #Db2


  • 2.  RE: Error message incorrect while configuring repository

    Posted Mon June 01, 2020 02:57 PM
    Hello Andres,

    Thank you for your detailed description.  The current error message is not clear.  We will review it to see if repository connection user needs to have DBADM and SYSCTRL instead.  Thanks.

    ------------------------------
    Jason Sizto
    ------------------------------

    Original Message


Related Content