I am developing scripts to collect data from DB2 environments. The db2pd tool has a lot of very cool data, but it is a pain to run and collect data compared to running a SQL. The MON_PKG_CACHE_SUMMARY
provides equivalent data to the db2pd -tcbstats
.
Does anyone know which DB2 function and/or view can provide equivalent data to db2pd -edus
please?
1 Answer
Take a look at the ENV_GET_DB2_EDU_SYSTEM_RESOURCES table function.
2ncG1vNJzZmirpJawrLvVnqmfpJ%2Bse6S7zGiorp2jqbawutJobXJoZWeEc4KOnZlrqJRisrLByK%2BYpZ2eqXquu81mna6mk6m2sLrSZq2inaeo