10. 88,000+ executed in 2006 VPN Mellon Bank PNC Bank PHEAA PGP Concur (ERS) SSL All ftp’s are initiated on the mainframe

30. Overview of Enterprise Infrastructure – ES Mike Kauffman, Manager, ES

31. Enterprise Group Discussion Points: Mike Kauffman: Overview of Infrastructure Group Bill Cook: Primary Production Responsibilities Phil Hawkins: New Projects: VM and Linux Using IBM Series “Z”

32. Enterprise Infrastructure Groups and Staff:

33. Major Hardware Overview: IBM – z/890 16G Memory, 1-CP/1IFL, 12-Ficon/16-Escon Voyager – Shields Building (IPO1, IPO3,IPO5 – VM) NCC1701 Computer Building (IPO2, IPO4, IPO6 – VM) IBM – ESS – F20 Shark Storage 2TB – Count/Key – IBM Mainframe Storage 7TB – Fixed Block – Wintel Storage 4TB – SAN Volume Controller (SVC) Controlled

34. Major Hardware Overview (cont): IBM -3490 Tape Libraries (2) Mainframe/WinTel Shared Miscellaneous – 3420/3480 Tape, Sysplex Timers, Visara Console Controllers, ESCON Directors, Network

35. Major Operating System Overview: z/OS – Base Level Sysplex with Shared SPOOL/Jes2: IPO1-ISIS IPO2-IBIS IPO3/4/5/6 – Test – D/R - Maint z/OS – USS (Unix System Services) z/VM – IFL Hypervisor z/Linux – (Approximately 10 instances)

36. Major Software Overview: ACF2/CA7/WLM/MIM/Roscoe/TSO-ISPF/FDR/Upstream/FTP SMS/HSM/CA1/CA-Vtape/ESS-Expert Adabas Database/Complete/Natural/EntireX Websphere/DB2/iBPM/NetworkDeploy/EntireX/Tamino

37. Business Partners Overview: Primary: IBM Historic Business Partner Consistent Migration Path from MFT to z/OS Production Focus Excellent Field Support Primary: Software AG Relationship Built Over 25 Years Excellent Performance and Consistency Forward Looking Products – Tamino/EntireX

38. Business Partners Overview (cont): Secondary: Computer Associates Other: LRS, Syncsort, BIS, Innovation, SAS

39. Projects and Focus Points From The Past Year: VM/Linux Infrastructure Hydra/GI Migration (DCE Removal) Print Migration to Media and Print Center Disaster and Catastrophe Recovery Planning Tape: Library Upgrade and Virtualization (CA-Vtape) Improvement To Hours of Availability Secure Data Transfer – Travel Services Project Security Issue Resolution – Natural, Grades

40. Peak Workloads and Challenges: Registration and Drop/Add Day 2 – Spring 07 – 30 Million Adabas IBIS/ISIS commands Determining Peak Growth Rate Difficult Changing Architecture Changing Calendars Estimate 15 – 20% Grades – Becoming The Major Focus Point Short Duration – But Heavy Impact Required Before Commencement Exercises

42. Overview of Database Administration for Enterprise Systems – DBA-ES Bill Cook, Manager, DBA-ES

43. Current Staff: Bill Cook – Manager Rusty Sodergren – Senior DBA Mark Mikowicz – Intermediate DBA Christine McCrum – Junior DBA

44. DBA Functions: Install and Manage Software Build, Manage Databases Provide Technical Support Software Vendors: Software AG Treehouse Software Computer Associates

45. Primary Database Software Vendor: Software AG Installed at PSU since 1982 ISIS, IBIS, ADIS and eLion run on the Software AG suite of products

46. Software AG Core Product Line: Database Data Dictionary Pgm Language TP Monitor Middleware Database: Adabas Data Dictionary: Predict Pgm Language: Natural TP Monitor: Com-plete Middleware: EntireX Broker, RPC Server, Net-work

47. Software AG Other Products: Remote Development Code Analysis Refactoring Remote Development: Natural Development Server Single Point of Development (SPoD) Natural for Eclipse Code Analysis and Refactoring: Natural Engineer

