{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Old","PopupProjectTasklist","Setup & Prep Checklist","ChangeHistory","Assumptions"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Old","index":0,"n_rows":76,"n_cols":9,"rows_kept":76,"cut":false,"hidden":true,"merged":[]}
["Project name","TEMPLATE FOR PROJECT TASK LIST FOR DELPHIX MAINFRAME Project"]
["Project manager","Gajalakshmi Sundararajan"]
["Project start date","2022-03-28"]
["Project finish date","2022-04-13"]
["Duration","13 days"]
["% complete",0]
["Exported on","2022-03-22"]
[]
["Task number","Outline number","Name","Assigned to","Duration","Start","Finish","Depends on","% complete"]
[null,1,"Infrastructure"]
[1,1.1000000000000001,"Linux/VM",null,null,"3/28/2022","2022-07-04",null,0]
[2,"1.1.1","VM Teams create/change VMs as per Blueprint","PopupLinux + ClientLinux","6 days","3/28/2022","2022-04-04",null,0]
[3,"1.1.2","Download OVA for VMware Sphere","PopupLinux + ClientLinux","2 days","3/28/2022","3/29/2022",null,0]
[4,"1.1.3","Reinstall PopUp on (Source VM) - Run new OVA","PopupLinux + ClientLinux","1 day","3/30/2022","3/30/2022","3 - Download OVA for VMware Sphere",0]
[5,"1.1.4","VM Team - Add disk to Delphix Virtualization VM as per blueprint","PopupLinux + ClientLinux","1 day","3/28/2022","3/28/2022",null,0]
[6,"1.1.5","Delphix appliances - config & performance health check","PopupLinux + ClientLinux","1 day","3/29/2022","3/29/2022","5 - VM Team - Add disk to Delphix Virtualization VM as per blueprint",0]
[7,"1.1.6","Delphix appliances - config changes if required based on health check","PopupLinux + ClientLinux","2 days","3/30/2022","3/31/2022","6 - Delphix appliances - config & performance health check",0]
[8,"1.1.7","Check Port assignment for Linux VMs (should be same as POC)","PopupLinux + ClientLinux","1 day","2022-05-04","2022-05-04","5 - VM Team - Add disk to Delphix Virtualization VM as per blueprint",0]
[9,"1.1.8","Install new Delphix Engine Virtualization","PopupLinux + ClientLinux","1 day","3/29/2022","3/29/2022","5 - VM Team - Add disk to Delphix Virtualization VM as per blueprint",0]
[10,"1.1.9","Create an Environment in Delphix","PopupLinux + ClientLinux","1 day","2022-06-04","2022-06-04","8 - Check Port assignment for Linux VMs (should be same as POC)",0]
[11,"1.1.10","Check toolkit and EDSI","PopupLinux + ClientLinux","1 day","2022-01-04","2022-01-04","9 - Install new Delphix Engine Virtualization",0]
[12,"1.1.11","Configure D-Source","PopupLinux + ClientLinux","1 day","2022-07-04","2022-07-04","11 - Check toolkit Toolkit and EDSI",0]
[13,"1.1.12","Setup License Server(Linux)","PopupLinux + ClientLinux","1 day"]
[14,1.2,"Mainframe"]
[15,"1.2.1","Install Migration Server","IBM Mainframe System Programmer","1 day",null,null,"-",1]
[16,"1.2.2","Set up Transport Volumes (3 x 53Gb) (non-SMS) ","ClientMainframe","1 day",null,null,"-"]
[17,"1.2.3","Install Corraling Utility","PopupMainframe + IBM Mainframe System Programmer","1 day",null,null,"-"]
[18,1.3,"Popup(Mainframe)"]
[19,"1.3.1","Userid setup","PopupMainframe","1 day",null,null,4]
[20,"1.3.2","Userid Logon Validation","PopupMainframe","1 day",null,null,19]
[21,2,"Migration to Popup"]
[22,2.1,"      Data Migration Setup"]
[23,"2.1.1","Install/Customise (De-)Corraling Utility","PopupMainframe","1 day",null,null,4]
[24,"2.1.2","Check Firewall and Ports between LPAR and PopUp","IBM Mainframe System Programmer + Network Team and PopupLinux","1 day","3/31/2022","3/31/2022",8,1]
[25,"2.1.3","Check Security on Server Migration Utility","ClientMainframe","1 day","3/31/2022","3/31/2022",15,0]
[26,"2.1.4","Check VOLSER for Migration Server","PopupLinux ","1 day","3/31/2022","3/31/2022",4,0]
[27,"2.1.5","Test Corraling utility to add 1+ datasets to transport volume","IBM Mainframe System Programmer+ PopupMainframe","1 day",null,null,26]
[28,"2.1.6","Test transfer of volume using Migration Server to zD&T","IBM Mainframe System Programmer+ PopupMainframe","1 day","2022-04-04","2022-04-04","27,24,25  ( 24 - Check Firewall and Ports between LPAR and PopUp, 25 - Check Security on Server Migration Utility",0]
[29,"2.1.7","Test De-Corraling to complete transfer of data to Popup","PopupMainframe","1 day",null,null,28]
[30,3,"Discover Mainframe Application Subsystems and Data for Gold Copy",null,"8 days","2022-04-04","4/13/2022",null,0]
[31,3.1,"      Identify Applications in scope",null,null,null,null,"-"]
[32,"3.1.1","           (For each in scope application):"]
[33,"3.1.1","     Identify / size all subsystem DB2 objects","IBM DB2 System Programmer and GSL Application DBA +PopUpMainframe  ","1 day","2022-04-04","2022-04-04",31,0]
[34,"3.1.1.1","     …..."," ",0,null,null,31]
[35,"3.1.2","     Identify / Size all subsystem CICS objects","IBM CICS System Programmer + PopUpMainframe","tbc","2022-04-04","2022-04-04",31,0]
[36,"3.1.3","     Identify and Size subsystem other objects i.e. files, JCLs, Batch jobs , Procs etc","GSL Application TEAM + PopUpMainframe","1 day","2022-04-04","2022-04-04",31,0]
[37,"3.1.4","     Gather, Understand Install and Shakedown instructions","GSL Application TEAM + PopUpMainframe","2 days","2022-04-04","2022-05-04",31,0]
[38,"3.1.5","     Liaise with SME's (Application / DB2 /  etc ) as required","GSL Application TEAM + PopUpMainframe",0,null,null,31]
[39,"3.1.6","Application Discovery document Complete","GSL Application TEAM",0,null,null,"33,34,35,36,37,38"]
[40,3.2,"Migrate Application",null,null,null,null,29]
[41,"3.2.1","           (For each in scope application):   ie GSL","PopupMainframe"]
[42,"3.2.1.1","                Application components:"]
[43,"3.2.1.1.1","                   DB2:  capture DDL for tables","PopupMainframe","1 day",null,null,30]
[44,"3.2.1.1.2","                   Corral all application objects (not data)","PopupMainframe","tbc",null,null,30]
[45,"3.2.1.1.3","                   Transfer Application objects (not data) to Popup","PopupMainframe","tbc",null,null,"43,44"]
[46,"3.2.1.1.4","                   Decorral Application objects","PopupMainframe","tbc",null,null,45]
[47,"3.2.1.1.5","                   Build application on Popup","PopupMainframe",null,null,null,46]
[48,"3.2.1.1.5.1","                        create tables and other objects on PopUp","PopupMainframe","2 day",null,null,50]
[49,"3.2.1.1.5.2","                        Customise JCL ","PopupMainframe","tbc",null,null,"48,50"]
[50,"3.2.1.1.5.3","                        Customise DB2 if required","PopupMainframe","tbc",null,null,47]
[51,"3.2.1.1.6","                   Populate with application data:","PopupMainframe"]
[52,"3.2.1.1.6.1","                      Unload of DB2 tables / imagecopies ( Timeline agreed)","PopupMainframe + GSL Application DBA","tbc",null,null,39]
[53,"3.2.1.1.6.2","                      Corral required Application objects (DATA)","PopupMainframe","tbc",null,null,52]
[54,"3.2.1.1.6.3","                      Transfer Application objects (DATA) to Popup","PopupMainframe","tbc",null,null,53]
[55,"3.2.1.1.6.4","                      Decorral Application objects (DATA)","PopupMainframe","tbc",null,null,54]
[56,"3.2.1.1.6.5","                      DB2: Load db2 tables","PopupMainframe","tbc",null,null,"55,48"]
[57,"3.2.1.1.7","                  Shake down Application","PopupMainframe",null,null,null,"56,47"]
[58,"3.2.1.1.7.1","                        tbc","PopupMainframe","tbc",null,null,57]
[59,4,"zD&T virtualisation",null,"4 days","2022-08-04","4/13/2022",null,0]
[60,"4.0.1","Start / Stop Server - Ready for Delphix Ingestion","PopupLinux","4 days","2022-05-04","2022-08-04",null,0]
[61,"4.0.2","Shake down All subsystems","PopupLinux","2 days","2022-07-04","2022-08-04",null,0]
[62,"4.0.3","Ingest PopUp and Virtualize the Gold Copy","PopupLinux","1 day","2022-11-04","2022-11-04","4 - Reinstall PopUp on (Source VM) - Run new OVA, 28 - Start / Stop Server - Ready for Delphix Ingestion",0]
[63,"4.0.4","Verify Virtual PopUp Subsystem - Log onto CICS application on virtual PopUp","PopupLinux","1 day","2022-12-04","2022-12-04",null,0]
[64,"4.0.5","Verify Virtual PopUp for All Subsystems","PopupLinux","2 days","2022-08-04","2022-11-04",null,0]
[65,"4.0.6","Run and test Batch Jobs for Subsystems","PopupLinux","2 days","2022-12-04","4/13/2022",null,0]
[66,"4.0.7","Document and Handover to Client","PopupLinux",0,null,null,null,0]

