469,271 Members | 1,481 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

Password lost - how to change it.

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
4 5316
Raj
uid's/pwd's in db2 for LUW is handled by the OS...

Aug 25 '06 #2
Raj
uid's/pwd's in db2 for LUW is handled by the OS...

Aug 25 '06 #3
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

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.

Similar topics

9 posts views Thread by Jay | last post: by
5 posts views Thread by Crayon Coco | last post: by
1 post views Thread by PHPBABY3 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.