IBM DB2 LUW Online Training

IBM DB2 LUW Online Training

0 STUDENTS ENROLLED

    IBM DB2 LUW Course Content :

    1. 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)

    2. 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

    3. The DB2 Database Manager Instance

    4. 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

    5. Product installation, extract and instance creation

    6. 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 table space 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

    7. Creating databases and data placement

    8. Creating database objects

    9. 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

    10. Creation of table spaces, tables, databases

    11. 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
    • Ingest utility

    12. Moving data using Export, Import, Load

    13. Backup and recovery

    • Transactional logging (Circular, Archival)
    • Configure database logs
    • Backup utility options
    • Recovery utility options
    • ROLLFORWARD
    • DB2 RECOVER DATABASE
    • ONLINE versus OFFLINE backup
    • Backup and recovery

    14. 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

    15. Using above DB2 Tools/Utilities

    16. 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

    17. Using db2pd to identify locks, wait locks, deadlocks

    18. Security

    • Authentication versus Authorization
    • SYSADM, SYSCTRL, SYSMAINT, SYSMON
    • DBADM, SECADM, ACCESSCTRL
    • DB2 security privilege hierarchies
    • Grant and Revoke privilege

    19. Database Security using grant/revoke

    20. 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

    21. Log archive/retrieval process

    22. 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

    23. Explain Tools, Indexes creation

    24. Advanced Monitoring

    • GET SNAPSHOT command
    • In-memory metrics
    • Monitoring table functions
    • Administrative views, functions
    • Monitoring performance with SQL
    • Monitor heath with SQL

    25. In memory metrics, SQLS, Admin views, functions

    26. 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

    27. DB2 HADR setup (1 primary, 1 standby creation, setup, communication)

    Write a Review

    Your email address will not be published. Required fields are marked *

    Course Reviews

    N.A

    ratings
    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 1 month

    Drop us a query

    Job Support

    Course Features

    Live Instructor-led Classes

    This isn't canned learning. Its dynamic, its interactive, its effective

    Expert Educators

    Only the best or they're out. We are constantly evaluating our trainers

    24&7 Support

    We never sleep. Need something answered at 3 am? No Problem

    Flexible Schedule

    You don't learn as per our calendar. We work according to yours.

    Customized Training's

    The most part self-managed and adaptable to suit a person's particular adapting technology needs

    Priority Based Training's

    Real-time Scenario based Assignments and Case Studies

    Disclaimer

    This web site or keentechnologies.com team is not associated with SAP AG or any other product. We are providing this service absolutely for Education and Training purpose only. We charge for the support services only, not for the actual SAP System access. All SAP Systems operate under INITIAL evaluation license. All trademarks mentioned on this web site belongs to their owners. We do not share or distribute ANY personal information we collect on this web site. For any additional information

    475-212-0075

    +91 9989754807

    trainings@keentechnologies.com


    ONLINE MEETING PARTNERS

    top
    COPYRIGHT © 2019 KEEN IT TECHNOLOGIES PVT.LTD, ALL RIGHTS RESERVED
    X