By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,237 Members | 1,228 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,237 IT Pros & Developers. It's quick & easy.

Local database requiring userid/password

P: n/a
I have an annoying problem on a particular server.

DB2 V8 FP12 on Windows 2003.

The database is catalogued on a local drive. From the CLI a connect to
the database without the userid/password works fine. When connecting
to the database from CC or Health Monitor (view utility status), the
userid/password is prompted. A second database (TOOLSDB) in the same
instance does not have this problem.

This messes up Automatic Maintenance. The db2fmp process is getting
connection errors.

I have tried uncatalog/recatalguing the database.

Any ideas?

Thanks in advance,
Norm

Oct 16 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Found the problem! The database is accessed through a local
application using ODBC. Another user had accessed the MS Data Sources
(ODBC). While testing local connectivity to the database through ODBC,
the UID was left in the DB2CLI.INI.

I guess the JDBC driver used by all the DB2 Tools was connecting using
this alias and saw the UID field. This caused the password to be
prompted, but none of the Tools are able to respond resulting in
numerous connection error messages in db2diag.log.

Solution: remove UID from db2cli.ini
Norm

Norm wrote:
I have an annoying problem on a particular server.

DB2 V8 FP12 on Windows 2003.

The database is catalogued on a local drive. From the CLI a connect to
the database without the userid/password works fine. When connecting
to the database from CC or Health Monitor (view utility status), the
userid/password is prompted. A second database (TOOLSDB) in the same
instance does not have this problem.

This messes up Automatic Maintenance. The db2fmp process is getting
connection errors.

I have tried uncatalog/recatalguing the database.

Any ideas?

Thanks in advance,
Norm
Oct 16 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.