WORK TERM REPORT Summer 2015 Coop Placement at Shared Services Canada

WORK TERM REPORT Summer 2015 Coop Placement at Shared Services Canada Tayo Odueke [email protected] Abstract The purpose of this report is to describe my summer of 2015 coop placement at Shared Services Canada. ...

WORK TERM REPORT Summer 2015 Coop Placement at Shared Services Canada Tayo Odueke [email protected] Abstract The purpose of this report is to describe my summer of 2015 coop placement at Shared Services Canada. While working at Shared Services most of my work centered on the creation of a website. The development process I went through to set up this website, including the issues I had to address and the solutions to them, make up the majority of this report.Table of Contents Table of Contents.........................................................................................................................................1 Introduction.................................................................................................................................................2 Website Requirements................................................................................................................................2 Website Design............................................................................................................................................3 Example.......................................................................................................................................................4 Database Structure......................................................................................................................................4 PHP Object interactions...............................................................................................................................6 PHP Code Description..................................................................................................................................6 Setting Up the Environment........................................................................................................................8 SQLite Decisions and Problems....................................................................................................................8 PHP Decisions and Problems.......................................................................................................................9 Conclusion.................................................................................................................................................10 References.................................................................................................................................................12 1Introduction I am a coop student in the Mainframe Networks team at Shared Services Canada. Shared Services is essentially all the I.T. departments of the various branches of the government combined into one branch. I started work on May 4th 2015 and I end on August 28th 2015. In the beginning I spent most of my time getting used to the environment and learning about mainframes. I needed to get clearance for the building, downloading software on my computer, scanning documents, as well as get my personal laptop, screen and work phone. Some of these came slower than others, most notable getting my work phone took more than half the coop term. Meanwhile, I got instruction on how Mainframes work through a combination of training from my immediate supervisor the supervisor of another coop student (both the supervisors worked together with both of us in practice), and another employee (Robb) who specialized in instructing people on Mainframe technology. Robb gave an hour a day sessions to me and the other coop students, covering topics from mainframe operating systems to how and where the data is stored. I found a lot of this information overwhelming at first but I focused on overarching ideas and material related to my work and it became more understandable. I also learned more about non mainframe topics, such as Linux, PHP, and SQLite, which were crucial in my personal task. The task being setting up a website to list details about OSA cards* which are central to Mainframe networking. This is a website to monitor and display various OSA cards and IP addresses. The data is previously hosted on a series of excel spreadsheets, with each spreadsheet representing a specific processor. The point of this website is to congregate all the information from various excel spreadsheets into one website. It is designed with a spreadsheet layout to efficiently convey the data. It exists inside of the Linux partition mfnetmgt 10.X.X.X. The database is designed in SQLite3 and is located in /data/data.db while the actual website code done in PHP and is located at srv/www/htdocs/index.PHP. This project is being done primarily to be a resource for the Mainframe networks team. 2 Column Name Format Example VIPA Boolea n true Processor String MAIA CHPID String E9 CHPID_type String OSD Port Int2 1 Failover_CHPID String FO Failover_CHPID type String OSC Failover_Port String 1 Slot String LG08 PCHIP String 1D0 Physical_Port String J01 OSA_Model String 3363 OSA-E3 GbE Connector String Fiber LC Duplex 4 ports Status String MVSI Mac_Address String 0014.5E78.3155 Local_Mac String 020010060100 UCB String 10E8-10EF Device String SYSOSD10 Interface_Name String OSD10FE1 Speed String Auto-100-Full Duplex String GIGE for EC Description String Broken Switch String KED1MFRMS05 Switch_port String Gi2/7 VLAN String 999 VIPA NAME String E91F01 LPar String MVS6 IP String 10.X.X.X. * Removed Sept, 2012Website Requirements Functional Requirements: · Accessible and editable via web · Displays all OSA information · Non Functional Requirements: · Reliability o Server Side design means the website is as reliable as the Processor it runs on · Scalability o Editable by anyone with access to the Linux partition it is hosted in · Security o Can only be accessed by through the shared Service Network · UI: Requirements · Website Display · Similar to excel, spreadsheet format · Database · The website must be able to show any combination of the following columns: