Dear Team
I was trying to find out the value of applications STATUS_CHANGE_TIME from SYSIBMADM.APPLICATIONS.
All my monitor switches were turned ON at session level using - db2 "update monitor switches using UOW ON"
Though my switches are ON, I'm getting a NULL value against STATUS_CHANGE_TIME .
The SQL I am trying to use is below. - db2 "select substr(A.AUTHID,1,10) as AUTH_ID, substr(A.APPL_NAME,1,20) as app_name, A.AGENT_ID as APP_HANDLE, substr(A.APPL_ID,1,25) as APPLICATION_ID, substr(A.APPL_STATUS,1,15) as status, A.STATUS_CHANGE_TIME, second(current timestamp-A.STATUS_CHANGE_TIME) as SEC_IN_STATUS, substr(A.CLIENT_NNAME,1,15) as CLIENT_NNAME from SYSIBMADM.APPLICATIONS A with ur"
Below is the output for the query. - AUTH_ID APP_NAME APP_HANDLE APPLICATION_ID STATUS STATUS_CHANGE_TIME SEC_IN_STATUS CLIENT_NNAME
-
---------- -------------------- -------------------- ------------------------- --------------- -------------------------- ------------- ---------------
-
DB2INST1 db2pcsd 13 *LOCAL.DB2.160619114917 CONNECTED - - db2v10primary
-
DB2INST1 db2bp 78 *LOCAL.db2inst1.160619123 UOWWAIT - - db2v10primary
-
DB2INST1 db2fw0 12 *LOCAL.DB2.160619114916 CONNECTED - - db2v10primary
-
DB2INST1 db2lused 11 *LOCAL.DB2.160619114915 CONNECTED - - db2v10primary
-
DB2INST1 db2bp 17 *LOCAL.db2inst1.160619114 LOCKWAIT - - db2v10primary
-
DB2INST1 db2wlmd 10 *LOCAL.DB2.160619114914 CONNECTED - - db2v10primary
-
DB2INST1 db2bp 88 *LOCAL.db2inst1.160619124 UOWEXEC - - db2v10primary
-
DB2INST1 db2taskd 9 *LOCAL.DB2.160619114913 CONNECTED - - db2v10primary
-
DB2INST1 db2stmm 8 *LOCAL.DB2.160619114912 UOWWAIT - - db2v10primary
-
DB2INST1 db2bp 47 *LOCAL.db2inst1.160619121 UOWWAIT - - db2v10primary
-
DB2INST1 db2evmg_DB2DETAILDEA 14 *LOCAL.DB2.160619114918 CONNECTED - - db2v10primary
-
DB2INST1 db2bp 7 *LOCAL.db2inst1.160619114 UOWWAIT - - db2v10primary
Please advise and thank you for your time.
0 1701 Sign in to post your reply or Sign up for a free account.
Similar topics
by: Constandinos Mavromoustakis |
last post by:
CFP: CLADE 2004-Challenges of Large Applications in Distributed
Environments
-------------------------------------------------
PhD student - Dept.Informatics at Aristotle University of...
|
by: Ravi Tallury |
last post by:
Hi
We are having issues with our application, certain portions of it stop
responding while the rest of the application is fine. I am attaching
the Java Core dump. If someone can let me know what...
|
by: Jeremy |
last post by:
I'm new to .Net. Specifically, I just started playing around with VB
..Net 2003.
I'm considering developing some shareware applications. Would you
consider .Net a suitable platform for this?
...
|
by: Terry Bell |
last post by:
We've had a very large A97 app running fine for the last seven years.
I've just converted to SQL Server backend, which is being tested, but
meanwhile the JET based version, running under terminal...
|
by: Robert |
last post by:
I have a series of web applications (configured as separate applications) on
a server.
There is a main application at the root and then several virtual directories
that are independant...
|
by: jai83 |
last post by:
Hi,
We are facing a problem with connectivity between Alphablox FastForward and DB2 Cubeviews.(Platform details are mentioned at the end of message).
We have created a cube definition on DB2...
|
by: =?Utf-8?B?YW1pdF9taXRyYQ==?= |
last post by:
Hi Everybody,
This one is a typical issue I am facing.
I have 4 different Web applications with Windows Integrated
Authentication . This works fine in local Intranet.
For Some business...
|
by: wugon.net |
last post by:
env: db2 LUW v8 + aix
We encounter some java applications status did not change and keep in
"Federated request pending" for a long time.
we try issue db2 "force applications <handle id>" to...
|
by: Rahul Babbar |
last post by:
Hi,
When i run the query,
" select distinct lock_object_type from sysibmadm.snaplock"
I gives lock object types as "ROW LOCK", "TABLE LOCK",
"INTERNALP_LOCK", "INTERNALC_LOCK",...
|
by: Gladiator |
last post by:
Hi ,
How does a SYSIBMADM schema created. Is this a default in V9 ? , bcos
i dont see it created by default in V8+ .
Thanks & Regards,
Kamalnath.V
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
| |