Mail : training@ecorptrainings.com
India : +91-8143-111-555
USA : +1-703-445-4802
Whats app : +91-8143-110-555
Facebook Twitter Google Plus Pinit Stumbleupon Youtube Blog

Workday HCM Demo New Batches Starting from Wednesday... 14-12-2016
Search Course Here




Live Chat
Support


DB2 Z-OS

overview

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.
prerequisties
  • Design a relational table
  • Describe the SQL data manipulation statements to access and change the contents of DB2 tables
Duration
Online
  • It is a 20 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

Corporate
  • It is a 5 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
Classroom
    Private Classroom arranged on request and minimum attendies for batch is 4.
course content
  • TRACK I : BASICS
    • 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
  • TRACK II : DB2 UDB
    • 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
  • TRACK III : USING JAVA
    • 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
Videos
For Videos Click Here Videos

Flash News


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


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


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


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


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

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

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

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

PUBLIC DEMO


(1) Workday Technical Demo Training

Demo Schedule : 09:30A.M EST / 08:30A.M CST / 6:30A.M PST on 13th DEC & 07:00A.M IST on 14th DEC

SOLVE YOUR QUERIES ONLINE
Email :
Rediff Bol :
ecorptrainings@rediffmail.com
Google Talk :
ecorptrainings@gmail.com
MSN Messenger :
ecorptrainings@hotmail.com
Yahoo Messenger :
ecorptrainings@yahoo.com
Skype Talk :
ecorptrainings