Articles & Content

Archives

DB2 Scripting Hacks for Linux, UNIX, and Windows (C06)

Topic: DB2 for LUW

Subtopic: 2008



DATE: 2008-10-14 (14:00 - 15:00)
SPEAKERS: Fred Sobotka (FRS Consulting)

Automation is not laziness. It is, in fact, an absolute necessity to staying sane as a DBA. This session shows DBAs how to automate even the most tedious of tasks by exploiting many diverse utilities that are either part of the base operating system (Linux, UNIX or Windows) or are freely obtainable online. The tips presented cover a wide range of use cases and skill levels, but all are based on real-life scenarios encountered by a battle-hardened DBA. The presentation uses numerous functional examples to demonstrate how DBAs can apply free, simple utilities to streamline many common tasks.

EXP. LEVEL: Intermediate

OBJECTIVES:

Get the most out of DB2's command-line processor (CLP) by learning about its design and by working around its limitations

Build a versatile toolkit of UNIX scripting tools, including Perl, sed, awk, and xargs

Exploit the Cygwin shell and its scripting utilities to create a UNIX-like environment on Windows platforms

Learn about Microsoft's new PowerShell, which offers an attractive scripting environment for administrators in Windows-only environments

Evaluate the pros and cons of different job scheduling systems, including DB2 Task Center, UNIX cron, and Windows schtasks



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.