Re: sql differences between batch,

Diego,
He actually means this:

https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_72/db2/rbafzcatsysindexstat.htm




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: Diego Kesselman <diegokesselman@xxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Date: 04/11/2018 07:20 PM
Subject: Re: sql differences between batch,
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Sorry, not my best day


select
index_schema,
index_table,
index_name,
SUM(index_size) as SIZE
from qsys2.systemstat
GROUP BY index_schema, index_table, index_name

I can't see QSYS2.SYSTEMSTAT on my V7R2


El 11/04/18 a las 18:14, Thomas Burrows escribió:

select
index_schema,
index_table,
index_name,
index_size
from qsys2.systemstat
*GROUP BY index_schema, index_table, index_name *
order by index_size;

--
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


--
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