473,322 Members | 1,314 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Issue with STATUS_CHANGE_TIME in SYSIBMADM.APPLICATIONS

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
Expand|Select|Wrap|Line Numbers
  1. 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.
Expand|Select|Wrap|Line Numbers
  1.  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.
Expand|Select|Wrap|Line Numbers
  1. AUTH_ID    APP_NAME             APP_HANDLE           APPLICATION_ID            STATUS          STATUS_CHANGE_TIME         SEC_IN_STATUS CLIENT_NNAME
  2. ---------- -------------------- -------------------- ------------------------- --------------- -------------------------- ------------- ---------------
  3. DB2INST1   db2pcsd                                13 *LOCAL.DB2.160619114917   CONNECTED       -                                      - db2v10primary
  4. DB2INST1   db2bp                                  78 *LOCAL.db2inst1.160619123 UOWWAIT         -                                      - db2v10primary
  5. DB2INST1   db2fw0                                 12 *LOCAL.DB2.160619114916   CONNECTED       -                                      - db2v10primary
  6. DB2INST1   db2lused                               11 *LOCAL.DB2.160619114915   CONNECTED       -                                      - db2v10primary
  7. DB2INST1   db2bp                                  17 *LOCAL.db2inst1.160619114 LOCKWAIT        -                                      - db2v10primary
  8. DB2INST1   db2wlmd                                10 *LOCAL.DB2.160619114914   CONNECTED       -                                      - db2v10primary
  9. DB2INST1   db2bp                                  88 *LOCAL.db2inst1.160619124 UOWEXEC         -                                      - db2v10primary
  10. DB2INST1   db2taskd                                9 *LOCAL.DB2.160619114913   CONNECTED       -                                      - db2v10primary
  11. DB2INST1   db2stmm                                 8 *LOCAL.DB2.160619114912   UOWWAIT         -                                      - db2v10primary
  12. DB2INST1   db2bp                                  47 *LOCAL.db2inst1.160619121 UOWWAIT         -                                      - db2v10primary
  13. DB2INST1   db2evmg_DB2DETAILDEA                   14 *LOCAL.DB2.160619114918   CONNECTED       -                                      - db2v10primary
  14. DB2INST1   db2bp                                   7 *LOCAL.db2inst1.160619114 UOWWAIT         -                                      - db2v10primary
Please advise and thank you for your time.
Jun 19 '16 #1
0 1701

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Constandinos Mavromoustakis | last post by:
CFP: CLADE 2004-Challenges of Large Applications in Distributed Environments ------------------------------------------------- PhD student - Dept.Informatics at Aristotle University of...
0
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...
5
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? ...
6
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...
5
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...
1
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...
1
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...
2
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...
1
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",...
3
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
0
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
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...
0
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...
0
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...
1
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
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....
0
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.