Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2005
    Posts
    12

    Unanswered: problems with old version of ods 7.23 on w2k

    Hi everyone, i'm new in this forum.

    i'd like to know how can i install informix ods (version 7.23) on w2k. I guest i'm doing everithing correct but the Command Center just don't go into the on-line mode. So i can't set the logical files and other stuffs. Does anybody know some kind of "magic" to do in this case?

    The "sagent.log" file give me this message:

    "18/01/1905 09:45:15 - Cannot complete the operation because the database server is changing modes or is off-line. Retry the operation at a later time."

    thanks.

    Clony

  2. #2
    Join Date
    Jan 2005
    Posts
    30
    Check the online.log (MSGPATH) for more information about the failure.

    _______________
    Sanjit Chakraborty

  3. #3
    Join Date
    Jan 2005
    Posts
    12
    Thanks saatatya, but in this log file everithing appears to be normal, see the log below:
    "
    Wed Jan 19 07:53:02 2005

    07:53:02 DR: DRAUTO is 0 (Off)
    07:53:04 INFORMIX-OnLine Initialized -- Shared Memory Initialized.
    07:53:04 Physical Recovery Started.
    07:53:04 Physical Recovery Complete: 0 Pages Restored.
    07:53:04 Logical Recovery Started.
    07:53:08 Logical Recovery Complete.
    0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

    07:53:09 Dataskip is now OFF for all dbspaces
    07:53:09 Init operation complete - Mode Online
    07:53:09 On-Line Mode
    07:53:21 Checkpoint Completed: duration was 1 seconds.
    "

    It gives the message that the database server is online but when i try to set the logical files to another size i have to change to administrative mode and it gives the message that "the database server is changing modes or is off line"

    any help?

    thanks.

  4. #4
    Join Date
    Jan 2005
    Posts
    30
    Not sure what exactly you are doing.

    Try these:
    1) Login as user ‘informix’
    2) Take the informix database server offline
    3) Update LOGSIZE accordingly in the ONCONFIG file
    4) Bring informix database server online

    If you are increasing the logical log size, make sure you have enough space available in the dbspace where logical logs exist.

    Cheers!

  5. #5
    Join Date
    Jan 2005
    Posts
    12

    informix 7.23 doesn't work

    Well, i've tryed everything, but the real problem is that this version of Informix ODS (7.23) seems not work well with W2K, cause everything is correct, but the database server does not change from offline to online, even login in with the user informix and doing all that was suggested here. The database simply can't change to online mode.
    The database works, the services starts, i can access the tables, insert data and other stuff like this, the only problem is that i can't manage the logs, start the continous logical logs backup, setup the dbspace and etc.

    I guess i'll give up, if anyone has more ideas please help me!

    Regards to everybody!

Posting Permissions

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