Logon to db2 qp2term -Error 0403-006 Execute permission denied.

[martimmendes]

Hi guys and also ,

As you already know i am very new to this platform.

I currently have an issue with a system that altough its "up" i cannot logon due to syntax errors, so, i open an OSS message and they asked me to view the contents of DDXTT table.

I'm loged in as <SID>adm user and when i try to connect using "db2 connect to <SID>" i get error 0403-006 Execute permission denied. It is ok to try to connect while loged in as <SID>adm user or should i log to AS/400 with another user?

Sorry if this seem an dumb question but i am pretty clueless.

Thanks in advance for your kind support.

Kind regards,

Martim.

[volker_gldenpfennig · Accepted solution]

Hi Martim,

you didn't mention the tool you were using ... call qp2term or STRQSH ... it does only work with one of them .. I think, with QSH ...

But, yes, STRSQL is REALLY helpful ... if you do not purchased that, you can download for free STRCONSQL:

https://www.consolut.com/en/s/download/consolut-sql-tool.html

Regards,

Volker Gueldenpfennig, consolut international ag

[martimmendes]

Hi guys,

I was using qp2term . Finally i went to the iNavigator series and found what i wanted to see.

Thanks for your help.

BRs

Martim.

[blaw]

If you goal is just to see to contents of DDXTT - SiDADM should work

I would recommend using System i Navigator -

If you don't have that installed - you run the SQL statement from the green screen -

On command line Key

STRSQL  and press enter

select * from DDXTT

Regards,

Brian