(Pavan Kristipati) There are many tools and utilities that simplify routine tasks and empower DBAs to automate tasks and get the job done. One of them is UNIX’s crontab utility. Colloquially, this is referred to as ‘Cron’ .

(Robert Ferin) Actions are the building blocks of an IBM Datacap application. Here, you can find the information to create your own actions to be used within an IBM Datacap application. When you cannot do an application function by using standard actions, you can write custom actions to fulfill your

(Kent Milligan) Often, when looking at a report, a user prefers to see similar values grouped together on a single line of output instead of having those values spread across multiple lines of report.

(Barkana Emrah, Antonella Bertoletti, Stefano Bussaglia, Ernest Calalang, Sebastian Kapciak, Leonardo Olivera, Sergio Polastri and Fabio Silva) This IBM Redbooks publication uses the same practical solution and is an extension to Creating Integrated WebSphere Solutions using Application Lifecycle Ma

(Lockwood Lyon) DBAs need to remove themselves from the rut of “what do I tune?” and spend some quality time on metrics, configurations, and costs. Develop these measurements and do a root cause analysis. Know your system!

(Carol) It has been almost a year since our partner DBI Software crowned the current DB2’s Got Talent Champion, Mike Krafick. Once again DBI are searching for participants to enter the hugely successful annual contest and we are thrilled to be sponsoring the competition again this year.

(Ember Crooks) We DBAs are lazy in some ways. Our favorite way of moving large amounts of data is the backup utility. It’s so easy to move data, structure, objects, permissions, etc.

(Lockwood Lyon) The most common performance issues related to SQL are those where a statement either executes for an inordinate amount of time, consumes excessive resources, or exceeds some capacity limit. Here are some examples:

(Noureddine Brahimi) You can modify the default WebSphere Commerce data model to maintain optimal system performance during periods of high user connectivity, such as peak shopping events. A heavy workload, simulating a peak shopping event on the original data model, is run and analyzed.

(Scott Hayes) 99% of our audience learned something! Who knew that there were so many options for the powerful and popular “db2pd” command? Not only did Melanie share dozens of db2pd command examples and tips, but she also compared and contrasted to various MON_GET function calls and SQL commands.