Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    12

    Unanswered: Problem changing the loggin status.

    Sir,

    IDS which is up. The command "onstat -" shows the following:

    --------------------------------------------------------------------
    OnlineBack>>onstat -

    Informix Dynamic Server Version 7.31.UD5 -- On-Line -- Up 02:34:40 122880
    Kbytes

    OnlineBack>>

    --------------------------------------------------------------------

    But when i run the an application it shows the following error:

    --------------------------------------------------------------------

    OnlineBack>>online
    Program stopped at "main.4gl", line number 61.
    SQL statement error number -329.
    Database not found or no system permission.
    SYSTEM error number -178.
    ISAM error: Database is locked; pending change to logging mode.
    OnlineBack>>

    --------------------------------------------------------------------

    Then i checked the logging status which i found was with "N" status. I understand that it should be with the "U" status under normal circustances. So i run the command "ontape -s -U online" which has been running for more than two hours but the loggin status is still the "N".

    Can anyone help me how to resolve this problem? Thanks in advance.

    Basanta

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

    Please run onmode -ky, next oninit, next ondblog unbuf <databasename>, next onbar -b -F.
    Next test with onmonitor or select from sysmaster.

    Gustavo.

Posting Permissions

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