{"sheet":"PopupProjectTasklist","index":1,"n_rows":368,"n_cols":8,"rows_kept":368,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Task List for Popup Virtualization of an Application(s)"]
["Task No","Outline number","Task Name","Estimated \nEffort\n(days)","Assigned to","CURRENT STATUS","Location of Document Template","Final version of document, edited for this specific project"]
[1,1,"Project Definition & Kickoff"]
[2,1.1000000000000001,"       Project Kick off meeting",null,"PopUp Manager","NOT STARTED"]
[3,1.2,"       Project Scope workshop",null,"PopUp Manager","NOT STARTED"]
[4,1.3,"       Create use cases, validation points, test plan",null,"PopUp Manager","NOT STARTED","http://docs.popup-mainframe.com/files/A1%20-%20CLIENT%20ProjectName%20-%20Use%20Cases%20%26%20Validation%20Points_V0.01.pptx"]
[5,1.4,"       Create Project charter",null,"PopUp Manager","NOT STARTED"]
[6,1.5,"       Review the project charter",null,"Client","NOT STARTED"]
[7,1.6,"       Sign off the project charter",null,"Client","NOT STARTED"]
[8,null,"MILESTONE  Project Definition & Kickoff completed"]
[9,2,"Architecture & Application Discovery​"]
[9,2.1,"       Architecture questionnaire"]
[11,"2.1.1","             Architecture workshop - discuss/share the current application/scope architecture",null,"Client + PopUpMFLead","NOT STARTED","http://docs.popup-mainframe.com/files/A1%20-%20CLIENT%20ProjectName%20-%20PopUp_and_Delphix_Architecture_Questionnaire_V0.01.xlsx"]
[12,"2.1.2","             Update the Architecture questionnaire ",null,"Client","NOT STARTED"]
[13,"2.1.3","             Review of the Architecture questionnaire updates",null,"Client + PopUpMFLead","NOT STARTED"]
[14,"2.1.4","             Sign off of the Architecture questionnaire document",null,"Client","NOT STARTED"]
[15,null,"MILESTONE   Architecture questionnaire completed"]
[16,2.2000000000000002,"         Infrastructure Blueprint "]
[17,"2.2.1","              Internal Discussion to Create Blueprint as per Clients Architecture Questionnaire",null,"PopUpMFLead+PopUpLINUXLead"]
[18,"2.2.2","             share the Infrastructure Blueprint(VM reqs,memory etc) of Delphix to the Client & Discussion",null,"Client + PopUpLINUXLead","NOT STARTED"]
[19,"2.2.3","             share the Infrastructure Blueprint(VM reqs,memory etc) of  Popup to the Client & Discussion",null,"Client + PopUpLINUXLead","NOT STARTED"]
[20,"2.2.4","             Client to Review the Infrastructure Blueprint(s) of Popup & Delphix shared by Popup Team",null,"Client","NOT STARTED"]
[21,"2.2.5","             Sign off/Agreement on the VM specifications/Infrastructure Blueprint",null,"Client","NOT STARTED"]
[22,null,"MILESTONE   Infrastructure Blueprint completed"]
[23,2.2999999999999998,"        Discover Mainframe Application Subsystems and Data for Gold Copy",null,null,"NOT STARTED"]
[24,"2.3.1","             Identify Applications in scope"]
[25,"2.3.2","                  <Application Name> (for each of the application)"]
[26,"2.3.2.1","                    Liaise with SME's (Application / DB2 /  etc ) as required",null,"Client+PopUpMFLead+PopUpMFDeveloper"]
[27,"2.3.2.2","                     Client to update the Application Discovery document ",null,"Client",null,"http://docs.popup-mainframe.com/files/A2%20-%20CLIENT%20ProjectName%20-%20Application%20Discovery_V0.01.xlsm"]
[28,"2.3.2.3","                    Review of the Application Discovery document",null,"PopUpMFLead + PopUpMFDeveloper"]
[29,"2.3.2.4","                    Sign off of the Application Discovery document",null,"Client"]
[30,null,"MILESTONE   Identify Applications in scope completed"]
[31,null,"MILESTONE   Application Discovery document Sign off  completed"]
[32,2.4,"Formulate Solution ( Create PopUp Architecture Design Document)"]
[33,"2.4.1","         Formulate Solution"]
[34,"2.4.1.1","            Create PopUp Architecture Design Document",null,"PopUpMFLead+PopUpLINUXLead"]
[35,"2.4.1.2","            Review/Rework PopUp Architecture Design Document",null,"Client + PopUpMFLead+PopUpLINUXLead","NOT STARTED"]
[36,"2.4.1.3","             Signoff of the  PopUp Architecture Design Document (PADD)",null,"Client"]
[37,null,"MILESTONE  PADD Sign off completed"]
[38,null,"MILESTONE  Architecture & Application Discovery completed"]
[39,3,"Popup(Mainframe) Infrastructure Setup & Basic Configuration"]
[40,3.1,"     Share OVA to Client",null,"PopUpLINUXLead","NOT STARTED"]
[41,3.2,"     Download OVA ( ~ 60 GB)",null,"Client","NOT STARTED"]
[42,3.3,"     VM Teams create/change VMs as per Blueprint shared by PopUp Team",null,"Client","NOT STARTED"]
[43,3.4,"     Network / firewall changes (if required )",null,"Client","NOT STARTED"]
[44,null,"MILESTONE   Create VM as per Blueprint for Popup Mainframe completed"]
[45,3.5,"     OVAs Config and Validation",null,"PopUpLINUXLead","NOT STARTED"]
[46,"3.5.1","          OVAs Config & performance health check - Validation ",null,"PopUpLINUXLead","NOT STARTED"]
[47,"3.5.2","          OVAs Config changes if required   ",null,"PopUpLINUXLead","NOT STARTED"]
[48,"3.5.3","          OVAs health check validated ",null,"PopUpLINUXLead","NOT STARTED"]
[49,null,"MILESTONE   OVA Config and Validation completed"]
[50,3.6,"      Setup POpUP Source,Target and license server",null,null,"NOT STARTED"]
[51,"3.6.1","      Config PopUp license server , Config PopUp Source & Target Server",null,"PopUpLINUXLead","NOT STARTED"]
[52,"3.6.2","     Generate & apply PopUp license key",null,"PopUpLINUXLead","NOT STARTED"]
[53,"3.6.3","      Start z/OS on PopUp Source",null,"PopUpLINUXLead","NOT STARTED"]
[54,null,"MILESTONE   Setup POpUP Source,Target and license server  completed"]
[55,null,"MILESTONE   Popup(Mainframe) Infrastructure Setup & Basic Configuration completed"]
[56,4,"Delphix Virtualzation Infrastructure Setup & Basic Configuration",null,null,"NOT STARTED"]
[57,4.0999999999999996,"     Share OVA to Client",null,"PopUpLINUXLead","NOT STARTED"]
[58,4.2,"Download OVA",null,"Client"]
[59,4.3,"     VM Teams create/change VMs as per Blueprint shared by PopUp Team",null,"Client","NOT STARTED"]
[60,4.4000000000000004,"Network / firewall changes (if required )",null,"Client","NOT STARTED"]
[61,null,"MILESTONE   Create VM as per Blueprint for Delphix Virtualization completed"]
[62,4.5,"OVAs Config and Validation ",null,"PopUpLINUXLead"]
[63,"4.5.1","    OVAs Config & performance health check - Validation ",null,"PopUpLINUXLead","NOT STARTED"]
[64,"4.5.2","    OVAs Config changes if required  ",null,"PopUpLINUXLead","NOT STARTED"]
[65,"4.5.3","    OVAs health check validated ",null,"PopUpLINUXLead","NOT STARTED"]
[66,null,"MILESTONE   OVA Config and Validation completed"]
[67,4.5999999999999996,"     Setup Delphix Virtualization Engine"]
[68,"4.6.1","       Config Delphix Virtualisation Engine",null,"PopUpLINUXLead","NOT STARTED"]
[69,"4.6.2","        Register Delphix Engine (license)",null,"PopUpLINUXLead","NOT STARTED"]
[70,null,"MILESTONE   Setup Delphix Virtualization Engine completed"]
[71,null,"MILESTONE   Delphix Virtualzation Infrastructure Setup & Basic Configuration completed"]
[72,5,"Delphix Virtualization Engine Verification"]
[73,5.0999999999999996,"         Create an Environment in Delphix Virtualization Engine ",null,"PopUpLINUXLead","NOT STARTED"]
[74,5.2,"         Check toolkit and EDSI ",null,"PopUpLINUXLead","NOT STARTED"]
[75,5.3,"         Configure D-Source",null,"PopUpLINUXLead","NOT STARTED"]
[76,5.4,"         Data Ingestion",null,"PopUpLINUXLead","NOT STARTED"]
[77,null,"MILESTONE   Delphix Virtualization Engine Verification Completed"]
[78,6,"Mainframe - Install & Setup",null,null,"NOT STARTED"]
[79,6.1,"    Client Mainframe"]
[80,"6.1.1","         Install Data Migration Server Utility",null,"Client"]
[81,"6.1.2","         Install / Customize Corraling Utility",null,"PopUpMFDeveloper"]
[82,null,"MILESTONE   Client Mainframe Install & Setup completed"]
[83,6.2,"    Popup Mainframe"]
[84,"6.2.1","         Userid setup",null,"PopUpMFDeveloper"]
[85,"6.2.2","         Userid Logon Validation",null,"PopUpMFDeveloper"]
[86,"6.2.3","         Install / Customize Corraling Utility",null,"PopUpMFDeveloper"]
[87,null,"MILESTONE   Popup Mainframe Install & Setup completed"]
[88,null,"MILESTONE   Mainframe Install & Setup completed"]
[89,7,"Mainframe - Verification & Validation",null,null,"NOT STARTED"]
[90,7.1,"     Client Mainframe"]
[91,"7.1.1","         Test Corraling utility to add 1+ datasets to transport volume  ",null,"PopUpMFDeveloper"]
[92,"7.1.2","         Check Security on Migration Server Utility",null,"Client"]
[93,"7.1.3","         Check VOLSER for Migration Server (Transport Volumes)",null,"Client"]
[94,"7.1.4","         Test transfer of volume using Migration Server to zD&T",null,"PopUpMFDeveloper"]
[95,null,"MILESTONE   Client Mainframe Verification & Validation completed"]
[96,7.2,"     Popup Mainframe"]
[97,"7.2.1","         Test De-Corraling to complete the transfer of data to Popup",null,"PopUpMFDeveloper"]
[98,null,"MILESTONE   Popup Mainframe Verification & Validation "]
[99,null,"MILESTONE   Mainframe Verification & Validation completed"]
[90,8,"Include following sections where applicable:",null,null,"NOT STARTED"]
[91,8.1,"     DB2 "]
[92,"8.1.1.","     DB2 (General)"]
[93,"8.1.1.1","          Setup"]
[94,"8.1.1.1.1","               Customize DB2 settings to match client's installation, as close as possible",null,"PopUpMFLead"]
[95,"8.1.1.1.2","               Calculate PopUp DASD requirements and ensure sufficient is available",null,"PopUpMFLead"]
[96,"8.1.1.1.3","               Identify Buffer Pools etc required for PopUp \"clone\"",null,"PopUpMFLead"]
[97,"8.1.1.1.4","               Corral  as required",null,"PopUpMFDeveloper"]
[98,"8.1.1.1.5","               Decorral on Popup if required",null,"PopUpMFDeveloper"]
[99,"8.1.1.1.6","               Configure DB2 on Popup",null,"PopUpMFLead"]
[19,"8.1.1.1.7","               Re-IPL when appropriate ",null,"PopUpMFDeveloper"]
[111,null,"MILESTONE   DB2  General - Setup  Completed "]
[112,null,"MILESTONE   DB2  General Completed "]
[113,"8.1.2","     DB2  for <Application>(1 Table with 90,000 rows/records)"]
[114,"8.1.2.1","          Setup"]
[115,"8.1.2.1.1","                Identify application specific Tables/Libraries",null,"Client"]
[116,null,"MILESTONE   DB2 Appl - Setup  Completed "]
[117,"8.1.2.2","          Preparation"]
[118,"8.1.2.2.1","               Calculate approximate space requirements for Unload files",null,"PopUpMFLead"]
[119,"8.1.2.2.2","               Calculate transfer method DASD requirements and ensure sufficient is available",null,"PopUpMFLead"]
[120,"8.1.2.2.3","               Identify Correct Release of:"]
[121,"8.1.2.2.3.1","                    Execution JCL/PROCLIBs",null,"Client"]
[122,"8.1.2.2.3.2","                    EXECutable code",null,"Client"]
[123,"8.1.2.2.3.3","                    DBRM's",null,"Client"]
[124,null,"MILESTONE   DB2 Appl - Release Identification Completed "]
[125,"8.1.2.2.4","               Identify / Provide DDL for all required tables/tablespaces",null,"Client"]
[126,"8.1.2.2.5","               Create/Modify table unload JCL to suit the PopUp transfer capabilities available \n               ( split  where necessary )",null,"PopUpMFDeveloper"]
[127,"8.1.2.2.6","               Unload data from Source Tables"]
[128,"8.1.2.2.6.1","                    Capture \"unload\"/syspunch",null,"PopUpMFDeveloper"]
[129,"8.1.2.2.6.2","                    Capture row counts (actual rows unloaded)",null,"PopUpMFDeveloper"]
[130,null,"MILESTONE   DB2 Appl - Unload data Completed "]
[131,"8.1.2.2.7","               Use CORRALing tool to set up data transfer JCL ",null,"PopUpMFDeveloper"]
[132,"8.1.2.2.8","               Create CORRALing scripts for automated execution",null,"PopUpMFDeveloper"]
[133,null,"MILESTONE   DB2 Appl - Preparation Completed "]
[134,"8.1.2.3","          Corral Data"]
[135,"8.1.2.3.1","               Transfer Code Base (Execution JCL/Code/DBRM's etc ) to PopUp",null,"PopUpMFDeveloper"]
[136,"8.1.2.3.2","               Transfer DDL to POPUP",null,"PopUpMFDeveloper"]
[137,"8.1.2.3.3","               Transfer data / unload cards to Popup",null,"PopUpMFDeveloper"]
[138,null,"MILESTONE   DB2 Appl - Corral Data Completed "]
[139,"8.1.2.4","          DeCorral (PopUp)"]
[140,"8.1.2.4.1","               Decorral Application objects",null,"PopUpMFDeveloper"]
[141,"8.1.2.4.2","               Confirm all data transferred successfully (use row counts captured above)",null,"PopUpMFDeveloper"]
[142,null,"MILESTONE   DB2 Appl - DeCorral Data Completed "]
[143,"8.1.2.5","           Post-Decorral"]
[144,"8.1.2.5.1","               Modify JCL to suit PopUp environment",null,"PopUpMFDeveloper"]
[145,"8.1.2.5.2","               Customise DDL / Buffer Pools to match PopUp",null,"PopUpMFLead"]
[146,"8.1.2.5.3","               Create required tables on PopUp",null,"PopUpMFDeveloper"]
[147,"8.1.2.5.4","               Load DB2 tables onto PopUp Sub-system",null,"PopUpMFDeveloper"]
[148,"8.1.2.5.5","               Verify all rows loaded ( vs Actual row counts captured above )",null,"PopUpMFDeveloper"]
[149,"8.1.2.5.6","               Execute RUNSTATS for required, non-empty tables",null,"PopUpMFDeveloper"]
[150,"8.1.2.5.7","               Bind"]
[151,"8.1.2.5.7.1","                    Programs ( LOAD & DBRM )",null,"PopUpMFDeveloper"]
[152,"8.1.2.5.7.2","                    Package Bind JCL",null,"PopUpMFDeveloper"]
[153,"8.1.2.5.7.3","                    Package Bind Cards",null,"PopUpMFDeveloper"]
[154,"8.1.2.5.7.4","                    Plan Bind Cards",null,"PopUpMFDeveloper"]
[155,"8.1.2.5.7.5","                    Execute Package Binds",null,"PopUpMFDeveloper"]
[156,"8.1.2.5.7.6","                    Execute Plan Binds",null,"PopUpMFDeveloper"]
[157,null,"MILESTONE   DB2 Appl - Bind Completed "]
[158,null,"MILESTONE   DB2 Appl - Post Decorral Completed "]
[159,"8.1.2.6","          Smoke Test"]
[160,"8.1.2.6.1","               Execute designated application program to confirm operability",null,"PopUpMFDeveloper"]
[161,null,"MILESTONE   DB2 Appl - Smoke test  Completed "]
[162,null,"MILESTONE   DB2 Applicatiion Completed (per Application)"]
[163,null,"MILESTONE   DB2  Completed (for all Applications)"]
[164,8.1999999999999993,"     VSAM estimation for /VSAM file",null,null,"NOT STARTED"]
[165,"8.2.2","     VSAM - <Application>"]
[166,"8.2.2.2","          Preparation"]
[167,"8.2.2.2.1","                Depending on transfer method:"]
[168,"8.2.2.2.1.1","                     Identify DELETE/DEFINE Cluster details",null,"PopUpMFDeveloper"]
[169,null,"MILESTONE   VSAM  Appl - Cluster Del/Definition  Completed "]
[170,"8.2.2.2.2","                Identify Correct Release of:"]
[171,"8.2.2.2.2.1","                    Execution JCL/PROCLIBs",null,"Client"]
[172,"8.2.2.2.2.2","                    EXECutable code",null,"Client"]
[173,null,"MILESTONE   VSAM  Appl - Release Identification Completed "]
[174,"8.2.2.2.3","               Use CORRALing tool to set up data transfer JCL ",null,"PopUpMFDeveloper"]
[175,"8.2.2.2.4","                Create CORRALing scripts for automated transfer of all Data objects",null,"PopUpMFDeveloper"]
[176,null,"MILESTONE   VSAM  Appl - Preparation  Completed "]
[177,"8.2.2.3","          Corral Data (Mainframe) for each VSAM dataset"]
[178,"8.2.2.3.2","               CORR(EXPORT) method then "]
[179,"8.2.2.3.2.1","                    EXPORT VSAM to Transport Volume",null,"PopUpMFDeveloper"]
[180,null,"MILESTONE   VSAM  Appl - Corral Data Completed "]
[181,"8.2.2.4","          DeCorral (PopUp)"]
[182,"8.2.2.4.1","               Transfer Code Base (Execution JCL/Code/DBRM's etc ) to PopUp",null,"PopUpMFDeveloper"]
[183,null,"MILESTONE   VSAM  Appl - DeCorral Data Completed "]
[184,"8.2.2.5","          Post-Decorral"]
[185,"8.2.2.5.1","               Confirm all data transferred successfully",null,"PopUpMFDeveloper"]
[186,"8.2.2.5.2","               Modify JCL to suit PopUp environment",null,"PopUpMFDeveloper"]
[187,null,"MILESTONE   VSAM  Appl - Post DeCorral Completed "]
[188,"8.2.2.6","          Smoke Test For all VSAM files"]
[189,"8.2.2.6.1","               Execute designated application program to confirm operability",null,"PopUpMFDeveloper"]
[190,null,"MILESTONE   VSAM  Appl -Smoke Test Completed "]
[191,null,"MILESTONE   VSAM  Application Completed (per Application)"]
[192,null,"MILESTONE   VSAM  Completed (for all Applications)"]
[194,8.3000000000000007,"CICS"]
[195,"8.3.1","      CICS (General)"]
[196,"8.3.1.1","          Setup"]
[197,"8.3.1.1.1","               Ensure correct release of CICS is installed",null,"PopUpMainframe"]
[198,"8.3.1.1.2","               Identify CSD file",null,"PopUpMainframe"]
[199,"8.3.1.1.3","               Identify other CICS libraries",null,"PopUpMainframe"]
[200,"8.3.1.1.4","               Corral / FTP as required",null,"PopUpMainframe"]
[201,"8.3.1.1.5","               Decorral on Popup if required",null,"PopUpMainframe"]
[202,"8.3.1.1.6","               Modify CSD for transactions to test",null,"PopUpMainframe"]
[203,"8.3.1.1.7","               Re-IPL when appropriate ",null,"PopUpMainframe"]
[204,null,"MILESTONE   CICS General - Setup Completed"]
[205,null,"MILESTONE   CICS General  Completed"]
[206,"8.3.2","     CICS (Application- {1,2....n} ) For each Application , Repeat the below"]
[207,"8.3.2.1","          Setup"]
[208,"8.3.2.1.1","                Identify application specific libraries",null,"Application Team"]
[209,null,"MILESTONE   CICS  Appl - Setup Completed"]
[29,"8.3.2.2","          Preparation"]
[211,"8.3.2.2.1","               Agree transfer method(s) ( Migration Utility / FTP / etc )",null,"PopupMainframe&Application Team"]
[212,"8.3.2.2.2","               Use CORRALing tool to set up data transfer JCL \n               (automation/schedule where necesaary)",null,"PopupMainframe"]
[213,"8.3.2.2.3","               Create CORRALing scripts for automated execution",null,"PopUpMainframe"]
[214,null,"MILESTONE   CICS  Appl - Preparation Completed"]
[215,"8.3.2.3","          Corral Data"]
[216,"8.3.2.3.1","               Transfer application specific CICS libraries (BMS, etc )",null,"PopUpMainframe"]
[217,null,"MILESTONE   CICS  Appl - Corral Data Completed"]
[218,"8.3.2.4","          DeCorral"]
[219,"8.3.2.4.1","               Restore application libraries",null,"PopUpMainframe"]
[220,null,"MILESTONE   CICS  Appl - DeCorral Data Completed"]
[221,"8.3.2.5","          Smoke Test"]
[222,"8.3.2.5.1","                Execute designated application program to confirm operability",null,"PopupMainframe&Application Team"]
[223,null,"MILESTONE   CICS Appl - Smoke Test  Completed"]
[224,null,"MILESTONE   CICS Application Completed (per Application)"]
[225,null,"MILESTONE   CICS Completed for all of the Applications"]
[226,8.4,"     IMS"]
[227,"8.4.1","     IMS (General)"]
[228,"8.4.1.1","          Setup"]
[229,"8.4.1.1.1","               Ensure correct release of IMS is installed",null,"PopUpMainframe"]
[230,"8.4.1.1.2","               Identify IMS started tasks (DBCTL or Full IMS DB/DC and whether or not CSL required)",null,"PopUpMainframe"]
[231,"8.4.1.1.3","               Identify required files              (RESLIB/SDFSMAC/MODBLKS/DBDLIB/PSBLIB/ACBLIBs)",null,"PopUpMainframe"]
[232,"8.4.1.1.4","               Identify other IMS libraries (RECON etc)",null,"PopUpMainframe"]
[233,"8.4.1.1.5","               Corral / FTP as required",null,"PopUpMainframe"]
[234,"8.4.1.1.6","               Decorral on Popup if required",null,"PopUpMainframe"]
[235,"8.4.1.1.7","             Update PROCLIB with new libraries",null,"PopUpMainframe"]
[236,"8.4.1.1.8","               Re-IPL when appropriate ",null,"PopUpMainframe"]
[237,null,"MILESTONE   IMS General Setup Completed "]
[238,null,"MILESTONE   IMS General Completed "]
[239,"8.4.2","     IMS (Database-{1,2....n} ) For each Database, Repeat the below",null,"in conjuncton with IMS Application but could be stand-alone if DB's only referenced by CICS for example"]
[240,"8.4.2.1","          Setup"]
[241,"8.4.2.1.1","                Identify required databases",null,"Application Team"]
[242,"8.4.2.1.2","                Determine migration method (db datasets/restore IC)",null,"PopUpMainframe"]
[243,"8.4.2.1.3","               Calculate PopUp DASD requirements and ensure sufficient space is available",null,"PopUpMainframe"]
[244,"8.4.2.1.4","               Identify Buffer Pools etc required for PopUp \"clone\"",null,"PopUpMainframe"]
[245,null,"MILESTONE   IMS Database Setup Completed"]
[246,"8.4.2.2","          Preparation"]
[247,"8.4.2.2.1","                Identify:"]
[248,"8.4.2.2.1.1","                    Database Datasets",null,"Application Team"]
[249,"8.4.2.2.1.2","                    RECON records",null,"Application Team"]
[250,null,"MILESTONE   IMS Database Preparation Completed"]
[251,"8.4.2.3","          Corral Data"]
[252,"8.4.2.3.1","               Transfer database datasets/IC",null,"PopUpMainframe"]
[253,null,"MILESTONE   IMS Database Corral Data Completed"]
[254,"8.4.2.4","          DeCorral"]
[255,"8.4.2.4.1","               Restore/Create databases",null,"PopUpMainframe"]
[256,"8.4.2.4.2","               Confirm all data transferred successfully (record counts?)",null,"PopupMainframe"]
[257,null,"MILESTONE   IMS Database DeCorral Data Completed"]
[258,"8.4.2.5","          Post-Decorral"]
[259,"8.4.2.5.1","               Confirm all data transferred successfully"]
[260,"8.4.2.5.2","               Modify JCL to suit PopUp environment",null,"PopupMainframe"]
[261,"8.4.2.5.3","               Customise Buffer Pools on PopUp",null,"PopupMainframe"]
[262,"8.4.2.5.4","               Create required databases on PopUp (RECON update)",null,"PopupMainframe"]
[263,null,"MILESTONE   IMS Database Post DeCorral Completed"]
[264,"8.4.2.6","          Smoke Test"]
[265,"8.4.2.6.1","                Execute DDLTO against db"]
[266,"8.4.2.6.2","                Execute designated application program to confirm operability"]
[267,null,"MILESTONE   IMS Database Smoke Test Completed"]
[268,null,"MILESTONE   IMS Database Completed (per Database)"]
[269,"8.4.3","     IMS  (Application- {1,2....n} ) For each Application , Repeat the below"]
[270,"8.4.3.1","          Setup"]
[271,"8.4.3.1.1","                Identify application specific libraries (DBDLIB/PSBLIB)",null,"Application Team"]
[272,null,"MILESTONE   IMS Appl Setup Completed"]
[273,"8.4.3.2","          Preparation"]
[274,"8.4.3.2.1","                Identify Correct Release of:"]
[275,"8.4.3.2.1.1","                    Execution JCL/PROCLIBs",null,"Application Team"]
[276,"8.4.3.2.1.2","                    EXECutable code",null,"Application Team"]
[277,null,"MILESTONE   IMS Appl Preparation Completed"]
[278,"8.4.3.3","          Corral Data"]
[279,"8.4.3.3.1","               Transfer application specific IMS libraries ",null,"PopUpMainframe"]
[280,null,"MILESTONE   IMS Appl Corral Data Completed"]
[281,"8.4.3.4","          DeCorral"]
[282,"8.4.3.4.1","               Restore application libraries",null,"PopUpMainframe"]
[283,null,"MILESTONE   IMS Appl DeCorral Data Completed"]
[284,"8.4.3.5","          Post-Decorral"]
[285,"8.4.3.5.1","               Confirm all data transferred successfully"]
[286,"8.4.3.5.2","               Modify JCL to suit PopUp environment"]
[287,null,"MILESTONE   IMS Appl Post DeCorral Completed"]
[288,"8.4.3.6","          Smoke Test"]
[289,"8.4.3.6.1","                Execute designated application program to confirm operability"]
[290,null,"MILESTONE   IMS Appl Smoke Test Completed"]
[291,null,"MILESTONE   IMS Appl Completed (per Database)"]
[292,null,"MILESTONE   IMS Completed (for all Databases & all Applications)"]
[293,8.5,"MQ"]
[294,"8.5.1","     MQ (General)"]
[295,"8.5.1.1","          Setup"]
[296,"8.5.1.1.1","               Ensure correct release of MQ is installed",null,"PopUpMainframe"]
[297,"8.5.1.1.2","               Identify external connections and listener ports required",null,"PopUpMainframe"]
[298,"8.5.1.1.3","               Identify messaging architecture (cluster/point-to-point/pub-sub etc)",null,"PopUpMainframe"]
[299,"8.5.1.1.4","               Identify additional requirements (exits etc) ",null,"PopUpMainframe"]
[300,"8.5.1.1.5","               Identify and configure connected mainframe systems (IMS/CICS Bridge etc)",null,"PopUpMainframe"]
[301,null,"MILESTONE   MQ General Setup Completed"]
[302,null,"MILESTONE   MQ General  Completed"]
[303,"8.5.2","     MQ (Application {1,2....n} ) For each Application, Repeat the below"]
[304,"8.5.2.1","          Setup"]
[305,"8.5.2.1.1","               Identify application specific objects (queues/channels)",null,"PopUpMainframe"]
[306,"8.5.2.1.2","               Confirm no queue data is required in PopUp (additional work required if needed)",null,"PopUpMainframe"]
[307,"8.5.2.1.3","               Identify application libraries/datasets ",null,"PopUpMainframe"]
[308,null,"MILESTONE   MQ Appl Setup Completed"]
[309,"8.5.2.2","          Preparation"]
[39,"8.5.2.2.1","               Copy required objects  from target system (CSQUTIL SDEFS or MAKEDEF)",null,"PopupMainframe"]
[311,"8.5.2.2.2","               Copy required application libraries/datasets",null,"PopupMainframe"]
[312,"8.5.2.2.3","               Agree transfer method(s) ( Migration Utility / FTP / etc )",null,"PopupMainframe&Application Team"]
[313,null,"MILESTONE   MQ Appl Preparation Completed"]
[314,"8.5.2.3","          Corral Data"]
[315,"8.5.2.3.1","               Transfer Definitions to PopUp",null,"PopupMainframe"]
[316,null,"MILESTONE   MQ Appl Corral Data Completed"]
[317,"8.5.2.4","          DeCorral (PopUp)"]
[318,"8.5.2.4.1","               Decorral MQ objects",null,"PopupMainframe"]
[319,"8.5.2.4.2","               Confirm all data transferred successfully (use queue/channel counts)",null,"PopupMainframe"]
[320,null,"MILESTONE   MQ Appl Decorral Data Completed"]
[321,"8.5.2.5","           Post-Decorral"]
[322,"8.5.2.5.1","               Copy required application libraries/datasets",null,"PopupMainframe"]
[323,"8.5.2.5.2","               Modify JCL to suit PopUp environment",null,"PopupMainframe"]
[324,"8.5.2.5.3","               Customise objects (may need to customise channel connection parms etc)",null,"PopupMainframe"]
[325,"8.5.2.5.4","               Run CSQUTIL to create objects on PopUp Qmanager",null,"PopupMainframe"]
[326,"8.5.2.5.5","               Confirm all objects created successfully (check RC; use queue/channel counts)",null,"PopupMainframe"]
[327,"8.5.2.5.6","               Display queues, channels etc (CSQUTIL or MQ panels)",null,"PopupMainframe"]
[328,null,"MILESTONE   MQ Appl Post Decorral Completed"]
[329,"8.5.2.6","          Smoke Test"]
[330,"8.5.2.6.1","               Execute designated application program to confirm operability",null,"PopupMainframe&Application Team"]
[331,null,"MILESTONE   MQ Appl Smoke Test Completed"]
[332,null,"MILESTONE   MQ Appl Completed (per Application)"]
[333,null,"MILESTONE   MQ Completed (for all Applications)"]
[334,8.6,"     External Tool / Utility-{1,2....n} "]
[335,"8.6.1","          Setup"]
[336,"8.6.1.1","               Discover pre-requisites ",null,"PopupMainframe"]
[337,"8.6.1.2","              Raise request for license (for any 3rd party tools) ",null,"PopupMainframe"]
[338,"8.6.1.3","              Acquire all the required documentation and any other artifacts",null,"PopupMainframe"]
[339,"8.6.1.4","              Install Tool",null,"PopupMainframe"]
[340,"8.6.1.5","              Configure Tool",null,"PopupMainframe"]
[341,null,"MILESTONE   Extenal Tool/Utility Setup  Completed"]
[342,"8.6.2","          Smoke Test"]
[343,"8.6.2.1","                Execute designated application program to confirm operability",null,"Application Team"]
[344,null,"MILESTONE   Smoke Test Completed"]
[345,null,"MILESTONE  External Tool/utility completed ( per tool/utility)"]
[346,null,"MILESTONE  External Tool/utility completed ( All of the tools/utilities  )"]
[347,9,"Popup Virtualisation - Popup target 1 with <Application>",null,null,"NOT STARTED"]
[348,9.1,"      Check Popup readiness for Data Ingestion ( all in scope application and data are available) & shutdown Popup",null,"PopUpMFDeveloper"]
[349,9.1999999999999993,"     Check Delphix Virtualization Engine Readiness for Data Ingestion : Start / Stop Server",null,"PopUpMFDeveloper"]
[350,9.3000000000000007,"     Create Environment in Delphix ",null,"PopUpMFDeveloper"]
[351,9.4,"     Ingest PopUp into Delphix Virtualization & create “Gold Copy\" (Based on Network speed effort will vary)",null,"PopUpMFDeveloper"]
[352,9.5,"     Provision PopUp targets (Virtual PopUps)",null,"PopUpMFDeveloper"]
[353,9.6,"     Shake down testing on All subsystems ( CICS / DB2 / IMS etc ) on Virtual Popups",null,"PopUpMFDeveloper"]
[354,9.6999999999999993,"     Review Virtual Popup and Signoff",null,"Client"]
[355,null,"MILESTONE Popup  Virtualization completed (1 Virtual popup mainframe)"]
[356,null,"MILESTONE Popup   Virtualization completed (All of the Virtual Popup mainframe)"]
[357,10,"Adhoc Tasks",null,null,"NOT STARTED"]
[358,10.1,"      Volume creation ( Per Volume -0.5)",null,"PopUpLINUXLead"]
[359,null,"MILESTONE Adhoc Tasks completed "]
[360,11,"Documentation & Instructions for PopUp including :",null,null,"NOT STARTED"]
[361,11.1,"     List of All of the Mainframe objects transferred per Application to POPUP",null,"PopUpMFDeveloper"]
[362,11.2,"     Frequently requried tasks on POPUP"]
[363,"11.2.1","          New User ID creation ",null,"PopUpMFDeveloper"]
[364,"11.2.2","          New Volume creation",null,"PopUpMFDeveloper"]
[365,"11.2.3","     Lessons Learned document",null,"PopUpMFDeveloper"]
[366,null,"MILESTONE Documentation & Instructions - Frequent tasks o PopUP completed"]
[367,null,"MILESTONE Documentation & Instructions for PopUp completed "]

{"sheet":"Setup & Prep Checklist","index":2,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,2,2,3]]}
[]
[]
[null,null,"Setup & Preparation Checklist"]
[]
[null,"No","Delivery Manual Stage","Activity / Document (must be signed off)","Status","Sign Off Provided by ","Sign Off Date"]
[null,1,"A1. Project Definition & Kickoff","Project Charter"]
[null,2,"A2. Architecture & Application Discovery","List of applications in scope for project"]
[null,3,"A2. Architecture & Application Discovery","Full infrastructure blueprint (logical architecture, network architecture, VM requirements, z/OS software) "]
[null,4,"A2. Architecture & Application Discovery","Network requirements for in-scope applications"]
[null,5,"A2. Architecture & Application Discovery","Data migration strategy (e.g. Connect:Direct or Migration Server)"]
[null,6,"A2. Architecture & Application Discovery","Application Discovery Document which includes list of data and application components to be virtualised (including sizing details)"]
[null,7,"A2. Architecture & Application Discovery","List of data field types to be masked (if applicable)"]
[null,8,"A3. Popup & Delphix Infrastructure Setup","PopUp appliances created as per infrastructure blueprint"]
[null,9,"A3. Popup & Delphix Infrastructure Setup","PopUp appliances health check completed successfully"]
[null,10,"A3. Popup & Delphix Infrastructure Setup","Delphix Continuous Data Engine appliances created as per infrastructure blueprint"]
[null,11,"A3. Popup & Delphix Infrastructure Setup","Delphix Continuous Compliance Engine appliances created as per infrastructure blueprint"]
[null,12,"A3. Popup & Delphix Infrastructure Setup","Delphix Continuous Data Engine appliances appliances health check completed successfully"]
[null,13,"A3. Popup & Delphix Infrastructure Setup","Delphix Continuous Compliance Engine appliances appliances health check completed successfully"]
[null,14,"A3. Popup & Delphix Infrastructure Setup","User access (for project team) to PopUp & Delphix appliances validated"]
[null,15,"A4. Data Migration Preparation","Migration Server utility installed and configured"]
[null,16,"A4. Data Migration Preparation","Migration Server security configured and tested"]
[null,17,"A4. Data Migration Preparation","Transport volumes created"]
[null,18,"A4. Data Migration Preparation","All data in scope for virtualisation copied to transport volume Note: data must be consistent i.e. time snapshot"]
[null,19,"A4. Data Migration Preparation","Migration Server utility up and running"]

{"sheet":"ChangeHistory","index":3,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Version No","Date","Description of changes","Changes done by"]
[null,0.01,null,"Initial Template "]

{"sheet":"Assumptions","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[8,1,8,3]]}
[]
[null," "]
[null,"Estimation here is based on the below assumptions/criteria. The estimation can be expanded based on the number of applications as well as the size of data."]
[null,null,1,"Table with 100,000 rows max"]
[null,null,2,"1 VSAM file of size ?"]
[null,null,3,"No NETWORK slowness issue"]
[null,null,4,"Medium Complexity over Data & Data transfer"]
[null,null,5,"Not considering unknown complexity"]
[null,"To arrive at an approx estimation on the below, as it was done for DB2 & VSAM"]
[null,null,null,"CICS"]
[null,null,null,"IMS"]
[null,null,null,"MQ"]