|
Hi
Environment: DB2 v9.5 Workgroup edition on Windows 2003. the tablespaces are in a SAN storage.
I am processing about 10 million records in one maintable and about 12 million in another in my database. Data is being gradually added to these tables. There are some SQL procedures that work on these tables and populate other set of tables (some of which could have as many records as these main tables).I have noticed a drastic slowness in the system performance in the last couple of days. The procedures that used to take about 2 - 4 minutes seem to take about 2 hours now. I run reorg-runstats regularly. I have noticed that the reorg process is taking a long time to complete. The reorg on the table with 10million is taking about 40 minutes. Though I have not exactly noted the timings before, it used to take about 5-10 minutes for the table when it had 8 million records. Is the time taken now for reorg an expected one? 40 minutes for a table with 10 million records? Somebody suggested that this could indicate that somthing is wrong with the database. The only change that I recollect in the environment is that the SAN storage where the tablespaces are created have been extended.
How and where do I start checking to find the cause for this?
Thanks.
Rajesh
| 
