active users

permalink · #1 (**permalink**) 02-27-2008, 04:42 AM

Hi all,

How can I list active users connected to database server in MS-DOS
shell environment. Is there any specific CLP command for this? We are
running DB2 ver 8.1.6.

Thanks in advance.

Mehmet

permalink · #2 (**permalink**) 02-27-2008, 04:42 AM

tuarek wrote:
> Hi all,
>
> How can I list active users connected to database server in MS-DOS
> shell environment. Is there any specific CLP command for this? We are
> running DB2 ver 8.1.6.
>

You have to have the DB2 CLP enabled (i.e. by starting the a DB2 Command
Window), but the command is "db2 list applications"

permalink · #3 (**permalink**) 02-27-2008, 04:42 AM

Hi Ian,

I initialized the CLP by issuing db2cmd command. When I entered "db2
list applications", it complained with

SQL1096N The command is not valid for this node type.

Regards,

Mehmet

permalink · #4 (**permalink**) 02-27-2008, 04:42 AM

Nevermind. When Issued the command on the server, It gave me the list.

Thanks Ian.

permalink · #5 (**permalink**) 02-27-2008, 04:43 AM

In article <1124895479.612821.6170@g43g2000cwa.googlegroups.c om>,
tuarek (mbaserdem@gmail.com) says...
> Nevermind. When Issued the command on the server, It gave me the list.
>
> Thanks Ian.
>
>

You can run it at the client also after attaching to a remote
instance (or with V8 after connecting to the database.)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode