Unable to initiate Debugger for Native Stored Procedure in DB2 z/os

[rameshmot]

Development environment where the bug occurred

• Db2 Developer Extension version:
• Editor platform
  • [x] Visual Studio Code
  • [ ] Eclipse Theia
• Editor platform version:
• Operating system on which your editor runs (for example, Windows 10 2004 or MacOS Catalina 10.15.7):
• Java Version (Run java -version and paste the details here):
• Db2 for z/OS version (including function level for Db2 12):
• Log files attached?: Yes/No

Problem description

Detailed steps for reproducing the problem:

1. First step

Hi, We currently can debug Native Stored procedure for Db2 z/os using Data Studio using Unified Debugger configured on z/os. But with DB2 z/OS developer extension, we are unable to initiate debugger sessions. We already specified db2forzosdeveloperextension.db2sqlservice.debugger.sessionManagerPort to portnumber that we configured in DB2UDSMD. Its the same port number that is working fine with Data Studio. When we try to trace the issue, it looks like it is trying to search for portnumber of local machine instead of z/os hostname. In DataStudio, we have the option to specify Debug session manager hostname and port number. But in z/os extension tool, we don't see any setting to specify hostname of z/os for debugging.

In WLMD(WLM Debugger address space) on z/os, we see below error when try to initiate debug session from DB2 z/os extension. Connect failed: EDC8116I Address not available. (errno2=0x76637240)

-

Expected behavior

-

[b-tsao]

Hi @rameshmot, the debugger session manager port is the port opened on local to establish a connection with Db2z debugger. Could you provide additional information regarding the error Address not available? Where is it trying to connect? Logs would be appreciated.

Thanks!