dbmcli on db760>event_list
\
OK
\
Name Priority Value Description
\
DBFILLINGABOVELIMIT LOW 70 Filling level of the data area exceeds the given percentage
\
DBFILLINGABOVELIMIT MEDIUM 80 Filling level of the data area exceeds the given percentage
\
DBFILLINGABOVELIMIT MEDIUM 85 Filling level of the data area exceeds the given percentage
\
DBFILLINGABOVELIMIT HIGH 90 Filling level of the data area exceeds the given percentage
\
DBFILLINGABOVELIMIT HIGH 95 Filling level of the data area exceeds the given percentage
\
DBFILLINGABOVELIMIT HIGH 96 Filling level of the data area exceeds the given percentage
\
DBFILLINGABOVELIMIT HIGH 97 Filling level of the data area exceeds the given percentage
\
DBFILLINGABOVELIMIT HIGH 98 Filling level of the data area exceeds the given percentage
\
DBFILLINGABOVELIMIT HIGH 99 Filling level of the data area exceeds the given percentage
\
DBFILLINGBELOWLIMIT LOW 70 Filling level of the data area has fallen short of the given percentage
\
DBFILLINGBELOWLIMIT LOW 80 Filling level of the data area has fallen short of the given percentage
\
DBFILLINGBELOWLIMIT LOW 85 Filling level of the data area has fallen short of the given percentage
\
DBFILLINGBELOWLIMIT LOW 90 Filling level of the data area has fallen short of the given percentage
\
DBFILLINGBELOWLIMIT LOW 95 Filling level of the data area has fallen short of the given percentage
\
LOGABOVELIMIT LOW 50 Filling of the log area exceeds the given percentage
\
LOGABOVELIMIT HIGH 66 Filling of the log area exceeds the given percentage
\
LOGABOVELIMIT LOW 75 Filling of the log area exceeds the given percentage
\
LOGABOVELIMIT MEDIUM 90 Filling of the log area exceeds the given percentage
\
LOGABOVELIMIT HIGH 94 Filling of the log area exceeds the given percentage
\
LOGABOVELIMIT MEDIUM 95 Filling of the log area exceeds the given percentage
\
LOGABOVELIMIT HIGH 96 Filling of the log area exceeds the given percentage
\
LOGABOVELIMIT HIGH 97 Filling of the log area exceeds the given percentage
\
LOGABOVELIMIT HIGH 98 Filling of the log area exceeds the given percentage
\
LOGABOVELIMIT HIGH 99 Filling of the log area exceeds the given percentage
\
AUTOSAVE LOW The state of the automatic log backup process has changed.
\
BACKUPRESULT LOW THIS FEATURE IS NOT YET IMPLEMENTED.
\
CHECKDATA LOW The event CHECKDATA is always transmitted when the database check using CHECK DATA or CHECK DATA WITH UPDATE is completed.
\
EVENT LOW An event was switched on or off
\
ADMIN LOW Operational state was changed to ADMIN
\
ONLINE LOW Operational state was changed to ONLINE
\
UPDSTATWANTED LOW At least one table needs new optimizer statistics
\
OUTOFSESSIONS HIGH Maximum number of parallel sessions is running
\
ERROR HIGH A error occurred which has been written to database diagnostic message file.
\
SYSTEMERROR HIGH A severe system error occured, see knldiag.err
\
DATABASEFULL LOW The event DATABASEFULL is transmitted at regular intervals when the data area is filled to 100 percent.
\
LOGFULL LOW The log area is full and has to be saved.
\
LOGSEGMENTFULL LOW One log segment is full and can be saved
\
STANDBY LOW Operational state was changed to STANDBY
\
\
---
\
[...]
\
AUTOSAVE
\
\
AUTOSAVE events give information about the state of the automatic log
\
backup and are triggered by changes of this state.
\
\
The events of category AUTOSAVE are active by default.
\
\
An actual event of category AUTOSAVE contains usable information within the
\
following data fields:
\
\
PRIORITY:
\
This data field contains the priority of the event. The following
\
value can occur:
\
LOW
\
\
VALUE1:
\
This data field contains the reason that triggered the event. The
\
following values can occur:
\
0, The automatic log backup task has been started.
\
1, The automatic log backup task has been stopped.
\
2, Automatic log backup has been enabled.
\
3, Automatic log backup has been disabled.
\
4, A log backup was successfully finished.
\
\
TEXT:
\
If data field VALUE1 has the value 1 or 4, data field TEXT contains the file
\
name of the log backup medium that is used by the automatic log backup.
\
Otherwise data field TEXT contains no information.
\
[...]
\
add <cfgFile> Name == <value> [Priority == (LOW|MEDIUM|HIGH)] [Value1 (==|>=|<=|>|<) <value>] [Value2 (==|>=|<=|>|<) <value>] Command == <command>
\
\
delete <entryID> <cfgFile>
\
\
list <cfgFile>
\
\
start [-remoteaccess] <cfgFile> -l <logFile> -d <dbName> (-u <user,pwd>|-U <userkey>) [-n <node> [-e SSL]]
\
\
state -d <dbName> (-u <user,pwd>|-U <userkey>) [-n <node> [-e SSL]]
\
\
stop <instanceID> -d <dbName> (-u <user,pwd>|-U <userkey>) [-n <node> [-e SSL]]
\
\
version
\
\
dbmcli on db770>help event
\
OK
\
event_available
\
event_create_testevent
\
event_delete <event_category> [<value>]
\
event_dispatcher ADD NAME == <event_name> [PRIORITY == <priority>]
\
[VALUE1 (==|>=|<=|>|<) <value1>] [VALUE2
\
(==|>=|<=|>|<) <value2>] COMMAND == <command> |
\
DELETE <entry_ID> |
\
SHOW |
\
ON |
\
OFF
\
event_list
\
event_list_categories [<event_category>]
\
event_receive
\
event_release
\
event_set <event_category> LOW|MEDIUM|HIGH [<value>]
\
event_wait
\
\
---
\
dbmcli on db770>
\
dbmevtdisp add C:\\sapdb\\data\\wrk\\DB760\\evtdisp.cfg
\
Name == "AUTOSAVE"
\
Value1 == 4
\
Command == "C:\\\\Windows\\\\System32\\\\cmd.exe \\/q \\/c C:\\\\sapdb\\\\data\\\\wrk\\\\DB760\\\\myeventscript.cmd $EVTTEXT$"
\
\
echo %1 >> C:\\sapdb\\data\\wrk\\DB760\\myeventscript.log
\
c:\\sapdb\\db760\\db\\bin>dbmevtdisp start C:\\sapdb\\data\\wrk\\DB760\\evtdisp.cfg -l C:\\sapdb\\data\\wrk\\DB760\\evtdisp.log -d db760 -U db760ED
\
Event Dispatcher instance 0 running
\
using configuration file C:\\sapdb\\data\\wrk\\DB760\\evtdisp.cfg
\
event with name DISPINFO:DISPSTART not dispatched (count 0)
\
c:\\sapdb\\db760\\db\\bin>dbmevtdisp stop 0 -d db760 -U db760ED
\
OK
\
c:\\sapdb\\db760\\db\\bin>dbmevtdisp start C:\\sapdb\\data\\wrk\\DB760\\evtdisp.cfg -l C:\\sapdb\\data\\wrk\\DB760\\evtdisp.log -d db760 -U db760ED
\
Event Dispatcher instance 0 running
\
using configuration file C:\\sapdb\\data\\wrk\\DB760\\evtdisp.cfg
\
\
[...]
\
event with name AUTOSAVE not dispatched (count 3)
\
Event with name AUTOSAVE dispatched (count 4)
\
event with name AUTOSAVE not dispatched (count 5)
\
event with name LOGSEGMENTFULL not dispatched (count 6)
\
event with name AUTOSAVE not dispatched (count 7)
\
Event with name AUTOSAVE dispatched (count 😎
\
event with name AUTOSAVE not dispatched (count 9)
\
Event with name AUTOSAVE dispatched (count 10)
\
event with name AUTOSAVE not dispatched (count 11)
\
Event with name AUTOSAVE dispatched (count 12)
\
event with name AUTOSAVE not dispatched (count 13)
\
[...]
\
C:\\sapdb\\backup\\db760log.822
\
C:\\sapdb\\backup\\db760log.823
\
C:\\sapdb\\backup\\db760log.824
\
C:\\sapdb\\backup\\db760log.825
\
C:\\sapdb\\backup\\db760log.826
\
C:\\sapdb\\backup\\db760log.827
\
C:\\sapdb\\backup\\db760log.828
\
C:\\sapdb\\backup\\db760log.829
\
C:\\sapdb\\backup\\db760log.830
\
C:\\sapdb\\backup\\db760log.831
\
C:\\sapdb\\backup\\db760log.833
\
C:\\sapdb\\backup\\db760log.834
\
C:\\sapdb\\backup\\db760log.835
\
C:\\sapdb\\backup\\db760log.836
\
C:\\sapdb\\backup\\db760log.837
\
C:\\sapdb\\backup\\db760log.838
\
[...]
\
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 |