(Kent Milligan) The upper limitation of a dtabase table is 1.7 TB in the V5R4 version. How about the limitation of database table in V6R1? (R)

(Radhesh Kumar) Sometimes even a simple SQL query may become challenging if we dont approach it with a right technique. Few months ago I came across one such SQL query problem that I am going to share in this post. I was writing a database monitoring routine using snapshot table function.

(Antonio Cangiano) You drank the Kool-Aid and downloaded the awesomeness which is DB2 Express-C. Good job! Next you proceed to install it on Linux with sudo ./db2setup and boom, instead of a launchpad all you see is a gray window. Now what?

(Benjamin G. Leonhardi, Christoph Sieb and Michael J. Wurst) In the previous installment of this series you learned how to visualize simple data mining results in IBM Cognos. In this article, learn some advanced techniques, such as drill-down and the extraction of structured information from data mi

(David Beulke) Application developers are starting to leverage the ability to put all types of large XML and unstructured data objects alongside main transaction data in DB2. This marriage of data and large objects (LOBs) has increased the flexibility and functionality of new applications.

(Chris Eaton) In this series we are looking at customer videos. In the last posting we saw Bashir Khan from Dow Jones. In this video a group of DBAs talk about how they successfully upgraded their skills to add DB2 LUW to their skill-set. My opinion has always been that if you are a good DBA regardl

(Mark Mulligan) Have you ever run the db2 “call get_dbsize_info(?,?,?,0)” command to get the size of your DB2 LUW database and noticed that the size is much smaller than the space used on your UNIX file systems? Do you need to monitor database growth over time to help plan for future storage require

(Venkatesh Gopal and Srini Bhagavan) This tutorial shows you how to use IBM Rational Data Architect (RDA) as a modeling tool for Informix Dynamic Server (IDS). Learn about the various features of RDA including how models can be used to represent business entities, database entities, and domain entit

(Craig S. Mullins) Every good DB2 developer knows that DB2 offers two types of SQL, static and dynamic. Static SQL is hard-coded and embedded into an application program and then bound into a package, which determines the access path that DB2 will use when the program is run. Dynamic SQL is built wi

(Phil Grainger) The International DB2 Users Group (IDUG) is pleased to partner with CA to deliver a free Webcast by renowned presenter Phil Grainger, Sr. Principal Product Manager. This live event will run approximately 60 minutes and participants will have the opportunity to pose questions to the p