Implementation Plan April, 2010

Personnel:

Prabhu E Pilli, DBA Implement/verification
Jon Gorrono, QA verification

Communication

server: irc.freenode.net
channel: #ucdsakai

During Maintenance Window
Pre Implementation tasks

(Prabhu) Run the following queries to compare with the results after the fix implementation.

select mothraid,kerberos_name,deleted from sakaiext.mothra_person where mothraid in ('00133387', '00344830', '00600118', '00655505', '00589927', '00618662',
'00597123', '00396833');

   Expected Results:
   MOTHRAID KERBEROS_NAME DELETED
   ===============================================

00133387 dhfeldma/DELETED N
00344830 abarnes/DELETED N
00396833 zee/DELETED Y
00589927 jjhicks N
00597123 zee N
00600118 jazhicks N
00618662 dhfeldma N
00655505 abarnes N

During the Implementation rollout (all times are PST)

(5:45 am, Prabhu) Backup current mothra package body and MOTHRA_PERSON table from SAKAIEXT schema on banner production.
(6:45 am, Mark) Notify UCD about successful run of 6:00 am table switch
(7:30 am to 7:45 am, Prabhu) Download https://mware.ucdavis.edu/svn/ucd-sakai/ucd-database/branches/sakaiext_ban_prod/sakai_external_plsql.sql and run mothra feed package body. Make sure no errors returned.
(7:45 am – 8:00 am, Prabhu) Execute the Mothra feed Package

Data Verification Testing

(8:00 – 8:15am, Prabhu)
- Run the following queries to compare with the results after the fix implementation.

select mothraid,kerberos_name,deleted from sakaiext.mothra_person where mothraid in ('00133387', '00344830', '00600118', '00655505', '00589927', '00618662',
'00597123', '00396833');

   Expected Results:
   MOTHRAID KERBEROS_NAME DELETED
   ===============================================

00133387 dhfeldma/DELETED Y
00344830 abarnes/DELETED Y
00396833 zee/DELETED Y
00589927 jjhicks N
00597123 zee N
00600118 jazhicks Y
00618662 dhfeldma N
00655505 abarnes N

Vote on to go

(8:15 – 8:30, Jon Gorrono) .

Rollback

(8:45 am – 9:30 am Prabhu ) Restore the MOTHRA_PERSON table and mothra feed package body from the backup. Execute the mothra feed package.