Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I created a TCP node and I catalogued a db into it. The catalogued db needs user name and password to be accessed. Is there anyway I can store username and password in the cataologue (or other way)? I use the catalogue in an Excel spreadsheet (OLEDB connection) and every time I need to insert username and password.

share|improve this question
up vote 3 down vote accepted

DB2 won't store your username and password - neither the server, nor the client. What you could do is set up an ODBC setting in Windows. (I am assuming you are using Windows given you mention Excel, though I could be incorrect in that). The ODBC setting allows you to store the username and password on that Windows system. Do be careful with that though as Windows will warn you that the password isn't stored the most securely.

share|improve this answer
Thats' correct. I found that I can call Control Panel->Admi Tools->Setup ODBC and on "System DSN" I can setup easily a db connection using all alias of my db2 instance. Thanks a lot. – Abruzzo Forte e Gentile Dec 4 '13 at 15:31

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.