Professional Web Applications Themes

connect question - IBM DB2

Hi I am trying to connect from a Windows DB2 client to a Linux database, both are at 8.1 FP 2. It works fine when I try to connect using the instance owner id. If I use any other id, I get an error message...."invalid user / password......reason code 24". The same id works fine if I directly log on to the server box and issue the CONNECT statement. What am I missing here ? Thanks...

  1. #1

    Default connect question

    Hi

    I am trying to connect from a Windows DB2 client to a Linux database,
    both are at 8.1 FP 2.
    It works fine when I try to connect using the instance owner id.
    If I use any other id, I get an error message...."invalid user /
    password......reason code 24". The same id
    works fine if I directly log on to the server box and issue the CONNECT
    statement.
    What am I missing here ?

    Thanks


    Murty Guest

  2. #2

    Default Re: connect question

    "Murty" <net> wrote in message
    news:WtKeb.478146$.. 
    Is that user id submitted from the client defined to the Windows operating
    system?


    Mark Guest

  3. #3

    Default Re: connect question

    This user id is a OS id on Linux box (where the DB2 server is running)
    and has got DBADM privilege
    on the database that I am trying to connect to.


    "Mark A" <net> wrote in message
    news:BDKeb.874$uswest.net... [/ref]
    database, [/ref]
    CONNECT 
    > Is that user id submitted from the client defined to the Windows operating
    > system?
    >
    >[/ref]


    Murty Guest

  4. #4

    Default Re: connect question

    "Murty" <net> wrote in message
    news:q%Keb.649299$.. 
    That's not what I asked you. I asked about whether the user has an id on the
    Windows client machine. the remote user must have a userid established on
    the client OS.


    Mark Guest

  5. #5

    Default Re: connect question


    "Mark A" <net> wrote in message
    news:b1Leb.876$uswest.net... 
    > That's not what I asked you. I asked about whether the user has an id on[/ref]
    the 

    No, this id is not defined to windows OS.

    Let me make myself clear....

    The instance owner is ABC100 (which is a Linux id, not a windows id).
    I can connect to the database
    from both server machine & client machine using this id.

    The other id is ABC200 (which is also a Linux id only, not a windows id),
    with DBADM privilege. It works fine
    if I connect from the linux box. I get an error if I try from the client
    box.


    Thanks
    Murty


    Murty Guest

  6. #6

    Default Re: connect question

    Murty <net> wrote:
     

    Have a look at your database manager configuration (GET DBM CFG). What have
    you set for "AUTHENTICATION"? It should be "SERVER" so that DB2 will use
    the users and their passwords as defined database server machine (Linux).

    --
    Knut Stolze
    Information Integration
    IBM Germany / University of Jena
    Knut Guest

  7. #7

    Default Re: connect question


    "Knut Stolze" <ibm.com> wrote in message
    news:blghc6$2sm$rz.uni-jena.de... [/ref]
    client 
    >
    > Have a look at your database manager configuration (GET DBM CFG). What[/ref]
    have 


    It is 'SERVER' only. Otherwise, I wouldn't have been able to connect to
    using the inst owner id.
    The exact command is CONNECT TO INST1 USER ABC200 USING XYZ200


    - Murty


    Murty Guest

  8. #8

    Default Re: connect question

    Have you tried opening a case with IBM? If you are getting SQL30082N with
    rc=24, I have seen this error in situations where there is an
    ownership/permissions issue with db2ckpw (happens if the db2 executables are
    somehow copied from another source instead of installed from the install
    image). There are a host of other possibilities including running out of page
    space. Difficult to know what the problem is for your specific environment ...
    IBM support would be better equipped to assist.

    Larry Edelstein

    Murty wrote:
     [/ref]
    > client 
    > >
    > > Have a look at your database manager configuration (GET DBM CFG). What[/ref]
    > have 
    >
    > It is 'SERVER' only. Otherwise, I wouldn't have been able to connect to
    > using the inst owner id.
    > The exact command is CONNECT TO INST1 USER ABC200 USING XYZ200
    >
    > - Murty[/ref]

    Larry Guest

  9. #9

    Default Re: connect question

    Can you connect (from the linux box) using ABC200 with the password? (Ie
    connect to db user ABC200 using ... , rather than just connect to db).

    On AIX you can have problems for example if you have AFS and local
    password mismatches (db2 will use the 'local' os password)...any special
    setup on the system?

    Murty wrote:
     [/ref]
    >
    > client

    >>
    >>Have a look at your database manager configuration (GET DBM CFG). What[/ref]
    >
    > have

    >
    >
    >
    > It is 'SERVER' only. Otherwise, I wouldn't have been able to connect to
    > using the inst owner id.
    > The exact command is CONNECT TO INST1 USER ABC200 USING XYZ200
    >
    >
    > - Murty
    >
    >[/ref]

    Sean Guest

Similar Threads

  1. CS3 will not connect
    By alfie conway in forum Macromedia Contribute Connection Administrtion
    Replies: 0
    Last Post: December 13th, 01:15 PM
  2. Replies: 9
    Last Post: April 27th, 04:44 AM
  3. How to use “RDS.Connect” to connect to a MS Access database?
    By hannaman@msn.com in forum ASP Database
    Replies: 0
    Last Post: August 2nd, 11:09 PM
  4. DB2 Connect question
    By Murty in forum IBM DB2
    Replies: 5
    Last Post: October 16th, 07:57 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139