Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

Utility to determine the total number of traces in database

Utility to determine the total number of traces in database


Utility to determine the total number of traces in database


  • Product Name: CaliberRM
  • Product Version: 2005
  • Product Component: Datamart
  • Platform/OS Version: Windows


1. Is there any way to determine if all the traces in a given Caliber project are getting into the datamart extract?

2. Also, is there a way to get the "Count" of Trace Ids out of the Caliber application database?


1. No easy way unless it is manually checked for each one.

2. db2tty Versant utility can be used to get the count of Trace_Ids.

From a dos prompt run:

C:>db2tty -D sqmdb >> test.out

And in the test.out file look for something similar to this:

====== CLASS `Trace_p" ====== [08f6e15e]
Trace_p::id_number : o_4b (Unique Hash Indexed)
Trace_p::name : char[]
Trace_p::description : char[]
Trace_p::from_object : o_4b
Trace_p::from_object_type : o_4b
Trace_p::from_object_changed : o_u1b
Trace_p::from_object_project : o_4b
Trace_p::to_object : o_4b
Trace_p::to_object_type : o_4b
Trace_p::to_object_changed : o_u1b
Trace_p::to_object_project : o_4b
Trace_p::suspect : o_u1b
Trace_p::type : char
Trace_p::from_object_deleted : o_u1b
Trace_p::to_object_deleted : o_u1b
Trace_p::o_ts_timestamp : o_4b
****** Total 43806 instances of class "Trace_p" ******

The above result shows that 43806 traces were determined.

43806 would be the total trace count found in database.

Author: Rajini Billahalli

Old KB# 15988


Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 18:28
Updated by:
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.