Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Posts
    9

    Question Unanswered: udb connect failure error

    I am getting the following error message when trying to connect to the database. This id has been granted dbadm. any thoughts as to why this is happening:
    "db2 connect to gocxudb user cwadmin using xxxxx SQL30082N Attempt to establish connection failed with security reason "19" ("USERID DISABLED or RESTRICTED")."

  2. #2
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186

    Re: udb connect failure error

    You don't say what OS your using, make sure that the id is defined and not locked at the OS level. DB2 make use of the id definded throught the OS

  3. #3
    Join Date
    Jul 2003
    Posts
    9
    the os is aix 5.1. i can log on with the id; i can't connect to any of the databases on that server.

  4. #4
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

    Re: udb connect failure error

    this´s the description of th rason code 19:
    19 (USERID DISABLED or RESTRICTED) The userid has been disabled,
    or the userid has been restricted from accessing the operating
    environment at this time.

    The problem be in the OS. Check the user in the OS.

    Abel.

Posting Permissions

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