DB Wiki

Log on as GGATE user

Run on ANDRACAA

exec mol_sequences.mol_seqoddeven('FBIAGENT');
exec mol_sequences.mol_seqoddeven('MAILONLINE');

Run on MOLBB

exec mol_sequences.mol_seq_alternate('FBIAGENT');
exec mol_sequences.mol_seq_alternate('MAILONLINE');

SQL Statement to Check that the above was Successful

set lines 120
col sequence_name format a30

select owner, sequence_name, valueint ANDRACA_VALUE, valuepoc MOLBB_VALUE,
       case when mod(ValueInt,2) = mod(ValuePOC,2) then 'ERROR'
         else 'ODD EVEN SUCCESS'
       end Validation
from ggate.mol_gg_sequences where owner in ('FBIAGENT','MAILONLINE')
order by owner, sequence_name;

ALTER USER ANALYTICS ACCOUNT UNLOCK;
ALTER USER ANDCOMMUNITIES ACCOUNT UNLOCK;
ALTER USER APTECO ACCOUNT UNLOCK;
ALTER USER CLEARSPACE ACCOUNT UNLOCK;
ALTER USER CSMIG ACCOUNT UNLOCK;
ALTER USER EAGLEEYE ACCOUNT UNLOCK;
ALTER USER FBIAGENT ACCOUNT UNLOCK;
ALTER USER GATEKEEPER ACCOUNT UNLOCK;
ALTER USER GATEKEEPERADMIN ACCOUNT UNLOCK;
ALTER USER GKREAD ACCOUNT UNLOCK;
ALTER USER JOBMANAGER ACCOUNT UNLOCK;
ALTER USER MAILONLINE ACCOUNT UNLOCK;
ALTER USER MAILREAD ACCOUNT UNLOCK;
ALTER USER MOFEEDS ACCOUNT UNLOCK;
ALTER USER MOLAPP ACCOUNT UNLOCK;
ALTER USER MOLEM ACCOUNT UNLOCK;
ALTER USER MOLSUPP ACCOUNT UNLOCK;
ALTER USER MOUSER ACCOUNT UNLOCK;
ALTER USER SCHOOL ACCOUNT UNLOCK;
ALTER USER TIMBOARDS ACCOUNT UNLOCK;
ALTER USER TIMDEBATE ACCOUNT UNLOCK;
ALTER USER TRAVELMAIL ACCOUNT UNLOCK;