Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  drop down space/chunks

    Posted 06/13/23 09:17 AM

    Hello to All

    have a dbspace with many chunks, on down state, and could not drop them, 

    pleaase help

    700000132d96bc0  9        0x60005    26       5        4096     ND BA    informix test_dbs
    700000132d9ae28  26     9      25         26214350   0                     PD-B-- /chunks/test_dbs_ol_sgma_chk01
    700000132d9b028  27     9      25         26214350   0                     PD-B-- /chunks/test_dbs_ol_sgma_chk02
    700000132d9b228  28     9      25         26214350   0                     PD-B-- /chunks/test_dbs_ol_sgma_chk03
    700000132d9b428  29     9      25         26214350   0                     PD-B-- /chunks/test_dbs_ol_sgma_chk04
    700000132d9b628  30     9      25         26214350   0                     PD-B-- /chunks/test_dbs_ol_sgma_chk05
     
     
    onspaces -d test_dbs
    WARNING: Dropping a DBspace.
    Do you really want to continue? (y/n)y
    WARNING! The dbspace you wish to drop has been disabled.  There
    may be database catalog entries for tables or indices which contain
    data in this dbspace.  If you complete the drop they will be unusable.
    Do you really want to continue? (y/n)y
    Cannot drop the Space.
    ISAM error: DBspace is not empty
     
     
    onspaces -d test_dbs  -p /chunks/test_dbs_ol_sgma_chk01 -o 100  -y
    Chunk not dropped.
    ISAM error:  Cannot drop first chunk
     
    onspaces -d test_dbs  -p /chunks/test_dbs_ol_sgma_chk02 -o 100  -y
    Chunk not dropped.
    ISAM error: Primary and Mirror chunks are bad



    ------------------------------
    John Smith
    ------------------------------