Hi Sergio,
I guess you're talking about intra-partition fragmentation, so multiple / too many extents in partitions and the (auto-)defrag functionality?
For the auto_crsd task, please be aware that its various capabilities can be turned on/off by specific switches in the ph_threshold table, and most are off by default (since the switches aren't even there in ph_threshold), if I'm right.
Please refer to
Scheduling data optimization for more details and/or ook at the related auto_crsd() SPL UDR definition in $INFORMIXDIR/etc/sysadmin/sch_tasks.sql for how exactly this works.
Regarding size of partitions/tables/indices, I'm sure Art has this in one of his many scripts and utilities ;-) ... and it probably even will be in one of the discussions here.
BR,
Andreas
------------------------------
Andreas Legner
------------------------------
Original Message:
Sent: Thu June 17, 2021 07:08 AM
From: Sergio Peres
Subject: Fragmentation issues
Hi,
I frequently see fragmentation in tables and indexes, even though I have activated the auto_crsd task there is still fragmentation.
Are there any other tasks needed?
How can I get the size of tables and indexes, including fragments?
Thanks in advance for any help,
SP
------------------------------
Sergio Peres
AIRC
Coimbra
------------------------------
#Informix