Certain rules and guidelines apply for pushdown optimization to an IBM DB2 database.
When you apply pushdown optimization to an IBM DB2 database, a session that requires type casting can fail. The session fails if the casting is from float or double to string, or if it requires a type of casting that IBM DB2 databases disallow.