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 Tuesday... 01-11-2016
Search Course Here




Live Chat
Support
IBM DB2 DBA Online Training, Online IBM DB2 DBA Training, IBM DB2 DBA Training Course, IBM DB2 DBA Training

IBM DB2 DBA

overview

IBM DB2 is a family of database server products developed by IBM. These products all support the relational model, but in recent years some products have been extended to support object-relational features and non-relational structures like JSON and XML.
prerequisties
  • Unix Basics (or)
  • Unix & Shell Scripting basics.
Duration
Online
  • It is a 16 days program and extends up to 2hrs each.
  • The format is 20% theory, 80% Hands-on.

Corporate
  • It is a 04 days program and extends up to 8hrs each.
  • The format is 20% theory, 80% Hands-on.
Classroom
    Private Classroom arranged on request and minimum attendies for batch is 4.
course content
  • Overview of DB2 on Linux, UNIX and Windows
    • DB2 family products overview (LUW, Mainframe, iSeries)
    • DB2 LUW product editions (Express-c to PureScale to InfoSphere)
    • DB2 product features and functions
    • DB2 client connectivity options (Data Studio, Data Server Client)
  • Command Line Processor (CLP) and GUI usage
    • Introduction to DB2 CLP environment
    • Non-interactive mode
    • Interactive mode
    • db2 command line options
    • Client connectivity from Data Studio
  • The DB2 Database Manager Instance
    • About DB2 Instance
    • Database Manager Instance overview
    • DB2 instance creation pre-requisites
    • Create and Drop an instance
    • Starting and Stopping an instance
    • list and modify DBM configuration
    • db2set command
    • db2 history command
    • DB2 registry and environment variables
  • Creating databases and data placement
    • Database creation pre-requisites
    • Database storage requirements
    • Table spaces overview
    • Storage management overview (SMS, DMS, Automatic)
    • Default Table spaces
    • CREATE DATABASE command
    • List DB configuration parameters
    • Modify DB configuration parameters
    • Database directories and files introduction
    • System catalog tables and views
    • Containers, extents, pages overview
    • CREATE TABLESPACE syntax
    • Storage groups overview
    • CREATE STOGROUP syntax
    • Assigning a tablespace to a storage group
    • Introduction to db2pd command
    • ALTER TABLESPACE, ALTER STOGROUP
    • DB2 LIST DB DIRECTORY
    • DB2 LIST NODE DIRECTORY
    • Activate and deactivate a database
  • Creating database objects
    • DB2 object hierarchy
    • CREATE SCHEMA
    • CREATE TABLE, VIEW
    • CREATE ALIAS, INDEX, TRIGGER
    • creation of temporary tables
    • Creation of temporal tables
    • Table partitioning
    • Referential Integrity
    • Keys, Constraints
    • db2look CLI command
    • Authorization & Authentication
  • Moving data
    • IMPORT versus LOAD
    • Offline versus online load
    • LOAD QUERY TABLE
    • DB2 LIST UTILITIES
    • Pending states (Load, backup, set integrity)
    • EXPORT command
    • db2move cli command
    • ADMIN_MOV_TABLE procedure
  • Backup and recovery
    • Transactional logging (Circular, Archival)
    • Configure database logs
    • Backup utility options
    • Recovery utility options
    • ROLLFORWARD
    • DB2 RECOVER DATABASE
    • ONLINE versus OFFLINE backup
  • Database Maintenance, Monitoring and Problem Determination
    • RUNSTATS utility
    • REORGCHK utility
    • REORG Utility
    • DB2 List commands
    • db2pd - Monitory and troubleshoot DB2
    • MON_GET_TABLE function
    • CREATE EVENT MONITOR
    • DB2 Optimizer
    • DB2 EXPLAIN
    • db2diag.log diagnostic log
    • db2trc command to obtain trace
    • db2fodc: collect diagnostic data for system hang
    • db2advis: Analyze workload
  • Locking and concurrency
    • Importance of locking
    • Table lock modes
    • Row lock modes
    • Lock mode compatibility
    • Isolation levels
    • LOCK TABLE statement
    • Lock escalation, wait, and timeout
    • Deadlocks and detection
  • Security
    • Authentication versus Authorization
    • SYSADM, SYSCTRL, SYSMAINT, SYSMON
    • DBADM, SECADM, ACCESSCTRL
    • DB2 security privilege hierarchies
    • Grant and Revoke privileges
  • Log Management
    • Database seeds
    • Log sequence numbers
    • db2ckbkp -l command
    • logfilsiz, logbufsz
    • Logprimary and Logsecond
    • db2pd to check logging activity
    • Log Archive processing
    • Log retrieval processing
    • MAX_LOG configuration parameter
  • Performance Tuning
    • Analyze SQL statements
    • Create an access plan graph
    • db2exfmt tool
    • db2expln tool
    • Using Indexes for performance
    • Index usage statistics using db2pd
    • MON_GET_INDEX
    • MON_CONNECTION_SUMMARY view
    • Clustering indexes
    • db2advis command
  • Advanced Monitoring
    • GET SNAPSHOT command
    • In-memory metrics
    • Monitoring table functions
    • Administrative views, functions
    • Monitoring performance with SQL
    • Monitor heath with SQL
  • High Availability with DB2 Database products
    • High Availability options in DB2
    • DR options in DB2
    • High Availability Disaster Recovery (HADR)
    • High Availability through Log Shipping
    • Log mirroring
    • High Availability through suspended I/O and online split mirror support
Videos
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

PUBLIC DEMO

(1) Workday Technical Demo Training

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

(2) SAP MII Demo Training

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

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