# Utility to know the details of database calls

**URL:** <https://techcommunity.softwareag.com/t/utility-to-know-the-details-of-database-calls/92911>\
**Category:** Forum\
**Tags:** Adabas-Natural, Natural, Natural-Utilities\
**Created:** [March 1, 2010, 6:51pm UTC](https://techcommunity.softwareag.com/t/utility-to-know-the-details-of-database-calls/92911 "2010-03-01T18:51:17Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bala6](https://avatars.discourse-cdn.com/v4/letter/b/7c8e57/32.png) [@Bala6](https://techcommunity.softwareag.com/u/Bala6)\
**Post date:** [March 1, 2010, 6:51pm UTC](https://techcommunity.softwareag.com/t/utility-to-know-the-details-of-database-calls/92911/1 "2010-03-01T18:51:17Z")

</div>

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?

Regards,  
Bala

---

<div class="post-metadata">

**Author:** ![Douglas\_Kelly](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/douglas_kelly/32/102_2.png) [@Douglas\_Kelly](https://techcommunity.softwareag.com/u/Douglas_Kelly)\
**Post date:** [March 1, 2010, 7:30pm UTC](https://techcommunity.softwareag.com/t/utility-to-know-the-details-of-database-calls/92911/2 "2010-03-01T19:30:53Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 2:58pm UTC](https://techcommunity.softwareag.com/t/utility-to-know-the-details-of-database-calls/92911/3 "2021-04-02T14:58:07Z")

</div>