Just a follow-up...
Since there appears to be no difference in joblogs AFTER starting System
Debugger, wouldn't that indicate that message #2 in lower pane (2.
Communications error with <system name>) is relevant? Like there is no
connection????
Jeremy
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
jeremy.ruth@xxxxxxxxxxx
Sent: Friday, October 14, 2022 9:10 AM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: ACS System Debugger doesn't want to work
This is the joblog just after starting 'Run SQL Scripts':
SQL799C The following special registers have been set: CLIENT_ACCTNG:
Windows 10;SSL=false;admin_user=true, CLIENT_APPLNAME: IBM i Access Client
Solutions - Run SQL Scripts, CLIENT_PROGRAMID:
file:/C:/Users/Public/IBM/ClientSolutions/acsbundle.jar | Version: 1.1.8.8 |
Build id: 1380 | 2021-09-13 13:47:59, CLIENT_USERID: jruth-a,
CLIENT_WRKSTNNAME: MN001JDEVM01 2022-10-14 08:58:56.725344 10
INFORMATIONAL
Cause . . . . . : This message is issued when any of the client special
registers have been updated. JRUTH99 QSYS QZDASRV QZDACMDP
CP_SET_ATTRCODE 21239 QSYS QZDASRV QZDACMDP CP_SET_ATTRCODE
21239
CPD1672 Job changed successfully; however errors occurred. 2022-10-14
08:58:56.435019 0 DIAGNOSTIC
Cause . . . . . : The request to change the job attributes completed
successfully, however errors occurred during processing.
Recovery . . . : See previously listed messages for details.
JRUTH99 QSYS QWTCHGJB 2F6F QSYS QZDASRV
QZDACMDP UPDATE_UPINFO 32783
CPD0912 Printer device PRT01 not found. 2022-10-14 08:58:56.434650 20
DIAGNOSTIC
Cause . . . . . : The printer device was not found.
Recovery . . . : Either create the printer device (CRTDEVPRT command) or
if the printer device name is not correct, change the printer device name
and then try the command again. JRUTH99 QSYS QWTCHGJB
2F6F QSYS QZDASRV QZDACMDP UPDATE_UPINFO 32783
CPIAD02 User JRUTH99 from client 10.51.96.212 connected to server.
2022-10-14 08:58:56.433895 0 INFORMATIONAL
Cause . . . . . : User profile JRUTH99 from client 10.51.96.212 is
currently connected to this server job. The client name is either a TCP/IP
remote system name, a dotted decimal IP address, the local host name, or an
IPv6 address. JRUTH99 QSYS QZBSSECR QZBSSECR
QzbsCheckSwapResults__FiP17QzbsStrSrvRequestP12QzbsStdReplyP14QzbsReplyHdr_t
PA10_cPcPiPsP16sockaddr_storageN27 315 QSYS QZBSSECR
QZBSSECR
QzbsCheckSwapResults__FiP17QzbsStrSrvRequestP12QzbsStdReplyP14QzbsReplyHdr_t
PA10_cPcPiPsP16sockaddr_storageN27 315
CPD1672 Job changed successfully; however errors occurred. 2022-10-14
08:58:56.433785 0 DIAGNOSTIC
Cause . . . . . : The request to change the job attributes completed
successfully, however errors occurred during processing.
Recovery . . . : See previously listed messages for details.
JRUTH99 QSYS QWTCHGJB 2F6F QSYS QZBSSECR
QZBSSECR QzbsChangeJob__Fi 33
CPD0912 Printer device PRT01 not found. 2022-10-14 08:58:56.433453 20
DIAGNOSTIC
Cause . . . . . : The printer device was not found.
Recovery . . . : Either create the printer device (CRTDEVPRT command) or
if the printer device name is not correct, change the printer device name
and then try the command again. JRUTH99 QSYS QWTCHGJB
2F6F QSYS QZBSSECR QZBSSECR QzbsChangeJob__Fi 33
CPF1336 Errors on CHGJOB command for job 047434/QUSER/QZDASOINIT.
2022-10-14 08:58:56.235725 40 ESCAPE EXCEPTION HANDLED
Recovery . . . : See the messages listed previously, if any. Correct the
errors and then submit the command again. QUSER QSYS QWTCHGJB
2F6F QSYS QWCJOBSR 022B
CPD0912 Printer device PRT01 not found. 2022-10-14 08:58:56.235674 20
DIAGNOSTIC
Cause . . . . . : The printer device was not found.
Recovery . . . : Either create the printer device (CRTDEVPRT command) or
if the printer device name is not correct, change the printer device name
and then try the command again. QUSER QSYS QWTCHGJB
2F6F QSYS QWCJOBSR 022B
CPF1124 Job 047434/QUSER/QZDASOINIT started on 10/14/22 at 04:31:03 in
subsystem QUSRWRK in QSYS. Job entered system on 10/14/22 at 04:31:03.
2022-10-14 04:31:03.352591 0 INFORMATIONAL
QUSER QSYS QWTPIIPP 04C9 *EXT
*N
This is the joblog after starting 'System Debugger':
*** no change!!!
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob
Berendt
Sent: Friday, October 14, 2022 8:08 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: ACS System Debugger doesn't want to work
In Run SQL Scripts click on View, Joblog.
You're about to get an education...
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail
to: 7310 Innovation Blvd, Suite 104
Ft. Wayne, IN 46818
Ship to: 7310 Innovation Blvd, Dock 9C
Ft. Wayne, IN 46818
http://www.dekko.com
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
jeremy.ruth@xxxxxxxxxxx
Sent: Friday, October 14, 2022 8:58 AM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: ACS System Debugger doesn't want to work
CAUTION: This email originated from outside of the organization. Do not
click links or open attachments unless you recognize the sender and know the
content is safe.
Hello again,
I was granted *ALL access to STRDBGSVR
As of now, I have run this command from the command line.
If I try running it from 'Run SQL scripts', I get the expected error:
-- CPFAC00: Debug server router function already active.
So I assume it is running on the system... when I start System Debugger:
No change to System Debugger UI visually No change to System Debugger
behaviorally I still get the same 3 messages in the lower pane upon startup:
1. Attempting connection to <system name> (IP address) 2. Communications
error with <system name> 3. Attempting to start debug server on <system
name>
Those 3 messages repeat for every time I click 'Start Debug'.
I guess I should ask, what should I expect to see when I first start System
Debugger?
What toolbar/menu options should I expect to see enabled at startup?
Jeremy
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob
Berendt
Sent: Thursday, October 13, 2022 12:02 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: ACS System Debugger doesn't want to work
And
select *
from qsys2.authorization_list_user_info
where authorization_list = 'SYSTEMS'
;
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail
to: 7310 Innovation Blvd, Suite 104
Ft. Wayne, IN 46818
Ship to: 7310 Innovation Blvd, Dock 9C
Ft. Wayne, IN 46818
http://www.dekko.com
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob
Berendt
Sent: Thursday, October 13, 2022 1:00 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: ACS System Debugger doesn't want to work
See also:
select special_authorities
from qsys2.user_info
where authorization_name = 'ROB';
select object_authority, system_object_schema, system_object_name,
object_type, object_name, authorization_name, authorization_list from
qsys2.object_privileges where authorization_name in('ROB', '*PUBLIC') and
((system_object_name in('STRDBG', 'ENDDBG', 'STRSRVJOB', 'ENDSRVJOB')
and system_object_schema = 'QSYS')
-- Program to debug below
OR (OBJECT_NAME = 'SET_INITIAL_MENU' and object_schema = 'ROB')) ;
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail
to: 7310 Innovation Blvd, Suite 104
Ft. Wayne, IN 46818
Ship to: 7310 Innovation Blvd, Dock 9C
Ft. Wayne, IN 46818
http://www.dekko.com
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob
Berendt
Sent: Thursday, October 13, 2022 12:10 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: ACS System Debugger doesn't want to work
https://www.ibm.com/docs/en/rdfi/9.6.0?topic=debugger-authorities-required-d
ebugging
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail
to: 7310 Innovation Blvd, Suite 104
Ft. Wayne, IN 46818
Ship to: 7310 Innovation Blvd, Dock 9C
Ft. Wayne, IN 46818
http://www.dekko.com
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
jeremy.ruth@xxxxxxxxxxx
Sent: Thursday, October 13, 2022 11:59 AM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: ACS System Debugger doesn't want to work
[You don't often get email from jeremy.ruth@xxxxxxxxxxx. Learn why this is
important at
https://aka.ms/LearnAboutSenderIdentification ]
CAUTION: This email originated from outside of the organization. Do not
click links or open attachments unless you recognize the sender and know the
content is safe.
Just a clarifying question...
If the command STRDBGSVR were added to our system's auto-start list, would I
still need authority granted to my user ID?
Jeremy
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jon
Paris
Sent: Thursday, October 13, 2022 8:31 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: ACS System Debugger doesn't want to work
System level. The debug server is system-wide.
When a system starts up (i.e after an IPL) there are a number of auto-start
jobs triggered that start TCPIP servers like HTTP, Telnet (5250), FTP, etc.
Your admin folks will understand. They just need to add the debug server to
the startup list.
Jon P.
On Oct 12, 2022, at 8:34 PM, <jeremy.ruth@xxxxxxxxxxx>
<jeremy.ruth@xxxxxxxxxxx> wrote:
Can you elaborate on your last comment? Those terms are foreign to
me, but I'd like to understand what you're talking about so I can
convey to our admins.
Are you saying that that command would be started automatically at the
system level? Or job level?
Jeremy
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Jon Paris
Sent: Wednesday, October 12, 2022 6:07 PM
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: ACS System Debugger doesn't want to work
Glad I guessed right.
Ideally it should just be added to your system's autostart list so
that it is always started along with the TCT servers etc.
Jon P.
On Oct 12, 2022, at 6:12 PM, <jeremy.ruth@xxxxxxxxxxx>
<jeremy.ruth@xxxxxxxxxxx> wrote:
Hi Jon,
That's a great idea and it just so happens that I do not have that
access.
I'll have to request it and see if that helps.
Thank you and I'll keep the thread posted when I hear back.
Jeremy
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Jon Paris
Sent: Wednesday, October 12, 2022 5:00 PM
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: ACS System Debugger doesn't want to work
It is possible you don't have enough authority to start the debug server.
To check this try issuing the command STRDBGSVR from the green screen.
Jon P
On Oct 12, 2022, at 3:43 PM, <jeremy.ruth@xxxxxxxxxxx>
<jeremy.ruth@xxxxxxxxxxx> wrote:
Hello,
I have never used the ACS System Debugger before but saw it as a
menu option so naturally I was intrigued by a GUI debugger that
could/would replace STRDBG.
Info:
* ACS v1.1.8.8 Build ID: 1380
* I am not an iSeries guy, but sometimes I am tasked with
writing/debugging Stored Procs/Triggers/Functions
* I run ACS as Administrator
I have a 'Run SQL Scripts' query window open.
I select the 'System Debugger' option from the 'Run' menu.
This brings up the Sign On window. I sign on.
System Debugger window is now displayed.
* Almost everything (toolbar options, menu options) on this UI is
disabled, excepts for the 'Start Debug' command
* Selecting 'Start Debug' does nothing
* In status pane at bottom of window, I have the following three
messages:
1. Attempting connection to <system name> (IP address) 2.
Communications error with <system name> 3. Attempting to start
debug server on <system name> .
I don't see anything of relevance in the joblog, that I can tell.
Is there something that must be configured on the i in order for
this to work?
The 'Communications error with <system name>' in the lower pane is
confusing. Is the 3rd message in the pane a result of the 2nd message?
Communications seems fine as I can run queries, I can start and use
5250 emulation, I can peruse the system via iNavigator, etc.
Thanks,
Jeremy
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related
questions.
Help support midrange.com by shopping at amazon.com with our
affiliate
link: https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.
Help support midrange.com by shopping at amazon.com with our
affiliate
link:
https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related
questions.
Help support midrange.com by shopping at amazon.com with our
affiliate
link: https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.
Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
