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]
Re: Reorg your database
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]
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]
Re: Reorg your database
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]
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]
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]
Re: Reorg your database
Mark, There is a little equation I use to figure out what the difference between reality and what TSM thinks.. Try this: DB Assigned Capacity - ( DB Assigned Capacity ) * DB Pct Util ) Remember your calculating MB(s) Hope this helps, works for me~ Gabriel C. Wiley ADSM/TSM Administrator AIX Support Phone 1-614-308-6709 Pager 1-877-489-2867 Fax 1-614-308-6637 Cell 1-740-972-6441 Siempre Hay Esperanza David Smith [EMAIL PROTECTED]To: [EMAIL PROTECTED] OM.AU cc: Sent by: ADSM: Subject: Re: Reorg your database Dist Stor Manager [EMAIL PROTECTED] .EDU 03/12/2002 05:35 PM Please respond to ADSM: Dist Stor Manager 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]