(Lockwood Lyon) Big data applications are now in place to support business analytics processing. However, many standard performance tuning options (such as indexes) may no longer apply. Here we investigate the differences between operational systems and big data systems, and present common options f

(Jack Vamvas) Once the Tivoli Storage Automation for Multiplatforms(SA MP) and the shared disk approach with DB2 is set and configured, the DBA needs to manage the cluster. There are hundreds of TSAMP and RSCT commands, but these ones will give you a quick start

(Emily Mitchell) Data is one of your company’s most valuable assets. What you do with your data can directly impact the success or failure of your company. To help you know the best way to manage your information, we publish weekly tutorials about data management.

(Pavan Kristipati) In an earlier blog post, we looked at how to create a sample database in DB2 LUW. We also looked at changing the defaults to suit our needs…changed the default database name from SAMPLE to whatever we wanted and also changed the database path (DBPATH).

(Lockwood Lyon) First, let’s consider the generalists. New DBAs and systems programmers start out in this category, only developing specialized skills and in-depth knowledge later in their careers. Their best roles tend to be well-defined, standardized procedures.

(Dave Beulke) I want to thank all my readers for their support and comments this year. It has been a great year speaking at many of the user group meetings and, as always, a pleasure and honor working/hearing from all of you throughout the year. I believe information technology is going through anot

(Troy L Coleman) DB2 10 for z/OS introduced high-performance database access threads (DBATs). Also known as DDF threads, DBATs are used to execute packages bound with option RELEASE(DEALLOCATE).

(Thomas Snyder) Thanks for sticking it out through my preliminary Microsoft articles. It’s about to pay off. Creating Excel spreadsheets from DB2 seems to be a common theme these days, with multiple ways of going about it.

(Ember Crooks) Loading data into a DB2 database using the LOAD utility has a lot of ins and outs. If a DBA has spent a lot of time working in a database without referential integrity or check constraints, then they may forget to check for tables in a check-pending state after loading data.

(Ute Baumbach, Patric Becker, Uwe Denneler, Eberhard Hechler, Wolfgang Hengstler, Steffen Knoll, Frank Neumann, Guenter Georg Schoellmann, Khadija Souissi and Timm Zimmermann) Transforming data from operational data models to purpose-oriented data structures has been commonplace for the last decades