Issue with STATUS_CHANGE_TIME in SYSIBMADM.APPLICATIONS

**db2dbdba** · Jun 19 '16, 07:11 PM

Dear Team

I was trying to find out the value of applications STATUS_CHANGE_T IME from SYSIBMADM.APPLI CATIONS.
All my monitor switches were turned ON at session level using

Code:

db2 "update monitor switches using UOW ON"

Though my switches are ON, I'm getting a NULL value against STATUS_CHANGE_T IME .

The SQL I am trying to use is below.

Code:

 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.

Code:

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.