Stellar Log Analyzer for SQL Anywhere
Stellar Log Analyzer for SQL Anywhere
With Stellar Log Analyzer for SQL Anywhere you can view complete transactions and log details of any SQL Anywhere log file. The details can be sorted according to the transaction type, time, transaction name etc of the transactions. With this software you can also view the query details and records of any particular transaction.
Run Stellar Log Analyzer for SQL Anywhere.
See Select SQL Anywhere Log File, to know how to select SQL Anywhere log file.
Click Analyze.
All the tables of the selected log file will be displayed in the left pane. Select the desired table to view its corresponding log transactions. The transactions of the selected table are displayed in the right pane.
The log transactions can be sorted according to Transaction Type, Time, Transaction Name, Table Name and Query.
To view the transaction details, click on a particular transaction. A Query Detail window appears with the transaction details i.e. Transaction Type, Transaction Name, Transaction Time, Transaction Table and Query.
Click OK to close the Query detail window.
Also, at the bottom under Data View pane the transaction data of the selected transaction is shown. Transaction Type are of following types:
Insert: The data that is inserted in the table is shown.
Update: The data that is replaced with the old data in the table is shown.
Delete: The data that is removed from the table is shown.
Note: Perform analysis process on the copy of database and log file. Also make sure SQL Anywhere is running during the saving process.
Note: Data View is not available for Create/Drop/Alter objects. Only Query Detail appears.
Note: The software provides options to save Log data file, to know more refer to Save Log File.
.