Facets Demo New Batches Starting from Saturday... 22-10-2016
Search Course Here

Live Chat



IBM DB2 for z/OS helps you to reduce cost and complexity in your IT infrastructure, simplify compliance, and leverage your core asset your data , so you can transform and adapt while limiting risk and cost to achieve agility and efficiency by standardizing best practices. Gain unmatched availability, reliability, and security for business critical information .Even in the most favorable economic climate, businesses need to control costs and increase efficiency in order to improve their bottom line. In today's more challenging business environment this has become a key factor for the survival and success of enterprises of all sizes.
  • Design a relational table
  • Describe the SQL data manipulation statements to access and change the contents of DB2 tables
  • It is a 20 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

  • It is a 5 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
    Private Classroom arranged on request and minimum attendies for batch is 4.
course content
    • Introduction
    • Time Sharing Option/Extensions (TSO/E) and ISPF
    • Data Sets (Part 1)
    • Introduction and Concepts
    • Structured Query Language (SQL)
    • DB2 Objects
    • Data Sets (Part 2)
    • DB2 Overview
    • DB2 Commands
    • JCL and SDSF
    • Utilities
    • DB2 Logging
    • Shutting down and restarting the DB2
    • DB2 program preparation
    • Scalability
      • describe the DB2 support for 64-bit storage
      • discuss the support provided for an increased number of partitions
      • describe the new features allowing more complex join statements
    • Availability
      • describe the new partitioned tables function
      • list the various index classifications
      • discuss online schema changes
      • relate the changes to partition management
      • describe the processes for system level point in time recovery
    • SQL enhancements
      • describe the use of dynamic scrollable cursors
      • explain multirow FETCH and INSERT
      • describe the GET DIAGNOSTICS statement
      • discuss the use of recursive SQL
      • describe sequence objects and their usage
      • discuss the usage of a scalar full select
      • describe the usage of a SELECT statement in an INSERT statement
    • e-business
      • discuss the DB2 Universal Driver for SQL for Java (SQLJ) and JDBC
      • describe the new integrated Extensible Markup Language (XML) publishing functions
      • relate the enhancements to DB2 security functions
    • Unicode in DB2 for z/OS
      • describe the fundamentals of Unicode and how it is implemented.
    • Network computing
      • describe new functions including member routing, Distributed Relational Database Architecture (DRDA) data stream encryption, and rollup of accounting data for threads.
    • Application enablement
      • describe the new functions for stored procedures and User Defined Function (UDF) routines
      • relate the use of the new capabilities of Open Database Connectivity (ODBC) for UNIX System Services
    • Utility enhancements
      • describe the new features of LOAD and UNLOAD
      • discuss the methods for rebalancing partitions
      • explain the changes to the REORG, COPY, REPAIR, and DSN1COPY utilities
      • relate the utility changes to support Data Partitioned Secondary Indexes (DPSI)
    • Performance enhancements
      • describe the new index support functions
      • discuss the new capabilities for obtaining distribution statistics
      • relate the implications of volatile tables
      • explain the new capabilities for processing star joins
      • describe the new functions for Visual Explain
    • Data sharing enhancements
      • describe the V8 reduction in Coupling Facility (CF) lock propagation
      • explain CF request batching
      • relate the improvements for Logical Page list (LPL) recovery
    • Installation and migration
      • plan for Version 8
      • discuss the migration process and implications
      • describe the changes to the catalog
    • Welcome
    • Introduction to Java and DB2 9 for z/OS Enterprise Servers
    • DB2 Access from Java Using JDBC
    • DB2 Access from Java Using SQLJ
    • Java Stored Procedures
    • Object Relational Extension
For Videos Click Here Videos

Flash News

AngularJS New Batch Start From 09th OCT & 10th OCT.

Hadoop Dev New Batch Start From 10th OCT & 11th OCT.

IBM COGNOS TM New Batch Start From 11th OCT & 12th OCT.

Informatica Dev New Batch Start From 12th OCT & 13th OCT.

Mean Stack New Batch Start 13th OCT & 14th OCT.

SAP BODS new Batch Starting From 14th OCT & 15th OCT.

SAP S/4 HANA New Batch Start From 15th OCT & 16th OCT

Tableau New Batch Start From 16th OCT & 17th OCT


Facets Demo Training

Demo Schedule : 08:30P.M EST / 07:30P.M CST / 05:30P.M PST on 21st OCT & 06:00A.M IST on 22nd OCT
Email :
Rediff Bol :
Google Talk :
MSN Messenger :
Yahoo Messenger :
Skype Talk :