Synchronization

About synchronization

Synchronization is the process of replicating specified records from application data files to corresponding database tables that reside on the database server.

The records in the database table are used in directed applications. For example, in a directed warehouse, you would synchronize the F4611 file and use the records from this file to instruct your warehouse workers how to collect data for a put-away, pick, or replenishment transaction.

About the normal update

Through the normal synchronization process, only new records are downloaded from the Trigger Results logical file to the corresponding database table.

The Trigger Results logical file contains the records matching user-defined selection criteria. As records change (add, change, delete) in your application data file, the universal trigger program detects the change and writes a record to the Trigger Results file.The TranConnect Synchronization Agent requests the next available record from the SocketSync Server and downloads it to the database table on the database server.

The data in the Trigger Results files are purged periodically based on the retention day value that is user defined in the SocketSync UDC SS/01 table. TranConnect Synchronization Agent is a multi-threaded program. It allows multiple application data files to run full updates to their corresponding database tables.

The agent also allows normal updates for other Trigger Results files to run at the same time. However, the TranConnect Synchronization Agent cannot perform both normal and full updates on the same file at the same time.

About the full update

Through the full update process, all records that match user-defined selection criteria are downloaded from the application logical file to the corresponding database table.

The full update function replaces all records in the database table with the records in the corresponding logical file. The database table is cleared of all records and becomes an exact image of the logical file.

The TranConnect Synchronization Agent requests a full update from the SocketSync Server. This program selects the records matching the selection criteria and sends them to the agent. The agent retrieves the records and updates the corresponding database table on the database server.

Advanced Inventory recommends that you run the full update on the following occasions.

When synchronizing the database table for the first time
When making a change in your business operations that might affect the filtering of records
When you suspect there is a problem with the synchronized records

Start the synchronization process

Synchronization replicates specified records from application data files to corresponding database tables that reside on the database server.

To start the synchronization process, complete the following steps.

Start the DCLINKSBS subsystem.
On a command line, enter STRSYNCSVR and press F4.

Expected Result

Result: The Start a SocketSync Server form displays.
For SocketSync Server Job Name, enter a job name for the SocketSync Server job.
Verify the default values for the following fields and make updates as necessary.
- IP Port Number
- SocketSync Server Program Library
- Job Description
- Job Description Library
- Job Queue
- Job Queue Library
- Transfer Status User Space Lib
- Submit Purge Job
Step Information

Important:The IP Port Number must match the IP port assigned in the TranConnect Synchronization Agent. You define this parameter in Agent Settings, which runs on a processing server. You system configuration determines where this program runs.
Verify that the SocketSync Server job started by using the WRKSBS command.
- On a command line, enter WRKSBS.
Expected Result
Result: The Work with Subsystems form displays with all active subsystems listed.
In the Opt field, for DCLINKSBS subsystem, enter 8 and press or select ENTER.

Expected Result
Result: The status for all jobs is *ACTIVE.
Close the forms.

Stop synchronization

You can stop synchronization by ending the job through an end job command.

To stop synchronization, complete the following steps.

On a command line, enter WRKSBS.

Expected Result

Result: The Work with Subsystems form displays and lists all active subsystems.
In the Opt field, for DCLINKSBS subsystem, enter 8 and press or select ENTER.
Enter 4 and press or select ENTER to end the job and close the forms.
Close the forms.

There was a problem loading this topic