interview question

[shaik]

If tsmDB reaches 100%. What can you do?

 

[erwanns]

Extend it !

 

[s_abrey]

Identify and delete redundant data and run a expiration on the nodes in question.

or

Extend it.

 

[TiborB]

TSB DB utilization is what 'q dbspace' gives? Then I would

a) enlarge filesystem
b) delete unneeded files from the filesystem.

As far as I understand there is no artifical limit for TSM DB, only the available space on particular filesystem (disk). Or am I wrong?

 

[eddytrio]

Extend the DB either by adding more space on the existing filesystem or on a new filesystem.

 

[Efim]

Hi
Usually adding space to TSMDB when it reaches 100% can't help without manual rebalance DB2 tablespaces.
Efim

 

[tsm_dude]

extend all DB filesystems the same amount, so they all have the same amount of free space.