Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    Yokohama,Japan
    Posts
    2

    Question Unanswered: how to execute db2dart /MI

    I have to recover the damaged db.
    It have damaged because of having stopped loading data into a table compulsorily (stopped the proceess by using the task manager of WindowsNT).
    I executed the "db2dart /DB" command and I found a Index damaged. It is the index of the table what I have stopped loading data into compulsorily.
    I tried to "db2dart /MI" command in oder to invalid the index. But I couldn't do.

    The command that I executed is follows,

    "db2dart XXXX /MI 3 36"

    XXXX:the name of the damaged database.
    3:the tablespace ID in that the index exist.
    36:the index ID of the damaged index.

    I input the above command on the command prompt, but didn't execute "db2dart /MI" command but showed the help of db2dart command.

    My DBServer environment is follows,
    OS:WindowsNT4.0
    DBMSB2Ver7.2 Workgroup Edition
    Both of them are Japanese Edition.

    Please Teach me how to execute the "db2dart /MI" command.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: how to execute db2dart /MI

    Not very sure why ...

    But you can use

    db2dart xxxx /mi

    and allow db2 to prompt for the input value ... when it prompts, enter


    3 36

    HTH

    sathyaram

    Originally posted by nob
    I have to recover the damaged db.
    It have damaged because of having stopped loading data into a table compulsorily (stopped the proceess by using the task manager of WindowsNT).
    I executed the "db2dart /DB" command and I found a Index damaged. It is the index of the table what I have stopped loading data into compulsorily.
    I tried to "db2dart /MI" command in oder to invalid the index. But I couldn't do.

    The command that I executed is follows,

    "db2dart XXXX /MI 3 36"

    XXXX:the name of the damaged database.
    3:the tablespace ID in that the index exist.
    36:the index ID of the damaged index.

    I input the above command on the command prompt, but didn't execute "db2dart /MI" command but showed the help of db2dart command.

    My DBServer environment is follows,
    OS:WindowsNT4.0
    DBMSB2Ver7.2 Workgroup Edition
    Both of them are Japanese Edition.

    Please Teach me how to execute the "db2dart /MI" command.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Aug 2003
    Location
    Yokohama,Japan
    Posts
    2

    Smile Re: how to execute db2dart /MI

    Hello, sathyaram.
    Thank you for your anwser.

    I tried the other way and succeeded.
    I described the "db2dart /MI" command as follows.
    db2dart XXXX /MI /TSI 3 /OI 36
    XXXX:db name.
    3:Tablespace ID where the damaged index is in.
    36:Object ID of the damaged index.
    I needed to describe "/TSI" to indicate Tablespace ID, and "/ OI" to indicate Object ID.
    Anyway, I solved the problem. The database has recovered.

    Thank you.

    Originally posted by sathyaram_s
    Not very sure why ...

    But you can use

    db2dart xxxx /mi

    and allow db2 to prompt for the input value ... when it prompts, enter


    3 36

    HTH

    sathyaram

Posting Permissions

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