1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

db2 backup is failing

Discussion in 'Backup / Archive Discussion' started by dkarpe, Jun 22, 2010.

  1. dkarpe

    dkarpe New Member

    Joined:
    Nov 6, 2008
    Messages:
    43
    Likes Received:
    0
    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.  
  3. ChrisRees

    ChrisRees Senior Member

    Joined:
    Jul 24, 2008
    Messages:
    537
    Likes Received:
    13
    Occupation:
    Storage Management Person
    Location:
    Birmingham, UK
    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
     
  4. Jeroen

    Jeroen Senior Member

    Joined:
    Oct 2, 2002
    Messages:
    356
    Likes Received:
    12
    Occupation:
    AIX + storage administrator
    Location:
    netherlands
    Disable disk caching on disk storage pools for api backups like db2/oracle
     
  5. dkarpe

    dkarpe New Member

    Joined:
    Nov 6, 2008
    Messages:
    43
    Likes Received:
    0
    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
     
  6. ChrisRees

    ChrisRees Senior Member

    Joined:
    Jul 24, 2008
    Messages:
    537
    Likes Received:
    13
    Occupation:
    Storage Management Person
    Location:
    Birmingham, UK
    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..
     
  7. dkarpe

    dkarpe New Member

    Joined:
    Nov 6, 2008
    Messages:
    43
    Likes Received:
    0
    Maximum Size Threshold: No Limit
     
  8. TonyB

    TonyB Senior Member

    Joined:
    Dec 10, 2009
    Messages:
    384
    Likes Received:
    9
    Location:
    Sydney, Australia
    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?
     
: db2

Share This Page