Hanseatic Mainframe Summit 2007

Time:	September 03-14, 2007 (two weeks) - Morning Session (09:30-13:30): Lecture - Afternoon Session (15:00-17:00): Lab (practical part)
Location:	Department of Informatics Vogt-Kölln-Str. 30 D-22527 Hamburg
Registration:	closed
Day 1 Day 2 Day 3 Day 4 Day 5	Mainframe and z/OS (details, material) System z Basics, Architecture & z/OS Virtualization zLinux Transaction Management & CICS Java & WebSphere
Day 6 Day 7 Day 8 Day 9 Day 10	DB2 for z/OS (details, material) Overview Relational and Legacy Database Systems Introduction of DB2 for z/OS, Advanced mechanisms Administration DB2 Utilities & DB2 Tools, Information Integration (1/2) Information Integration (2/2)	WebService Enablement and Backend Integration (details, material) SOA Project: We introduce the WebSphere family of tools and frameworks to develop a J2EE application with a service orientedarchitecture (SOA) in a mainframe-based environment.
Certification	DB2 for z/OS (Administration)

Abstract: A mainframe is a computing system that businesses use to host large-scale commercial databases, transaction servers, and applications that require a greater degree of security and availability than is commonly available on smaller-scale systems. Despite their predominance in the business world, mainframes are largely invisible to the general public and the academic community. This is unfortunate, as they offer great opportunities to IT professionals and university graduates in a variety of technical fields. Today, about 60% of all data available on the Internet is stored and processed on mainframe computers. Hence, we are all mainframe users, whether we realize it or not.

This special lecture is offered to computer science students in cooperation with IBM. The lectures of the first week will acquaint you with the technical details of the mainframe hardware and its operating system z/OS. It will also cover technologies that are built on top this platform, such as Virtualization, Linux on Mainframe, Transaction Management (CICS), and enterprise-scale Java applications (J2EE). The second week offers two parallel tracks, DB2 for z/OS and WebService Enablement and Backend Integration. While the track DB2 for z/OS deals with the application and management of IBM's DB2 which is one of the worldwide mostly used database management systems, the major contents of the track WebService Enablement and Backend Integration is to introduce the WebSphere family of tools and frameworks to develop a J2EE application with a service oriented architecture (SOA) in a mainframe-based environment.

Synopsis:

Special Lecture, Praktische Informatik, Bachelor/Master Informatik, Diplom Informatik - Hauptstudium.
Prerequisites (all): Operating Systems basics.
Prerequisites (for DB2 for z/OS): Database Systems basics.
Open to students of all universities in Hamburg.
Language of lectures and lab will be German or English.

Additional admissions upon request.

Credits and grading:

IBM Certified Database Associate DB2 9 Fundamentals
IBM Certified Database Administrator DB2 V9 for z/OS

Track 'DB2 for z/OS' (second week, in parallel to 'WebService Enablement and Backend Integration' track)

'DB2 for z/OS', a relational database management system running on IBM mainframes, is worldwide handling the largest data volumes. Almost each larger banking or insurance company as well as many large-scale enterprises are using DB2 for z/OS to manage and keep available their data. Thus, these enterprises mainly benefit from the major advantages of Mainframe platforms, i.e., scalability, data-sharing / high-availability, security, maintainability, which are fully supported by DB2 for z/OS.

Further, it has to be recognized that about two-thirds of the worldwide data volumes are managed by Mainframes today, often in pre-relational management systems, e.g., IMS, Adabas, IDMS, Datacom, or even in files, e.g. VSAM or QSAM. Information Integration allows to incorporate these data into modern application environments, business processes and strategic initiatives as Business Intelligence (BI), Customer Relationship Management (CRM), Risk & Compliance, or Master Data Management (MDM). So the goal of this track is to qualify for using and administrating DB2 for z/OS as well as corresponding information integration tools both, conceptually as well as practically (hands-on lab).

This track will deal with the following contents:

DB2 for z/OS
- Overview
  - Architecture
  - Data Objects
  - DB2 for z/OS in comparison to DB2 for Linux, Unix, Windows
- Advanced mechanisms
  - Data Sharing/High Availability
  - Security
  - Scalability
  - XML Support
- Administration (Operations, Performance Management)
- DB2 Utilities & DB2 Tools
Information Integration
- Legacy database systems and File Structures: IBM IMS, CA IDMS & Datacom, Software AG Adabas, VSAM Clusters & CICS/VSAM, QSAM & ISAM Files
- Concepts of Information Integration: Federation, Change Data Capture (CDC), Replication, Profiling, Cleansing, Extract-Transform-Load (ETL), SOA
- Sample Solutions: Access to Legacy Data in Web Applications, Real-time Update of Data Warehouses with Legacy-Data, Using CDC Events for Application Integration, Leveraging Legacy Data in Business Processes (BPEL), Migration of Legacy-Databases
- During a hands-on lab, each participant will deploy the product WebSphere Classic Federation Server for z/OS to provide a JSP application with federated access to IMS, DB2, and CICS/VSAM data.

Track 'WebService Enablement and Backend Integration' (second week, in parallel to 'DB2 for z/OS' track)

Major theme of the 2nd week is the transformation of a Mainframe-Application into a Web-Service. Two Project groups of approx. 10 - 12 students will each be responsible to design and implement a project by using the appropriate technologies: Wdz, RAD, CICS will be trained and used to create the application. By the end of the 2nd week the application will be presented to the trainers i.e. customers.

Mainframes Today

Hanseatic Mainframe Summit 2007