Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

  • 1.  Error message incorrect while configuring repository

    Posted 06/01/20 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 06/01/20 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
    ------------------------------