Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2004
    Posts
    12

    Unanswered: dbspace disabled

    Hi all,
    I tryed to backup my informix database by the following command:
    "ontape -s -L 0" but it shows "DBSpace dbspace1 disabled" and the program is over.


    I don't have any backup of this dbspace.

    Wat can i do ?? please give a help

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

    Please test the following points:

    _ Correct environment variables.
    _ On-Line must be mode "on-Line", "Quiescent" or "Fast-Recovery".
    _ Variables in ONCONFIG file: TAPEDEV, TAPEBLK and TAPESIZE.

    If not work, please send me you ONCONFIG file, onstat -d and on-line.log, if it's posible.

    thanks.

    Gustavo.

  3. #3
    Join Date
    Apr 2004
    Posts
    12
    Ok,

    I'll try it this night. And if not work, i'll send logs to you

  4. #4
    Join Date
    Apr 2004
    Posts
    12
    Quote Originally Posted by gurey
    Hi,

    Please test the following points:

    _ Correct environment variables.
    _ On-Line must be mode "on-Line", "Quiescent" or "Fast-Recovery".
    _ Variables in ONCONFIG file: TAPEDEV, TAPEBLK and TAPESIZE.

    If not work, please send me you ONCONFIG file, onstat -d and on-line.log, if it's posible.

    thanks.

    Gustavo.
    Hi,

    here is the output of onstat -d :

    $ onstat -d

    Informix Dynamic Server 2000 Version 9.21.HC6 -- On-Line -- Up 00:18:11 -- 191884 Kbytes

    Dbspaces
    address number flags fchunk nchunks flags owner name
    c94807e0 1 0x1 1 1 N informix rootdbs
    c94b11a0 2 0x1 2 8 N informix space1
    c94b12e8 3 0x8001 10 1 N S informix sbspace
    3 active, 2047 maximum

    Chunks
    address chk/dbs offset size free bpages flags pathname
    c9480928 1 1 0 1048569 639289 PO- /opt/informix/data/rootchk
    c94c0830 2 2 6 1048569 942242 PO- /opt/informix/data/datadbs00
    c94c09a0 3 2 6 1048569 0 PD- /opt/informix/data/datadbs01
    c94c0b10 4 2 6 1048569 1048566 PO- /opt/informix/data/datadbs02
    c94c0c80 5 2 6 1048569 0 PD- /opt/informix/data/datadbs03
    c94c0df0 6 2 6 1048569 1048566 PO- /opt/informix/data/datadbs04
    c9480a98 7 2 6 1048569 0 PD- /opt/informix/data/datadbs05
    c9480c08 8 2 6 1048569 1048566 PO- /opt/informix/data/datadbs06
    c9480d78 9 2 6 1048569 0 PD- /opt/informix/data/datadbs07
    c94b1030 10 3 6 1048569 979087 979087 POS /opt/informix/data/datadbs08
    Metadata 69429 52508 69429
    10 active, 2047 maximum


    Thanks for your Help

  5. #5
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

    You have a dbspace "datadbs00", some chunks DOWN.
    Please restart this from archive.
    Or run utility onspaces for take the chunk to on-line and then oncheck all tables in this dbspace.
    Gustavo.

  6. #6
    Join Date
    Apr 2004
    Posts
    12
    Hi Gustavo,

    I tryed onspaces utilitie but the chunk still down

    Is it normal that the free space for chunk that are down is Zero ?

    Thank you !

  7. #7
    Join Date
    Feb 2004
    Posts
    32
    Call up tech support , they will have to dial-in and mark the chunks "Online" , this is your only way out.
    Don't mess with it anymore than it is, it would only cause more issues.

    -Abraham

Posting Permissions

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