L14 release schedule


Project Start Date: 12/3/00 12:01 AM
Project Finish Date: 12/18/00 3:00 PM

Task_Data

ID
Task_Name
DurationStart_DateFinish_DatePredecessorsResource_Names
1
Release L14 - Release Schedule
46.87 days?12/3/00 12:01 AM12/18/00 3:00 PM  
2
Release L14 Certification
0 days12/12/00 12:01 AM12/12/00 12:01 AM Everyone
3
Pre-push tasks
44.76 days12/3/00 12:01 AM12/17/00 10:05 PM  
4
DBAs
17.76 days12/12/00 12:01 AM12/17/00 10:05 PM  
5
Write audit scripts for release
3 days12/12/00 12:01 AM12/13/00 4:01 AM2Ramesh
6
Export Skinner tables from tsp@stage
30 mins12/15/00 10:05 PM12/15/00 10:35 PM48FS-6 daysVishal
7
Export Resource tables from tsp@stage
30 mins12/15/00 10:35 PM12/15/00 11:05 PM6Vishal
8
Move the Skinner and Resource .dmp files to PROD
30 mins12/15/00 11:05 PM12/15/00 11:35 PM7Vishal
9
Verify scripts installed on db1 are correct
30 mins12/15/00 11:35 PM12/16/00 12:05 AM8Vishal
10
Accelerate hot backup at 8:00 and comment out cron entry for hot backup
5 mins12/16/00 12:05 AM12/16/00 12:10 AM9Ramesh
11
Run audit scripts against PROD for baseline information
30 mins12/16/00 12:10 AM12/16/00 12:40 AM10Ramesh
12
Add tablespaces to PROD for L14
2 hrs12/12/00 12:01 AM12/12/00 2:01 AM2Vishal
13
Run snapshots 1 hour before release
30 mins12/17/00 9:05 PM12/17/00 9:35 PM48FS-1 hrVishal
14
Export tsp_environment
30 mins12/17/00 9:35 PM12/17/00 10:05 PM13Vishal
15      
16
Sys Admins
0.03 days12/3/00 12:01 AM12/3/00 12:16 AM  
17
Rollout app servers for Portal
0 days12/3/00 12:01 AM12/3/00 12:01 AM Dan
18
Rollout db servers for Portal
0 days12/3/00 12:01 AM12/3/00 12:01 AM Dan
19
Rollout Alteon ACE Director for Portal
0 days12/3/00 12:01 AM12/3/00 12:01 AM Arnold
20
Update Redzone messaging for outage window
15 mins12/3/00 12:01 AM12/3/00 12:16 AM Mike L
21      
22
Operations Lead
0 days12/12/00 12:01 AM12/12/00 12:01 AM  
23
Schedule Final Release Meeting (launch minus 1 day)
0 days12/12/00 12:01 AM12/12/00 12:01 AM2Matt
24
Setup Conference Call via AT&T
0 days12/12/00 12:01 AM12/12/00 12:01 AM23Matt
25      
26
Release Engineering
0.59 days12/12/00 12:01 AM12/12/00 4:46 AM  
27
Create app server tar ball on stage
30 mins12/12/00 12:01 AM12/12/00 12:31 AM2Keith
28
Create MEP tar ball on stage
15 mins12/12/00 12:31 AM12/12/00 12:46 AM27Keith
29
Massage the app server tar ball so that configuration is correct for PROD env
30 mins12/12/00 12:46 AM12/12/00 1:16 AM28Keith
30
Move the app server tar ball to PROD app and http servers machines and untar
1 hr12/12/00 1:16 AM12/12/00 2:16 AM29Keith
31
Move the app server tar ball to PROD graph server machines and untar
15 mins12/12/00 2:16 AM12/12/00 2:31 AM30Keith
32
Move the MEP tar ball to BFS1
15 mins12/12/00 2:31 AM12/12/00 2:46 AM31Keith
33
Copy PL/SQL scripts from app codebase to db server
30 mins12/12/00 2:46 AM12/12/00 3:16 AM32Keith
34
Create L14 migration script tar ball
1 hr12/12/00 3:16 AM12/12/00 4:16 AM33Keith
35
Move migration script tar ball to PROD and untar
30 mins12/12/00 4:16 AM12/12/00 4:46 AM34Keith
36      
37
Pre-release L14 Infranet testing
7.69 days12/12/00 12:01 AM12/14/00 1:30 PM  
38
Setup 'thrash' instance on db2
4 hrs12/12/00 12:01 AM12/12/00 4:01 AM2Mahender
39
App servers configured
1 hr12/12/00 12:01 AM12/12/00 1:01 AM2,17,18,19Mike L
40
Install L14 code on AS6 and HTTP3
4 hrs12/12/00 12:01 AM12/12/00 4:01 AM2Keith
41
Price lists installed
1 hr12/12/00 8:00 AM12/12/00 9:00 AM2Allen
42
Coldbackup of PORTAL database
4 hrs12/12/00 9:00 AM12/12/00 1:00 PM41Ramesh
43
Remove AS6 and HTTP3 from the production loop
30 mins12/12/00 1:00 PM12/12/00 1:30 PM42Mike L
44
Test Dynamo to Portal interfaces
1 day12/12/00 1:30 PM12/13/00 1:30 PM43Luke
45
Infranet administrator testing
1 day12/13/00 1:30 PM12/14/00 1:30 PM44CS
46      
47
Release Tasks
1.6 days12/17/00 10:00 PM12/18/00 10:50 AM  
48
Conference call starts - final decision point
5 mins12/17/00 10:00 PM12/17/00 10:05 PM Everyone
49
Enable Redzone via admin console
55 mins12/17/00 10:05 PM12/17/00 11:00 PM48Mike L
50
Validate service component disablement
0 days12/17/00 10:05 PM12/17/00 10:05 PM48Mike B
51
Disable cron jobs, foglight alerts
15 mins12/17/00 10:05 PM12/17/00 10:20 PM50Mike L
52
Site is taken down - redirected to outage page
0 days12/17/00 11:00 PM12/17/00 11:00 PM Mike L
53
Validate outage notice
0 days12/17/00 11:00 PM12/17/00 11:00 PM52Mike B
54
Application servers are shutdown
3 mins12/17/00 11:00 PM12/17/00 11:03 PM53Mike L
55
Verify DB connections are shutdown
1 min12/17/00 11:03 PM12/17/00 11:04 PM54Vishal
56
Switch logs on db1
3 mins12/17/00 11:04 PM12/17/00 11:07 PM55Vishal
57
Run snapshots
30 mins12/17/00 11:07 PM12/17/00 11:37 PM56Vishal
58
Move logs on to db2
5 mins12/17/00 11:37 PM12/17/00 11:42 PM57Ramesh
59
Change dynamo symlinks
3 mins12/17/00 11:03 PM12/17/00 11:06 PM54Mike L
60
Run makeCorpSite script for http1-6 and as1-5
3 mins12/17/00 11:06 PM12/17/00 11:09 PM59Mike L
61
Untar MEP tar ball
2 mins12/17/00 11:09 PM12/17/00 11:11 PM60Keith
62
Wait for logs to apply to db2 (sync with db1)
5 mins12/17/00 11:42 PM12/17/00 11:47 PM58Ramesh
63
Drop snapshot logs
15 mins12/17/00 11:47 PM12/18/00 12:02 AM62Vishal
64
Shutdown standby instance and listener on db2
2 mins12/17/00 11:47 PM12/17/00 11:49 PM62Ramesh
65
Shutdown PROD instance and listener on db1
2 mins12/18/00 12:02 AM12/18/00 12:04 AM63Vishal
66
Startup PROD instance and listener on db1
2 mins12/18/00 12:04 AM12/18/00 12:06 AM65Vishal
67
Run DataNorm migration scripts
0.08 days12/18/00 12:06 AM12/18/00 12:44 AM  
68
Address Group
15 mins12/18/00 12:06 AM12/18/00 12:21 AM66Vishal
69
Login
3 mins12/18/00 12:21 AM12/18/00 12:24 AM68Vishal
70
Consumer 2.0
4 mins12/18/00 12:24 AM12/18/00 12:28 AM69Vishal
71
Patch (Login optimization)
2 mins12/18/00 12:28 AM12/18/00 12:30 AM70 
72
International Shipping
10 mins12/18/00 12:30 AM12/18/00 12:40 AM71Vishal
73
Migration
2 mins12/18/00 12:40 AM12/18/00 12:42 AM72Vishal
74
Run Audit scripts
2 mins12/18/00 12:42 AM12/18/00 12:44 AM73Ramesh
75
Run Catalog Lite migration scripts
16 mins12/18/00 12:44 AM12/18/00 1:00 AM74Vishal
76
Run Audit scripts
2 mins12/18/00 1:00 AM12/18/00 1:02 AM75Ramesh
77
Run CSP migration scripts
3 mins12/18/00 1:02 AM12/18/00 1:05 AM76Vishal
78
Run Audit scripts
2 mins12/18/00 1:05 AM12/18/00 1:07 AM77Ramesh
79
Run small projects migration scripts
1 min12/18/00 1:07 AM12/18/00 1:08 AM78Vishal
80
Run Audit scripts
2 mins12/18/00 1:08 AM12/18/00 1:10 AM79Ramesh
81
Run WATR migration scripts
17 mins12/18/00 1:10 AM12/18/00 1:27 AM80Vishal
82
Run Audit scripts
2 mins12/18/00 1:27 AM12/18/00 1:29 AM81Ramesh
83
Run updated PL/SQL package scripts
6 mins12/18/00 1:29 AM12/18/00 1:35 AM82Vishal
84
Import Resource tables to tsp@prod (validate row counts)
15 mins12/18/00 1:35 AM12/18/00 1:50 AM83Vishal
85
Import Skinner tables to tsp@prod (validate row counts)
15 mins12/18/00 1:50 AM12/18/00 2:05 AM84Vishal
86
Run Audit scripts
2 mins12/18/00 2:05 AM12/18/00 2:07 AM85Ramesh
87
Create snapshot logs (before site goes live)
15 mins12/18/00 2:07 AM12/18/00 2:22 AM86Vishal
88
Shutdown and restart PROD instance and listener
4 mins12/18/00 2:22 AM12/18/00 2:26 AM87Vishal
89
DBA QA time for reviewing contstraints
10 mins12/18/00 2:26 AM12/18/00 2:36 AM88Vishal,Ramesh
90
Add dnsCheck cron job
15 mins12/17/00 11:09 PM12/17/00 11:24 PM60Mike L
91
Reconfigure as1 to point to http3.bigstep.com instead of www.bigstep.com
5 mins12/18/00 2:07 AM12/18/00 2:12 AM86Mike L
92
Validate base functions
40 mins12/18/00 2:12 AM12/18/00 2:52 AM91Mike B
93
Reconfigure as1 to point to www.bigstep.com instead of http3.bigstep.com
5 mins12/18/00 2:52 AM12/18/00 2:57 AM92Mike L
94
Start all app servers
5 mins12/18/00 2:57 AM12/18/00 3:02 AM93Mike L
95
Start migrations via admin console
5 mins12/18/00 3:02 AM12/18/00 3:07 AM94Mike L
96
Monitor status of migrations for failure rates
60 mins12/18/00 3:07 AM12/18/00 4:07 AM95Kirt
97
Bring up entire service
1 min12/18/00 4:07 AM12/18/00 4:08 AM96Mike L
98
Re-enable cron jobs, foglight alerts
5 mins12/18/00 4:08 AM12/18/00 4:13 AM97Mike L
99
Kickoff load_reporting.sh on bfs1
1 min12/18/00 4:13 AM12/18/00 4:14 AM98Mike L
100
Kickoff sustained load test against production
90 mins12/18/00 4:14 AM12/18/00 5:44 AM99Mike B
101
Send email to notify customers that the service is back online
5 mins12/18/00 5:44 AM12/18/00 5:49 AM100Mike L
102
Monitor system performance
1 hr12/18/00 5:49 AM12/18/00 6:49 AM101Mike L,Matt
103
Re-enable cron job on db2 for standby
1 min12/18/00 10:49 AM12/18/00 10:50 AM102FS+0.5 daysRamesh
104      
105
Post-rollout support staff
46.87 days?12/3/00 12:01 AM12/18/00 3:00 PM  
106
On-site
1.06 days12/18/00 6:30 AM12/18/00 3:00 PM  
107
Sys Admin
8 hrs12/18/00 6:30 AM12/18/00 2:30 PM102Seth
108
DBA
8 hrs12/18/00 6:30 AM12/18/00 2:30 PM102Mahender
109
Engineers
8 hrs12/18/00 7:00 AM12/18/00 3:00 PM102 
110
Off-site
1 day?12/3/00 12:01 AM12/3/00 8:01 AM