Topic
  • 3 replies
  • Latest Post - ‏2012-09-14T16:34:54Z by SystemAdmin
cabrerachaparro
cabrerachaparro
2 Posts

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

    Re: Errorcode=-4499, SQLSTATE=08001

    ‏2012-09-14T09:21:49Z  
    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

    Re: Errorcode=-4499, SQLSTATE=08001

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

    Thanks
  • SystemAdmin
    SystemAdmin
    1086 Posts

    Re: Errorcode=-4499, SQLSTATE=08001

    ‏2012-09-14T16:34:54Z  
    How can i get these values? I will try before contact the DB2 administrator.

    Thanks
    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