onstat -d | grep auditidx (shows 7 chunks) b88c318 4 1 20 7 N informix auditidx But actually we have 8 as the onstat shows and is in syschunks also? Is the only way to fix this a reorg?
1b055c90 20 4 0 1048000 17 PO- /bb/bin/informix/disks/devts_auditidx_0001
1b055d90 21 4 0 1048000 0 PO- /bb/bin/informix/disks/devts_auditidx_0002
1b055e90 22 4 0 1048000 1 PO- /bb/bin/informix/disks/devts_auditidx_0003
1b07e230 23 4 0 1048000 1 PO- /bb/bin/informix/disks/devts_auditidx_0004
1b07e330 24 4 0 1048000 9 PO- /bb/bin/informix/disks/devts_auditidx_0005
1b07e430 25 4 0 1048000 17 PO- /bb/bin/informix/disks/devts_auditidx_0006
1b88c118 134 4 0 1048000 565400 PO- /bb/bin/informix/disks/devts_auditidx_0007
1c8c2260 143 4 0 1048000 1047997 PO- /bb/bin/informix/disks/devts_auditidx_0008
dBforums
>
sysdbspaces and syschunks tbl not match
09-05-07, 16:45
Linear Mode
