1

I am running runstats command to update the runtime statistics of a particular table called "CUSTOMER" in DB2. The customer has two columns- CID (integer) and INFO (xml column).

After running the command, if I look into the SYSCOLDIST table, the information for column CID is populated correctly. But there is nothing filled for the INFO xml column. The same happens with a different table that has xml columns.

Please help..

Thanks,
-Keshav

Improve this question

1 Answer 1

Reset to default
1

Have a look here for some tips on stats generation for XML columns. You might try checking the error logs to see what's there - also specifically as per tip 11 using sampling.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .