If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > change account password

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Jul 2011
Posts: 4
change account password

Hi,

i am working with DB2 UDB version for the first time. i have been told to change password for a DB2 user. I am using this DB2 in Tivoli access manager environment and i have to do everything from the command line on a solaris platform.. please help
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Jul 2006
Location: Bangalore
Posts: 57
db2 uses OS authentication so you need to change user password from OS level.
__________________
Ritesh Kumar Singh
IBM Certified DB2 DBA for LUW
**Knowledge Is Theft If Not Shared !!**
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Jul 2011
Posts: 4
Quote:
Originally Posted by singhipst View Post
db2 uses OS authentication so you need to change user password from OS level.
how do we get it done..is there any UI for doing it..if it can be done from command line, can you please explain the same..

Thanks in advance
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,713
Quote:
Originally Posted by ichwaiznicht View Post
how do we get it done..is there any UI for doing it..if it can be done from command line, can you please explain the same..

Thanks in advance
It is a Solaris operating system command, not a DB2 command. If there is a GUI it would be a Solaris GUI. From the Solaris command line, you can try passwd. I would recommend that you contact your Solaris adminstrator if you have any further questions about this.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Jul 2011
Posts: 4
Quote:
Originally Posted by Marcus_A View Post
It is a Solaris operating system command, not a DB2 command. If there is a GUI it would be a Solaris GUI. From the Solaris command line, you can try passwd. I would recommend that you contact your Solaris adminstrator if you have any further questions about this.
Thanks for your time.

once i change the password using passwd command, dont i need to make this change reflected in all of the db2 services. besides,while changing the password using solaris command line, how DB2 will get to know that the password has been changed.

Last edited by ichwaiznicht; 07-04-11 at 10:39.
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,713
Quote:
Originally Posted by ichwaiznicht View Post
Thanks for your time.

once i change the password using passwd command, dont i need to make this change reflected in all of the db2 services. besides,while changing the password using solaris command line, how DB2 will get to know that the password has been changed.
No, you do not need to do anything else (assuming you change it on the same server that DB2 is running on), since as noted by the above post, DB2 uses operating system authentication.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: Jul 2011
Posts: 4
Cool

Quote:
Originally Posted by Marcus_A View Post
No, you do not need to do anything else (assuming you change it on the same server that DB2 is running on), since as noted by the above post, DB2 uses operating system authentication.
thanks...it was quite helpful..
Reply With Quote
  #8 (permalink)  
Old
Registered User
 
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,721
DB2 will notice the change automatically the next time it needs authentication. Since DB2 relies on the operating system for that, it doesn't do any caching in this respect.
__________________
Knut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development
Reply With Quote
Reply

Tags
db2, password, solaris

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On