Debugger 2.0.2 service is messed up

[duieolson]

Type: Bug
Sorry for the length, bug I have to open a new issue on the debugger.
New dev system. SJ03030 is on. V2.0.2 loaded.

I just went thru the process of cleaning up the .env file so that nothing is after line 60.
I then deleted the certs in the IFS.
I then deleted the cert on my laptop.
I then restarted VSCode, Connect and Reload.
Swithed to the Debug perspective.
Status of the server, a green check.
Status of Service-Dead, Need to generate new certs. Took that option.
Generated and downloaded new cert.
Rebooted VSCode.
Redid the Connect and Reload
Opened Code for i. Opened a pgm source and made it ready to debug.
Switched to Debug perspective again. 2 green check marks.
switched back to Code for i. Started debug in Batch.
Worked!

I emailed dev team Debugger is up and working.
Dev member emailed back, no it is not.
We had a teams mtg to see his screen.
His Debug Server is a green check.
His Debug Service says 'Need to regenerate certificate'. What!??

1. Why is it not prompting that his current c:\Users<profile><hostname>_debug_service.crt file is just not matching and prompting for an import option?

So, to avoid that (what's the point, I just did it, plus I don't want them clicking on generate certs, ever), we went out to his c:\Users<profile><hostname>_debug_service.crt and we just deleted the cert file.

Restarted, VSCode on his system, along with a Connect and Reload.
Switched to the debug perspective. Server - green check.
Service- dead. wants to regenerate the certificate. Even though I just blew away the cert file from his laptop. Here's the screenshot of both my system on the left that just did a debug and his system on the right that he can't even connect the service job. He's stuck not able to get by the forced generate cert message. I was expecting the Service to say, wait, you dont have a matching cert. Import. That didn't happen.

So, with no cert, we then hovered on the system in the tray, choose Settings. Went to the Debugger tab, on the bottom, we clicked on the Download Certificate option. It downloaded it. Verified the cert file existed on his laptop.
Again, Restart VSCode, Connect and Reload.. Switch to Debug perspective... Status: Server-Green check. Service.. Forced to regenerate certificate. It didn't even know he just downloaded the cert. I guess I expected the download option to reset all check flags that are done to see if the server and service are ok and now in green check status.

That should have worked. But, it didn't reset the failed Service status to start over and go back to check and see if my laptop cert matches the system. Now I am starting to figure out why my developers are constantly generating new certificates. Cause it is unique to the person apparently.

How do I reset that flag that says force the cert regeneration to not know anything and go check it all again?

I dont know how to reset this or prevent this.

Extension version: 2.14.11
VS Code version: Code 1.97.2 (e54c774e0add60467559eb0d1e229c6452cf8447, 2025-02-12T23:20:35.343Z)
OS version: Windows_NT x64 10.0.22631
Modes:

System Info

Item	Value
CPUs	12th Gen Intel(R) Core(TM) i7-12800H (20 x 2803)
GPU Status	2d_canvas: enabled canvas_oop_rasterization: enabled_on direct_rendering_display_compositor: disabled_off_ok gpu_compositing: enabled multiple_raster_threads: enabled_on opengl: enabled_on rasterization: enabled raw_draw: disabled_off_ok skia_graphite: disabled_off video_decode: enabled video_encode: enabled vulkan: disabled_off webgl: enabled webgl2: enabled webgpu: enabled webnn: disabled_off
Load (avg)	undefined
Memory (System)	63.65GB (45.13GB free)
Process Argv	--crash-reporter-id 5e90849e-ef2b-4bc3-97a3-9254bf36265e
Screen Reader	no
VM	0%

A/B Experiments

vsliv368cf:30146710
vspor879:30202332
vspor708:30202333
vspor363:30204092
vscod805cf:30301675
binariesv615:30325510
py29gd2263:31024239
c4g48928:30535728
azure-dev_surveyone:30548225
a9j8j154:30646983
962ge761:30959799
2e7ec940:31000449
pythontbext0:30879054
cppperfnew:31000557
dwnewjupytercf:31046870
nativerepl2:31139839
pythonrstrctxt:31112756
nativeloc1:31192215
iacca1:31171482
5fd0e150:31155592
dwcopilot:31170013
6074i472:31201624
dwoutputs:31242946
customenabled:31248079
5a9hg449:31230677
hdaa2157:31222309
copilot_t_ci:31222730
jda6j935:31233686
cp15370_t:31242499
copilothoveroff:31248523

