If you never had a look at the index advices. This table includes all
advices since release V5R2M0.
It is up to you to decide whether you want to clear the table, or delete
only the advices for a specific schema or a specific table ... and then wait
for several days/weeks before you'll analyze the content of the SYSIXADV.
Instead of using CL or SQL commands you could also delete the index advices
with ACS - Database - Schemas
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob
Berendt
Sent: Dienstag, 24. März 2020 20:45
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
