Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2012
    Posts
    53

    Unanswered: db2diag error , need reason , urgentt

    HI

    the following error message written in diag file
    As for I know the user has enterd wrong password.
    But managers are asking for root cause, user entered same password which he is using for lost one month. But he is not able to connect to db

    The problem is solved after reseting the password . But is there anything on db side that will make password to expire something like that?
    please help mee

    2013-01-25-15.15.39.904742+330 I1737064561A435 LEVEL: Warning
    PID : 11731076 TID : 2353 PROC : db2sysc 0
    INSTANCE: db2qas NODE : 000 DB : QAS
    APPHDL : 0-36526
    EDUID : 2353 EDUNAME: db2agent (QAS) 0
    FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
    DATA #1 : String with size, 65 bytes
    Password validation for user sapprd failed with rc = -2146500508

    2013-01-25-15.15.40.003102+330 I1737064997A435 LEVEL: Warning
    PID : 11731076 TID : 2353 PROC : db2sysc 0
    INSTANCE: db2qas NODE : 000 DB : QAS
    APPHDL : 0-36527
    EDUID : 2353 EDUNAME: db2agent (QAS) 0
    FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
    DATA #1 : String with size, 65 bytes
    Password validation for user sapprd failed with rc = -2146500508

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    db2 does not maintain uid/pw
    there is a possibility in the db2 connect statement to supply new and confirm a pw change
    CONNECT (Type 2)
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Dec 2012
    Posts
    53
    thank you very much

    Can u share me a link regarding how many CONNECT (Types) are there

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    follow previous link to infocenter...
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •