loadid row count

[sbutal02]

How do I obtain a count of the number of records (rows) associated with a particular loadid, if the loadid is no longer in the system log ?

[Justin Derrick]

Hi.

You're likely going to have to query the database directly.  In DB2 on AIX, you'd do this:

db2 connect to archive
db2 "select count(*) from <owner>.<table> where doc_name like '<objname>%'"
db2 terminate

You'll need to know the name of the instance owner, and the table(s) associated with the Application Group, and the object name (ie '123FAA') you're interested in.

To get the number of rows for ALL objects inside a specific table, try something like this.
db2 connect to archive
db2 "select doc_name,count(*) from <owner>.<table> group by doc_name"
db2 terminate

Hope this helps!

-JD.

[Vadim V N]

Hi,

Another alternative for Justin's suggestion, if you don't want to search for the right table, is to use "arsdoc query" or "arsdoc get" with [-i "WHERE DOC_NAME LIKE 'xxxFAA'"]. Then you'll get either txt list of respective DB rows which you can count, or the report file itself, where you can count number of reports.

The way you do it depends on the means you have and personal preferences.

[nijagunakote]

What is the version of CMOD you are running?

Version 8.4.1 has a new folder called "System Load" where load statistics are collected.
It will give you all information about a load.

-Nija

[Alessandro Perucchi]

What is the version of CMOD you are running?

Version 8.4.1 has a new folder called "System Load" where load statistics are collected.
It will give you all information about a load.

-Nija

Hello Nija,

yes, but if the information he wanted was from several years in the past, then the "System Load" won't have it. It is use only for the loads you did after you setup the "System Load".
So if you want some info from a load you did in version 8.3 or 8.4.0.X... then you won't find anything in "System Load".

Cheers,
Alessandro