All Forums Database
Santanu84 122 posts Joined 04/13
23 Jul 2014
Viewpoint and Corresponding DBC Table

Hi
In Viewpoint Query-Monitor, for a particular session we can check the cpu skew and also the highest and average cpu.
If I want to check this from database, then which table and column shall I refer, is it DBQLogTbl or AMPUsageV view or anything else?
 
Thanks
Santanu

Santanu84 122 posts Joined 04/13
27 Jul 2014

Hi
Anyone, any guidance ?
Santanu

VBurmist 96 posts Joined 12/09
28 Jul 2014

Hi Santanu,
 
for the near-real-time data, you might want to check MonitorSession:
 SELECT * FROM TABLE (SYSLIB.MonitorSession(-1,'*',0));
for the history data, the DBQL is the most probable choice.
 
Regards,
Vlad.

VBurmist 96 posts Joined 12/09
28 Jul 2014

p.s. forgot the alias, it is SELECT * FROM TABLE (SYSLIB.MonitorSession(-1,'*',0)) as t1;
Both MonitorSession and DBQL do not have skew column pre-calculated, but it can be calculated based on high/low AMP CPU and the number of participating AMPs.

 

You must sign in to leave a comment.