WRITTEN BY: supportmymoto.com STAFF
Whats up Everybody
We all know SLT used for real-time replication to HANA but when we face beneath conditions then SLT logging and replay is helpful.
- Desk replication reveals superb however some information fields not up to date appropriately(Resulting from product bug or every other purpose) – instance circumstances are flag fields the place information modified a number of instances particularly time.
- Giant tables Inconsistency attributable to HANA product bugs (HANA 1.0 SPS 122.15).
- Handbook deletions restoration from HANA in case of latest information.
Logging possibility out there on SLT system and it used to log desk particular replication or complete configuration which incorporates all tables.
Pre-requisites for SLT Logging – SLT spacing needed to be elevated as logging can be recorded in SLT system.
Steps to allow Logging:
Step 1: Go to SLT system and entry transaction LTRS, choose configuration for which logging required.
Step 2: Below Superior Replication Settings choose Replication Logging as proven beneath.
Step 3: If you wish to allow all tables logging for respective configuration then use Normal settings as proven beneath.
Allow verify field for Activate Logging
Recording Interval(Days) – Its completely venture particular as this includes house requirement on SLT system. For manufacturing system its good to maintain at-least 2 weeks in order that in case if we face any points with information we will retrieve it from logging.
Under setting from non-production methods so it may be as much as week days.
Step 4: If you wish to allow desk particular logging for respective configuration then use Desk-Particular Settings as proven beneath.
All replicated tables will reveals right here so you possibly can choose tables and allow Energetic verify field with days as proven beneath.
On this possibility we could have possibility to pick out completely different choice of days for various tables.
Notice: Now we have to be sure that if first time we use Desk particular settings and later we plan to make use of Normal settings for configuration then be sure that we’ll take away all desk particular settings earlier than going for common settings because it is not going to overwrite the times so please be sure to validate the identical.
SLT Replay is the choice to retrieve information with alternatives from logging information. Right here alternatives is dependent upon days which we chosen for logging.
Steps to Replay:
Step 1: Go to SLT system and entry LTRC transaction after which Knowledgeable Operate tab as proven beneath.
Right here now we have possibility beneath Further Capabilities known as Logged Replication Information.
Step 2: Once we double click on Logged Replication Information it would reveals different window the place we will choose desk and course of information as proven beneath.
Step 3: Choose desk and press enter to indicate the logged request particulars.
Step 4: Right here suppose if we need to retrieve information for specific time slot then this selection is usually recommended in any other case for Mass switch will cowl in subsequent steps.
To pick out specific package deal based mostly on our information evaluation, let say i have to retrieve information between 8-9 then we have to course of 2 packages and switch them as proven beneath
If you press switch it would ask to proceed press Sure in order that background can be created to course of the data.
Notice: Above possibility solely helps if handful of packages required to course of as now we have to course of them one after the other.
SLT Reply Utilizing Mass Switch Packages:
This selection helpful if we need to course of bunch of packages at one step or to course of days packages.
Once we double click on Logged Replication Information it would reveals different window click on on Goto and choose “Mass Retransfer”
Under display screen reveals Mass Re-transfer: right here now we have possibility to pick out from once we need to course of the logging information, additionally possibility for single or all tables.
Right here we will choose From and Desk particulars and execute them in background.
For those who verify SM37 for background job and it reveals as beneath.
Now when you verify the info on HANA aspect you will notice the info.