Stopping and starting transaction logging
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------ =_NextPart_000_01BE0F54.6A422C86
Content-Type: text/plain
My firm has just switched to a time and billing system running in Informix
7.23 on NT 4.0
I have some questions regarding backups for transaction logging. I'm not
sure I'm doing this right.
Here's my current scenario -
Dell 4200/6100 with quad processors
DLT tape drive is used for level 0 backups
DAT drive is used for transaction logging to tape
MKS Toolkit is running on the NT 4.0 server (all commands run thru Toolkit's
Korn shell)
Transaction logs are backed up to DAT drive using ontape -c command
Nightly, I do a level 0 backups to a DLT drive using the ontape -s command.
Before I execute the level 0 backup, I kill the ontape -c session by typing
CTRL-C in the korn shell window where ontape -c is running) I do the backup
to the DLT, replace the DAT tape with the next day's tape and then when the
backup is done, I type ontape -c to begin logging the transactions to tape
again.
Is this what I should be doing or am I screwing things up? I also notice
that if I do not turn transaction logging back on right after I do the
backup, the transaction logs fill up pretty quickly.
-Patricia Noe
Brown, Rudnick, Freed & Gesmer
pnoe@brfg.com
------ =_NextPart_000_01BE0F54.6A422C86
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IjAWAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQSAAQAqAAAAU3RvcHBpbmcgYW5kIHN0YXJ0aW5nIHRyYW5zYWN0
aW9uIGxvZ2dpbmcAABABCYABACEAAABCQ0M4RkNGODAzN0JEMjExODk4RjAwQzA0RkEzNDJGRABb
BwEggAMADgAAAM4HCwANABEAGAAsAAUARwEBBYADAA4AAADOBwsADQASABkAJgAFAEMBAQ2ABAAC
AAAAAgACAAEDkAYAuAgAAC0AAAALAAIAAQAAAEAAOQAgJBfsXA++AR4AcAABAAAAKgAAAFN0b3Bw
aW5nIGFuZCBzdGFydGluZyB0cmFuc2FjdGlvbiBsb2dnaW5nAAAAAgFxAAEAAAAWAAAAAb4PXOwN
+PzIzHsDEdKJjwDAT6NC/QAAAgEJEAEAAACDAwAAfwMAAFYFAABMWkZ1IpD5OwMACgByY3BnMTI1
FjIA+Atgbg4QMDMznQH3IAKkA+MCAGNoCsBgc2V0MCAHEwKAfRkKgXVjAFALA3Vsbg0CIGULpgXQ
eSBmaRhybSARAAQganVzGwVAA+F0EPAJgCB0b1wgYRVAB3EVcG4VMGJVAxBsC4BnFLB5FJBlcRQQ
cnVuAwAWgQuAIAxJbgIQFABpeCA3MC4yMyACIAewVCBcNC4RYAqiCoBJFCF2bRXQcwNwFdBxClAU
kGm3AiAEIAlwZwsRFnJiANC4a3VwBCAX8RVAcgBxSwDQGrIgCQBnZxZxLvogF8AnFBAS4BShCHAV
0Mkd0mRvFnJ0aAQAFxBgaWdodC4ZVBlUSKkEkGUnBCBtE8BjCHB3CXACMBSwYwnwCsAawCDmLRlF
GVREZRZQGQAB0LgwLzYPQBFgFNFoGmH6YRUwcANgIeAEEAWwEMCtIvRMGPABkHAV0GQFEJ8Z8R9h
FIAVIRwybGUZ8O8DIBFgG7Ui5UEY8CZvHG9PHwMVYCYSGVRNSwXwVPpvBvBrFOAmshcmGLEfQLcV
0BjlETByGfAFwCgHQOsDIAWgbQOBZC0THzEXINssdiDxSwWwA6BzFRAWUPopH/pUKkwEIArAFdAb
sn8VIRvwFUIo2BSALXQmEy0WYy9GGUVOH6JseSz/F8Ae0RVxJ40VRCXSNOot4u81pgQgL1UdoUIB
EAWwHoHoIGV4BZB1FuAt0yeM/zeSLMAjYTp6NiARMAQQHPIiYhPAdHlwFnJDVLBSTC1DF5It4msx
J+skIRYAbwfgdxUQHnE1qP0tCCk3pC3iG7QrYy3xJdH/N5AJcAtRIeBFlCjhJhMkM4st4hMAeAVA
ZGF5IPH/JhMV8i3hA6BCsS3ERQUfYb8e4BMAN5JAQT7aFVFiGyD/F6Eq9y3xKjk5A0jEGzALgN0f
60k5AR9SQrBhBUAZsHsxYAhgbBYRJkEe8wWxYX8UEFDRBQAH0B8FDyAm0XD2Px2xFXBsGiAeAg3g
POLvUKEGkDekHhJ0CHAtwSpP/xuUGKIfkxVwAYAu0UR9N5D/TV0zNBPgI2E0QSTQEUBAQJsaYQ3g
azdwH+stUFCgrQUQYwcwB7BvK9VCA2DEd243kFJ1ZAMAG9CNN5BGCdEVMCYgRweQFQeAchlUcBLg
ZUBivHJmHZAvUR/6EfEAYlAAAwD9P1IDAAAeADFAAQAAAA4AAABOT0VQQjEwODY4QjgxAAAAAwAa
QAAAAAAeADBAAQAAAA4AAABOT0VQQjEwODY4QjgxAAAAAwAZQAAAAAADAN4/r28AAAsAAIAIIAYA
AAAAAMAAAAAAAABGAAAAAAOFAAAAAAAAAwACgAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAAD
AAWACCAGAAAAAADAAAAAAAAARgAAAABShQAA8BMAAB4AJYAIIAYAAAAAAMAAAAAAAABGAAAAAFSF
AAABAAAABAAAADguNQALANqACCAGAAAAAADAAAAAAAAARgAAAAAGhQAAAAAAAAMAJoAIIAYAAAAA
AMAAAAAAAABGAAAAAAGFAAAAAAAACwAvgAggBgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADADCA
CCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAAAAMAMoAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAA
AAAAHgBBgAggBgAAAAAAwAAAAAAAAEYAAAAANoUAAAEAAAABAAAAAAAAAB4AQoAIIAYAAAAAAMAA
AAAAAABGAAAAADeFAAABAAAAAQAAAAAAAAAeAEOACCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAA
AAEAAAAAAAAACwDGgAsgBgAAAAAAwAAAAAAAAEYAAAAAAIgAAAAAAAALAMiACyAGAAAAAADAAAAA
AAAARgAAAAAFiAAAAAAAAAMAJgAAAAAAAwA2AAAAAAADAIAQ/////wIB+T8BAAAAZwAAAAAAAADc
p0DIwEIQGrS5CAArL+GCAQAAAAYAAAAvTz1CUk9XTiwgUlVETklDSywgRlJFRUQgJiBHRVNNRVIv
T1U9Qk9TVE9OL0NOPVJFQ0lQSUVOVFMvQ049Tk9FUEIxMDg2OEI4MQAAHgD4PwEAAAARAAAATm9l
LCBQYXRyaWNpYSBCLgAAAAAeADhAAQAAAA4AAABOT0VQQjEwODY4QjgxAAAAAgH7PwEAAABnAAAA
AAAAANynQMjAQhAatLkIACsv4YIBAAAABgAAAC9PPUJST1dOLCBSVUROSUNLLCBGUkVFRCAmIEdF
U01FUi9PVT1CT1NUT04vQ049UkVDSVBJRU5UUy9DTj1OT0VQQjEwODY4QjgxAAAeAPo/AQAAABEA
AABOb2UsIFBhdHJpY2lhIEIuAAAAAB4AOUABAAAADgAAAE5PRVBCMTA4NjhCODEAAABAAAcwQCie
TVUPvgFAAAgwhixCalQPvgEeAD0AAQAAAAEAAAAAAAAAHgAdDgEAAAAqAAAAU3RvcHBpbmcgYW5k
IHN0YXJ0aW5nIHRyYW5zYWN0aW9uIGxvZ2dpbmcAAAALACkAAAAAAAsAIwAAAAAAAwAGEMCq/UoD
AAcQlwMAAAMAEBAAAAAAAwAREAAAAAAeAAgQAQAAAGUAAABNWUZJUk1IQVNKVVNUU1dJVENIRURU
T0FUSU1FQU5EQklMTElOR1NZU1RFTVJVTk5JTkdJTklORk9STUlYNzIzT05OVDQwSUhBVkVTT01F
UVVFU1RJT05TUkVHQVJESU5HQkFDAAAAAFYB
------ =_NextPart_000_01BE0F54.6A422C86--