Problem:

When attempting to start SQL Wizard, an error message appears:

"XDB Error: Unable to get error message. Error code is XU005".Error parameters are: (1) $XDBSRVROOT\\xutl.xsg.

Resolution:

If you open XDBHELPW.HLP (Net Express\\mfsql\\help or using the Net Express IDE, help/sql for DB2/error messages), the message corresponding to the error code XU005 is:

XU005: File name not found.

As the parameter of the message is "(1)/xutl.xsg" that means that it can not find the file xutl.xsg that the sql wizard needs for some reason...

The file xutl.xsg is in the directory: Net Express\\mfsql\\BIN, so you need check that the file does actually exist in that location.

If the file does exist, the next thing to check is that the XDB environment is set up correctly. XDB needs certain environment variables to be defined to work properly. For example, if you open a Net Express command prompt and you run the set command, you should see the following variables with similar values:

Path=C:\\Program Files\\MICRO FOCUS\\Net Express\\mfsql\\bin;"C:\\Program Files\\MICRO FOCUS\\Net Express\\Unix\\DSCHAR\\BIN";"C:\\Program Files\\MICRO FOCUS\\Net Express\\DialogSystem\\BIN";C:\\Program Files\\MICRO FOCUS\\Net Express\\DialogSystem\\BIN;"C:\\Program Files\\MICRO FOCUS\\Net Express\\Base\\BIN";C:\\Program Files\\MICRO FOCUS\\Net Express\\Base\\BIN;C:\\Program Files\\MICRO FOCUS\\Net Express\\mfsql\\bin;"C:\\Program Files\\MICRO FOCUS\\Net Express\\Unix\\DSCHAR\\BIN";"C:\\Program Files\\MICRO FOCUS\\Net Express\\DialogSystem\\BIN";C:\\Program Files\\MICRO FOCUS\\Net Express\\DialogSystem\\BIN;"C:\\Program Files\\MICRO FOCUS\\Net Express\\Base\\BIN";C:\\Program Files\\MICRO FOCUS\\Net Express\\Base\\BIN;.......................

LIB=C:\\Program Files\\MICRO FOCUS\\Net Express\\mfsql\\lib;"C:\\Program Files\\MICRO FOCUS\\Net Express\\Unix\\DSCHAR\\LIB";"C:\\Program Files\\MICRO FOCUS\\Net Express\\DialogSystem\\LIB";"C:\\Program Files\\MICRO FOCUS\\Net Express\\Base\\LIB";C:\\Program Files\\MICRO FOCUS\\Net Express\\Base\\LIB;

XDBCFG=C:\\Program Files\\MICRO FOCUS\\Net Express\\mfsql\\cfg

XDBDIR=C:\\Program Files\\MICRO FOCUS\\Net Express\\mfsql\\bin

XSRVCFG=C:\\Program Files\\MICRO FOCUS\\Net Express\\mfsql\\cfg

So please review these XDB environment variables and check that they correspond to the ones set in the failing environment and amend as necessary.