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

    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.

    db2set DB2_GRP_LOOKUP=LOCAL,TOKENLOCAL
    db2 update dbm cfg using sysadm_group DB2ADMNS db2stop
    db2start

    i have find this cmd at https://www.ibm.com/support/knowledg...in_userid.html.

    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
    Location
    Moscow
    Posts
    259
    Provided Answers: 39
    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))


    Questions:

    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?
    Regards,
    Mark.

Posting Permissions

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