Connection dropped

[cirikus]

Hi,

When i try to connect with VS Code For Ibm I, at the last, i have this window

And if i try to connect again, I have the same issue ;)

For you, what is the issue please ?

Thks a lot

[sebjulliand]

Hi @cirikus ,
This is most likely a network issue.
Try connecting with an ssh client like putty to see if the connection drops as well. If it does, then get in touch with your sys admin or network admin to figure out why the ssh server on the I drops the connection.

[cirikus]

With Putty, that's fine ;)

Settings on Code For Ibm I for SSH ?

[worksofliam]

Do you get this instantly after you connect? That would be odd.

[cirikus]

Juste after Cancel a warning "The Data Area QSYS/QCPFRMIMPF........."

I specify I have a VPN on my professional laptop and team has opened the port

[cirikus]

Hi,
I have always my issue ;)

Log for code for i when i try to connect :

Code for IBM i, version 2.14.5

.: 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/SSALOMON/",
"stderr": ""
}

/home/SSALOMON/: ls -p /usr/bin/
{
"code": 0,
"signal": null,
"stdout": "Rfile\najar\nappletviewer\napt\narmsrv\narmsrvconv\nattr\nbasename\nbash\ncat\ncatsplf\nchgrp\nchmod\nchown\nclrtmp\ncmp\ncompress\ncp\ncut\ndataq\ndatarea\ndate\ndb2\ndb2profc\ndb2profc_trace\ndb2profp\nddns-confgen\ndelv\ndfmadmin\ndhcpd\ndhcrelay\ndig\ndirname\ndnssec-dsfromkey\ndnssec-importkey\ndnssec-keyfromlabel\ndnssec-keygen\ndnssec-revoke\ndnssec-settime\ndnssec-signzone\ndnssec-verify\ndspmsg\necho\negrep\nenv\nexpr\nextcheck\nfgrep\nfile\nfind\ngencat\ngetjobid\ngrep\nhead\nhost\nhostname\nhttpapi\niconv\nid\nidlj\nikeyman\nipcrm\nipcs\nixlc\njar\njarsigner\njava\njavac\njavadoc\njavah\njavap\njconsole\njdb\njdmpview\njextract\nkdestroy\nkeytab\nkeytool\nkinit\nklist\nkpasswd\nksetup\nldapadd\nldapchangepwd\nldapcompare\nldapdelete\nldapdiff\nldapexop\nldapmodify\nldapmodrdn\nldapsearch\nln\nlocale\nlogger\nlogname\nls\nmkdir\nmkfifo\nmv\nnamed\nnamed-checkconf\nnamed-checkzone\nnamed-compilezone\nnamed-journalprint\nnamed-rrchecker\nnative2ascii\nnohup\nnslookup\nnsupdate\nod\norbd\npack200\npax\npolicytool\npr\nprintenv\nprofconv\nprofdb\nprofp\nps\npwd\npwdx\nqsh\nrexec\nrexx\nrm\nrmdir\nrmic\nrmid\nrmiregistry\nrndc\nrndc-confgen\nschemagen\nsed\nserialver\nservertool\nsetccsid\nsh\nsort\nsplit\nsqlj\nstrEKM\nsystem\nsysval\ntail\ntar\ntee\ntest\ntnameserv\ntouch\ntr\ntsig-keygen\nuname\nuncompress\nuniq\nunpack200\nwc\nwsgen\nwsimport\nxargs\nxjc\nzcat",
"stderr": ""
}

