X-LOG for CDC

= TO_DATE(‘2024’,’YYYY’) AND GUBUNCODE IN (‘AC’,’FA’) 29X-LOG for CDC UI Guide For replication conditions, a validation function is provided to verify the validity of the condition manually entered by the user by inquiring with the actual condition entered in the selected table. Upon successful validation, a green ''v'' icon is displayed, and upon failure, a red ''x'' icon is displayed. When viewing the table on the policy management screen, tables with a registered replication condition are marked with a blue circle in the replication condition column. 2-7-6. Register Column Replication Information The column replication function is used when replicating only some columns when the structure of the replication target table is different. After registering the replication target table, clicking the column replication icon activates a pop-up window for selecting target columns to replicate. When selecting replication columns, the PK-related columns of the source table must be registered as replication targets, and the corresponding columns must exist identically in the target table. Select and map the target table column to be mapped to the source table 30X-LOG for CDC UI Guide column from the Listbox. When mapping setup is complete, clicking the [Save] button applies the set mapping. Clicking the ''Auto Mapping'' button maps all columns 1:1 according to the COLUMN_ID order. When auto-mapping registration is complete, the color of the column replication icon changes to blue. Note Column replication provides only mapping of the same data type, and it is recommended to use the ''Auto Mapping'' function only when the structures of the replication target tables are identical. 2-7-7. Register Transformation Replication Information The transformation replication function is used when it is necessary to convert data among source table data and reflect it in the target table. After registering the replication target table, clicking the FUNCTION icon activates a pop-up window to write the FUNCTION name to be applied to the selected column. Transformation Replication Not Set Transformation Replication Set Note The user must provide the function used for transformation replication, and the function must also be created in the source/target databases by the user. As a constraint for the function, there must be only 1 Parameter argument. 31X-LOG for CDC UI Guide 2-7-8. Configure Multi-Policy If there is a delay when applying data in the corresponding policy or if there are many transactions being applied, applying it as a multi-policy allows for faster application. However, since it uses additional resources such as memory, it is recommended to set it appropriately. When you click the [Multi-Policy] button, a pop-up window is output. Set and register a value of 1 or more for the number of multi-threads on the pop-up screen, and restart the policy to complete the application. 32X-LOG for CDC UI Guide Tables with multi-threading applied will show an icon. 33X-LOG for CDC UI Guide 2-8. Monitoring By clicking [Monitoring] from the menu below, you can view the monitoring screen in the Contents area. 2-8-1. Overall Monitoring You can monitor the status of X-LOG replication agents and Queues, event log occurrences, and delay time-related information in real-time. Daemon Status : Agent status normal/abnormal check Queue Status : AQ/PQ agent status normal/abnormal check Event Log : Event log occurrence by policy and event count check (RollOver) DelayTime : Normal/abnormal status and value check of delay time according to monitoring threshold (RollOver). Message Count : Check AQ/PQ message block count for each group. 34X-LOG for CDC UI Guide Monitoring interval : Set the monitoring interval (sec) on a group basis. Critical value : You can determine whether it is normal by setting the threshold range according to the delay time. Note Since the MONIMGR agent is in charge of collecting agent status, check the status of the MONIMGR agent if status information cannot be searched. 2-8-2. Detail Monitoring If you select a specific group code, you can check the monitoring information for each group. 35X-LOG for CDC UI Guide 2-8-2-1. Detail Monitoring - Daemon Monitoring ''Daemon Monitoring'' allows you to check the status of the agents constituting X-LOG and the last captured and applied SCN and time. - The value indicated by ''Last SCN'' represents the ''application completion time'' expressed as an SCN value - Application status monitoring may not output anything or may output contents from a past point in time if the MONIMGR agent''s status inquiry interval is set to be long. In this case, change the value of the NR_MON_INT option in the $XL_HOME/XLManager/conf/xl.conf file to shorten the daemon status inquiry interval. Alternatively, check if the monitoring interval and monitoring threshold values have been set. 2-8-2-2. Detail Monitoring - Delay Time Monitoring ''Delay Time Monitoring'' provides detailed messages about Delay Time on a policy basis through the monitoring threshold set for the group undergoing synchronization. ''Delay Time'' indicates the time difference of the ''Application Completion Status'' in the ''Daemon Monitoring'' tab, that is, the time taken for replication to complete from the source database to the target database, compared against the monitoring threshold. 36X-LOG for CDC UI Guide 2-8-2-3. Detail Monitoring - Event Log Monitoring ''Event Log Monitoring'' shows a list of events related to DML, such as integrity errors, that occurred during synchronization. The [{Policy Code} Number of events by State] button at the bottom allows you to check the count by event status for events that occurred in that policy. Event Description Unapplied TX When unapplied data occurs because the Apply agent terminates (Abnormal Termination) abnormally while applying data to the target database. When a DB error such as an integrity error occurs while applying ERR-DB data to the target database. When there is no matching data while performing Update/Delete ERR-0ROW on the target database. When correction is performed on event data using a correction Correction Complete tool. Hextorow Conversion When Hextorow conversion work is performed Complete When data exceeding the column length occurs while applying Column Length Error data to the target database. Error recurred during When an error occurs while performing correction work using a correction correction tool. Other Errors Undefined other error events. Note Occurred events can happen due to various causes such as triggers or constraints depending on site characteristics. X-LOG supports a data correction tool (XLVALIDATOR) to resolve these problems through data correction. 37X-LOG for CDC UI Guide 2-8-2-4. Detail Monitoring - DDL Monitoring ''DDL Monitoring'' shows a list of DDLs related to DDLs such as TRUNCATE and DROP that occurred during synchronization. ''Y'' in the reflection status means that DDL replication application to the target DB has been completed during synchronization. Conversely, if marked as ''N'', it means that DDL replication was not applied, or it could not be applied because of some reason on the target DB during application. In this case, the administrator must manually apply the corresponding DDL, and check the occurrence status by checking the manually applied DDL in the "Event" field. Depending on the user''s confirmation of DDL occurrence, if not confirmed, a pop-up window appears with a Confirm button, and if confirmed, "User has already checked DDL." appears. 38X-LOG for CDC UI Guide 2-9. Report By clicking [Report] from the menu below, you can view the report screen in the Contents area. 2-9-1. Policy Management Reports 2-9-1-1. Policy information The ''Policy Information report allows you to check various policy information, such as multi-application and multi-column, for the policy set by the user in report format. Clicking the ''Excel'' button saves the searched contents as an Excel file, and the default file name is "Policy information.xls". 39X-LOG for CDC UI Guide 2-9-2. Replication Process Reports 2-9-2-1. Daily IUD statistics The ''Daily IUD statistics'' report allows you to check the number of replicated DML processing counts by group in report format. Clicking the ''Excel'' button saves the searched contents as an Excel file (default file name: "Daily IUD statistics.xls"). 2-9-2-2. Average Delay-Time statistics The ''Average Delay-Time statistics'' report allows you to check the average replication time for replication target tables by group or policy unit. Clicking the ''Excel'' button saves the searched contents as an Excel file (default file name: "Average Delay-Time statistics.xls"). 40X-LOG for CDC UI Guide 2-9-3. Error History Reports 2-9-3-1. Capture Error History The capture failure history inquiry allows you to check a list of failures when the Archive Log File cannot be found during capture in report format. The ''completed Check'' column indicates whether the failure has been processed; ''T'' means failure processing is complete, and ''F'' means failure processing is not complete. Clicking the ''Excel'' button saves the searched contents as an Excel file (default file name: "Capture Error History.xls"). 2-9-4. Work History Reports 2-9-4-1. User Work History The ''User Work History'' report displayed the user''s task history list. Clicking the ''Excel'' button saves the searched contents as an Excel file (default file name: " User Work History.xls"). 41X-LOG for CDC UI Guide 2-9-4-2. Replication Schedule Result The ''Replication Schedule Result'' report allows you to check detailed messages about the time and schedule for the replication schedule setup. Clicking the ''Excel'' button saves the searched contents as an Excel file (default file name: " Replication Schedule Result.xls"). 42X-LOG for CDC UI Guide 2-10. User Management 2-10-1. user information Management ''User Information Management'' provides UI user information verification, addition, and deletion. Provided permissions include ''Administrator'' and ''User'' permissions, and users have restricted registration, modification, and deletion functions. Input rules when adding/modifying user information are as follows: Category Description Up to 4~50 characters including alphabets and numbers, and the first ID character must be an alphabet. Up to 8~20 characters including alphabets, numbers, and special Password characters. Name Up to 1~25 characters in Korean and English. Phone Up to 10~11 numeric characters. Email Only email format can be entered. Note The initial X-LOG UI access account ''admin'' is an account for X-LOG engineers, and arbitrary password change and deletion by the user are not possible. 43X-LOG for CDC UI Guide 2-11. Error Notification An alarm occurs at the bottom of the X-LOG UI when a replication error occurs. Details about the alarm can be checked by clicking the bell shape button at the bottom. 2-11-1. View Error Detail Category Description DATE The point in time when the error occurred GROUP The group where the error occurred Indicates the classification of major agents CPMGR, DPMGR, APMGR, Error Type AQ, PQ. Indicates the error message or status for each agent, and provides Error Message messages about replication delay time and event occurrence for the replication group 44X-LOG for CDC UI Guide 3. X-LOG Technical Support and Contact Information 3-1. Technical Support and Contact Information X-LOG technical support provides a one-year free maintenance period starting from the product installation date. After that, maintenance is charged, and a separate maintenance contract is required. X-LOG Co., Ltd. http://www.xlog.co.kr 5th Floor, Jungle Building, Bongeunsa-ro, Nonhyeon-dong, Gangnam-gu, Seoul TEL : 070-5015-3517 FAX : 070-4032-2017 E-mail: ts@xlog.co.kr 45">