Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003

    Unanswered: TSM db2qadutl grant failed


    I get the following error message using TSM and granting permission to dbuser1 and node mynode for an already backed up database of another dbuser2.

    db2adutl grant user dbuser1 on nodename mynode for db dbuser2

    Warning: Permissions granted on backup image files only.
    Unable to find log files to add permissions to. At least one log
    file must exist to grant access to logs for this database.

    Any idea?


  2. #2
    Join Date
    Sep 2003
    Does the logarchmeth1 for already backed up database set to TSM? Message is saying it cannot find any logs archived by TSM.

  3. #3
    Join Date
    Jan 2003
    There is only one offline backup that was registered in TSM. I guess there is no log required.

    The backup was issued as follow:

    db2 backup database MYDB use tsm open 3 sessions with 4 buffers buffer 1024 parallelism 20 UTIL_IMPACT_PRIORITY 10 without prompting

    The logarchmeth1 is set to OFF.
    but... why TSM needs to have already some backups registered to allow granting permissions?

    thanks (sorry newbee in DB2)

    sorry I forget to tell: DB2 v9 on linux

Posting Permissions

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