Re: db access to iseries from pc's via ?

Bryan:

you seem to be really good with your SQL.

I have the following SQL

select
table_schema,
table_name,
index_name
from qsys2.sysindexes
order by
table_schema,
table_name,
index_name;

What I need is a list of the indexes by size. Largest to smallest.

How would I do that?

Or if anyone else wants to jump in that would be great.

Sorry about being a newbe on the SQL thing per pulling schema, table, and
index information.

Thomas Burrows
PS: If anyone wants to call me I am at 469 693 2533

On Tue, Apr 10, 2018 at 3:39 PM, Bryan Dietz <bdietz400@xxxxxxxxx> wrote:

(Channeling Rob) and if you are on a current release there is some SQL you
can use:

SELECT Aj.Subsystem
,Aj.Job_Name
,Aj.Authorization_Name AS "Current User"
,Ns.Remote_Address
,Aj.Cpu_Time AS "MilliSeconds Used"
FROM TABLE(Qsys2.Active_Job_Info('NO', '', 'QZDASOINIT', '')) AS Aj
,Qsys2.Netstat_Job_Info AS Ns
WHERE (Aj.Authorization_Name LIKE '%'
and NS.REMOTE_ADDRESS like '%')
AND Aj.Job_Name = Ns.Job_Name
ORDER BY Aj.Authorization_Name;


https://www.ibm.com/developerworks/community/wikis/home/
wiki/IBM%20i%20Technology%20Updates/page/QSYS2.ACTIVE_
JOB_INFO()%20-%20UDTF




Bryan

tim wrote on 4/10/2018 11:38 AM:

is there a way of telling who is connecting to the iseries db using
things like access, excel, etc?

i want to be able to control these functions. I believe all our users
have odbc set up as part of client access install.

--

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD