Checking Locations are Aligned

A simple check to make sure that locations are aligned is to run a macro which captures the latest session number of each secondary database as compared to the latest session of the Primary database.

Note:
Such a macro could use the Q REMOTE command to query the remote location (Q REMOTE <loc> <dbname> LASTSESSION). The session number can be extracted from the query result.
Q REMOTE ABC MYTEAM/DESI LASTSESSION
Q REMOTE ABC MYTEAM/DESI FILEDETAILS

Assuming it is run when there are no users on the project then the session numbers at all the locations should be identical, however if the Primary db is being used it is likely that the Primary session number will be slightly higher than the Secondary databases. As the intention is that Global runs while users are continuing to work this will be the most common scenario.

If for some reason the Secondary database is higher than the Primary, detailed investigation will be required to realign that database. An example of the type of output from such a macro follows: