BMC - Interskill Learning Mainframe Training

[email protected]

The World’s Most Delivered Mainframe Training
Search   Course Catalog  
Return to Catalog Home     Return to Curriculum Listing

Databases – Database Communication


4 hours


This course describes how local and remote clients can connect to a DBMS server. It discusses connection options including the use of APIs. You will also see how an administrator can view existing client connections and configure the DBMS to place restrictions on client activity. Finally, you will see how replication provide copies of database systems on alternate DBMS servers. This is useful for redundancy purposes.


This course is suitable for Systems Programmers or DBAs whose responsibility is to create and manage databases, and their management systems.


Successful completion of the Interskill Databases – Introduction to Databases and Database Managers course, or equivalent knowledge.


After completing this course, the student should be able to:

  • Describe how clients connect and communicate with DBMS servers
  • Explain how DBMSs replicate data
  • Describe other DBMS server-to-server communication

Course Content

Client Communications

Connecting to the DBMS Server
Connection Options and Parameters
DBMS connectors and APIs
ODBC and JDBC Drivers
Viewing Client Connections
Terminating a Client Connection
Limiting Client Connections
Managing Connection Performance

DBMS Server Communications and Replication

Database Replication
Advantages and Disadvantages of Replication
Full and Partial Replication
Snapshot and Full Table Replication
Incremental Replication
Synchronous and Asynchronous Replication
Replication to Different DBMSs
Extract, Transform, and Load (ETL)
Data Pipeline Communications
Remote and Linked DBMSs

Databases – Database Communication Mastery Test

Search our catalog