MQSeries.net :: View topic - How to retrieve broker property servername,instance in ESQL

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to retrieve broker property servername,instance in ESQL

How to retrieve broker property servername,instance in ESQL

« View previous topic :: View next topic »

Author

Message

dosttumhara1810

Posted: Wed Dec 01, 2010 11:04 pm Post subject: How to retrieve broker property servername,instance in ESQL

Voyager

Joined: 01 Dec 2010
Posts: 76

Any idea on accessing brker properties servername and instance ID at runtime through ESQL.

smdavies99

Posted: Wed Dec 01, 2010 11:10 pm Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

Do you mean the
servername == Underlying System Hostname

What do you mean by the instance ID?

I'm also curious as to why you need this stuff
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

dosttumhara1810

Posted: Wed Dec 01, 2010 11:54 pm Post subject:

Voyager

Joined: 01 Dec 2010
Posts: 76

Yes i want system hostname on which Broker is installed.
Actually I am creating a error handler and in that i am addind these fields (server name,instance ID) so i want to know how can i fetch there values at runtime . for ex to fetch Brokername we write SQL.BrokerName command at right side of SET statement in ESQL and this gives us the name of broker.

smdavies99

Posted: Thu Dec 02, 2010 12:19 am Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

You may well have to write a bit of java to get the real hostname.
Remember that this may change if you are using some form of HA.

What do you mean by InstanceID?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

fjb_saper

Posted: Thu Dec 02, 2010 1:22 am Post subject:

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

I think the instance Id the OP is thinking of comes with the multi-instance broker (see as well multi-instance qmgr).
However as smdavies so nicely put it, the host name should already resolve that. Writing a little bit of java to determine the host name should be java 101.

Have fun

_________________
MQ & Broker admin

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to retrieve broker property servername,instance in ESQL

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP