How can i configure my SQL Anywhere 12.0.1 database to listen and respond to ISO messages e.g the ISO message 0800 which pings the database?

asked 17 Aug '11, 03:19

Takudzwa's gravatar image

Takudzwa
818813
accept rate: 0%


Why would you like to want to to that? IMHO, responding to PINGing is a task for the network stack, not for the database engine.

If you want to check whether a particular database engine or database is available in the network, you might use the DBLOCATE and DBPING utilities.

permanent link

answered 17 Aug '11, 03:31

Volker%20Barth's gravatar image

Volker Barth
30.0k295449654
accept rate: 32%

Thanks Volker, was considering logging each time i get the ISO echo message as am interfacing two systems so would like to find out which system was responsible for the break in communication

(17 Aug '11, 03:44) Takudzwa

Some ideas:

If you are logging the messages outside the two databases, you could use SNMP to query the version and log when the query fails:

http://dcx.sybase.com/index.html#1201/en/dbadmin/snmpconfig.html

If you are logging inside the database you could setup a remote procedure call to a local procedure that selects the version and log when that fails:

http://dcx.sybase.com/index.html#1201/en/dbusage/rpc-omni-using.html*d5e42098

permanent link

answered 17 Aug '11, 10:25

Siger%20Matt's gravatar image

Siger Matt
3.1k486493
accept rate: 13%

Are you referring to ISO 8583, this is a financial application level message standard. I am not aware, that any database system is declaring to be in conformance with a business communication standard other than SQL...

permanent link

answered 17 Aug '11, 04:47

Martin's gravatar image

Martin
8.6k116149237
accept rate: 14%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×2

question asked: 17 Aug '11, 03:19

question was seen: 716 times

last updated: 17 Aug '11, 10:25

Related questions