Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2017

    Unanswered: DB@ Authoirty issue

    I am Working on db2 v10.5.

    Initially database was working fine having issue while generating the DDL of table, To resolve it i have execute the following cmd.

    db2 update dbm cfg using sysadm_group DB2ADMNS db2stop

    i have find this cmd at

    After executing the cmd, i am unable to perform following tasks

    backup of database
    create database from database.
    DDL gerente using db2look command.
    Please provide your support,how to get database in previous state.

  2. #2
    Join Date
    Jul 2016
    Provided Answers: 45
    To have an ability to do backups (you can test any username setting it instead of 'user' below) the following query must return some rows:

    select authority
    from table(AUTH_LIST_AUTHORITIES_FOR_AUTHID(user, 'U'))
    where authority in ('SYSADM', 'SYSCTRL', 'SYSMAINT') and d_group='Y'

    DB2 thinks that your user is a member of the following groups:

    select group
    from table(auth_list_groups_for_authid(user))


    1. What's the result of these queries for your user?
    2. DB2ADMNS - is this a local or domain group?
    3. Your user - is this a local or domain user?
    4. Your user which you use for the DB2 instance service - is this a local or domain user?
    5. Your workstation - is this a standalone workstation or a member of MS AD?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts