# Is there a service function to "ping" defined data servers?

**URL:** <https://techcommunity.softwareag.com/t/is-there-a-service-function-to-ping-defined-data-servers/208180>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-Add-on-Products, SQL-Access, Mainframe-Integration, CONNX\
**Created:** [May 11, 2020, 6:27pm UTC](https://techcommunity.softwareag.com/t/is-there-a-service-function-to-ping-defined-data-servers/208180 "2020-05-11T18:27:50Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ChristianHeld](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/christianheld/32/138_2.png) [@ChristianHeld](https://techcommunity.softwareag.com/u/ChristianHeld)\
**Post date:** [May 11, 2020, 6:27pm UTC](https://techcommunity.softwareag.com/t/is-there-a-service-function-to-ping-defined-data-servers/208180/1 "2020-05-11T18:27:50Z")

</div>

Hello

I have a simple question.

ACE offers a set of “service” functions which retrieve internal JDBC data.  
Examples:

SELECT  
CNXCURRENTCONNECTIONS()  
,CNXPEAKCONNECTIONS()  
,CNXTOTALCONNECTIONS()  
,CNXCURRENTSTATEMENTS()  
,CNXPEAKSTATEMENTS()  
,CNXTOTALSTATEMENTS()

Is there a “service” function available which checks whether defined data servers are “up and running”?  
I ask for something like a “ping” with no real data access.

Background:  
If you define multiple data servers für a data base (either as failover or for load balancing), it would be nice to know if these data servers are really “up and running”. I thinks about monitoring etc.

Any feedback is welcomed.  
Kind regards Christian

---

<div class="post-metadata">

**Author:** ![Bill\_Luton1](https://avatars.discourse-cdn.com/v4/letter/b/71e660/32.png) [@Bill\_Luton1](https://techcommunity.softwareag.com/u/Bill_Luton1)\
**Post date:** [June 1, 2020, 3:30pm UTC](https://techcommunity.softwareag.com/t/is-there-a-service-function-to-ping-defined-data-servers/208180/2 "2020-06-01T15:30:23Z")

</div>

The {serverlist} extension will show the list of active Adabas connections. Is this what you are looking for? The syntax is  
select 1 {serverlist}

You can run it from InfoNaut to see what the output looks like.

---

<div class="post-metadata">

**Author:** ![ChristianHeld](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/christianheld/32/138_2.png) [@ChristianHeld](https://techcommunity.softwareag.com/u/ChristianHeld)\
**Post date:** [June 3, 2020, 8:20pm UTC](https://techcommunity.softwareag.com/t/is-there-a-service-function-to-ping-defined-data-servers/208180/3 "2020-06-03T20:20:14Z")

</div>

Hello Bill

Thx for your reference.  
As we are a Mainframe data center we do not use Infonaut at all.  
I’ll try to get the info I want from placing a SELECT 1 {serverlist} using a Batch-Programm.

I’ll be back asap.

---

<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, 3:44pm UTC](https://techcommunity.softwareag.com/t/is-there-a-service-function-to-ping-defined-data-servers/208180/4 "2021-04-02T15:44:38Z")

</div>