(Craig S. Mullins) The database log, sometimes referred to as the transaction log, is a fundamental component of a database management system. All changes to application data in the database are recorded serially in the database log.

(Willie Favero) DSNWMSGS; one of the coolest flat files available from DB2. DSNWMSGS not only has the detailed description of every IFCID (Instrumentation Facility Component IDentifier) delivered in DB2 for z/OS, this flat file also includes the instructions and sample DDL to load all that descript

(Troy Coleman) Users of DB2 Version 10 and earlier releases may find inconsistent behavior when using the LIKE predicate, particularly if the column contains trailing blanks and is of variable length.

(Craig S. Mullins) Most mainframe programmers are aware that IBM supplies many utility programs that are useful for system maintenance chores such as copying and deleting files, manipulating partitioned data sets, and the like.

(Chuck Ballard, Oliver Brandt, Bharath Devaraju, Daniel Farrell, Kevin Foster, Chris Howard, Peter Nicholls, Ankit Pasricha, Roger Rea, Norbert Schulz, Tetsuya Shimada, John Thorson, Sandra Tucker and Robert Uleman) This IBM Redbooks publication describes visual development, visualization, adapters,

(Henrik Loeser) Imagine that you had to search for a cooking pot within your house. Where would you start and search first? Most people would focus on the kitchen. Where would you look for some toothpaste? Most probably in the bathroom and maybe in the room where you just put the bag from your shopp

(Willie Favero) I know this is going to sound a little silly, but I still excited at the opportunely to use something in DB2 that I haven’t had a chance to use before. DB2 for z/OS is a huge product so any time a can do something new is special.

(Kanagarajan Ramakrishnan Maheshwari) In enterprise integrations, applications across different systems are integrated by various means and techniques. In such large-scale integration, there is a need to identify the key integration components or elements and maintain them in a secure centralized lo

(Scott Hayes) 95% of our studio audience learned something! Today’s presentations were fantastic! Ember Crooks was a substitute judge for Klaas Brant. USA, Brazil, and India competed! You can learn about DB CFG CPUSPEED, a solution for purging 1.1TB of data, and get advice on automating DBA tasks.

(Frank Fillmore) Probably my most popular blog post of all time – certainly the one most commented upon – was called Changing the Hostname for a DB2 Server. If you work in a shop that uses the same image (i.e. a Windows backup, VMWare image, or some other form of snap-shotting a Windows computer) c