Skip to Content
0
Former Member
May 12, 2006 at 04:27 AM

Delta in Genaric extractin

32 Views

Hello gurus,

I have done generic extraction on table OSMON,

the feild which i have included in are,

SERVER(Server name)

1,ADATE(Date of analysis)

2,CPUMAX(Max. CPU usage for 1 day (percent), av. value for 1 hour)

3,CPUAVG(Av. CPU usage in percent)

4,PAGEINMAX(Memory paged in (KB), maximum for 1 day, av. value 1 hour)

5,PAGINAVG(KB paged in, av. value for 1 day)

6,DRESPMAX(Max.disk response time (ms) for 1 day, av.value for 1 hour)

7,DRESPAVG(Av.disk response time (ms) for 1 day, av.value for 1 hour)

8,CPUUSRAVG(User CPU utilization in percent)

9,CPUSYSAVG(CPU system utilization in percent)

10,CPUIDEAVG(Idle CPU time in percent).

and I have to make it as delta,and for this have taken ADATE object for delta,

my question is am i right to take delta on Date object or should i go for another object and why.

as my requirement is to show in BW report how much USER are utilizing system.

Help me on this

Thanks & Regards,