You need to check the version of your Java Combined Client (JCC) installed? Try this way:
All DB2 JDBC Driver versions, see here!
More information on DB2, Java, JDBC and JCC.
Customers who want to make use of extended EXPLAIN need to adapt and execute a DB2 10 sample job from SDSNSAMP library. IBM delivers a job called DSNTESC to create a set of 20 EXPLAIN tables required.
Because Visual Explain is deprecated and OSC (Optimization Service Center) does not support DB2 ... weiterlesen