Tim, We are generally using one table per tablespace in Unix with some exceptions. Some of the advantages that come to mind are:
1. Gives you better control of bufferpool assignment and utilization per tablespace. For DMS tablespaces, you can assign the index(s) to their own tablespace and take advantage of dedicated bufferpools. 2. If you use Autoload to load data into a table, that tablespace will end up in Load Pending/Backup Pending state which restricts the access to any other tables in the tablespace 3. Backup/restore to/from a tablespace I'm sure others can add to this list. However, in cases such as CODE Tables, since they are many and small, we have put them all in their own tablespace and assigned the right size bufferpool so the entire thing is always kept in the memory. They are after all, more or less, read-only tables. Hope this helps. >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: [EMAIL PROTECTED] >Subject: [DB2EUG] Many tables per tablespace versus one table per >tablespace >Date: Thu, 25 Apr 2002 16:26:56 -0500 > >Hello List, > >We currently have several UDB databases on both NT and AIX, but all of the >databases are used >in conjunction with a third party application that we purchased from some >other company. The databases >were installed with the software and therefore a majority of the tables >reside in the default userspace1 >tablespace. When we have had a reason to restore from a backup we have >just restored the entire >database rather than individual tablespaces. Now we are developing an >in-house application on >AIX and I am wondering what types of strategies do other UDB DBAs implement >when new applications >are being developed in-house. On the S/390, we put one table per >tablespace. Should the same type >of strategy be used in the distributed environment. When making this >decision, what do I need to consider >from a recovery point of view? Am I missing anything else that I need to >consider as well? > >As always, any input on this is appreciated. > >Thanks, >Tim Traxson >[EMAIL PROTECTED] >479-820-8811 > > > > >- >::: 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 _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - ::: 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
