IDUG DB2 Tech Conference in Sydney, Australia 2014
Sydney, Australia
10 - 12 September, 2014

View Printable Version

DB2 Scripting Hacks: Make Your DBA life easier with scripts

Session Number: 3055
Track: LUW Track
Session Type: Podium Presentation
Primary Presenter: Roland Schock [CEO - ARS Computer und Consulting GmbH]

1.08 => Fri, Sep 12, 2014 (12:30 PM - 03:45 PM)

Speaker Bio: After his studies of Computer Science at Technische Universitaet Muenchen from 1985-1992 Roland Schock co-founded ARS Computer und Consulting GmbH with two associates. The company ARS is one of the first IBM Premier Partners in Germany and is dedicated to know how transfer in the DB2, WebSphere and Java area, consulting, selling IBM hard- and software and services. Roland Schock takes care of the database and host access department.
Audience experience level: Beginner, Intermediate
Presentation Category: Managing Availability
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Database Administrators, Systems Programmers, New Users
Technical areas this presentation will apply to: User Experiences
If Tools and Utilities was selected which products: All the tips and trick will be presented, so the participant can immediately use it under Windows and several Unix shells. There will be no 3rd vendor tools, but we will have to use open source libraries for Unix-like text processing (GNU text utils)
All scripts will be available for download for the participants.
Objective 1: Get started with the shell, shell variables, proper quoting and calling db2 properly
Objective 2: Get along with Windows User Access Control and a commandline, if you are on the road with your laptop (which is not trivial).
Objective 3: Exploit GNU text utilities to get things done easily.

Abstract:  Make your life simpler with scripting the day to day jobs and DB2. Master the tricky quoting of params in Windows and different Unix shells. Use pipes for redirected restores and parse DB2 output to feed it back into other programs.

For questions or concerns about your event registration, please contact