The source database uses DB2 for z/OS, but the Generate partitioning SQL property is set to
No. When the source database uses DB2 for z/OS, the Generate partitioning SQL property must
be set to Yes.
Explanation
When the Generate partitioning SQL property is set to No,
the SELECT statement must include the DBPARTITIONNUM clause. However, DB2 for z/OS does not
support the DBPARTITIONNUM clause.
User response
Set the Generate partitioning SQL property to Yes.
IBM InfoSphere Information Server, Version 11.3.1
Last updated: 2015-04-23
PDF version of this information:
IBM InfoSphere Information Server DB2 Connector Message Reference