There are efficiencies in storage and productivity associated with DB2 as it scales to increased volume. Deep compression improves response time
and query performance and storage capacity, while increasing the amount of data in the data buffer pool. STMM: Self-tuning Memory Manager automates the configuration, monitoring, and tuning of the system memory in relation to workloads. HADR: High-availability Disaster Recovery
decreases the time for recovery from partial and complete site failures. Multidimensional clustering enhances third party enterprise resource planning applications.

IBM is promoting its SOA: service oriented architecture for updating and integrating existing investments in legacy programming languages and mainframe system software. The SOA and DB2 also will accommodate open source software and third party databases.

The DB2 Utilities Suite is comprised of DB2 Administration Tool for z/OS, DB2 Object Comparison Tool for z/OS, DB2 Recovery Expert for z/OS, and DB2 High Performance Unload for z/OS. Database management capabilities
have been added. The online schema can be used for adding partitions and changing data definitions with ALTER statements and online unload and replace. There are database design options for indexes, clustering, and
materialized query tables to rotate partitions which support data warehouses.

SYS-ED workshops demonstrate and explain:

Data types for decimal floating point and spatial data.

Built-in function compatibility within the DB2 family and for third party and open source databases.

XML functions for Java and web applications.

Java Universal Driver.

How to use REORG for improved performance and availability.

New partitioning, clustering, and index options.

Dataset level Flashcopy support for multiple utilities for improved CPU utilization and reductions in elapsed time.

Big Data refers to large volumes - petabytes of data and emerging software technology such as Apache Hadoop and analytical databases. Apache Foundation Hadoop is an open source framework used to store unstructured and multi-structured data. Hadoop runs on commodity servers and provides a low cost staging and refining area for data exploration and reuse. Apache projects being developed as part of an Apache ecosystem include Flume, Hive, HBase, Pig, HCatalog, Mahout, MapReduce, Oozie, and Squoop. Hadoop uses a permissive open source license; it represents a new source of data and opportunity for IBM to drive revenue from DB2 and other new products. IBM offers products in conjunction with Hadoop to meet the operational requirements of mainstream business operations. This includes web server logs, system logs, social media, semi-structured data, sensor data, e-mail, and XML: extensible markup data.

IBM is ending development of BigInsights and migrating existing users to the HDP: Hortonworks Data Platform. Hortonworks will be reselling two IBM products: Data Science Experience suite of tools for
collaborative analytics and Big SQL, a SQL-on-Hadoop query engine. There also will be joint development to expand the features of the Apache Atlas framework. It is part of data governance and security as key issues in Big Data environments. For Hortonworks, the IBM DSX is a more enterprise-ready workbench environment than the Apache Zeppelin notebook tool. IBM SQL also has advantages over the Apache Hive SQL query engine.

Service oriented architecture functions both as a software development environment and a delivery framework. It provides a mechanism for defining business services and operating models as an information technology infrastructure that can be used to meet enterprise business requirements and modernize legacy environments.

In a SOA environment, network nodes make resources available to other network participants as independent services, which participants can access in a standardized way through well-defined service interfaces. SOA is constructed as a shared network of web services linked by distributed intermediaries. Incremental SOA for a mainframe environment will result in a services network. Successful execution of an SOA strategy, combined with the release of the business value contained in legacy systems, DB2 databases, and
IBM MQ: (WebSphere MQ) middleware can produce significant value and return on investment by leveraging existing software assets to create new applications and provide interoperability with modern web-based systems.

Starting with DB2 version 9.7, IBM supports Oracle SQL and PL/SQL. IBM has aligned the syntax and semantics with the locking mechanisms, data types, SQL, procedural language residing on the server, and the client interfaces
used by the applications.

IBM has resolved the concurrency control with Oracle by reading the currently committed version of the changed row and retrieving the locked row from the log. In most cases, since the change has not been
committed, the row will still be in the log buffer. However, even if the row has been written out and overwritten in the log buffer, DB2 will know exactly where to find it. The single I/O will bring the required version
into the bufferpool. Additional lock avoidance techniques have been added which eliminate a reader holding a lock under CS isolation.

DB2 supports a library of functions compatible with Oracle for operating on data. Mismatched types or mismatched semantics of the types can seriously impact the ability to enable an application to
another RDBMS. In order to allow Oracle applications to run on DB2, a number of data types commonly used in Oracle's PL/SQL have been added in DB2 9.7. When an application is ported from one product to another, the SQL and
procedural language is translated from one SQL dialect to the other. The DB2 engine includes a PL/SQL compiler along with the SQL PL compiler. Both compilers produce virtual machine code for DB2's SQL Unified Runtime Engine.

SYS-ED courses and training programs teach the DB2 architecture and components used to implement data integrity and develop systems which are scalable, run in the cloud, and support mobile devices.
SYS-ED collective experience with DB2 reflects our knowledge with the underlying design of IBM DB2 Enterprise Server Edition and the foundation development languages that DB2 was written in. The DB2 courseware, examples, case studies, and examples provided in SYS-ED distance-learning and classroom training services is highly respected. The sample programs and exercises were developed to teach DB2 on multiple platforms. The principles of adult learning have been applied to the subject matter: interpreting and translating content into performance objectives, narrative descriptions, and diagrams which explain.
The full complement of training medium is used to help business and information technology professionals learn.

