Infrastructure – Enterprise Systems George Dranes, Assistant Director of the Computer Center Zach Pratt, Systems Programmer
ENTERPRISE SYSTEMS � � Current Mainframe Configuration � � Separated into four logical partitions Production z/OS operating system � � Includes STARS, WIUP and all administrative batch processing � � Student z/OS operating system � � Maintained for WIU’s CS 220 and CS 230 COBOL courses � � Test z/OS operating system � � Testing ground for major subsystem upgrades � � z/VM operating system (hypervisor) � � Currently supporting 9 SUSE Linux images � � Resource shortages on mainframe have forced a restructuring of the system � �
ENTERPRISE SYSTEMS � � z/OS Production System � � FY12 Accomplishments � � Migrated operating system from z/OS release 1.11 to release 1.12 � � Migrated Transaction Server (CICS) from release 3.2 to release 4.2 � � Successfully performed a disaster recovery test at Sungard’s Chicago facility � � Replaced 60+ years of Production Control experience due to Marcia Blackledge’s and Fred Combite’s retirements
ENTERPRISE SYSTEMS � � z/OS Production System � � System availability and throughput � � Processed 1,041,581 jobs in 2011 requiring 7706 hours of CPU � � Increase of nearly 1000 CPU hours over 2010 � � STARS and WIUP CICS systems processed 58,333,120 transactions in 2011 requiring 1051 CPU hours � � Decrease of 8,000,000 transactions yet an increase of 168 CPU hours over 2010??? � � CICS system availability over the previous 52 weeks is 99.99% (8,120.9 hours out of a possible 8,121.25 hours)
ENTERPRISE SYSTEMS � � z/OS Production System � � Goals and New Projects for FY13 � � Migrate from release 8 to release 10 of DB2 � � Migrate from release 1.12 to release 1.13 of z/OS � � Work with AIMS to CASify STARS � � Continue to maintain our 99.9%+ availability rate and our sub-second CICS transaction response time � � Perform yearly disaster recovery test in June
ENTERPRISE SYSTEMS � � Morgan Hall Data Center � � Updates and Ongoing Projects � � Computer Center modernization project kicked off � � Upgrade HVAC system � � Reorganize Data Center to follow hot/cold aisle approach � � Make electrical upgrades required for future growth of the Center � � Several walk-throughs with Stanley Engineering architects and engineers � � Currently the project is in the hands of the Capital Development Board
ENTERPRISE SYSTEMS � � Pentaho and Data Warehouse – FY12 Accomplishments � � AIMS added two full-time data architects to the team: Jeff Brown and Brian Jarmy � � Worked closely with the following departments to implement business intelligence solutions for them: � � Macomb and Quad Cities Admissions � � Foundation and Development � � University Housing and Dining � � We are continuing to add new features for each of these departments in addition to maintaining our current implementation � � Upgraded the Pentaho BI Server to the latest release: 4.1 � � Switched to using RACF credentials for Pentaho authentication
ENTERPRISE SYSTEMS � � Pentaho and Data Warehouse – FY12 Accomplishments continued � � Began the implementation of a Changed Data Capture solution, which will allow for efficient ETL processing and reduce the load on the transactional database system which supports STARS and WIUP � � This has been fully implemented for the Foundation Phonathon System and partially implemented for other areas � � Created an internal data governance group to define our strategy for Pentaho and data warehouse stewardship and security � � Began working on an web-based method for handling requests for access to Pentaho and the data warehouse
ENTERPRISE SYSTEMS � � Pentaho and Data Warehouse – FY12 Accomplishments continued � � Three team members (Jeff, Jon, and Zach) were able to attend multiple training events, which included: � � A TDWI (The Data Warehouse Institute) Conference � � 3 Pentaho classes – Bootcamp, PDI, and Pentaho Architect � � A Kimball University Dimensional Modeling � � Installed and configured separate test and production Pentaho servers � � Began working on separate test and production data warehouse servers
ENTERPRISE SYSTEMS � � Pentaho and Data Warehouse – FY13 Goals � � Continue the implementation of the university’s data warehouse by expanding into additional subjects areas within Admissions and Foundation and Development � � Continue to improve our strategy for data governance and stewardship by working closely with AIMS, our users, The Office of the Registrar, and the Chief Technology Security Officer � � Finalize our implementation for a system that will handle requests for access to Pentaho and the university’s data warehouse � � Continue to expand and refine our Change Data Capture implementation � � Maintain the latest release of Pentaho � � Upgrade the data warehouse to the latest release of DB2 LUW (9.7)
ENTERPRISE SYSTEMS � � z/VM Accomplishments – FY12 � � Deployed the SUSE Subscription Management Tool (SMT) server to manage licenses and updates for all of our z/VM guests running SUSE Linux � � Updated our CIS Secure-based lockdown procedure for SUSE Linux Enterprise Server 11 and applied it to all new guests � � Upgraded 4 of our 9 z/VM guests from SUSE Linux Enterprise Server (SLES) 10 SP2 to SUSE Linux Enterprise Server 11 SP1 � � Supported the Interpersonal Violence Prevention Education Program (IVPE) by hosting their education application on z/VM � � Continued providing support for the WEPPAS web application, which in turn supports COEHS’ Teacher Education program
ENTERPRISE SYSTEMS � � z/VM Accomplishments - FY 12 continued � � The Pentaho BI Server had a 591% increase in pages views and a 777% increase in hits from calendar year 2010 to 2011 � � 80,912 page views and 278,815 hits during calendar year 2011 compared to 11,711 page views and 31,780 hits in calendar year 2010 � � The WEPPAS web application had a 133% increase in page views and a 109% increase in hits from calendar year 2010 to 2011 � � 180,730 page views and 824,697 hits during calendar year 2011 compared to 77,664 page views and 394,165 hits in calendar year 2010
ENTERPRISE SYSTEMS
ENTERPRISE SYSTEMS � � z/VM Goals - FY 13 � � Continue to improve the security and reliability of our environment � � Maintain the latest releases and maintenance levels of DB2 LUW and Pentaho � � Upgrade z/VM from release 5.3 to 5.4 � � Finish the upgrade of all z/VM Linux virtual machines from SLES10 to SLES11 � � Install the latest release of CEG connector for u.select � � Implement an NFS v4 server on z/OS for incremental backup storage for Linux and also for mounting users’ home directories
Recommend
More recommend