48. Software AG Advantages: Adabas: Extremely Fast and Reliable; Natural, SQL, XML Access Predict: Full Documentation of Systems Natural: Easy To Learn and Powerful Com-plete: Reliable Broker, RPC Server, Net-work: Fast, Powerful and Reliable

49. Software AG Advantages (cont): Friendly, small-company feel Technical Support is excellent Products run on z/OS, Unix, Linux, zLinux and Windows Builds a real partnership with customers

50. Some Database Numbers… ADA229 Test Database: 61 Million Records ADA227 ISIS Database: 151 Million Records ADA226 IBIS Database: 459 Million Records ADA229: 301 files, Approximately 20,000 fields -- Rough estimates. ADA227: 92 files, Approximately 7,500 fields ADA226: 191 files, Approximately 12,500 fieldsADA229: 301 files, Approximately 20,000 fields -- Rough estimates. ADA227: 92 files, Approximately 7,500 fields ADA226: 191 files, Approximately 12,500 fields

51. Primary Tools Software Vendor: Treehouse Software Installed at PSU since 2002 Software used to convert files, model and propagate data

52. Treehouse Product Line: File Conversions Data Modeling Data Propagation File Conversions: ADAREORG Data Modeling: tRelational Data Propagation: DPS (Data Propagation System)

53. Treehouse Software Advantages: ADAREORG: Significantly Cuts File Conversion Times (in one instance shortened a file conversion from 24 hours to 2 hours) tRelational: Interactive Data Modeling from Adabas to RDBMS DPS: Efficiently Propagates Data From Adabas To Any Format

54. Secondary Tools Software Vendor: Computer Associates Installed at PSU since 1985 Software used to create performance reports, trace problems

55. CA Product Line: Performance Reports Tracing Problems Performance Reports: APAS (Adabas Performance Analysis System) Tracing Problems: Insight

56. Enterprise Infrastructure – Database Administration Discussion and Questions

58. Enterprise Services Integration: Born of the need to build a Services Oriented Architecture in support of the AIS modernization program on the enterprise server utilizing the zVM/zLinux O/S platform > NEW and EXCITING Technologies, c0mplexity is integrating them into real solutions Workflow and PELL XML document processing are the first implementations of the AIS J2EE modernization strategy 2 New Operating Systems, New Database Technology, New Application Server Environment, New Web Server Environment, Newly ported Workflow Engine, New Software AG XML software……BUT on the familiar enterprise server iron

59. SO…..Where are We? Built 3 test architectures since 11/05 including a windows environment and multiple zLinux environments Successful workflow engine port test to zLinux in 08/2006 Completely abandoned the windows environment 09/2006 Pilot test for UGTR workflow application 10/2006

60. SO…..Where are We (cont)? PELL ready for a parallel test on zLinux using all new XML document processing software IBM health check completed and recommendations implemented Production environment created & ready for use on March 15th Leveraged the power of virtualization on a known hardware platform, incorporated vendor best practices on the environment, and started to integrate into the organizations’ strengths in production control and operations

61. New Technologies: XML XML orchestration using Software AG’s Mediator XML database using Software AG’s Tamino Software AG’s IBPM workflow engine IBM’s DB2 relational database IBM’s Websphere Application Server Network Deploy zVM and zlinux OS LDAP role based authorization security IBM’s Omegamon monitoring software CA’s operator software

62. What’s Next? Continued emphasis on identity management and security architectures – corroboration with ASSET Implement true SOA – Governance, Registry, Websphere ESB, CentraSite Implement Web Server Load Balancer and Security Gateway Appliance Cross Training Migration of eCommerce to new architecture Automating alerts and increased monitoring High availability and DR documentation

69. 3000 service requests annually 12,000 scheduled jobs executed 9,500 files accessed

70. 278 total devices 77 ANGEL devices or 28% 133 production servers

71. 50 TB storage currently and growing More prevalent Windows 2003 64-bit Dell OpenManage monitoring

72. 509 databases 2 TB for just the db data 28 db servers

74. Migration of services to VM Storage strategy and management Load testing for high demand apps