Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2012
    Posts
    2

    Unanswered: Table level restore using archecker

    Hi all,

    I am just facing a problem of restoring a table from archecker utility with the level 0 backup created to the disk path using ontape command. Now I am trying to restore one of the tables in the database using archecker and IDS server is in online mode (IDS 11.50.FC8X2) and I get the bellow mentioned erro when I try to execute the bellow command. This server already contains blank database of the original server.

    Error: Connection to database sysmaster failed, check server mode.
    (It does not display at least the version of the archecker.)

    command executing : archecker -tvsdX -f cmd.sql (This command is running by informix user)

    The contents of the cmd.sql is as follows

    database bms;
    create table tb1
    (tb_id integer,
    tb_name char(10));


    The configuration file is

    AC_MSGPATH /tmp/ac_msg.log
    AC_STORAGE /tmp
    AC_VERBOSE 1


    If any one can help that is great.
    Last edited by jagathabhaya; 03-01-12 at 23:39. Reason: Modify the Title

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Hi,

    I think that if you want to restore at the table level, your instance must be on-line.
    First, this makes sense, because archecker will need to access to the SQL layer, and second this is what the error message tells you.

    first check the state of the server:
    onstat -
    and check the indication on the first line, on the right

    if "offline" run :
    oninit

    if "quiescent" run:
    onmode -m

    can you give a try?

Posting Permissions

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