How to change password of a database in DB2 software of IBM?

database db2 username forgot-password
ypahalajani picture ypahalajani · Apr 11, 2015 · Viewed 14.1k times · Source

However, it seems very trivial - How to get the current username of a database in DB2 software in IBM; But, trust me, when it comes to entering the database username and password while connecting DB2 with eclipse, you might have to wait for a time which is tediously long. Let's get straight to the point:-

This is how you get the username of a database in DB2.

  1. open DB2 Command Line Processor .

  2. Connect to your database:-

         db2 => connect to <database_name>

  3. Enter this query in db2 clp:-

         db2 =>  SELECT CURRENT USER FROM SYSIBM.SYSDUMMY1

  4. You'll get the current user name of the current database that you have accessed.

Now, the main problem is :- How to get / change the password if one has forgotten the password. And, What is the difference between database password and the one that i entered while installing DB2 ?

Answer

Ian Bjorhovde picture Ian Bjorhovde · Apr 12, 2015

DB2 does not have its own set of IDs and passwords; it relies on the operating system to perform authentication. So your ID and password are what you used to log in to Windows (or Linux, AIX, etc); and you change your password as you do normally on each platform.

The password you entered during installation is for a different ID - DB2 created a new user on your local machine. On Windows the ID is called db2admin by default.

Related questions

Difference between CLOB and BLOB from DB2 and Oracle Perspective?

I have been pretty much fascinated by these two data types. According to Oracle Docs, they are presented as follows : BLOB : Variable-length binary large object string that can be up to 2GB (2,147,483,647) long. Primarily intended to hold non-traditional data, such …

Read More
How to update multiple columns in single update statement in DB2

I want to update multiple columns of a table in DB2 with single Update statement. Any hint or idea will be appreciable. Thanks.

Read More
Calculating how many days are between two dates in DB2?

I need to get the difference in days between two dates in DB2. I tried a couple of different queries but nothing seems to be working. So basically what i need to get is something like this. SELECT DAYS (CURRENT …

Read More