ADSM-L

Preallocated Diskstorage for DB2 compressed Data

2006-02-10 03:04:03
Subject: Preallocated Diskstorage for DB2 compressed Data
From: Michael Garnebode <GARNEBOD AT DE.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 10 Feb 2006 09:03:36 +0100
Good Morning,

i have found two inquiries for the problem in adsm-l but no answer and
no clue in the quick facts.

The customer have many udb databases and his strategie is to  backup all
udb first to diskstoragepools.
He use compression "on" at the client side but in some situations the
diskstorage is full
and the backup goes directly to tape. The compressed data is lesser than
the storagepoolsize.
I think the problem is the preallocation for the databasebackup (db2) .

Must the size for the diskpool the same as the db2 database ?

Any idea or tips ?

kind regards
Michael Garnebode