infrastructure enterprise systems
play

Infrastructure Enterprise Systems George Dranes, Assistant - PowerPoint PPT Presentation

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


  1. Infrastructure – Enterprise Systems George Dranes, Assistant Director of the Computer Center Zach Pratt, Systems Programmer

  2. 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 � �

  3. 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

  4. 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)

  5. 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

  6. 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

  7. 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

  8. 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

  9. 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

  10. 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)

  11. 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

  12. 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

  13. ENTERPRISE SYSTEMS

  14. 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