on 08-29-2012 12:22 PM
Hello experts,
I'm new to the DB2 database.
Can anyone please tell me how to find the database users in DB2? In which table it exactly stored information ?
Thanks,
Sunny
Please use the following SQL
db2 => select SCHEMANAME from syscat.schemata
SCHEMANAME
-------------------------
NULLID
NULLIDR1
NULLIDRA
SAPSR3
SAPSR3DB
SAPTOOLS
SQLJ
SYSCAT
SYSFUN
SYSIBM
SYSIBMADM
SYSIBMINTERNAL
SYSIBMTS
SYSPROC
SYSPUBLIC
SYSSTAT
SYSTOOLS
Regards
Ratnajit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sunny,
Here is some info about passwords on db2
As already mentioned, on db2 udb, we use operating system passwords, if you change the password on operating system level, you need to ensure the same password is updated in the encrupted db6conf file, or else logon will fail as the passwords dont match.
Connect directly to the database at command line to check connection at
database level
db2 connect to <sid> user <sid>adm using <password>
db2 connect to <sid> user db2<sid> using <password>
If you found userid or password problems at operating system level.
i.e. the password for the one of the users is expired.
Please use the following command to set the password for the users:
passwd <sid>adm <password> ,
passwd sap<sid> <password> or if the system is created via a upgrade
passwd sapr3 <password>
after you have done this, perform the following:
logon as <sid>adm
dscdb6up <sid>adm <password>
dscdb6up sap<sid> <password> or if the system is created via a upgrade
dscdb6up sapr3 <password>
Please note this applies for the Abap schema, to update the java connect
user, use the following method:
To change the sap<sid>db password you have to change it on OS level
and afterwards through the configtool. To change with the configtool,
start the configtool, then click on secure store, then change the
value for the key jdbc/pool/<SID>/Password, click add then click on
file>apply. You will have to restart the system.
SAP Note 582875 DB6: SAP cannot log onto the database
Hope this helps.
Regards,
Paul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Paul,
I have run the command
as root user > passwd sapr3
Entered twice sapr3's new password.
Then, as sidadm:
dscdb6up sapr3 <password>
and getting the below response -
Password file '/usr/sap/RW2/SYS/global/dscdb6.conf' successfully written
Effective userid is not root. OS passwords can not be changed.
ABORTING! Please check permissions and ownership
What does this mean? Has the sapr3 user password changed or not?
Thanks
Abdul
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.