Re: ITH Size

Member           Size        Type  Date       Date     Time      Records
ITH             25971752960        12/26/07 02/22/16 07:51:29   41408867
Repeat:  41,408,867
Number of deleted records . . . . . . . . :                     0
And they are all 'TH'

select year(routines.numtodate(ttdte)), count(*)
from erplxf.ith 
group by year(routines.numtodate(ttdte)) 
order by year(routines.numtodate(ttdte)) 

  YEAR     COUNT ( * )
 2,011               1
 2,013      10,017,099
 2,014      14,215,982
 2,015      15,071,830
 2,016       2,104,177
 2,020               2

I'm not our local LX administrator.  So I can't begin to say why they 
retain so long.  As the saying goes, "Not my monkey, not my problem"

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:   Billy Waters <[email protected]>
To:     "bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected]" <bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected]>
Date:   02/22/2016 07:44 AM
Subject:        [BPCS-L] ITH Size
Sent by:        "BPCS-L" <bpcs-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]>



Currently ITH 9 million records.  Considering a process change that could 
greatly increase the daily ITH record created.  Boss is concerned about 
the size of ITH and performance considerations.  If you can please respond 
with your ITH size and any other information you feel would be of use. We 
cannot purge ITH at month end due to an internal reporting process. We are 
working on another new process that will allow purging of ITH at month 
end.

-- 
This is the BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.



-- 
This is the BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.