Articles & Content

Archives

Varsity SQL for the Busy DBA (E13)

Topic: 2010 EMEA

Subtopic: Cross Platform DB2 for z/OS & LUW



DATE: 2010-11-10 (15:45 - 16:45)
SPEAKERS: Fred Sobotka (FRS Consulting, Inc.)

Adding just a few tricks to your SQL repertoire can save a tremendous amount of time in administering and maintaining your DB2 databases. Advanced SQL techniques aren't just for developers; by combining these patterns with a solid understanding of the system catalog, DBAs can generate sophisticated sets of XML, SQL, DDL, and even programming/scripting code for other languages. Although vendor tools can generate certain types of useful data and code, DBAs also receive many "one-off" requests that may appear to require a lot of hand typing, but are actually well-suited for SQL automation. This session will introduce DBAs to powerful SQL techniques that generate data and code with minimal effort, leading to time saved and fewer errors. The examples provided come from the real-world experiences of a battle-hardened DBA.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

How to spot the SQL shortcut for a seemingly tedious task

Common table expressions, the foundation for versatile SQL that is structured and easily tested and debugged

Replacing unreliable application-based XML generators with ANSI-standard SQL-XML

Identifying the most useful parts of the system catalog

SQL functions and patterns that provide the most bang for the buck



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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