SYNCHRONIZE STAMPS

The SYNCHRONIZE STAMPS utility manipulates SQL synchronization stamps in the following ways:
idmscu19
The SYNCHRONIZE STAMPS utility manipulates SQL synchronization stamps in the following ways:
  • Displays and compares the stamps in the catalog and the data area(s), issuing a warning if stamps are inconsistent
  • Updates the catalog with the stamps from the data area(s)
  • Updates the data area(s) with the stamps from the catalog
This utility provides an alternate mechanism for taking snapshot copies of identically defined databases and also as an aid in recovery situations in which either the catalog or a data area must be restored independently of each other.
The following topics are discussed on this page:
2
2
Authorization
To
You Need This Privilege
On
Use SYNCHRONIZE STAMPS
DBAWRITE
Every area processed by SYNCHRONIZE STAMPS
Syntax
  ►►─── SYNCHRONIZE STAMPS FOR ┬─ AREA ── segment-name.area-name ┬───────────────►                              └─ SEGMENT segment-name ──────────┘  ►───┬─ UPDATE CATALOG ──┬─────────────────────────────────────────────────────►◄      ├─ UPDATE DATABASE ─┤      └─ COMPARE ─────────┘  
Parameters
  • AREA
    Specifies the area in which to synchronize stamps.
  • segment-name
    Specifies the name of the segment associated with the area.
  • area-name
    Specifies the name of an area included in the DMCL module.
  • SEGMENT
    Specifies the segment whose areas will have their stamps synchronized.
  • segment-name
    Specifies the name of a segment included in the DMCL module.
  • UPDATE CATALOG
    Specifies that the catalog is to be updated with the stamps from the data area(s).
  • UPDATE DATABASE
    Specifies that the area(s) are to be updated with stamps from the catalog.
  • COMPARE
    Displays and compares the stamps in the catalog and the data area(s) and issues a warning if the stamps are inconsistent.
Usage
How to submit the SYNCHRONIZE STAMPS statement
You submit the SYNCHRONIZE STAMPS statement using either the batch command facility or the online command facility.
Use caution when updating stamps
By using the SYNCHRONIZE STAMPS utility to update stamps in a catalog or data area, you are asserting that the definition in the catalog accurately describes data in the area. You should be sure that this is true before updating stamp values. No data validation is performed by the utility.
JCL Considerations
When you submit a SYNCHRONIZE STAMPS statement through the batch command facility in local mode, the JCL to execute the facility must include statements to define the following:
  • File(s) that map to the area to be processed
  • Dictionary that defines the table(s) in the area
  • Journal file(s) if backups are not taken
To run under central version, a SYSCTL statement is needed.
For more information about the generic JCL used to execute the batch command facility, see the section for your operating system in this section.
Examples
The following example directs the SYNCHRONIZE STAMPS utility to compare the synchronization stamps in the USERDB.EMP_AREA with those in the catalog.
synchronize stamps for area userdb.emp_area compare;
Sample Output
The following report sample is produced by the SYNCHRONIZE STAMPS utility.
IDMSBCF  nn.n                     CA IDMS Batch Command Facility                    mm/dd/yy                  PAGE 1 SYNCHRONIZE STAMPS FOR AREA USERDB.EMP_AREA COMPARE; *+ Status = 0        SQLSTATE = 00000                         *** Current Stamps Report ***   Area:USERDB.EMP_AREA                        Table Stamping       Catalog Stamp:  <null>       Database Stamp: <null>           Table ID:1024   Table:DEMO.EMPL               Catalog Stamp:  1993-03-08-14.50.01.952955               Database Stamp: 1993-03-08-14.50.01.952955           Table ID:1025   Table:DEMO.POSITION               Catalog Stamp:  1993-03-08-14.50.01.668147               Database Stamp: 1993-03-08-14.50.01.668147           Table ID:1026   Table:DEMO.MANAGERS               Catalog Stamp:  1993-03-08-14.50.01.952955               Database Stamp: 1993-03-08-14.50.01.952955           Table ID:1027   Table:INV.PART               Catalog Stamp:  1996-06-18-10.40.51.839925               Database Stamp: 1996-06-18-10.40.51.839925           Table ID:1028   Table:INV.COMPONENT               Catalog Stamp:  1996-06-18-10.40.51.839925               Database Stamp: 1996-06-18-10.40.51.839925           Table ID:1029   Table:EMP.T5               Catalog Stamp:  2001-11-05-09.31.31.638046               Database Stamp: 2001-11-05-09.31.31.638046           Table ID:1030   Table:LRD.EMPL               Catalog Stamp:  2002-06-28-15.11.18.494317               Database Stamp: 2002-06-28-15.11.18.494317           Table ID:1031   Table:JPD.T5               Catalog Stamp:  1999-06-21-13.04.08.968700               Database Stamp: 1999-06-21-13.04.08.968700
For more information about synchronization stamps, see and .