(Martin Jungfer and Siegfried Wurst) This article describes performance considerations for IBM DB2 for Linux, UNIX, and Windows stored procedure ADMIN_MOVE_TABLE in a SAP system environment. We will examine tables with the characteristics of typical SAP systems.

(Cristian Molaro) The DB2 for z/OS version 10 DDF migration infoapar II14619 should be in the list of your most regarded references in your migration to DB2 10. It provides up to date and critical information that helps to migrate to DB2 10 safelly.

(Dave Beulke) In last week’s blog post on company and government analysis of our digital footprints, I mentioned several aspects of the Big Data digital horizon.

(James Buck) An additional feature of the Run SQL Scripts interface is SQL Assist. This feature allows the user to create fairly sophisticated SQL statements with little or no knowledge of SQL. Although you should learn to write SQL statements without depending on a feature such as SQL Assist, this

(Cuneyt Goksu) The Social Security Institution (SSI) for the Republic of Turkey was established to provide Turkish citizens with equitable, easily accessible social and universal health insurance. The organization is responsible for implementing social security policy in accordance with national dev

(Emma Bushby) This article describes the WebSphere MQ Application Activity Trace, a new feature in WebSphere MQ V7.1 on all distributed platforms. Until now it has been difficult for WebSphere MQ administrators to see what the applications connecting to queue managers are actually doing. Application

(Ember Crooks) Many times, the SQL analysis I do is extremely focused – mostly on SQL that is a proven resource hog or a suspected problem. Analyzing all SQL used in a particular process can be a bit different, and may not be something that is frequently done in WebSphere Commerce databases.

(Peter J. Jamack) The data warehouse has been an ongoing battle among organizations for years. How do you build it? What data can you integrate? Should you use Kimball or Inmon, corporate information factory (CIF), or data marts? The list could go on for days — decades, even. With big data, the que

(Craig S. Mullins) We continue the series on DB2 locking today with a look at the SQL statement: LOCK TABLE .

(Troy Coleman) Getting the most from a new DB2 release typically requires some work on the part of customers, who must redesign their applications to take advantage of the latest features. Of course this effort is worthwhile, because it ultimately saves CPU, thus reducing the overall cost of the new