Running Global Projects
Suggested Housekeeping Guidelines for Projects
:
Global
: Checking Locations are Aligned
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:
DBnumber
DBname
Session_SAT1
Session_SAT2
Session_SAT3
Session_HUB
2001
SAT1PIPING/UNITA
P 1134
S 1128
S 1128
S 1128
2000
SAT1PIPING/UNITB
P 684
S 679
S 679
S 679
2002
SAT1PIPING/UNITC
P 106
S 106
S 107
S 106
2003
SAT1PIPING/UNITD
P 758
S 742
S 692
S 742
2004
SAT1PIPING/UNITE
P 533
S 517
S 467
S 517
2457
SAT3PIPING/UNITA
S 1164
S 1164
P 1169
S 1164
2451
SAT3PIPING/UNITB
S 814
S 793
P 849
S 814
2432
SAT3PIPING/UNITC
S 131
S 131
P 133
S 131
2431
SAT3PIPING/UNITD
S 451
S 451
P 453
S 451
2100
HUBPIPING/UNITA
S 1148
S 1148
S 1148
P 1175
2102
HUBPIPING/UNITB
S 212
S 212
S 212
P 213
2104
HUBPIPING/UNITC
S 231
S 231
S 231
P 234
2355
SAT2PIPING/UNITA
S 560
P 562
S 560
S 560
2353
SAT2PIPING/UNITB
S 288
P 328
S 288
S 324
2351
SAT2PIPING/UNITC
S 513
P 578
S 484
S 541
2351
SAT2PIPING/UNITD
S 79
P 101
S 79
S 79
2343
SAT2PIPING/UNITE
S 174
P 176
S 174
S 174
1974 to current year.
AVEVA Solutions Limited and its subsidiaries. All rights reserved.
