A database administrator would like to examine repartitioning options for a partitioned database named PRODDB. A workload has been captured on the system (Windows) and is stored in a file named WORKLOAD.SQL. What is the proper command to run the Design Advisor so that it will evaluate the information stored in the file and give advice on re-partitioning?()
A. db2advis -d proddb -i workload.sql -P
B. db2advis -d proddb -i workload.sql -partitioning
C. db2advis -d proddb -i workload.sql -m P
D. db2advis -d proddb -i workload.sql -m ALL&e