Problem in executing EXTEND DBSPACE command

[neel]

Hi,
I am new to TSM & have an issue on running TSM v6.1.2 on linux. It is showing db 93.5% full. I have used EXpand DBspace command in its format to allocate more space, butthe command is not running successfully. Please tell me if there is any other command or how to expand the space.

The following is the output of command "q db f=d"
Database Name:TSMDB1
Total size of file system(MB):508913
Space used by Database(MB):448
Free space available:29440
Page Size(Bytes):
Total Pages:32776
Usable Pages:32640
Used Pages:25776
Free Pages:6864
Buffer Pool Hit Ratio:99.3
Total Buffer Requets:2612437
Sort Overflows:0
Lock escalation:0
Package Cache hit Ratio:96.1
Last Database Reorganization:02/09/2010 02:29:25 PM
Full Device Class Name:
Incrementals Since Last Full:0
Last Complete Backup Date/Time:

Kindly give me some suggestions.
Thanks & Regards

 

[lhcat]

Hi,

please post the output of

q db
q dbspace

What error did the "extend dbspace <extra_directory>" give ?

 

[mikeatkc]

Hi,
I am new to TSM & have an issue on running TSM v6.1.2 on linux. It is showing db 93.5% full. I have used EXpand DBspace command in its format to allocate more space, butthe command is not running successfully. Please tell me if there is any other command or how to expand the space.

The following is the output of command "q db f=d"
Database Name:TSMDB1
Total size of file system(MB):508913
Space used by Database(MB):448
Free space available:29440
Page Size(Bytes):
Total Pages:32776
Usable Pages:32640
Used Pages:25776
Free Pages:6864
Buffer Pool Hit Ratio:99.3
Total Buffer Requets:2612437
Sort Overflows:0
Lock escalation:0
Package Cache hit Ratio:96.1
Last Database Reorganization:02/09/2010 02:29:25 PM
Full Device Class Name:
Incrementals Since Last Full:0
Last Complete Backup Date/Time:

Kindly give me some suggestions.
Thanks & Regards

I think it's just "extend db <SIZE>" so to increase DB size by 500MB, just do "extend db 500" but do "help extend db" for more details in TSM 6.x.

 

[jbautista]

I think it's just "extend db <SIZE>" so to increase DB size by 500MB, just do "extend db 500" but do "help extend db" for more details in TSM 6.x.

hi mike,

no more "extend db" command in tsm 6.x.

extend dbspace command is used to extend only the directories of where to write the db. refer to admin guide. there is a part in there that discuss how to extend the database


thanks

 

[mikeatkc]

hi mike,

no more "extend db" command in tsm 6.x.

extend dbspace command is used to extend only the directories of where to write the db. refer to admin guide. there is a part in there that discuss how to extend the database


thanks

Sure enough, "extend dbspace <DIR>" in the Administrative book. I tinkered a bit with 6.2.x.x and thought a few query commands change, but guess it's more than that. More commands to adapt.