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.