DB2 Design Advisor with huge workload?

Peter Arrenbrecht

Does anyone have experience with running the DB2 Design Advisor on huge
workloads? I have a workload for a single day for some 132'000
statements in a file. Will the advisor handle this or should I take a
sample?

Thanks,
Peter Arrenbrecht
Opus Software AG

Nov 12 '05 #1

Serge Rielau

Peter Arrenbrecht wrote:

Does anyone have experience with running the DB2 Design Advisor on huge
workloads? I have a workload for a single day for some 132'000
statements in a file. Will the advisor handle this or should I take a
sample?

Thanks,
Peter Arrenbrecht
Opus Software AG

Quote from backstage: "try using -k HIGH"
This may take a while....

Cheers
Serge

Nov 12 '05 #2