Answers for "Why STMT_TEXT is always NULL in SYSIBMADM.SNAPSTMT even after turning on monitoring switches in DB2?"https://developer.ibm.com/answers/questions/485437/why-stmt-text-is-always-null-in-sysibmadmsnapstmt.html
The latest answers for the question "Why STMT_TEXT is always NULL in SYSIBMADM.SNAPSTMT even after turning on monitoring switches in DB2?"Answer by STMI_old_apehttps://developer.ibm.com/answers/answers/487829/view.html
Hi @mbharath696
Just one question : did you resolved the problem ?
If yes ( and I hope so ), it would be good to share here the way you solved the issue.
Other people may look at the same and will "like" your post having found the answer, or just having found it interesting.
If no, as is, I can't answer, sorry. I did some investigation and did not found any open issues. Yes, monitoring is a bit tricky to get exactly what we want, but most often it works. So if it still does not work for you now, more investigation has to be done. This is outside the scope of this forum and you should open a case ( formerly PMR ) to have it reviewed by the IBM Db2 support team. ( https://www.ibm.com/mysupport )
TIA, and thanks to "like" this one if it provided you good guidances to proceed further on the topic.
KR
Michel
<:~__)-Thu, 10 Jan 2019 15:35:49 GMTSTMI_old_apeAnswer by Samuel Pizarrohttps://developer.ibm.com/answers/answers/485580/view.html
> the suggestion was to turn on the STATEMENT monitoring flag
How have you turned it on ? could you please provide the output for this:
db2 get dbm cfg show detail | grep DFT_
Have you done a Instance restart after setting them ? (db2stop/db2start)
From Documentation, you must attach to instance in order to changes take effect immediately.
[https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.config.doc/doc/r0000297.html][1]
The change takes effect immediately if you explicitly ATTACH to the instance before modifying the dft_mon_xxxx switch settings. Otherwise the setting takes effect the next time the instance is restarted.
[1]: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.config.doc/doc/r0000297.htmlWed, 19 Dec 2018 15:11:58 GMTSamuel Pizarro