Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2011
    Posts
    54

    Unanswered: IBM Data Studio connection with AIX Server DB2 Database

    I am trying to connect DB2 server database from XP machine with IBM data studio but I am getting error “No Start database command was issued. ErrorCode=-4499,SQLState=08001”.
    Please correct me where I am doing mistaken I am able to connect and access database from putty software but I want to connect server database through IBM Data studio.

    Server and Client machine details as given below and add database screen shot is attached-

    Database Server- AIX
    Database: DB2 9.5

    Client OS: Windows XP
    Database on Client XP: DB2 Express Edition C 9.7
    Management Studio on Client: IBM Data Studio stand-alone 2.2
    Attached Thumbnails Attached Thumbnails No Start database command was issued.JPG  

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    no start means : db2start is needed at the server to start the instance..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Jul 2011
    Posts
    54

    IBM data studio

    Instance already running and I am able to connect that instance through putty software but this error i am getting when i am trying to connect DB2 through IBM data studio.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    verify the connection string defined for this db
    connect to instance = nok
    attach to instance or connect to database
    if type/2 connection used - try todo a connect in db2 command line
    publish node directory - db directory - svcename/port of instance
    db2set -all at server
    for details howto - see : infocenter
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Jul 2011
    Posts
    54

    DB2 Data Studio License

    Hi,
    For using the DB2 Data Studio on client machine license required or it is free.

  6. #6
    Join Date
    Jan 2010
    Posts
    335
    The Data Studio is free. The Optim Tools require depend on server side licenses.
    The Optim Tools are at the bottom of the listing: Compare the distributed DB2 9.7 database servers

  7. #7
    Join Date
    Sep 2011
    Posts
    26
    Check you port number is correct ot not?

Posting Permissions

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