Welcome to the Application Performance Management Blog, where you can read the perspectives from APM experts. This Blog provides insights into the Application Performance Management solution, as well as technical details about specific IBM products.
Here is a quick video tutorial on how to find the TEMS database schema, so you can extract key information directly from your TEMS. This information is great for speeding up environment healthchecks, dumping large amounts of data quickly outside the GUI, etc.
This video will show yo how to extract the TEMS database schema directly from your TEMS machine and how to read it.
You will then be able to build your own SQL SELECT statements to extract information from the TEMS at will.
There are always times when you need that single query from the TEMS to make that audit a little quicker, that healthcheck a bit more in-depth...
This method will show you.
- How to extract the database schema
- How to sort the tables and columns
- How to read the resulting file so you can create your own SQL select statements