Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399

    Unanswered: how to change owner of backup file

    when we take a backup of the database the backup file has instance as an owner. it does not permit other users to do any operations on it (we want ops to compress the backup file). manually we can logon as an instance owner and change the backup file permission. but ops should not have access to instance userid and it all has to be automated (e.g. ops run script which takes a backup and compresses the backup file).

    any way to fix it? thanks in advance
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Why not have db2 compress the backup when it is created?

    Andy

  3. #3
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    Quote Originally Posted by ARWinner View Post
    Why not have db2 compress the backup when it is created?

    Andy
    we thought abt it but backup with compress takes much longer. when we do offline backup and than compress, db is availalbe right away once backup process ends.
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Once DB2 has completed the backup, it is basically an OS issue on compressing it.

    Andy

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Backup file permissions changed starting with v9.5. I believe it was done for security reason since the information in the image could be parsed with a hex editor. Your backup script can modify permissions on the image.

  6. #6
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    Quote Originally Posted by db2girl View Post
    Backup file permissions changed starting with v9.5. I believe it was done for security reason since the information in the image could be parsed with a hex editor. Your backup script can modify permissions on the image.
    no it can not. the message is:
    The file access permissions do not allow the specified action.

    another reason we want to use aix compress it makes backup file 10 times smaller vs. db2 backup compress which makes backup file only 4 times smaller.
    DB2 9.5/9.7 on Unix/AIX 6.1/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
  •