Page 1 of 2 12 LastLast
Results 1 to 15 of 28
  1. #1
    Join Date
    Jan 2004
    Posts
    23

    Lightbulb Unanswered: DB2 6.1 UDB - Badly need help please

    Dear Friends

    Here is the problem :

    While I try to connect database through control center I get this error message. In this DB2 I only know how to use control center becuase it is quite similliar to SQL SERVER Enterprise manager. I don't know how to use other tools.

    Error : SQL1402N Unable to authenticate user due to unexpected system error. SQLSTATE = 08004

    I'm using id = db2admin and password = db2admin

    db2admin is a domain account, and I'm very sure password has not been changed. Becuase I'm using the same account to login to different DB2 server which has no problem.

    If any one is in USA, please give me your contact number bcoz i badly need some one's help today it self.

    Your small help is also highly appericiable.

    With regards
    darshna shah
    Attached Thumbnails Attached Thumbnails db2error-snapshot.bmp  
    Last edited by Darsh; 02-04-04 at 20:42.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I don't have the Messages and Codes manual for version 6, but here is a description from version 8.

    SQL1402N Unable to authenticate user due to unexpected system error.

    Explanation: Call your system administrator. On unix-based systems, the file db2ckpw may not have the correct permission bits set, or the system may have run out of swap/paging space. On Windows NT, the DB2 security service may not have been started or the account may be locked. The command can not be processed.

    Federated system users: this situation can also be detected by the data source.

    User Response: On unix-based systems, have the system administrator ensure the correct access permissions are set for db2ckpw, and that there is enough swap/paging space allocated. On Windows NT, have the system administrator verify that the DB2 security service is installed and started. If the service is running then ensure that the account is not locked.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: DB2 6.1 UDB - Badly need help please

    Darshana

    See if this helps


    H:\>db2 ? sql1402n

    SQL1402N Unable to authenticate user due to unexpected system
    error.

    Explanation: Call your system administrator. On unix-based
    systems, the file db2ckpw may not have the correct permission
    bits set, or the system may have run out of swap/paging space.
    On Windows NT, the DB2 security service may not have been
    started.

    The command can not be processed.

    Federated system users: this situation can also be detected by
    the data source.

    User Response: On unix-based systems, have the system
    administrator ensure the correct access permissions are set for
    db2ckpw, and that there is enough swap/paging space allocated.
    On Windows NT, have the system administrator verify that the DB2
    security service is installed and started.



    To view details on an error message,

    db2 ? <message code>

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: DB2 6.1 UDB - Badly need help please

    Another occasion I have seen this error is when the account is locked (eg, you have typed in a wrong password a couple of times ) as per the system policy

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Jan 2004
    Posts
    23
    All

    (1) This DB2 6.1 is on Windows Nt 4.0

    (2) All Db2 services are running - i did double check and i also restarted all services again.

    (3) I've restarted server so many times so there is no problem of locking the account. I'm facing this tough time since last so many days.

    (4) I've not checked about swaping files, what is that ? how should i check ?

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I think the swap space issue for this error is for AIX, not Windows.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  7. #7
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Check if your db2diag.log file has any info .. C:\sqllib\db2\db2diag.log

    Change the diaglevel to 4 ..

    db2 update dbm cfg using diaglevel 4

    which will give more detailed messages ...

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  8. #8
    Join Date
    Jan 2004
    Posts
    23
    (1) I got this last message from db2diag.log file.

    "2004-01-20-10.56.20.035000 InstanceB2 Node:000
    PID:204(db2syscs.exe) TID:399 Appid:*LOCAL.DB2.040120165616
    database_monitor sqm.sqlm_log_ev_err Probe:1 DatabaseIEBTDB"

  9. #9
    Join Date
    Jan 2004
    Posts
    23
    I forgot how i capture this error, but i capture this error from log files.

    "[IBM][CLI Driver] SQL1403N The username and/or password supplied is incorrect. SQLSTATE=08004 "

  10. #10
    Join Date
    Jan 2004
    Posts
    23
    Last edited by Darsh; 02-04-04 at 20:43.

  11. #11
    Join Date
    Jan 2004
    Posts
    23
    Last edited by Darsh; 02-04-04 at 20:44.

  12. #12
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Contact your administrator to unlock the user ...

    You should read

    http://www-306.ibm.com/cgi-bin/db2ww...9.htm#HDRNTSEC

    to understand how DB2 works with NT password ... With your Windows and SQL Server background, I assume you'll understand this topic better than many others will

    Cheers

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  13. #13
    Join Date
    Jan 2004
    Posts
    23
    Last edited by Darsh; 02-04-04 at 20:44.

  14. #14
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    It is an instance setting which indicates that the 'connect' will be authenticated on the client side rather than the server side ...

    Search for authentication, trust_allclnts and trust_clntauth in you db2 manuals ...

    I would generally prefer a SERVER Authentication to be set

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  15. #15
    Join Date
    Jan 2004
    Posts
    23
    (1) This document, is very nice , cleared my so many doubts.
    Though, I'm feeling that something i'm missing.

    so, what i did, i renamed few of the log file and system has generated new log file.

    I'm getting this error message from db2diag.log file, while i try to connect to db2 through control center.

    2004-01-22-14.58.00.218000 InstanceB2 Node:000
    PID:204(db2syscs.exe) TID:399 Appid:*LOCAL.DB2.040122205759
    database_monitor sqm.sqlm_log_ev_err Probe:1 DatabaseIEBTDB


    Any idea please ?

    Any suggestion please ?

    With regards
    darshna

Posting Permissions

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