Background

Trying to run Explain on a Db/2 query, but running into an error.

Error

Error Image

SQLCode-104AndSQLCode-727.20181005.1124AM.PNG

Error Text

 An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-104", SQLSTATE "42601" and message tokens "END-OF-STATEMENT|153875 FOR ORDER BY|JOIN ".. SQLCODE=-727, SQLSTATE=56098, DRIVER=4.21.29

Troubleshooting

Unselected Text

When we try to explain the Query without selecting the text we get the error pasted below:

Image

unselectedQuery.20181005.1133AM

Text


Empty query string

Remediation

Select Text

Please select the text you want explained and click the “Explain Execution Plan“.

queryEditor.selected.20181005.1130AM.PNG

Learning in the Open

Db/2 LUW & DBeaver – Error – An error occurred during implicit system action type “2”