Hi Stef If you changed such amount of data I am quite sure that db2 realized during runstats that it should perform some reorg. As its not done during deletion but after you see impact on db2 a bit afterwards. Regards Krzysztof
2015-12-11 11:52 GMT+01:00 Stef Coene <[email protected]>: > On Friday 11 December 2015 10:22:55 you wrote: > > 16 Power8 cores(at least 3.42 GHz) and 192 GB to handle 1000 TB of backup > > data? One would think there was a potential for code efficiency > improvement. > I have a copy of our production TSM running on a standby TSM server. > I remove almost all filespace data (don't ask why) and DB2 (not dsmserv > process) is constantly eating 2 a 3 Power7 CPU's. > And I have no idea why......... > > > Stef >
