(Ember Crooks) Specifies whether or not the database manager can use Intra-partition parallelism. Intra-partition parallelism allows db2 to apply more than one cpu to processing a query.
Tag: IBM
DB2 10 Performance Improvements
(Dave Beulke) There are many great features in DB2 10 and as the system migrations happen more companies are experiencing improved performance. The clients doing migrations from DB2 Version 8 to DB2 10 are especially happy experiencing the performance improvements in DB2 Version 9 once they make it
Ensuring data quality for multilingual data using IBM InfoSphere Information Server
(Bharath Kumar Devaraju and Rachit Arora) With ever-growing importance for data quality in growth markets, many companies have an immediate need to cleanse unstructured data. However, one of the challenges during this exercise is language. Countries such as India, where there are multiple languages,
Must-have iPad Apps for the DB2 DBA
(Frank Fillmore) At IBM’s Information on Demand (IOD) conference held in Las Vegas in October of 2011, I was awarded an iPad 2 at the IBM Champions luncheon for working on the “most significant” Oracle to DB2 migration to that date.
Working With Variable Data
(Craig S. Mullins) One of the key design issues that is addressed in most DB2 applications is how to implement character data that varies in size from row to row. The basic trade-off is “ease-of-use and performance” versus “storage requirements.”
Get started with IBM ILOG CPLEX Enterprise Server
(Jun Zhang) The IBM ILOG CPLEX Enterprise Server, a new feature of IBM ILOG CPLEX Optimization Studio Version 12.4, allows remote, concurrent, queued, multi-user solving for OPL applications.
Episode #74: DB2’s GOT TALENT Finals Round #2! Watch, Learn, and VOTE!
(Scott Hayes) 96% of our audience learned something! Our Top 10 Finalists need YOUR votes! Their futures and BIG prizes depend on impressing YOU with their sage advice and presentation skills! Watch the replay, learn valuable DB2 LUW and z/OS tips and techniques, and then cast your votes for the fin
Watch Migration from Oracle to DB2 in Real Time
(Leon Katsnelson) This video shows a live migration of the OpenBravo, a complex ERP application, from Oracle to DB2 for Linux, Unix and Windows.
db2caem – Get Actual Row Counts in Your Explain Plans
(Ember Crooks) db2caem is a tool in 9.7 that reports actual row counts in your explain plan alongside your estimated row counts.
Moving a PHP application to DB2 from MySQL, Part 4: Deploy your application
(Daniel Krook, Yan Li Mu and Mark Nusekabel) Learn why you should move a PHP application to DB2, how to plan the migration, how to execute it, how to support it, and how to handle potential risks based on the experience of an IBM Intranet application case study.
