Restrictions for caching in Watson Query

Important: IBM Cloud Pak for Data Version 4.8 will reach end of support (EOS) on 31 July, 2025. For more information, see the Discontinuance of service announcement for IBM Cloud Pak for Data Version 4.X.

Upgrade to IBM Software Hub Version 5.1 before IBM Cloud Pak for Data Version 4.8 reaches end of support. For more information, see Upgrading from IBM Cloud Pak for Data Version 4.8 to IBM Software Hub Version 5.1.

When you create a cache in Watson Query, you must consider certain restrictions.

Caching in Watson Query is subject to the following restrictions:
  • You can't use the fetch first n rows clause.
  • You can't use the order by clause.
  • You can't use select statements that use the with clause.
  • Data types that are not supported:
    • LOB types (BLOB, CLOB, DBCLOB)
    • LONG VARCHAR, LONG VARGRAPHIC (These types are deprecated in Db2®)
    • TIME
    • XML
    Note: BINARY and CHARACTER FOR BIT DATA data types are supported from Watson Query 1.7.7 and later.

Watson Query caching is built on Db2 Big SQL capabilities that involve Hadoop MQTs. The following restrictions apply.

  • You must be aware of restrictions in the CREATE TABLE (HADOOP) statement. For more information, see CREATE TABLE (HADOOP) statement in the Db2 Big SQL product documentation.

Watson Query caching is also built on Db2 MQT capabilities. The following Db2 MQT restrictions apply. For more information, see Materialized query table restrictions in the Db2 product documentation.

  • You must be aware of fullselect component restrictions. For more information, see fullselect in the Db2 product documentation.
  • Direct access to cache tables (MQT tables with names that start with DV* in the CACHESYS schema) is denied to all users.