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:
.png)
.png)
 (1).png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
