×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I found the answer. Was doing select * from QSYS2.SYSLIMITS.
I already had *ALLOBJ, but that was not enough.
Through trial and error found that you also need *JOBCTL to run the above SQL Select statement.
-----Original Message-----
From: Rob Berendt [mailto:rob@xxxxxxxxx]
Sent: Thursday, January 4, 2018 11:06 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Minimum permissions required to query QSYS2.SYSLIMITS
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/Tracking%20Important%20System%20Limits
didn't seem to help.
Can you post a sample query which gives you fits?
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
From: Matt Olson <Matt.Olson@xxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 01/04/2018 11:46 AM
Subject: Minimum permissions required to query QSYS2.SYSLIMITS
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
I'm trying to find the minimum set of permissions to query this system
view:
https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_73/rzajq/rzajqviewsyslimits.htm
I can't seem to find that information anywhere. My Admin account, which I
thought had all permissions is not able to query this file.
Only qsecofr so far has the ability to query this file.
midrange.com
