SAP Function SDB_CALENDER_PLANNINGS - MaxDB: Create calender planning

Parameter Reference Type Length Default Optional Text
ACTION SDBA_BTYPE C 5 X Type of DBA Action
COLLIDING_DELTA I I 4 300 X Colliding actions intervall (seconds)
DATE SYDATUM D 8 X Date
DAY CHAR1 C 1 Day
HIGHCALC I I 4 50 X For "Mark tables requiring statistics update"
LOWCALC I I 4 40 X For "Mark tables requiring statistics update"
MEDIA_NAME SDB_MNAME C 64 X SAP DB: Name of Backup Medium
RECURRENCE_PERIOD BTCPDAY N 3 X Duration (in days) of DBA action
RECURRENCE_UNIT CHAR1 C 1 X Recurrence
SYSID SYSYSID C 8 Cockpit name
TIME SDBA_TIME T 6 Time

Parameter Reference Type Length Text
RC BAPIRET2 u 548 Return Code

FUNCTIONALITY
Shedules DBA actions in the DBA Planning Calender (DB13 and DB13c).
SYSID (obligatory import parameter): Name of the system. this is thename shown in transactions DB13, DB13c and DBACOCKPIT. The SYSID can beeither the SID of the local R/3 system or a liveCache or a remotedatabase.
ACTION (optional import parameter): Name of the DBA action. Thefollowing actions are supported:
UPD2 Mark tables requiring statistics update
UPD3 Update statistics for marked tables
UPD1 Update all optimizer statistics
VERI3 Check database structure
VERIX Check database structure (only tables)
COLTS Refresh table statistics
AUOFF Deactivate automatic log backup
If the parameter is not supplied the default UPD1 = Update alloptimizer statistics will be taken.
DAY (obligatory import parameter): Day for the execution; 1=Monday,2=Tuesday, etc.
DATE (optional import parameter): Date of the execution. Format:DD.MM.YYYY. If the parameter is not supplied the date will be computedfrom the DAY parameter. Example: No DATE and DAY=6 will compute the dateof the next Saturday starting from today.
TIME (obligatory import parameter): Time of the execution. Format: HH:MM
RECURRENCE_UNIT (optional import parameter): D=daily, W=weekly, Empty=Run only once
RECURRENCE_PERIOD (optional import parameter): Integer number dependingon unit. Example: Unit='D', Recurrence_period='7' means "once per week".Unit='W', Recurrence_period ='1' also means "once per week".
COLLIDING_DELTA (optional import parameter): Time in seconds to bechecked for colliding actions. Default is 300 seconds (5 minutes).Example: Colliding_delta=600 will check if there is already a jobsheduled 10 minutes before or 10 minutes after the given TIME importparameter. If yes, no shedulling will be done.
LOWCALC (optional import parameter - only required for ACTION=UPD2):Lower limit reduction of the dataset in the table. The default is 40
HIGHCALC (optional import parameter - only required for ACTION=UPD2):Upper limit increase of the dataset in the table. The default is 50
RC: Export parameter in BAPIRET2 format. If RC-TYPE = 'E' an errortext will be written into RC-MESSAGE. If RC-TYPE='S' the action wassheduled succesfully in the calender.
EXAMPLE
Calling the function with parameter SYSID=xxx and without the ACTIONparameter will shedule an "Update all optimizer statistics" job for thelocal R/3 (Name of the R/3 = xxx)
Calling the function with parameters SYSID=LCA and ACTION=UPD2 willshedule a " Mark tables requiring statistics update " job for the localliveCache (LCA)
Calling the function with parameters SYSID=xxx_JAVA and ACTION=UPD3 willshedule a " Update statistics for marked tables" job for the JAVA stack(xxx_JAVA)
NOTE:
Executing this function requires the authorization 'S_ADMI_FCD' value'DBA'.