Christo, Can you teel what sql query is running? I know some queries are really terrible, especially 'select * from volumeusage". Is there some options in the TDSSMA to limit what queries are done?
I run a large tsm erver on OS/390 also. I can do a select of all the occupancy data in 9 minutes elapsed time. I can't compare the performance with w2k or aix because I don't run those servers, but I am happy with the perfromance on os/390. But I agree with you about TDSSMA - if it drives the server crazy it isn't a good product. At 12:53 PM 1/23/2002 +0200, you wrote: >Hi, > >Are there any of you guys/gals that are running TDS for SMA? >If you are - what kind of TSM server are you running: >Platform and size of database being the ones I'll be interested >in. >We are busy evaluating the TDSSMA modules and are experiencing >bad performance on our biggest TSM server - for those of you >that are familiar with the product - when the TDS Loader runs it >consumes about 24% of our OS/390 CPU for 28hours - the load is still >not finished. This makes the whole TDS product useless to us. > >It is fine for our smaller TSM environments but it does not help >getting different products for the smaller and bigger environments. >To me it seems like the usefullness of this product or any other >product that will be running SQL queries into your TSM db is severly >impacted by the size of your TSM environment - coming back to the >scalability of TSM's proprietary "black box" DB! > >Have any of you noticed this or do we need to look at other things. >My opinion of TSM on OS/390 is that it performs worse on OS/390 than >AIX or I'll even be as bold to say Win2K ;-) > >Thanks for any input. > >Regards >Christo Heuer ---------- Bill Colwell C. S. Draper Lab Cambridge Ma.