By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,237 Members | 1,224 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.

Password lost - how to change it.

P: n/a
Hi,

I'm after forgetting a password for a database user.

DB2 on linux client, server on zSeries. 8.1.5 is the version.

I can connect as user SYSADM, which has full authorisations.

What's the equivalent of ALTER USER SM1ADM IDENTIFIED BY PASSWORD for
DB2 please?

Regards.

Aug 25 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Raj
uid's/pwd's in db2 for LUW is handled by the OS...

Aug 25 '06 #2

P: n/a
Raj
uid's/pwd's in db2 for LUW is handled by the OS...

Aug 25 '06 #3

P: n/a
In article <11*********************@m79g2000cwm.googlegroups. com>,
sp****@yahoo.com says...
uid's/pwd's in db2 for LUW is handled by the OS...
Yes, but it can be changed when entering the CONNECT statement.
Check the docs at http://tinyurl.com/rb22y
Aug 25 '06 #4

P: n/a

Gert van der Kooij wrote:
In article <11*********************@m79g2000cwm.googlegroups. com>,
sp****@yahoo.com says...
uid's/pwd's in db2 for LUW is handled by the OS...

Yes, but it can be changed when entering the CONNECT statement.
Check the docs at http://tinyurl.com/rb22y
I couldn't figure out the correct syntax to do that. The DB2 admin
changed the password on the mainframe and I ran some SAP utility
programs to sync the passwords again. All's OK now.

Aug 28 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.