db2pd equivalent MON functions/views

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.

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.

2

ncG1vNJzZmirpJawrLvVnqmfpJ%2Bse6S7zGiorp2jqbawutJobXJoZWeEc4KOnZlrqJRisrLByK%2BYpZ2eqXquu81mna6mk6m2sLrSZq2inaeo

 Share!