Problem:

HCO Query Tool fails when performing a query - 551N - doesn't have privilege...

Resolution:

The first time you use any of the Mainframe Express Host Compatibility Option tools with a database, the Host Compatibility Option automatically tries to bind itself to the database being connected to. If the database is on the mainframe, this automatic bind may fail if you do not have the authority to 'Create in collection NULLID' and 'BINDADD'.  If an automatic bind fails, it is worth trying a manual bind, because the message returned from a manual bind will clearly indicates why the bind has failed.

You perform a manual bind by using the DB2 command processor. Enter the following commands in an MS-DOS window:

   DB2 connect to <server>

   DB2 bind c:\\mfe\\mfhco\\bin\\mfhco70b.bnd

Where server is the name of the DB2 server for the database that you want to connect to.

If this manual bind fails, ask your Database Administrator to help resolve the problem, since it is probably an authority issue.