Utility to know the details of database calls

Hi all,

Is there any utility we can use to know the details of database calls issued by a batch Natural program and act on improving the performance of the details from the utility?


You can use the TEST DBLOG facility to report the database calls made. There is a post elsewhere that talks about how to get the log in batch (it works best online).

Beyond that, you are looking for tools on the Adabas database that look at the Adabas Command Log, such as Adabas Review, that will allow you to monitor the activity of anything calling the database and summarize or report on the details of interest to you. Adabas command log reports can include the number of I/Os, estimated CPU usage, descriptors updated and so on.