By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,004 Members | 1,253 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,004 IT Pros & Developers. It's quick & easy.

Db2 Create Tablespace Performance Impact

P: 2
Anybody know why db2 heavily affect it's performance by DMS (using file) tablespace creation? During the creation process, almost all db2 activities pending...

Besides, the disks where the tablespace located always 100% busy at that time.

Platform: AIX 5.3
db2level V8.2 fixpak 12
Nov 8 '07 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 297

when defining a new DMS tablespace based on a file, DB2 will create that file up to the defined size and format it internally with the structures/informations needed by DB2 itself. This causes a lot of disk I/O, slowing down all other processes.

Regards, Bernd
Nov 8 '07 #2

P: 2
Besides, I think the most influence factors for this slowdown due to latch and resources contention. I started a trace and here the findings:

1. Other new coming db2 connect request hang up and waiting for the latch held by "create tablespace" application until finish.

2. Other db2 application performing "create table" will wait for Memory Map synchronization until the "create table" application finish.

Is there anyone know IBM DB2 team aware of this or how to resolve it?
Nov 13 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.