[SLUG] Does anyone recognize this file format and how to extract data from it?

From: Ben Ostrowsky (ostrowb@tblc.org)
Date: Mon Apr 09 2007 - 18:07:56 EDT


I've got data in a Sybase transaction-dump file and I'm not sure how to
read it. I think the real data begins at 00003000, with "USTH".

>From what I was able to Google, mt might have something to do with it,
but when I try to use mt -f txn_sunline_MonApr0917.txn <arguments>, I
get "Inappropriate ioctl for device".

So -- any ideas about how I can get the data out?

Ben

> hexdump -C txn_sunline_MonApr0917.txn | more
00000000 56 4f 4c 31 20 20 20 20 20 20 20 20 20 20 20 20 |VOL1
|
00000010 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 |
|
00000020 20 20 20 20 30 20 20 20 20 20 20 20 20 20 20 20 | 0
|
00000030 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 |
|
00000040 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 37 |
7|
00000050 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
*
00000800 48 44 52 31 73 75 6e 6c 69 6e 65 30 37 30 39 39
|HDR1sunline07099|
00000810 30 45 46 31 33 00 00 00 01 00 00 00 01 00 00 00
|0EF13...........|
00000820 01 00 00 00 00 30 30 30 31 30 30 20 30 37 30 39 |.....000100
0709|
00000830 39 20 30 37 30 39 39 20 00 00 00 00 00 00 00 00 |9 07099
........|
00000840 53 79 62 61 73 65 20 20 30 45 46 31 33 20 20 20 |Sybase
0EF13 |
00000850 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
*
00001000 48 44 52 32 46 00 01 00 00 20 30 32 30 34 38 30 |HDR2F....
020480|
00001010 33 20 20 20 73 75 6e 6c 69 6e 65 20 20 20 20 20 |3 sunline
|
00001020 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 |
|
00001030 20 20 30 30 30 30 30 30 30 30 30 30 31 30 30 30 |
00000000001000|
00001040 30 32 35 36 30 33 20 20 20 30 30 30 30 30 30 32 |025603
0000002|
00001050 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
*
00001800 45 4f 46 31 73 75 6e 6c 69 6e 65 30 37 30 39 39
|EOF1sunline07099|
00001810 30 45 46 31 33 00 00 00 01 00 00 00 01 00 00 00
|0EF13...........|
00001820 01 00 00 00 00 30 30 30 31 30 30 20 30 37 30 39 |.....000100
0709|
00001830 39 20 30 37 30 39 39 20 00 00 00 00 00 00 0e 36 |9 07099
.......6|
00001840 53 79 62 61 73 65 20 20 30 45 46 31 33 20 20 20 |Sybase
0EF13 |
00001850 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
*
00002000 45 4f 46 32 46 00 01 00 00 20 30 32 30 34 38 30 |EOF2F....
020480|
00002010 33 20 20 20 73 75 6e 6c 69 6e 65 20 20 20 20 20 |3 sunline
|
00002020 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 |
|
00002030 20 20 30 30 30 30 30 30 30 30 30 30 31 30 30 30 |
00000000001000|
00002040 30 32 35 36 30 33 20 20 20 30 30 30 30 30 30 32 |025603
0000002|
00002050 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
*
00002800 45 4f 46 33 56 4f 4c 31 20 20 20 20 20 20 20 20 |EOF3VOL1
|
00002810 20 20 20 20 20 20 20 20 20 37 20 20 20 20 20 20 | 7
|
00002820 00 00 00 00 00 00 1c 6c 20 20 20 20 20 20 20 20 |.......l
|
00002830 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 |
|
*
00002850 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|................|
*
00003000 55 53 54 48 00 00 08 00 00 00 00 90 00 00 00 03
|USTH............|
00003010 00 00 00 64 00 af 00 05 00 00 00 2c 00 00 99 0b
|...d.......,....|
00003020 01 18 2c 6b 00 1c ce ef 00 1c dd 2e 00 06 00 00
|..,k............|
00003030 00 00 99 0b 01 07 ae 37 00 00 99 0b 01 18 2b 58
|.......7......+X|
00003040 00 1c ce ef 00 11 00 00 00 1c dd 2e 00 00 14 9f
|................|
00003050 00 00 00 66 00 00 00 08 00 00 00 03 00 00 00 00
|...f............|
00003060 14 00 00 00 00 0f a0 00 00 00 00 04 00 0f a0 00
|................|
00003070 1c 00 00 00 00 0f a0 00 00 00 00 03 00 1f 40 00
|..............@.|
00003080 15 00 00 00 00 0f a0 00 00 00 00 03 00 2e e0 00
|................|
00003090 16 00 00 00 00 0f a0 00 00 00 00 03 00 3e 80 00
|.............>..|
000030a0 17 00 00 00 00 0f a0 00 00 00 00 03 00 4e 20 00
|.............N .|
000030b0 18 00 00 00 00 0f a0 00 00 00 00 03 00 5d c0 00
|.............]..|
000030c0 19 00 00 00 00 0f a0 00 00 00 00 03 00 6d 60 00
|.............m`.|
000030d0 1a 00 00 00 00 0f a0 00 00 00 00 00 00 0f 82 2f
|.............../|

-----------------------------------------------------------------------
This list is provided as an unmoderated internet service by Networked
Knowledge Systems (NKS). Views and opinions expressed in messages
posted are those of the author and do not necessarily reflect the
official policy or position of NKS or any of its employees.



This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 16:11:26 EDT