IBM Tivoli Composite Application Manager for Application Diagnostics, Version 7.1.0.1
Verification
The following commands can help you list all of ITCAM for Application Diagnostics's database tables and determine the number of records in a given table. In addition, most of the tables have a timestamp that can be viewed using the last two select statements in the table.
Database list commands
IBM DB2 Command Function of Command Lists all tables in the database db2 "select count("*") from amuser.tablename"Gives the count of rows in the table db2 "select("*") from amuser.tablename"Lists all of the rows in the table db2 "select("*") from amuser.tablename order by columnname desc"Lists all of the rows in the table in descending order
Parent topic:
Enable the trimming of data through the Archive Agent