MQSeries.net :: View topic

catwood2 · Posted: Fri Apr 20, 2007 4:58 am Post subject: IS11: Flowstats & Nodestats

I am trying to sort out two "issues" I seem to be having with the xls bundled in the support pac.

I have the setup implemented, with the accounting and statistics data being published, the flow processing and updating db2 tables, and the spreadsheets connecting to the db2 instance. I am having two issues at this point:

1. The aw_nodestats.xls is reflecting a Total CPU Time in seconds (TOTCT) that would seem to be wildly off (80264) for an archive dataset that reflects a ten minute interval. The aw_flowstats.xls, for the same dataset, is reflecting a TOTCT of 3 (what I would expect). When reviewing the sheets just looking at the sample data - the values in these two spreadsheets seem to more or less align. So, this has me stumped.

2. The ah_flowstats.xls is throwing an error on refresh data step that "PAICE.AH_FLOWSTATS" is an undefined name. I can view the query in microsoft query - where I see PAICE coded - but don't know what has to be used to edit the query. The credentials to connect have been changed and the connection is good...wondering how I get at the query to change it.

TIA for any pointers.