Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2015
    Posts
    4

    Unanswered: DB2 9.7 client connect to server show SQL4414N error

    When I try to do "Generate DDL" from "Control Center", it shows:

    SQL4414N The DB2 Administration Server is not active.


    Explanation:

    The request cannot be processed unless the DB2 Administration Server is
    active.

    User response:

    Start the DB2 Administration Server by issuing the command DB2ADMIN
    START, and reissue the request.



    Clinet is IBM DB2 V9.7 client on windows, and connect to server is on unix.

  2. #2
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    And you are asking what? How to resolve that? As the 'User response' says.....
    Start the admin server on the db2 server.
    If you can't do that then ask the dba responsible for the server to do it.
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

  3. #3
    Join Date
    Jun 2015
    Posts
    4
    Quote Originally Posted by tafster View Post
    And you are asking what? How to resolve that? As the 'User response' says.....
    Start the admin server on the db2 server.
    If you can't do that then ask the dba responsible for the server to do it.
    Thank you, I tried

    db2admin stop and db2admin start on server side, still same error.

    I need start DAS for using the Control Center tools or performing remote administration.

    Thanks

  4. #4
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Are you able to telnet to this Linux port 523 from the windows workstation?
    Regards,
    Mark.

Posting Permissions

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