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
