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

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

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s