How to get application name with select statement?

grofaty · #1 (**permalink**) 10-13-09, 03:23

Hi,
using db2 v9.5 fp2 on Linux I would like to write select statement that would return current application name.

I can write: "db2 list application" which returns:

Code:

Auth Id  Application    Appl.      Application Id
         Name           Handle
-------- -------------- ---------- -----------------------------
GROFATY  db2bp          15374      C0A804A0.KE0B.021543042035

I know I can get "Application Id" with select:

Code:

select application_id() from sysibm.sysdummy1

but how to get "Application Name"? In my case "db2bp".

I need this "Application Name" info because I would like to create trigger to collect application name which updated the record.
Regards,
Grofaty

Mathew_paul · #2 (**permalink**) 10-13-09, 06:00

try with snapshot functions
select * from table(snapshot_appl_info('',-1)) as tt
regds
Paul

Cougar8000 · #3 (**permalink**) 10-13-09, 09:43

db2 "select substr(APPL_NAME,1,30) from SYSIBMADM.APPLICATIONS"

sathyaram_s · #4 (**permalink**) 10-15-09, 10:42

There is an APPLICATION_ID scalar function too

dr_te_z · #5 (**permalink**) 10-16-09, 06:10

Very often you will see "java" which does not add too much info. In this context I want to draw your attention to this: Java Program Name for DB2 | db2ude
Nice liitle feature if you ask me.

Cougar8000 · #6 (**permalink**) 10-16-09, 11:11

Dr_t, you just earned another cup of java

That is a neat little code that should be utilized in all java code, specially as more teams use the same DB, you have to have an ability to know who is who.

Thank you.

Internet Services

Web Development

Digital Marketing

Consumer Tech