Articles & Content

Archives

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

Topic: 2015 EMEA

Subtopic: Cross Platform DB2 for z/OS & LUW



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 it is in the database, it’s my job to fix it!
This presentation will present examples of several programming languages commonly used with DB2 LUW (SQL/PL, ksh, perl/dbi, java/jdbc/jpa, udf, XML) and discuss the plusses and minuses of each. Next, I will share some tools, utilities, functions and tips for coding database programs in each one. Heavy emphasis will be placed on error handling, as this is one of areas that is most often overlooked or under developed.
Next, I will share some of my favorite utilities, tools, tips and tricks to help the DBA get things done.
Finally, we will discuss a few of the different IDEs are available to assist the DBA (Developer wannabe).



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.