Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    Allentown pa
    Posts
    41

    Unanswered: sysdbspaces and syschunks tbl not match

    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
    Jeff Wain

  2. #2
    Join Date
    Aug 2003
    Location
    Allentown pa
    Posts
    41
    Clearer
    [informix@sundev11] /bb/bin/informix/disks: onstat -d | grep auditidx
    1b88c318 4 1 20 7 N informix auditidx
    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
    Jeff Wain

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •