UDB JDBC procedure call causes S04E in DB2

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • N61601@gmail.com
    #1

    UDB JDBC procedure call causes S04E in DB2

    I'm trying to call a z/OS stored procedure from Win UDB and am getting
    a SQLCODE: -444, SQLSTATE: 42724.
    On the the z/OS system log, I see -
    DSNL027I -PRDA SERVER DISTRIBUTED AGENT WITH 102
    LUWID=GA79647C. C009.01FA421529 19=180
    THREAD-INFO=PCTEST:MYP C:PCTEST:javaw. exe
    RECEIVED ABEND=04E
    FOR REASON=00D3003B
    DSNL028I -PRDA GA79647C.C009.0 1FA42152919=180 103
    ACCESSING DATA FOR
    LOCATION 2.121.130.124
    IPADDR 2.121.130.124

    I haven't been able to find anything by searching IBM.

    Does anyone have any idea what's causing this?

    Thank you in advance,
    Serenity
    Tags: None
    • Serge Rielau
      #2
      Re: UDB JDBC procedure call causes S04E in DB2

      N61601@gmail.co m wrote:
      I'm trying to call a z/OS stored procedure from Win UDB and am getting
      a SQLCODE: -444, SQLSTATE: 42724.
      On the the z/OS system log, I see -
      DSNL027I -PRDA SERVER DISTRIBUTED AGENT WITH 102
      LUWID=GA79647C. C009.01FA421529 19=180
      THREAD-INFO=PCTEST:MYP C:PCTEST:javaw. exe
      RECEIVED ABEND=04E
      FOR REASON=00D3003B
      OK, Your Windows box is not guilty (for a change), that much is clear.
      I'd try to find these hex numbers (or their numeric equivalents) in Java
      land. Perhaps a NULL pointer exception, etc, etc...

      Cheers
      Serge
      --
      Serge Rielau
      DB2 Solutions Development
      IBM Toronto Lab

        Comment

        • Colin Booth
          #3
          Re: UDB JDBC procedure call causes S04E in DB2

          N61601@gmail.co m wrote:
          I'm trying to call a z/OS stored procedure from Win UDB and am getting
          a SQLCODE: -444, SQLSTATE: 42724.
          On the the z/OS system log, I see -
          DSNL027I -PRDA SERVER DISTRIBUTED AGENT WITH 102
          LUWID=GA79647C. C009.01FA421529 19=180
          THREAD-INFO=PCTEST:MYP C:PCTEST:javaw. exe
          RECEIVED ABEND=04E
          FOR REASON=00D3003B
          DSNL028I -PRDA GA79647C.C009.0 1FA42152919=180 103
          ACCESSING DATA FOR
          LOCATION 2.121.130.124
          IPADDR 2.121.130.124
          >
          I haven't been able to find anything by searching IBM.
          >
          Does anyone have any idea what's causing this?
          >
          Thank you in advance,
          Serenity
          I have not got all the z/os manuals but i think that this may be idle thread
          timeout. Is your connection idle for significant periods of time?

          Colin

            Comment

            • Knut Stolze
              #4
              Re: UDB JDBC procedure call causes S04E in DB2

              Colin Booth wrote:
              N61601@gmail.co m wrote:
              >
              >I'm trying to call a z/OS stored procedure from Win UDB and am getting
              >a SQLCODE: -444, SQLSTATE: 42724.
              >On the the z/OS system log, I see -
              >DSNL027I -PRDA SERVER DISTRIBUTED AGENT WITH 102
              > LUWID=GA79647C. C009.01FA421529 19=180
              > THREAD-INFO=PCTEST:MYP C:PCTEST:javaw. exe
              > RECEIVED ABEND=04E
              > FOR REASON=00D3003B
              >DSNL028I -PRDA GA79647C.C009.0 1FA42152919=180 103
              > ACCESSING DATA FOR
              > LOCATION 2.121.130.124
              > IPADDR 2.121.130.124
              >>
              >I haven't been able to find anything by searching IBM.
              >>
              >Does anyone have any idea what's causing this?
              >>
              >Thank you in advance,
              >Serenity
              >
              I have not got all the z/os manuals but i think that this may be idle
              thread timeout. Is your connection idle for significant periods of time?
              The reason code is available at Lookat, and it is indeed a timeout:

              http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNMCJ12/SPTD3003B


              --
              Knut Stolze
              DB2 z/OS Utilities Development
              IBM Germany

                Comment

                Previous template Next
                Working...