Any attempt to run db2caem on a query with optimization guideline will be greeted with this message:
DBT7028E "db2caem": The db2caem command failed because the DB2 database manager encountered an error while processing the specified input parameters and the specified SQL statement. Handle type: "3". Return code: "-1:2162".
CLIInfo: SQLstate: "42601"
Return code: "-104"
Diagnostic message: "[IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An unexpected token "'SELECT xxxxxxxx" was found following "WHERE STMT_TEXT LIKE". Expected tokens may include: "LIKE <pattern>". SQLSTATE=42601
"
DBT7028E "db2caem": The db2caem command failed because the DB2 database manager encountered an error while processing the specified input parameters and the specified SQL statement. Handle type: "3". Return code: "-1:2162".
CLIInfo: SQLstate: "42601"
Return code: "-104"
Diagnostic message: "[IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An unexpected token "'SELECT xxxxxxxx" was found following "WHERE STMT_TEXT LIKE". Expected tokens may include: "LIKE <pattern>". SQLSTATE=42601
"
Too bad.
No comments:
Post a Comment