Environment: aix 5.3

    db2 8.2

Previously query is running fine,now its taking 6 hours to complte..

Everythig is fine like indexes and all

can any one please guide me

Thanks

Hello Johan,

Could you please provide us your the query and the tables statistics used from your query, such as: number of inserts, number of reads, updates. etc.

Run the command :

db2 reorgchk update statistics on table <schemaname>.<tablename>

And inform us if there are any indexes for these tables.

Regards,
Perallis