db2 backup is failing

[dkarpe]

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

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

[ChrisRees]

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

[Jeroen]

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

[dkarpe]

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

[ChrisRees]

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..

[dkarpe]

Maximum Size Threshold: No Limit

[TonyB]

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?