Load Insert Vs Statistics Yes option

nagbuchi · #1 (**permalink**) 08-30-06, 03:38

I am loading the data and would like to take the statistics at load time.I am using the below load command and receiving a error message.

db2 "LOAD FROM in.txt OF DEL INSERT INTO Test_tbl STATISTICS YES"

SQL3525N The "STATISTICS" option is incompatible with the "INSERT " option.

I am able to run the LOAD.. REPLACE..STATISTICS YES successfully.Problem is coming only when appending the data to the table.

I am using UDB V8.2 ,Fixpack : 9

Please advise if you have any thoughts.

Thanks in advance,

Marcus_A · #2 (**permalink**) 08-30-06, 13:13

Statistics are only valid for the entire table, not just the rows being inserted.

sathyaram_s · #3 (**permalink**) 08-31-06, 09:30

IIRC, the limitation is documented!

Internet Services

Web Development

Digital Marketing

Consumer Tech