There's nothing quite like the smell of TSM database structure issues in the morning.Only run through this proceedure if you are sure you have DB structure issues.

Here are the instructions on running a dump/load/audit.
.
1. Make a copy of the following files:
- dsmserv.opt
- dsmserv.dsk
- volhist (volume history file)
- devconfig (device configuration file)
.
2. Set the following options in your dsmserv.opt file:
EXPINTERVAL 0
DISABLESCHEDS YES
NOMIGRRECL
.
3. Define a file devclass unless one is already defined if your server is down please add to the devconfig and ensure that the directory that this is written to has enough space to provide the format, the following example creates 10GB dump files, you will need to manually specify all these files in the future so ammend as appropriate.
e.g.-
DEFINE DEVCLASS FILECLASS DEVTYPE=FILE FORMAT=DRIVE MAXCAPACITY=100000000K MOUNTLIMIT=1 DIRECTORY="C:\TSMDATA" SHARED=NO
.
4. Stop the TSM server if it is still running.
.
5. From the c:\program files\tivoli\tsm\server1 directory run the
following:
.
..\server\dsmserv dumpdb devclass=FILECLASS
.
6. Next, format new TSM database volumes:
(Please run this from the c:\program files\tivoli\tsm\server1 directory)
.
..\server\dsmserv loadformat <# of log files> [repeat log file name and size according to the number] <# of dbvols> [repeat db vol name and size according to the number]
.
e.g. - ..\server\dsmserv loadformat 2 c:\tsmdata\log1.dsm 4000 c:\tsmdata\log2.dsm 5000 3 c:\tsmdata\db1.dsm 4000 d:\tsmdata\db2.dsm 7000 e:\tsmdata\db3.dsm 8000
.
7. Next, we need to load the TSM db via the following command run from
the same directory as above:
.
..\server\dsmserv loaddb devclass=FILECLASS volume= the dump>
.
8. Once the load is finished, we will need to run the audit via:
.
..\server\dsmserv auditdb fix=yes
.
9. Once the audit is finished, you can bring up your TSM server and attempt to run "expire inventory". If that runs fine, please bring down your TSM server and remove the 3 lines that were added to your dsmserv.opt file and then please restart your TSM server.

Thanks

Ryan Partington