Does Extend dbspace works ?

[fretof]

I want to extend my dbspace, not much space left. So I extend dbspace to a new raid disk but I can´t see that TSM is using the new dbspace.


tsm: >q db
Database Name Total Pages Usable Pages Used Pages Free Pages
-------------- ------------ ------------ ------------ ------------
TSMDB1 14,337,028 14,336,892 14,327,880 9,012

tsm: >q dbs
Location Total Space(MB) Used Space(MB) Free Space(MB)
------------------------------ --------------- --------------- ---------------
E:\tsmdata\db 286,069 271,625 14,444
d:\tsmdata\db 286,069 522 285,547

TSM has created a server1 library but it seems like TSM not stores db there.

Can I force TSM to use the newly extended space ?

[sandeepkontham]

what is q dbs? and what is TSM created a server1 library???

[sandeepkontham]

to extend DBspace

first define dbvolume

define dbvolume \path\xxxx.db formatsize=xxxMB
then extend it
extend db xxxmb

[fretof]

We have version 6.2 installed and that use IBM DB2.
def dbvol doesn´t work in 6.x version.

[sandeepkontham]

oops sorry i thought it at 5.x

[JeanSeb]

Hi,
I remember reading from the IBM documentation that it can take up to a few weeks for the DB to extends it containers to the new allocated space. I suppose it's the way DB2 works.

[fretof]

Ok,
I extend the dbspace this several months ago so then it should worked now.
I have heard from a IBM presentation that DB2 use the extended dbspace only if it will be better performance for the database.

[mladams]

We also used created a new dbvolume and used extend db on a 6.2.3 server. This was done 5 weeks ago and the dbvolume is still not being utilized and the other 4 volumes have grown to 96% full. We opened a ticket w/ IBM and they found nothing amiss but did send the following links to us: http://www-01.ibm.com/support/docvie...id=swg21438315 and http://www-01.ibm.com/support/docvie...id=swg21399504

[baranp]

If not already done so, review IBM apar IC78489. It describes a work-around to use the additional space added by the EXTEND DB command. See if it applies to your case.

Regards.