Paul, Where do you get the figure 33MB/sec?
11000MB / 7200sec = 1.53MB/sec Regards, David Smith AIX Administrator Corporate Express Australia -----Original Message----- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Thursday, 14 March 2002 3:53 PM To: [EMAIL PROTECTED] Subject: Re: Reorg your database The database is blocked at 4K. I doubt what you are saying is true. Simply, the database disk will never run at 33MB/sec. It really depends on how your tape and disk are configured. -----Original Message----- From: Michael, Monte [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 10: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 67-77 Epsom Rd Sydney NSW PH 02 93350318 or 0412 258 208 -----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]
