The output sample shown in Table 6 shows the audit trail of events on Extended Parallel Server, one of which requires more than one record to completely describe the event.
| xps|2|2000-01-29 03:23:51.000|smart|2234|dragon|sunny|0:OPDB:sysmaster:0:- |
|---|
| xps|2|2000-01-29 03:24:23.000|smart|2234|dragon|sunny|0:SLCT:1:1:select * from customers; |
| xps|2|2000-01-29 03:26:53.000|smart|2234|dragon|sunny|0:SLCT:1:1:select items.stock_num, items.price, orders.order_num, items.manu_code from items, orders where item.price > 1000 and item.manu_code = 'abcdefghijklmnopqrstuvwxyz123456789012345678901234abcdefghijklmnopqrs |
| xps|2|2000-01-29 03:26:53.000|smart|2234|dragon|sunny|0:SLCT:1:2: stuvwxyz123456789012'; |
| xps|2|2000-01-29 03:30:15.000|smart|2234|dragon|sunny|0:SLCT:0:1:select count(stock_num) from item; |
During this audit trail, three cursor SELECT events occurred. The first and third event execute short queries whose contents fit into the additional field. Each of these events generates a single audit record with the flag field set to 1. The second SELECT event, however, executes a much longer query that requires two audit records to include all of its information. The flag field in the first record is set to 1, while the flag field in the second record is set to 2.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]