Michael, I ran the db unload to a file device class. I set the max capacity to a value greater than the database size so that it only ran to one volume. I did have trouble on 4.1.2 when it reached the EOV of the first file volume.
Havn't tried it to a disk (random access) device. Regards, David Smith AIX Administrator Corporate Express Australia -----Original Message----- From: Michael, Monte [mailto:[EMAIL PROTECTED]] Sent: Thursday, 14 March 2002 2:26 AM To: [EMAIL PROTECTED] Subject: Re: Reorg your database Dave, Can you unload the TSM database to a disk volume? I have always unloaded to a 3590 tape drive. Disk would be much faster.. Monte -----Original Message----- From: David Smith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:35 PM To: [EMAIL PROTECTED] Subject: Re: Reorg your database Mark, I've just unloaded/loaded our TSM 4.1.5 database to fix performance problems. Our 18GB database shrank to 11GB and a 'query archive' that used to run for over an hour now takes 10 seconds. It took 4 hours to dump (to a fileclass volume) and 2 hours to load on an RS/6000 6M1 but it was mostly I/O so I don't think the speed of the machine helped all that much. I did have a failure running it on 4.1.2 server as it locked up when changing from one file volume to another. I updated to 4.1.5 and made the fileclass max volume size 20GB. The unload then ran fine to the one file volume. Regards, David Smith AIX Administrator Corporate Express Australia -----Original Message----- From: Mark Hayden [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 13 March 2002 7:22 AM To: [EMAIL PROTECTED] Subject: Reorg your database Hello, I have been checking into and reading e-mails from here regarding reorganizing your database. It sounds like this should be done every so often. We have some problems that I believe this may fix, but am a little bit nervous and have not done so. My question is ( for people who have ran this) How has it worked for you and do you run this as a procedure, or only when you think the DB is fragmented or in need. Maybe how difficult is the procedure, and any do's and don'ts......Thanks for your help! Thanks, Mark Hayden Network Administrator E-Mail: [EMAIL PROTECTED]
