Extend dbspace

[frankantony]

Hi All,

I have extended the dbspace two weeks back with /tsmdb005,tsmdb006. But it has not yet used by DB.It is using the old file systems . Please advise what we have to do manually.

Location Total Space(MB) Used Space(MB) Free Space(MB)
------------------------------ --------------- --------------- ---------------
/tsmdb001 75,595.01 65,332.39 10,262.61
/tsmdb002 75,595.01 65,332.41 10,262.60
/tsmdb003 75,595.01 65,332.43 10,262.57
/tsmdb004 75,595.01 65,332.38 10,262.62
/tsmdb005 74,587.07 3,968.57 70,618.50
/tsmdb006 74,587.07 3,968.57 70,618.50


server version Storage Management Server for Linux/x86_64 - Version 6, Release 3, Level 2.0


/dev/mapper/vg01-lv_tsmdb001
74G 61G 11G 86% /tsmdb001
/dev/mapper/vg01-lv_tsmdb002
74G 61G 11G 86% /tsmdb002
/dev/mapper/vg01-lv_tsmdb003
74G 61G 11G 86% /tsmdb003
/dev/mapper/vg01-lv_tsmdb004
74G 61G 11G 86% /tsmdb004
/dev/mapper/vg01-lv_tsmdb005
73G 180M 69G 1% /tsmdb005
/dev/mapper/vg01-lv_tsmdb006
73G 180M 69G 1% /tsmdb006

Thanks,
Frank

 

[rowl]

From what I have read there isn't anything you need to do to make this work, so I would be very curious if you discover otherwise. Did you use the reclaimstorage option when you did the extend dbspace? The only other thing that comes to mind would be that the TSM instance user doesn't have permissions on the new file systems.
-Rowl

 

[rgg]

From what I have read there isn't anything you need to do to make this work, so I would be very curious if you discover otherwise. Did you use the reclaimstorage option when you did the extend dbspace? The only other thing that comes to mind would be that the TSM instance user doesn't have permissions on the new file systems.
-Rowl

http://www-01.ibm.com/support/docview.wss?uid=swg1IC78489

After an extend, you should do a rebalance/reduce to actually use the newly defined space. These operations can be completed with the server online and are generally pretty quick.

 

[frankantony]

HI Rowl,
Thanks for the quick reply. I just used the exdend dbspace command and no othere changes done. The file permissions are same as old file systems.

extend dbspace /tsmdb005,/tsmdb006
ANR2592I Directory(ies) '/tsmdb005','/tsmdb006' has been defined in the database space.

[root@ ~]# ls -ld /tsmdb001
drwxr-xr-x. 4 tsminst1 tsmsrvrs 4096 Jul 25 2012 /tsmdb001
[root@ ~]# ls -ld /tsmdb002
drwxr-xr-x. 4 tsminst1 tsmsrvrs 4096 Jul 25 2012 /tsmdb002
[root@ ~]# ls -ld /tsmdb003
drwxr-xr-x. 4 tsminst1 tsmsrvrs 4096 Jul 25 2012 /tsmdb003
[root@ ~]# ls -ld /tsmdb004
drwxr-xr-x. 4 tsminst1 tsmsrvrs 4096 Jul 25 2012 /tsmdb004
[root@ ~]# ls -ld /tsmdb005
drwxr-xr-x 3 tsminst1 tsmsrvrs 4096 Jul 1 03:27 /tsmdb005
[root@ ~]# ls -ld /tsmdb006
drwxr-xr-x 3 tsminst1 tsmsrvrs 4096 Jul 1 03:27 /tsmdb006

Frank.

 

[frankantony]

Hi rgg,

Thanks for the reply. Shall i follow the given steps. Or need to check with IBM before updating the database ?.

Frank.

 

[frankantony]

Hi rgg,

Can we perform the steps while backup running. Or need to stop all the backup and do while tsm instance online. Pl confirm

 

[rgg]

Hi rgg,

Can we perform the steps while backup running. Or need to stop all the backup and do while tsm instance online. Pl confirm

Your call if you want to check with IBM. I've done the process with the server running before, but it's probably not a bad idea to stop as much server activity as possible as it does move the database around, which takes significant resources to do and can impact other operations.

 

[anyeraz]

Hi all,

My TSM db utilization has reached 80% usage. I have ran extend dbspace for 2 new volumes. The thing is I just notice that I created a TEIR 3 fs for the new db space instead of TEIR 1. So anybody know how to remove the new created db vol location?

Thanks

 

[rgg]

Hi all,

My TSM db utilization has reached 80% usage. I have ran extend dbspace for 2 new volumes. The thing is I just notice that I created a TEIR 3 fs for the new db space instead of TEIR 1. So anybody know how to remove the new created db vol location?

Thanks

There is no remove dbspace. You'll have to follow the instructions in the manuals for "moving the database"...which includes a restore db.

 

[moon-buddy]

Hi all,

My TSM db utilization has reached 80% usage. I have ran extend dbspace for 2 new volumes. The thing is I just notice that I created a TEIR 3 fs for the new db space instead of TEIR 1. So anybody know how to remove the new created db vol location?

Thanks

You have a similar posting - I answered this.

http://adsm.org/forum/showthread.ph...te-the-new-db-diretories-after-extend-dbspace

 

[booman55]

Moving forward you might want to consider just increasing the size of the existing file systems.

 

[[email protected]]

extend dbspace - rebalancing is supported by TSM 7.1

Moving forward you might want to consider just increasing the size of the existing file systems.

Hi all,

just for your information:

the rebalancing of new DB2 directories which are added via "extend dbspace", is now supported by TSM 7.1.

I tested it already and it works fine

rgds Michael