SAP Program SDBI_SYNC_CHECK_TECHNICAL - Buffer Synchronization Test

Purpose
Technical Check of Buffer Synchronization

Features

Technical Check of Buffer Synchronization
This report is intended to run on any application server. The followingtests are carried out:

  • The profile parameter rdisp/bufrefmode is tested. If there are multiple
  • application servers, and if the parameter is not set to'sendon/exeauto', an error message is output.
    • The profile parameter rdisp/bufreftime is tested. The parameter should
    • be less than 30 or greater than 300 (value is in seconds).
      The other parameters are database-specific. Initially, only tests forthe database are implemented that use sequences for the DDLOG fieldSEQ_NR (Oracle, SAPDB, Informix, MSSQL). The tests are also carried outif the parameter rdisp/bufrefmode is not set to 'sendon/exeauto', astransports into the system have to be synchronized.
      The last sequence number of the DDLOG sequence (dictionary query,LAST_SEQNR_DB ) is compared with the last synchronized number (from theapplication server's shared memory, LAST_SEQNR_SHM). This can have oneof the following results:
      • LAST_SEQNR_DB = LAST_SEQNR_SMH : all DDLOG records were synchronized,
      • everything OK.
        • LAST_SEQNR_DB < LAST_SEQNR_SMH : should never happen. The application
        • server#s time is in the future and it cannot synchronize.
          • LAST_SEQNR_DB > LAST_SEQNR_SMH : there are still changes in the DDLOG
          • that have to be synchronized. The system checks how long newer DDLOGrecords exist. A maximum value of FACTOR * BUFREFTIME is tolerated(currently, FACTOR = 4; BUFREFTIME is the value of the profileparameter rdisp/bufreftime). The system tries to find the record withSEQ_NR = LAST_SEQNR_SMH +1 and to read the corresponding time stamp(WR_TS). This can have one of the following results:
            The record does not exist. This is an error. The record has not yetbeen synchronized, so it must exist in the system.
            The record is found, the time stamp is read and compared with thecurrent time. If the difference between the current time and the timestamp is greater than FACTOR * BUFREFTIME, an error is returned.

            Other Information
            The table DDLOG is defined in the Data Dictionary from release 6.10.The field NOTEBOOK contains the actual synchronization data.
            Also see report RSDBBUFF.