home *** CD-ROM | disk | FTP | other *** search
/ Chip 1997 September / CHIP_CD_1997_09_PL.iso / software / testsoft / adabas / help / xcontrol.hlp < prev   
Unknown  |  1996-01-10  |  809.4 KB

open in: MacOS 8.1     |     Win98     |     DOS

view JSON data     |     view as text


This file was not able to be converted.
This format is not currently supported by dexvert.

ConfidenceProgramDetectionMatch TypeSupport
100% dexvert Windows Help File (document/hlp) magic Supported
100% dexvert Multimedia Viewer Book (document/multimediaViewerBook) magic Supported
1% dexvert BDC HelpSystem (document/bdcHelpSystem) ext Unsupported
1% dexvert Eureka/Mercury Help (document/eurekaMercuryHelp) ext Unsupported
1% dexvert 4DOS Help (document/fourDOSHelp) ext Unsupported
1% dexvert OPHelp (document/opHelp) ext Unsupported
1% dexvert POP-UP DOS Help (document/popupDOSHelp) ext Unsupported
1% dexvert Quick Help (document/quickHelp) ext Unsupported
1% dexvert RMP Help (document/rmpHelp) ext Unsupported
1% dexvert Symantec DOS software help (document/symantecDOSSoftwareHelp) ext Unsupported
1% dexvert xText compiled Hypertext/Help (document/xTextCompiledHypertext) ext Unsupported
1% dexvert gfxboot compiled HTML Help (document/gfxbootCompiledHTMLHelp) ext Unsupported
1% dexvert Pure Pascal Help (document/purePascalHelp) ext Unsupported
1% dexvert WordPerfect help (document/wordPerfectHelp) ext Unsupported
1% dexvert Ashton-Tate Help data (other/ashtonTateHelpData) ext Unsupported
1% dexvert Borland Help System (other/borlandHelpSystem) ext Unsupported
1% dexvert DeskMate Filer database (other/deskMateFilerDatabase) ext Unsupported
1% dexvert Eclipse Help (other/eclipseHelp) ext Unsupported
1% dexvert Necromancer's Dos Navigator Help (other/necromancersDosNavigatorHelp) ext Unsupported
1% dexvert 1dir+ Help (other/oneDirPlusHelp) ext Unsupported
1% dexvert Qualitas Help (other/qualitasHelp) ext Unsupported
1% dexvert Quattro Pro Help (other/quattroProHelp) ext Unsupported
1% dexvert Turbo Pascal Help (other/turboPascalHelp) ext Unsupported
1% dexvert Vocal-Eyes Help (other/vocalEyesHelp) ext Unsupported
1% dexvert Windows Help index (other/windowsHelpIndex) ext Unsupported
1% dexvert Alpha Four Help (other/alphaFourHelp) ext Unsupported
1% dexvert Applause Help (other/applauseHelp) ext Unsupported
1% dexvert FastLynx Help (other/fastLynxHelp) ext Unsupported
1% dexvert Lucid 3-D Help (other/lucid3DHelp) ext Unsupported
1% dexvert Sprint Help (other/sprintHelp) ext Unsupported
1% dexvert ULTIboard Library (other/ultiboardLibrary) ext Unsupported
100% file MS Windows 3.1 help, Thu Jan 11 14:51:33 1996, title "ADABAS D Control", 828827 bytes default
99% file data default
50% TrID Windows HELP File default
49% TrID Multimedia Viewer Book default
100% siegfried fmt/474 Windows Help File default
100% gt2 Windows 95/98 Hilfedatei default
100% detectItEasy Format: MS Help default
100% xdgMime application/winhlp default



hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 3f 5f 03 00 76 ec 0a 00 | ff ff ff ff 9b a5 0c 00 |?_..v...|........|
|00000010| c8 00 00 00 bf 00 00 00 | 00 6c 03 15 00 01 00 45 |........|.l.....E|
|00000020| 6a f5 30 00 00 01 00 11 | 00 41 44 41 42 41 53 20 |j.0.....|.ADABAS |
|00000030| 44 20 43 6f 6e 74 72 6f | 6c 00 03 00 04 00 00 00 |D Contro|l.......|
|00000040| 00 00 02 00 20 00 43 6f | 70 79 72 69 67 68 74 20 |.... .Co|pyright |
|00000050| ae 20 31 39 39 36 20 62 | 79 20 53 6f 66 74 77 61 |. 1996 b|y Softwa|
|00000060| 72 65 20 41 47 00 04 00 | 10 00 42 72 6f 77 73 65 |re AG...|..Browse|
|00000070| 42 75 74 74 6f 6e 73 28 | 29 00 06 00 5a 00 87 02 |Buttons(|)...Z...|
|00000080| 6d 61 69 6e 00 1c 00 02 | 00 3f 6d 61 69 6e 00 00 |main....|.?main..|
|00000090| 8c 03 3b 41 44 41 42 41 | 53 20 44 20 43 6f 6e 74 |..;ADABA|S D Cont|
|000000a0| 72 6f 6c 00 00 00 57 01 | 47 01 47 01 e4 09 f4 08 |rol...W.|G.G.....|
|000000b0| 1c 20 7a 4f 00 00 9f 01 | 6d 00 23 00 23 00 b0 4f |. zO....|m.#.#..O|
|000000c0| 13 2c 87 01 6c 08 47 01 | ea 02 9f 01 07 00 00 00 |.,..l.G.|........|
|000000d0| 9f 01 9f 01 ff ff 80 00 | 2f 04 00 00 0c 04 00 00 |........|/.......|
|000000e0| 00 6c 70 01 00 08 00 00 | 00 08 01 10 be 33 5f 06 |.lp.....|.....3_.|
|000000f0| 44 08 de 07 00 00 15 00 | 00 00 00 00 00 00 8d 01 |D.......|........|
|00000100| 00 09 00 00 03 11 02 00 | 00 05 00 4f 05 00 81 14 |........|...O....|
|00000110| 03 00 86 26 06 0f 00 1e | 00 04 ff 83 04 00 14 03 |...&....|........|
|00000120| 00 95 57 6f 72 64 0e 00 | 4d 69 63 72 6f 73 6f 66 |..Word..|Microsof|
|00000130| 74 20 57 6f 72 64 05 03 | 00 82 0b 02 04 00 81 05 |t Word..|........|
|00000140| 03 00 87 0c 02 c1 00 1d | 06 0d 03 00 82 fb 02 11 |........|........|
|00000150| 00 84 01 00 44 04 03 00 | 85 2d 01 00 00 07 03 00 |....D...|.-......|
|00000160| 82 fc 02 08 00 81 04 03 | 00 85 2d 01 01 00 09 03 |........|..-.....|
|00000170| 00 89 1d 06 21 00 f0 00 | 06 00 06 03 00 83 1b 00 |....!...|........|
|00000180| 07 03 00 84 fc 02 00 00 | 03 ff 03 00 81 04 03 00 |........|........|
|00000190| 85 2d 01 02 00 04 03 00 | 85 2d 01 01 00 09 03 00 |.-......|.-......|
|000001a0| 89 1d 06 21 00 f0 00 06 | 00 06 03 00 83 1b 00 04 |...!....|........|
|000001b0| 03 00 85 2d 01 02 00 04 | 03 00 85 2d 01 01 00 09 |...-....|...-....|
|000001c0| 03 00 8f 1d 06 21 00 f0 | 00 06 00 dc 05 00 00 21 |.....!..|.......!|
|000001d0| 00 04 03 00 85 2d 01 02 | 00 04 03 00 85 2d 01 01 |.....-..|.....-..|
|000001e0| 00 09 03 00 89 1d 06 21 | 00 f0 00 06 00 06 03 00 |.......!|........|
|000001f0| 83 fd 05 04 03 00 85 2d | 01 02 00 04 03 00 85 2d |.......-|.......-|
|00000200| 01 01 00 09 03 00 89 1d | 06 21 00 f0 00 06 00 06 |........|.!......|
|00000210| 03 00 83 fd 05 04 03 00 | 85 2d 01 02 00 04 03 00 |........|.-......|
|00000220| 85 2d 01 01 00 09 03 00 | 8f 1d 06 21 00 f0 00 a0 |.-......|...!....|
|00000230| 00 06 00 06 00 1b 00 04 | 03 00 85 2d 01 02 00 04 |........|...-....|
|00000240| 03 00 85 2d 01 01 00 09 | 03 00 8f 1d 06 21 00 f0 |...-....|.....!..|
|00000250| 00 06 00 06 00 a6 00 1b | 00 04 03 00 85 2d 01 02 |........|.....-..|
|00000260| 00 04 03 00 85 2d 01 01 | 00 09 03 00 8f 1d 06 21 |.....-..|.......!|
|00000270| 00 f0 00 06 00 06 00 a6 | 00 1b 00 04 03 00 85 2d |........|.......-|
|00000280| 01 02 00 04 03 00 85 2d | 01 01 00 09 03 00 8f 1d |.......-|........|
|00000290| 06 21 00 f0 00 06 00 dc | 05 a6 00 21 00 04 03 00 |.!......|...!....|
|000002a0| 85 2d 01 02 00 04 03 00 | 85 2d 01 01 00 09 03 00 |.-......|.-......|
|000002b0| 8f 1d 06 21 00 f0 00 a0 | 00 06 00 06 00 fd 05 04 |...!....|........|
|000002c0| 03 00 85 2d 01 02 00 04 | 03 00 85 2d 01 01 00 09 |...-....|...-....|
|000002d0| 03 00 8f 1d 06 21 00 f0 | 00 06 00 06 00 a6 00 fd |.....!..|........|
|000002e0| 05 04 03 00 85 2d 01 02 | 00 04 03 00 85 2d 01 01 |.....-..|.....-..|
|000002f0| 00 09 03 00 8f 1d 06 21 | 00 f0 00 06 00 06 00 a6 |.......!|........|
|00000300| 00 fd 05 04 03 00 85 2d | 01 02 00 04 03 00 85 02 |.......-|........|
|00000310| 01 01 00 13 03 00 84 fb | 02 da ff 06 00 82 90 01 |........|........|
|00000320| 04 00 93 04 00 00 31 43 | 6f 75 72 69 65 72 20 4e |......1C|ourier N|
|00000330| 65 77 00 6d 61 04 03 00 | 85 2d 01 03 00 05 03 00 |ew.ma...|.-......|
|00000340| 87 09 02 00 00 ff 00 04 | 03 00 85 02 01 01 00 05 |........|........|
|00000350| 03 00 82 09 02 04 00 81 | 04 03 00 85 02 01 01 00 |........|........|
|00000360| 04 03 00 85 2d 01 03 00 | 05 03 00 87 09 02 00 00 |....-...|........|
|00000370| ff 00 4f 03 00 a0 32 0a | 2e 00 2c 00 2d 00 04 00 |..O...2.|..,.-...|
|00000380| 21 00 28 00 fd 05 56 00 | 20 20 72 65 73 74 6f 72 |!.(...V.| restor|
|00000390| 65 20 64 61 74 61 06 20 | 83 28 32 29 0d 20 e5 28 |e data. |.(2). .(|
|000003a0| 44 41 54 41 5f 42 30 29 | 00 17 00 17 00 17 00 17 |DATA_B0)|........|
|000003b0| 00 17 00 17 00 17 00 17 | 00 17 00 17 00 17 00 17 |........|........|
|000003c0| 00 17 00 17 00 17 00 17 | 00 17 00 17 00 17 00 17 |........|........|
|000003d0| 00 17 00 17 00 17 00 17 | 00 17 00 17 00 17 00 17 |........|........|
|000003e0| 00 17 00 17 00 17 00 17 | 00 17 00 17 00 17 00 17 |........|........|
|000003f0| 00 17 00 17 00 17 00 17 | 00 17 00 17 00 17 00 17 |........|........|
|00000400| 00 17 00 04 03 00 85 02 | 01 01 00 05 03 00 82 09 |........|........|
|00000410| 02 04 00 81 04 03 00 85 | 02 01 01 00 04 03 00 85 |........|........|
|00000420| 2d 01 03 00 05 03 00 87 | 09 02 00 00 ff 00 19 03 |-.......|........|
|00000430| 00 af 32 0a 56 00 2c 00 | 09 00 04 00 21 00 50 00 |..2.V.,.|....!.P.|
|00000440| fd 05 7e 00 20 20 72 65 | 73 74 61 72 74 00 17 00 |..~. re|start...|
|00000450| 17 00 17 00 17 00 17 00 | 17 00 17 00 17 00 17 00 |........|........|
|00000460| 04 03 00 85 02 01 01 00 | 05 03 00 82 09 02 04 00 |........|........|
|00000470| 81 04 03 00 85 02 01 01 | 00 04 03 00 85 2d 01 03 |........|.....-..|
|00000480| 00 05 03 00 87 09 02 00 | 00 ff 00 04 03 00 85 02 |........|........|
|00000490| 01 01 00 05 03 00 82 09 | 02 04 00 81 04 03 00 85 |........|........|
|000004a0| 02 01 01 00 15 03 00 84 | fb 02 ef ff 06 00 82 90 |........|........|
|000004b0| 01 04 00 93 04 00 00 12 | 54 69 6d 65 73 20 4e 65 |........|Times Ne|
|000004c0| 77 20 52 6f 6d 61 6e 03 | 00 81 04 03 00 85 2d 01 |w Roman.|......-.|
|000004d0| 04 00 04 03 00 85 02 01 | 01 00 04 03 00 85 2d 01 |........|......-.|
|000004e0| 00 00 04 03 00 85 f0 01 | 01 00 03 05 00 7c 62 6d |........|.....|bm|
|000004f0| 39 00 b4 16 04 00 7c 62 | 6d 39 30 00 99 be 06 00 |9.....|b|m90.....|
|00000500| 17 00 17 00 17 00 17 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000510| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000520| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000530| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000540| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000550| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000560| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000570| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000580| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000590| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000600| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000610| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000620| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000630| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000670| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000680| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000690| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000700| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000710| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000720| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000740| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000750| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000780| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000790| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007f0| 00 00 00 00 00 00 00 87 | 95 02 00 7e 95 02 00 20 |........|...~... |
|00000800| ff ff ff ff 0c 00 00 00 | 00 00 00 00 41 00 00 00 |........|....A...|
|00000810| 10 00 00 00 ff ff ff ff | 4d 00 00 00 31 00 00 00 |........|M...1...|
|00000820| 02 8d 0d 00 00 ff ff ff | ff ff ff ff ff 00 00 00 |........|........|
|00000830| 00 4d 00 00 00 7b 00 00 | 00 d7 0d 00 00 41 44 41 |.M...{..|.....ADA|
|00000840| 42 41 53 20 44 20 43 6f | 6e 74 72 6f 6c 2e 00 00 |BAS D Co|ntrol...|
|00000850| 00 0b 00 00 00 0c 00 00 | 00 7b 00 00 00 23 00 00 |........|.{...#..|
|00000860| 00 20 16 80 16 00 80 00 | 00 00 00 80 03 00 82 ff |. ......|........|
|00000870| 00 43 6f 6e 74 65 6e 74 | 73 00 00 28 00 00 00 03 |.Content|s..(....|
|00000880| 00 00 00 4d 00 00 00 a3 | 00 00 00 25 00 00 00 20 |...M....|...%... |
|00000890| 1a 80 06 00 80 00 00 0a | 00 94 b8 80 04 00 82 ff |........|........|
|000008a0| 00 00 00 48 00 00 00 19 | 00 00 00 7b 00 00 00 eb |...H....|...{....|
|000008b0| 00 00 00 2f 00 00 00 20 | 2e 80 32 00 80 00 00 0e |.../... |..2.....|
|000008c0| 00 84 8c b8 e3 0d 45 55 | 2c 80 05 00 89 80 06 00 |......EU|,.......|
|000008d0| 82 ff 00 00 4f 72 64 65 | 72 69 6e 67 20 74 68 65 |....Orde|ring the|
|000008e0| 20 4d 61 6e 75 61 6c 00 | 00 00 00 34 00 00 00 0f | Manual.|...4....|
|000008f0| 00 00 00 a3 00 00 00 1f | 01 00 00 25 00 00 00 20 |........|...%... |
|00000900| 1a 80 1e 00 80 00 00 06 | 00 b0 98 80 07 00 82 ff |........|........|
|00000910| 00 49 6e 74 72 6f 64 75 | 63 74 69 6f 6e 00 00 41 |.Introdu|ction..A|
|00000920| 00 00 00 12 00 00 00 eb | 00 00 00 60 01 00 00 2f |........|...`.../|
|00000930| 00 00 00 20 2e 80 24 00 | 80 00 00 0e 00 84 8c b8 |... ..$.|........|
|00000940| e3 f9 3c 50 9c 80 05 00 | 89 80 06 00 82 ff 00 00 |..<P....|........|
|00000950| 49 6e 74 72 6f 64 75 63 | 74 69 6f 6e 00 00 00 00 |Introduc|tion....|
|00000960| 30 00 00 00 0b 00 00 00 | 1f 01 00 00 90 01 00 00 |0.......|........|
|00000970| 25 00 00 00 20 1a 80 16 | 00 80 00 00 06 00 b0 98 |%... ...|........|
|00000980| 80 07 00 82 ff 00 43 6f | 6e 63 65 70 74 73 00 00 |......Co|ncepts..|
|00000990| b6 01 00 00 f7 00 00 00 | 60 01 00 00 46 03 00 00 |........|`...F...|
|000009a0| bf 00 00 00 20 4c 81 ef | 01 00 80 00 00 0e 00 84 |.... L..|........|
|000009b0| 8c b8 e3 b2 ce 9b 1a 80 | 05 00 89 80 06 00 82 e3 |........|........|
|000009c0| 40 05 b2 f8 80 05 00 89 | 80 06 00 82 e3 64 b8 33 |@.......|.....d.3|
|000009d0| df 80 05 00 89 80 06 00 | 82 e3 95 04 e0 6e 80 05 |........|.....n..|
|000009e0| 00 89 80 06 00 82 e3 51 | 01 28 1a 80 05 00 89 80 |.......Q|.(......|
|000009f0| 06 00 82 e3 72 be 2a 28 | 80 05 00 89 80 06 00 82 |....r.*(|........|
|00000a00| e3 cb 01 97 68 80 05 00 | 89 80 06 00 82 e3 ea 0c |....h...|........|
|00000a10| d2 ce 80 05 00 89 80 06 | 00 82 e3 25 81 06 dd 80 |........|...%....|
|00000a20| 05 00 89 80 06 00 82 e3 | c7 9c 18 db 80 05 00 89 |........|........|
|00000a30| 80 06 00 82 e3 f4 1a e0 | 00 80 05 00 89 80 06 00 |........|........|
|00000a40| 82 e3 34 f9 f7 e3 80 05 | 00 89 80 06 00 82 ff 00 |..4.....|........|
|00000a50| 00 53 45 52 56 45 52 44 | 42 a0 53 74 72 75 63 74 |.SERVERD|B.Struct|
|00000a60| 75 72 65 00 00 00 00 00 | 4c 6f 67 67 69 6e 67 00 |ure.....|Logging.|
|00000a70| 00 00 00 00 42 61 63 6b | 75 70 00 00 00 00 00 52 |....Back|up.....R|
|00000a80| 65 73 74 6f 72 65 00 00 | 00 00 00 43 6f 6e 73 69 |estore..|...Consi|
|00000a90| 73 74 65 6e 63 79 a0 43 | 68 65 63 6b a0 61 6e 64 |stency.C|heck.and|
|00000aa0| a0 4f 70 74 69 6d 69 7a | 65 72 a0 53 75 70 70 6f |.Optimiz|er.Suppo|
|00000ab0| 72 74 00 00 00 00 00 43 | 61 63 68 65 73 00 00 00 |rt.....C|aches...|
|00000ac0| 00 00 4d 75 6c 74 69 70 | 72 6f 63 65 73 73 6f 72 |..Multip|rocessor|
|00000ad0| a0 43 6f 6e 66 69 67 75 | 72 61 74 69 6f 6e 73 00 |.Configu|rations.|
|00000ae0| 00 00 00 00 43 6c 69 65 | 6e 74 a0 53 65 72 76 65 |....Clie|nt.Serve|
|00000af0| 72 00 00 00 00 00 44 69 | 73 74 72 69 62 75 74 69 |r.....Di|stributi|
|00000b00| 6f 6e 00 00 00 00 00 53 | 70 65 63 69 61 6c a0 55 |on.....S|pecial.U|
|00000b10| 73 65 72 73 00 00 00 00 | 00 41 76 61 69 6c 61 62 |sers....|.Availab|
|00000b20| 69 6c 69 74 79 00 00 00 | 00 00 43 6f 6e 66 69 67 |ility...|..Config|
|00000b30| 75 72 61 74 69 6f 6e a0 | 50 61 72 61 6d 65 74 65 |uration.|Paramete|
|00000b40| 72 73 00 00 00 00 3d 00 | 00 00 18 00 00 00 90 01 |rs....=.|........|
|00000b50| 00 00 83 03 00 00 25 00 | 00 00 20 1a 80 30 00 80 |......%.|.. ..0..|
|00000b60| 00 00 06 00 b0 98 80 07 | 00 82 ff 00 43 61 6c 6c |........|....Call|
|00000b70| a0 61 6e 64 a0 49 6e 73 | 74 61 6c 6c 61 74 69 6f |.and.Ins|tallatio|
|00000b80| 6e 00 00 00 01 00 00 9c | 00 00 00 46 03 00 00 83 |n.......|...F....|
|00000b90| 04 00 00 64 00 00 00 20 | 96 80 39 01 00 80 00 00 |...d... |..9.....|
|00000ba0| 0e 00 84 8c b8 e3 fc b2 | 19 43 80 05 00 89 80 06 |........|.C......|
|00000bb0| 00 82 e3 6f 7f 03 cd 80 | 05 00 89 80 06 00 82 e3 |...o....|........|
|00000bc0| 87 ec b5 23 80 05 00 89 | 80 06 00 82 e3 0a 20 2c |...#....|...... ,|
|00000bd0| 4a 80 05 00 89 80 06 00 | 82 e3 37 47 eb 9e 80 05 |J.......|..7G....|
|00000be0| 00 89 80 06 00 82 ff 00 | 00 43 61 6c 6c 69 6e 67 |........|.Calling|
|00000bf0| a0 43 4f 4e 54 52 4f 4c | 00 00 00 00 00 49 6e 73 |.CONTROL|.....Ins|
|00000c00| 74 61 6c 6c 69 6e 67 a0 | 61 a0 4e 65 77 a0 53 45 |talling.|a.New.SE|
|00000c10| 52 56 45 52 44 42 00 00 | 00 00 00 54 68 65 a0 41 |RVERDB..|...The.A|
|00000c20| 64 64 69 74 69 6f 6e 61 | 6c a0 49 6e 73 74 61 6c |dditiona|l.Instal|
|00000c30| 6c 61 74 69 6f 6e a0 6f | 66 a0 43 4f 4e 54 52 4f |lation.o|f.CONTRO|
|00000c40| 4c 00 00 00 00 00 54 68 | 65 a0 4d 61 69 6e a0 53 |L.....Th|e.Main.S|
|00000c50| 63 72 65 65 6e 00 00 00 | 00 00 43 4f 4e 54 52 4f |creen...|..CONTRO|
|00000c60| 4c a0 4d 65 6e 75 a0 53 | 74 72 75 63 74 75 72 65 |L.Menu.S|tructure|
|00000c70| a0 61 6e 64 a0 48 65 6c | 70 a0 54 65 78 74 73 00 |.and.Hel|p.Texts.|
|00000c80| 00 00 00 3f 00 00 00 1a | 00 00 00 83 03 00 00 c2 |...?....|........|
|00000c90| 04 00 00 25 00 00 00 20 | 1a 80 34 00 80 00 00 06 |...%... |..4.....|
|00000ca0| 00 b0 98 80 07 00 82 ff | 00 4f 70 65 72 61 74 69 |........|.Operati|
|00000cb0| 6e 67 a0 4d 65 6e 75 a0 | 46 75 6e 63 74 69 6f 6e |ng.Menu.|Function|
|00000cc0| 00 00 0e 01 00 00 9d 00 | 00 00 83 04 00 00 d0 05 |........|........|
|00000cd0| 00 00 71 00 00 00 20 b0 | 80 3b 01 00 80 00 00 0e |..q... .|.;......|
|00000ce0| 00 84 8c b8 e3 93 e7 bb | 6a 80 05 00 89 80 06 00 |........|j.......|
|00000cf0| 82 e3 24 08 7a aa 80 05 | 00 89 80 06 00 82 e3 85 |..$.z...|........|
|00000d00| 7b 51 36 80 05 00 89 80 | 06 00 82 e3 19 1a 27 67 |{Q6.....|......'g|
|00000d10| 80 05 00 89 80 06 00 82 | e3 e4 73 98 82 80 05 00 |........|..s.....|
|00000d20| 89 80 06 00 82 e3 87 86 | ce cc 80 05 00 89 80 06 |........|........|
|00000d30| 00 82 ff 00 00 4f 70 65 | 72 61 74 69 6e 67 a0 4d |.....Ope|rating.M|
|00000d40| 65 6e 75 a0 46 75 6e 63 | 74 69 6f 6e 00 00 00 00 |enu.Func|tion....|
|00000d50| 00 4f 70 65 72 61 74 69 | 6e 67 a0 2f a0 52 65 66 |.Operati|ng./.Ref|
|00000d60| 72 65 73 68 00 00 00 00 | 00 4f 70 65 72 61 74 69 |resh....|.Operati|
|00000d70| 6e 67 a0 2f a0 52 65 73 | 74 61 72 74 00 00 00 00 |ng./.Res|tart....|
|00000d80| 00 4f 70 65 72 61 74 69 | 6e 67 a0 2f a0 53 68 75 |.Operati|ng./.Shu|
|00000d90| 74 64 6f 77 6e 00 00 00 | 00 00 4f 70 65 72 61 74 |tdown...|..Operat|
|00000da0| 69 6e 67 a0 2f a0 55 70 | 64 61 74 65 a0 53 74 61 |ing./.Up|date.Sta|
|00000db0| 74 69 73 74 69 63 73 00 | 00 00 00 00 4f 70 65 72 |tistics.|....Oper|
|00000dc0| 61 74 69 6e 67 a0 2f a0 | 45 78 69 74 00 00 00 00 |ating./.|Exit....|
|00000dd0| 3a 00 00 00 15 00 00 00 | c2 04 00 00 0a 06 00 00 |:.......|........|
|00000de0| 25 00 00 00 20 1a 80 2a | 00 80 00 00 06 00 b0 98 |%... ..*|........|
|00000df0| 80 07 00 82 ff 00 49 6e | 66 6f a0 4d 65 6e 75 a0 |......In|fo.Menu.|
|00000e00| 46 75 6e 63 74 69 6f 6e | 00 00 ad 01 00 00 ee 00 |Function|........|
|00000e10| 00 00 d0 05 00 00 b7 07 | 00 00 bf 00 00 00 20 4c |........|...... L|
|00000e20| 81 dd 01 00 80 00 00 0e | 00 84 8c b8 e3 d4 7f d7 |........|........|
|00000e30| cd 80 05 00 89 80 06 00 | 82 e3 79 81 76 1a 80 05 |........|..y.v...|
|00000e40| 00 89 80 06 00 82 e3 9b | fe d5 09 80 05 00 89 80 |........|........|
|00000e50| 06 00 82 e3 7d da ff 28 | 80 05 00 89 80 06 00 82 |....}..(|........|
|00000e60| e3 f3 cd d9 ba 80 05 00 | 89 80 06 00 82 e3 5b 79 |........|......[y|
|00000e70| ac be 80 05 00 89 80 06 | 00 82 e3 ca 4f 0d 9c 80 |........|....O...|
|00000e80| 05 00 89 80 06 00 82 e3 | 90 3c 3f 22 80 05 00 89 |........|.<?"....|
|00000e90| 80 06 00 82 e3 5f 15 35 | d1 80 05 00 89 80 06 00 |....._.5|........|
|00000ea0| 82 e3 1a 53 4f 40 80 05 | 00 89 80 06 00 82 e3 f5 |...SO@..|........|
|00000eb0| dc 8d 8f 80 05 00 89 80 | 06 00 82 e3 d3 dd 50 c6 |........|......P.|
|00000ec0| 80 05 00 89 80 06 00 82 | ff 00 00 49 6e 66 6f a0 |........|...Info.|
|00000ed0| 4d 65 6e 75 a0 46 75 6e | 63 74 69 6f 6e 00 00 00 |Menu.Fun|ction...|
|00000ee0| 00 00 49 6e 66 6f a0 2f | a0 41 63 74 69 76 69 74 |..Info./|.Activit|
|00000ef0| 79 00 00 00 00 00 49 6e | 66 6f a0 2f a0 43 6f 6e |y.....In|fo./.Con|
|00000f00| 66 69 67 75 72 61 74 69 | 6f 6e 00 00 00 00 00 49 |figurati|on.....I|
|00000f10| 6e 66 6f a0 2f a0 55 73 | 65 72 73 00 00 00 00 00 |nfo./.Us|ers.....|
|00000f20| 49 6e 66 6f a0 2f a0 43 | 61 63 68 65 73 00 00 00 |Info./.C|aches...|
|00000f30| 00 00 49 6e 66 6f a0 2f | a0 49 2f 4f a0 41 63 63 |..Info./|.I/O.Acc|
|00000f40| 65 73 73 65 73 00 00 00 | 00 00 49 6e 66 6f a0 2f |esses...|..Info./|
|00000f50| a0 4c 6f 63 6b 73 00 00 | 00 00 00 49 6e 66 6f a0 |.Locks..|...Info.|
|00000f60| 2f a0 4c 6f 67 73 00 00 | 00 00 00 49 6e 66 6f a0 |/.Logs..|...Info.|
|00000f70| 2f a0 50 72 6f 63 65 73 | 73 65 73 00 00 00 00 00 |/.Proces|ses.....|
|00000f80| 49 6e 66 6f a0 2f a0 52 | 65 67 69 6f 6e 73 00 00 |Info./.R|egions..|
|00000f90| 00 00 00 49 6e 66 6f a0 | 2f a0 4d 65 6d 6f 72 79 |...Info.|/.Memory|
|00000fa0| 00 00 00 00 00 49 6e 66 | 6f a0 2f a0 56 65 72 73 |.....Inf|o./.Vers|
|00000fb0| 69 6f 6e 00 00 00 00 3d | 00 00 00 18 00 00 00 0a |ion....=|........|
|00000fc0| 06 00 00 f4 07 00 00 25 | 00 00 00 20 1a 80 30 00 |.......%|... ..0.|
|00000fd0| 80 00 00 06 00 b0 98 80 | 07 00 82 ff 00 4f 70 74 |........|.....Opt|
|00000fe0| 69 6f 6e 73 a0 4d 65 6e | 75 a0 46 75 6e 63 74 69 |ions.Men|u.Functi|
|00000ff0| 6f 6e 00 00 3b 01 00 00 | bd 00 00 00 b7 07 00 00 |on..;...|........|
|00001000| 2f 09 00 00 7e 00 00 00 | 20 ca 80 7b 01 00 80 00 |/...~...| ..{....|
|00001010| 00 0e 00 84 8c b8 e3 f7 | 1e 70 f5 80 05 00 89 80 |........|.p......|
|00001020| 06 00 82 e3 dd eb 4e 6b | 80 05 00 89 80 06 00 82 |......Nk|........|
|00001030| e3 ca 88 89 f7 80 05 00 | 89 80 06 00 82 e3 bd 08 |........|........|
|00001040| c8 f1 80 05 00 89 80 06 | 00 82 e3 f5 2b 30 dd 80 |........|....+0..|
|00001050| 05 00 89 80 06 00 82 e3 | d2 e6 9c 97 80 05 00 89 |........|........|
|00001060| 80 06 00 82 e3 64 c8 a8 | 85 80 05 00 89 80 06 00 |.....d..|........|
|00001070| 82 ff 00 00 4f 70 74 69 | 6f 6e 73 a0 2f a0 52 65 |....Opti|ons./.Re|
|00001080| 73 65 74 a0 43 6f 75 6e | 74 65 72 00 00 00 00 00 |set.Coun|ter.....|
|00001090| 4f 70 74 69 6f 6e 73 a0 | 2f a0 52 65 6d 6f 74 65 |Options.|/.Remote|
|000010a0| a0 53 51 4c a0 53 65 72 | 76 65 72 00 00 00 00 00 |.SQL.Ser|ver.....|
|000010b0| 4f 70 74 69 6f 6e 73 a0 | 2f a0 41 63 63 6f 75 6e |Options.|/.Accoun|
|000010c0| 74 69 6e 67 00 00 00 00 | 00 4f 70 74 69 6f 6e 73 |ting....|.Options|
|000010d0| a0 2f a0 41 63 63 65 73 | 73 a0 4d 6f 64 65 00 00 |./.Acces|s.Mode..|
|000010e0| 00 00 00 4f 70 74 69 6f | 6e 73 a0 2f a0 4b 65 72 |...Optio|ns./.Ker|
|000010f0| 6e 65 6c a0 54 72 61 63 | 65 00 00 00 00 00 4f 70 |nel.Trac|e.....Op|
|00001100| 74 69 6f 6e 73 a0 2f a0 | 41 75 74 6f 73 61 76 65 |tions./.|Autosave|
|00001110| a0 4c 6f 67 00 00 00 00 | 00 4f 70 74 69 6f 6e 73 |.Log....|.Options|
|00001120| a0 2f a0 53 63 68 65 64 | 75 6c 65 00 00 00 00 3c |./.Sched|ule....<|
|00001130| 00 00 00 17 00 00 00 f4 | 07 00 00 6b 09 00 00 25 |........|...k...%|
|00001140| 00 00 00 20 1a 80 2e 00 | 80 00 00 06 00 b0 98 80 |... ....|........|
|00001150| 07 00 82 ff 00 42 61 63 | 6b 75 70 a0 4d 65 6e 75 |.....Bac|kup.Menu|
|00001160| a0 46 75 6e 63 74 69 6f | 6e 00 00 d9 00 00 00 76 |.Functio|n......v|
|00001170| 00 00 00 2f 09 00 00 44 | 0a 00 00 63 00 00 00 20 |.../...D|...c... |
|00001180| 96 80 ec 00 80 00 00 0e | 00 84 8c b8 e3 19 e7 e1 |........|........|
|00001190| 54 80 05 00 89 80 06 00 | 82 e3 08 14 39 8d 80 05 |T.......|....9...|
|000011a0| 00 89 80 06 00 82 e3 3e | b4 7b 9f 80 05 00 89 80 |.......>|.{......|
|000011b0| 06 00 82 e3 bb d1 b9 74 | 80 05 00 89 80 06 00 82 |.......t|........|
|000011c0| e3 b9 72 72 f3 80 05 00 | 89 80 06 00 82 ff 00 00 |..rr....|........|
|000011d0| 42 61 63 6b 75 70 a0 4d | 65 6e 75 a0 46 75 6e 63 |Backup.M|enu.Func|
|000011e0| 74 69 6f 6e 00 00 00 00 | 00 42 61 63 6b 75 70 a0 |tion....|.Backup.|
|000011f0| 2f a0 53 61 76 65 00 00 | 00 00 00 42 61 63 6b 75 |/.Save..|...Backu|
|00001200| 70 a0 2f a0 52 65 73 74 | 6f 72 65 00 00 00 00 00 |p./.Rest|ore.....|
|00001210| 42 61 63 6b 75 70 a0 2f | a0 53 68 6f 77 a0 48 69 |Backup./|.Show.Hi|
|00001220| 73 74 6f 72 79 00 00 00 | 00 00 42 61 63 6b 75 70 |story...|..Backup|
|00001230| a0 2f a0 53 68 6f 77 a0 | 50 72 6f 74 6f 63 6f 6c |./.Show.|Protocol|
|00001240| 00 00 00 00 41 00 00 00 | 1c 00 00 00 6b 09 00 00 |....A...|....k...|
|00001250| 85 0a 00 00 25 00 00 00 | 20 1a 80 38 00 80 00 00 |....%...| ..8....|
|00001260| 06 00 b0 98 80 07 00 82 | ff 00 41 64 76 61 6e 63 |........|..Advanc|
|00001270| 65 64 a0 42 61 63 6b 75 | 70 a0 46 75 6e 63 74 69 |ed.Backu|p.Functi|
|00001280| 6f 6e 73 00 00 d4 00 00 | 00 71 00 00 00 44 0a 00 |ons.....|.q...D..|
|00001290| 00 59 0b 00 00 63 00 00 | 00 20 96 80 e2 00 80 00 |.Y...c..|. ......|
|000012a0| 00 0e 00 84 8c b8 e3 90 | 75 54 d8 80 05 00 89 80 |........|uT......|
|000012b0| 06 00 82 e3 11 d7 30 5d | 80 05 00 89 80 06 00 82 |......0]|........|
|000012c0| e3 a7 39 66 bc 80 05 00 | 89 80 06 00 82 e3 6d 71 |..9f....|......mq|
|000012d0| 1f 34 80 05 00 89 80 06 | 00 82 e3 39 51 75 24 80 |.4......|...9Qu$.|
|000012e0| 05 00 89 80 06 00 82 ff | 00 00 43 6f 6e 63 65 70 |........|..Concep|
|000012f0| 74 73 00 00 00 00 00 42 | 61 63 6b 75 70 a0 2f a0 |ts.....B|ackup./.|
|00001300| 4d 65 64 69 61 a0 4d 61 | 6e 61 67 65 72 00 00 00 |Media.Ma|nager...|
|00001310| 00 00 42 61 63 6b 75 70 | a0 2f a0 4c 61 62 65 6c |..Backup|./.Label|
|00001320| a0 4d 61 6e 61 67 65 72 | 00 00 00 00 00 42 61 63 |.Manager|.....Bac|
|00001330| 6b 75 70 a0 2f a0 53 63 | 68 65 64 75 6c 65 a0 4d |kup./.Sc|hedule.M|
|00001340| 61 6e 61 67 65 72 00 00 | 00 00 00 42 61 74 63 68 |anager..|...Batch|
|00001350| a0 4d 6f 64 65 00 00 00 | 00 3e 00 00 00 19 00 00 |.Mode...|.>......|
|00001360| 00 85 0a 00 00 97 0b 00 | 00 25 00 00 00 20 1a 80 |........|.%... ..|
|00001370| 32 00 80 00 00 06 00 b0 | 98 80 07 00 82 ff 00 44 |2.......|.......D|
|00001380| 69 61 67 6e 6f 73 65 a0 | 4d 65 6e 75 a0 46 75 6e |iagnose.|Menu.Fun|
|00001390| 63 74 69 6f 6e 00 00 9e | 00 00 00 55 00 00 00 59 |ction...|...U...Y|
|000013a0| 0b 00 00 35 0c 00 00 49 | 00 00 00 20 62 80 aa 00 |...5...I|... b...|
|000013b0| 80 00 00 0e 00 84 8c b8 | e3 3c 3c f7 34 80 05 00 |........|.<<.4...|
|000013c0| 89 80 06 00 82 e3 aa d7 | 52 d2 80 05 00 89 80 06 |........|R.......|
|000013d0| 00 82 e3 b9 ae 85 df 80 | 05 00 89 80 06 00 82 ff |........|........|
|000013e0| 00 00 44 69 61 67 6e 6f | 73 65 a0 2f a0 4f 70 a0 |..Diagno|se./.Op.|
|000013f0| 4d 65 73 73 61 67 65 73 | 00 00 00 00 00 44 69 61 |Messages|.....Dia|
|00001400| 67 6e 6f 73 65 a0 2f a0 | 4c 6f 67 a0 4d 65 73 73 |gnose./.|Log.Mess|
|00001410| 61 67 65 73 00 00 00 00 | 00 44 69 61 67 6e 6f 73 |ages....|.Diagnos|
|00001420| 65 a0 2f a0 49 6e 73 74 | a0 50 72 6f 74 6f 63 6f |e./.Inst|.Protoco|
|00001430| 6c 00 00 00 00 43 00 00 | 00 1e 00 00 00 97 0b 00 |l....C..|........|
|00001440| 00 78 0c 00 00 25 00 00 | 00 20 1a 80 3c 00 80 00 |.x...%..|. ..<...|
|00001450| 00 06 00 b0 98 80 07 00 | 82 ff 00 43 6f 6e 66 69 |........|...Confi|
|00001460| 67 75 72 61 74 69 6f 6e | a0 4d 65 6e 75 a0 46 75 |guration|.Menu.Fu|
|00001470| 6e 63 74 69 6f 6e 00 00 | 11 01 00 00 ad 00 00 00 |nction..|........|
|00001480| 35 0c 00 00 89 0d 00 00 | 64 00 00 00 20 96 80 5b |5.......|d... ..[|
|00001490| 01 00 80 00 00 0e 00 84 | 8c b8 e3 34 ba dd e8 80 |........|...4....|
|000014a0| 05 00 89 80 06 00 82 e3 | 48 a7 d6 5b 80 05 00 89 |........|H..[....|
|000014b0| 80 06 00 82 e3 1b a6 a9 | 93 80 05 00 89 80 06 00 |........|........|
|000014c0| 82 e3 f8 81 cf 52 80 05 | 00 89 80 06 00 82 e3 35 |.....R..|.......5|
|000014d0| 2a d2 75 80 05 00 89 80 | 06 00 82 ff 00 00 43 6f |*.u.....|......Co|
|000014e0| 6e 66 69 67 75 72 61 74 | 69 6f 6e a0 2f a0 41 6c |nfigurat|ion./.Al|
|000014f0| 74 65 72 a0 50 61 72 61 | 6d 65 74 65 72 73 00 00 |ter.Para|meters..|
|00001500| 00 00 00 43 6f 6e 66 69 | 67 75 72 61 74 69 6f 6e |...Confi|guration|
|00001510| a0 2f a0 41 6c 74 65 72 | a0 43 6f 6e 66 69 67 00 |./.Alter|.Config.|
|00001520| 00 00 00 00 43 6f 6e 66 | 69 67 75 72 61 74 69 6f |....Conf|iguratio|
|00001530| 6e a0 2f a0 4c 6f 61 64 | a0 53 79 73 74 61 62 6c |n./.Load|.Systabl|
|00001540| 65 73 00 00 00 00 00 43 | 6f 6e 66 69 67 75 72 61 |es.....C|onfigura|
|00001550| 74 69 6f 6e a0 2f a0 49 | 6e 69 74 a0 43 6f 6e 66 |tion./.I|nit.Conf|
|00001560| 69 67 00 00 00 00 00 43 | 6f 6e 66 69 67 75 72 61 |ig.....C|onfigura|
|00001570| 74 69 6f 6e a0 2f a0 43 | 6c 65 61 72 a0 53 65 72 |tion./.C|lear.Ser|
|00001580| 76 65 72 64 62 00 00 00 | 00 26 00 00 00 03 00 00 |verdb...|.&......|
|00001590| 00 78 0c 00 00 af 0d 00 | 00 23 00 00 00 20 16 80 |.x......|.#... ..|
|000015a0| 06 00 80 00 00 00 00 80 | 04 00 82 ff 00 00 00 28 |........|.......(|
|000015b0| 00 00 00 03 00 00 00 89 | 0d 00 00 d7 0d 00 00 25 |........|.......%|
|000015c0| 00 00 00 20 1a 80 06 00 | 80 00 00 06 00 bc 98 80 |... ....|........|
|000015d0| 05 00 82 ff 00 00 00 44 | 00 00 00 13 00 00 00 af |.......D|........|
|000015e0| 0d 00 00 1b 0e 00 00 31 | 00 00 00 02 02 04 00 00 |.......1|........|
|000015f0| ff ff ff ff ff ff ff ff | 01 00 00 00 1b 0e 00 00 |........|........|
|00001600| 54 0e 00 00 31 42 00 00 | 4f 72 64 65 72 69 6e 67 |T...1B..|Ordering|
|00001610| 20 74 68 65 20 4d 61 6e | 75 61 6c 39 00 00 00 16 | the Man|ual9....|
|00001620| 00 00 00 d7 0d 00 00 54 | 0e 00 00 23 00 00 00 20 |.......T|...#... |
|00001630| 16 80 2c 00 80 00 00 00 | 00 80 03 00 82 ff 00 4f |..,.....|.......O|
|00001640| 72 64 65 72 69 6e 67 20 | 74 68 65 20 4d 61 6e 75 |rdering |the Manu|
|00001650| 61 6c 00 00 56 02 00 00 | 20 02 00 00 1b 0e 00 00 |al..V...| .......|
|00001660| b6 40 00 00 36 00 00 00 | 20 3a 80 41 04 00 80 00 |.@..6...| :.A....|
|00001670| 00 00 00 80 08 00 82 82 | 80 09 00 82 82 82 82 82 |........|........|
|00001680| 82 82 80 0a 00 80 0b 00 | 82 ff 00 20 00 4d 61 6e |........|... .Man|
|00001690| 75 61 6c 20 4f 72 64 65 | 72 20 4e 75 6d 62 65 72 |ual Orde|r Number|
|000016a0| 3a 20 20 45 53 44 36 31 | 31 2d 30 33 34 57 4f 55 |: ESD61|1-034WOU|
|000016b0| 00 00 20 00 54 68 69 73 | 20 6f 6e 6c 69 6e 65 20 |.. .This| online |
|000016c0| 68 65 6c 70 20 69 73 20 | 61 70 70 6c 69 63 61 62 |help is |applicab|
|000016d0| 6c 65 20 74 6f 20 41 44 | 41 42 41 53 20 44 20 56 |le to AD|ABAS D V|
|000016e0| 65 72 73 69 6f 6e 20 36 | 2e 31 2e 31 20 50 45 20 |ersion 6|.1.1 PE |
|000016f0| 61 6e 64 20 74 6f 20 61 | 6c 6c 20 73 75 62 73 65 |and to a|ll subse|
|00001700| 71 75 65 6e 74 20 72 65 | 6c 65 61 73 65 73 2c 20 |quent re|leases, |
|00001710| 75 6e 6c 65 73 73 20 6f | 74 68 65 72 77 69 73 65 |unless o|therwise|
|00001720| 20 69 6e 64 69 63 61 74 | 65 64 20 69 6e 20 6e 65 | indicat|ed in ne|
|00001730| 77 20 65 64 69 74 69 6f | 6e 73 20 6f 72 20 74 65 |w editio|ns or te|
|00001740| 63 68 6e 69 63 61 6c 20 | 6e 65 77 73 6c 65 74 74 |chnical |newslett|
|00001750| 65 72 73 2e 00 20 00 53 | 70 65 63 69 66 69 63 61 |ers.. .S|pecifica|
|00001760| 74 69 6f 6e 73 20 63 6f | 6e 74 61 69 6e 65 64 20 |tions co|ntained |
|00001770| 68 65 72 65 69 6e 20 61 | 72 65 20 73 75 62 6a 65 |herein a|re subje|
|00001780| 63 74 20 74 6f 20 63 68 | 61 6e 67 65 20 61 6e 64 |ct to ch|ange and|
|00001790| 20 74 68 65 73 65 20 63 | 68 61 6e 67 65 73 20 77 | these c|hanges w|
|000017a0| 69 6c 6c 20 62 65 20 72 | 65 70 6f 72 74 65 64 20 |ill be r|eported |
|000017b0| 69 6e 20 73 75 62 73 65 | 71 75 65 6e 74 20 72 65 |in subse|quent re|
|000017c0| 76 69 73 69 6f 6e 73 20 | 6f 72 20 65 64 69 74 69 |visions |or editi|
|000017d0| 6f 6e 73 2e 00 20 00 52 | 65 61 64 65 72 73 27 20 |ons.. .R|eaders' |
|000017e0| 63 6f 6d 6d 65 6e 74 73 | 20 61 72 65 20 77 65 6c |comments| are wel|
|000017f0| 63 6f 6d 65 64 2e 20 43 | 6f 6d 6d 65 6e 74 73 20 |comed. C|omments |
|00001800| 54 0e 00 00 b6 40 00 00 | d7 0d 00 00 6d 61 79 20 |T....@..|....may |
|00001810| 62 65 20 61 64 64 72 65 | 73 73 65 64 20 74 6f 20 |be addre|ssed to |
|00001820| 74 68 65 20 44 6f 63 75 | 6d 65 6e 74 61 74 69 6f |the Docu|mentatio|
|00001830| 6e 20 44 65 70 61 72 74 | 6d 65 6e 74 20 61 74 20 |n Depart|ment at |
|00001840| 74 68 65 20 61 64 64 72 | 65 73 73 20 6f 6e 20 74 |the addr|ess on t|
|00001850| 68 65 20 62 61 63 6b 20 | 63 6f 76 65 72 2e 00 20 |he back |cover.. |
|00001860| 00 00 d3 00 20 20 20 20 | 4e 6f 76 65 6d 62 65 72 |.... |November|
|00001870| 20 32 32 2c 20 31 39 39 | 35 2c 20 53 4f 46 54 57 | 22, 199|5, SOFTW|
|00001880| 41 52 45 20 41 47 2c 20 | 47 65 72 6d 61 6e 79 20 |ARE AG, |Germany |
|00001890| 26 20 53 4f 46 54 57 41 | 52 45 20 41 47 20 6f 66 |& SOFTWA|RE AG of|
|000018a0| 20 4e 6f 72 74 68 20 41 | 6d 65 72 69 63 61 2c 20 | North A|merica, |
|000018b0| 49 6e 63 2e 00 00 3a 00 | 00 00 16 00 00 00 54 0e |Inc...:.|......T.|
|000018c0| 00 00 f0 40 00 00 24 00 | 00 00 20 18 80 2c 00 80 |...@..$.|.. ..,..|
|000018d0| 00 00 02 00 98 80 09 00 | 82 ff 00 41 6c 6c 20 72 |........|...All r|
|000018e0| 69 67 68 74 73 20 72 65 | 73 65 72 76 65 64 00 00 |ights re|served..|
|000018f0| 41 01 00 00 1b 01 00 00 | b6 40 00 00 31 42 00 00 |A.......|.@..1B..|
|00001900| 26 00 00 00 20 1a 80 37 | 02 00 80 00 00 00 00 80 |&... ..7|........|
|00001910| 09 00 82 82 82 ff 00 50 | 72 69 6e 74 65 64 20 69 |.......P|rinted i|
|00001920| 6e 20 74 68 65 20 46 65 | 64 65 72 61 6c 20 52 65 |n the Fe|deral Re|
|00001930| 70 75 62 6c 69 63 20 6f | 66 20 47 65 72 6d 61 6e |public o|f German|
|00001940| 79 00 20 00 54 68 65 20 | 53 4f 46 54 57 41 52 45 |y. .The |SOFTWARE|
|00001950| 20 41 47 20 64 6f 63 75 | 6d 65 6e 74 61 74 69 6f | AG docu|mentatio|
|00001960| 6e 20 6f 66 74 65 6e 20 | 72 65 66 65 72 73 20 74 |n often |refers t|
|00001970| 6f 20 6e 75 6d 65 72 6f | 75 73 20 68 61 72 64 77 |o numero|us hardw|
|00001980| 61 72 65 20 61 6e 64 20 | 73 6f 66 74 77 61 72 65 |are and |software|
|00001990| 20 70 72 6f 64 75 63 74 | 73 20 62 79 20 74 68 65 | product|s by the|
|000019a0| 69 72 20 74 72 61 64 65 | 20 6e 61 6d 65 73 2e 20 |ir trade| names. |
|000019b0| 49 6e 20 6d 6f 73 74 2c | 20 69 66 20 6e 6f 74 20 |In most,| if not |
|000019c0| 61 6c 6c 20 63 61 73 65 | 73 2c 20 74 68 65 73 65 |all case|s, these|
|000019d0| 20 64 65 73 69 67 6e 61 | 74 69 6f 6e 73 20 61 72 | designa|tions ar|
|000019e0| 65 20 63 6c 61 69 6d 65 | 64 20 61 73 20 74 72 61 |e claime|d as tra|
|000019f0| 64 65 6d 61 72 6b 73 20 | 6f 72 20 72 65 67 69 73 |demarks |or regis|
|00001a00| 74 65 72 65 64 20 74 72 | 61 64 65 6d 61 72 6b 73 |tered tr|ademarks|
|00001a10| 20 62 79 20 74 68 65 69 | 72 20 72 65 73 70 65 63 | by thei|r respec|
|00001a20| 74 69 76 65 20 63 6f 6d | 70 61 6e 69 65 73 2e 00 |tive com|panies..|
|00001a30| 00 4c 00 00 00 1b 00 00 | 00 f0 40 00 00 7d 42 00 |.L......|..@..}B.|
|00001a40| 00 31 00 00 00 02 64 03 | 00 00 ff ff ff ff ff ff |.1....d.|........|
|00001a50| ff ff 02 00 00 00 7d 42 | 00 00 af 42 00 00 e2 45 |......}B|...B...E|
|00001a60| 00 00 49 6e 74 72 6f 64 | 75 63 74 69 6f 6e 20 2d |..Introd|uction -|
|00001a70| 20 49 6e 74 72 6f 64 75 | 63 74 69 6f 6e 32 00 00 | Introdu|ction2..|
|00001a80| 00 0f 00 00 00 31 42 00 | 00 af 42 00 00 23 00 00 |.....1B.|..B..#..|
|00001a90| 00 20 16 80 1e 00 80 00 | 00 00 00 80 03 00 82 ff |. ......|........|
|00001aa0| 00 49 6e 74 72 6f 64 75 | 63 74 69 6f 6e 00 00 cf |.Introdu|ction...|
|00001ab0| 00 00 00 a0 00 00 00 7d | 42 00 00 7e 43 00 00 2f |.......}|B..~C../|
|00001ac0| 00 00 00 20 2c 80 41 01 | 00 80 00 00 10 00 e3 80 |... ,.A.|........|
|00001ad0| 80 0c 00 82 80 08 00 80 | 0c 00 82 82 82 ff 00 20 |........|....... |
|00001ae0| 00 00 43 4f 4e 54 52 4f | 4c 00 20 69 73 20 75 73 |..CONTRO|L. is us|
|00001af0| 65 64 20 74 6f 20 63 6f | 6e 74 72 6f 6c 20 61 6e |ed to co|ntrol an|
|00001b00| 64 20 6d 6f 6e 69 74 6f | 72 20 74 68 65 20 41 44 |d monito|r the AD|
|00001b10| 41 42 41 53 20 73 65 72 | 76 65 72 2c 20 61 6e 64 |ABAS ser|ver, and|
|00001b20| 20 74 6f 20 65 78 65 63 | 75 74 65 20 74 68 65 20 | to exec|ute the |
|00001b30| 62 61 63 6b 75 70 20 61 | 6e 64 20 72 65 63 6f 76 |backup a|nd recov|
|00001b40| 65 72 79 20 70 72 6f 63 | 65 64 75 72 65 73 2e 00 |ery proc|edures..|
|00001b50| 20 00 43 4f 4e 54 52 4f | 4c 20 73 75 70 70 6f 72 | .CONTRO|L suppor|
|00001b60| 74 73 20 74 68 65 20 66 | 6f 6c 6c 6f 77 69 6e 67 |ts the f|ollowing|
|00001b70| 20 6f 70 65 72 61 74 69 | 6f 6e 73 3a 00 00 bd 01 | operati|ons:....|
|00001b80| 00 00 79 01 00 00 af 42 | 00 00 3b 45 00 00 44 00 |..y....B|..;E..D.|
|00001b90| 00 00 20 56 80 f3 02 00 | 80 00 00 50 02 39 81 2c |.. V....|...P.9.,|
|00001ba0| 82 39 01 80 0c 00 82 83 | 82 82 83 82 82 83 82 82 |.9......|........|
|00001bb0| 83 82 82 83 82 82 83 82 | 82 83 82 82 83 82 82 83 |........|........|
|00001bc0| 82 ff 00 20 00 2d 00 49 | 6e 73 74 61 6c 6c 69 6e |... .-.I|nstallin|
|00001bd0| 67 20 74 68 65 20 64 61 | 74 61 62 61 73 65 20 73 |g the da|tabase s|
|00001be0| 65 72 76 65 72 2c 20 00 | 20 00 2d 00 4c 6f 61 64 |erver, .| .-.Load|
|00001bf0| 69 6e 67 20 74 68 65 20 | 73 79 73 74 65 6d 20 74 |ing the |system t|
|00001c00| 61 62 6c 65 73 2c 20 00 | 20 00 2d 00 53 74 61 72 |ables, .| .-.Star|
|00001c10| 74 69 6e 67 20 61 6e 64 | 20 73 68 75 74 74 69 6e |ting and| shuttin|
|00001c20| 67 20 64 6f 77 6e 20 74 | 68 65 20 64 61 74 61 62 |g down t|he datab|
|00001c30| 61 73 65 20 73 65 72 76 | 65 72 2c 20 00 20 00 2d |ase serv|er, . .-|
|00001c40| 00 53 74 61 72 74 69 6e | 67 20 61 6e 64 20 73 68 |.Startin|g and sh|
|00001c50| 75 74 74 69 6e 67 20 64 | 6f 77 6e 20 74 68 65 20 |utting d|own the |
|00001c60| 72 65 6d 6f 74 65 20 53 | 51 4c 20 73 65 72 76 65 |remote S|QL serve|
|00001c70| 72 2c 20 00 20 00 2d 00 | 4d 6f 6e 69 74 6f 72 69 |r, . .-.|Monitori|
|00001c80| 6e 67 20 74 68 65 20 64 | 61 74 61 62 61 73 65 20 |ng the d|atabase |
|00001c90| 73 65 72 76 65 72 2c 00 | 20 00 2d 00 42 61 63 6b |server,.| .-.Back|
|00001ca0| 69 6e 67 20 75 70 20 74 | 68 65 20 64 61 74 61 62 |ing up t|he datab|
|00001cb0| 61 73 65 20 61 6e 64 20 | 6c 6f 67 2c 00 20 00 2d |ase and |log,. .-|
|00001cc0| 00 52 65 73 74 6f 72 69 | 6e 67 20 74 68 65 20 64 |.Restori|ng the d|
|00001cd0| 61 74 61 62 61 73 65 20 | 61 6e 64 20 6c 6f 67 2c |atabase |and log,|
|00001ce0| 00 20 00 2d 00 45 78 70 | 61 6e 64 69 6e 67 20 74 |. .-.Exp|anding t|
|00001cf0| 68 65 20 64 69 73 6b 20 | 63 61 70 61 63 69 74 69 |he disk |capaciti|
|00001d00| 65 73 20 6f 66 20 74 68 | 65 20 64 61 74 61 62 61 |es of th|e databa|
|00001d10| 73 65 20 73 65 72 76 65 | 72 2c 00 20 00 2d 00 52 |se serve|r,. .-.R|
|00001d20| 75 6e 6e 69 6e 67 20 74 | 68 65 20 44 69 61 67 6e |unning t|he Diagn|
|00001d30| 6f 73 65 20 74 6f 6f 6c | 2e 00 00 75 00 00 00 4f |ose tool|...u...O|
|00001d40| 00 00 00 7e 43 00 00 b0 | 45 00 00 26 00 00 00 20 |...~C...|E..&... |
|00001d50| 1c 80 9e 00 80 00 00 12 | 00 b0 e3 80 80 0c 00 82 |........|........|
|00001d60| ff 00 52 65 6d 6f 74 65 | 20 61 63 63 65 73 73 20 |..Remote| access |
|00001d70| 74 6f 20 6e 6f 6e 2d 6c | 6f 63 61 6c 20 64 61 74 |to non-l|ocal dat|
|00001d80| 61 62 61 73 65 20 73 65 | 72 76 65 72 73 20 62 79 |abase se|rvers by|
|00001d90| 20 43 4f 4e 54 52 4f 4c | 20 69 73 20 6e 6f 74 20 | CONTROL| is not |
|00001da0| 79 65 74 20 73 75 70 70 | 6f 72 74 65 64 2e 00 00 |yet supp|orted...|
|00001db0| 32 00 00 00 0a 00 00 00 | 3b 45 00 00 e2 45 00 00 |2.......|;E...E..|
|00001dc0| 28 00 00 00 20 20 80 14 | 00 80 00 00 10 00 e3 80 |(... ..|........|
|00001dd0| 80 0c 00 82 82 82 82 ff | 00 20 00 20 00 20 00 20 |........|. . . . |
|00001de0| 00 00 43 00 00 00 12 00 | 00 00 b0 45 00 00 25 46 |..C.....|...E..%F|
|00001df0| 00 00 31 00 00 00 02 c4 | 0c 00 00 ff ff ff ff 4d |..1.....|.......M|
|00001e00| 01 01 00 03 00 00 00 25 | 46 00 00 5d 46 00 00 fc |.......%|F..]F...|
|00001e10| 82 00 00 53 45 52 56 45 | 52 44 42 a0 53 74 72 75 |...SERVE|RDB.Stru|
|00001e20| 63 74 75 72 65 38 00 00 | 00 15 00 00 00 e2 45 00 |cture8..|......E.|
|00001e30| 00 5d 46 00 00 23 00 00 | 00 20 16 80 2a 00 80 00 |.]F..#..|. ..*...|
|00001e40| 00 00 00 80 03 00 82 ff | 00 53 45 52 56 45 52 44 |........|.SERVERD|
|00001e50| 42 a0 53 74 72 75 63 74 | 75 72 65 00 00 fe 01 00 |B.Struct|ure.....|
|00001e60| 00 c5 01 00 00 25 46 00 | 00 5b 48 00 00 39 00 00 |.....%F.|.[H..9..|
|00001e70| 00 20 40 80 8d 03 00 80 | 00 00 10 00 e3 80 80 0c |. @.....|........|
|00001e80| 00 82 82 82 86 22 08 80 | 02 00 00 00 00 82 82 82 |....."..|........|
|00001e90| 82 82 82 82 82 ff 00 20 | 00 4f 6e 65 20 6f 72 20 |....... |.One or |
|00001ea0| 6d 6f 72 65 20 69 6e 73 | 74 61 6e 63 65 73 20 6f |more ins|tances o|
|00001eb0| 66 20 41 44 41 42 41 53 | 20 63 61 6e 20 62 65 20 |f ADABAS| can be |
|00001ec0| 69 6e 73 74 61 6c 6c 65 | 64 20 61 6e 64 20 6f 70 |installe|d and op|
|00001ed0| 65 72 61 74 65 64 20 6f | 6e 20 61 20 63 6f 6d 70 |erated o|n a comp|
|00001ee0| 75 74 65 72 2e 20 45 61 | 63 68 20 41 44 41 42 41 |uter. Ea|ch ADABA|
|00001ef0| 53 20 69 6e 73 74 61 6e | 63 65 20 69 73 20 63 61 |S instan|ce is ca|
|00001f00| 6c 6c 65 64 20 61 20 53 | 45 52 56 45 52 44 42 20 |lled a S|ERVERDB |
|00001f10| 61 6e 64 20 68 61 73 20 | 74 68 65 20 66 6f 6c 6c |and has |the foll|
|00001f20| 6f 77 69 6e 67 20 73 74 | 72 75 63 74 75 72 65 3a |owing st|ructure:|
|00001f30| 00 20 00 00 00 54 68 65 | 20 74 65 72 6d 20 22 64 |. ...The| term "d|
|00001f40| 65 76 73 70 61 63 65 22 | 20 64 65 6e 6f 74 65 73 |evspace"| denotes|
|00001f50| 20 61 20 70 68 79 73 69 | 63 61 6c 20 64 69 73 6b | a physi|cal disk|
|00001f60| 20 6f 72 20 70 61 72 74 | 20 6f 66 20 61 20 70 68 | or part| of a ph|
|00001f70| 79 73 69 63 61 6c 20 64 | 69 73 6b 2c 20 65 2e 67 |ysical d|isk, e.g|
|00001f80| 2e 2c 20 61 20 55 4e 49 | 58 20 72 61 77 20 64 65 |., a UNI|X raw de|
|00001f90| 76 69 63 65 20 6f 72 20 | 61 20 66 69 6c 65 2e 00 |vice or |a file..|
|00001fa0| 20 00 41 44 41 42 41 53 | 20 61 73 73 75 6d 65 73 | .ADABAS| assumes|
|00001fb0| 20 74 68 61 74 20 65 61 | 63 68 20 64 65 76 73 70 | that ea|ch devsp|
|00001fc0| 61 63 65 20 69 73 20 6c | 6f 63 61 74 65 64 20 6f |ace is l|ocated o|
|00001fd0| 6e 20 61 20 64 69 66 66 | 65 72 65 6e 74 20 64 69 |n a diff|erent di|
|00001fe0| 73 6b 2e 20 49 66 20 74 | 68 69 73 20 69 73 20 6e |sk. If t|his is n|
|00001ff0| 6f 74 20 74 72 75 65 2c | 20 64 65 63 72 65 61 73 |ot true,| decreas|
|00002000| 65 64 20 70 65 72 66 6f | 72 6d 61 6e 63 65 20 69 |ed perfo|rmance i|
|00002010| 73 20 74 6f 20 62 65 20 | 65 78 70 65 63 74 65 64 |s to be |expected|
|00002020| 2e 00 20 00 20 00 54 68 | 65 20 41 44 41 42 41 53 |.. . .Th|e ADABAS|
|00002030| 20 64 65 76 73 70 61 63 | 65 73 20 68 61 76 65 20 | devspac|es have |
|00002040| 74 68 65 20 66 6f 6c 6c | 6f 77 69 6e 67 20 6d 65 |the foll|owing me|
|00002050| 61 6e 69 6e 67 73 3a 00 | 20 00 00 12 01 00 00 e6 |anings:.| .......|
|00002060| 00 00 00 5d 46 00 00 6d | 49 00 00 2c 00 00 00 20 |...]F..m|I..,... |
|00002070| 26 80 cd 01 00 80 00 00 | 50 02 1b 83 cb 7d 82 1b |&.......|P....}..|
|00002080| 03 80 0c 00 83 82 ff 00 | 53 79 73 74 65 6d 20 44 |........|System D|
|00002090| 65 76 73 70 61 63 65 3a | 00 54 68 65 20 63 6f 6e |evspace:|.The con|
|000020a0| 66 69 67 75 72 61 74 69 | 6f 6e 20 64 61 74 61 20 |figurati|on data |
|000020b0| 61 6e 64 20 74 68 65 20 | 6d 61 70 70 69 6e 67 73 |and the |mappings|
|000020c0| 20 6f 66 20 74 68 65 20 | 6c 6f 67 69 63 61 6c 20 | of the |logical |
|000020d0| 70 61 67 65 20 6e 75 6d | 62 65 72 73 20 74 6f 20 |page num|bers to |
|000020e0| 70 68 79 73 69 63 61 6c | 20 70 61 67 65 20 61 64 |physical| page ad|
|000020f0| 64 72 65 73 73 65 73 20 | 61 72 65 20 61 64 6d 69 |dresses |are admi|
|00002100| 6e 69 73 74 65 72 65 64 | 20 6f 6e 20 74 68 69 73 |nistered| on this|
|00002110| 20 64 65 76 73 70 61 63 | 65 2e 20 54 68 65 20 73 | devspac|e. The s|
|00002120| 69 7a 65 20 6f 66 20 74 | 68 65 20 73 79 73 74 65 |ize of t|he syste|
|00002130| 6d 20 64 65 76 73 70 61 | 63 65 20 74 68 65 72 65 |m devspa|ce there|
|00002140| 66 6f 72 65 20 64 65 70 | 65 6e 64 73 20 64 69 72 |fore dep|ends dir|
|00002150| 65 63 74 6c 79 20 6f 6e | 20 74 68 65 20 64 61 74 |ectly on| the dat|
|00002160| 61 62 61 73 65 20 73 69 | 7a 65 2e 00 00 2b 00 00 |abase si|ze...+..|
|00002170| 00 04 00 00 00 5b 48 00 | 00 98 49 00 00 27 00 00 |.....[H.|..I..'..|
|00002180| 00 20 1e 80 08 00 80 00 | 00 50 00 1b 83 cb 7d 80 |. ......|.P....}.|
|00002190| 0c 00 82 ff 00 20 00 00 | 64 03 00 00 35 03 00 00 |..... ..|d...5...|
|000021a0| 6d 49 00 00 fc 4c 00 00 | 2f 00 00 00 20 2c 80 6b |mI...L..|/... ,.k|
|000021b0| 06 00 80 00 00 50 02 1b | 83 cb 7d 82 1b 03 80 0c |.....P..|..}.....|
|000021c0| 00 83 82 82 83 82 ff 00 | 54 72 61 6e 73 61 63 74 |........|Transact|
|000021d0| 69 6f 6e 20 4c 6f 67 20 | 44 65 76 73 70 61 63 65 |ion Log |Devspace|
|000021e0| 3a 00 4d 6f 64 69 66 69 | 63 61 74 69 6f 6e 73 20 |:.Modifi|cations |
|000021f0| 74 6f 20 74 68 65 20 64 | 61 74 61 20 61 72 65 20 |to the d|ata are |
|00002200| 72 65 63 6f 72 64 65 64 | 20 69 6e 20 74 68 69 73 |recorded| in this|
|00002210| 20 6c 6f 67 20 61 6e 64 | 20 77 72 69 74 74 65 6e | log and| written|
|00002220| 20 74 6f 20 64 69 73 6b | 20 61 74 20 74 68 65 20 | to disk| at the |
|00002230| 65 6e 64 20 6f 66 20 74 | 68 65 20 74 72 61 6e 73 |end of t|he trans|
|00002240| 61 63 74 69 6f 6e 2e 20 | 54 68 65 20 74 72 61 6e |action. |The tran|
|00002250| 73 61 63 74 69 6f 6e 20 | 6c 6f 67 20 63 61 6e 20 |saction |log can |
|00002260| 62 65 20 75 73 65 64 20 | 74 6f 20 52 4f 4c 4c 42 |be used |to ROLLB|
|00002270| 41 43 4b 20 74 72 61 6e | 73 61 63 74 69 6f 6e 73 |ACK tran|sactions|
|00002280| 20 61 6e 64 20 69 73 20 | 77 72 69 74 74 65 6e 20 | and is |written |
|00002290| 63 79 63 6c 69 63 61 6c | 6c 79 2e 20 49 74 73 20 |cyclical|ly. Its |
|000022a0| 73 69 7a 65 20 6d 75 73 | 74 20 62 65 20 73 75 66 |size mus|t be suf|
|000022b0| 66 69 63 69 65 6e 74 20 | 74 6f 20 72 65 63 65 69 |ficient |to recei|
|000022c0| 76 65 20 74 68 65 20 6d | 6f 64 69 66 69 63 61 74 |ve the m|odificat|
|000022d0| 69 6f 6e 73 20 6f 66 20 | 61 6c 6c 20 6f 70 65 6e |ions of |all open|
|000022e0| 20 74 72 61 6e 73 61 63 | 74 69 6f 6e 73 2e 20 00 | transac|tions. .|
|000022f0| 20 00 41 72 63 68 69 76 | 65 20 4c 6f 67 20 44 65 | .Archiv|e Log De|
|00002300| 76 73 70 61 63 65 73 3a | 00 54 6f 20 65 6e 73 75 |vspaces:|.To ensu|
|00002310| 72 65 20 74 68 65 20 72 | 65 63 6f 76 65 72 79 20 |re the r|ecovery |
|00002320| 6f 66 20 74 68 65 20 64 | 61 74 61 62 61 73 65 20 |of the d|atabase |
|00002330| 63 6f 6e 74 65 6e 74 73 | 20 61 66 74 65 72 20 61 |contents| after a|
|00002340| 20 6d 65 64 69 61 20 66 | 61 69 6c 75 72 65 2c 20 | media f|ailure, |
|00002350| 61 6c 6c 20 6d 6f 64 69 | 66 69 63 61 74 69 6f 6e |all modi|fication|
|00002360| 73 20 6d 61 64 65 20 74 | 6f 20 74 68 65 20 64 61 |s made t|o the da|
|00002370| 74 61 62 61 73 65 20 63 | 6f 6e 74 65 6e 74 73 20 |tabase c|ontents |
|00002380| 61 72 65 20 72 65 63 6f | 72 64 65 64 20 69 6e 20 |are reco|rded in |
|00002390| 74 68 65 20 61 72 63 68 | 69 76 65 20 6c 6f 67 20 |the arch|ive log |
|000023a0| 64 65 76 73 70 61 63 65 | 2e 20 55 73 69 6e 67 20 |devspace|. Using |
|000023b0| 74 68 65 20 62 61 63 6b | 75 70 20 66 75 6e 63 74 |the back|up funct|
|000023c0| 69 6f 6e 73 20 28 53 41 | 56 45 20 4c 4f 47 2c 20 |ions (SA|VE LOG, |
|000023d0| 53 41 56 45 20 4c 4f 47 | 20 53 45 47 4d 45 4e 54 |SAVE LOG| SEGMENT|
|000023e0| 29 2c 20 74 68 65 20 63 | 6f 6e 74 65 6e 74 73 20 |), the c|ontents |
|000023f0| 6f 66 20 74 68 65 20 61 | 72 63 68 69 76 65 20 6c |of the a|rchive l|
|00002400| 6f 67 20 64 65 76 73 70 | 61 63 65 20 61 72 65 20 |og devsp|ace are |
|00002410| 73 61 76 65 64 20 74 6f | 20 74 61 70 65 20 28 44 |saved to| tape (D|
|00002420| 41 54 2c 20 56 69 64 65 | 6f 38 29 20 61 6e 64 20 |AT, Vide|o8) and |
|00002430| 74 68 65 20 75 73 65 64 | 20 73 70 61 63 65 20 69 |the used| space i|
|00002440| 73 20 74 68 65 6e 20 72 | 65 6c 65 61 73 65 64 2e |s then r|eleased.|
|00002450| 20 54 68 65 20 73 69 7a | 65 20 6f 66 20 61 72 63 | The siz|e of arc|
|00002460| 68 69 76 65 20 6c 6f 67 | 20 64 65 76 73 70 61 63 |hive log| devspac|
|00002470| 65 20 6d 75 73 74 20 74 | 68 65 72 65 66 6f 72 65 |e must t|herefore|
|00002480| 20 62 65 20 73 75 66 66 | 69 63 69 65 6e 74 20 74 | be suff|icient t|
|00002490| 6f 20 72 65 63 65 69 76 | 65 20 61 6c 6c 20 6d 6f |o receiv|e all mo|
|000024a0| 64 69 66 69 63 61 74 69 | 6f 6e 73 20 74 68 61 74 |dificati|ons that|
|000024b0| 20 6f 63 63 75 72 20 64 | 75 72 69 6e 67 20 74 77 | occur d|uring tw|
|000024c0| 6f 20 62 61 63 6b 75 70 | 73 2e 20 54 68 65 20 61 |o backup|s. The a|
|000024d0| 72 63 68 69 76 65 20 6c | 6f 67 20 63 61 6e 20 63 |rchive l|og can c|
|000024e0| 6f 6d 70 72 69 73 65 20 | 73 65 76 65 72 61 6c 20 |omprise |several |
|000024f0| 64 65 76 73 70 61 63 65 | 73 2e 00 00 2b 00 00 00 |devspace|s...+...|
|00002500| 04 00 00 00 98 49 00 00 | 27 4d 00 00 27 00 00 00 |.....I..|'M..'...|
|00002510| 20 1e 80 08 00 80 00 00 | 50 00 1b 83 cb 7d 80 0c | .......|P....}..|
|00002520| 00 82 ff 00 20 00 00 79 | 01 00 00 4d 01 00 00 fc |.... ..y|...M....|
|00002530| 4c 00 00 a0 4e 00 00 2c | 00 00 00 20 26 80 9b 02 |L...N..,|... &...|
|00002540| 00 80 00 00 50 02 1b 83 | cb 7d 82 1b 03 80 0c 00 |....P...|.}......|
|00002550| 83 82 ff 00 44 61 74 61 | 20 44 65 76 73 70 61 63 |....Data| Devspac|
|00002560| 65 73 3a 00 54 68 65 20 | 75 73 65 72 20 64 61 74 |es:.The |user dat|
|00002570| 61 20 28 74 61 62 6c 65 | 73 2c 20 69 6e 64 65 78 |a (table|s, index|
|00002580| 65 73 29 20 61 6e 64 20 | 74 68 65 20 53 51 4c 20 |es) and |the SQL |
|00002590| 63 61 74 61 6c 6f 67 20 | 28 73 63 68 65 6d 61 20 |catalog |(schema |
|000025a0| 69 6e 66 6f 72 6d 61 74 | 69 6f 6e 29 20 61 72 65 |informat|ion) are|
|000025b0| 20 73 74 6f 72 65 64 20 | 69 6e 20 74 68 65 20 64 | stored |in the d|
|000025c0| 61 74 61 20 64 65 76 73 | 70 61 63 65 73 2e 20 41 |ata devs|paces. A|
|000025d0| 73 20 61 20 72 75 6c 65 | 2c 20 61 6e 20 41 44 41 |s a rule|, an ADA|
|000025e0| 42 41 53 2d 69 6e 74 65 | 72 6e 61 6c 20 73 74 72 |BAS-inte|rnal str|
|000025f0| 69 70 69 6e 67 20 61 6c | 67 6f 72 69 74 68 6d 20 |iping al|gorithm |
|00002600| 65 76 65 6e 6c 79 20 64 | 69 73 74 72 69 62 75 74 |evenly d|istribut|
|00002610| 65 73 20 74 68 65 20 64 | 61 74 61 20 62 65 6c 6f |es the d|ata belo|
|00002620| 6e 67 69 6e 67 20 74 6f | 20 61 20 74 61 62 6c 65 |nging to| a table|
|00002630| 20 61 63 72 6f 73 73 20 | 61 6c 6c 20 64 61 74 61 | across |all data|
|00002640| 20 64 65 76 73 70 61 63 | 65 73 2e 20 54 68 65 20 | devspac|es. The |
|00002650| 73 74 6f 72 61 67 65 20 | 73 70 61 63 65 20 64 65 |storage |space de|
|00002660| 66 69 6e 65 64 20 62 79 | 20 61 6c 6c 20 64 61 74 |fined by| all dat|
|00002670| 61 20 64 65 76 73 70 61 | 63 65 73 20 69 73 20 74 |a devspa|ces is t|
|00002680| 68 65 20 74 6f 74 61 6c | 20 73 69 7a 65 20 6f 66 |he total| size of|
|00002690| 20 74 68 65 20 64 61 74 | 61 62 61 73 65 2e 00 00 | the dat|abase...|
|000026a0| dc 02 00 00 b3 02 00 00 | 27 4d 00 00 88 81 00 00 |........|'M......|
|000026b0| 29 00 00 00 20 20 80 67 | 05 00 80 00 00 10 00 e3 |)... .g|........|
|000026c0| 80 80 0c 00 82 82 82 82 | ff 00 20 00 54 68 65 20 |........|.. .The |
|000026d0| 64 61 74 61 20 64 65 76 | 73 70 61 63 65 73 20 61 |data dev|spaces a|
|000026e0| 72 65 20 6e 6f 74 20 64 | 69 72 65 63 74 6c 79 20 |re not d|irectly |
|000026f0| 72 65 6c 61 74 65 64 20 | 74 6f 20 74 68 65 20 73 |related |to the s|
|00002700| 74 6f 72 61 67 65 20 6f | 66 20 64 61 74 61 62 61 |torage o|f databa|
|00002710| 73 65 20 6f 62 6a 65 63 | 74 73 2e 20 41 6e 20 61 |se objec|ts. An a|
|00002720| 73 73 69 67 6e 6d 65 6e | 74 20 6f 66 20 74 61 62 |ssignmen|t of tab|
|00002730| 6c 65 73 20 74 6f 20 64 | 61 74 61 20 64 65 76 73 |les to d|ata devs|
|00002740| 70 61 63 65 73 20 69 73 | 20 6e 6f 74 20 70 6f 73 |paces is| not pos|
|00002750| 73 69 62 6c 65 20 61 6e | 64 20 6e 6f 74 20 6e 65 |sible an|d not ne|
|00002760| 63 65 73 73 61 72 79 2e | 20 41 20 74 61 62 6c 65 |cessary.| A table|
|00002770| 20 6f 72 20 61 6e 20 69 | 6e 64 65 78 20 63 61 6e | or an i|ndex can|
|00002780| 20 75 73 65 20 6f 6e 65 | 20 70 61 67 65 20 28 34 | use one| page (4|
|00002790| 20 4b 42 29 20 61 73 20 | 61 20 6d 69 6e 69 6d 75 | KB) as |a minimu|
|000027a0| 6d 3b 20 6f 72 20 61 20 | 74 61 62 6c 65 20 63 61 |m; or a |table ca|
|000027b0| 6e 20 75 73 65 20 61 6c | 6c 20 64 61 74 61 20 64 |n use al|l data d|
|000027c0| 65 76 73 70 61 63 65 73 | 20 28 69 2e 65 2e 2c 20 |evspaces| (i.e., |
|000027d0| 74 68 65 20 77 68 6f 6c | 65 20 64 61 74 61 62 61 |the whol|e databa|
|000027e0| 73 65 29 20 61 73 20 61 | 20 6d 61 78 69 6d 75 6d |se) as a| maximum|
|000027f0| 2e 20 41 20 74 61 62 6c | 65 20 69 6e 63 72 65 61 |. A tabl|e increa|
|00002800| a0 4e 00 00 88 81 00 00 | e2 45 00 00 73 65 73 20 |.N......|.E..ses |
|00002810| 6f 72 20 64 65 63 72 65 | 61 73 65 73 20 69 6e 20 |or decre|ases in |
|00002820| 73 69 7a 65 20 61 75 74 | 6f 6d 61 74 69 63 61 6c |size aut|omatical|
|00002830| 6c 79 20 77 69 74 68 6f | 75 74 20 61 64 6d 69 6e |ly witho|ut admin|
|00002840| 69 73 74 72 61 74 69 76 | 65 20 69 6e 74 65 72 76 |istrativ|e interv|
|00002850| 65 6e 74 69 6f 6e 2e 00 | 20 00 54 6f 20 6f 62 74 |ention..| .To obt|
|00002860| 61 69 6e 20 61 20 68 69 | 67 68 65 72 20 64 65 67 |ain a hi|gher deg|
|00002870| 72 65 65 20 6f 66 20 61 | 76 61 69 6c 61 62 69 6c |ree of a|vailabil|
|00002880| 69 74 79 2c 20 74 68 65 | 20 73 79 73 74 65 6d 20 |ity, the| system |
|00002890| 64 65 76 73 70 61 63 65 | 20 61 6e 64 20 61 6c 6c |devspace| and all|
|000028a0| 20 64 61 74 61 20 64 65 | 76 73 70 61 63 65 73 20 | data de|vspaces |
|000028b0| 6f 66 20 61 20 53 45 52 | 56 45 52 44 42 20 63 61 |of a SER|VERDB ca|
|000028c0| 6e 20 62 65 20 6d 69 72 | 72 6f 72 65 64 2e 20 57 |n be mir|rored. W|
|000028d0| 72 69 74 65 20 6f 70 65 | 72 61 74 69 6f 6e 73 20 |rite ope|rations |
|000028e0| 61 72 65 20 70 65 72 66 | 6f 72 6d 65 64 20 6f 6e |are perf|ormed on|
|000028f0| 20 65 61 63 68 20 6f 66 | 20 74 68 65 20 74 77 6f | each of| the two|
|00002900| 20 6d 69 72 72 6f 72 65 | 64 20 64 61 74 61 20 64 | mirrore|d data d|
|00002910| 65 76 73 70 61 63 65 73 | 2c 20 77 68 69 6c 65 20 |evspaces|, while |
|00002920| 72 65 61 64 20 6f 70 65 | 72 61 74 69 6f 6e 73 20 |read ope|rations |
|00002930| 61 6c 74 65 72 6e 61 74 | 65 20 62 65 74 77 65 65 |alternat|e betwee|
|00002940| 6e 20 6f 6e 65 20 6d 69 | 72 72 6f 72 65 64 20 64 |n one mi|rrored d|
|00002950| 61 74 61 20 64 65 76 73 | 70 61 63 65 20 61 6e 64 |ata devs|pace and|
|00002960| 20 74 68 65 20 6f 74 68 | 65 72 20 74 6f 20 64 69 | the oth|er to di|
|00002970| 73 74 72 69 62 75 74 65 | 20 74 68 65 20 49 2f 4f |stribute| the I/O|
|00002980| 20 6c 6f 61 64 2e 00 00 | 74 01 00 00 4d 01 00 00 | load...|t...M...|
|00002990| a0 4e 00 00 fc 82 00 00 | 27 00 00 00 20 1c 80 9b |.N......|'... ...|
|000029a0| 02 00 80 00 00 10 00 e3 | 80 80 0c 00 82 82 ff 00 |........|........|
|000029b0| 20 00 49 66 20 74 68 65 | 20 64 61 74 61 20 64 65 | .If the| data de|
|000029c0| 76 73 70 61 63 65 73 20 | 62 65 63 6f 6d 65 20 66 |vspaces |become f|
|000029d0| 75 6c 6c 2c 20 64 61 74 | 61 62 61 73 65 20 6f 70 |ull, dat|abase op|
|000029e0| 65 72 61 74 69 6f 6e 20 | 73 74 6f 70 73 20 61 6e |eration |stops an|
|000029f0| 64 20 41 44 41 42 41 53 | 20 70 65 72 66 6f 72 6d |d ADABAS| perform|
|00002a00| 73 20 61 6e 20 22 65 6d | 65 72 67 65 6e 63 79 20 |s an "em|ergency |
|00002a10| 73 68 75 74 64 6f 77 6e | 22 2e 20 54 68 65 20 64 |shutdown|". The d|
|00002a20| 65 76 73 70 61 63 65 20 | 75 73 61 67 65 20 6c 65 |evspace |usage le|
|00002a30| 76 65 6c 20 6f 66 20 61 | 20 53 45 52 56 45 52 44 |vel of a| SERVERD|
|00002a40| 42 20 69 73 20 74 68 65 | 72 65 66 6f 72 65 20 61 |B is the|refore a|
|00002a50| 20 63 72 69 74 69 63 61 | 6c 20 70 61 72 61 6d 65 | critica|l parame|
|00002a60| 74 65 72 20 6f 66 20 64 | 61 74 61 62 61 73 65 20 |ter of d|atabase |
|00002a70| 6f 70 65 72 61 74 69 6f | 6e 20 61 6e 64 20 6d 75 |operatio|n and mu|
|00002a80| 73 74 20 62 65 20 6d 6f | 6e 69 74 6f 72 65 64 2e |st be mo|nitored.|
|00002a90| 20 41 20 53 45 52 56 45 | 52 44 42 20 63 61 6e 20 | A SERVE|RDB can |
|00002aa0| 62 65 20 65 78 70 61 6e | 64 65 64 20 62 79 20 61 |be expan|ded by a|
|00002ab0| 64 64 69 74 69 6f 6e 61 | 6c 20 64 61 74 61 20 64 |dditiona|l data d|
|00002ac0| 65 76 73 70 61 63 65 73 | 2c 20 69 66 20 6e 65 63 |evspaces|, if nec|
|00002ad0| 65 73 73 61 72 79 2c 20 | 77 68 69 6c 65 20 74 68 |essary, |while th|
|00002ae0| 65 20 64 61 74 61 62 61 | 73 65 20 69 73 20 6f 70 |e databa|se is op|
|00002af0| 65 72 61 74 69 6f 6e 61 | 6c 2e 00 00 38 00 00 00 |erationa|l...8...|
|00002b00| 07 00 00 00 88 81 00 00 | 34 83 00 00 31 00 00 00 |........|4...1...|
|00002b10| 02 6e 0d 00 00 b2 83 00 | 00 66 80 01 00 04 00 00 |.n......|.f......|
|00002b20| 00 34 83 00 00 61 83 00 | 00 aa c0 00 00 4c 6f 67 |.4...a..|.....Log|
|00002b30| 67 69 6e 67 2d 00 00 00 | 0a 00 00 00 fc 82 00 00 |ging-...|........|
|00002b40| 61 83 00 00 23 00 00 00 | 20 16 80 14 00 80 00 00 |a...#...| .......|
|00002b50| 00 00 80 03 00 82 ff 00 | 4c 6f 67 67 69 6e 67 00 |........|Logging.|
|00002b60| 00 fe 00 00 00 d6 00 00 | 00 34 83 00 00 5f 84 00 |........|.4..._..|
|00002b70| 00 28 00 00 00 20 1e 80 | ad 01 00 80 00 00 10 00 |.(... ..|........|
|00002b80| e3 80 80 0c 00 82 82 82 | ff 00 20 00 54 6f 20 6d |........|.. .To m|
|00002b90| 65 65 74 20 64 69 66 66 | 65 72 65 6e 74 20 64 61 |eet diff|erent da|
|00002ba0| 74 61 20 70 72 6f 74 65 | 63 74 69 6f 6e 20 61 6e |ta prote|ction an|
|00002bb0| 64 20 63 6f 6d 70 75 74 | 65 72 20 63 6f 6e 66 69 |d comput|er confi|
|00002bc0| 67 75 72 61 74 69 6f 6e | 20 72 65 71 75 69 72 65 |guration| require|
|00002bd0| 6d 65 6e 74 73 2c 20 41 | 44 41 42 41 53 20 70 72 |ments, A|DABAS pr|
|00002be0| 6f 76 69 64 65 73 20 61 | 20 67 72 61 64 75 61 6c |ovides a| gradual|
|00002bf0| 20 6c 6f 67 67 69 6e 67 | 20 63 6f 6e 63 65 70 74 | logging| concept|
|00002c00| 2e 20 54 68 65 20 63 6f | 6e 66 69 67 75 72 61 74 |. The co|nfigurat|
|00002c10| 69 6f 6e 20 70 61 72 61 | 6d 65 74 65 72 20 4c 4f |ion para|meter LO|
|00002c20| 47 20 4d 4f 44 45 20 63 | 61 6e 20 62 65 20 75 73 |G MODE c|an be us|
|00002c30| 65 64 20 74 6f 20 73 65 | 6c 65 63 74 20 6f 6e 65 |ed to se|lect one|
|00002c40| 20 6f 66 20 74 68 65 20 | 66 6f 6c 6c 6f 77 69 6e | of the |followin|
|00002c50| 67 20 76 61 72 69 61 6e | 74 73 3a 00 20 00 00 b4 |g varian|ts:. ...|
|00002c60| 01 00 00 88 01 00 00 61 | 83 00 00 13 86 00 00 2c |.......a|.......,|
|00002c70| 00 00 00 20 26 80 11 03 | 00 80 00 00 50 02 a9 82 |... &...|....P...|
|00002c80| 3d 7e 82 a9 02 80 0c 00 | 83 82 ff 00 4e 4f 52 4d |=~......|....NORM|
|00002c90| 41 4c 3a 00 54 68 69 73 | 20 6c 6f 67 20 6d 6f 64 |AL:.This| log mod|
|00002ca0| 65 20 69 73 20 74 68 65 | 20 72 65 63 6f 6d 6d 65 |e is the| recomme|
|00002cb0| 6e 64 65 64 20 64 65 66 | 61 75 6c 74 20 6d 6f 64 |nded def|ault mod|
|00002cc0| 65 2e 20 49 74 20 72 65 | 71 75 69 72 65 73 20 61 |e. It re|quires a|
|00002cd0| 74 20 6c 65 61 73 74 20 | 6f 6e 65 20 61 72 63 68 |t least |one arch|
|00002ce0| 69 76 65 20 6c 6f 67 20 | 64 65 76 73 70 61 63 65 |ive log |devspace|
|00002cf0| 20 69 6e 20 61 64 64 69 | 74 69 6f 6e 20 74 6f 20 | in addi|tion to |
|00002d00| 74 68 65 20 74 72 61 6e | 73 61 63 74 69 6f 6e 20 |the tran|saction |
|00002d10| 6c 6f 67 20 64 65 76 73 | 70 61 63 65 2e 20 54 68 |log devs|pace. Th|
|00002d20| 65 20 61 72 63 68 69 76 | 65 20 6c 6f 67 20 64 65 |e archiv|e log de|
|00002d30| 76 73 70 61 63 65 28 73 | 29 20 6d 75 73 74 20 62 |vspace(s|) must b|
|00002d40| 65 20 6c 6f 63 61 74 65 | 64 20 6f 6e 20 64 69 73 |e locate|d on dis|
|00002d50| 6b 73 20 64 69 66 66 65 | 72 65 6e 74 20 66 72 6f |ks diffe|rent fro|
|00002d60| 6d 20 61 6c 6c 20 74 68 | 65 20 6f 74 68 65 72 20 |m all th|e other |
|00002d70| 64 65 76 73 70 61 63 65 | 73 20 28 73 79 73 74 65 |devspace|s (syste|
|00002d80| 6d 20 64 65 76 73 70 61 | 63 65 2c 20 74 72 61 6e |m devspa|ce, tran|
|00002d90| 73 61 63 74 69 6f 6e 20 | 6c 6f 67 20 64 65 76 73 |saction |log devs|
|00002da0| 70 61 63 65 2c 20 64 61 | 74 61 20 64 65 76 73 70 |pace, da|ta devsp|
|00002db0| 61 63 65 73 29 2e 20 41 | 20 6d 69 6e 69 6d 75 6d |aces). A| minimum|
|00002dc0| 20 63 6f 6e 66 69 67 75 | 72 61 74 69 6f 6e 20 66 | configu|ration f|
|00002dd0| 6f 72 20 74 68 69 73 20 | 6c 6f 67 20 6d 6f 64 65 |or this |log mode|
|00002de0| 20 74 68 65 72 65 66 6f | 72 65 20 72 65 71 75 69 | therefo|re requi|
|00002df0| 72 65 73 20 61 74 20 6c | 65 61 73 74 20 32 20 28 |res at l|east 2 (|
|00002e00| 70 68 79 73 69 63 61 6c | 29 20 64 69 73 6b 73 2e |physical|) disks.|
|00002e10| 20 00 00 2b 00 00 00 04 | 00 00 00 5f 84 00 00 3e | ..+....|..._...>|
|00002e20| 86 00 00 27 00 00 00 20 | 1e 80 08 00 80 00 00 50 |...'... |.......P|
|00002e30| 00 a9 82 3d 7e 80 0c 00 | 82 ff 00 20 00 00 2d 02 |...=~...|... ..-.|
|00002e40| 00 00 01 02 00 00 13 86 | 00 00 6b 88 00 00 2c 00 |........|..k...,.|
|00002e50| 00 00 20 26 80 03 04 00 | 80 00 00 50 02 a9 82 3d |.. &....|...P...=|
|00002e60| 7e 82 a9 02 80 0c 00 83 | 82 ff 00 44 55 41 4c 3a |~.......|...DUAL:|
|00002e70| 00 46 6f 72 20 61 20 73 | 74 69 6c 6c 20 68 69 67 |.For a s|till hig|
|00002e80| 68 65 72 20 64 65 67 72 | 65 65 20 6f 66 20 64 61 |her degr|ee of da|
|00002e90| 74 61 20 70 72 6f 74 65 | 63 74 69 6f 6e 20 72 65 |ta prote|ction re|
|00002ea0| 71 75 69 72 65 6d 65 6e | 74 73 2c 20 74 68 65 20 |quiremen|ts, the |
|00002eb0| 61 72 63 68 69 76 65 20 | 6c 6f 67 20 63 61 6e 20 |archive |log can |
|00002ec0| 62 65 20 64 6f 75 62 6c | 65 64 2c 20 72 65 71 75 |be doubl|ed, requ|
|00002ed0| 69 72 69 6e 67 20 61 74 | 20 6c 65 61 73 74 20 6f |iring at| least o|
|00002ee0| 6e 65 20 6d 6f 72 65 20 | 64 65 76 73 70 61 63 65 |ne more |devspace|
|00002ef0| 20 74 6f 20 6d 69 72 72 | 6f 72 20 74 68 65 20 61 | to mirr|or the a|
|00002f00| 72 63 68 69 76 65 20 6c | 6f 67 2e 20 54 68 65 20 |rchive l|og. The |
|00002f10| 6d 69 6e 69 6d 75 6d 20 | 63 6f 6e 66 69 67 75 72 |minimum |configur|
|00002f20| 61 74 69 6f 6e 20 66 6f | 72 20 74 68 69 73 20 6c |ation fo|r this l|
|00002f30| 6f 67 20 6d 6f 64 65 20 | 74 68 75 73 20 63 6f 6d |og mode |thus com|
|00002f40| 70 72 69 73 65 73 20 61 | 74 20 6c 65 61 73 74 20 |prises a|t least |
|00002f50| 33 20 64 69 73 6b 73 2e | 20 54 68 69 73 20 63 6f |3 disks.| This co|
|00002f60| 6e 66 69 67 75 72 61 74 | 69 6f 6e 20 68 61 73 20 |nfigurat|ion has |
|00002f70| 74 68 65 20 66 6f 6c 6c | 6f 77 69 6e 67 20 61 64 |the foll|owing ad|
|00002f80| 76 61 6e 74 61 67 65 73 | 3a 20 61 20 66 61 69 6c |vantages|: a fail|
|00002f90| 75 72 65 20 6f 66 20 74 | 68 65 20 74 72 61 6e 73 |ure of t|he trans|
|00002fa0| 61 63 74 69 6f 6e 20 6c | 6f 67 20 64 65 76 73 70 |action l|og devsp|
|00002fb0| 61 63 65 20 6f 72 20 6f | 66 20 6f 6e 65 20 6f 66 |ace or o|f one of|
|00002fc0| 20 74 68 65 20 61 72 63 | 68 69 76 65 20 6c 6f 67 | the arc|hive log|
|00002fd0| 20 64 65 76 73 70 61 63 | 65 73 20 64 6f 65 73 20 | devspac|es does |
|00002fe0| 6e 6f 74 20 69 6e 74 65 | 72 72 75 70 74 20 64 61 |not inte|rrupt da|
|00002ff0| 74 61 62 61 73 65 20 6f | 70 65 72 61 74 69 6f 6e |tabase o|peration|
|00003000| 2c 20 61 6e 64 20 6f 6e | 63 65 20 74 68 65 20 64 |, and on|ce the d|
|00003010| 65 66 65 63 74 69 76 65 | 20 64 65 76 73 70 61 63 |efective| devspac|
|00003020| 65 20 68 61 73 20 62 65 | 65 6e 20 72 65 70 61 69 |e has be|en repai|
|00003030| 72 65 64 2c 20 69 74 20 | 63 61 6e 20 62 65 20 75 |red, it |can be u|
|00003040| 70 64 61 74 65 64 20 77 | 68 69 6c 65 20 74 68 65 |pdated w|hile the|
|00003050| 20 64 61 74 61 62 61 73 | 65 20 69 73 20 6f 70 65 | databas|e is ope|
|00003060| 72 61 74 69 6f 6e 61 6c | 2e 00 00 d4 00 00 00 ab |rational|........|
|00003070| 00 00 00 3e 86 00 00 3f | 89 00 00 29 00 00 00 20 |...>...?|...)... |
|00003080| 20 80 57 01 00 80 00 00 | 10 00 e3 80 80 0c 00 82 | .W.....|........|
|00003090| 82 82 82 ff 00 20 00 20 | 00 54 68 65 20 6c 6f 67 |..... . |.The log|
|000030a0| 20 6d 6f 64 65 73 20 53 | 49 4e 47 4c 45 20 61 6e | modes S|INGLE an|
|000030b0| 64 20 44 45 4d 4f 20 61 | 72 65 20 6e 6f 74 20 69 |d DEMO a|re not i|
|000030c0| 6e 74 65 6e 64 65 64 20 | 66 6f 72 20 70 72 6f 64 |ntended |for prod|
|000030d0| 75 63 74 69 6f 6e 20 65 | 6e 76 69 72 6f 6e 6d 65 |uction e|nvironme|
|000030e0| 6e 74 73 20 62 75 74 20 | 66 6f 72 20 74 65 73 74 |nts but |for test|
|000030f0| 20 61 6e 64 20 64 65 6d | 6f 6e 73 74 72 61 74 69 | and dem|onstrati|
|00003100| 6f 6e 20 70 75 72 70 6f | 73 65 73 20 69 6e 20 63 |on purpo|ses in c|
|00003110| 6f 6e 66 69 67 75 72 61 | 74 69 6f 6e 73 20 77 69 |onfigura|tions wi|
|00003120| 74 68 20 61 20 73 6d 61 | 6c 6c 20 6e 75 6d 62 65 |th a sma|ll numbe|
|00003130| 72 20 6f 66 20 64 69 73 | 6b 73 2e 00 20 00 00 9c |r of dis|ks.. ...|
|00003140| 01 00 00 6e 01 00 00 6b | 88 00 00 db 8a 00 00 2e |...n...k|........|
|00003150| 00 00 00 20 2a 80 dd 02 | 00 80 00 00 50 02 a9 82 |... *...|....P...|
|00003160| 3d 7e 82 a9 02 80 0c 00 | 83 82 83 82 ff 00 53 49 |=~......|......SI|
|00003170| 4e 47 4c 45 3a 00 49 6e | 20 74 68 69 73 20 63 6f |NGLE:.In| this co|
|00003180| 6e 66 69 67 75 72 61 74 | 69 6f 6e 2c 20 74 68 65 |nfigurat|ion, the|
|00003190| 72 65 20 69 73 20 6e 6f | 20 61 72 63 68 69 76 65 |re is no| archive|
|000031a0| 20 6c 6f 67 2c 20 6f 6e | 6c 79 20 74 68 65 20 74 | log, on|ly the t|
|000031b0| 72 61 6e 73 61 63 74 69 | 6f 6e 20 6c 6f 67 20 69 |ransacti|on log i|
|000031c0| 73 20 77 72 69 74 74 65 | 6e 2e 20 54 68 69 73 20 |s writte|n. This |
|000031d0| 61 6c 6c 6f 77 73 20 41 | 44 41 42 41 53 20 74 6f |allows A|DABAS to|
|000031e0| 20 62 65 20 75 73 65 64 | 20 69 6e 20 63 6f 6e 66 | be used| in conf|
|000031f0| 69 67 75 72 61 74 69 6f | 6e 73 20 77 69 74 68 20 |iguratio|ns with |
|00003200| 6f 6e 65 20 64 69 73 6b | 2e 20 54 72 61 6e 73 61 |one disk|. Transa|
|00003210| 63 74 69 6f 6e 73 20 63 | 61 6e 20 62 65 20 72 6f |ctions c|an be ro|
|00003220| 6c 6c 65 64 20 62 61 63 | 6b 3b 20 62 75 74 20 69 |lled bac|k; but i|
|00003230| 66 20 61 20 64 65 76 69 | 63 65 20 66 61 69 6c 75 |f a devi|ce failu|
|00003240| 72 65 20 6f 63 63 75 72 | 73 2c 20 74 68 65 20 63 |re occur|s, the c|
|00003250| 6f 6e 74 65 6e 74 73 20 | 6f 66 20 74 68 65 20 64 |ontents |of the d|
|00003260| 61 74 61 62 61 73 65 20 | 61 72 65 20 64 65 73 74 |atabase |are dest|
|00003270| 72 6f 79 65 64 2e 00 00 | 54 68 65 20 6f 6e 6c 79 |royed...|The only|
|00003280| 20 63 6f 75 72 73 65 20 | 6f 66 20 61 63 74 69 6f | course |of actio|
|00003290| 6e 20 74 68 65 6e 20 69 | 73 20 74 6f 20 72 65 73 |n then i|s to res|
|000032a0| 74 6f 72 65 20 61 20 70 | 72 65 76 69 6f 75 73 20 |tore a p|revious |
|000032b0| 64 61 74 61 62 61 73 65 | 20 73 74 61 74 65 20 28 |database| state (|
|000032c0| 52 45 53 54 4f 52 45 20 | 44 41 54 41 2c 20 43 4c |RESTORE |DATA, CL|
|000032d0| 45 41 52 20 4c 4f 47 29 | 2e 00 00 2b 00 00 00 04 |EAR LOG)|...+....|
|000032e0| 00 00 00 3f 89 00 00 06 | 8b 00 00 27 00 00 00 20 |...?....|...'... |
|000032f0| 1e 80 08 00 80 00 00 50 | 00 a9 82 3d 7e 80 0c 00 |.......P|...=~...|
|00003300| 82 ff 00 20 00 00 57 01 | 00 00 2b 01 00 00 db 8a |... ..W.|..+.....|
|00003310| 00 00 5d 8c 00 00 2c 00 | 00 00 20 26 80 57 02 00 |..]...,.|.. &.W..|
|00003320| 80 00 00 50 02 a9 82 3d | 7e 82 a9 02 80 0c 00 83 |...P...=|~.......|
|00003330| 82 ff 00 44 45 4d 4f 3a | 00 49 6e 20 74 68 69 73 |...DEMO:|.In this|
|00003340| 20 63 6f 6e 66 69 67 75 | 72 61 74 69 6f 6e 2c 20 | configu|ration, |
|00003350| 74 6f 6f 2c 20 74 68 65 | 72 65 20 69 73 20 6e 6f |too, the|re is no|
|00003360| 20 61 72 63 68 69 76 65 | 20 6c 6f 67 2c 20 61 6e | archive| log, an|
|00003370| 64 20 6f 6e 6c 79 20 74 | 68 65 20 74 72 61 6e 73 |d only t|he trans|
|00003380| 61 63 74 69 6f 6e 20 6c | 6f 67 20 69 73 20 77 72 |action l|og is wr|
|00003390| 69 74 74 65 6e 2e 20 49 | 6e 20 63 6f 6e 74 72 61 |itten. I|n contra|
|000033a0| 73 74 20 74 6f 20 6c 6f | 67 20 6d 6f 64 65 20 53 |st to lo|g mode S|
|000033b0| 49 4e 47 4c 45 2c 20 74 | 68 65 20 74 72 61 6e 73 |INGLE, t|he trans|
|000033c0| 61 63 74 69 6f 6e 20 6c | 6f 67 20 69 73 20 63 79 |action l|og is cy|
|000033d0| 63 6c 69 63 61 6c 6c 79 | 20 6f 76 65 72 77 72 69 |clically| overwri|
|000033e0| 74 74 65 6e 20 74 6f 20 | 70 72 65 76 65 6e 74 20 |tten to |prevent |
|000033f0| 69 74 20 66 72 6f 6d 20 | 62 65 69 6e 67 20 66 69 |it from |being fi|
|00003400| 6c 6c 65 64 20 63 6f 6d | 70 6c 65 74 65 6c 79 2e |lled com|pletely.|
|00003410| 20 54 68 65 20 6f 74 68 | 65 72 20 63 68 61 72 61 | The oth|er chara|
|00003420| 63 74 69 73 74 69 63 73 | 20 61 72 65 20 74 68 65 |ctistics| are the|
|00003430| 20 73 61 6d 65 20 61 73 | 20 64 65 73 63 72 69 62 | same as| describ|
|00003440| 65 64 20 66 6f 72 20 74 | 68 65 20 6c 6f 67 20 6d |ed for t|he log m|
|00003450| 6f 64 65 20 53 49 4e 47 | 4c 45 2e 00 00 b2 03 00 |ode SING|LE......|
|00003460| 00 89 03 00 00 06 8b 00 | 00 1b c0 00 00 29 00 00 |........|.....)..|
|00003470| 00 20 20 80 13 07 00 80 | 00 00 10 00 e3 80 80 0c |. .....|........|
|00003480| 00 82 82 82 82 ff 00 20 | 00 49 66 20 74 68 65 20 |....... |.If the |
|00003490| 61 72 63 68 69 76 65 20 | 6c 6f 67 20 62 65 63 6f |archive |log beco|
|000034a0| 6d 65 73 20 66 75 6c 6c | 2c 20 64 61 74 61 62 61 |mes full|, databa|
|000034b0| 73 65 20 6f 70 65 72 61 | 74 69 6f 6e 20 73 74 6f |se opera|tion sto|
|000034c0| 70 73 20 61 6e 64 20 41 | 44 41 42 41 53 20 70 65 |ps and A|DABAS pe|
|000034d0| 72 66 6f 72 6d 73 20 61 | 6e 20 22 65 6d 65 72 67 |rforms a|n "emerg|
|000034e0| 65 6e 63 79 20 73 68 75 | 74 64 6f 77 6e 22 2e 20 |ency shu|tdown". |
|000034f0| 54 68 65 20 75 73 61 67 | 65 20 6c 65 76 65 6c 20 |The usag|e level |
|00003500| 6f 66 20 74 68 65 20 6c | 6f 67 20 69 73 20 74 68 |of the l|og is th|
|00003510| 65 72 65 66 6f 72 65 20 | 61 20 63 72 69 74 69 63 |erefore |a critic|
|00003520| 61 6c 20 70 61 72 61 6d | 65 74 65 72 20 6f 66 20 |al param|eter of |
|00003530| 64 61 74 61 62 61 73 65 | 20 6f 70 65 72 61 74 69 |database| operati|
|00003540| 6f 6e 20 61 6e 64 20 6d | 75 73 74 20 62 65 20 6d |on and m|ust be m|
|00003550| 6f 6e 69 74 6f 72 65 64 | 2e 20 54 68 65 20 61 72 |onitored|. The ar|
|00003560| 63 68 69 76 65 20 6c 6f | 67 20 63 61 6e 20 62 65 |chive lo|g can be|
|00003570| 20 65 78 70 61 6e 64 65 | 64 20 62 79 20 61 64 64 | expande|d by add|
|00003580| 69 74 69 6f 6e 61 6c 20 | 61 72 63 68 69 76 65 20 |itional |archive |
|00003590| 6c 6f 67 20 64 65 76 73 | 70 61 63 65 73 2c 20 69 |log devs|paces, i|
|000035a0| 66 20 6e 65 63 65 73 73 | 61 72 79 2c 20 77 68 69 |f necess|ary, whi|
|000035b0| 6c 65 20 74 68 65 20 64 | 61 74 61 62 61 73 65 20 |le the d|atabase |
|000035c0| 69 73 20 6f 70 65 72 61 | 74 69 6f 6e 61 6c 2e 00 |is opera|tional..|
|000035d0| 20 00 45 69 74 68 65 72 | 20 74 68 65 20 77 68 6f | .Either| the who|
|000035e0| 6c 65 20 6c 6f 67 20 6f | 72 20 73 65 6c 65 63 74 |le log o|r select|
|000035f0| 65 64 20 70 61 72 74 73 | 20 6f 66 20 74 68 65 20 |ed parts| of the |
|00003600| 6c 6f 67 20 63 61 6e 20 | 62 65 20 73 61 76 65 64 |log can |be saved|
|00003610| 2e 20 54 68 69 73 20 72 | 65 71 75 69 72 65 73 20 |. This r|equires |
|00003620| 74 68 65 20 64 65 66 69 | 6e 69 74 69 6f 6e 20 6f |the defi|nition o|
|00003630| 66 20 74 68 65 20 6d 61 | 78 69 6d 75 6d 20 73 69 |f the ma|ximum si|
|00003640| 7a 65 20 6f 66 20 6c 6f | 67 20 73 65 67 6d 65 6e |ze of lo|g segmen|
|00003650| 74 73 2e 20 54 68 65 20 | 73 69 7a 65 20 6f 66 20 |ts. The |size of |
|00003660| 74 68 65 20 6c 6f 67 20 | 73 65 67 6d 65 6e 74 73 |the log |segments|
|00003670| 20 69 73 20 69 6e 64 65 | 70 65 6e 64 65 6e 74 20 | is inde|pendent |
|00003680| 6f 66 20 74 68 65 20 73 | 69 7a 65 20 6f 66 20 74 |of the s|ize of t|
|00003690| 68 65 20 69 6e 64 69 76 | 69 64 75 61 6c 20 61 72 |he indiv|idual ar|
|000036a0| 63 68 69 76 65 20 6c 6f | 67 20 64 65 76 73 70 61 |chive lo|g devspa|
|000036b0| 63 65 73 3b 20 69 74 20 | 6d 75 73 74 20 6e 6f 74 |ces; it |must not|
|000036c0| 20 65 78 63 65 65 64 20 | 74 68 65 20 73 69 7a 65 | exceed |the size|
|000036d0| 20 6f 66 20 74 68 65 20 | 77 68 6f 6c 65 20 61 72 | of the |whole ar|
|000036e0| 63 68 69 76 65 20 6c 6f | 67 2e 20 49 66 20 61 20 |chive lo|g. If a |
|000036f0| 6c 6f 67 20 73 65 67 6d | 65 6e 74 20 69 73 20 75 |log segm|ent is u|
|00003700| 73 65 64 20 74 6f 20 37 | 30 25 2c 20 41 44 41 42 |sed to 7|0%, ADAB|
|00003710| 41 53 20 74 72 69 65 73 | 20 74 6f 20 63 6f 6d 70 |AS tries| to comp|
|00003720| 6c 65 74 65 20 74 68 65 | 20 6c 6f 67 20 73 65 67 |lete the| log seg|
|00003730| 6d 65 6e 74 2e 20 54 68 | 65 20 6f 6c 64 65 73 74 |ment. Th|e oldest|
|00003740| 20 63 6f 6d 70 6c 65 74 | 65 64 20 6c 6f 67 20 73 | complet|ed log s|
|00003750| 65 67 6d 65 6e 74 20 63 | 61 6e 20 62 65 20 73 61 |egment c|an be sa|
|00003760| 76 65 64 20 74 6f 20 61 | 6e 20 65 78 74 65 72 6e |ved to a|n extern|
|00003770| 61 6c 20 6d 65 64 69 75 | 6d 20 28 74 61 70 65 29 |al mediu|m (tape)|
|00003780| 2e 20 41 66 74 65 72 77 | 61 72 64 73 2c 20 74 68 |. Afterw|ards, th|
|00003790| 65 20 73 70 61 63 65 20 | 75 73 65 64 20 62 79 20 |e space |used by |
|000037a0| 74 68 69 73 20 6c 6f 67 | 20 73 65 67 6d 65 6e 74 |this log| segment|
|000037b0| 20 69 73 20 72 65 6c 65 | 61 73 65 64 2e 20 54 68 | is rele|ased. Th|
|000037c0| 69 73 20 70 72 6f 63 65 | 64 75 72 65 20 63 61 6e |is proce|dure can|
|000037d0| 20 62 65 20 61 75 74 6f | 6d 61 74 69 63 61 6c 6c | be auto|maticall|
|000037e0| 79 20 70 65 72 66 6f 72 | 6d 65 64 20 77 68 65 6e |y perfor|med when|
|000037f0| 65 76 65 72 20 61 20 6c | 6f 67 20 73 65 67 6d 65 |ever a l|og segme|
|00003800| 5d 8c 00 00 1b c0 00 00 | fc 82 00 00 6e 74 20 69 |].......|....nt i|
|00003810| 73 20 66 69 6c 6c 65 64 | 2e 00 00 8f 00 00 00 66 |s filled|.......f|
|00003820| 00 00 00 5d 8c 00 00 aa | c0 00 00 29 00 00 00 20 |...]....|...)... |
|00003830| 22 80 cc 00 80 00 00 10 | 00 e3 80 80 0c 00 82 82 |".......|........|
|00003840| 82 82 82 ff 00 20 00 49 | 66 20 6e 6f 20 6c 6f 67 |..... .I|f no log|
|00003850| 20 73 65 67 6d 65 6e 74 | 20 73 69 7a 65 20 68 61 | segment| size ha|
|00003860| 73 20 62 65 65 6e 20 64 | 65 66 69 6e 65 64 2c 20 |s been d|efined, |
|00003870| 74 68 65 20 77 68 6f 6c | 65 20 61 72 63 68 69 76 |the whol|e archiv|
|00003880| 65 20 6c 6f 67 20 69 73 | 20 63 6f 6e 73 69 64 65 |e log is| conside|
|00003890| 72 65 64 20 61 20 6c 6f | 67 20 73 65 67 6d 65 6e |red a lo|g segmen|
|000038a0| 74 2e 00 20 00 20 00 20 | 00 00 37 00 00 00 06 00 |t.. . . |..7.....|
|000038b0| 00 00 1b c0 00 00 e1 c0 | 00 00 31 00 00 00 02 a5 |........|..1.....|
|000038c0| 10 00 00 4d 01 01 00 04 | 00 02 00 05 00 00 00 e1 |...M....|........|
|000038d0| c0 00 00 0d c1 00 00 f9 | 00 01 00 42 61 63 6b 75 |........|...Backu|
|000038e0| 70 2c 00 00 00 09 00 00 | 00 aa c0 00 00 0d c1 00 |p,......|........|
|000038f0| 00 23 00 00 00 20 16 80 | 12 00 80 00 00 00 00 80 |.#... ..|........|
|00003900| 03 00 82 ff 00 42 61 63 | 6b 75 70 00 00 27 03 00 |.....Bac|kup..'..|
|00003910| 00 f2 02 00 00 e1 c0 00 | 00 34 c4 00 00 35 00 00 |........|.4...5..|
|00003920| 00 20 38 80 e5 05 00 80 | 00 00 10 00 e3 80 80 0c |. 8.....|........|
|00003930| 00 82 82 80 08 00 82 82 | 80 0d 00 82 80 0c 00 82 |........|........|
|00003940| 82 ff 00 20 00 41 44 41 | 42 41 53 20 73 75 70 70 |... .ADA|BAS supp|
|00003950| 6f 72 74 73 20 63 6f 6d | 70 6c 65 74 65 20 61 6e |orts com|plete an|
|00003960| 64 20 69 6e 63 72 65 6d | 65 6e 74 61 6c 20 64 61 |d increm|ental da|
|00003970| 74 61 20 62 61 63 6b 75 | 70 73 20 70 72 6f 76 69 |ta backu|ps provi|
|00003980| 64 69 6e 67 20 74 68 65 | 20 72 65 71 75 69 72 65 |ding the| require|
|00003990| 64 20 72 65 73 74 6f 72 | 65 20 61 6e 64 20 72 65 |d restor|e and re|
|000039a0| 73 74 61 72 74 20 66 75 | 6e 63 74 69 6f 6e 73 20 |start fu|nctions |
|000039b0| 69 6e 20 6f 72 64 65 72 | 20 74 6f 20 6d 61 6b 65 |in order| to make|
|000039c0| 20 64 61 74 61 62 61 73 | 65 73 20 6f 70 65 72 61 | databas|es opera|
|000039d0| 74 69 6f 6e 61 6c 20 61 | 67 61 69 6e 20 61 66 74 |tional a|gain aft|
|000039e0| 65 72 20 70 6f 77 65 72 | 20 61 6e 64 20 6d 65 64 |er power| and med|
|000039f0| 69 61 20 66 61 69 6c 75 | 72 65 73 2e 20 50 65 72 |ia failu|res. Per|
|00003a00| 69 6f 64 69 63 20 62 61 | 63 6b 75 70 73 20 61 72 |iodic ba|ckups ar|
|00003a10| 65 20 69 6e 64 69 73 70 | 65 6e 73 61 62 6c 65 20 |e indisp|ensable |
|00003a20| 66 6f 72 20 70 72 6f 64 | 75 63 74 69 6f 6e 20 64 |for prod|uction d|
|00003a30| 61 74 61 62 61 73 65 20 | 65 6e 76 69 72 6f 6e 6d |atabase |environm|
|00003a40| 65 6e 74 73 2e 00 00 20 | 00 20 00 00 43 6f 6d 70 |ents... |. ..Comp|
|00003a50| 6c 65 74 65 20 42 61 63 | 6b 75 70 20 6f 66 20 74 |lete Bac|kup of t|
|00003a60| 68 65 20 44 41 54 41 42 | 41 53 45 20 28 53 41 56 |he DATAB|ASE (SAV|
|00003a70| 45 20 44 41 54 41 29 00 | 00 20 00 41 20 63 6f 6d |E DATA).|. .A com|
|00003a80| 70 6c 65 74 65 20 62 61 | 63 6b 75 70 20 6f 66 20 |plete ba|ckup of |
|00003a90| 74 68 65 20 64 61 74 61 | 20 6f 66 20 61 20 53 45 |the data| of a SE|
|00003aa0| 52 56 45 52 44 42 20 28 | 53 41 56 45 20 44 41 54 |RVERDB (|SAVE DAT|
|00003ab0| 41 29 20 63 61 6e 20 62 | 65 20 70 65 72 66 6f 72 |A) can b|e perfor|
|00003ac0| 6d 65 64 20 77 68 69 6c | 65 20 74 68 65 20 64 61 |med whil|e the da|
|00003ad0| 74 61 62 61 73 65 20 69 | 73 20 6f 70 65 72 61 74 |tabase i|s operat|
|00003ae0| 69 6f 6e 61 6c 20 28 61 | 6e 64 2c 20 6f 66 20 63 |ional (a|nd, of c|
|00003af0| 6f 75 72 73 65 2c 20 77 | 68 65 6e 20 74 68 65 20 |ourse, w|hen the |
|00003b00| 64 61 74 61 62 61 73 65 | 20 69 73 20 69 6e 20 43 |database| is in C|
|00003b10| 4f 4c 44 20 6d 6f 64 65 | 29 2e 20 46 6f 72 20 62 |OLD mode|). For b|
|00003b20| 61 63 6b 75 70 73 20 70 | 65 72 66 6f 72 6d 65 64 |ackups p|erformed|
|00003b30| 20 77 68 69 6c 65 20 74 | 68 65 20 64 61 74 61 62 | while t|he datab|
|00003b40| 61 73 65 20 69 73 20 6f | 70 65 72 61 74 69 6f 6e |ase is o|peration|
|00003b50| 61 6c 2c 20 74 68 65 20 | 73 74 61 74 65 20 6f 66 |al, the |state of|
|00003b60| 20 74 68 65 20 64 61 74 | 61 62 61 73 65 20 61 74 | the dat|abase at|
|00003b70| 20 74 68 65 20 62 65 67 | 69 6e 6e 69 6e 67 20 6f | the beg|inning o|
|00003b80| 66 20 74 68 65 20 62 61 | 63 6b 75 70 2c 20 6e 6f |f the ba|ckup, no|
|00003b90| 74 20 74 68 61 74 20 61 | 74 20 74 68 65 20 65 6e |t that a|t the en|
|00003ba0| 64 20 6f 66 20 74 68 65 | 20 62 61 63 6b 75 70 2c |d of the| backup,|
|00003bb0| 20 69 73 20 77 72 69 74 | 74 65 6e 20 74 6f 20 61 | is writ|ten to a|
|00003bc0| 6e 20 65 78 74 65 72 6e | 61 6c 20 6d 65 64 69 75 |n extern|al mediu|
|00003bd0| 6d 20 28 65 2e 67 2e 2c | 20 74 61 70 65 29 2e 20 |m (e.g.,| tape). |
|00003be0| 41 20 63 6f 6d 70 6c 65 | 74 65 20 62 61 63 6b 75 |A comple|te backu|
|00003bf0| 70 20 69 73 20 74 68 65 | 20 62 61 73 69 73 20 66 |p is the| basis f|
|00003c00| 6f 72 20 61 6e 79 20 72 | 65 73 74 6f 72 65 20 6f |or any r|estore o|
|00003c10| 70 65 72 61 74 69 6f 6e | 73 20 74 68 61 74 20 6d |peration|s that m|
|00003c20| 69 67 68 74 20 62 65 20 | 72 65 71 75 69 72 65 64 |ight be |required|
|00003c30| 2e 20 00 00 bd 02 00 00 | 89 02 00 00 0d c1 00 00 |. ......|........|
|00003c40| f1 c6 00 00 34 00 00 00 | 20 36 80 13 05 00 80 00 |....4...| 6......|
|00003c50| 00 10 00 e3 80 80 0c 00 | 82 80 08 00 82 82 80 0d |........|........|
|00003c60| 00 82 80 0c 00 82 82 ff | 00 41 20 63 6f 6d 70 6c |........|.A compl|
|00003c70| 65 74 65 20 62 61 63 6b | 75 70 20 6d 61 6b 65 73 |ete back|up makes|
|00003c80| 20 73 65 6e 73 65 20 62 | 65 66 6f 72 65 20 61 6e | sense b|efore an|
|00003c90| 64 20 61 66 74 65 72 20 | 6c 61 72 67 65 2d 73 63 |d after |large-sc|
|00003ca0| 61 6c 65 20 6d 6f 64 69 | 66 69 63 61 74 69 6f 6e |ale modi|fication|
|00003cb0| 73 20 74 6f 20 74 68 65 | 20 53 45 52 56 45 52 44 |s to the| SERVERD|
|00003cc0| 42 20 61 6e 64 20 62 65 | 66 6f 72 65 20 73 74 6f |B and be|fore sto|
|00003cd0| 70 70 69 6e 67 20 74 68 | 65 20 73 79 73 74 65 6d |pping th|e system|
|00003ce0| 2c 20 65 2e 67 2e 2c 20 | 61 74 20 74 68 65 20 77 |, e.g., |at the w|
|00003cf0| 65 65 6b 65 6e 64 2e 00 | 00 20 00 20 00 00 49 6e |eekend..|. . ..In|
|00003d00| 63 72 65 6d 65 6e 74 61 | 6c 20 42 61 63 6b 75 70 |crementa|l Backup|
|00003d10| 2c 20 6c 6f 67 69 63 61 | 6c 20 28 53 41 56 45 20 |, logica|l (SAVE |
|00003d20| 4c 4f 47 2c 20 53 41 56 | 45 20 4c 4f 47 20 53 45 |LOG, SAV|E LOG SE|
|00003d30| 47 4d 45 4e 54 29 00 00 | 20 00 41 73 20 61 20 72 |GMENT)..| .As a r|
|00003d40| 75 6c 65 2c 20 74 68 65 | 20 63 6f 6e 74 65 6e 74 |ule, the| content|
|00003d50| 73 20 6f 66 20 74 68 65 | 20 61 72 63 68 69 76 65 |s of the| archive|
|00003d60| 20 6c 6f 67 20 61 72 65 | 20 75 73 65 64 20 66 6f | log are| used fo|
|00003d70| 72 20 61 6e 20 69 6e 63 | 72 65 6d 65 6e 74 61 6c |r an inc|remental|
|00003d80| 20 62 61 63 6b 75 70 2e | 20 41 6c 6c 20 6d 6f 64 | backup.| All mod|
|00003d90| 69 66 69 63 61 74 69 6f | 6e 73 20 6d 61 64 65 20 |ificatio|ns made |
|00003da0| 74 6f 20 74 68 65 20 64 | 61 74 61 62 61 73 65 20 |to the d|atabase |
|00003db0| 61 72 65 20 72 65 63 6f | 72 64 65 64 20 69 6e 20 |are reco|rded in |
|00003dc0| 74 68 65 20 61 72 63 68 | 69 76 65 20 6c 6f 67 20 |the arch|ive log |
|00003dd0| 66 72 6f 6d 20 77 68 69 | 63 68 20 74 68 65 20 64 |from whi|ch the d|
|00003de0| 61 74 61 20 63 61 6e 20 | 62 65 20 6c 6f 67 69 63 |ata can |be logic|
|00003df0| 61 6c 6c 79 20 72 65 63 | 6f 6e 73 74 72 75 63 74 |ally rec|onstruct|
|00003e00| 65 64 2e 20 41 73 20 61 | 6e 20 6f 76 65 72 66 6c |ed. As a|n overfl|
|00003e10| 6f 77 20 6f 66 20 74 68 | 65 20 61 72 63 68 69 76 |ow of th|e archiv|
|00003e20| 65 20 6c 6f 67 20 28 4c | 4f 47 20 46 55 4c 4c 29 |e log (L|OG FULL)|
|00003e30| 20 68 61 73 20 74 68 65 | 20 65 66 66 65 63 74 20 | has the| effect |
|00003e40| 74 68 61 74 20 64 61 74 | 61 62 61 73 65 20 6f 70 |that dat|abase op|
|00003e50| 65 72 61 74 69 6f 6e 20 | 69 73 20 69 6e 74 65 72 |eration |is inter|
|00003e60| 72 75 70 74 65 64 2c 20 | 74 68 65 20 6c 6f 67 20 |rupted, |the log |
|00003e70| 6f 72 20 61 20 6c 6f 67 | 20 73 65 67 6d 65 6e 74 |or a log| segment|
|00003e80| 20 6d 75 73 74 20 62 65 | 20 62 61 63 6b 65 64 20 | must be| backed |
|00003e90| 75 70 20 69 6e 20 74 69 | 6d 65 20 74 6f 20 72 65 |up in ti|me to re|
|00003ea0| 6c 65 61 73 65 20 74 68 | 65 20 75 73 65 64 20 6c |lease th|e used l|
|00003eb0| 6f 67 20 61 72 65 61 2e | 20 49 74 20 69 73 20 6e |og area.| It is n|
|00003ec0| 6f 74 20 70 6f 73 73 69 | 62 6c 65 20 74 6f 20 62 |ot possi|ble to b|
|00003ed0| 61 63 6b 75 70 20 74 68 | 65 20 6c 6f 67 20 69 6e |ackup th|e log in|
|00003ee0| 20 6c 6f 67 20 6d 6f 64 | 65 20 44 45 4d 4f 2e 00 | log mod|e DEMO..|
|00003ef0| 00 35 02 00 00 f9 01 00 | 00 34 c4 00 00 26 c9 00 |.5......|.4...&..|
|00003f00| 00 3c 00 00 00 20 46 80 | f3 03 00 80 00 00 10 00 |.<... F.|........|
|00003f10| e3 80 80 08 00 82 82 80 | 0d 00 80 0e 00 82 80 0c |........|........|
|00003f20| 00 82 82 82 80 0d 00 82 | 80 0c 00 82 ff 00 20 00 |........|...... .|
|00003f30| 20 00 00 53 61 76 69 6e | 67 20 61 20 4c 6f 67 20 | ..Savin|g a Log |
|00003f40| 53 65 67 6d 65 6e 74 00 | 00 00 20 00 49 66 20 74 |Segment.|.. .If t|
|00003f50| 68 65 20 61 72 63 68 69 | 76 65 20 6c 6f 67 20 28 |he archi|ve log (|
|00003f60| 53 41 56 45 20 4c 4f 47 | 20 53 45 47 4d 45 4e 54 |SAVE LOG| SEGMENT|
|00003f70| 29 20 69 73 20 62 61 63 | 6b 65 64 20 75 70 20 77 |) is bac|ked up w|
|00003f80| 68 69 6c 65 20 74 68 65 | 20 64 61 74 61 62 61 73 |hile the| databas|
|00003f90| 65 20 69 73 20 6f 70 65 | 72 61 74 69 6f 6e 61 6c |e is ope|rational|
|00003fa0| 20 28 6f 72 20 77 68 65 | 6e 20 74 68 65 20 64 61 | (or whe|n the da|
|00003fb0| 74 61 62 61 73 65 20 69 | 73 20 73 68 75 74 20 64 |tabase i|s shut d|
|00003fc0| 6f 77 6e 29 2c 20 61 20 | 63 6f 6d 70 6c 65 74 65 |own), a |complete|
|00003fd0| 64 20 73 65 67 6d 65 6e | 74 20 6f 66 20 74 68 65 |d segmen|t of the|
|00003fe0| 20 6c 6f 67 20 69 73 20 | 77 72 69 74 74 65 6e 20 | log is |written |
|00003ff0| 74 6f 20 61 6e 20 65 78 | 74 65 72 6e 61 6c 20 6d |to an ex|ternal m|
|00004000| 65 64 69 75 6d 20 28 74 | 61 70 65 29 2e 20 54 68 |edium (t|ape). Th|
|00004010| 65 20 64 65 76 73 70 61 | 63 65 20 61 72 65 61 20 |e devspa|ce area |
|00004020| 6f 66 20 74 68 65 20 73 | 61 76 65 64 20 6c 6f 67 |of the s|aved log|
|00004030| 20 73 65 67 6d 65 6e 74 | 20 69 73 20 63 6c 65 61 | segment| is clea|
|00004040| 72 65 64 20 61 6e 64 20 | 63 61 6e 20 62 65 20 75 |red and |can be u|
|00004050| 73 65 64 20 66 6f 72 20 | 74 68 65 20 72 65 63 6f |sed for |the reco|
|00004060| 72 64 69 6e 67 20 6f 66 | 20 66 75 74 75 72 65 20 |rding of| future |
|00004070| 64 61 74 61 62 61 73 65 | 20 6d 6f 64 69 66 69 63 |database| modific|
|00004080| 61 74 69 6f 6e 73 2e 20 | 49 6e 20 61 64 64 69 74 |ations. |In addit|
|00004090| 69 6f 6e 2c 20 43 4f 4e | 54 52 4f 4c 20 6f 66 66 |ion, CON|TROL off|
|000040a0| 65 72 73 20 61 6e 20 61 | 75 74 6f 6d 61 74 69 63 |ers an a|utomatic|
|000040b0| 20 62 61 63 6b 75 70 20 | 6f 66 20 63 6f 6d 70 6c | backup |of compl|
|000040c0| 65 74 65 64 20 6c 6f 67 | 20 73 65 67 6d 65 6e 74 |eted log| segment|
|000040d0| 73 20 28 41 55 54 4f 53 | 41 56 45 20 4c 4f 47 29 |s (AUTOS|AVE LOG)|
|000040e0| 2e 00 20 00 00 20 00 42 | 61 63 6b 69 6e 67 20 55 |.. .. .B|acking U|
|000040f0| 70 20 74 68 65 20 41 72 | 63 68 69 76 65 20 4c 6f |p the Ar|chive Lo|
|00004100| 67 20 57 68 69 6c 65 20 | 74 68 65 20 44 61 74 61 |g While |the Data|
|00004110| 62 61 73 65 20 69 73 20 | 4f 70 65 72 61 74 69 6f |base is |Operatio|
|00004120| 6e 61 6c 00 00 00 41 02 | 00 00 18 02 00 00 f1 c6 |nal...A.|........|
|00004130| 00 00 67 cb 00 00 29 00 | 00 00 20 20 80 31 04 00 |..g...).|.. .1..|
|00004140| 80 00 00 10 00 e3 80 80 | 0c 00 82 82 82 82 ff 00 |........|........|
|00004150| 20 00 49 6e 20 61 64 64 | 69 74 69 6f 6e 20 74 6f | .In add|ition to|
|00004160| 20 73 61 76 69 6e 67 20 | 63 6f 6d 70 6c 65 74 65 | saving |complete|
|00004170| 64 20 6c 6f 67 20 73 65 | 67 6d 65 6e 74 73 2c 20 |d log se|gments, |
|00004180| 74 68 65 20 77 68 6f 6c | 65 20 61 72 63 68 69 76 |the whol|e archiv|
|00004190| 65 20 6c 6f 67 20 61 6e | 64 20 74 68 65 20 63 75 |e log an|d the cu|
|000041a0| 72 72 65 6e 74 6c 79 20 | 61 63 74 69 76 65 2c 20 |rrently |active, |
|000041b0| 69 6e 63 6f 6d 70 6c 65 | 74 65 20 6c 6f 67 20 73 |incomple|te log s|
|000041c0| 65 67 6d 65 6e 74 20 63 | 61 6e 20 62 65 20 77 72 |egment c|an be wr|
|000041d0| 69 74 74 65 6e 20 74 6f | 20 61 6e 20 65 78 74 65 |itten to| an exte|
|000041e0| 72 6e 61 6c 20 64 65 76 | 69 63 65 20 28 74 61 70 |rnal dev|ice (tap|
|000041f0| 65 29 2e 20 54 68 69 73 | 20 63 61 6e 20 62 65 20 |e). This| can be |
|00004200| 64 6f 6e 65 20 75 73 69 | 6e 67 20 53 41 56 45 20 |done usi|ng SAVE |
|00004210| 4c 4f 47 20 77 68 69 6c | 65 20 74 68 65 20 64 61 |LOG whil|e the da|
|00004220| 74 61 62 61 73 65 20 69 | 73 20 6f 70 65 72 61 74 |tabase i|s operat|
|00004230| 69 6f 6e 61 6c 2e 20 41 | 66 74 65 72 77 61 72 64 |ional. A|fterward|
|00004240| 73 2c 20 74 68 65 20 77 | 68 6f 6c 65 20 61 72 63 |s, the w|hole arc|
|00004250| 68 69 76 65 20 6c 6f 67 | 20 64 65 76 73 70 61 63 |hive log| devspac|
|00004260| 65 20 6f 66 20 74 68 65 | 20 53 45 52 56 45 52 44 |e of the| SERVERD|
|00004270| 42 20 69 73 20 63 6c 65 | 61 72 65 64 2e 00 20 00 |B is cle|ared.. .|
|00004280| 41 20 62 61 63 6b 75 70 | 20 6f 66 20 74 68 65 20 |A backup| of the |
|00004290| 61 72 63 68 69 76 65 20 | 6c 6f 67 20 70 65 72 66 |archive |log perf|
|000042a0| 6f 72 6d 65 64 20 77 68 | 69 6c 65 20 74 68 65 20 |ormed wh|ile the |
|000042b0| 64 61 74 61 62 61 73 65 | 20 69 73 20 6e 6f 74 20 |database| is not |
|000042c0| 6f 70 65 72 61 74 69 6f | 6e 61 6c 20 69 73 20 6f |operatio|nal is o|
|000042d0| 6e 6c 79 20 75 73 65 64 | 20 74 6f 20 70 72 65 70 |nly used| to prep|
|000042e0| 61 72 65 20 61 20 64 61 | 74 61 62 61 73 65 20 72 |are a da|tabase r|
|000042f0| 65 63 6f 76 65 72 79 20 | 61 6e 64 20 73 68 6f 75 |ecovery |and shou|
|00004300| 6c 64 20 6e 6f 74 20 62 | 65 20 63 6f 6e 73 69 64 |ld not b|e consid|
|00004310| 65 72 65 64 20 66 6f 72 | 20 74 68 65 20 62 61 63 |ered for| the bac|
|00004320| 6b 75 70 20 70 72 6f 63 | 65 64 75 72 65 20 69 6e |kup proc|edure in|
|00004330| 20 74 68 65 20 53 63 68 | 65 64 75 6c 65 20 4d 61 | the Sch|edule Ma|
|00004340| 6e 61 67 65 72 20 62 65 | 63 61 75 73 65 20 74 68 |nager be|cause th|
|00004350| 65 20 6c 6f 67 20 69 73 | 20 6e 6f 74 20 63 6c 65 |e log is| not cle|
|00004360| 61 72 65 64 2e 00 00 8e | 02 00 00 4e 02 00 00 26 |ared....|...N...&|
|00004370| c9 00 00 f5 cd 00 00 40 | 00 00 00 20 4e 80 9d 04 |.......@|... N...|
|00004380| 00 80 00 00 10 00 e3 80 | 80 08 00 82 82 80 0d 00 |........|........|
|00004390| 82 80 0c 00 82 82 80 08 | 00 82 82 80 0d 00 82 80 |........|........|
|000043a0| 0c 00 82 82 82 82 ff 00 | 20 00 20 00 00 49 6e 63 |........| . ..Inc|
|000043b0| 72 65 6d 65 6e 74 61 6c | 20 42 61 63 6b 75 70 2c |remental| Backup,|
|000043c0| 20 70 68 79 73 69 63 61 | 6c 20 28 53 41 56 45 20 | physica|l (SAVE |
|000043d0| 50 41 47 45 53 29 00 00 | 20 00 41 6e 20 61 6c 74 |PAGES)..| .An alt|
|000043e0| 65 72 6e 61 74 69 76 65 | 20 74 6f 20 73 61 76 69 |ernative| to savi|
|000043f0| 6e 67 20 74 68 65 20 6c | 6f 67 20 69 73 20 62 61 |ng the l|og is ba|
|00004400| 63 6b 69 6e 67 20 75 70 | 20 74 68 65 20 64 61 74 |cking up| the dat|
|00004410| 61 62 61 73 65 20 70 61 | 67 65 73 20 74 68 61 74 |abase pa|ges that|
|00004420| 20 68 61 76 65 20 62 65 | 65 6e 20 6d 6f 64 69 66 | have be|en modif|
|00004430| 69 65 64 20 73 69 6e 63 | 65 20 74 68 65 20 6c 61 |ied sinc|e the la|
|00004440| 73 74 20 62 61 63 6b 75 | 70 20 28 53 41 56 45 20 |st backu|p (SAVE |
|00004450| 50 41 47 45 53 29 2e 00 | 00 20 00 20 00 00 52 65 |PAGES)..|. . ..Re|
|00004460| 63 6f 6d 6d 65 6e 64 61 | 74 69 6f 6e 73 20 66 6f |commenda|tions fo|
|00004470| 72 20 42 61 63 6b 69 6e | 67 20 55 70 20 74 68 65 |r Backin|g Up the|
|00004480| 20 53 45 52 56 45 52 44 | 42 00 00 20 00 57 65 20 | SERVERD|B.. .We |
|00004490| 72 65 63 6f 6d 6d 65 6e | 64 20 74 6f 20 70 65 72 |recommen|d to per|
|000044a0| 66 6f 72 6d 20 61 20 63 | 6f 6d 70 6c 65 74 65 20 |form a c|omplete |
|000044b0| 64 61 74 61 20 62 61 63 | 6b 75 70 20 61 66 74 65 |data bac|kup afte|
|000044c0| 72 20 74 68 65 20 69 6e | 73 74 61 6c 6c 61 74 69 |r the in|stallati|
|000044d0| 6f 6e 20 6f 66 20 74 68 | 65 20 64 61 74 61 62 61 |on of th|e databa|
|000044e0| 73 65 20 61 6e 64 20 74 | 68 65 6e 20 74 6f 20 73 |se and t|hen to s|
|000044f0| 63 68 65 64 75 6c 65 20 | 61 20 62 61 63 6b 75 70 |chedule |a backup|
|00004500| 20 69 6e 20 72 65 67 75 | 6c 61 72 20 74 69 6d 65 | in regu|lar time|
|00004510| 20 69 6e 74 65 72 76 61 | 6c 73 20 28 77 65 65 6b | interva|ls (week|
|00004520| 6c 79 29 2e 20 00 20 00 | 49 66 20 74 68 65 20 64 |ly). . .|If the d|
|00004530| 61 74 61 62 61 73 65 20 | 6d 6f 64 69 66 69 63 61 |atabase |modifica|
|00004540| 74 69 6f 6e 73 20 61 72 | 65 20 73 70 72 65 61 64 |tions ar|e spread|
|00004550| 20 61 63 72 6f 73 73 20 | 74 68 65 20 77 68 6f 6c | across |the whol|
|00004560| 65 20 64 61 74 61 62 61 | 73 65 2c 20 77 65 20 72 |e databa|se, we r|
|00004570| 65 63 6f 6d 6d 65 6e 64 | 20 74 6f 20 75 73 65 20 |ecommend| to use |
|00004580| 74 68 65 20 61 72 63 68 | 69 76 65 20 6c 6f 67 20 |the arch|ive log |
|00004590| 66 6f 72 20 69 6e 63 72 | 65 6d 65 6e 74 61 6c 20 |for incr|emental |
|000045a0| 62 61 63 6b 75 70 73 2e | 20 54 68 65 73 65 20 73 |backups.| These s|
|000045b0| 68 6f 75 6c 64 20 62 65 | 20 70 65 72 66 6f 72 6d |hould be| perform|
|000045c0| 65 64 20 72 65 67 75 6c | 61 72 6c 79 2c 20 61 74 |ed regul|arly, at|
|000045d0| 20 62 65 73 74 20 61 75 | 74 6f 6d 61 74 69 63 61 | best au|tomatica|
|000045e0| 6c 6c 79 20 28 41 55 54 | 4f 53 41 56 45 20 4c 4f |lly (AUT|OSAVE LO|
|000045f0| 47 29 2e 00 00 cf 02 00 | 00 a6 02 00 00 67 cb 00 |G)......|.....g..|
|00004600| 00 d0 00 01 00 29 00 00 | 00 20 20 80 4d 05 00 80 |.....)..|. .M...|
|00004610| 00 00 10 00 e3 80 80 0c | 00 82 82 82 82 ff 00 20 |........|....... |
|00004620| 00 46 6f 72 20 6c 61 72 | 67 65 2d 73 63 61 6c 65 |.For lar|ge-scale|
|00004630| 20 64 61 74 61 62 61 73 | 65 20 6d 6f 64 69 66 69 | databas|e modifi|
|00004640| 63 61 74 69 6f 6e 73 20 | 74 68 61 74 20 6f 6e 6c |cations |that onl|
|00004650| 79 20 72 65 6c 61 74 65 | 20 74 6f 20 61 20 70 61 |y relate| to a pa|
|00004660| 72 74 20 6f 66 20 74 68 | 65 20 64 61 74 61 62 61 |rt of th|e databa|
|00004670| 73 65 2c 20 77 65 20 72 | 65 63 6f 6d 6d 65 6e 64 |se, we r|ecommend|
|00004680| 20 74 6f 20 62 61 63 6b | 75 70 20 74 68 65 20 6d | to back|up the m|
|00004690| 6f 64 69 66 69 65 64 20 | 64 61 74 61 62 61 73 65 |odified |database|
|000046a0| 20 70 61 67 65 73 2e 20 | 41 73 20 61 20 72 75 6c | pages. |As a rul|
|000046b0| 65 2c 20 61 6e 20 69 6e | 63 72 65 6d 65 6e 74 61 |e, an in|crementa|
|000046c0| 6c 20 62 61 63 6b 75 70 | 20 62 79 20 53 41 56 45 |l backup| by SAVE|
|000046d0| 20 50 41 47 45 53 20 69 | 6e 63 72 65 61 73 65 73 | PAGES i|ncreases|
|000046e0| 20 74 68 65 20 64 61 74 | 61 20 76 6f 6c 75 6d 65 | the dat|a volume|
|000046f0| 20 62 75 74 20 73 70 65 | 65 64 73 20 75 70 20 74 | but spe|eds up t|
|00004700| 68 65 20 72 65 73 74 6f | 72 65 20 74 69 6d 65 73 |he resto|re times|
|00004710| 20 62 65 63 61 75 73 65 | 20 74 68 65 20 64 61 74 | because| the dat|
|00004720| 61 62 61 73 65 20 70 61 | 67 65 73 20 6d 75 73 74 |abase pa|ges must|
|00004730| 20 6f 6e 6c 79 20 62 65 | 20 72 65 6c 6f 61 64 65 | only be| reloade|
|00004740| 64 3b 20 77 68 65 72 65 | 61 73 20 66 6f 72 20 61 |d; where|as for a|
|00004750| 20 72 65 73 74 6f 72 65 | 20 77 69 74 68 20 74 68 | restore| with th|
|00004760| 65 20 61 72 63 68 69 76 | 65 20 6c 6f 67 2c 20 70 |e archiv|e log, p|
|00004770| 72 65 76 69 6f 75 73 20 | 6c 6f 67 73 20 6d 75 73 |revious |logs mus|
|00004780| 74 20 62 65 20 72 65 61 | 70 70 6c 69 65 64 2e 00 |t be rea|pplied..|
|00004790| 20 00 54 6f 20 61 63 63 | 65 6c 65 72 61 74 65 20 | .To acc|elerate |
|000047a0| 74 68 65 20 62 61 63 6b | 75 70 20 61 6e 64 20 72 |the back|up and r|
|000047b0| 65 73 74 6f 72 65 20 6f | 70 65 72 61 74 69 6f 6e |estore o|peration|
|000047c0| 73 20 66 6f 72 20 6c 61 | 72 67 65 20 64 61 74 61 |s for la|rge data|
|000047d0| 62 61 73 65 73 20 28 53 | 41 56 45 a0 44 41 54 41 |bases (S|AVE.DATA|
|000047e0| 2c 20 53 41 56 45 a0 50 | 41 47 45 53 2c 20 52 45 |, SAVE.P|AGES, RE|
|000047f0| 53 54 4f 52 45 a0 44 41 | 54 41 29 2c 20 69 74 20 |STORE.DA|TA), it |
|00004800| f5 cd 00 00 d0 00 01 00 | aa c0 00 00 69 73 20 72 |........|....is r|
|00004810| 65 63 6f 6d 6d 65 6e 64 | 65 64 20 74 6f 20 75 73 |ecommend|ed to us|
|00004820| 65 20 73 65 76 65 72 61 | 6c 20 74 61 70 65 20 64 |e severa|l tape d|
|00004830| 65 76 69 63 65 73 20 73 | 69 6d 75 6c 74 61 6e 65 |evices s|imultane|
|00004840| 6f 75 73 6c 79 2e 20 54 | 68 65 20 62 61 63 6b 75 |ously. T|he backu|
|00004850| 70 20 61 6e 64 20 72 65 | 73 74 6f 72 65 20 74 69 |p and re|store ti|
|00004860| 6d 65 73 20 74 68 65 6e | 20 6f 6e 6c 79 20 64 65 |mes then| only de|
|00004870| 70 65 6e 64 20 6f 6e 20 | 74 68 65 20 6e 75 6d 62 |pend on |the numb|
|00004880| 65 72 20 6f 66 20 74 61 | 70 65 20 64 65 76 69 63 |er of ta|pe devic|
|00004890| 65 73 20 75 73 65 64 20 | 61 6e 64 20 6f 6e 20 74 |es used |and on t|
|000048a0| 68 65 20 64 69 73 6b 20 | 63 61 70 61 63 69 74 79 |he disk |capacity|
|000048b0| 20 6f 66 20 74 68 65 20 | 6c 61 72 67 65 73 74 20 | of the |largest |
|000048c0| 64 61 74 61 20 64 65 76 | 73 70 61 63 65 2e 00 00 |data dev|space...|
|000048d0| 29 00 00 00 04 00 00 00 | f5 cd 00 00 f9 00 01 00 |).......|........|
|000048e0| 25 00 00 00 20 1a 80 08 | 00 80 00 00 10 00 e3 80 |%... ...|........|
|000048f0| 80 0c 00 82 ff 00 20 00 | 00 38 00 00 00 07 00 00 |...... .|.8......|
|00004900| 00 d0 00 01 00 31 01 01 | 00 31 00 00 00 02 40 0b |.....1..|.1....@.|
|00004910| 00 00 66 80 01 00 78 0a | 02 00 06 00 00 00 31 01 |..f...x.|......1.|
|00004920| 01 00 5e 01 01 00 6d 0c | 01 00 52 65 73 74 6f 72 |..^...m.|..Restor|
|00004930| 65 2d 00 00 00 0a 00 00 | 00 f9 00 01 00 5e 01 01 |e-......|.....^..|
|00004940| 00 23 00 00 00 20 16 80 | 14 00 80 00 00 00 00 80 |.#... ..|........|
|00004950| 03 00 82 ff 00 52 65 73 | 74 6f 72 65 00 00 83 02 |.....Res|tore....|
|00004960| 00 00 5a 02 00 00 31 01 | 01 00 e1 03 01 00 29 00 |..Z...1.|......).|
|00004970| 00 00 20 20 80 b5 04 00 | 80 00 00 10 00 e3 80 80 |.. ....|........|
|00004980| 0c 00 82 82 82 82 ff 00 | 20 00 49 66 20 61 20 64 |........| .If a d|
|00004990| 61 74 61 62 61 73 65 20 | 66 61 69 6c 75 72 65 20 |atabase |failure |
|000049a0| 6f 74 68 65 72 20 74 68 | 61 6e 20 61 20 64 65 76 |other th|an a dev|
|000049b0| 73 70 61 63 65 20 66 61 | 69 6c 75 72 65 20 6f 63 |space fa|ilure oc|
|000049c0| 63 75 72 73 2c 20 74 68 | 65 20 72 65 73 74 61 72 |curs, th|e restar|
|000049d0| 74 20 6f 66 20 41 44 41 | 42 41 53 20 65 6e 73 75 |t of ADA|BAS ensu|
|000049e0| 72 65 73 20 74 68 61 74 | 20 74 68 65 20 6c 61 73 |res that| the las|
|000049f0| 74 20 63 6f 6e 73 69 73 | 74 65 6e 74 20 64 61 74 |t consis|tent dat|
|00004a00| 61 62 61 73 65 20 73 74 | 61 74 65 20 69 73 20 72 |abase st|ate is r|
|00004a10| 65 65 73 74 61 62 6c 69 | 73 68 65 64 20 75 73 69 |eestabli|shed usi|
|00004a20| 6e 67 20 74 68 65 20 74 | 72 61 6e 73 61 63 74 69 |ng the t|ransacti|
|00004a30| 6f 6e 20 6c 6f 67 3b 20 | 74 68 69 73 20 6d 65 61 |on log; |this mea|
|00004a40| 6e 73 2c 20 74 68 65 20 | 65 66 66 65 63 74 73 20 |ns, the |effects |
|00004a50| 6f 66 20 63 6f 6d 6d 69 | 74 74 65 64 20 74 72 61 |of commi|tted tra|
|00004a60| 6e 73 61 63 74 69 6f 6e | 73 20 61 72 65 20 72 65 |nsaction|s are re|
|00004a70| 61 70 70 6c 69 65 64 20 | 6f 6e 20 74 68 65 20 64 |applied |on the d|
|00004a80| 61 74 61 20 64 65 76 73 | 70 61 63 65 73 2c 20 61 |ata devs|paces, a|
|00004a90| 6e 64 20 74 68 65 20 65 | 66 66 65 63 74 73 20 6f |nd the e|ffects o|
|00004aa0| 66 20 6f 70 65 6e 20 74 | 72 61 6e 73 61 63 74 69 |f open t|ransacti|
|00004ab0| 6f 6e 73 20 61 72 65 20 | 72 6f 6c 6c 65 64 20 62 |ons are |rolled b|
|00004ac0| 61 63 6b 2e 00 20 00 49 | 66 20 61 20 6d 65 64 69 |ack.. .I|f a medi|
|00004ad0| 61 20 66 61 69 6c 75 72 | 65 20 6f 63 63 75 72 73 |a failur|e occurs|
|00004ae0| 20 6f 6e 20 74 68 65 20 | 73 79 73 74 65 6d 20 64 | on the |system d|
|00004af0| 65 76 73 70 61 63 65 20 | 6f 72 20 61 20 64 61 74 |evspace |or a dat|
|00004b00| 61 20 64 65 76 73 70 61 | 63 65 2c 20 64 61 74 61 |a devspa|ce, data|
|00004b10| 62 61 73 65 20 6f 70 65 | 72 61 74 69 6f 6e 20 65 |base ope|ration e|
|00004b20| 6e 64 73 20 28 75 6e 6c | 65 73 73 20 74 68 65 20 |nds (unl|ess the |
|00004b30| 64 61 74 61 20 64 65 76 | 73 70 61 63 65 73 20 61 |data dev|spaces a|
|00004b40| 6e 64 20 74 68 65 20 73 | 79 73 74 65 6d 20 64 65 |nd the s|ystem de|
|00004b50| 76 73 70 61 63 65 20 61 | 72 65 20 6d 69 72 72 6f |vspace a|re mirro|
|00004b60| 72 65 64 29 2e 20 41 66 | 74 65 72 20 72 65 70 61 |red). Af|ter repa|
|00004b70| 69 72 69 6e 67 20 74 68 | 65 20 6d 65 64 69 61 20 |iring th|e media |
|00004b80| 66 61 69 6c 75 72 65 2c | 20 74 68 65 20 64 61 74 |failure,| the dat|
|00004b90| 61 62 61 73 65 20 6d 75 | 73 74 20 62 65 20 72 65 |abase mu|st be re|
|00004ba0| 63 6f 76 65 72 65 64 20 | 73 74 61 72 74 69 6e 67 |covered |starting|
|00004bb0| 20 77 69 74 68 20 74 68 | 65 20 6c 61 73 74 20 63 | with th|e last c|
|00004bc0| 6f 6d 70 6c 65 74 65 20 | 62 61 63 6b 75 70 20 28 |omplete |backup (|
|00004bd0| 52 45 53 54 4f 52 45 20 | 44 41 54 41 29 2e 20 00 |RESTORE |DATA). .|
|00004be0| 00 b8 03 00 00 8f 03 00 | 00 5e 01 01 00 99 07 01 |........|.^......|
|00004bf0| 00 29 00 00 00 20 20 80 | 1f 07 00 80 00 00 10 00 |.)... .|........|
|00004c00| e3 80 80 0c 00 82 82 82 | 82 ff 00 20 00 49 66 20 |........|... .If |
|00004c10| 74 68 65 20 61 72 63 68 | 69 76 65 20 6c 6f 67 20 |the arch|ive log |
|00004c20| 68 61 64 20 6e 6f 74 20 | 62 65 65 6e 20 73 61 76 |had not |been sav|
|00004c30| 65 64 20 69 6e 20 74 68 | 65 20 6d 65 61 6e 74 69 |ed in th|e meanti|
|00004c40| 6d 65 2c 20 74 68 65 20 | 72 65 73 74 61 72 74 20 |me, the |restart |
|00004c50| 68 61 73 20 74 68 65 20 | 65 66 66 65 63 74 20 74 |has the |effect t|
|00004c60| 68 61 74 20 74 68 65 20 | 64 61 74 61 62 61 73 65 |hat the |database|
|00004c70| 20 6d 6f 64 69 66 69 63 | 61 74 69 6f 6e 73 20 72 | modific|ations r|
|00004c80| 65 63 6f 72 64 65 64 20 | 69 6e 20 74 68 65 20 61 |ecorded |in the a|
|00004c90| 72 63 68 69 76 65 20 6c | 6f 67 20 61 72 65 20 72 |rchive l|og are r|
|00004ca0| 65 61 70 70 6c 69 65 64 | 2c 20 74 68 75 73 20 72 |eapplied|, thus r|
|00004cb0| 65 65 73 74 61 62 6c 69 | 73 68 69 6e 67 20 74 68 |eestabli|shing th|
|00004cc0| 65 20 6c 61 73 74 20 63 | 6f 6e 73 69 73 74 65 6e |e last c|onsisten|
|00004cd0| 74 20 73 74 61 74 65 20 | 6f 66 20 74 68 65 20 64 |t state |of the d|
|00004ce0| 61 74 61 62 61 73 65 2e | 00 20 00 49 66 20 74 68 |atabase.|. .If th|
|00004cf0| 65 20 61 72 63 68 69 76 | 65 20 6c 6f 67 20 68 61 |e archiv|e log ha|
|00004d00| 64 20 62 65 65 6e 20 73 | 61 76 65 64 20 69 6e 20 |d been s|aved in |
|00004d10| 74 68 65 20 6d 65 61 6e | 74 69 6d 65 2c 20 52 45 |the mean|time, RE|
|00004d20| 53 54 4f 52 45 20 44 41 | 54 41 20 6d 75 73 74 20 |STORE DA|TA must |
|00004d30| 62 65 20 70 65 72 66 6f | 72 6d 65 64 20 61 6e 64 |be perfo|rmed and|
|00004d40| 20 74 68 65 20 62 61 63 | 6b 75 70 20 6f 66 20 74 | the bac|kup of t|
|00004d50| 68 65 20 61 72 63 68 69 | 76 65 20 6c 6f 67 20 6d |he archi|ve log m|
|00004d60| 75 73 74 20 62 65 20 72 | 65 73 74 6f 72 65 64 20 |ust be r|estored |
|00004d70| 77 69 74 68 20 52 45 53 | 54 4f 52 45 20 4c 4f 47 |with RES|TORE LOG|
|00004d80| 2e 20 42 75 74 20 62 65 | 66 6f 72 65 20 70 65 72 |. But be|fore per|
|00004d90| 66 6f 72 6d 69 6e 67 20 | 52 45 53 54 4f 52 45 20 |forming |RESTORE |
|00004da0| 4c 4f 47 2c 20 69 74 20 | 69 73 20 65 73 73 65 6e |LOG, it |is essen|
|00004db0| 74 69 61 6c 20 74 6f 20 | 73 61 76 65 20 74 68 65 |tial to |save the|
|00004dc0| 20 63 75 72 72 65 6e 74 | 20 63 6f 6e 74 65 6e 74 | current| content|
|00004dd0| 73 20 6f 66 20 74 68 65 | 20 61 72 63 68 69 76 65 |s of the| archive|
|00004de0| 20 6c 6f 67 20 28 53 41 | 56 45 20 4c 4f 47 20 70 | log (SA|VE LOG p|
|00004df0| 65 72 66 6f 72 6d 65 64 | 20 69 6e 20 43 4f 4c 44 |erformed| in COLD|
|00004e00| 20 6d 6f 64 65 29 2c 20 | 62 65 63 61 75 73 65 20 | mode), |because |
|00004e10| 6f 74 68 65 72 77 69 73 | 65 20 69 74 20 77 6f 75 |otherwis|e it wou|
|00004e20| 6c 64 20 62 65 20 6f 76 | 65 72 77 72 69 74 74 65 |ld be ov|erwritte|
|00004e30| 6e 20 62 79 20 52 45 53 | 54 4f 52 45 20 4c 4f 47 |n by RES|TORE LOG|
|00004e40| 2e 20 49 66 20 73 65 76 | 65 72 61 6c 20 6c 6f 67 |. If sev|eral log|
|00004e50| 20 62 61 63 6b 75 70 73 | 20 68 61 76 65 20 62 65 | backups| have be|
|00004e60| 65 6e 20 6d 61 64 65 20 | 61 66 74 65 72 20 74 68 |en made |after th|
|00004e70| 65 20 63 6f 6d 70 6c 65 | 74 65 20 62 61 63 6b 75 |e comple|te backu|
|00004e80| 70 2c 20 52 45 53 54 4f | 52 45 20 4c 4f 47 20 6d |p, RESTO|RE LOG m|
|00004e90| 75 73 74 20 62 65 20 70 | 65 72 66 6f 72 6d 65 64 |ust be p|erformed|
|00004ea0| 20 77 69 74 68 20 65 61 | 63 68 20 6f 66 20 74 68 | with ea|ch of th|
|00004eb0| 65 73 65 20 6c 6f 67 20 | 62 61 63 6b 75 70 73 2e |ese log |backups.|
|00004ec0| 20 54 68 65 20 6c 61 73 | 74 20 62 61 63 6b 75 70 | The las|t backup|
|00004ed0| 20 74 6f 20 62 65 20 72 | 65 73 74 6f 72 65 64 20 | to be r|estored |
|00004ee0| 63 6f 6e 74 61 69 6e 73 | 20 74 68 65 20 63 75 72 |contains| the cur|
|00004ef0| 72 65 6e 74 20 63 6f 6e | 74 65 6e 74 73 20 6f 66 |rent con|tents of|
|00004f00| 20 74 68 65 20 61 72 63 | 68 69 76 65 20 6c 6f 67 | the arc|hive log|
|00004f10| 2c 20 74 68 75 73 20 70 | 72 6f 64 75 63 69 6e 67 |, thus p|roducing|
|00004f20| 20 74 68 65 20 6c 61 73 | 74 20 63 6f 6e 73 69 73 | the las|t consis|
|00004f30| 74 65 6e 74 20 73 74 61 | 74 65 20 6f 66 20 74 68 |tent sta|te of th|
|00004f40| 65 20 64 61 74 61 62 61 | 73 65 2e 20 41 20 73 75 |e databa|se. A su|
|00004f50| 62 73 65 71 75 65 6e 74 | 20 52 45 53 54 41 52 54 |bsequent| RESTART|
|00004f60| 20 74 68 65 6e 20 65 6e | 61 62 6c 65 73 20 64 61 | then en|ables da|
|00004f70| 74 61 62 61 73 65 20 6f | 70 65 72 61 74 69 6f 6e |tabase o|peration|
|00004f80| 20 28 57 41 52 4d 20 6f | 70 65 72 61 74 69 6e 67 | (WARM o|perating|
|00004f90| 20 6d 6f 64 65 29 2e 00 | 00 6a 03 00 00 41 03 00 | mode)..|.j...A..|
|00004fa0| 00 e1 03 01 00 03 0b 01 | 00 29 00 00 00 20 20 80 |........|.)... .|
|00004fb0| 83 06 00 80 00 00 10 00 | e3 80 80 0c 00 82 82 82 |........|........|
|00004fc0| 82 ff 00 20 00 49 66 20 | 74 68 65 20 64 61 74 61 |... .If |the data|
|00004fd0| 62 61 73 65 20 6e 65 65 | 64 73 20 74 6f 20 62 65 |base nee|ds to be|
|00004fe0| 20 72 65 73 65 74 20 74 | 6f 20 61 20 70 72 65 76 | reset t|o a prev|
|00004ff0| 69 6f 75 73 20 73 74 61 | 74 65 20 66 6f 72 20 6f |ious sta|te for o|
|00005000| 72 67 61 6e 69 7a 61 74 | 69 6f 6e 61 6c 20 72 65 |rganizat|ional re|
|00005010| 61 73 6f 6e 73 2c 20 72 | 65 73 74 6f 72 65 20 74 |asons, r|estore t|
|00005020| 68 65 20 6d 6f 73 74 20 | 72 65 63 65 6e 74 20 63 |he most |recent c|
|00005030| 6f 6d 70 6c 65 74 65 20 | 62 61 63 6b 75 70 20 28 |omplete |backup (|
|00005040| 52 45 53 54 4f 52 45 20 | 44 41 54 41 29 20 74 68 |RESTORE |DATA) th|
|00005050| 61 74 20 77 61 73 20 6d | 61 64 65 20 70 72 65 76 |at was m|ade prev|
|00005060| 69 6f 75 73 20 74 6f 20 | 74 68 65 20 64 65 73 69 |ious to |the desi|
|00005070| 72 65 64 20 64 61 74 65 | 20 61 6e 64 20 74 69 6d |red date| and tim|
|00005080| 65 2c 20 73 61 76 65 20 | 74 68 65 20 63 75 72 72 |e, save |the curr|
|00005090| 65 6e 74 20 61 72 63 68 | 69 76 65 20 6c 6f 67 2c |ent arch|ive log,|
|000050a0| 20 61 6e 64 20 72 65 73 | 74 6f 72 65 20 74 68 65 | and res|tore the|
|000050b0| 20 6c 6f 67 20 62 61 63 | 6b 75 70 73 20 73 75 62 | log bac|kups sub|
|000050c0| 73 65 71 75 65 6e 74 20 | 74 6f 20 74 68 65 20 63 |sequent |to the c|
|000050d0| 6f 6d 70 6c 65 74 65 20 | 62 61 63 6b 75 70 20 28 |omplete |backup (|
|000050e0| 52 45 53 54 4f 52 45 20 | 4c 4f 47 29 2e 20 54 68 |RESTORE |LOG). Th|
|000050f0| 65 20 64 65 73 69 72 65 | 64 20 64 61 74 61 62 61 |e desire|d databa|
|00005100| 73 65 20 73 74 61 74 65 | 20 63 61 6e 20 62 65 20 |se state| can be |
|00005110| 64 65 74 65 72 6d 69 6e | 65 64 20 62 79 20 73 70 |determin|ed by sp|
|00005120| 65 63 69 66 79 69 6e 67 | 20 61 20 64 61 74 65 20 |ecifying| a date |
|00005130| 61 6e 64 20 61 20 74 69 | 6d 65 20 28 52 45 53 54 |and a ti|me (REST|
|00005140| 4f 52 45 20 4c 4f 47 20 | 55 4e 54 49 4c 29 2e 00 |ORE LOG |UNTIL)..|
|00005150| 20 00 41 20 73 69 6d 69 | 6c 61 72 20 70 72 6f 63 | .A simi|lar proc|
|00005160| 65 64 75 72 65 20 69 73 | 20 75 73 65 64 20 74 6f |edure is| used to|
|00005170| 20 72 65 73 74 6f 72 65 | 20 6d 6f 64 69 66 69 65 | restore| modifie|
|00005180| 64 20 64 61 74 61 62 61 | 73 65 20 70 61 67 65 73 |d databa|se pages|
|00005190| 20 69 6e 73 74 65 61 64 | 20 6f 66 20 6c 6f 67 20 | instead| of log |
|000051a0| 62 61 63 6b 75 70 73 2e | 20 49 6e 20 74 68 69 73 |backups.| In this|
|000051b0| 20 63 61 73 65 2c 20 74 | 6f 6f 2c 20 74 68 65 72 | case, t|oo, ther|
|000051c0| 65 20 77 69 6c 6c 20 62 | 65 20 61 20 73 65 71 75 |e will b|e a sequ|
|000051d0| 65 6e 63 65 20 6f 66 20 | 74 61 70 65 73 20 77 72 |ence of |tapes wr|
|000051e0| 69 74 74 65 6e 20 61 66 | 74 65 72 20 74 68 65 20 |itten af|ter the |
|000051f0| 6c 61 73 74 20 63 6f 6d | 70 6c 65 74 65 20 62 61 |last com|plete ba|
|00005200| 63 6b 75 70 20 75 73 69 | 6e 67 20 53 41 56 45 20 |ckup usi|ng SAVE |
|00005210| 50 41 47 45 53 2e 20 54 | 68 65 73 65 20 74 61 70 |PAGES. T|hese tap|
|00005220| 65 73 20 6d 75 73 74 20 | 62 65 20 72 65 73 74 6f |es must |be resto|
|00005230| 72 65 64 20 6f 6e 65 20 | 61 66 74 65 72 20 74 68 |red one |after th|
|00005240| 65 20 6f 74 68 65 72 20 | 75 73 69 6e 67 20 52 45 |e other |using RE|
|00005250| 53 54 4f 52 45 20 50 41 | 47 45 53 2e 20 54 68 65 |STORE PA|GES. The|
|00005260| 20 63 75 72 72 65 6e 74 | 20 63 6f 6e 74 65 6e 74 | current| content|
|00005270| 73 20 6f 66 20 74 68 65 | 20 61 72 63 68 69 76 65 |s of the| archive|
|00005280| 20 6c 6f 67 20 64 6f 20 | 6e 6f 74 20 6e 65 65 64 | log do |not need|
|00005290| 20 74 6f 20 62 65 20 73 | 61 76 65 64 3b 20 73 75 | to be s|aved; su|
|000052a0| 62 73 65 71 75 65 6e 74 | 6c 79 2c 20 64 75 72 69 |bsequent|ly, duri|
|000052b0| 6e 67 20 74 68 65 20 72 | 65 73 74 61 72 74 2c 20 |ng the r|estart, |
|000052c0| 74 68 65 79 20 61 72 65 | 20 75 73 65 64 20 74 6f |they are| used to|
|000052d0| 20 72 65 65 73 74 61 62 | 6c 69 73 68 20 74 68 65 | reestab|lish the|
|000052e0| 20 6c 61 73 74 20 63 6f | 6e 73 69 73 74 65 6e 74 | last co|nsistent|
|000052f0| 20 64 61 74 61 62 61 73 | 65 20 73 74 61 74 65 2e | databas|e state.|
|00005300| 20 00 00 6a 01 00 00 40 | 01 00 00 99 07 01 00 6d | ..j...@|.......m|
|00005310| 0c 01 00 2a 00 00 00 20 | 22 80 81 02 00 80 00 00 |...*... |".......|
|00005320| 10 00 e3 80 80 0c 00 82 | 82 82 82 82 ff 00 20 00 |........|...... .|
|00005330| 49 66 20 61 20 6d 65 64 | 69 61 20 66 61 69 6c 75 |If a med|ia failu|
|00005340| 72 65 20 6f 63 63 75 72 | 73 20 6f 6e 20 74 68 65 |re occur|s on the|
|00005350| 20 74 72 61 6e 73 61 63 | 74 69 6f 6e 20 6c 6f 67 | transac|tion log|
|00005360| 20 64 65 76 73 70 61 63 | 65 20 6f 72 20 61 72 63 | devspac|e or arc|
|00005370| 68 69 76 65 20 6c 6f 67 | 20 64 65 76 73 70 61 63 |hive log| devspac|
|00005380| 65 2c 20 64 61 74 61 62 | 61 73 65 20 6f 70 65 72 |e, datab|ase oper|
|00005390| 61 74 69 6f 6e 20 65 6e | 64 73 20 75 6e 6c 65 73 |ation en|ds unles|
|000053a0| 73 20 74 68 65 20 6c 6f | 67 20 6d 6f 64 65 20 44 |s the lo|g mode D|
|000053b0| 55 41 4c 20 64 65 66 69 | 6e 65 73 20 61 20 6d 69 |UAL defi|nes a mi|
|000053c0| 72 72 6f 72 65 64 20 61 | 72 63 68 69 76 65 20 6c |rrored a|rchive l|
|000053d0| 6f 67 2e 20 41 66 74 65 | 72 20 72 65 70 61 69 72 |og. Afte|r repair|
|000053e0| 69 6e 67 20 74 68 65 20 | 6d 65 64 69 61 20 66 61 |ing the |media fa|
|000053f0| 69 6c 75 72 65 20 61 6e | 64 20 70 65 72 66 6f 72 |ilure an|d perfor|
|00005400| 6d 69 6e 67 20 52 45 53 | 54 4f 52 45 20 4c 4f 47 |ming RES|TORE LOG|
|00005410| 20 46 52 4f 4d 20 44 45 | 56 53 50 41 43 45 20 61 | FROM DE|VSPACE a|
|00005420| 6e 64 20 61 20 73 75 62 | 73 65 71 75 65 6e 74 20 |nd a sub|sequent |
|00005430| 72 65 73 74 61 72 74 2c | 20 74 68 65 20 64 61 74 |restart,| the dat|
|00005440| 61 62 61 73 65 20 69 73 | 20 69 6e 20 61 20 63 6f |abase is| in a co|
|00005450| 6e 73 69 73 74 65 6e 74 | 20 73 74 61 74 65 20 61 |nsistent| state a|
|00005460| 67 61 69 6e 2e 00 20 00 | 20 00 20 00 00 58 00 00 |gain.. .| . ..X..|
|00005470| 00 27 00 00 00 03 0b 01 | 00 c5 0c 01 00 31 00 00 |.'......|.....1..|
|00005480| 00 02 b0 08 00 00 04 00 | 02 00 04 80 02 00 07 00 |........|........|
|00005490| 00 00 c5 0c 01 00 12 0d | 01 00 01 43 01 00 43 6f |........|...C..Co|
|000054a0| 6e 73 69 73 74 65 6e 63 | 79 a0 43 68 65 63 6b a0 |nsistenc|y.Check.|
|000054b0| 61 6e 64 a0 4f 70 74 69 | 6d 69 7a 65 72 a0 53 75 |and.Opti|mizer.Su|
|000054c0| 70 70 6f 72 74 4d 00 00 | 00 2a 00 00 00 6d 0c 01 |pportM..|.*...m..|
|000054d0| 00 12 0d 01 00 23 00 00 | 00 20 16 80 54 00 80 00 |.....#..|. ..T...|
|000054e0| 00 00 00 80 03 00 82 ff | 00 43 6f 6e 73 69 73 74 |........|.Consist|
|000054f0| 65 6e 63 79 a0 43 68 65 | 63 6b a0 61 6e 64 a0 4f |ency.Che|ck.and.O|
|00005500| 70 74 69 6d 69 7a 65 72 | a0 53 75 70 70 6f 72 74 |ptimizer|.Support|
|00005510| 00 00 99 02 00 00 6e 02 | 00 00 c5 0c 01 00 ab 0f |......n.|........|
|00005520| 01 00 2b 00 00 00 20 24 | 80 dd 04 00 80 00 00 10 |..+... $|........|
|00005530| 00 e3 80 80 0c 00 82 82 | 82 82 82 82 ff 00 20 00 |........|...... .|
|00005540| 54 6f 20 65 6e 73 75 72 | 65 20 61 20 73 61 66 65 |To ensur|e a safe|
|00005550| 20 64 61 74 61 62 61 73 | 65 20 6f 70 65 72 61 74 | databas|e operat|
|00005560| 69 6f 6e 20 61 6e 64 20 | 67 6f 6f 64 20 70 65 72 |ion and |good per|
|00005570| 66 6f 72 6d 61 6e 63 65 | 2c 20 74 77 6f 20 6f 74 |formance|, two ot|
|00005580| 68 65 72 20 61 63 74 69 | 76 69 74 69 65 73 20 6d |her acti|vities m|
|00005590| 75 73 74 20 62 65 20 64 | 6f 6e 65 20 66 72 6f 6d |ust be d|one from|
|000055a0| 20 74 69 6d 65 20 74 6f | 20 74 69 6d 65 3a 20 56 | time to| time: V|
|000055b0| 45 52 49 46 59 20 61 6e | 64 20 55 50 44 41 54 45 |ERIFY an|d UPDATE|
|000055c0| 20 53 54 41 54 49 53 54 | 49 43 53 2e 00 20 00 56 | STATIST|ICS.. .V|
|000055d0| 45 52 49 46 59 20 63 61 | 6e 20 62 65 20 65 78 65 |ERIFY ca|n be exe|
|000055e0| 63 75 74 65 64 20 77 68 | 69 6c 65 20 74 68 65 20 |cuted wh|ile the |
|000055f0| 64 61 74 61 62 61 73 65 | 20 69 73 20 6f 70 65 72 |database| is oper|
|00005600| 61 74 69 6f 6e 61 6c 2e | 20 49 74 20 63 68 65 63 |ational.| It chec|
|00005610| 6b 73 20 74 68 65 20 63 | 6f 6e 73 69 73 74 65 6e |ks the c|onsisten|
|00005620| 63 79 20 6f 66 20 69 6e | 74 65 72 6e 61 6c 20 63 |cy of in|ternal c|
|00005630| 68 61 69 6e 73 20 77 69 | 74 68 69 6e 20 74 68 65 |hains wi|thin the|
|00005640| 20 42 2a 20 74 72 65 65 | 73 20 75 73 65 64 2e 20 | B* tree|s used. |
|00005650| 49 66 20 69 6e 63 6f 6e | 73 69 73 74 65 6e 63 69 |If incon|sistenci|
|00005660| 65 73 20 61 72 65 20 64 | 69 73 63 6f 76 65 72 65 |es are d|iscovere|
|00005670| 64 2c 20 74 68 65 20 64 | 61 74 61 62 61 73 65 20 |d, the d|atabase |
|00005680| 6d 75 73 74 20 62 65 20 | 72 65 73 74 6f 72 65 64 |must be |restored|
|00005690| 2e 20 41 20 56 45 52 49 | 46 59 20 69 73 20 72 65 |. A VERI|FY is re|
|000056a0| 63 6f 6d 6d 65 6e 64 65 | 64 20 62 65 66 6f 72 65 |commende|d before|
|000056b0| 20 65 61 63 68 20 63 6f | 6d 70 6c 65 74 65 20 62 | each co|mplete b|
|000056c0| 61 63 6b 75 70 20 6f 66 | 20 74 68 65 20 64 61 74 |ackup of| the dat|
|000056d0| 61 62 61 73 65 2e 00 20 | 00 56 45 52 49 46 59 20 |abase.. |.VERIFY |
|000056e0| 69 6e 20 43 4f 4c 44 20 | 6d 6f 64 65 20 28 69 2e |in COLD |mode (i.|
|000056f0| 65 2e 2c 20 62 65 66 6f | 72 65 20 61 20 52 45 53 |e., befo|re a RES|
|00005700| 54 41 52 54 20 6f 66 20 | 74 68 65 20 53 45 52 56 |TART of |the SERV|
|00005710| 45 52 44 42 29 20 68 61 | 73 20 61 6e 20 61 64 64 |ERDB) ha|s an add|
|00005720| 69 74 69 6f 6e 61 6c 20 | 70 72 6f 70 65 72 74 79 |itional |property|
|00005730| 3a 20 70 61 67 65 73 20 | 77 72 6f 6e 67 6c 79 20 |: pages |wrongly |
|00005740| 72 65 63 6f 72 64 65 64 | 20 61 73 20 75 73 65 64 |recorded| as used|
|00005750| 20 73 69 6e 63 65 20 61 | 6e 20 69 72 72 65 67 75 | since a|n irregu|
|00005760| 6c 61 72 20 65 6e 64 20 | 6f 66 20 64 61 74 61 62 |lar end |of datab|
|00005770| 61 73 65 20 6f 70 65 72 | 61 74 69 6f 6e 20 61 72 |ase oper|ation ar|
|00005780| 65 20 72 65 6c 65 61 73 | 65 64 20 74 6f 20 74 68 |e releas|ed to th|
|00005790| 65 20 66 72 65 65 20 73 | 70 61 63 65 20 6d 61 6e |e free s|pace man|
|000057a0| 61 67 65 6d 65 6e 74 2e | 20 00 00 21 03 00 00 f8 |agement.| ..!....|
|000057b0| 02 00 00 12 0d 01 00 d8 | 42 01 00 29 00 00 00 20 |........|B..)... |
|000057c0| 20 80 f1 05 00 80 00 00 | 10 00 e3 80 80 0c 00 82 | .......|........|
|000057d0| 82 82 82 ff 00 20 00 55 | 50 44 41 54 45 20 53 54 |..... .U|PDATE ST|
|000057e0| 41 54 49 53 54 49 43 53 | 20 64 65 74 65 72 6d 69 |ATISTICS| determi|
|000057f0| 6e 65 73 20 74 68 65 20 | 6e 75 6d 62 65 72 20 6f |nes the |number o|
|00005800| ab 0f 01 00 d8 42 01 00 | 6d 0c 01 00 66 20 72 6f |.....B..|m...f ro|
|00005810| 77 73 20 69 6e 20 74 61 | 62 6c 65 73 20 61 6e 64 |ws in ta|bles and|
|00005820| 20 74 68 65 20 73 65 6c | 65 63 74 69 76 69 74 79 | the sel|ectivity|
|00005830| 20 6f 66 20 69 6e 64 69 | 76 69 64 75 61 6c 20 63 | of indi|vidual c|
|00005840| 6f 6c 75 6d 6e 73 2e 20 | 54 68 65 20 41 44 41 42 |olumns. |The ADAB|
|00005850| 41 53 20 6f 70 74 69 6d | 69 7a 65 72 20 6e 65 65 |AS optim|izer nee|
|00005860| 64 73 20 74 68 65 73 65 | 20 73 70 65 63 69 66 69 |ds these| specifi|
|00005870| 63 61 74 69 6f 6e 73 20 | 74 6f 20 64 65 74 65 72 |cations |to deter|
|00005880| 6d 69 6e 65 20 74 68 65 | 20 62 65 73 74 20 73 74 |mine the| best st|
|00005890| 72 61 74 65 67 79 20 66 | 6f 72 20 74 68 65 20 70 |rategy f|or the p|
|000058a0| 72 6f 63 65 73 73 69 6e | 67 20 6f 66 20 63 6f 6d |rocessin|g of com|
|000058b0| 70 6c 65 78 20 53 51 4c | 20 73 74 61 74 65 6d 65 |plex SQL| stateme|
|000058c0| 6e 74 73 2e 20 49 66 20 | 74 68 65 20 73 69 7a 65 |nts. If |the size|
|000058d0| 73 20 6f 72 20 74 68 65 | 20 76 61 6c 75 65 20 61 |s or the| value a|
|000058e0| 73 73 69 67 6e 6d 65 6e | 74 73 20 69 6e 20 74 68 |ssignmen|ts in th|
|000058f0| 65 20 64 61 74 61 62 61 | 73 65 20 68 61 76 65 20 |e databa|se have |
|00005900| 63 68 61 6e 67 65 64 20 | 63 6f 6e 73 69 64 65 72 |changed |consider|
|00005910| 61 62 6c 79 2c 20 61 20 | 6e 65 77 20 55 50 44 41 |ably, a |new UPDA|
|00005920| 54 45 20 53 54 41 54 49 | 53 54 49 43 53 20 6d 75 |TE STATI|STICS mu|
|00005930| 73 74 20 62 65 20 70 65 | 72 66 6f 72 6d 65 64 2e |st be pe|rformed.|
|00005940| 20 55 50 44 41 54 45 20 | 53 54 41 54 49 53 54 49 | UPDATE |STATISTI|
|00005950| 43 53 20 73 68 6f 75 6c | 64 20 62 65 20 65 78 65 |CS shoul|d be exe|
|00005960| 63 75 74 65 64 20 6f 6e | 63 65 20 61 20 77 65 65 |cuted on|ce a wee|
|00005970| 6b 2e 20 00 20 00 49 66 | 20 41 44 41 42 41 53 20 |k. . .If| ADABAS |
|00005980| 64 65 74 65 72 6d 69 6e | 65 73 20 64 69 66 66 65 |determin|es diffe|
|00005990| 72 65 6e 63 65 73 20 62 | 65 74 77 65 65 6e 20 74 |rences b|etween t|
|000059a0| 68 65 20 6f 70 74 69 6d | 69 7a 65 72 20 61 73 73 |he optim|izer ass|
|000059b0| 75 6d 70 74 69 6f 6e 73 | 20 66 72 6f 6d 20 74 68 |umptions| from th|
|000059c0| 65 20 6c 61 73 74 20 55 | 50 44 41 54 45 20 53 54 |e last U|PDATE ST|
|000059d0| 41 54 49 53 54 49 43 53 | 20 61 6e 64 20 74 68 65 |ATISTICS| and the|
|000059e0| 20 63 75 72 72 65 6e 74 | 20 73 74 61 74 65 20 6f | current| state o|
|000059f0| 66 20 61 20 74 61 62 6c | 65 2c 20 69 74 20 61 74 |f a tabl|e, it at|
|00005a00| 74 65 6d 70 74 73 20 74 | 6f 20 70 65 72 66 6f 72 |tempts t|o perfor|
|00005a10| 6d 20 61 6e 20 69 6d 70 | 6c 69 63 69 74 20 55 50 |m an imp|licit UP|
|00005a20| 44 41 54 45 20 53 54 41 | 54 49 53 54 49 43 53 2e |DATE STA|TISTICS.|
|00005a30| 20 49 66 20 74 68 65 72 | 65 20 61 72 65 20 63 6f | If ther|e are co|
|00005a40| 6e 66 6c 69 63 74 69 6e | 67 20 6c 6f 63 6b 73 2c |nflictin|g locks,|
|00005a50| 20 74 68 69 73 20 61 74 | 74 65 6d 70 74 20 6d 69 | this at|tempt mi|
|00005a60| 67 68 74 20 62 65 20 61 | 62 6f 72 74 65 64 2c 20 |ght be a|borted, |
|00005a70| 73 6f 20 74 68 61 74 20 | 74 68 65 20 69 6d 70 6c |so that |the impl|
|00005a80| 69 63 69 74 20 55 50 44 | 41 54 45 20 53 54 41 54 |icit UPD|ATE STAT|
|00005a90| 49 53 54 49 43 53 20 69 | 73 20 6e 6f 74 20 61 20 |ISTICS i|s not a |
|00005aa0| 63 6f 6d 70 6c 65 74 65 | 20 65 71 75 69 76 61 6c |complete| equival|
|00005ab0| 65 6e 74 20 6f 66 20 74 | 68 65 20 65 78 70 6c 69 |ent of t|he expli|
|00005ac0| 63 69 74 20 55 50 44 41 | 54 45 20 53 54 41 54 49 |cit UPDA|TE STATI|
|00005ad0| 53 54 49 43 53 2e 00 00 | 29 00 00 00 04 00 00 00 |STICS...|).......|
|00005ae0| ab 0f 01 00 01 43 01 00 | 25 00 00 00 20 1a 80 08 |.....C..|%... ...|
|00005af0| 00 80 00 00 10 00 e3 80 | 80 0c 00 82 ff 00 20 00 |........|...... .|
|00005b00| 00 37 00 00 00 06 00 00 | 00 d8 42 01 00 38 43 01 |.7......|..B..8C.|
|00005b10| 00 31 00 00 00 02 d5 09 | 00 00 78 0a 02 00 bb 87 |.1......|..x.....|
|00005b20| 02 00 08 00 00 00 38 43 | 01 00 64 43 01 00 08 4d |......8C|..dC...M|
|00005b30| 01 00 43 61 63 68 65 73 | 2c 00 00 00 09 00 00 00 |..Caches|,.......|
|00005b40| 01 43 01 00 64 43 01 00 | 23 00 00 00 20 16 80 12 |.C..dC..|#... ...|
|00005b50| 00 80 00 00 00 00 80 03 | 00 82 ff 00 43 61 63 68 |........|....Cach|
|00005b60| 65 73 00 00 fc 00 00 00 | d4 00 00 00 38 43 01 00 |es......|....8C..|
|00005b70| 60 44 01 00 28 00 00 00 | 20 1e 80 a9 01 00 80 00 |`D..(...| .......|
|00005b80| 00 10 00 e3 80 80 0c 00 | 82 82 82 ff 00 20 00 52 |........|..... .R|
|00005b90| 65 61 64 20 61 6e 64 20 | 77 72 69 74 65 20 6f 70 |ead and |write op|
|00005ba0| 65 72 61 74 69 6f 6e 73 | 20 74 6f 20 74 68 65 20 |erations| to the |
|00005bb0| 64 65 76 73 70 61 63 65 | 73 20 61 72 65 20 62 75 |devspace|s are bu|
|00005bc0| 66 66 65 72 65 64 20 69 | 6e 20 6f 72 64 65 72 20 |ffered i|n order |
|00005bd0| 74 6f 20 73 61 76 65 20 | 64 69 73 6b 20 61 63 63 |to save |disk acc|
|00005be0| 65 73 73 65 73 2e 20 54 | 68 65 20 70 65 72 74 69 |esses. T|he perti|
|00005bf0| 6e 65 6e 74 20 6d 61 69 | 6e 20 6d 65 6d 6f 72 79 |nent mai|n memory|
|00005c00| 20 73 74 72 75 63 74 75 | 72 65 73 20 61 72 65 20 | structu|res are |
|00005c10| 63 61 6c 6c 65 64 20 63 | 61 63 68 65 73 2e 20 54 |called c|aches. T|
|00005c20| 68 65 79 20 63 61 6e 20 | 62 65 20 64 69 6d 65 6e |hey can |be dimen|
|00005c30| 73 69 6f 6e 65 64 2e 20 | 41 44 41 42 41 53 20 64 |sioned. |ADABAS d|
|00005c40| 65 66 69 6e 65 73 20 74 | 68 65 20 66 6f 6c 6c 6f |efines t|he follo|
|00005c50| 77 69 6e 67 20 63 61 63 | 68 65 73 3a 00 20 00 00 |wing cac|hes:. ..|
|00005c60| 09 01 00 00 dd 00 00 00 | 64 43 01 00 69 45 01 00 |........|dC..iE..|
|00005c70| 2c 00 00 00 20 26 80 bb | 01 00 80 00 00 50 02 a9 |,... &..|.....P..|
|00005c80| 82 3d 7e 82 a9 02 80 0c | 00 83 82 ff 00 44 61 74 |.=~.....|.....Dat|
|00005c90| 61 20 43 61 63 68 65 3a | 00 54 68 69 73 20 63 61 |a Cache:|.This ca|
|00005ca0| 63 68 65 20 63 6f 6e 74 | 61 69 6e 73 20 74 68 65 |che cont|ains the|
|00005cb0| 20 6c 61 73 74 20 72 65 | 61 64 2d 20 6f 72 20 77 | last re|ad- or w|
|00005cc0| 72 69 74 65 2d 61 63 63 | 65 73 73 65 64 20 70 61 |rite-acc|essed pa|
|00005cd0| 67 65 73 20 6f 66 20 74 | 68 65 20 64 61 74 61 20 |ges of t|he data |
|00005ce0| 64 65 76 73 70 61 63 65 | 73 2e 20 54 68 65 20 64 |devspace|s. The d|
|00005cf0| 61 74 61 20 63 61 63 68 | 65 20 69 73 20 73 68 61 |ata cach|e is sha|
|00005d00| 72 65 64 20 62 79 20 61 | 6c 6c 20 73 69 6d 75 6c |red by a|ll simul|
|00005d10| 74 61 6e 65 6f 75 73 6c | 79 20 61 63 74 69 76 65 |taneousl|y active|
|00005d20| 20 75 73 65 72 73 2e 20 | 54 68 65 20 68 69 74 20 | users. |The hit |
|00005d30| 72 61 74 65 20 69 6e 20 | 74 68 65 20 64 61 74 61 |rate in |the data|
|00005d40| 20 63 61 63 68 65 20 69 | 73 20 64 65 63 69 73 69 | cache i|s decisi|
|00005d50| 76 65 20 66 6f 72 20 74 | 68 65 20 70 65 72 66 6f |ve for t|he perfo|
|00005d60| 72 6d 61 6e 63 65 2e 00 | 00 2b 00 00 00 04 00 00 |rmance..|.+......|
|00005d70| 00 60 44 01 00 94 45 01 | 00 27 00 00 00 20 1e 80 |.`D...E.|.'... ..|
|00005d80| 08 00 80 00 00 50 00 a9 | 82 3d 7e 80 0c 00 82 ff |.....P..|.=~.....|
|00005d90| 00 20 00 00 80 01 00 00 | 54 01 00 00 69 45 01 00 |. ......|T...iE..|
|00005da0| 14 47 01 00 2c 00 00 00 | 20 26 80 a9 02 00 80 00 |.G..,...| &......|
|00005db0| 00 50 02 a9 82 3d 7e 82 | a9 02 80 0c 00 83 82 ff |.P...=~.|........|
|00005dc0| 00 43 6f 6e 76 65 72 74 | 65 72 20 43 61 63 68 65 |.Convert|er Cache|
|00005dd0| 3a 00 54 68 65 20 63 6f | 6e 76 65 72 74 65 72 20 |:.The co|nverter |
|00005de0| 63 61 63 68 65 20 61 6e | 64 20 69 74 73 20 68 69 |cache an|d its hi|
|00005df0| 74 20 72 61 74 65 20 61 | 72 65 20 61 6c 73 6f 20 |t rate a|re also |
|00005e00| 64 65 63 69 73 69 76 65 | 20 66 6f 72 20 74 68 65 |decisive| for the|
|00005e10| 20 70 65 72 66 6f 72 6d | 61 6e 63 65 2e 20 54 68 | perform|ance. Th|
|00005e20| 65 20 63 6f 6e 76 65 72 | 74 65 72 20 63 61 63 68 |e conver|ter cach|
|00005e30| 65 20 63 6f 6e 74 61 69 | 6e 73 20 74 68 65 20 6c |e contai|ns the l|
|00005e40| 61 73 74 20 72 65 61 64 | 2d 20 6f 72 20 77 72 69 |ast read|- or wri|
|00005e50| 74 65 2d 61 63 63 65 73 | 73 65 64 20 70 61 67 65 |te-acces|sed page|
|00005e60| 73 20 6f 66 20 74 68 65 | 20 73 79 73 74 65 6d 20 |s of the| system |
|00005e70| 64 65 76 73 70 61 63 65 | 2e 20 54 68 65 20 63 6f |devspace|. The co|
|00005e80| 6e 76 65 72 74 65 72 20 | 63 61 63 68 65 20 69 73 |nverter |cache is|
|00005e90| 20 73 68 61 72 65 64 20 | 62 79 20 61 6c 6c 20 73 | shared |by all s|
|00005ea0| 69 6d 75 6c 74 61 6e 65 | 6f 75 73 6c 79 20 61 63 |imultane|ously ac|
|00005eb0| 74 69 76 65 20 75 73 65 | 72 73 2e 20 46 6f 72 20 |tive use|rs. For |
|00005ec0| 74 68 65 20 63 6f 6e 76 | 65 72 74 65 72 20 63 61 |the conv|erter ca|
|00005ed0| 63 68 65 2c 20 79 6f 75 | 20 73 68 6f 75 6c 64 20 |che, you| should |
|00005ee0| 73 74 72 69 76 65 20 66 | 6f 72 20 68 69 74 20 72 |strive f|or hit r|
|00005ef0| 61 74 65 73 20 61 73 20 | 63 6c 6f 73 65 20 74 6f |ates as |close to|
|00005f00| 20 31 30 30 25 20 61 73 | 20 70 6f 73 73 69 62 6c | 100% as| possibl|
|00005f10| 65 2e 00 00 2b 00 00 00 | 04 00 00 00 94 45 01 00 |e...+...|.....E..|
|00005f20| 3f 47 01 00 27 00 00 00 | 20 1e 80 08 00 80 00 00 |?G..'...| .......|
|00005f30| 50 00 a9 82 3d 7e 80 0c | 00 82 ff 00 20 00 00 e1 |P...=~..|.... ...|
|00005f40| 00 00 00 b5 00 00 00 14 | 47 01 00 20 48 01 00 2c |........|G.. H..,|
|00005f50| 00 00 00 20 26 80 6b 01 | 00 80 00 00 50 02 a9 82 |... &.k.|....P...|
|00005f60| 3d 7e 82 a9 02 80 0c 00 | 83 82 ff 00 50 72 6f 63 |=~......|....Proc|
|00005f70| 20 43 6f 64 65 20 43 61 | 63 68 65 3a 00 54 68 69 | Code Ca|che:.Thi|
|00005f80| 73 20 73 74 72 75 63 74 | 75 72 65 20 63 6f 6e 74 |s struct|ure cont|
|00005f90| 61 69 6e 73 20 74 68 65 | 20 63 6f 64 65 20 6f 66 |ains the| code of|
|00005fa0| 20 74 68 65 20 6c 61 73 | 74 20 65 78 65 63 75 74 | the las|t execut|
|00005fb0| 65 64 20 44 42 20 70 72 | 6f 63 65 64 75 72 65 73 |ed DB pr|ocedures|
|00005fc0| 2c 20 74 72 69 67 67 65 | 72 73 2c 20 6f 72 20 44 |, trigge|rs, or D|
|00005fd0| 42 20 66 75 6e 63 74 69 | 6f 6e 73 2e 20 54 68 65 |B functi|ons. The|
|00005fe0| 20 70 72 6f 63 20 63 6f | 64 65 20 63 61 63 68 65 | proc co|de cache|
|00005ff0| 20 69 73 20 73 68 61 72 | 65 64 20 62 79 20 61 6c | is shar|ed by al|
|00006000| 6c 20 73 69 6d 75 6c 74 | 61 6e 65 6f 75 73 6c 79 |l simult|aneously|
|00006010| 20 61 63 74 69 76 65 20 | 75 73 65 72 73 2e 00 00 | active |users...|
|00006020| 2b 00 00 00 04 00 00 00 | 3f 47 01 00 4b 48 01 00 |+.......|?G..KH..|
|00006030| 27 00 00 00 20 1e 80 08 | 00 80 00 00 50 00 a9 82 |'... ...|....P...|
|00006040| 3d 7e 80 0c 00 82 ff 00 | 20 00 00 f8 00 00 00 cc |=~......| .......|
|00006050| 00 00 00 20 48 01 00 43 | 49 01 00 2c 00 00 00 20 |... H..C|I..,... |
|00006060| 26 80 99 01 00 80 00 00 | 50 02 a9 82 3d 7e 82 a9 |&.......|P...=~..|
|00006070| 02 80 0c 00 83 82 ff 00 | 50 72 6f 63 20 44 61 74 |........|Proc Dat|
|00006080| 61 20 43 61 63 68 65 3a | 00 54 68 69 73 20 63 61 |a Cache:|.This ca|
|00006090| 63 68 65 20 65 78 69 73 | 74 73 20 66 6f 72 20 65 |che exis|ts for e|
|000060a0| 61 63 68 20 61 63 74 69 | 76 65 20 75 73 65 72 20 |ach acti|ve user |
|000060b0| 28 6f 72 20 66 6f 72 20 | 65 61 63 68 20 64 61 74 |(or for |each dat|
|000060c0| 61 62 61 73 65 20 73 65 | 73 73 69 6f 6e 29 2e 20 |abase se|ssion). |
|000060d0| 49 74 20 63 6f 6e 74 61 | 69 6e 73 20 74 68 65 20 |It conta|ins the |
|000060e0| 70 61 72 61 6d 65 74 65 | 72 73 20 6f 72 20 76 61 |paramete|rs or va|
|000060f0| 72 69 61 62 6c 65 73 20 | 62 65 6c 6f 6e 67 69 6e |riables |belongin|
|00006100| 67 20 74 6f 20 74 68 65 | 20 6c 61 73 74 20 65 78 |g to the| last ex|
|00006110| 65 63 75 74 65 64 20 44 | 42 20 70 72 6f 63 65 64 |ecuted D|B proced|
|00006120| 75 72 65 73 2c 20 74 72 | 69 67 67 65 72 73 2c 20 |ures, tr|iggers, |
|00006130| 61 6e 64 20 44 42 20 66 | 75 6e 63 74 69 6f 6e 73 |and DB f|unctions|
|00006140| 2e 00 00 2b 00 00 00 04 | 00 00 00 4b 48 01 00 6e |...+....|...KH..n|
|00006150| 49 01 00 27 00 00 00 20 | 1e 80 08 00 80 00 00 50 |I..'... |.......P|
|00006160| 00 a9 82 3d 7e 80 0c 00 | 82 ff 00 20 00 00 3c 02 |...=~...|... ..<.|
|00006170| 00 00 0d 02 00 00 43 49 | 01 00 aa 4b 01 00 2f 00 |......CI|...K../.|
|00006180| 00 00 20 2c 80 1b 04 00 | 80 00 00 50 02 a9 82 3d |.. ,....|...P...=|
|00006190| 7e 82 a9 02 80 0c 00 83 | 82 82 83 82 ff 00 43 61 |~.......|......Ca|
|000061a0| 74 61 6c 6f 67 20 43 61 | 63 68 65 3a 00 54 68 69 |talog Ca|che:.Thi|
|000061b0| 73 20 63 61 63 68 65 20 | 65 78 69 73 74 73 20 66 |s cache |exists f|
|000061c0| 6f 72 20 65 61 63 68 20 | 61 63 74 69 76 65 20 75 |or each |active u|
|000061d0| 73 65 72 20 28 6f 72 20 | 66 6f 72 20 65 61 63 68 |ser (or |for each|
|000061e0| 20 64 61 74 61 62 61 73 | 65 20 73 65 73 73 69 6f | databas|e sessio|
|000061f0| 6e 29 2e 20 49 74 20 63 | 6f 6e 74 61 69 6e 73 20 |n). It c|ontains |
|00006200| 74 68 65 20 6c 61 73 74 | 20 63 61 74 61 6c 6f 67 |the last| catalog|
|00006210| 20 6f 62 6a 65 63 74 73 | 20 75 73 65 64 20 62 79 | objects| used by|
|00006220| 20 61 20 64 61 74 61 62 | 61 73 65 20 73 65 73 73 | a datab|ase sess|
|00006230| 69 6f 6e 20 61 6e 64 20 | 74 68 65 20 69 6e 74 65 |ion and |the inte|
|00006240| 72 6e 61 6c 20 72 65 70 | 72 65 73 65 6e 74 61 74 |rnal rep|resentat|
|00006250| 69 6f 6e 20 28 61 70 70 | 6c 69 63 61 74 69 6f 6e |ion (app|lication|
|00006260| 20 70 6c 61 6e 73 29 20 | 6f 66 20 74 68 65 20 6c | plans) |of the l|
|00006270| 61 73 74 20 65 78 65 63 | 75 74 65 64 20 63 6f 6d |ast exec|uted com|
|00006280| 6d 61 6e 64 73 2e 20 44 | 69 73 70 6c 61 63 65 6d |mands. D|isplacem|
|00006290| 65 6e 74 73 20 66 72 6f | 6d 20 74 68 65 20 63 61 |ents fro|m the ca|
|000062a0| 74 61 6c 6f 67 20 63 61 | 63 68 65 20 66 69 72 73 |talog ca|che firs|
|000062b0| 74 20 6d 6f 76 65 20 74 | 68 65 20 64 61 74 61 20 |t move t|he data |
|000062c0| 69 6e 74 6f 20 74 68 65 | 20 64 61 74 61 20 63 61 |into the| data ca|
|000062d0| 63 68 65 2e 00 20 00 54 | 65 6d 70 20 43 61 63 68 |che.. .T|emp Cach|
|000062e0| 65 3a 00 54 68 69 73 20 | 63 61 63 68 65 20 65 78 |e:.This |cache ex|
|000062f0| 69 73 74 73 20 66 6f 72 | 20 65 61 63 68 20 61 63 |ists for| each ac|
|00006300| 74 69 76 65 20 75 73 65 | 72 20 28 6f 72 20 66 6f |tive use|r (or fo|
|00006310| 72 20 65 61 63 68 20 64 | 61 74 61 62 61 73 65 20 |r each d|atabase |
|00006320| 73 65 73 73 69 6f 6e 29 | 2e 20 49 74 20 63 6f 6e |session)|. It con|
|00006330| 74 61 69 6e 73 20 74 68 | 65 20 6c 61 73 74 20 64 |tains th|e last d|
|00006340| 61 74 61 62 61 73 65 20 | 6f 62 6a 65 63 74 73 20 |atabase |objects |
|00006350| 28 53 45 4c 45 43 54 20 | 72 65 73 75 6c 74 73 2c |(SELECT |results,|
|00006360| 20 74 65 6d 70 6f 72 61 | 72 79 20 74 61 62 6c 65 | tempora|ry table|
|00006370| 73 29 20 67 65 6e 65 72 | 61 74 65 64 20 6f 72 20 |s) gener|ated or |
|00006380| 74 65 6d 70 6f 72 61 72 | 69 6c 79 20 75 73 65 64 |temporar|ily used|
|00006390| 20 62 79 20 61 20 64 61 | 74 61 62 61 73 65 20 73 | by a da|tabase s|
|000063a0| 65 73 73 69 6f 6e 2e 20 | 00 00 2f 01 00 00 03 01 |ession. |../.....|
|000063b0| 00 00 6e 49 01 00 d9 4c | 01 00 2c 00 00 00 20 26 |..nI...L|..,... &|
|000063c0| 80 07 02 00 80 00 00 50 | 02 a9 82 3d 7e 82 a9 02 |.......P|...=~...|
|000063d0| 80 0c 00 83 82 ff 00 00 | 41 70 70 6c 69 63 61 74 |........|Applicat|
|000063e0| 69 6f 6e 73 20 74 68 61 | 74 20 67 65 6e 65 72 61 |ions tha|t genera|
|000063f0| 74 65 20 6c 61 72 67 65 | 20 6a 6f 69 6e 20 72 65 |te large| join re|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.