/home/SSALOMON/: ls -p /QOpenSys/pkgs/bin/
{
"code": 0,
"signal": null,
"stdout": "2to3\n2to3-3.6\n2to3-3.9\n5250keys\n[\naddbuiltin\nalternatives\natob\nbaddbdir\nbase32\nbase64\nbasename\nbash\nbashbug\nbltest\nbtoa\nc++\nc2ph\ncat\ncc\ncertcgi\ncertutil\nchardetect\nchcon\nchgrp\nchktest\nchmod\nchown\nchroot\nchsh\ncksum\ncmsutil\ncomm\nconflict\ncorelist\ncp\ncpan\ncpp-6\ncpp-6.bin\ncrlutil\ncrmftest\ncsplit\ncurl\ncut\ncwbcopwr\ncwbmedic\ncwbnltbl\ncwbping\ncwbtrc\ncygdb\ncython\ncythonize\ndate\ndbtest\ndd\ndebuginfo-install\nderdump\ndertimetest\ndf\ndigest\ndir\ndircolors\ndirname\ndltest\ndu\necho\necperf\negrep\nenc2xs\nencguess\nencodeinttest\nenv\nexample\nexpand\nexpr\nfactor\nfalse\nfbectest\nfgrep\nfind-repos-of-install\nfipstest\nfmt\nfold\ng++\ng++-6\ng++-6.bin\ngcc\ngcc-6\ngcc-6.bin\ngcc-ar\ngcc-ar-6\ngcc-ar-6.bin\ngcc-nm\ngcc-nm-6\ngcc-nm-6.bin\ngcc-ranlib\ngcc-ranlib-6\ngcc-ranlib-6.bin\ngcov\ngcov-6\ngendiff\ngrep\ngroups\ngunzip\ngzexe\ngzip\nh2ph\nh2xs\nhead\nhostid\nhttpserv\nid\nidle3\nidle3.6\nidle3.9\ninstall\ninstmodsh\nisql\niusql\njoin\njson_pp\nkill\nlibnetcfg\nlibtool\nlibtoolize\nlink\nlistsuites\nln\nlogname\nlp5250d\nls\nmakepqg\nmangle\nmd5sum\nminigzip\nmkdir\nmkfifo\nmknod\nmktemp\nmodutil\nmultinit\nmv\nneeds-restarting\nnice\nnl\nnohup\nnonspr10\nnproc\nnumfmt\nocspclnt\nocspresp\nod\nodbc_config\nodbcinst\noidcalc\np7content\np7env\np7sign\np7verify\npackage-cleanup\npaste\npathchk\nperl\nperl5.24.1\nperlbug\nperldoc\nperlivp\nperlthanks\npiconv\npinky\npip3\npip3.9\npk11ectest\npk11gcmtest\npk11mode\npk12util\npk1sign\npkix-errcodes\npl2pm\npod2html\npod2man\npod2text\npod2usage\npodchecker\npodselect\npp\npr\nprintenv\nprintf\nprove\npstruct\nptar\nptardiff\nptargrep\nptx\npwd\npwdecrypt\npydoc\npydoc3\npydoc3.6\npydoc3.9\npython\npython2\npython2.7\npython3\npython3.6\npython3.6m\npython3.9\npython3.9-config\npyvenv-3.6\nreadlink\nrealpath\nremtest\nrepo-graph\nrepo-rss\nrepoclosure\nrepodiff\nrepomanage\nrepoquery\nreposync\nrepotrack\nrm\nrmdir\nrpm\nrpm2archive\nrpm2cpio\nrpmdb\nrpmgraph\nrpmkeys\nrpmquery\nrpmsign\nrpmspec\nrpmverify\nrsaperf\nruncon\nscs2ascii\nscs2pdf\nscs2ps\nsdrtest\nsecmodtest\nselfserv\nseq\nsha1sum\nsha224sum\nsha256sum\nsha384sum\nsha512sum\nshasum\nshlibsign\nshow-changed-rco\nshow-installed\nshred\nshuf\nsigntool\nsignver\nsleep\nslencheck\nsmtpd.py\nsort\nsplain\nsplit\nssltap\nstat\nstdbuf\nstrsclnt\nstty\nsum\nsymkeyutil\nsync\ntac\ntail\ntee\ntest\ntimeout\ntn5250\ntouch\ntox\ntr\ntrue\ntruncate\ntrust\ntsort\ntstclnt\ntty\nuname\nuncompress\nunexpand\nuniq\nunlink\nupdate-alternatives\nupdate-ca-certificates\nuptime\nurlgrabber\nusers\nvdir\nverifytree\nvfychain\nvfyserv\nvirtualenv\nwc\nwhataformatter\nwheel\nwho\nwhoami\nxml2-config\nxslt-config\nxsltproc\nxsubpp\nxt5250\nyes\nyum\nyum-builddep\nyum-complete-transaction\nyum-config-manager\nyum-debug-dump\nyum-debug-restore\nyum-groups-manager\nyumdb\nyumdownloader\nzcat\nzcmp\nzdiff\nzegrep\nzfgrep\nzforce\nzgrep\nzipdetails\nzless\nzmore\nznew",
"stderr": ""
}

