Turning On FCS Non-Locking Synchronization

You can use File Collaboration Server (FCS) non-locking synchronization to allow concurrency of file operations during synchronization, and prevent double synchronization.

Before you begin: All databases from 3DEXPERIENCE R2014x and later are set to use non-locking synchronization. For other databases prior to 3DEXPERIENCE R2014x, you must migrate the database to 3DEXPERIENCE R2014x or later before you turn on non-locking synchronization.

Context: To turn on non-locking synchronization:

  1. Start MQL.
  2. Run upgrade fcsfileidupgrade;, the dedicated upgrade command, to populate a new field column on the IxFile table rows.

    The FCS non-locking synchronization algorithm uses the fileID column.

    The system is available for other user activities when you run this command.

  3. Run validate fcsfileidupgrade; to verify that the previous step completes successfully.

    If you see the message: FCSFileIdUpgrade is completed, then go to the next step.

    If you see the message: FCSFileIdUpgrade is required, n unpopulated rows, then go back to step 2 to complete the fileID column population.

    To get more information about the rows that are not yet populated, type:

    validate fcsfileidupgrade show n;

    n is any positive integer. If n is larger than 10000, it resets to 10000 internally.

    For example to see the 10 first rows that still need to be populated: validate fcsfileidupgrade show 10;

    LXFILE_b2d8271c: LXBO:75920053 ,LXFMT:759204938, LXSTORE:759229761, LXLOC:1, LXPATH:test_file.txt, LXALIAS: bb/82/bb82rbnoh9gjiba1rlmm_um0kn4lxihzdbxy-de_tbo.tjr, LXSIZE:451, LXFLAGS:2, LXCRDATE:07-JAN-14 FCSFileIdUpgrade is required, 1 unpopulated rows.

  4. When FCSFileIDUpgrade finishes and is successful, turn on non-locking synchronization:

    set system fcssettings syncconcurrency ON