Hi Scott,
Thanks for the feedback and the performance tunning links and tips.
The disk configuration is currently set up as a :
RAID-5 composed of 6 disks
I guess it might be worth while looking at possibly creating a MIRROR from 2
disks and then creating a RAID-5 from the remaining 4 disks. I will see if
we have the disk capacity to do this.
Scott, if i was living in the USA i would attend your seminar. However im
living in Australia. Would you consider doing a simultaneous Web Cast ?
Cheers
Michael
>From: "Scott Hayes" <[EMAIL PROTECTED]>
>Reply-To: "Scott Hayes" <[EMAIL PROTECTED]>
>To: "Michael Smith" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>CC: "Scott Hayes" <[EMAIL PROTECTED]>
>Subject: RE: [DB2EUG] tablespace page size question
>Date: Wed, 17 Apr 2002 01:13:55 -0400
>
>Michael,
>
>Indeed, you have very little memory to play with and might be best suited
>to
>using just one page size, especially if your queries might be joining on
>tables that are presently in 4K and 8K page sizes. __In a data
>warehouse__,
>measurable CPU and elapsed times savings can be achieved by putting table
>data and tempspace into the same bufferpool. From a presentation I gave
>last year at IDUG, here are some page size guidelines:
>
>Tables with small widths should use smaller pages sizes.
>* maximum 255 rows per page
>-- width < 16, use 4K
>-- width < 32, use 4K or 8K
>-- width < 64, use 4, 8, or 16K
>-- width > 128, use any page size
>
>So, you would be "harmed" by wasting disk space on 8K page sizes only if
>your table row widths are very small.
>
>Your email didn't mention your disk configuration. You can reduce some
>query elapsed times by 25% or more (when there is a sort) by simply
>ensuring
>that the TEMPSPACE tablespace is located on a disk separate from the data.
>For more hints and tips on sort and I/O tuning, attend IDUG North America
>session B4 "Cut Query Elapsed Times in Half: Sort and I/O Tuning".
>It's not quite as entertaining as the live presentation, but there's an
>article in DB2 Magazine that you might find helpful as well, see:
>http://www.db2mag.com/db_area/archives/2001/q4/hayes.shtml
>
>I don't think I've shamelessly plugged my IDUG Ed Seminar enough yet
>(grin),
>you can learn a whole bunch about making your DB2 UDB Linux, UNIX, and
>Windows databases go really fast by attending "Intimate Details:
>Performance
>and Design for DB2 UDB EE & EEE". See www.idug.org for details. Bring
>printed or electronic output from snapshots if you can.
>
>And, remember to get your DB2EUG sticker from DGI's IDUG booth #400.
>
>Kindest regards,
>Scott
>
>The fastest DB2 UDB databases on the planet do it with DGI. Running Siebel
>or Peoplesoft on DB2 UNIX? Join our rapidly growing customer list and
>double or triple your performance in a matter of hours. Visit
>http://www.breakthroughdb2.com/ for details. On call? DGI's Palm-GUY(TM)
>makes it possible to monitor, tune, and control any DB2 UDB Linux, UNIX, or
>Windows database from just about anywhere on the planet with the Palm VIIx
>wireless PDA. It's available NOW, just in time for summer vacations, beach
>weekends, picnics, and other "get a real life" events. Visit
>http://www.breakthroughdb2.com/hh.shtml
>
>
>
>
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
>Behalf Of Michael Smith
>Sent: Tuesday, April 16, 2002 10:22 PM
>To: [EMAIL PROTECTED]
>Subject: [DB2EUG] tablespace page size question
>
>
>
>Hello Group,
>
>I have a question to share with the group, regarding tablespace page
>size's.
>
>***********************************************************************
>
>Database Specifics :
>--------------------
> 5 GB in Size
> Running DB2 UDB 6.1 fp 9
> Windows 2000 O/S
> Replicating 500 tables.
> I have 320 MB of memory to play with.
>
>Database Purpose :
>------------------
> The users only issue select statements against the database (Read Only
>Database).
>
> However the database is updated every 30 minutes from the
> Mainframe using replication (apply loging onto the mainframe
> through a DB2 Connect Gateway and pulling down the updates ).
>
>Issue Faced :
>-------------
> 3 Tables require a tablespace page size of 8 KB.
> The other 497 fit in the 4 KB tablespace page size.
>
> Basically the row length of 3 tables is greater than the 4 KB
> page size.
>
>What i have done :
>------------------
> I created a 8 KB page tablespace to house these tables in.
>
> However this means that i also have to create :
>
> A TEMPSPACE of 8 KB
> A BUFFERPOOL of 8 KB
>
> This is in addition to the existing TEMPSPACE of 4 KB and
> BUFFERPOOLS at 4 KB
>
>My Question :
>-------------
> Since i dont have a lot of memory to play with, ive been
> tossing up whether or not :
>
> I should recreate all of the tablespaces at a 8 KB page
> size.
>
> This would mean that i wouldn't have different page sizes for
> the bufferpools and temp tablespaces. I also though that using
> a 8 KB page size would assist with the "Read Only" queries that
> are executed against the database by the users.
>
>************************************************************************
>
>I would like to get some feedback on what other DBA's in the industry have
>done and any recommendations you might have.
>
>I look forward to reading your responses.
>
>Regards
>
>Michael
>
>
>_________________________________________________________________
>Send and receive Hotmail on your mobile device: http://mobile.msn.com
>
>-
>::: When replying to the list, please use 'Reply-All' and make sure
>::: a copy goes to the list ([EMAIL PROTECTED]).
>*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
>*** For more information, check http://www.db2eug.uni.cc
>
>-
>::: When replying to the list, please use 'Reply-All' and make sure
>::: a copy goes to the list ([EMAIL PROTECTED]).
>*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
>*** For more information, check http://www.db2eug.uni.cc
_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
