Troubleshooting
Problem
In DB2 LUW the db2advis command errors out with SQL0206 "RUN_ID" is not valid in the context where it is used.
Symptom
The error message is similar to the following:
SQL0206N "RUN_ID" is not valid in the context where it is used.
SQLSTATE=42703
SQLCABC = 136
SQLCODE = -206
SQLERRMC = RUN_ID
SQLERRP = SQLNQ074
sqlerrd[0] = 2149187693
SQLSTATE = 42703
Critical SQLCODE. Exiting db2advis ...
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Compiler - db2advis","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1","Edition":"Enterprise Server;Express;Personal;Personal Developer\u0027s;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
16 June 2026
UID
swg21398854