(Craig Mullins) What’s in a name? The establishment and enforcing of naming conventions is often one of the first duties to be tackled when implementing new software. Adequate thought and preparation is required in order for such a task to be successful. What amount of effort should be extended in t

(Farzad Farahbod) A repository, such as a relational database, provides the environment to securely share XML documents and XML schemas with authorized users. The authorized users have secure access to important XML documents and XML schemas at any time, from anywhere. By using a repository system t

(Chris Eaton) In my last posting I discussed the new larger rid format for tablespaces in DB2 9. This allows for more rows per page and more pages per table partition. As I mentioned any new DMS tablespace created in DB2 9 or any Automatic Storage Tablespace in DB2 9 will use the larger rid format b

(Lester Knutsen) One of the advantages of Unix and Linux is the ability to use scripts for developing systems and programs. I’ll introduce you to using shell scripts with embedded SQL to access your database. Shell scripts are easy to write, they don’t need to be compiled, and are great for small ba

(Willie Favero) So, what does one do in Seattle when all of the roads are iced over, it’s 25 degrees (F) and getting colder, and it’s threatening to snow again? Well, you sit around a cold and boring hotel and try to figure out what the two DSNZPARM keywords CMTSTAT and IDTHTOIN have in common with

(Craig Mullins) Most DBAs have faced the situation where one of their applications requires a four-byte code that is used to identify products, accounts, or some other business object, and all of the codes are numeric and will stay that way. But, for reporting purposes, users or developers wish the

(Paolo Bruni, Patric Becker, Tim Bohlsen, Burkhard Diekmann, Dima Etkin and Davy Goethals) The requirements for a database management system (DBMS) have included support for very large and complex data objects. DB2 UDB for OS/390 Version 6 introduced the support for large objects (LOBs): they can c

(Chuck Ballard, Angus Beaton, David Chiou, Janardhan Chodagam, Meridee Lowry, Andrew Perkins, Richard T. Phillips and John Rollings) In this IBM Redbook we describe and discuss DB2 Data Warehouse Edition (DWE) Version 9.1, a comprehensive platform offering with functionality to build a business inte

(Jin Ji Wen and Wang Sheng Ping) There are two ways to create business integration modules: The first is to create a new business integration module in WebSphere Integration Developer directly. The other way is to create a new business modeling project in WebSphere Business Modeler, and then export

(Chris Eaton) Prior to DB2 9 any non long data types (i.e. not blobs, clobs or long varchar) were stored in “regular” tablespaces. Data stored in these tablespaces always had a 4 byte record identifier known as a RID. The 4 bytes are made up of a 3 byte page number and a 1 byte slot number. The slot