Db2 - L

Latest Discussion Posts

  • Hello Leila, perhaps you can use optimization guidelines <OPTGUIDELINES> <IXSCAN TABLE='"T_00"' INDEX='"TABLE1_IX"' /> </OPTGUIDELINES> Best regards, Joachim ------------------------------ JoachimMüllerDouglas IT ------------------------------

  • Just an observation. I've seen Db2 quite keen to use an index on even very low row counts – like 2. So if VOLATILE doesn't work, maybe 'lie' to Db2 a little and tell it there are quite a few rows in the table by updating the statistics. Or if there's ...

  • I interpret the between lines section as that all of 1.8 (2014 something) should be included. Localdate has been around since the beginning so I had some hopes for it. Anyhow, thanks for opening an aha (and for the link, I'll try to remember where aha ...

  • Got my vote straightaway! Roy Boxwell SOFTWARE ENGINEERING GmbH and SEGUS Inc. -Product Development- Vagedesstrasse 19 40479 Dusseldorf/Germany Tel. +49 (0)211 96149-675 Fax +49 (0)211 96149-32 Email: R.Boxwell@seg.de Web http://www.seg.de Link ...

  • Hi Lennart, thanks for testing this! But if I read the KC link between the lines: JCC supports new APIs [but not all of them] from JDBC 4.3 specification with this release. JCC driver is built with JDK 1.8 [as it was to complicated for us ...