MVSFORUMS.com

NASCAR9 · Posted: Fri May 27, 2005 1:22 pm Post subject: Partitioned Vs Standard table

I am looking for advice on the advantages/disadvantages regarding the use of partitioned versus standard table spaces. These tables will have approximately 5 to 20 million rows and have approximately 1,000,000 queries and 50,000 inserts/updates daily. These databases will be on a z/800 at 80 MIPS. Performance (obviously) is the number one priority. The IBM manuals lead us in one direction, but real world experience is usually better than what is stated in a manual. Any advice here would be appreciated.
Thanks
NASCAR9

superk · Advanced Joined: 19 Dec 2002 Posts: 684 Topics: 5

NASCAR9 - A Kasey Kahne fan perhaps??

NASCAR9 · Posted: Fri May 27, 2005 1:31 pm Post subject:

superk - Bill Elliott, then Kasey Kahne, been a NASCAR fan since early 80's.
_________________
Thanks,
NASCAR9

kolusu · Posted: Fri May 27, 2005 4:24 pm Post subject:

NASCAR9,

Check this link which might answer some of your queries.

http://www.mainframeweek.com/journals/articles/0063/DB2+tablespace+options,+part+2

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

NASCAR9 · Posted: Tue May 31, 2005 2:47 pm Post subject:

Thanks kolusu,
I did notice the article was written in 2003(although plenty of good information). Do you think Ver. 8 will be any different?

NASCAR9

kolusu · Posted: Tue May 31, 2005 2:55 pm Post subject: