Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

ctldmp option to create transaction start files from checkpoints in transaction log files

The ctldmp utility allows you to create transaction log start files for the transaction logs that it scans. Specify the csf ("create start files") option to use this feature.

The start files are named S<lognumber>_<sequencenumber>.FCA, where lognumber is the transaction log number and sequencenumber is the checkpoint number in that log (starting from 1).

These start files can be renamed to S0000000.FCS and S0000001.FCS so that FairCom Server can use the checkpoint positions as starting points for automatic recovery.

Example:

# ctldmp log 1254 csf

getlogfil

LOGPOS:1254-002473fax #0:690034176 P0051a057f3-00x F0000-000 T26 U03 A0000x L139672 042 CHKPNT

0000e0007fa0a000a0009200920073000000000071001200e000000000005100000000000000000

300054001cb100002000020042002c00000030008a20f0003400000040004b20100000000000000

........q............""...""..r<..........x.... ..............T................

Created start file S0001254_0001.FCA for log position 0x002473fa

Sat May 25 01:19:31 2013

LOGPOS:1254-0026a624x #0:690034177 P0051a057f3-00x F0000-000 T26 U17 A0000x L10684 042 CHKPNT

ffffe000f720a000a0009200920092000000000092001200e000000000007200000000000000000

bfff6400a3400000200002004200820000003000c200f0003400000040008300100000000000000

.........s$..........""...""...""...........""... ..............x#.............

Created start file S0001254_0002.FCA for log position 0x0026a624

Sat May 25 01:19:31 2013

TOCIndex