X212 error running select statement under SQL Option

Problem:

Statement was

select count(creator) from sysibm.systables;

Error was X212: Function not available under current compatibility setting.

Resolution:

Changed the XDB Server version from V6 to V7 and the statement now runs successfully.