Skip to Content

 

  

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see ALTER and BMC AMI Change Manager for Db2 13.1.

-SYNC (Sync point)

The -SYNC command creates a sync table entry and executes a Db2 COMMIT WORK statement.

The text of the command includes a comment that is recorded in the sync table. The Analysis component creates these commands at required intervals in a worklist. Analysis also uses the SYNCPOINT keyword in the ALUIN input stream to create additional -SYNC commands in a worklist based on the number of -SQL commands since the last -SYNC command. 

-RNST 000630   RUNSTATS TABLESPACE RESTATE.PROPERTY
               INDEX (ALL)
-SYNC 000640 CHECKPOINT AFTER RUNSTATS
********************************************************
-AUTH 000690 JEO
-REBD 000700 REBIND PLAN ALUAPL1
             VALIDATE(BIND) ISOLATION(CS)
             ACQUIRE(USE)  RELEASE(COMMIT) EXPLAIN(NO)
-AUTH 000710
-SYNC 000720 END OF REBIND PLANS SECTION
********************************************************
-COPY 000730
             COPY TABLESPACE RESTATE.PROPERTY
             DEVT TAPE   COPYDDN SYSC1001
-SYNC 000740 CHECKPOINT AFTER IMAGE COPY
********************************************************
Warning

Note

The product might truncate the name of an object in the -SYNC command if the name contains up to 128 characters. To determine the full name of the object, review the worklist command that precedes the -SYNC command in the worklist.

A -STOP command records a RESTART point and halts processing, while a -SYNC command records a RESTART point and continues processing. Because they mark RESTART points, -SYNC commands should not be removed.

You can insert additional parameters as allowed by Db2 in this command. Execution passes these parameters unchanged to the Db2 utility.

The CM/PILOT component of BMC AMI Change Manager for Db2 also uses the -SYNC command in a CM/PILOT worklist. The sync table entries are created during CM/PILOT worklist processing. You can view the sync table entries for task IDs.

A -SYNC command includes one of the following values in a CM/PILOT worklist:

  • END OF ANALYSIS SECTION
  • END OF BASELINE REPORT SECTION
  • END OF BASELINE SECTION
  • END OF BATCH JCL SECTION
  • END OF COMPARE SECTION
  • END OF DELETE WORKID SECTION
  • END OF IMPORT SECTION
  • END OF REPLICATE WORKID SECTION


Related topic

Worklist-commands



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

ALTER and BMC AMI Change Manager for Db2 12.1