Database error

[aroon_e]

Hi,

I am getting this error continuously in our Tivoli server.Can any one help me on this ?

ANR4430W Unable to Define Data Base Volume c:\tsmdata\server1\D2997341.DBV.
ANR4415I Data Base and Recovery Log Space Expansion Completed.
ANR4414I Data Base Space expansion Is Needed, 12288 Megabytes needed.
ANR4412I Data Base and Recovery Log Space expansion triggered.
ANR7820W Insufficient Space Available for file
c:\tsmdata\server1\D2997341.DBV.


Aroon

 

[nezih]

there is no available space on c:\ drive...

 

[aroon_e]

Hi,

I have the following files in c:\tsmdata\server1\ and only 898 MB free space.

D0303078.DBV 50 MB
D1333340.DBV 6 GB
D1761860.DBV 1.5 GB
D2482078.DBV 25 MB
D5253078.DBV 99 MB
D5792229.DBV 767 MB
D6588771.DBV 3.14 GB
D6844078.DBV 197MB
D6972078.DBV 13 MB
D7748378.DBV 394MB


Can i delete or move the files to some other drive?

 

[nezih]

yes you've need that... but you'll need to do this on tsm, not on oS

 

[aroon_e]

Hi,

Can you tell me the steps or command to do that ?

Aroon

 

[mateinone]

Just define a volume somewhere else if you cannot add space to that filesystem. what is a qb showing? what is your spacetrigger set at?

 

[aroon_e]

Hi,

My spacetrigger is given below.

Begin expansion at this percentage of capacity 90 %
Expand the database by this amount (0-200 percent) 125%


Do you need my q db ?

Aroon

 

[heada]

In order to move your TSM database from one drive to another:

- Find a drive that has enough free space to hold the database.
- Define DB volumes on the new drive (either through the define command or dsmfmt and then define)
- Delete the previous DB volumes from within TSM. TSM will move all the data from the old volumes to the new volumes. Do NOT delete the DB volume file from the OS without doing it in TSM.
- Once your database has been moved and you perform a full DB backup, delete the old DB volumes from the OS.
- If you have one, update your spacetrigger so that it creates DB volumes on the new drive.

-Aaron