Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  What is wrong with my onbar invocation?

    Posted 12/11/23 03:20 AM

    Hi,

    I try to restore my DB to point-in-time:

    onbar -r -w -t "2023-12-11 03:00:00"

    What I get is error 149:

     2023-12-11 11:09:21 35913732  21823508 /opt/informix/11.70fc5xe/bin/onbar_d -r -w -t 2023-12-11 03:00:00
     2023-12-11 11:09:21 35913732  21823508 Invalid Point In Time value specified: .
     2023-12-11 11:09:21 35913732  21823508 onbar usage
    <...>
     2023-12-11 11:09:21 35913732  21823508 /opt/informix/11.70fc5xe/bin/onbar_d complete, returning 149 (0x95)

    What is wrong with my onbar invocation?



    ------------------------------
    Sincerely,
    Dennis
    ------------------------------


  • 2.  RE: What is wrong with my onbar invocation?

    Posted 12/11/23 03:58 AM

    Any CLIENT_LOCALE or GL_DATETIME setting in your way or, in fact, demanding a different format?



    ------------------------------
    Andreas Legner
    ------------------------------



  • 3.  RE: What is wrong with my onbar invocation?

    Posted 12/11/23 04:34 AM

    I have CLIENT_LOCALE set, no GL_DATETIME.

    With the setting, dbaccess displays

    SELECT CURRENT FROM sysdual;

    as

    2023-12-11 12:30:02.000



    ------------------------------
    Sincerely,
    Dennis
    ------------------------------



  • 4.  RE: What is wrong with my onbar invocation?

    Posted 12/11/23 06:07 AM
    Edited by Dennis Melnikov 12/11/23 06:18 AM

    Eventually I managed to run it this way:

    GL_DATETIME="%iY-%m-%d %H:%M:%S" onbar -r -t '2023-12-11 03:00:00'

    Target time in BAR_ACT_LOG shows the correct time (it is GMT/UTC, isn't it?)

    bar_build_timeline: target time 1702252800



    ------------------------------
    Sincerely,
    Dennis
    ------------------------------