Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
3 replies Latest Post - ‏2012-09-14T16:34:54Z by SystemAdmin
cabrerachaparro
cabrerachaparro
2 Posts
ACCEPTED ANSWER

Pinned topic Errorcode=-4499, SQLSTATE=08001

‏2012-08-28T17:41:48Z |
Hello,
I'm trying to connect to DB2 z/OS database. When I test the connection I got this error:

"No start database command was issue. Errorcode=-4499, SQLSTATE=08001"

How can I get the connection to DB2?

Thanks
Updated on 2012-09-14T16:34:54Z at 2012-09-14T16:34:54Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    1086 Posts
    ACCEPTED ANSWER

    Re: Errorcode=-4499, SQLSTATE=08001

    ‏2012-09-14T09:21:49Z  in response to cabrerachaparro
    Check that you have the right parameters set in the connection to DB2 zOS, specifically the Driver properties :
    Database (it should match the LOCATION of your host database)
    Host (it should match the IP address of the host where your DB2 for zOS is running)
    Port Number (it should match the TCPPORT where DB2 is listening)

    These values should be provided by your DB2 host admin in case you are not able to look at them
  • cabrerachaparro
    cabrerachaparro
    2 Posts
    ACCEPTED ANSWER

    Re: Errorcode=-4499, SQLSTATE=08001

    ‏2012-09-14T13:33:58Z  in response to cabrerachaparro
    How can i get these values? I will try before contact the DB2 administrator.

    Thanks
    • SystemAdmin
      SystemAdmin
      1086 Posts
      ACCEPTED ANSWER

      Re: Errorcode=-4499, SQLSTATE=08001

      ‏2012-09-14T16:34:54Z  in response to cabrerachaparro
      These values are set by the host DB2 admin. You can look at them in the DB2 started task, in the JESMSGLG DDname
      Look for something like this and check the <== values
      DB2S DDF START COMPLETE 449
      LOCATION NDCDBX21 <==
      LU USIBMNR.LUDB1S
      GENERICLU -NONE
      DOMAIN mycompany.com <==
      TCPPORT 54446 <==
      SECPORT 54448
      RESPORT 54461
      IPNAME -NONE