How to get the concurrent user login information in DB2?

Hi,

The current user is in CURRENT USER.
e.g. select current user from sysibm.sysdummy1
or
insert into mytable (myname) values (current user)

--Greg

elvis wrote:

> hi all,
> May I ask query here how to get the concurrent user login information
> from DB2?
> Thank you,
>
> regards
> elvis

Hi Elvis,

The actual connections are available through LIST APPLICATIONS command, or
through the API if you program to it. I don't believe it is available in a table
or view.

--Greg

elvis wrote:

> hi Nash,
> Thank you for your reply. Your replied is helpful.
> I would like to raise a question here that do you where is the table actually
> store the consurrent/session users infomation whose are active?
>
> thank you,
> regards,
> elvis
>
> Greg Nash <gnash@namoicotton.com.au> wrote:
> >Hi,
> >
> >The current user is in CURRENT USER.
> >e.g. select current user from sysibm.sysdummy1
> >or
> >insert into mytable (myname) values (current user)
> >
> >--Greg
> >
> >elvis wrote:
> >
> >> hi all,
> >> May I ask query here how to get the concurrent user login information
> >> from DB2?
> >> Thank you,
> >>
> >> regards
> >> elvis
> >

Try posting to the ibm news groups (news.software.ibm.com).

BTW, stored procs are provided by the db vendors so you don't have to access
the system tables - and you shouldn't. Also, in distributed applications
an application id is typically used to access the database so there is no
client-to-database info. Currently, all the projects I am working on(DB2
and SQL Server) work this way.

Mark

"elvis" <airqq@yahoo.com> wrote:
>
>hi greg,
> Thanks for your reply. To my understanding, it should be stored into
certain
>table before publishes the API for end user. Oracle and MSSQL does stored
>into system table for any attempt connections from client to the database.
>Hence, I believe so DB2 did the same thing. Frankly, I'm a 'zero' knowledge
>about the DB2. I wish my mail posting would get help from here.
>
>regards,
>elvis
>
>Greg Nash <gnash@namoicotton.com.au> wrote:
>>Hi Elvis,
>>
>>The actual connections are available through LIST APPLICATIONS command,
>or
>>through the API if you program to it. I don't believe it is available
in
>a table
>>or view.
>>
>>--Greg
>>
>>elvis wrote:
>>
>>> hi Nash,
>>> Thank you for your reply. Your replied is helpful.
>>> I would like to raise a question here that do you where is the table
actually
>>> store the consurrent/session users infomation whose are active?
>>>
>>> thank you,
>>> regards,
>>> elvis
>>>
>>> Greg Nash <gnash@namoicotton.com.au> wrote:
>>> >Hi,
>>> >
>>> >The current user is in CURRENT USER.
>>> >e.g. select current user from sysibm.sysdummy1
>>> >or
>>> >insert into mytable (myname) values (current user)
>>> >
>>> >--Greg
>>> >
>>> >elvis wrote:
>>> >
>>> >> hi all,
>>> >> May I ask query here how to get the concurrent user login information
>>> >> from DB2?
>>> >> Thank you,
>>> >>
>>> >> regards
>>> >> elvis
>>> >
>>
>