|
|
|
|
|
|
Output Format
The output from the READLOG functionality is divided into transactions, showing the date and time, the ident performing the transaction (with entered program idents where appropriate) and the number of database records read during the transaction.
Note: The output does not contain statements for reconstructing the logged operations - it is simply a documentary record of the transactions performed on the database
If list operations 6 or 7 (select by "Specified tables" or "Tables in databank") are selected, the contents of the affected rows in the table are displayed. Insert and delete operations are listed as a single row. Update operations are recorded as the state of the row before and after the update.
If the list operation 8 is selected, "All (no data)", the operations are listed without the data records.
The following example uses the READLOG functionality to list all the transactions that have been committed between 2000-09 and 2000-11 and shows extracts from the output for "All (no data)".
-- Read log -- List definitions List restrictions List operations Change program id ---------------- ----------------- --------------- ----------------- 1. Log list file 3. Time interval 6. Specified tables 9. Enter program 2. Log list width 4. Ident 7. Tables in databank 10. Leave program 5. Databank 8. All (no data) 0. EXIT Select: 1 Log list file: LOGFILE -- Read log -- List definitions List restrictions List operations Change program id ---------------- ----------------- --------------- ----------------- ... Select: 3 Format : YYYYMMDDHHMMSS Starttime: 200005231055 Endtime : 200005231200 -- Read log -- List definitions List restrictions List operations Change program id ---------------- ----------------- --------------- ----------------- ... Select: 8Extract from output "All (no data)":
Transno Function ----------------------------------------------------------------------------- 106 Update before in HOTELADM.FREEROOMS 106 Update after in HOTELADM.FREEROOMS 106 Delete from HOTELADM.MAINTENANCE 106 Delete from foreign key 106 Commit 2000-05-23 11:06:59:74 by HOTELADM/CHARLIE Read 6 ----------------------------------------------------------------------------- 107 Insert into HOTELADM.CHARGES 107 Update before in HOTELADM.BOOK_GUEST 107 Update after in HOTELADM.BOOK_GUEST 107 Commit 2000-05-23 11:08:00:45 by HOTELADM/GEORGE Read 5 ----------------------------------------------------------------------------- -- Read log -- List definitions List restrictions List operations Change program id ---------------- ----------------- --------------- ----------------- 1. Log list file 3. Time interval 6. Specified tables 9. Enter program 2. Log list width 4. Ident 7. Tables in databank 10. Leave program 5. Databank 8. All (no data) 0. EXIT Select: 6 Table: BOOK_GUEST Table:Extract from output for table BOOK_GUEST:
Table HOTELADM.BOOK_GUEST Transno Function ________________________________________________________________________________ 618 Create table 618 Commit 2000-10-23 16:41:35:68 by HOTELADM Read 69 ________________________________________________________________________________ 815 Insert 1356, '2000-08-13', 'SKY', 'SDBLB', 'M & D AB', '0350-19738', 'ERIK', 'ANDERSSON', '2000-10-22', '2000-10-25', 'ERIKA', 'ANDERSSON', 'PARKV. 126, SVEDALA', '2000-10-22', <NULL>, 'SKY124', <NULL> 815 Commit 2000-10-23 16:41:55:22 by HOTELADM Read 3 ________________________________________________________________________________ 816 Insert 1357, '2000-08-13', 'SKY', 'NSDBLB', 'M & D AB', '0350-19738', 'ERIK', 'ANDERSSON', '2000-10-22', '2000-10-24', 'FRED', 'NILSSON', 'BLOMGATAN 15B, SVEDALA', '2000-10-23', <NULL>, 'LAP201', <NULL> 816 Commit 2000-10-23 16:41:55:36 by HOTELADM Read 3 ________________________________________________________________________________ 817 Insert 1369, '2000-08-19', 'WIND', 'NSDBLS', 'ALEX OLSSON', '018-298573', 'ALEX', 'OLSSON', '2000-10-23', '2000-10-25', 'ALEX', 'OLSSON', 'TORSGATAN 12, UPPSALA', '2000-10-23', <NULL>, 'WIND401', <NULL> 817 Commit 2000-10-23 16:41:55:50 by HOTELADM Read 3 ________________________________________________________________________________ 818 Insert 1370, '2000-08-19', 'WIND', 'NSDBLS', 'ALEX OLSSON', '018-298573', 'ALEX', 'OLSSON', '2000-10-20', '2000-10-25', 'KERSTIN', 'OLSSON', 'TORSGATAN 12, UPPSALA', '2000-10-20', <NULL>, 'WIND402', <NULL> 818 Commit 2000-10-23 16:41:55:64 by HOTELADM Read 3 ________________________________________________________________________________ 1191 Update before 1349, '2000-08-11', 'LAP', 'NSSGLS', 'MIMER AB', '018-185210', 'MATS', 'LINDBLOM', '2000-08-31', '2000-09-01', 'STEFAN', 'HANSEN', 'IDUNGATAN 24, UPPSALA', '2000-08-31', '2000-09-01', 'LAP206', 'EUROCARD' 1191 Update after 1349, '2000-08-11', 'LAP', 'NSSGLS', 'MIMER AB', '018-185210', 'MATS', 'LINDBLOM', '2000-08-31', '2000-09-01', 'STEFAN', 'HANSEN', 'IDUNGATAN 24, UPPSALA', '2000-08-31', '2000-09-01', 'LAP205', 'EUROCARD' 1191 Commit 2000-10-23 16:52:21:05 by HOTELADM Read 2 ________________________________________________________________________________ 1192 Update before 1350, '2000-08-12', 'SKY', 'SDBLB', 'SALLY WEBERT', '0760-57609', 'SALLY', 'WEBERT', '2000-10-22', '2000-10-25', 'SALLY', 'WEBERT', 'KRONPARKEN 44, JOKKMOKK', '2000-10-22', '2000-10-23', 'SKY212', 'CASH' 1192 Update after 1350, '2000-08-12', 'SKY', 'SDBLB', 'SALLY WEBERT', '0760-57609', 'SALLY', 'WEBERT', '2000-10-22', '2000-10-25', 'SALLY', 'WEBERT', 'KRONPARKEN 44, JOKKMOKK', '2000-10-22', '2000-10-23', 'SKY210', 'CASH' 1192 Commit 2000-10-23 16:53:04:76 by HOTELADM Read 2 ________________________________________________________________________________
 Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se |
|
|
|
|
|
|