When information technology professionals leave a SYS-ED DB2 course, they have the documentation, training aids, and examples to code and debug DB2 programs, perform administrative tasks, and optimize system performance. Case and point, if your organization outsourced its DB2 coding and program maintenance to consulting companies in
the 1980ís, it more than likely was SYS-ED which trained many of the consultants who did the actual design and coding.

Few software or consulting companies know and teach DB2 courses better than SYS-ED.

SYS-ED will not accept a DB2 assignment without a consultation with the prospective client organization. We review the background of the employees to be trained, operating environment, documented standards, and project specifications and use that information to select the code snippets, examples, skeleton programs, and hands-on exercises. We then prepare a training strategy: lesson plan, modular
courseware, training aids, and validation assessment. The pre course consultation allows us to identify and differentiate between teaching an industry standard course as compared to the clientís true need for
educational consultancy: 1- DB2 database administration on z/OS - mainframe or a specific UNIX-variant, Linux-variant, or MS Windows platform. 2- Integration with WAS: WebSphere Application Server or alternative third party commercial and open source web server platform. 3- Evaluation for migration to IBM service oriented
architecture standards. 4- Composite application development and repurposing with Rational Developer for System z. And when not confident that a professional training outcome can be provided, politely will turn down an assignment.

As part of presenting an instructor-led DB2 course at the client location, courseware is organized for future use in a web-based infrastructure and delivery medium.

The courseware used in SYS-ED courses consist of student handouts, training aids, and industry-specific examples and exercises. The CETi knowledge base aggregates and analyzes information in the public domain. Content selectively
is added to courseware. Our long term strategy is to have our courseware recognized as a
NRV: Nationally Recognized Vendor.

The distance-learning service is an extension of the
SYS-ED schedule, inclusive of courseware and training aids. A
distance-learning course is 65% lecture with pre and post course validation,
review questions, examples, workshops, and website support services.

Premium Training Services

Recording of Live Sessions

SCORM to Client LMS

Courseware Licensing

Content to Mobile Device Platforms

Enrollment requires a consultation with the manager sending the employee for the training. The prospective trainee needs to be qualified for the course and service transmission to the client location
tested: bandwidth, firewall, base operating system, software requirements, web browser, and set up of machine exercises.

It is difficult to find DB2 courses which provide the foundation and develops the specialized skills needed for database administration, maintenance programming,
cross platform database web programming, and system programming.

2.

There is a scarcity of DB2 courses, 5 or fewer days in duration, geared to corporate employees and their work environments and operational objectives.

3.

A high percentage of DB2 courses are cancelled.

4.

Travel costs and living expenses in a majority of situations are a significant constraint when it comes to attending a DB2 course.

SYS-EDís DB2 courses and integrated training programs have been developed based upon adult learning theory and the standards of the New York State Department of Education.
The curriculum includes specialized courses that comprise IBM strategic imperatives.

The schedule on our websites reflects a projected time frame for licensure with the New York State Department of Education - Bureau of Proprietary School Supervision and submission and approval of curriculum.

Personnel will need to learn new skills in the IBM z/OS mainframe and WebSphere environment for DB2 administration and application development. Some experienced people will be learning web enablement technologies and Java while first generation IT staff will be using ISPF and JCLfor the first time.

Program for Client A

Distance-learning will be used for introductory training: TSO/ISPF, JCL, SQL, and Java fundamentals.

IBM Education Center offerings will be used for specialized operations training.

SYS-ED classroom instruction will be extended with distance-learning to allow staff in remote geographic locations to attend.

The plan is to train all the programmers on DB2 and Java under z/OS. The exact schedule will depend on workloads of the staff.

Evolving IT - Interrelated Technologies

Mainframe installations face challenges in centralized distributed processing: immense amounts of data, web servers, cloud computing, mobile computing and analytics. Organizational enterprise have a substantial investment in hardware infrastructure and applications specific to a business model. DB2 applications developed in the 1990's have to be maintained, updated,
recoded, or ported to another platform. There are long term implications regarding the strategic mix of commercial and open source software.

SYS-ED trained a significant portion of the first generation of DP personnel. And looks forward to training their IT successors in the 21st century.

CoursewareSYS-ED's DB2 courseware draws upon a library of student handouts, sample programs, exercises, case studies and training aids to teach courses and training programs on z/OS, z/VSE, z/VM, and third party emulation workbench/platforms.

Teaching is Our BusinessMost computer training companies are divisions of large software companies or consulting companies. Not SYS-ED. Our only goal is to provide DB2 training for motivated IT professionals. This independence allows us to to concentrate on teaching.

Our Teachers Know How to TeachSYS-ED instructors combine teaching skills with cross platform DB2 skills - operating systems, programming languages, third party utilities and development tools, and system software. After a
course, they are available to answer questions.

Enrollment - SYS-ED DB2 Courses are Not for EveryoneNo one is allowed to enroll in a SYS-ED mainframe course, without a consultation with our
director of education. We review the operational objectives and project specifications for the organization evaluating whether to send its employee for the training. The employee only is allowed to enroll if they have the background corresponding to the learning path.

DB2 Training - Distance-learning or at Your OfficeSYS-ED DB2 courses are provided over the Internet through a distance-learning delivery medium or classroom instruction. Client location courses can include the
same workshops as the SYS-ED schedule.