[duieolson]

I am going to add an addendum here as I feel it important. I have an update and its even worse than I thought. However, its consistent!

I just went to another dev system, went thru the clean up and setup process, and got it working so the debug worked. Notified the dev team for that system that debugger was running. Anyway, I ran a test today after my earlier post when I opened this issue and the debug still worked.

I then grabbed a colleague and we did a test with his laptop on the same IBM i dev system. Same version of vscode and all extensions updated. I watched him do it.
Then had him startup his connection. Did a Connect and Reload. Switched to the debug perspective. Same issue.
The service wont' start. It is forcing a certificate regeneration, just like the other system.

This is a screen shot of my system on the left and his system on the right. You can see the server and service job numbers are identical, just like my previous post image showed on that system.

I had him open his file explorer to look for a cert. One is there. It was old, but it was there.

It should have prompted him that there was a cert mismatch, Import option allowed. Didn't.

I guess I call that a pattern now. Again, explains why developers were cranking out new certs multiple times a day. One generates, debugs what they need, then another comes along, generates and debugs, then another gens certs and debugs. Like a revolving door.

Hope this helps.

[sebjulliand]

Sounds like there is an issue when the debug service status is being checked.
When connecting, if the service is running but the local certificate doesn't match, the debug view will offer to download and update it.
Something goes wrong at this point for your colleagues since they are offered to regenerate the certificate entirely.
Could you get the Code for i output from one of your colleagues session after he connecs and access the debug view, after you have restarted the service? Thanks!

[duieolson]

Here you go Sebastien,
Couple notes.
I tried to genericize the log for security purposes.
The colleagues profile I changed to in its place.
Profile used to start the qb5router is changed to
Service started by profile is changed to

codeforioutputlog_debug serviceForceRegenCert.txt

[sebjulliand]

Thanks @duieolson !
Can you get your colleague to run these commands and give me the output?

This should return 0:

test -r /QIBM/UserData/IBMiDebugService/.code4i.debug; echo $?

This should return 0 too :

test -r /QIBM/UserData/IBMiDebugService/C4iDebugService.env; echo $?

This should return CODE4IDEBUG=$([ -f $DBGSRV_WRK_DIR/.code4i.debug ] && cp $DBGSRV_WRK_DIR/.code4i.debug $DBGSRV_WRK_DIR/key.properties):

cat /QIBM/UserData/IBMiDebugService/C4iDebugService.env | grep CODE4IDEBUG

Let me know how it goes; thanks!

[duieolson]

Here ya go.

[mkwan01]

@sebjulliand Is there any update to this issue?

[worksofliam]

@duieolson We're going to need your help so we can collect more information about your setup.

Please see this PR and download the VSIX that is available and install it into your VS Code instance. Following that, navigate to the Debug View after connecting to a system and head to the Code for IBM i output channel.

Please share the contents of your Code for IBM i output channel after the error appears in the view.

[duieolson]

I am trying to get you want you need, but I am now struggling to do that.
My dev system was rebooted over the weekend. So the debug server wasn't running, which i started back up.
Now in VSCode, I get the server started, but when I went to start the service, it thru this error. I removed my cert on my local drive and restarted VSCode. Debugger said no local cert found, I said import. It did. Restarted VSCode. Connected again. Stil wouldn't start. Smoked the certs on the userdata/certs directory and the one in my local drive. Restarted and it prompted for me to Generate Certs where I say yeah go ahead and it did and downloaded. Restarted VSCode and the service did not start. Went to start it. Same error as the other times.

