Re: Maximum database volumes?

2004-07-09 Thread Paul Ripke
On Friday, Jul 9, 2004, at 11:11 Australia/Sydney, [EMAIL PROTECTED] wrote: == In article [EMAIL PROTECTED], Paul Ripke [EMAIL PROTECTED] writes: With any disk and controller technology that supports command queuing (SCSI2 command tagged queuing, SATA Native Command Queuing (NCQ)), you are better

Maximum database volumes?

2004-07-08 Thread Gordon Woodward
Before I upgrade our TSM server to v5.2 (seems to be taking forever to do due to small outage windows) I want to reorganise our database volumes so they are a little more efficient. Is there any recommended maximum number of database volumes a TSM database should have? Ours is spread across

Re: Maximum database volumes?

2004-07-08 Thread Christo Heuer
Performance and Tuning documentation states it should not be more than 13 Volumes - not too sure how you achieve that in the mainframe world where you have 2.835Gig disks - (Mod3's). Most shops don't really have access to mod9's, so then from a performance guide point of view you can not really go

Re: Maximum database volumes?

2004-07-08 Thread John Naylor
Re: Maximum database volumes? 08/07/2004 07:19 Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] .edu Performance and Tuning documentation states it should not be more than 13

Re: Maximum database volumes?

2004-07-08 Thread Christo Heuer
.edu Re: Maximum database volumes? 08/07/2004 07:19 Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] .edu Performance and Tuning documentation states

Re: Maximum database volumes?

2004-07-08 Thread John Naylor
: [EMAIL PROTECTED] Dist Stor cc Manager [EMAIL PROTECTED] Subject .edu Re: Maximum database volumes? 08/07/2004 13:55

Re: Maximum database volumes?

2004-07-08 Thread asr
== In article [EMAIL PROTECTED], Gordon Woodward [EMAIL PROTECTED] writes: Before I upgrade our TSM server to v5.2 (seems to be taking forever to do due to small outage windows) I want to reorganise our database volumes so they are a little more efficient. Is there any recommended maximum

Re: Maximum database volumes?

2004-07-08 Thread Paul Ripke
On Friday, Jul 9, 2004, at 01:36 Australia/Sydney, [EMAIL PROTECTED] wrote: == In article [EMAIL PROTECTED], Gordon Woodward [EMAIL PROTECTED] writes: Best recommendation: try to keep your volumes on a 1:1 basis with your physical spindles. It's the best possible way to convey to TSM what the

Re: Maximum database volumes?

2004-07-08 Thread asr
== In article [EMAIL PROTECTED], Paul Ripke [EMAIL PROTECTED] writes: With any disk and controller technology that supports command queuing (SCSI2 command tagged queuing, SATA Native Command Queuing (NCQ)), you are better off with about 3 volumes per spindle for random I/O. TSM serialises