Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


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: 8

Extract 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
Mimer SQL System Management Handbook TOC PREV NEXT INDEX