when i do offline reorg it takes 3.5 hours
after that when i checked actual reorg done on each table and sum the time taken to reorg the each table..its actualy only (1/2)half an our..


for reorg tiime taken...i used the command


db2pd -d <dbname> -reorg


please help me why this time difference

can you state in more detail which timing you collect for which operation and how you get to the statement..

Ex:

Complete time taken for 4 table (A,B,C,D) in db1.

i scheduled the cronjobs for this and get the email for successfull completion.
its getting after 3 hours(No delay in mail).


After this i checked for each table by using "db2pd -d <dbname> -reorg"
it gives

Address TableName Start End


1 A 09/26/2011 04:32:12 09/26/2011 04:32:13

maybe : checking stats_time in catalog and see when this was done
in the crontab job-generate log and time of start and end for each table
according to db2pd = 1 sec ????

when I start a reorg - the table is not reflected in the db2pd output list
I presume this is for automatic maintenance -
has to be checked..

checked again - seems ok
(0)[db2inst1@dlx00005 ump]$ date;db2 "reorg table pip.access"; date
Thu Dec 8 08:55:38 CET 2011
DB20000I The REORG command completed successfully.
Thu Dec 8 08:55:50 CET 2011

db2pd..
0x00002AD316418528 ACCESS 12/08/2011 08:55:39 12/08/2011 08:55:50 12/08/2011 08:55:40 3
I suggest - you print the times in the job executing the reorg to check