/home/SSALOMON/: ls -p /QSYS.LIB/QZDFMDB2.PGM
{
"code": 0,
"signal": null,
"stdout": "/QSYS.LIB/QZDFMDB2.PGM",
"stderr": ""
}

/home/SSALOMON/: ls -p /QIBM/ProdData/IBMiDebugService/bin/startDebugService.sh
{
"code": 0,
"signal": null,
"stdout": "/QIBM/ProdData/IBMiDebugService/bin/startDebugService.sh",
"stderr": ""
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: test -x /QOpenSys/QIBM/ProdData/JavaVM/jdk80/64bit/bin/java
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: test -x /QOpenSys/QIBM/ProdData/JavaVM/jdk11/64bit/bin/java
{
"code": 1,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: test -x /QOpensys/pkgs/lib/jvm/openjdk-11/bin/java
{
"code": 1,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: test -x /QOpenSys/QIBM/ProdData/JavaVM/jdk17/64bit/bin/java
{
"code": 1,
"signal": null,
"stdout": "",
"stderr": ""
}

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

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

/home/SSALOMON/: test -x /home/SSALOMON/.vscode/cqsh_1
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: /home/SSALOMON/.vscode/cqsh_1
echo "Hello world"
{
"code": 9,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: chmod +x /home/SSALOMON/.vscode/cqsh_1
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: /home/SSALOMON/.vscode/cqsh_1
echo "Hello world"
{
"code": 9,
"signal": null,
"stdout": "",
"stderr": ""
}

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

/home/SSALOMON/: rm -rf /tmp/code4itempO_Sjnz3UaJZXxrbu7qncFb && mkdir -p /tmp/code4itempO_Sjnz3UaJZXxrbu7qncFb
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/: /QOpenSys/usr/bin/qsh
system "RUNSQLSTM SRCSTMF('/tmp/code4itempO_Sjnz3UaJZXxrbu7qncFb/getnewlibl.sql') COMMIT(*NONE) NAMING(*SQL)"
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: rm -rf /tmp/code4itempO_Sjnz3UaJZXxrbu7qncFb
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

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

/home/SSALOMON/: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')"
select cast(LONG_COMMENT as VarChar(200)) LONG_COMMENT from qsys2.sysroutines where routine_schema = 'ILEDITOR' and routine_name = 'GETMBRINFO'
{
"code": 0,
"signal": null,
"stdout": "DB2>\n PTXBEDEV-Traitement en Recette",
"stderr": ""
}

/home/SSALOMON/: rm -rf /tmp/code4itempO_J8vzHwdd5cCtpH6NlqFs && mkdir -p /tmp/code4itempO_J8vzHwdd5cCtpH6NlqFs
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/: /QOpenSys/usr/bin/qsh
system "RUNSQLSTM SRCSTMF('/tmp/code4itempO_J8vzHwdd5cCtpH6NlqFs/getMemberInfo.sql') COMMIT(*NONE) NAMING(*SQL)"
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: rm -rf /tmp/code4itempO_J8vzHwdd5cCtpH6NlqFs
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

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

Code for IBM i components:
0 (1): Error
1 (1): Installed
2 (0): Installed
3 (1): Installed

/home/SSALOMON/: /QOpenSys/usr/bin/qsh
liblist
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: /QOpenSys/usr/bin/qsh
system "CRTLIB LIB(ILEDITOR) TEXT('Code for i temporary objects. May be cleared.')"
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: [ -d "/tmp" ]
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

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

/home/SSALOMON/: /QOpenSys/usr/bin/qsh
system "CHKOBJ OBJ(QSYS/QCPTOIMPF) OBJTYPE(*DTAARA)"
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: /QOpenSys/usr/bin/qsh
system "CHKOBJ OBJ(QSYS/QCPFRMIMPF) OBJTYPE(*DTAARA)"
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: echo $PATH
{
"code": 0,
"signal": null,
"stdout": "/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin",
"stderr": ""
}

/home/SSALOMON/: test -e /home/SSALOMON//.bashrc
{
"code": 1,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: /QOpenSys/usr/bin/qsh
system "DLTOBJ OBJ(QSYS/QCPTOIMPF) OBJTYPE(*DTAARA)"
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: /QOpenSys/usr/bin/qsh
liblist -d
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: /QOpenSys/usr/bin/expr /QOpenSys/usr/bin/getconf ARG_MAX - env|wc -c - env|wc -l * 4 - 2048
{
"code": 0,
"signal": null,
"stdout": "4191777",
"stderr": ""
}

/home/SSALOMON/: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')"
Call QSYS2.QCMDEXC('CPYTOIMPF FROMFILE(QSYS2/ASP_INFO *FIRST) TOSTMF(''/tmp/vscodetemp-O_t57nSy6J'') MBROPT(*REPLACE) STMFCCSID(1208) RCDDLM(*CRLF) DTAFMT(*DLM) RMVBLANK(*TRAILING) ADDCOLNAM(*SQL) FLDDLM('','') DECPNT(*PERIOD)')
{
"code": 0,
"signal": null,
"stdout": "DB2>\n PTXBEDEV-Traitement en Recette",
"stderr": ""
}

/home/SSALOMON/: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')"
CREATE TABLE QTEMP.O_6ZZMG AS (select SYSTEM_VALUE_NAME, CURRENT_NUMERIC_VALUE from QSYS2.SYSTEM_VALUE_INFO where SYSTEM_VALUE_NAME = 'QCCSID') WITH DATA;
Call QSYS2.QCMDEXC('CPYTOIMPF FROMFILE(QTEMP/O_6ZZMG *FIRST) TOSTMF(''/tmp/vscodetemp-O_zml2LnjH'') MBROPT(*REPLACE) STMFCCSID(1208) RCDDLM(*CRLF) DTAFMT(*DLM) RMVBLANK(*TRAILING) ADDCOLNAM(*SQL) FLDDLM('','') DECPNT(*PERIOD)')
{
"code": 0,
"signal": null,
"stdout": "DB2>\n PTXBEDEV-Traitement en Recette",
"stderr": ""
}

/home/SSALOMON/: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')"
CREATE TABLE QTEMP.O_XD0PW AS (with SSH_DETAIL (id, iid) as ( select substring(job_name, locate('/', job_name, 15)+1, 10) as id, internal_job_id as iid from qsys2.netstat_job_info j where local_address = '0.0.0.0' and local_port = 22 ) select DEFAULT_CCSID, CCSID from table(QSYS2.ACTIVE_JOB_INFO( JOB_NAME_FILTER => (select id from SSH_DETAIL), DETAILED_INFO => 'ALL')) where INTERNAL_JOB_ID = (select iid from SSH_DETAIL)) WITH DATA;
Call QSYS2.QCMDEXC('CPYTOIMPF FROMFILE(QTEMP/O_XD0PW *FIRST) TOSTMF(''/tmp/vscodetemp-O_BGn3CsFG'') MBROPT(*REPLACE) STMFCCSID(1208) RCDDLM(*CRLF) DTAFMT(*DLM) RMVBLANK(*TRAILING) ADDCOLNAM(*SQL) FLDDLM('','') DECPNT(*PERIOD)')
{
"code": 0,
"signal": null,
"stdout": "DB2>\n PTXBEDEV-Traitement en Recette",
"stderr": ""
}

.: 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/SSALOMON/",
"stderr": ""
}

/home/SSALOMON/: ls -p /usr/bin/
{
"code": 0,
"signal": null,
"stdout": "Rfile\najar\nappletviewer\napt\narmsrv\narmsrvconv\nattr\nbasename\nbash\ncat\ncatsplf\nchgrp\nchmod\nchown\nclrtmp\ncmp\ncompress\ncp\ncut\ndataq\ndatarea\ndate\ndb2\ndb2profc\ndb2profc_trace\ndb2profp\nddns-confgen\ndelv\ndfmadmin\ndhcpd\ndhcrelay\ndig\ndirname\ndnssec-dsfromkey\ndnssec-importkey\ndnssec-keyfromlabel\ndnssec-keygen\ndnssec-revoke\ndnssec-settime\ndnssec-signzone\ndnssec-verify\ndspmsg\necho\negrep\nenv\nexpr\nextcheck\nfgrep\nfile\nfind\ngencat\ngetjobid\ngrep\nhead\nhost\nhostname\nhttpapi\niconv\nid\nidlj\nikeyman\nipcrm\nipcs\nixlc\njar\njarsigner\njava\njavac\njavadoc\njavah\njavap\njconsole\njdb\njdmpview\njextract\nkdestroy\nkeytab\nkeytool\nkinit\nklist\nkpasswd\nksetup\nldapadd\nldapchangepwd\nldapcompare\nldapdelete\nldapdiff\nldapexop\nldapmodify\nldapmodrdn\nldapsearch\nln\nlocale\nlogger\nlogname\nls\nmkdir\nmkfifo\nmv\nnamed\nnamed-checkconf\nnamed-checkzone\nnamed-compilezone\nnamed-journalprint\nnamed-rrchecker\nnative2ascii\nnohup\nnslookup\nnsupdate\nod\norbd\npack200\npax\npolicytool\npr\nprintenv\nprofconv\nprofdb\nprofp\nps\npwd\npwdx\nqsh\nrexec\nrexx\nrm\nrmdir\nrmic\nrmid\nrmiregistry\nrndc\nrndc-confgen\nschemagen\nsed\nserialver\nservertool\nsetccsid\nsh\nsort\nsplit\nsqlj\nstrEKM\nsystem\nsysval\ntail\ntar\ntee\ntest\ntnameserv\ntouch\ntr\ntsig-keygen\nuname\nuncompress\nuniq\nunpack200\nwc\nwsgen\nwsimport\nxargs\nxjc\nzcat",
"stderr": ""
}

/home/SSALOMON/: ls -p /QOpenSys/pkgs/bin/
{
"code": 0,
"signal": null,
"stdout": "2to3\n2to3-3.6\n2to3-3.9\n5250keys\n[\naddbuiltin\nalternatives\natob\nbaddbdir\nbase32\nbase64\nbasename\nbash\nbashbug\nbltest\nbtoa\nc++\nc2ph\ncat\ncc\ncertcgi\ncertutil\nchardetect\nchcon\nchgrp\nchktest\nchmod\nchown\nchroot\nchsh\ncksum\ncmsutil\ncomm\nconflict\ncorelist\ncp\ncpan\ncpp-6\ncpp-6.bin\ncrlutil\ncrmftest\ncsplit\ncurl\ncut\ncwbcopwr\ncwbmedic\ncwbnltbl\ncwbping\ncwbtrc\ncygdb\ncython\ncythonize\ndate\ndbtest\ndd\ndebuginfo-install\nderdump\ndertimetest\ndf\ndigest\ndir\ndircolors\ndirname\ndltest\ndu\necho\necperf\negrep\nenc2xs\nencguess\nencodeinttest\nenv\nexample\nexpand\nexpr\nfactor\nfalse\nfbectest\nfgrep\nfind-repos-of-install\nfipstest\nfmt\nfold\ng++\ng++-6\ng++-6.bin\ngcc\ngcc-6\ngcc-6.bin\ngcc-ar\ngcc-ar-6\ngcc-ar-6.bin\ngcc-nm\ngcc-nm-6\ngcc-nm-6.bin\ngcc-ranlib\ngcc-ranlib-6\ngcc-ranlib-6.bin\ngcov\ngcov-6\ngendiff\ngrep\ngroups\ngunzip\ngzexe\ngzip\nh2ph\nh2xs\nhead\nhostid\nhttpserv\nid\nidle3\nidle3.6\nidle3.9\ninstall\ninstmodsh\nisql\niusql\njoin\njson_pp\nkill\nlibnetcfg\nlibtool\nlibtoolize\nlink\nlistsuites\nln\nlogname\nlp5250d\nls\nmakepqg\nmangle\nmd5sum\nminigzip\nmkdir\nmkfifo\nmknod\nmktemp\nmodutil\nmultinit\nmv\nneeds-restarting\nnice\nnl\nnohup\nnonspr10\nnproc\nnumfmt\nocspclnt\nocspresp\nod\nodbc_config\nodbcinst\noidcalc\np7content\np7env\np7sign\np7verify\npackage-cleanup\npaste\npathchk\nperl\nperl5.24.1\nperlbug\nperldoc\nperlivp\nperlthanks\npiconv\npinky\npip3\npip3.9\npk11ectest\npk11gcmtest\npk11mode\npk12util\npk1sign\npkix-errcodes\npl2pm\npod2html\npod2man\npod2text\npod2usage\npodchecker\npodselect\npp\npr\nprintenv\nprintf\nprove\npstruct\nptar\nptardiff\nptargrep\nptx\npwd\npwdecrypt\npydoc\npydoc3\npydoc3.6\npydoc3.9\npython\npython2\npython2.7\npython3\npython3.6\npython3.6m\npython3.9\npython3.9-config\npyvenv-3.6\nreadlink\nrealpath\nremtest\nrepo-graph\nrepo-rss\nrepoclosure\nrepodiff\nrepomanage\nrepoquery\nreposync\nrepotrack\nrm\nrmdir\nrpm\nrpm2archive\nrpm2cpio\nrpmdb\nrpmgraph\nrpmkeys\nrpmquery\nrpmsign\nrpmspec\nrpmverify\nrsaperf\nruncon\nscs2ascii\nscs2pdf\nscs2ps\nsdrtest\nsecmodtest\nselfserv\nseq\nsha1sum\nsha224sum\nsha256sum\nsha384sum\nsha512sum\nshasum\nshlibsign\nshow-changed-rco\nshow-installed\nshred\nshuf\nsigntool\nsignver\nsleep\nslencheck\nsmtpd.py\nsort\nsplain\nsplit\nssltap\nstat\nstdbuf\nstrsclnt\nstty\nsum\nsymkeyutil\nsync\ntac\ntail\ntee\ntest\ntimeout\ntn5250\ntouch\ntox\ntr\ntrue\ntruncate\ntrust\ntsort\ntstclnt\ntty\nuname\nuncompress\nunexpand\nuniq\nunlink\nupdate-alternatives\nupdate-ca-certificates\nuptime\nurlgrabber\nusers\nvdir\nverifytree\nvfychain\nvfyserv\nvirtualenv\nwc\nwhataformatter\nwheel\nwho\nwhoami\nxml2-config\nxslt-config\nxsltproc\nxsubpp\nxt5250\nyes\nyum\nyum-builddep\nyum-complete-transaction\nyum-config-manager\nyum-debug-dump\nyum-debug-restore\nyum-groups-manager\nyumdb\nyumdownloader\nzcat\nzcmp\nzdiff\nzegrep\nzfgrep\nzforce\nzgrep\nzipdetails\nzless\nzmore\nznew",
"stderr": ""
}

/home/SSALOMON/: ls -p /QSYS.LIB/QZDFMDB2.PGM
{
"code": 0,
"signal": null,
"stdout": "/QSYS.LIB/QZDFMDB2.PGM",
"stderr": ""
}

/home/SSALOMON/: ls -p /QIBM/ProdData/IBMiDebugService/bin/startDebugService.sh
{
"code": 0,
"signal": null,
"stdout": "/QIBM/ProdData/IBMiDebugService/bin/startDebugService.sh",
"stderr": ""
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: ls -p /QSYS.lib/ILEDITOR.lib/GE*.PGM
{
"code": 2,
"signal": null,
"stdout": "",
"stderr": "/QSYS.lib/ILEDITOR.lib/GE*.PGM not found"
}

/home/SSALOMON/: test -x /QOpenSys/QIBM/ProdData/JavaVM/jdk80/64bit/bin/java
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: test -x /QOpenSys/QIBM/ProdData/JavaVM/jdk11/64bit/bin/java
{
"code": 1,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: test -x /QOpensys/pkgs/lib/jvm/openjdk-11/bin/java
{
"code": 1,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: test -x /QOpenSys/QIBM/ProdData/JavaVM/jdk17/64bit/bin/java
{
"code": 1,
"signal": null,
"stdout": "",
"stderr": ""
}

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

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

/home/SSALOMON/: test -x /home/SSALOMON/.vscode/cqsh_1
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: /home/SSALOMON/.vscode/cqsh_1
echo "Hello world"
{
"code": 9,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: chmod +x /home/SSALOMON/.vscode/cqsh_1
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: /home/SSALOMON/.vscode/cqsh_1
echo "Hello world"
{
"code": 9,
"signal": null,
"stdout": "",
"stderr": ""
}

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

/home/SSALOMON/: rm -rf /tmp/code4itempO_TAWXqb6mrqWqk5DWqWba && mkdir -p /tmp/code4itempO_TAWXqb6mrqWqk5DWqWba
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/: /QOpenSys/usr/bin/qsh
system "RUNSQLSTM SRCSTMF('/tmp/code4itempO_TAWXqb6mrqWqk5DWqWba/getnewlibl.sql') COMMIT(*NONE) NAMING(*SQL)"
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: rm -rf /tmp/code4itempO_TAWXqb6mrqWqk5DWqWba
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

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

/home/SSALOMON/: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')"
CREATE TABLE QTEMP.O_2FYPH AS (select cast(LONG_COMMENT as VarChar(200)) LONG_COMMENT from qsys2.sysroutines where routine_schema = 'ILEDITOR' and routine_name = 'GETMBRINFO') WITH DATA;
Call QSYS2.QCMDEXC('CPYTOIMPF FROMFILE(QTEMP/O_2FYPH *FIRST) TOSTMF(''/tmp/vscodetemp-O_zKOQ9817'') MBROPT(*REPLACE) STMFCCSID(1208) RCDDLM(*CRLF) DTAFMT(*DLM) RMVBLANK(*TRAILING) ADDCOLNAM(*SQL) FLDDLM('','') DECPNT(*PERIOD)')
{
"code": 0,
"signal": null,
"stdout": "DB2>\n PTXBEDEV-Traitement en Recette",
"stderr": ""
}

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

Code for IBM i components:
0 (1): Error
1 (1): Installed
2 (0): Error
3 (1): Installed

/home/SSALOMON/: /QOpenSys/usr/bin/qsh
liblist
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: /QOpenSys/usr/bin/qsh
system "CRTLIB LIB(ILEDITOR) TEXT('Code for i temporary objects. May be cleared.')"
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: [ -d "/tmp" ]
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

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

/home/SSALOMON/: /QOpenSys/usr/bin/qsh
system "CHKOBJ OBJ(QSYS/QCPTOIMPF) OBJTYPE(*DTAARA)"
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: /QOpenSys/usr/bin/qsh
system "CHKOBJ OBJ(QSYS/QCPFRMIMPF) OBJTYPE(*DTAARA)"
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: echo $PATH
{
"code": 0,
"signal": null,
"stdout": "/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin",
"stderr": ""
}

/home/SSALOMON/: test -e /home/SSALOMON//.bashrc
{
"code": 1,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: /QOpenSys/usr/bin/qsh
liblist -d
{
"code": 0,
"signal": null,
"stdout": "",
"stderr": ""
}

/home/SSALOMON/: /QOpenSys/usr/bin/expr /QOpenSys/usr/bin/getconf ARG_MAX - env|wc -c - env|wc -l * 4 - 2048
{
"code": 0,
"signal": null,
"stdout": "4191777",
"stderr": ""
}

/home/SSALOMON/: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')"
Call QSYS2.QCMDEXC('CPYTOIMPF FROMFILE(QSYS2/ASP_INFO *FIRST) TOSTMF(''/tmp/vscodetemp-O_TTltb1IJ'') MBROPT(*REPLACE) STMFCCSID(1208) RCDDLM(*CRLF) DTAFMT(*DLM) RMVBLANK(*TRAILING) ADDCOLNAM(*SQL) FLDDLM('','') DECPNT(*PERIOD)')
{
"code": 0,
"signal": null,
"stdout": "DB2>\n PTXBEDEV-Traitement en Recette",
"stderr": ""
}

/home/SSALOMON/: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')"
CREATE TABLE QTEMP.O_NDBAV AS (select SYSTEM_VALUE_NAME, CURRENT_NUMERIC_VALUE from QSYS2.SYSTEM_VALUE_INFO where SYSTEM_VALUE_NAME = 'QCCSID') WITH DATA;
Call QSYS2.QCMDEXC('CPYTOIMPF FROMFILE(QTEMP/O_NDBAV *FIRST) TOSTMF(''/tmp/vscodetemp-O_0ppSfQYK'') MBROPT(*REPLACE) STMFCCSID(1208) RCDDLM(*CRLF) DTAFMT(*DLM) RMVBLANK(*TRAILING) ADDCOLNAM(*SQL) FLDDLM('','') DECPNT(*PERIOD)')
{
"code": 0,
"signal": null,
"stdout": "DB2>\n PTXBEDEV-Traitement en Recette",
"stderr": ""
}

/home/SSALOMON/: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')"
CREATE TABLE QTEMP.O_5KQFK AS (with SSH_DETAIL (id, iid) as ( select substring(job_name, locate('/', job_name, 15)+1, 10) as id, internal_job_id as iid from qsys2.netstat_job_info j where local_address = '0.0.0.0' and local_port = 22 ) select DEFAULT_CCSID, CCSID from table(QSYS2.ACTIVE_JOB_INFO( JOB_NAME_FILTER => (select id from SSH_DETAIL), DETAILED_INFO => 'ALL')) where INTERNAL_JOB_ID = (select iid from SSH_DETAIL)) WITH DATA;
Call QSYS2.QCMDEXC('CPYTOIMPF FROMFILE(QTEMP/O_5KQFK *FIRST) TOSTMF(''/tmp/vscodetemp-O_y3TybNMn'') MBROPT(*REPLACE) STMFCCSID(1208) RCDDLM(*CRLF) DTAFMT(*DLM) RMVBLANK(*TRAILING) ADDCOLNAM(*SQL) FLDDLM('','') DECPNT(*PERIOD)')

thks for your help

[sebjulliand]

Hi,
except for a small bug I noticed thanks to your logs, but unrelated to this case, I think the problem boils down to this:

/home/SSALOMON/: LC_ALL=EN_US.UTF-8 system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')"
CREATE TABLE QTEMP.O_2FYPH AS (select cast(LONG_COMMENT as VarChar(200)) LONG_COMMENT from qsys2.sysroutines where routine_schema = 'ILEDITOR' and routine_name = 'GETMBRINFO') WITH DATA;
Call QSYS2.QCMDEXC('CPYTOIMPF FROMFILE(QTEMP/O_2FYPH *FIRST) TOSTMF(''/tmp/vscodetemp-O_zKOQ9817'') MBROPT(*REPLACE) STMFCCSID(1208) RCDDLM(*CRLF) DTAFMT(*DLM) RMVBLANK(*TRAILING) ADDCOLNAM(*SQL) FLDDLM('','') DECPNT(*PERIOD)')
{
"code": 0,
"signal": null,
"stdout": "DB2>\n PTXBEDEV-Traitement en Recette",
"stderr": ""
}

Above is an extract from your log of a call to the Db2 CLI. Whenever Code for i needs to perform an SQL operation, it does so calling this CLI, then it parses the output. But here, instead of having the expected CLI output, all there is is this:

DB2>\n PTXBEDEV-Traitement en Recette

This prevents the SQL operations from being carried out and crashes the whole extension, basically 😅

Try to find where this message is sent from (maybe from an exit point?) and see if it can be removed, at least when the program being called is QZDFMDB2.

[cirikus]

Hi,

I find where was this text....on value system QPRTTXT

But I can't clear this value :/

[sebjulliand]

I'm afraid there won't be any easy workaround for this, for the time being.
But now, I'm not even sure it interferes with the process, since it's processing every SQL statement through CPYTOMSTMF. This is mostly due to the SQL runner running in "fail safe" mode. Which leads me to this:

/home/SSALOMON/: /home/SSALOMON/.vscode/cqsh_1
echo "Hello world"
{
"code": 9,
"signal": null,
"stdout": "",
"stderr": ""
}

cqsh is a wrapper we use to ensure CCSID is correctly handled within shell calls. In your case, each call to this returns a code 9 which is unexpected (and force the SQL runner to use its "safe mode").
According to this page, code 9 would mean "descriptor 2 is not available", in other words "error output is not available". Hard to say why though 😕

We could at least have a look at your environment variables to see if anything stands out. Open a terminal and connect through SSH, then run the set command. It will return a list en variables. Copy and paste the list here please.