[DB2-L] Is there a standard way to determine which DB2 subsystem the program is talking

Walter Janißen

[DB2-L] Is there a standard way to determine which DB2 subsystem the program is talking
Hi

I am not sure, what you mean with subsystem name. ASAIK you can (must) specify the local subsystem name in the BSDS and that's, what you get, when you issue the CURRENT SERVER-statement. If you are in datasahring, there is also a special register called "current member".

Mit freundlichen Grüßen
Walter Janißen

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Laufzeitarchitektur
Victoriaplatz 2
40477 Düsseldorf
mailto:[login to unmask email]

Vorsitzender des Aufsichtsrates: Jürgen Vetter
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Ina Kirchhof, Dr. Christian Nymphius, Dr. Michael Regauer, Wolfgang Schön.
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf, HRB 37996


-----Ursprüngliche Nachricht-----
Von: IDUG DB2-L [mailto:[login to unmask email] Im Auftrag von Binyamin Dissen
Gesendet: Montag, 1. Februar 2010 16:14
An: [login to unmask email]
Betreff: Re: [DB2-L] Is there a standard way to determine which DB2 subsystem the program is talking to?

I saw that, but it does not allow me to determine the subsystem name. Also it can be blank.

On Mon, 1 Feb 2010 10:00:14 -0500 "Sevetson, Phil" <[login to unmask email]>
wrote:

:>SELECT CURRENT SERVER FROM SYSIBM.SYSDUMMY1 should work nicely. Note that the SERVER name is always unique but not always identical to the four-character subsystem name (it is defined at install time).
:>
:>--Phil S.
:>
:>-----Original Message-----
:>From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Binyamin Dissen
:>Sent: Monday, February 01, 2010 9:45 AM
:>To: [login to unmask email]
:>Subject: [DB2-L] Is there a standard way to determine which DB2 subsystem the program is talking to?
:>
:>Assuming that a DB2 program calls my subroutine, is there a standard way to :>discover the name of the DB2 subsystem? Or must it be passed as a parm?

--
Binyamin Dissen <[login to unmask email]> http://www.dissensoftware.com

Director, Dissen Software, Bar & Grill - Israel


Should you use the mailblocks package and expect a response from me, you should preauthorize the dissensoftware.com domain.

I very rarely bother responding to challenge/response systems, especially those from irresponsible companies.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA * _____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L