IBM Support

SQL0206N  "PKGNAME " is not valid in the context where it is used.  SQLSTATE=42703

Troubleshooting


Problem

Exception received when trying to start the IBM WebSphere Studio Asset Analyzer distributed scanner on a Windows XP machine. The same driver has no problems on Windows 2000.

Symptom

[IBM][CLI Driver][DB2] SQL0206N  "PKGNAME " is not valid in the context where it is used.  SQLSTATE=42703
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2] SQL0206N  "PKGNAME" is not valid in the context where it is used.  SQLSTATE=42703

Resolving The Problem

From a DB2 command window, do the following:

cd to DB2DIR\bnd
db2 connect to 390db user adminID using password
db2 bind @ddcsmvs.lst blocking all grant public sqlerror continue
db2 terminate

[{"Product":{"code":"SSXJB2","label":"WebSphere Studio Asset Analyzer"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Inventory scan","Platform":[{"code":"PF033","label":"Windows"}],"Version":"4.1;3.1","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
16 June 2018

UID

swg21190531