Articles & Content

Archives

G10 - "I'm a DBA Not a Developer!" - with Apologies to Dr. Leonard McCoy

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2016



But we NEED to BE developers!
DBAs frequently (constantly?) get called on to develop “quick” database scripts and programs, never mind that we don’t have the time, the tools, or the training. From a quick, little runstats script in ksh, to a full blown application to load data or “fix a few rows”, it seems that if the data is in the database, it’s my job to fix it!
This presentation will present examples of manipulating DB2 data in several programming languages commonly used with DB2 LUW (ksh, perl/dbi, java/jdbc ) and discuss the plusses and minuses of each. Heavy emphasis will be placed on error handling, as this is one of areas that is most often overlooked or under developed. My favorite utility will be explained and sample code in perl and java will be discussed.

Next, I will share some of my favorite utilities, tools, tips and tricks to help the DBA get things done.



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.