1. Forum
  2. Usenet
  3. COMP.DATABASES.INFORMIX

  • logging change error

    From [email protected]@21:1/5 to All on Fri Mar 22 11:08:14 2019
    El miércoles, 2 de agosto de 2000, 3:00:00 (UTC-4), Karl Hewlett escribió:
    Hi

    I am a new Informix DBA - and have never use Informix before :) (I have an Oracle background)

    Yesterday I dbimported a database (ausatst -thank god it is a test database, but still v. important at this stage of the project). I had not set logging on (didn't know I had to) and had to go to a meeting. The PeopleSoft administrator (my backup) attempted to set logging on with "ontape -s -U ausatst" and encountered some sort of error. I think he may have done a level 2 ontape.

    Anyway the present situation is that onmonitor reports a logging status of
    N. Any attempt to alter the logging status results in the following error

    informix:ps7testshm@zircon>ontape -s -U aufstst
    Error changing logging status - 'aufstst'. iserrno 107.


    I have attempted to do "ontape -s -N ausatst" with the same result.
    ontape -s -B ausatst gives the result "invalid logging change" or some very similar error. I have dropped and reimported the database. I have stopped and resarted the instance. The docos refer to an onarchive command that stops a partly completed logging change but we don't use onarchive and it doesn't run - I tried it.

    Any help greatfull appreciated. As I do not have newsgroup access at work please reply to [email protected] Thank you.

    Karl Hewlett
    PeopleSoft DBA
    University of Auckland
    New Zealand

    ejecutar dbimport con -l buffered
    la solucion funciona:

    server:informix/home/informix > ontape -s -L 0 -B database

    Please mount tape 1 on /work/tape_serverinformix and press Return to continue ...
    10 percent done.
    20 percent done.
    30 percent done.
    100 percent done.
    Read/Write End Of Medium enabled: blocks = 61441

    Please label this tape as number 1 in the arc tape sequence.
    This tape contains the following logical logs:

    20542

    Program over.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Mike Walker@21:1/5 to All on Fri Mar 22 13:30:21 2019
    To: [email protected]

    I think that this might be as simple as making sure that there is NOBODY in the database when you try and change the logging mode.

    The 107 is a locking error.

    Run "onstat -g sql" and there should be NO connections referencing the ausatst database.

    I don't know what version of Informix you are on, but you may find the ondblog command (if available) more friendly than using ontape.

    -----Original Message-----
    From: [email protected] [mailto:[email protected]] On Behalf Of [email protected]
    Sent: Friday, March 22, 2019 12:08 PM
    To: [email protected]
    Subject: Re: logging change error

    El miércoles, 2 de agosto de 2000, 3:00:00 (UTC-4), Karl Hewlett escribió:
    Hi

    I am a new Informix DBA - and have never use Informix before :) (I
    have an Oracle background)

    Yesterday I dbimported a database (ausatst -thank god it is a test
    database, but still v. important at this stage of the project). I had
    not set logging on (didn't know I had to) and had to go to a meeting.
    The PeopleSoft administrator (my backup) attempted to set logging on
    with "ontape -s -U ausatst" and encountered some sort of error. I
    think he may have done a level 2 ontape.

    Anyway the present situation is that onmonitor reports a logging
    status of N. Any attempt to alter the logging status results in the following error

    informix:ps7testshm@zircon>ontape -s -U aufstst Error changing logging
    status - 'aufstst'. iserrno 107.


    I have attempted to do "ontape -s -N ausatst" with the same result.
    ontape -s -B ausatst gives the result "invalid logging change" or
    some very similar error. I have dropped and reimported the database.
    I have stopped and resarted the instance. The docos refer to an
    onarchive command that stops a partly completed logging change but we
    don't use onarchive and it doesn't run - I tried it.

    Any help greatfull appreciated. As I do not have newsgroup access at
    work please reply to [email protected] Thank you.

    Karl Hewlett
    PeopleSoft DBA
    University of Auckland
    New Zealand

    ejecutar dbimport con -l buffered
    la solucion funciona:

    server:informix/home/informix > ontape -s -L 0 -B database

    Please mount tape 1 on /work/tape_serverinformix and press Return to continue ...
    10 percent done.
    20 percent done.
    30 percent done.
    100 percent done.
    Read/Write End Of Medium enabled: blocks = 61441

    Please label this tape as number 1 in the arc tape sequence.
    This tape contains the following logical logs:

    20542

    Program over.

    _______________________________________________
    Informix-list mailing list
    [email protected]
    http://members.iiug.org/mailman/listinfo/informix-list

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)