Rob,
My SYSIXADV is updated daily.
10,000+ records.
How would this impact the system if cleared?
Member List
Source Creation Last Change Deleted
Member Size Type Date Date Time Records Records
SYSIXADV 4849664 03/23/14 03/24/20 16:10:11 10182 0
Paul
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob Berendt
Sent: Tuesday, March 24, 2020 3:45 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Should one clear SYSIXADV on occasion?
Should one clear SYSIXADV on occasion? We have reason to believe that much of the advice is dated.
If one should clear it, how does one do so?
- DELETE FROM QSYS2.SYSIXADV
- CLRPFM QSYS2.SYSIXADV
- Use of the qsys2.Reset_Table_Index_Statistics service?
If it was damaged there are some steps to rebuild it:
https://www.ibm.com/support/pages/node/685225
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
--
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@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
