Results 1 to 7 of 7
  1. #1
    Member
    Join Date
    Nov 2008
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Blog Entries
    1

    Default db2 backup is failing

    The db2 backup is failing with below error,any solution.

    "size estimate exceeded and server is unable to obtain additional space in storage pool"

  2. #2
    Senior Member
    Join Date
    Jul 2008
    Location
    Birmingham, UK
    Posts
    537
    Thanks
    0
    Thanked 5 Times in 4 Posts

    Default

    check the maxscratch parameter for the storage pool the backup is using
    and compare that to the number of scratch volume used

    q stg <stgpool name> f=d will show you this information

    Maximum Scratch Volumes Allowed: 270
    Number of Scratch Volumes Used: 244

    If you need to allow the stgpool to use more tapes do

    upd stgpool <stgpool name> maxscratch=xxx

    The other thing of course could be that you have run out of scratch tapes..

    Cheers

  3. #3
    Senior Member
    Join Date
    Oct 2002
    Location
    netherlands
    Posts
    334
    Thanks
    0
    Thanked 9 Times in 9 Posts

    Default

    Disable disk caching on disk storage pools for api backups like db2/oracle

  4. #4
    Member
    Join Date
    Nov 2008
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Blog Entries
    1

    Default

    We use diskpool for backup & next pool is tapepool with enough scratch tape assigned.And also we don't have caching on diskpool.Any other suggestions

  5. #5
    Senior Member
    Join Date
    Jul 2008
    Location
    Birmingham, UK
    Posts
    537
    Thanks
    0
    Thanked 5 Times in 4 Posts

    Default

    have you got a maximum size threshold set on the disk storage pool?

    post the output of "q stg <stgpool name> f=d" please.

    It could be that the db2 backup is larger than this value..

  6. #6
    Member
    Join Date
    Nov 2008
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Blog Entries
    1

    Default

    Maximum Size Threshold: No Limit

  7. #7
    Senior Member
    Join Date
    Dec 2009
    Location
    Sydney, Australia
    Posts
    384
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    So...can we assume the disk stgpool isn't big enough to contain the entire db2 backup? If so why not reassign the copygroup to use tape directly?

Similar Threads

  1. Replies: 5
    Last Post: 03-12-2010, 07:44 AM
  2. backup db failing.
    By LED888 in forum TSM Server
    Replies: 2
    Last Post: 10-12-2009, 10:59 AM
  3. DB2 backup failing due to error
    By newguy538 in forum Backup / Archive Discussion
    Replies: 7
    Last Post: 08-03-2009, 09:14 AM
  4. DB2 backup is failing
    By waire in forum DB2
    Replies: 11
    Last Post: 10-10-2006, 05:58 AM
  5. TSM backup of DB2 V8 64-bit database failing on AIX server with SQL2071N
    By bspiegel in forum Backup / Archive Discussion
    Replies: 0
    Last Post: 09-16-2004, 11:43 PM

Tags for this Thread

Posting Permissions

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