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
