Dump a logical Log data to a file



This is a straight forward process if the required log has not been overwritten, however at some point in the past (when I used 7.31) I needed to look in an old log and was given this workaround by Tech Support

Workaround: 8864
1. Create the following file at $INFORMIXDIR/bin/onlog.long
#!/usr/bin/ksh
onlog $* -l

2. Set the following environment variable
export ONLOG=$INFORMIXDIR/bin/onlog.long
export BAR_LOGCHECK=1

3. Execute
onbar -P <LOG NUMBER>

Now that I have upgraded to 9.40 the above workaround no longer works, does anyone know of a way of getting a dump of an archived logical log?





Regards

Colin

There are 10 types of people in the world, those that understand binary and those that don't

_________________________________________________________________
Windows Live? Messenger has arrived. Click here to download it for free! http://imagine-msn.com/messenger/launch80/?locale=en-gb

.