Multiple Tablespaces - DB2 Database

Christos Kalantzis

Hi Everyone,

I have a question about tablespaces....

Does having Multiple tablespaces (ie..one for indexes, one for large
tables and one for smaller tables) realy help out performance
considering my containers are all on the same disks?

Does the performance out-weigh the complexity of the design/maintenace
of the database?

DB2 8.2 Express
Suse Linux 9.2
Dual CPU
4GB RAM
Thanks a lot,
Christos

Nov 12 '05 #1

Subscribe Post Reply

1723

Mark A

"Christos Kalantzis" <ch*******@intertrade.com> wrote in message
news:VHOGd.106385$dv1.30541@edtnps89...

Hi Everyone,

I have a question about tablespaces....

Does having Multiple tablespaces (ie..one for indexes, one for large
tables and one for smaller tables) realy help out performance
considering my containers are all on the same disks?

Does the performance out-weigh the complexity of the design/maintenace
of the database?

DB2 8.2 Express
Suse Linux 9.2
Dual CPU
4GB RAM
Thanks a lot,
Christos

It might help a little to have indexes on a different tablespace than the
table. Disk drives do have more than one platter/read-write head. A lot
depends on your bufferpool hit ratio (usually a function of the bufferpool
size). If you aren't doing much synchronous I/O, then tablespace
configuration tuning is vastly over-rated.

Nov 12 '05 #2

Similar topics

Partitioning and Tablespaces

by: CK | last post by:

Need a piece of advice on allocation of tablespaces for partitioning We are using a day level range-based approach as our parititiong scheme given that we have data inflows running into 15...

Oracle Database

Used Space for Tablespaces ESE/DPF

by: Joachim Mueller | last post by:

Have written a litte sql for showing the utilization of the tablespace. (found it within the newsgroup from Paul Vernon). Looks fine for an one Partition System only. But how i can I see on which...

DB2 Database

Multiple temp tablespaces with same page size

by: mike_dba | last post by:

Can anyone tell me why a EEE system might be created to have two separate tablespaces with the same 4k pagesize ? They both appear to be in use as I can see the underlying files being modified. ...

DB2 Database

Multiple Temp Tablespaces

by: sethwai | last post by:

Hi, A friend of mine inheritted a system that had 2 4k temp tablespaces each assigned to a different bufferpool. This brought up a number of questions for me. 1) Does anyone know in general...

DB2 Database

Creating Tablespaces : Best Practices

by: rAinDeEr | last post by:

Hi, I am trying to create around 70 tablespaces for around 100 tables.. Am using DB2 UDB 8.2 in Linux environment... This is one i generated through Control centre.... CREATE REGULAR...

DB2 Database

List tablespaces work, but not SQL

by: dcruncher4 | last post by:

DB2 8.2.3 the task I have is to write a script to restore a database from a backup on to another machine. the backup can be as old as seven years. The container layout on the machine to be...

DB2 Database

multiple tablespaces containers on SAN

by: paul | last post by:

Hi, i want to know if this is better to split a tablespace into several containers while the database are on san disk. And how can i configure optimally the values for prefetch and extend ? thx

DB2 Database

Automatic Storage ### How I need to expand the DMS tablespaces manualyy##

by: beena | last post by:

All, I'm new to the concept of automatic storage... I'm looking at the database setup by a vendor. I see few tablespaces showing up with automatic storage - Yes. Tablespace ID ...

DB2 Database

Should system temporary tablespaces generally be on automaticstorage?

by: Troels Arvin | last post by:

Hello, I have recently run a rather large data import where the imported data i pumped through some updatable views equipped with INSTEAD OF triggers. For various reasons, the exact same data...

DB2 Database

Access Europe meeting on Wed 4 Oct - The future of Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

How to find best mobile app development company in usa

by: Aliciasmith | last post by:

In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...

Mobile Development

Can faster file sharing be achieved by connecting computers simultaneously via WiFi and LAN cables

by: tracyyun | last post by:

Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...

Networking - Hardware / Configuration

Energy Model code modification to account for year dependent interest rate

by: giovanniandrean | last post by:

The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...

Python

VBA Class Basics

by: NeoPa | last post by:

Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...

Microsoft Access / VBA

Access Europe Meeting - Wed 1 Nov - Using SQL Server skills to extend Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...

Microsoft Access / VBA

Finding a record, and then saving a new record after the record has been amended.

by: nia12 | last post by:

Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...

Microsoft Access / VBA

VBA Class Basics (Report Class)

by: NeoPa | last post by:

Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...

Microsoft Access / VBA

Take a Database to the Next Level

by: GKJR | last post by:

Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

Microsoft Access / VBA