I have a UDB DB2 V9 fixpack4 database. It has automatic storage enabled for its tablespaces. Each tablespace has two containers one conatiner per file system.It is using two file systems. Unfortunately 90% of the data is going to one file system and 10% to other file system.
What can i do to redistribute my tablespace data across these two file systems equally.
PS: I think DB was created with one automatic storage path initially and then second storage was added.
i don't see a rebalance command
best would be unload table-drop table-reload table
have you defined different strip set - otherwise ts are auto rebalanced
see : Rebalancing DMS containers
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be
koganti, I think one storage path was defined at create database time and new storage path was added later, because DB2 if using automatic storage automatically balance disk space according to defined storage paths. If new storage path is added, then DB2 will not rebalance disk storage, because this would greatly influence performance. DB2 ensures that a rebalance will never take place as part of an auto-resize.
I think (not 100% sure) the rebalance will be in place if using backup/restore. This can be easily tested. Make a backup and restore database to test computer.
If I remember correctly "rebalancing DMS container" does not work with automatic storage.