on 04-02-2015 11:49 AM
Hi experts,
is there a metric or does anybody know the way to realize a metric which displays the the last database dump (full dump)?
So like the transaction log metric, which displays in minutes, how long the last transaction log dump is ago.
So I want to see how many minutes are ago a db dump was done.
(to see if a backup wasn't running).
Thx to everybody
Hi Christian,
Hope you are doing good.
I did check this further internally and I came across these 2 notes.
Note 1930388 - SYB: Additional metrics for E2E Alerting :
"You are using SAP Solution Manager based on the SAP_BASIS component SP 14 to monitor an SAP ASE database. This SAP Note adds several new metrics to the Technical Monitoring. The following metrics have been added:
"
Also check note 2083174.
Kind Regards,
Hemanth
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Christian, That’s great news. I thought you were on the latest level, cause there are some known issues when SP 14 is used; but I think we will get to them after you upgrade :). Please do keep us posted incase of any issues. Hope this helps. _ _ _ _ _ _ _ _ _ Kind Regards, Hemanth SAP AGS _ _ _ _ _ _ _ _ _
Hi Christian, It is always advisable to be on the latest release. Please do the stack upgrade as you are not pressed for time. If you download the software packages using the Maintenance Optimizer in SAP Solution Manager, the stack configuration file will be generated automatically and saved to the EPS inbox. An early check is added to filter out upgrade and update paths that are not supported by the current SUM version, so if there is anything wrong, a pop up should be triggered. Hence please try a stack upgrade. Regards, Hemanth
Got it now.
So if somebody wants to know how to get the dump-information into ABAP, see the following thread below. With that help I did create a customer FM and did implement that in metrics.
Job for around 2 hours and I got the result
I know that I have to do the upgrade to sp12/7.2 and be sure, we will do that.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hmm...I see that for the basis 14 we have to bring solman on SP11.
As we don't have the time at the moment to do the complete update, maybe there is another way.
Can somebody please post the "Data collection" of metric "Time since Last Database Dump"?
So for transaction dump it is:
Keyfigure = last transaction dump SID
DBCNAME = $DBCNAME$
DBMS_ID = $DBMS_ID$
What is it for database dump? Maybe I can try to create bymyself and if I have a luck it also works without the upgrade.
A bit of last hope.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Maybe anybody knows if that information is stored in a ABAP-Table.??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.