Ansicht
Dokumentation

SDB_CALENDER_PLANNINGS - MaxDB: Create calender planning

ROGBILLS - Synchronize billing plans   ABAP Short Reference  
This documentation is copyright by SAP AG.

FUNCTIONALITY

Shedules DBA actions in the DBA Planning Calender (DB13 and DB13c).

PARAMETERS

SYSID (obligatory import parameter): Name of the system. this is the name shown in transactions DB13, DB13c and DBACOCKPIT. The SYSID can be either the SID of the local R/3 system or a liveCache or a remote database.

ACTION (optional import parameter): Name of the DBA action. The following 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 all optimizer 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 computed from the DAY parameter. Example: No DATE and DAY=6 will compute the date of 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 depending on 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 be checked for colliding actions. Default is 300 seconds (5 minutes). Example: Colliding_delta=600 will check if there is already a job sheduled 10 minutes before or 10 minutes after the given TIME import parameter. 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 error text will be written into RC-MESSAGE. If RC-TYPE='S' the action was sheduled succesfully in the calender.

EXAMPLE

Calling the function with parameter SYSID=xxx and without the ACTION parameter will shedule an "Update all optimizer statistics" job for the local R/3 (Name of the R/3 = xxx)

Calling the function with parameters SYSID=LCA and ACTION=UPD2 will shedule a " Mark tables requiring statistics update " job for the local liveCache (LCA)

Calling the function with parameters SYSID=xxx_JAVA and ACTION=UPD3 will shedule 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'.

Parameters

ACTION
COLLIDING_DELTA
DATE
DAY
HIGHCALC
LOWCALC
MEDIA_NAME
RC
RECURRENCE_PERIOD
RECURRENCE_UNIT
SYSID
TIME

Exceptions

Function Group

SADA_A1S

BAL_S_LOG - Application Log: Log header data   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

Length: 3689 Date: 20240523 Time: 045453     sap01-206 ( 67 ms )