Problem:

Accessing DB2 through HCO(Host Connectivity Option).
The first time that you try to access DB2 a Dialog Box will appear to enter valid User Details for accessing DB2. This also allows you to save the User Details to stop repetitive logons each time the Database is accessed.
I now wish to change User details when accessing the Database but the Logon Dialog box doesn't appear?

Resolution:

The SQL Logon information is either held by the MFDAEMON or is specified by an Environment variable SQLPASS.TXT.

The MFDAEMON can be Started or Stopped from the Enterprise Developer command line using MFDAEMON start or MFDAMEON close. This will reset any stored User Details currently held.

The Environmental Variable would have been initiated with something like

' SET SQLPASS.TXT=D:\\BATCH.TXT'.

This can be checked on your system from the set command from the Enterprise Developer command Line.