Session Id for DB2 Z/OS

techday · #1 (**permalink**) 11-18-11, 04:18

Hi ,
Database server = DB2 z/OS 10.1.5

What would be the command to get the session id (or is it called something else in DB2) in DB2 Z/OS.
Came across the query "select application_id() as appl_id from sysibm.sysdummy1" but this does not seem to be supported in Z/os.
(No authorized routine named "APPLICATION_ID" of type "APPLICATION_ID")

Thanks.

Peter.Vanroose · #2 (**permalink**) 11-20-11, 15:46

No, there is no such function (nor any other way to obtain a unique session value) in DB2 for z/OS.

techday · #3 (**permalink**) 11-21-11, 04:16

Oh. Surprised.
But DB2 LUW does have session id values?
Using a Connection's Application ID

Peter.Vanroose · #4 (**permalink**) 11-21-11, 11:49

Yes; see also the DB2 Info Center for LUW:
APPLICATION_ID scalar function

stolze · #5 (**permalink**) 11-28-11, 11:16

You may have a good chance to do something similar as I described in my article using a UDF on DB2 z/OS. The DBINFO structure, which is available using the DBINFO keyword on the CREATE FUNCTION statement, contains an application ID also on z/OS. So the article is pretty much applicable for you.

dineshdb2dba · #6 (**permalink**) 11-28-11, 12:08

We can get session id in DB2 zO/S.

In DB2 zO/S it is called as SESSID

Use the following command to get SESSID:

-DISPLAY THREAD(*) LOCATION(*) DETAIL

From the O/P look this message DSNV448I..

The information on this line is part of message DSNV448I. The SESSID
column has changed. If the connection uses VTAM, the SESSID column
contains a VTAM session identifier. If the connection uses TCP/IP, the
SESSID column contains "local:remote", where local specifies the DB2
TCP/IP port number and remote specifies the partner's TCP/IP port
number.

dav1mo · #7 (**permalink**) 11-28-11, 13:29

Take a look at special registers. The one you want is in there.

techday · #8 (**permalink**) 11-29-11, 00:26

Quote:

Originally Posted by dineshdb2dba

We can get session id in DB2 zO/S.

In DB2 zO/S it is called as SESSID

Use the following command to get SESSID:

-DISPLAY THREAD(*) LOCATION(*) DETAIL

From the O/P look this message DSNV448I..

Where exactly should the statement "-DISPLAY THREAD(*) LOCATION(*) DETAIL" be executed? Tried it in the AQT Run window where I normally execute queries.Didn't recognize.

dineshdb2dba · #9 (**permalink**) 11-29-11, 02:58

Quote:

Where exactly should the statement "-DISPLAY THREAD(*) LOCATION(*) DETAIL" be executed? Tried it in the AQT Run window where I normally execute queries.Didn't recognize.

-DISPLAY THREAD(*) LOCATION(*) DETAIL

This command can be issued from a z/OS console,
a DSN session under TSO,
a DB2I panel (DB2 COMMANDS),
an IMS or CICS terminal, or
a program using the
instrumentation facility interface (IFI).

Data sharing scope: Group or local, depending on the SCOPE option.

techday · #10 (**permalink**) 12-05-11, 02:28

Hmm... IBM Data Studio's(2.2.1.1) SQL Scripts window could not recognize the command.
ILLEGAL SYMBOL "DISPLAY"

Peter.Vanroose · #11 (**permalink**) 12-05-11, 02:48

Quote:

Originally Posted by techday

Where exactly should the statement "-DISPLAY THREAD(*) LOCATION(*) DETAIL" be executed?

Simplest way: on the DB2I panel (ISPF), option 7.
Alternative: as DSN subcommand, either on the TSO prompt or through JCL:

Code:

//DB2CMD  EXEC PGM=IKJEFT01,DYNAMNBR=20
//SYSTSPRT DD  SYSOUT=*
//SYSPRINT DD  SYSOUT=*
//SYSUDUMP DD  SYSOUT=*
//SYSTSIN  DD  *
   DSN SYSTEM(DB2A)
   -DISPLAY THREAD(*) LOCATION(*) DETAIL
  END
//*

Internet Services

Web Development

Digital Marketing

Consumer Tech