What is wrong with my onbar invocation?
Dennis Melnikov (11.70.FC5XE) got error 149 'Invalid Point In Time value' from onbar -r -w -t with a timestamp. Andreas Legner asked about CLIENT_LOCALE and GL_DATETIME. Dennis made it work by setting GL_DATETIME to the format %iY-%m-%d %H:%M:%S and dropping the -w option, after which the target time appeared correctly in BAR_ACT_LOG.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
------------------------------
Any CLIENT_LOCALE or GL_DATETIME setting in your way or, in fact, demanding a different format? ------------------------------ Andreas Legner ------------------------------
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
------------------------------
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
------------------------------