Author: Mark Hayden <MHayden AT EPA.STATE.IL DOT US>
Date: Tue, 12 Mar 2002 14:21:49 -0600
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 f
Author: David Smith <david.smith AT CE.COM DOT AU>
Date: Wed, 13 Mar 2002 09:35:24 +1100
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 t
Author: Mark Hayden [mailto:MHayden AT EPA.STATE.IL DOT US]
Date: Sun, 04 Oct 2015 17:10:42 -0500
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 f
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
Author: David Smith [mailto:david.smith AT CE.COM DOT AU]
Date: Sun, 04 Oct 2015 17:10:42 -0500
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 t
Author: David Smith <david.smith AT CE.COM DOT AU>
Date: Thu, 14 Mar 2002 12:10:33 +1100
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 th
Author: "Seay, Paul" <seay_pd AT NAPTHEON DOT COM>
Date: Wed, 13 Mar 2002 23:52:57 -0500
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.
Author: Seay, Paul [mailto:seay_pd AT NAPTHEON DOT COM]
Date: Sun, 04 Oct 2015 17:10:42 -0500
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.