How do,
Have you run statistics on the tables that you've loaded? If not DB2 might not choose the most optimal path for verifying the loaded data. We had a set integrity that took days to run; this fell to a couple of hours after a runstats.
Cheers,
Mark Savin
DBA
Euler Trade Indemnity
-----Original Message-----
From: Shi, Zhong [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, January 09, 2003 4:47 PM
To: [EMAIL PROTECTED]
Cc: '[EMAIL PROTECTED]'
Subject: [DB2EUG] How to Improve Performance of Setintegrity ?
List Experts,
After loading data onto data warehouse, we have to run the setintegrity.
There are only three tables that have foreign key on them but the
setintegrity runs more then one week. What are the possible ways to tune the
system so that the setintegrity run faster? What resources are used by the
setintegrity? Or generally and internally how the setintegrity work?
System: UDB v7.2, AIX4.2, RS/6000.
Temp Tablespace: 147365 4k pages
Temp Tablespace Bufferpool 1000 4k pages (I know, this looks bad :-)
Index Tablespace Bufferpool: 8192 8k page
Data Tablespace Bufferpool: 8192 8k page
When I look at the monitor, here what I see:
Total Sort Time (ms) 767,070,270.0
Sort Overflow (%) 18.85
Average Sort time (ms) 35,081.46
Synchronous I/O time (ms) 766,935,810.0
Your advice are highly appreciated.
Thanks
Zhong Shi
DBA
Incepture, Inc
-
::: 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
