Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2011
    Posts
    39

    Unanswered: Cant quite COnnect

    From my DB2 Client I can catalog a DB, but cant quite connect:

    Code:
    db2 => catalog tcpip node db2node remote 10.14.50.12 server 50000
    DB20000I  The CATALOG TCPIP NODE command completed successfully.
    DB21056W  Directory changes may not be effective until the directory cache is
    refreshed.
    
    db2 => catalog database IPC as IPC at node db2node
    DB20000I  The CATALOG DATABASE command completed successfully.
    DB21056W  Directory changes may not be effective until the directory cache is
    refreshed.
    
    db2 => connect to IPC
    SQL30082N  Security processing failed with reason "3" ("PASSWORD MISSING").
    SQLSTATE=08001
    I looked up the catalog and connect statements, but I do not see anywhere where I can set a PW.

    How can I tell the client what PW to use when I connect to the DB ?

    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by Gideon22 View Post

    I looked up the catalog and connect statements, but I do not see anywhere where I can set a PW.
    Look up the CONNECT command again.

  3. #3
    Join Date
    Jun 2011
    Posts
    39
    You were right, I misunderstood the command

    I got it to work with the following:

    catalog tcpip node db2node remote 10.14.50.12 server 50000

    catalog database IPC as IPC at node db2node

    connect to IPC user db2inst1 using db2inst1
    Thanks for your help

Posting Permissions

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