java version "11.0.25" 2024-10-15
IBM Semeru Runtime Certified Edition (build 11.0.25+9)
Eclipse OpenJ9 VM (build openj9-0.48.0, JRE 11 OS/400 ppc64-64-Bit Compressed References 20241217_000000 (JIT enabled, AOT enabled
OpenJ9 - 1d5831436e
OMR - d10a4d553
JCL - 4668c27671 based on jdk-11.0.25+9)
Encrytion key file does not exist: /home/myprofile/key.properties
EQARD1001E Remote Debug Service failed to start because the argument -data is invalid.
Use the -help option to display the command line help.

I also thought about the configuration file and I went into there and cleared out anything after line 60.
Tried to restart the service, now I get this error.

java version "17.0.13" 2024-10-15
IBM Semeru Runtime Certified Edition (build 17.0.13+11)
Eclipse OpenJ9 VM (build openj9-0.48.0, JRE 17 OS/400 ppc64-64-Bit Compressed References 20241217_000000 (JIT enabled, AOT enabled)
OpenJ9 - 1d5831436e
OMR - d10a4d553
JCL - 4e6d65012a0 based on jdk-17.0.13+11)
Incorrect Java version. Java 11 is required.

So I keep digging and find out that our PTF crew just put on a new set of PTFs. Including 5770JV1 Java 17
Licensed Installed
Program Release Description
5722IP1 V5R3M0 IBM Infoprint Server for iSeries
5770JV1 V7R5M0 IBM Developer Kit for Java
5770JV1 V7R5M0 Java SE 8 32 bit
5770JV1 V7R5M0 Java SE 8 64 bit
5770JV1 V7R5M0 Java SE 11 64 bit
5770JV1 V7R5M0 Java SE 17 64 bit

My other system that is debugging ok doesn't have that Java 17 yet. It will in a couple weeks. I presume that will break then too?

[worksofliam]

@duieolson On the system that is not starting up the Debug Service, can you please share the contents of these files:

• /QIBM/UserData/IBMiDebugService/C4iDebugService.env
• /QIBM/ProdData/IBMiDebugService/bin/DebugService.env
• /QIBM/ProdData/IBMiDebugService/package.json

[duieolson]

Sure Liam,
Here ya go.
vscodedebugfiles.zip

[sebjulliand]

C4iDebugService.env is the exact copy of DebugService.env; the lines added by Code for i after the certificate is generated are missing. They used to be there:

Try clearing the /QIBM/UserData/IBMiDebugService folder (keep it but remove everything inside) and re-generate the certificate once again.

[duieolson]

ok, cleared the noted directory leaving the directory itself.
Started the vscode startup and had to generate new keys and downloaded.
Restarted VSCode. Debug status shows server started, Service not.
I clicked on the start and it failed.

java version "11.0.25" 2024-10-15
IBM Semeru Runtime Certified Edition (build 11.0.25+9)
Eclipse OpenJ9 VM (build openj9-0.48.0, JRE 11 OS/400 ppc64-64-Bit Compressed References 20241217_000000 (JIT enabled, AOT enabled)
OpenJ9 - 1d5831436e
OMR - d10a4d553
JCL - 4668c27671 based on jdk-11.0.25+9)
Encrytion key file does not exist: /home/DOLS/key.properties
EQARD1001E Remote Debug Service failed to start because the argument -data is invalid.
Use the -help option to display the command line help.

Here's the same 3 files post reset.

[worksofliam]

@duieolson After you see the Debug View, can you please share the Code for IBM i output as requested before?

[duieolson]

Code for IBM i, version 2.15.3

.: echo "This should be the only text!"
{
"code": 0,
"signal": null,
"stdout": "This should be the only text!",
"stderr": ""
}

.: echo $HOME && cd && test -w $HOME
{
"code": 0,
"signal": null,
"stdout": "/home/",
"stderr": ""
}

/home/: /usr/bin/uname -rv
{
"code": 0,
"signal": null,
"stdout": "5 7",
"stderr": ""
}

/home/: echo "$HOME/.vscode/"
{
"code": 0,
"signal": null,
"stdout": "/home//.vscode/",
"stderr": ""
}

/home/: echo "$HOME/.vscode/"
{
"code": 0,
"signal": null,
"stdout": "/home//.vscode/",
"stderr": ""
}

/home/: echo "$HOME/.vscode/"
{
"code": 0,
"signal": null,
"stdout": "/home//.vscode/",
"stderr": ""
}

/home/: echo "$HOME/.vscode/"
{
"code": 0,
"signal": null,
"stdout": "/home//.vscode/",
"stderr": ""
}

Code for IBM i components:
cqsh (1): Installed
GetNewLibl (1): Installed
GetMemberInfo (2): Installed
CopyToImport (1): Installed

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1
liblist
{
"code": 0,
"signal": null,
"stdout": "RBTSYSLIB SYS\nQSYS SYS\nQSYS2 SYS\nQHLPSYS SYS\nQUSRSYS SYS\nQSHELL PRD\nQTEMP USR\nQGPL USR\nXIUTLLIB USR\nSXCUTLOBJ USR\nSXCUTLFIL USR\nPKZIP USR\nCDPRDOBJ USR\nCOOLSPV7R1 USR\nACMSLIB USR",
"stderr": ""
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1
system "CRTLIB LIB(ILEDITOR) TEXT('Code for i temporary objects. May be cleared.')"
/home/: [ -d "/tmp" ]
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

{
"code": 1,
"signal": null,
"stdout": "",
"stderr": "CPF2111: Library ILEDITOR already exists.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: echo $SHELL
{
"code": 0,
"signal": null,
"stdout": "/QOpenSys/pkgs/bin/bash",
"stderr": ""
}

/home/: test -r /QIBM/UserData/IBMiDebugService/C4iDebugService.env
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
values current_server
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\n00001 \n------------------\nRXDV1 \n\n 1 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

CCSID information:
QCCSID: 65535
User Job CCSID: 37
User Default CCSID: 37
/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
With VARIANTS ( HASH, AT, DOLLARSIGN ) as ( values ( cast( x'7B' as varchar(1) ) , cast( x'7C' as varchar(1) ) , cast( x'5B' as varchar(1) ) ))Select HASH concat AT concat DOLLARSIGN as LOCAL from VARIANTS
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nLOCAL \n------\n#@$ \n\n 1 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select job_name, local_port from qsys2.netstat_job_info where cast(local_port_name as VarChar(14) CCSID 37) = 'is-debug-ile' fetch first row only
/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select job_name, local_port from qsys2.netstat_job_info j where job_name = (select job_name from qsys2.netstat_job_info j where local_port = 8005 and remote_address = '0.0.0.0' fetch first row only) and remote_address = '0.0.0.0'
/home/: test -r /QIBM/UserData/IBMiDebugService/C4iDebugService.env
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJOB_NAME LOCAL_PORT \n---------------------------- -----------\n772411//QB5ROUTER 3825\n\n 1 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: test -r /QIBM/ProdData/IBMiDebugService/package.json
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJOB_NAME LOCAL_PORT \n---------------------------- -----------\n\n 0 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: test -r /QIBM/UserData/IBMiDebugService/C4iDebugService.env
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select job_name, local_port from qsys2.netstat_job_info where cast(local_port_name as VarChar(14) CCSID 37) = 'is-debug-ile' fetch first row only
/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select job_name, local_port from qsys2.netstat_job_info j where job_name = (select job_name from qsys2.netstat_job_info j where local_port = 8005 and remote_address = '0.0.0.0' fetch first row only) and remote_address = '0.0.0.0'
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJOB_NAME LOCAL_PORT \n---------------------------- -----------\n772411//QB5ROUTER 3825\n\n 1 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: test -r /QIBM/ProdData/IBMiDebugService/package.json
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1
system "CHKOBJ OBJ(QSYS/ON) OBJTYPE(*LIB) AUT(*NONE)"
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": "CPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
with SRCFILES as ( select rtrim(cast(t.SYSTEM_TABLE_SCHEMA as char(10) for bit data)) as LIBRARY, rtrim(cast(t.SYSTEM_TABLE_NAME as char(10) for bit data)) as NAME, '*FILE' as TYPE, 'PF' as ATTRIBUTE, t.TABLE_TEXT as TEXT, 1 as IS_SOURCE, t.ROW_LENGTH as SOURCE_LENGTH, t.IASP_NUMBER as IASP_NUMBER from QSYS2.SYSTABLES as t where t.FILE_TYPE = 'S' ) SELECT * FROM SRCFILES as f where f.LIBRARY = 'ON'
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJOB_NAME LOCAL_PORT \n---------------------------- -----------\n\n 0 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: test -r /QIBM/UserData/IBMiDebugService/C4iDebugService.env
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nLIBRARY NAME TYPE ATTRIBUTE TEXT IS_SOURCE SOURCE_LENGTH IASP_NUMBER \n---------- ---------- ----- ---------- -------------------------------------------------- ----------- -------------- ------------\nON $SRCSYS *FILE PF 1 124 0\nON EVFTEMPF01 *FILE PF 1 112 0\nON EVFTEMPF02 *FILE PF 1 112 0\nON QCLLESRC *FILE PF 1 124 0\nON QCLSRC *FILE PF 1 112 0\nON QCMDSRC *FILE PF 1 112 0\nON QCSRC *FILE PF 1 92 0\nON QDDSSRC *FILE PF 1 92 0\nON QPNLSRC *FILE PF Panel and Menu Source 1 92 0\nON QREXSRC *FILE PF 1 112 0\nON QRPGLESRC *FILE PF 1 112 0\nON QSQDSRC *FILE PF SQL PROCEDURES 1 160 0\nON QSQLSRC *FILE PF 1 112 0\nON QSQLSRC80 *FILE PF 1 92 0\nON QSRC *FILE PF 1 112 0\nON QTOOLS *FILE PF 1 92 0\nON QTSTSRC *FILE PF 1 112 0\nON VSCODE *FILE PF 1 112 0\nON XISPR1T001 *FILE PF 1 124 0\n\n 19 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1
system "CHKOBJ OBJ(QSYS/ON) OBJTYPE(*LIB) AUT(*NONE)"
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

{
"code": 0,
"signal": null,
"stdout": "",
"stderr": "CPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
with SRCFILES as ( select rtrim(cast(t.SYSTEM_TABLE_SCHEMA as char(10) for bit data)) as LIBRARY, rtrim(cast(t.SYSTEM_TABLE_NAME as char(10) for bit data)) as NAME, '*FILE' as TYPE, 'PF' as ATTRIBUTE, t.TABLE_TEXT as TEXT, 1 as IS_SOURCE, t.ROW_LENGTH as SOURCE_LENGTH, t.IASP_NUMBER as IASP_NUMBER from QSYS2.SYSTABLES as t where t.FILE_TYPE = 'S' ) SELECT * FROM SRCFILES as f where f.LIBRARY = 'ON'
/home/: test -r /QIBM/ProdData/IBMiDebugService/package.json
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nLIBRARY NAME TYPE ATTRIBUTE TEXT IS_SOURCE SOURCE_LENGTH IASP_NUMBER \n---------- ---------- ----- ---------- -------------------------------------------------- ----------- -------------- ------------\nON $SRCSYS *FILE PF 1 124 0\nON EVFTEMPF01 *FILE PF 1 112 0\nON EVFTEMPF02 *FILE PF 1 112 0\nON QCLLESRC *FILE PF 1 124 0\nON QCLSRC *FILE PF 1 112 0\nON QCMDSRC *FILE PF 1 112 0\nON QCSRC *FILE PF 1 92 0\nON QDDSSRC *FILE PF 1 92 0\nON QPNLSRC *FILE PF Panel and Menu Source 1 92 0\nON QREXSRC *FILE PF 1 112 0\nON QRPGLESRC *FILE PF 1 112 0\nON QSQDSRC *FILE PF SQL PROCEDURES 1 160 0\nON QSQLSRC *FILE PF 1 112 0\nON QSQLSRC80 *FILE PF 1 92 0\nON QSRC *FILE PF 1 112 0\nON QTOOLS *FILE PF 1 92 0\nON QTSTSRC *FILE PF 1 112 0\nON VSCODE *FILE PF 1 112 0\nON XISPR1T001 *FILE PF 1 124 0\n\n 19 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/: test -f /QIBM/UserData/IBMiDebugService/certs/debug_service.pfx
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/: test -f /QIBM/UserData/IBMiDebugService/certs/debug_service.crt
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/: test -f /QIBM/UserData/IBMiDebugService/.code4i.debug
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/: test -f /QIBM/ProdData/IBMiDebugService/bin/certs/debug_service.pfx
{
"code": 1,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/: test -r /QIBM/UserData/IBMiDebugService/C4iDebugService.env
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/: test -f /QIBM/UserData/IBMiDebugService/.code4i.debug
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/: test -f /QIBM/UserData/IBMiDebugService/certs/debug_service.pfx
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/: test -f /QIBM/UserData/IBMiDebugService/certs/debug_service.crt
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/: cat /QIBM/UserData/IBMiDebugService/certs/debug_service.crt
{
"code": 0,
"signal": null,
"stdout": "-----BEGIN CERTIFICATE-----\nMIIDGDCCAgCgAwIBAgIUcsSob9BaAccvLZsVrgvN6mVuKH8wDQYJKoZIhvcNAQEL\nBQAwHTEbMBkGA1UEAwwSQVBTSTkwNkUuT1BUVU0uQ09NMB4XDTI1MDMxODEyMzI0\nNFoXDTI4MDMxNzEyMzI0NFowHTEbMBkGA1UEAwwSQVBTSTkwNkUuT1BUVU0uQ09N\nMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA4TAWZ3qP/jEhqBC+mqvx\nc2ByCcT2qBLelfG44Z+wNrTNzDaBblsDDQNKl1v/1UxkDQRZBpgwnKKFlM4VqEfu\nLeFuu/DLxgti1cYdYhH15IGpQuZhW0GNuE3xrJOCvlgO2r3fniDqs5319t2AEFW/\nKPzp+frNRDnlJt/2B+g8mjWM/xzBYb0nL5l0a24s8TFqc8VpzkYnjWdXjx6LXEzt\nDJMqX1NnkZGnuQeINnF7nc0geRerRHXKKXZ7IPuPPc1dR8weiL+0UKh+H2Drxzk9\n12/IHrYRqdACkya/t857uj/p9aSw1BWj8qXP7gI95UOMpQt8KFa5BKCRP7N5hiCr\nuwIDAQABo1AwTjAtBgNVHREEJjAkghJBUFNJOTA2RS5PUFRVTS5DT02CCEFQU0k5\nMDZFhwQKaokfMB0GA1UdDgQWBBSMd4r1/OV5gksb5LMPait3C3Tw8DANBgkqhkiG\n9w0BAQsFAAOCAQEAODoUlcOrLE/2NQIRHRUc6U5oRHJHcTlGjGvwIOu85As3QS4d\n5J6NjT6ldLrSZ1iopAhnXqgsWB5Hzuun4UYyMbZHdoi/acun/H2iYg7B/KX8g3/s\n/+ctn+VFISl/YgU1kTrrFmUoRlrNqIfdet0A4iwXEa4OS30ebkYy68F7MRxyvRYy\nwVNS7PQ/7l/QTG/7h6sJ3l0TBU5tjFMES6DSmyZOsExEsRyJHiY3MuBMkQqGEXob\nd4MVcapNvv9GVn7BtiBTIaS6+pHG1K2IIVfhcLV1dV8iAQrhcPfAg/5nD8T+FA5L\nMuh6pQNMYgu3OhX+v+uOcF3cXsdrMBzET4QO0A==\n-----END CERTIFICATE-----",
"stderr": ""
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select job_name, local_port from qsys2.netstat_job_info where cast(local_port_name as VarChar(14) CCSID 37) = 'is-debug-ile' fetch first row only
/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select job_name, local_port from qsys2.netstat_job_info j where job_name = (select job_name from qsys2.netstat_job_info j where local_port = 8005 and remote_address = '0.0.0.0' fetch first row only) and remote_address = '0.0.0.0'
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJOB_NAME LOCAL_PORT \n---------------------------- -----------\n772411//QB5ROUTER 3825\n\n 1 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJOB_NAME LOCAL_PORT \n---------------------------- -----------\n\n 0 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select trim(coalesce(usr.special_authorities,'') concat ' ' concat coalesce(grp.special_authorities, '')) AUTHORITIES from qsys2.user_info_basic usr left join qsys2.user_info_basic grp on grp.authorization_name = usr.group_profile_name where usr.authorization_name = ''
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nAUTHORITIES \n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\n*ALLOBJ *SECADM *JOBCTL *SPLCTL *SAVSYS *SERVICE *AUDIT *IOSYSCFG *ALLOBJ *SECADM *JOBCTL *SPLCTL *SAVSYS *SERVICE *AUDIT *IOSYSCFG \n\n 1 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object QSQUS00001 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZLSCKSVR in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QSQUS00002 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZLSCKSVR in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: test -r /QIBM/UserData/IBMiDebugService/C4iDebugService.env
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/QIBM/UserData/IBMiDebugService: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1
system "SBMJOB CMD(STRQSH CMD('/QOpenSys/pkgs/bin/bash -c ''cp /QIBM/UserData/IBMiDebugService/C4iDebugService.env /QIBM/ProdData/IBMiDebugService/bin/DebugService.env; /QIBM/ProdData/IBMiDebugService/bin/startDebugService.sh''')) JOB(DBGSVCE) JOBQ(QSYS/QUSRNOMAX) JOBD(QSYS/QSYSJOBD) USER(*CURRENT)"
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC1221: Job 838721//DBGSVCE submitted to job queue QUSRNOMAX in library QSYS.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select job_name_short "Job name", job_user "Job user", job_number "Job number", subsystem_library_name concat '/' concat subsystem as "Subsystem", authorization_name "Current user", job_status "Job status", memory_pool "Memory pool" from table(qsys2.active_job_info(job_name_filter => 'DBGSVCE')) where job_name = '838721//DBGSVCE' fetch first row only
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJob name Job user Job number Subsystem Current user Job status Memory pool \n---------- ---------- ----------- --------------------- ------------- ----------- ------------\nDBGSVCE 838721 QSYS/QUSRWRK TIMA BASE \n\n 1 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select job_name, local_port from qsys2.netstat_job_info j where job_name = (select job_name from qsys2.netstat_job_info j where local_port = 8005 and remote_address = '0.0.0.0' fetch first row only) and remote_address = '0.0.0.0'
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJOB_NAME LOCAL_PORT \n---------------------------- -----------\n\n 0 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select job_name_short "Job name", job_user "Job user", job_number "Job number", subsystem_library_name concat '/' concat subsystem as "Subsystem", authorization_name "Current user", job_status "Job status", memory_pool "Memory pool" from table(qsys2.active_job_info(job_name_filter => 'DBGSVCE')) where job_name = '838721//DBGSVCE' fetch first row only
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJob name Job user Job number Subsystem Current user Job status Memory pool \n---------- ---------- ----------- --------------------- ------------- ----------- ------------\nDBGSVCE 838721 QSYS/QUSRWRK TIMW BASE \n\n 1 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select job_name, local_port from qsys2.netstat_job_info j where job_name = (select job_name from qsys2.netstat_job_info j where local_port = 8005 and remote_address = '0.0.0.0' fetch first row only) and remote_address = '0.0.0.0'
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJOB_NAME LOCAL_PORT \n---------------------------- -----------\n\n 0 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select job_name_short "Job name", job_user "Job user", job_number "Job number", subsystem_library_name concat '/' concat subsystem as "Subsystem", authorization_name "Current user", job_status "Job status", memory_pool "Memory pool" from table(qsys2.active_job_info(job_name_filter => 'DBGSVCE')) where job_name = '838721//DBGSVCE' fetch first row only
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJob name Job user Job number Subsystem Current user Job status Memory pool \n---------- ---------- ----------- --------------------- ------------- ----------- ------------\nDBGSVCE 838721 QSYS/QUSRWRK TIMW BASE \n\n 1 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select job_name, local_port from qsys2.netstat_job_info j where job_name = (select job_name from qsys2.netstat_job_info j where local_port = 8005 and remote_address = '0.0.0.0' fetch first row only) and remote_address = '0.0.0.0'
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJOB_NAME LOCAL_PORT \n---------------------------- -----------\n\n 0 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select job_name_short "Job name", job_user "Job user", job_number "Job number", subsystem_library_name concat '/' concat subsystem as "Subsystem", authorization_name "Current user", job_status "Job status", memory_pool "Memory pool" from table(qsys2.active_job_info(job_name_filter => 'DBGSVCE')) where job_name = '838721//DBGSVCE' fetch first row only
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJob name Job user Job number Subsystem Current user Job status Memory pool \n---------- ---------- ----------- --------------------- ------------- ----------- ------------\nDBGSVCE 838721 QSYS/QUSRWRK TIMA BASE \n\n 1 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select job_name, local_port from qsys2.netstat_job_info j where job_name = (select job_name from qsys2.netstat_job_info j where local_port = 8005 and remote_address = '0.0.0.0' fetch first row only) and remote_address = '0.0.0.0'
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJOB_NAME LOCAL_PORT \n---------------------------- -----------\n\n 0 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select job_name_short "Job name", job_user "Job user", job_number "Job number", subsystem_library_name concat '/' concat subsystem as "Subsystem", authorization_name "Current user", job_status "Job status", memory_pool "Memory pool" from table(qsys2.active_job_info(job_name_filter => 'DBGSVCE')) where job_name = '838721//DBGSVCE' fetch first row only
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJob name Job user Job number Subsystem Current user Job status Memory pool \n---------- ---------- ----------- --------------------- ------------- ----------- ------------\n\n 0 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

[worksofliam]

@duieolson Can you please confirm you are using the VSIX that was built for this?

[duieolson]

Sorry Liam, I was not.. Here is the code for i output with VSIX installed.
select job_name, local_port from qsys2.netstat_job_info j where job_name = (select job_name from qsys2.netstat_job_info j where local_port = 8005 and remote_address = '0.0.0.0' fetch first row only) and remote_address = '0.0.0.0'
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJOB_NAME LOCAL_PORT \n---------------------------- -----------\n\n 0 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select job_name_short "Job name", job_user "Job user", job_number "Job number", subsystem_library_name concat '/' concat subsystem as "Subsystem", authorization_name "Current user", job_status "Job status", memory_pool "Memory pool" from table(qsys2.active_job_info(job_name_filter => 'DBGSVCE')) where job_name = '840621//DBGSVCE' fetch first row only
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJob name Job user Job number Subsystem Current user Job status Memory pool \n---------- ---------- ----------- --------------------- ------------- ----------- ------------\nDBGSVCE 840621 QSYS/QUSRWRK TIMW BASE \n\n 1 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select job_name, local_port from qsys2.netstat_job_info j where job_name = (select job_name from qsys2.netstat_job_info j where local_port = 8005 and remote_address = '0.0.0.0' fetch first row only) and remote_address = '0.0.0.0'
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJOB_NAME LOCAL_PORT \n---------------------------- -----------\n\n 0 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select job_name_short "Job name", job_user "Job user", job_number "Job number", subsystem_library_name concat '/' concat subsystem as "Subsystem", authorization_name "Current user", job_status "Job status", memory_pool "Memory pool" from table(qsys2.active_job_info(job_name_filter => 'DBGSVCE')) where job_name = '840621//DBGSVCE' fetch first row only
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJob name Job user Job number Subsystem Current user Job status Memory pool \n---------- ---------- ----------- --------------------- ------------- ----------- ------------\nDBGSVCE 840621 QSYS/QUSRWRK TIMW BASE \n\n 1 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select job_name, local_port from qsys2.netstat_job_info j where job_name = (select job_name from qsys2.netstat_job_info j where local_port = 8005 and remote_address = '0.0.0.0' fetch first row only) and remote_address = '0.0.0.0'
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJOB_NAME LOCAL_PORT \n---------------------------- -----------\n\n 0 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select job_name_short "Job name", job_user "Job user", job_number "Job number", subsystem_library_name concat '/' concat subsystem as "Subsystem", authorization_name "Current user", job_status "Job status", memory_pool "Memory pool" from table(qsys2.active_job_info(job_name_filter => 'DBGSVCE')) where job_name = '840621//DBGSVCE' fetch first row only
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJob name Job user Job number Subsystem Current user Job status Memory pool \n---------- ---------- ----------- --------------------- ------------- ----------- ------------\nDBGSVCE 840621 QSYS/QUSRWRK TIMW BASE \n\n 1 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select job_name, local_port from qsys2.netstat_job_info j where job_name = (select job_name from qsys2.netstat_job_info j where local_port = 8005 and remote_address = '0.0.0.0' fetch first row only) and remote_address = '0.0.0.0'
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJOB_NAME LOCAL_PORT \n---------------------------- -----------\n\n 0 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}

/home/: LC_ALL=EN_US.UTF-8 /home//.vscode/cqsh_1 -c "system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')""
select job_name_short "Job name", job_user "Job user", job_number "Job number", subsystem_library_name concat '/' concat subsystem as "Subsystem", authorization_name "Current user", job_status "Job status", memory_pool "Memory pool" from table(qsys2.active_job_info(job_name_filter => 'DBGSVCE')) where job_name = '840621//DBGSVCE' fetch first row only
{
"code": 0,
"signal": null,
"stdout": "DB2>\n ?>\n\nJob name Job user Job number Subsystem Current user Job status Memory pool \n---------- ---------- ----------- --------------------- ------------- ----------- ------------\n\n 0 RECORD(S) SELECTED.",
"stderr": "CPFA0A9: Object not found. Object is EN_US.UTF-8.\nCPC2206: Ownership of object SQUS000000 in QTEMP type *USRSPC changed.\nCPC2206: Ownership of object QZSHSYSTEM in QTEMP type *USRSPC changed."
}