(Roger Sanders) Here are more sample questions to help you prepare for the DB2 9 DBA certificiation exam. The questions originally appeared in the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press, and are reprinted with permission. Che

(Willie Favero) I guess it ‘s time to get back to blogging about how stuff works. I have a little more time to think right now; in between articles and have no presentations due to any conferences in the near future, so I will use the few minutes of extra time for some good old fashion tech blogging

(Skip Marchesani) I frequently use Interactive SQL or Run SQL Scripts in Navigator to do ad hoc analysis of information in an SQL table, which often results in one or more new columns being derived or created based on existing columns. When I first began doing these types of queries, I was frustrate

(David Whitelegg) This is the second in a two-part tutorial series on creating secure Java-based Web applications using Rational Application Developer, Data Studio and Rational AppScan. In Part 1 you developed a Java Web application with Rational Application Developer, and then deployed the applicat

(Troy Coleman) What’s the most efficient SQL statement you could ever write? The answer is one that’s never executed.

(Willie Favero) IDUG, one of the premier DB2 events (if not THE premier event for DB2) is just around the corner. The North America flavor of the conference is the week of May 18-22 in Dallas, TX. Hopefully, I’ll get to see many of you at IDUG. However, if you are unable to attend this years confer

(Antonio Cangiano) I’d like to take a moment to provide a small status update on what’s been going on in the DB2 on Rails world. The Alphaworks starter toolkit hasn’t been update for a long time, so someone may wrongly assume that the project is not maintained, but nothing could be further from the

(Robert Catterall) When people analyze DB2 for z/OS monitor accounting reports or online DB2 monitor displays of thread detail data, they often pay particular attention (with good reason) to the elapsed and CPU time figures contained therein. Some of these same folks are a little confused as to the

(Andrew Ford) The kind people at IBM Database Magazine have asked me to join their highly unpaid blogging staff to write a few paragraphs a month on all things Informix. I’ll be pulling from my own day to day experiences as a DBA who frequently puts on the software developer, system administrator, d

(Scott Salisbury) Have you ever avoided using SQL in your RPG programs because embedded SQL is a hassle and it’s just easier to do it the old-fashioned way? Have you ever wished your RPG programs could access data from Microsoft SQL Server or Oracle? Do you work with multiple databases and multiple