Post-2 : Reset the pwd for the os user using db2

36 views
Skip to first unread message

malla kishore

unread,
Aug 29, 2007, 5:55:05 AM8/29/07
to mirac...@googlegroups.com
Hi Team
I have a requirement that i have to change the password of db2 user using db2 command

db2 CONNECT TO <dbname> USER <uname> USING <pwd> NEW <pwd> CONFIRM <pwd>

Operating system: Linux

(FYI: on AIX it works fine)

But its giving the error

SQL30083N Attempt to change password for user id "inst1" failed with securityreason "17" ("UNSUPPORTED FUNCTION"). SQLSTATE 001

advance thanks for any idea

Gokul Sagi

unread,
Aug 29, 2007, 7:57:42 AM8/29/07
to mirac...@googlegroups.com
Hi Kishore

This is what i got from a long search for your question .

The only platforms where changing passwords is supported are Windows NT, AIX, OS/2, and S/390.
Other operating systems do not provide APIs that DB2 can use to request a change in password. You
will need to change passwords at the OS level instead.

link: http://www-304.ibm.com/jct09002c/isv/tech/faq/individual.jsp?oid=1:31338

cheers,
Gokul.Sagi.


------- Original Message -------
From : malla kishore[mailto:mallak...@gmail.com]
Sent : 8/29/2007 5:55:05 AM
To : mirac...@googlegroups.com
Cc :
Subject : RE: Post-2 : Reset the pwd for the os user using db2

Hi Team
I have a requirement that i have to change the password of db2 user using
db2 command

db2 CONNECT TO <dbname> USER <uname> USING <pwd> NEW <pwd> CONFIRM <pwd>

*Operating system: Linux*

malla kishore

unread,
Aug 29, 2007, 8:27:52 AM8/29/07
to mirac...@googlegroups.com
 
Hi Gokul,
 
Good work..is there any way to ovecome this situation ?
 
Please chk this
 
 
 
Thanks
Kishore

 
--
కిశోర్ మల్ల

malla kishore

unread,
Aug 29, 2007, 9:09:07 AM8/29/07
to mirac...@googlegroups.com

Hi team,
 
Please have a look at this..
This needs db2 V 9.0 with fixpack
 
any one please uninstall u r old version and try
 
Thanks
Kishore
Reply all
Reply to author
Forward
0 new messages