Results 1 to 2 of 2

Thread: DB2 privilleges

  1. #1
    Join Date
    Dec 2008

    Unanswered: DB2 privilleges

    DB2 v9.7 fp 3a (Trial Version) on Win 2008 R2 (64bit).

    I have installed this DB2 trial version with full admin rights. Then restored the DB2 v8.2 database backup successfully.

    using db2cmd, at command promt I can connect to the database and did export ,import, drop table, alter table, backup, restore.,deactivate db, and activate db.....etc.
    However, I can not do the db2stop or db2start using db2cmd and getting not enough admin privilleage message.
    Also, db2pd -db database shows as database is not activated and not showing any database details.

    But using db2cwadmin I can do the db2stop and start. Also db2pd -db shows the database is active and shows all database details.

    Can someone advise, why I can not do he stop and start and db2pd using db2cmd.
    And how can I resolve this ?

    Thanks, Valan

  2. #2
    Join Date
    Aug 2001
    It is due to the way windows security works... there is nothing to fix ...

    There is an explanation here for vista .. probably similar for w2008

    IBM DB2 9.7 for Linux, UNIX and Windows Information Center
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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