DB space history not updating in DB02 after upgrading to NW7 patch level 11

[jeff_matheis]

We upgraded our NW04 system to NW7 patch level 11 and now when I go into DB02 and click on DB space history there is no new data since the upgrade. SAP_Collector_For_PerfMonitor runs every hour without error. I've checked st22 and there are no shortdumps and I can't find any timeout issues. Ideas?

[jeff_matheis]

This issue was resolved by creating a proxy in SQL. We used the store procedure sp_xp_cmdshell_proxy_account in SQL.

[jeff_matheis]

I resolved this myself using the resolution in my previous post.

[Former Member]

You may need to a newer release of saposcol. Saposcol comes with your kernel, if you haven't updated your kernel recently that could be a conflict with your saposcol.

Lee

[Former Member]

Hi, I have the exact same problem. After patching the NW2004s system with SP10 or 11 (which contains the new DBA Cockpit), I don't get any stats in DB02 -> Space Overview. All the values are 0. Any ideas?

[Former Member]

Hi ,

Check SAPOSCOL is running?, there must be some background job is not running like statsupdate.

Regards,

Hari.