View Printable Version

F13 - What a DBA Needs to Know about Distributed Shells and SSH

Session Number: 3269
Track: F - General II
Session Type: Podium Presentation
Primary Presenter: Larry Sokoloski [Lockheed Martin]
Time: Nov 18, 2015 (02:30 PM - 03:30 PM)

Speaker Bio: I have over 25 years of database experience as a developer, system programmer, consultant and DBA on z/OS and LUW. I like to leverage the power of scripting to automate tedious DBA tasks.
Audience experience level: Beginner, Intermediate, Advanced
Presentation Platform: DB2 for Linux, UNIX, Windows
Presentation Category: Data Management
Audiences this presentation will apply to: Database Administrators, Systems Programmers
Objective 1: Show how to create a SSH key and passphrase on a management node and copy the SSH key to any number of database servers.

Objective 2: Describe AIX DSH capabilities and create DSH environment variables and server lists.
Objective 3: Describe in detail a short script stub that is the foundation code for automating DBA administration and reporting tasks across database servers by DB2 directory, instances and databases.
Objective 4: What is a man-in-the-middle attack and how can OS maintenance can cause this the host key to change and how to keep you host keys current.
Objective 5: Describe how to execute inline PL/SQL code within a Korn shell.

Abstract:  Managing hundreds of database servers can be made easier by implementing distributed shells like AIX's DSH, Puppet and Chef. This presentation will walk the DBA through the steps of creating and maintaining SSH keys,configuring DSH environment variables and automating DBA administrative and reporting tasks with distributed shells.

For questions or concerns about your event registration, please contact