Craig S. Mullins' Published Articles

	Craig Mullins Published Articles *1997 and Prior*
<MAP NAME="boxmap-p8"><AREA SHAPE="RECT" COORDS="14, 200, 103, 207" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/mullinassoci-20" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/120x240.gif" width="120" height="240" border="0" usemap="#boxmap-p8" alt="Shop at Amazon.com"> <MAP NAME="boxmap-p8"><AREA SHAPE="RECT" COORDS="14, 200, 103, 207" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/mullinassoci-20" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/120x240.gif" width="120" height="240" border="0" usemap="#boxmap-p8" alt="Shop at Amazon.com">	Index by Year: 1996 \| 1995 \| 1994 \| 1993 \| 1992 \| 1991 Craig Mullins: Articles Published in 1997 Large Partitioned Table Spaces DB2 Update, November 1997. This article discusses the issues of table space partitioning in DB2. It provides tips, techniques, and guidelines for implementing partitioned table spaces, as well as in-depth coverage of the new large table space feature of DB2 V5. Useful for all DB2 users. DBMS Trends into the 21st Century IDUG Solutions Journal, November 1997. Database management systems are getting more and more complex as new features are added and new ways are found to utilize them. This article summarizes the major changes impacting DBMS products today and over the course of the next few years. Useful for all DBMS users. This article kicks off the new Face Off column for IDUG Solutions Journal. The Capability Maturity Model - From a Data Perspective. The Data Administration Newsletter, December 1997. The Capability Maturity Model (CMM), published by the Software Engineering Institute (SEI), is a well-established, defined model that characterizes the software development maturity of organizations based on their practices and procedures. However, it does not address the maturity of organizations with regard to the manner in which data is managed. This article introduces the reader to a data perspective of the Capability Maturity Model. Data Definition Guidelines. InformIT, October 1997. This article is an excerpt from my book, DB2 Developer's Guide. It covers the section on DDL guidelines and naming conventions for DB2 objects. The Oracle Environment. Oracle Update, October 1997. This article provides a concise introduction to the environment of the Oracle DBMS in terms of its architecture and components. Useful for all ORACLE and RDBMS users. Co-authored with Christopher T. Foot. DB2 Performance Planning and Engineering. IDUG Solutions Journal, August 1997. Most organizations monitor and tune DB2 performance in a reactive manner. This article discusses how to implement proactive performance engineering for applications before the application is implemented. Useful for DB2 performance analysts and DBAs. Co-authored with Richard Bolesta. Denormalization Guidelines. The Data Administration Newsletter, June 1997. Normalization is the process of putting one fact in one appropriate place. This optimizes updates at the expense of retrievals. This article itemizes several reasons why denormalization of data may be necessary and provides guidelines for successful implementation. Index by Year: 1996 \| 1995 \| 1994 \| 1993 \| 1992 \| 1991 Craig Mullins: Articles Published in 1996 Stored Procedure Guidelines for DB2. DB2 Magazine, Winter 1996. Both of the major implementations of DB2 (DB2 for MVS and DB2 for Common Servers) provide support for stored procedures. In this article, I discuss tips and tricks for implementing useful stored procedures, as well as guidelines for proper stored procedure administration. Most useful for programmers, analysts, and DBAs. Managing Systems in the Age of the Web. PLATINUM Edge, September 1996. As the web and Internet computing become pervasive, the way we manage information systems will need to adapt to include web technology. This article discusses the many ramifications of this oncoming change. Optimizing DB2 Outer Joins. DB2 Update, August 1996. Although coding outer joins in DB2 may appear to be straightforward, there are techniques that can be used to optimize their performance. This article discusses several ideas to aid outer join performance. Most useful for SQL developers and application programmers. Procedural SQL. Enterprise Systems Journal, July 1996. As SQL migrates from a query-only language to a procedural language, understanding the basics of procedural SQL will become an intrinsic component of the database professional's job. This article discusses the impact of procedural logic on SQL. Useful for anyone using SQL and RDBMS technology. Distributed Query Optimization. [Adobe Acrobat Format - PDF] Technical Support, July, 1996. Distributing data using RDBMS technology is quite popular, but few current products enable distributed joins — and those that do are not efficient. This article discusses the challenges of distributed querying and table joining. Security Enhancements in DB2 V4. DB2 Update, June 1996. Several useful security and authorization techniques were introduced to DB2 with Version 4. This article discusses these features and their impact on DB2. Most useful for DBAs and security analysts. Using Variable Character Data in DB2. DB2 Update, June 1996. Database designers frequently run into trouble when deciding whether or not to implement DB2 tables with variable character columns. This article briefly discusses the "pros and cons" of VARCHAR and provides some useful SQL statements to monitor the effectiveness of variable vs. fixed columns. Useful for database designer, performance analysts, and DBAs. Storing Procedural Logic in the Database. Sybase Technical Journal, Spring/Summer 1996. Sybase pioneered the concept of storing procedural logic within a database using stored procedures and triggers. Increasingly, organizations are adopting this technique within their client/server applications. This article offers guidelines and examples of how and when to effectively use and administer server code objects using Sybase SQL Server. Most useful for programmers, analysts, and DBAs. Tools for a Comprehensive DB2 Environment. IDUG Solutions Journal, Issue 2, 1996. Although DB2 for MVS, as offered by IBM, is a complete, full-function RDBMS, users quickly realize that the functionality to adequately support large-scale database development is not provided by DB2 alone. This article examines the burgeoning DB2 add-on product market identifying key product categories and their benefits. Useful for all DB2 users. Industry Trends Impacting Database Administration. Computing News and Review, May 1996. As the IS organization evolves from one of centralized control to an open, heterogeneous environment, the role of database administration necessarily expands. This brief article provides an overview of the DBMS industry. The article highlights pervasive trends (data warehousing, data mining, OO, the Internet) and discusses how these trends impact database administration. Useful for all database professionals. DB2 Version 4 Catalog Revisions. DB2 Update, April 1996. With each new release of DB2, IBM modifies and tunes the system catalog and directory structures. This is done for many reasons including the addition of new features and to make old features more efficient. This article provides an overview of the changes and additions made to the DB2 catalog to support Version 4. Most useful for performance analysts and DBAs. Dealing with Data Outhouses. DM Review, March 1996. Although data warehouses are currently all the rage, few professionals consider the problems that "dirty data" can cause for a warehousing project. DB2 Version 4 Security and Authorization Enhancements. PLATINUM Edge, March 1996. A synopsis of the enhanced security functionality provided by DB2 Version 4. Includes a discussion of plan level authorization for dynamic SQL programs. Useful for all users of DB2. DB2 Version 4 Dirty Read Capability. DB2 Update, February 1996. The ability to read data without taking locks is a common requirement of RDBMS products. Until Version 4, DB2 did not provide this feature. This article discusses the capabilities and ramifications of using dirty reads in DB2 programs and SQL statements. Useful for application designers and programmers, performance analysts, and DBAs. DB2 Version 4 Check Constraints. DB2 Update, January 1996. DB2 Version 4 provides the ability to code limitations on the values that can be stored in DB2 table columns. This is accomplished through the use of check constraints. This article outlines the capabilities of check constraints and gives advice on their proper usage. Most useful database designers and DBAs, but of general interest for most DB2 users. Reorganizing the System Catalog in DB2 Version 4. IDUG Solutions Journal, Winter 1996. Of the many new features added to DB2 Version 4 one of the most eagerly awaited by DBAs is the ability to REORG the DB2 Catalog and DB2 Directory in a systematic manner. This article discusses the steps to take to utilize the new V4 features to accomplish catalog reorganization. Useful for DB2 database administrators and systems programmers. Index by Year: 1996 \| 1995 \| 1994 \| 1993 \| 1992 \| 1991 Craig Mullins: Articles Published in 1995 Gathering DB2 Information in Cyberspace. Enterprise Systems Journal, December 1995. Finding information using on-line services can be a daunting task for the "newbie." This article focuses specifically on sources of DB2 information available on-line through the Internet, CompuServe, and other on-line services. Useful for all DB2 users. The Procedural DBA. Database Programming & Design, December 1995. More and more DBMS vendors are providing methods of including application code into the DBMS (in addition to the data). A proper methodology for handling these server code objects (triggers, stored procedures, check constraints, etc.) must be observed in order to effectively administer this change. This article discusses these new code-based objects and suggests a useful re-definition of the role of a DBA in this changing environment. Useful for all RDBMS users. DB2 V4 Outer Join Basics. DB2 Update, October 1995. Coding a DB2 SQL outer join used to be difficult and complex. However, DB2 Version 4 provides in-depth support for outer joins. This article discusses these features. Useful for all DB2 users. Referential Integrity in SYBASE SQL Server 10. Relational Database Journal, Sept-Oct 1995. Details the manner in which SYBASE supports referential integrity (RI). Covers declarative RI and trigger-supported RI. Useful for all SYBASE users. An Introduction to the Architecture of DB2 for OS/2. PLATINUM Edge, September 1995. An in-depth analysis of the architecture and composition of Version 2 of DB2 for OS/2. Fourth in a four part series. Useful for all users of DB2 for OS/2. Reprinted in the March 1996 edition of DB2 Update. DB2 V4 In-Line Views. DB2 Update September 1995. The ability to specify a SELECT statement in place of a table name in the FROM clause of a SQL statement is a major benefit provided by DB2 Version 4. This article discusses how to code these in-line views. Useful for all DB2 users. Distributed Query Optimization. IDUG Solutions Journal, July-Sept. 1995. Distributing data using RDBMS technology is quite popular, but few current products enable distributed joins-and those that do are not efficient. This article discusses the challenges of distributed querying and table joining. An Introduction to the Architecture of ORACLE. PLATINUM Edge, Summer 1995. An in-depth analysis of the architecture and composition of ORACLE7. Third in a four part series. Useful for all ORACLE and RDBMS users. Co-authored with Christopher T. Foot. Producing Quality Software. Systems Development Management, May 1995. Quality has become a buzzword, but it also has become necessary for survival in today's business environment. Software development managers must satisfy customers with quality systems. This article explores how to manage technology, techniques, and personnel to produce quality systems that meet clients' demands. This article was also published as a chapter in the Auerbach reference book entitled Handbook of Application Development, co-authored with Bernard S. Klopfer. 3rd edition published 4th quarter 1995. Stored Procedures in DB2 Version 4. IDUG Solutions Journal, April 1995. Although stored procedures are old features for many of the client/server RDBMS products, they are new to DB2 as of Version 4. This article details the manner in which stored procedures are implemented in DB2. Useful for all users of DB2. Reprinted in the June 1996 issue of Enterprise Client/Server. An Introduction to the Architecture of DB2. PLATINUM Edge, Spring 1995. A short analysis of the architecture and composition of DB2. Second in a four part series. Useful for all DB2 and RDBMS users. DB2 SQL Analysis Tools. DB2 Update, February 1995. The development of SQL to access DB2 tables is typically the responsibility of an application development team. However, because of the flexibility of SQL, the same request can be made in different ways, each yielding the same results but quite different performance. This article discusses how to ensure optimal SQL and the benefits of an automated tool to examine application SQL statements. Useful for DBAs, systems analysts, and programmer/analysts. Optimizing Client/Server Performance. Data Management Review, January 1995. Client/server applications are gaining wide acceptance and quite a lot of press, but there have been very few discussions of the performance implications of client/server processing. This article discusses those implications and provides some tuning advice. Useful for systems analysts, application developers, and programmers. Lock Avoidance in DB2 Version 3. DB2 Update, January 1995. Lock avoidance is a new feature of DB2 Version 3 that, in certain circumstances, enables the DBMS to bypass locking and maintain integrity. This article discusses the features that enable DB2 V3 to provide lock avoidance. Useful for DBAs, performance analysts, systems programmers, and Technical Support personnel. Data Set Closing From Deferred to Pseudo. Relational Database Journal, Jan-Feb 1995. DB2 Version 3 once again changed the manner in which the underlying physical data sets used by the RDBMS are opened and closed for usage. This article provides a short introduction to the past and present functionality of DB2 data set management. Useful for DBAs, performance analysts, systems programmers, and Technical Support personnel. Index by Year: 1996 \| 1995 \| 1994 \| 1993 \| 1992 \| 1991 Craig Mullins: Articles Published in 1994 Implementing DB2 in a Client/Server Environment. Mainframe Client/Server, December 1994. A short article that introduces some of the major differences between DB2 for MVS and the client/server member of the DB2 Family (DB2/2 and DB2/6000). Useful for anyone with DB2 for MVS experience who is investigating the potential of DB2 for OS/2 and/or AIX. New Catalog Statistics in DB2 Version 3. DB2 Update, December 1994. IBM added many new statistical tables and columns to the DB2 Catalog for Version 3. This article details the contents of these new statistics. Useful for DBAs, performance analysts, and systems programmers. What is a Stored Procedure? Enterprise Systems Journal, December 1994 This article provides a comprehensive introduction to database stored procedures. It defines what a stored procedure is, discusses the manner in which stored procedures are executed, provides sample code, and discusses the impact of stored procedures on application design. Useful for DBAs and programmer/analysts. An Introduction to the Architecture of SYBASE SQL Server. PLATINUM Edge, Winter 1994 A short analysis of the architecture and composition of SYBASE SQL Server. First in a four part series. Useful for all SYBASE and RDBMS users. DB2 V3 Bufferpool Tuning Options: A Trip to Tune Town. Relational Database Journal, November-December 1994. This article discusses the DB2 V3 tuning options for buffer pools and hiperpools, including several recommendations for buffer optimization. Useful for DBAs, performance analysts, and technical support personnel. Getting Integrity in SYBASE SQL Server. DBMS Magazine, November 1994. SYBASE SQL Server System 10 contains many useful features for ensuring the integrity of the data it houses. This articles discusses each of the techniques provided by SYBASE to ensure data integrity. Useful for SYBASE DBAs, database designer, and system developers. Views on Views. DB2 Update, October 1994. This article contains a concise set of rules defining and describing when, and when not, to use DB2 views. It discusses the limitations of conventional view usage and warns against using one view per base table in a DB2 application. Useful for DBAs, DAs, systems analysts, and programmer/analysts. Client/Server Development Considerations. Data Management Review, September 1994. This article discusses client/server development from an architectural and personnel perspective. It discusses the infrastructure deficiencies that abound in client/server implementation and what can be done to overcome them. Useful for anyone participating in a client/server development effort. What's in a Name? DB2 Update, September 1994. A critical look at traditional database object naming standards. This article takes a fresh look at how to name database objects and challenges some of the "tried and true" notions. Useful for all DB2 DBAs and database designers. Pursuing Procedural SQL. PLATINUM Edge, Fall 1994. The modification of SQL dialects to enable procedural processing is becoming more and more popular. SYBASE and ORACLE both provide looping and branching features that enable procedural logic to be coded using only SQL. This article discusses the pros and cons of such an implementation. Useful for anyone using SQL and RDBMS technology. What is a Trigger? Enterprise Systems Journal, August 1994. This article provides a comprehensive introduction to database triggers. It defines what a trigger is, discusses trigger types and methods of execution, provides sample code, and discusses the impact of triggers on application design. Useful for DBAs and programmer/analysts. DB2-IBM's Answer to Client/Server. Data Management Review, June 1994. Provides a closer look at the similarities and differences between IBM's DB2 for MVS and its workstation cousins, DB2/2 and DB2/6000. Useful for DBAs, programmer/analysts, database designers, and anyone who needs to work on multiple DB2 platforms. QMF Performance Tuning (Parts 1, 2, & 3). DB2 Update, Jun-Jul-Aug 1994. Three part article discussing tuning issues for users of QMF. Discusses basic QMF environment, DB2, and SQL tuning issues. Useful for DBAs, programmer/analysts, and technical support personnel. DB2 for MVS: Triggers & Stored Procedures. PLATINUM Edge, Summer 1994. A short synopsis of the features of DB2 V3 that approximate trigger and stored procedure functionality. Any user of DB2 would find this information interesting. The Future of DB2. DB2 Update, May 1994. This is basically an updated reprint of the article The Databases of Our Lives, which appeared in the April 1993 issue of PLATINUM SYSJOURNAL. It is a discussion of DB2 trends and directions. Probably DBAs and tech support personnel will find this article most interesting, but P/As might also find it useful. Dismissing Dynamic Dangers. Database Programming & Design, May 1994. This article tries to diminish the negative image of dynamic SQL. It discusses why and when to use dynamic SQL from performance, mathematical, and practicality viewpoints. Useful for DBAs, programmer/analysts and application developers/designers. The Wrapping: Package Implementation Considerations (Parts 1, 2, & 3). Relational Database Journal, May-Jun / Jul-Aug / Sept-Oct '94. A comprehensive three-part article covering the organizational, structural, and conversion aspects of implementing DB2 packages. Not another article on "What is a package," this 8000+ word, three-part article covers "how to use packages!" Useful for DBAs, Technical Support, programmer/analysts, and anyone who develops DB2 applications and/or databases. The Great Debate. Byte, April 1994. Discusses the differences between RDBMS and ODBMS in terms of dealing with the impedance mismatch problem. Two issues are examined: 1) set-level processing vs. record-level processing and; 2) type mismatch. Useful for DBAs, and anyone interesting in ODBMS and Object-Oriented Technology. DB2 Dataset Placement. DB2 Update, April 1994. Reprint from Summer 1993 SYSJOURNAL. Useful for beginning to intermediate DB2 shops. The Bufferpool: DB2 Tips, Thoughts, and Rumors (column). Relational Database Journal, Mar-Apr 1994. This is the third installment of a regular column discussing DB2 tips, tricks, and techniques. Useful for all DB2 users. Know Your Data. DB2 Update, March 1994. Discusses the importance of understanding the nature of the data in your DB2 tables. Provides techniques for exploiting this knowledge to enhance SQL performance. Useful for application developers, DBAs, and performance analysts. A Look at DB2 Version 3. DB2 Update, February 1994. Reprint of two part SYSJOURNAL article (Fall '93/Winter '93) on DB2 V3. Useful for DBAs, Technical Support, and anyone who designs DB2 databases. Index by Year: 1996 \| 1995 \| 1994 \| 1993 \| 1992 \| 1991
	Craig Mullins: Articles Published in 1993 DB2 Version 3: A Closer Look (Part 2). PLATINUM SYSJOURNAL, Winter '93. Second part of a multi-part series exploring the implementation considerations surrounding the new features of DB2 Version 3. This article discusses hiperpool support and Query I/O Parallelism. Useful for DBAs, Technical Support, and anyone who designs DB2 databases. The Object-Oriented Tutorial Series: Part IV. "Making Object Relational Successful" Data Management Review, December 1993. Delineates the components of OO technology that will need to be "merged" with relational technology to produce a new technology dubbed Object Relational. Useful for all technical audiences. (Last in the OO series) Preparing for DB2 Design Reviews. DB2 Update, December 1993. Outlines the seven design review phases that can be implemented over the course of a DB2 application development project. Each phase is documented detailing what needs to be accomplished at the review and who should attend it. Useful for all DB2 users. Denormalization Techniques for DB2 Tables. Relational Database Journal, November 1993 - January 1994. Discusses techniques for denormalizing DB2 tables for performance. Several reasons for denormalizing are presented after which techniques for accomplishing that type of denormalization are outlined. Also elaborates on administrative issues and re-analyzing denormalization decisions as systems change. Useful for all DB2 users. DB2 Version 3: A Closer Look (Part 1). PLATINUM SYSJOURNAL, Fall 1993. First part of a multi-part series exploring the implementation considerations surrounding the new features of DB2 Version 3. This article discusses data compression and extended buffer pool support. Useful for DBAs, Technical Support, and anyone who designs DB2 databases. A BASE for CASE. Data Management Review, September 1993. Opinion piece on the state of CASE in the early 1990's. Discusses CASE integration issues and human factors. Useful for all audiences. How DB2 2.3 Impacts EDM Pool Size. DB2 Update, September 1993. General purpose article on the impact of DB2 V2.3 on the size of the EDM Pool. Useful for intermediate to advanced DB2 users. Originally published in IDUG Globe, January 1993. Preparing for DB2 Version 3 Buffer pools. DB2 Today, August 1993. A very short synopsis of solutions for implementing a buffer pool strategy to exploit the 60 buffer pools available in DB2 Version 3. Intended audience is intermediate level DBAs and technical support. The Object-Oriented Tutorial Series: Part III: "Object vs. Relational" Data Management Review, August 1993. Provides a comparison of the benefits and drawbacks of ODBMS and RDBMS. Useful for all technical audiences. The Buffer Pool: DB2 Tips, Thoughts, and Rumors (column). Relational Database Journal, August - October 1993. This is the second installment of a regular column discussing DB2 tips, tricks, and techniques. Useful for all DB2 users. DB2 Tips & Techniques: DB2 Data Set Placement. PLATINUM SYSJOURNAL, Summer 1993. DBA-oriented article on DB2 data set placement. Covers system catalog, logs, table spaces, and indexes. Useful for beginning to intermediate DB2 shops. DB2 Organizational Issues: It's Here, But Now What? Data Management Review, July 1993. In-depth article on political and organizational issues that will be encountered as shops embrace DB2. Useful for DBAs, managers, technical support, and programmer/analysts. Targeted toward new DB2 shops. The Doors to DB2. (cover story) DB2 Today, May 1993. Discusses the teleprocessing monitor choices for DB2 application development. (i.e. CICS, IMS/DC, TSO, and CAF). Geared toward new and intermediate level DBAs, technical support, and programmer/analysts. The Object-Oriented Tutorial Series: Part II: "An Object Oriented Tutor" Data Management Review, May 1993. General discussion of object-oriented terminology. Useful for all audiences. How DB2 V2.3 Will Affect Your Standards. DB2 Update, May 1993. This article discusses DB2 standards development and maintenance and the impact of a new release of DB2 on shop standards. Useful for all DB2 users - beginning to advanced. The Buffer Pool: DB2 Tips, Thoughts, and Rumors (column). Relational Database Journal, May - July 1993. This is the first installment of a regular column discussing DB2 tips, tricks, and techniques. Sort of like Andy Rooney becomes a DBA! Useful for all DB2 users. The Databases of Our Lives. PLATINUM SYSJOURNAL, April 1993. Humorous discussion of DB2 trends and directions. Probably DBAs and tech support personnel will find this article most interesting, but P/As might also find it useful. The Object Oriented Tutorial Series: Part I: "To ODB or Not To ODB, That Is The Question" Data Management Review, February 1993. General discussion of object-oriented terminology. Useful for all audiences. A Critical Look at the DB2 Catalog (Parts I and II) Technical Support, January 1993 and February 1993. A technical article digging into the internals and structure of the DB2 Catalog. Mostly for intermediate to advanced DBAs and systems programmers. Many changes to the DB2 Catalog since V3 have caused much of this article to become outdated. Still, from an historical perspective, as well as from an academic design review and analysis perspective, this article may be of some interest. How DB2 V2.3 Impacts EDM Pool Size. IDUG Globe, January 1993. General purpose article on the impact of DB2 V2.3 on the size of the EDM Pool. Useful for intermediate to advanced DB2 users. Index by Year: 1996 \| 1995 \| 1994 \| 1993 \| 1992 \| 1991
	Craig Mullins: Articles Published in 1992 Technical Tips for Users of DB2 V2.3. PLATINUM SYSJOURNAL, September 1992. Basic tips and tricks for V2.3. Most of these tips are still useful as of DB2 V4. Geared mostly for DBAs and programmers. The Future of DB2 Security (Parts I and II). Data Management Review, July 1992 and August 1992. This is a "blue sky" type article containing my wish list for DB2 security features, some of which have been subsequently implemented by IBM. Written for all DB2 users. Index by Year: 1996 \| 1995 \| 1994 \| 1993 \| 1992 \| 1991
	Craig Mullins: Articles Published in 1991 and Earlier Dynamic SQL For DB2. Enterprise Systems Journal, December 1991. Contains in-depth discussion of each type of dynamic SQL supported by DB2. Oriented toward intermediate to advanced programmer/analyst types. Should also interest DBAs who have to support dynamic SQL applications. One View Per Base Table? Don't Do It! Database Programming & Design, February 1991. Designed to provoke thought, this has probably been my most commented-upon article. It provides reasons why DB2 shops should avoid using base table views. Useful for all levels of DB2 users - but probably most beneficial for new DB2 users (to help them avoid making a costly mistake). Mastering Disaster Recovery. Database Programming & Design, January 1991. This article discusses DB2 disaster recovery techniques and approaches as of DB2 V2.3. Many of the techniques are still applicable as of DB2 V4. Useful for all DB2 users - beginning to advanced. DBA Shoptalk: Dusting Off The Database. Database Programming & Design, August 1990. Outlines Mellon Bank's usage of DB2 circa 1990. There is probably not much general interest in this article at this late date, but it is an interesting period piece discussing the "data technology" division of a large commercial bank at the beginning of the 1990's. DB2 V2.2: A Few More Bells & Whistles. Database Programming & Design, June 1990. An overview of DB2 V2.2 features. Of limited historical interest only. Effective DB2 Object Monitoring Using The DB2 Catalog. Mainframe Journal, May 1990. Although this is an old article, it is still useful as of DB2 V4. Though some of the DB2 Catalog tables have changed (necessitating tweaking the SQL in the article), the approaches outlined are still useful. Geared toward beginning to intermediate DB2 users. Index by Year: 1996 \| 1995 \| 1994 \| 1993 \| 1992 \| 1991 © 2007, 1999 Craig S. Mullins, All rights reserved. Return to Home.

	Craig Mullins Published Articles *1997 and Prior*
<MAP NAME="boxmap-p8"><AREA SHAPE="RECT" COORDS="14, 200, 103, 207" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/mullinassoci-20" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/120x240.gif" width="120" height="240" border="0" usemap="#boxmap-p8" alt="Shop at Amazon.com"> <MAP NAME="boxmap-p8"><AREA SHAPE="RECT" COORDS="14, 200, 103, 207" HREF="http://rcm.amazon.com/e/cm/privacy-policy.html?o=1" ><AREA COORDS="0,0,10000,10000" HREF="http://www.amazon.com/exec/obidos/redirect-home/mullinassoci-20" ></MAP><img src="http://rcm-images.amazon.com/images/G/01/rcm/120x240.gif" width="120" height="240" border="0" usemap="#boxmap-p8" alt="Shop at Amazon.com">	Index by Year: 1996 \| 1995 \| 1994 \| 1993 \| 1992 \| 1991 Craig Mullins: Articles Published in 1997 Large Partitioned Table Spaces DB2 Update, November 1997. This article discusses the issues of table space partitioning in DB2. It provides tips, techniques, and guidelines for implementing partitioned table spaces, as well as in-depth coverage of the new large table space feature of DB2 V5. Useful for all DB2 users. DBMS Trends into the 21st Century IDUG Solutions Journal, November 1997. Database management systems are getting more and more complex as new features are added and new ways are found to utilize them. This article summarizes the major changes impacting DBMS products today and over the course of the next few years. Useful for all DBMS users. This article kicks off the new Face Off column for IDUG Solutions Journal. The Capability Maturity Model - From a Data Perspective. The Data Administration Newsletter, December 1997. The Capability Maturity Model (CMM), published by the Software Engineering Institute (SEI), is a well-established, defined model that characterizes the software development maturity of organizations based on their practices and procedures. However, it does not address the maturity of organizations with regard to the manner in which data is managed. This article introduces the reader to a data perspective of the Capability Maturity Model. Data Definition Guidelines. InformIT, October 1997. This article is an excerpt from my book, DB2 Developer's Guide. It covers the section on DDL guidelines and naming conventions for DB2 objects. The Oracle Environment. Oracle Update, October 1997. This article provides a concise introduction to the environment of the Oracle DBMS in terms of its architecture and components. Useful for all ORACLE and RDBMS users. Co-authored with Christopher T. Foot. DB2 Performance Planning and Engineering. IDUG Solutions Journal, August 1997. Most organizations monitor and tune DB2 performance in a reactive manner. This article discusses how to implement proactive performance engineering for applications before the application is implemented. Useful for DB2 performance analysts and DBAs. Co-authored with Richard Bolesta. Denormalization Guidelines. The Data Administration Newsletter, June 1997. Normalization is the process of putting one fact in one appropriate place. This optimizes updates at the expense of retrievals. This article itemizes several reasons why denormalization of data may be necessary and provides guidelines for successful implementation. Index by Year: 1996 \| 1995 \| 1994 \| 1993 \| 1992 \| 1991 Craig Mullins: Articles Published in 1996 Stored Procedure Guidelines for DB2. DB2 Magazine, Winter 1996. Both of the major implementations of DB2 (DB2 for MVS and DB2 for Common Servers) provide support for stored procedures. In this article, I discuss tips and tricks for implementing useful stored procedures, as well as guidelines for proper stored procedure administration. Most useful for programmers, analysts, and DBAs. Managing Systems in the Age of the Web. PLATINUM Edge, September 1996. As the web and Internet computing become pervasive, the way we manage information systems will need to adapt to include web technology. This article discusses the many ramifications of this oncoming change. Optimizing DB2 Outer Joins. DB2 Update, August 1996. Although coding outer joins in DB2 may appear to be straightforward, there are techniques that can be used to optimize their performance. This article discusses several ideas to aid outer join performance. Most useful for SQL developers and application programmers. Procedural SQL. Enterprise Systems Journal, July 1996. As SQL migrates from a query-only language to a procedural language, understanding the basics of procedural SQL will become an intrinsic component of the database professional's job. This article discusses the impact of procedural logic on SQL. Useful for anyone using SQL and RDBMS technology. Distributed Query Optimization. [Adobe Acrobat Format - PDF] Technical Support, July, 1996. Distributing data using RDBMS technology is quite popular, but few current products enable distributed joins — and those that do are not efficient. This article discusses the challenges of distributed querying and table joining. Security Enhancements in DB2 V4. DB2 Update, June 1996. Several useful security and authorization techniques were introduced to DB2 with Version 4. This article discusses these features and their impact on DB2. Most useful for DBAs and security analysts. Using Variable Character Data in DB2. DB2 Update, June 1996. Database designers frequently run into trouble when deciding whether or not to implement DB2 tables with variable character columns. This article briefly discusses the "pros and cons" of VARCHAR and provides some useful SQL statements to monitor the effectiveness of variable vs. fixed columns. Useful for database designer, performance analysts, and DBAs. Storing Procedural Logic in the Database. Sybase Technical Journal, Spring/Summer 1996. Sybase pioneered the concept of storing procedural logic within a database using stored procedures and triggers. Increasingly, organizations are adopting this technique within their client/server applications. This article offers guidelines and examples of how and when to effectively use and administer server code objects using Sybase SQL Server. Most useful for programmers, analysts, and DBAs. Tools for a Comprehensive DB2 Environment. IDUG Solutions Journal, Issue 2, 1996. Although DB2 for MVS, as offered by IBM, is a complete, full-function RDBMS, users quickly realize that the functionality to adequately support large-scale database development is not provided by DB2 alone. This article examines the burgeoning DB2 add-on product market identifying key product categories and their benefits. Useful for all DB2 users. Industry Trends Impacting Database Administration. Computing News and Review, May 1996. As the IS organization evolves from one of centralized control to an open, heterogeneous environment, the role of database administration necessarily expands. This brief article provides an overview of the DBMS industry. The article highlights pervasive trends (data warehousing, data mining, OO, the Internet) and discusses how these trends impact database administration. Useful for all database professionals. DB2 Version 4 Catalog Revisions. DB2 Update, April 1996. With each new release of DB2, IBM modifies and tunes the system catalog and directory structures. This is done for many reasons including the addition of new features and to make old features more efficient. This article provides an overview of the changes and additions made to the DB2 catalog to support Version 4. Most useful for performance analysts and DBAs. Dealing with Data Outhouses. DM Review, March 1996. Although data warehouses are currently all the rage, few professionals consider the problems that "dirty data" can cause for a warehousing project. DB2 Version 4 Security and Authorization Enhancements. PLATINUM Edge, March 1996. A synopsis of the enhanced security functionality provided by DB2 Version 4. Includes a discussion of plan level authorization for dynamic SQL programs. Useful for all users of DB2. DB2 Version 4 Dirty Read Capability. DB2 Update, February 1996. The ability to read data without taking locks is a common requirement of RDBMS products. Until Version 4, DB2 did not provide this feature. This article discusses the capabilities and ramifications of using dirty reads in DB2 programs and SQL statements. Useful for application designers and programmers, performance analysts, and DBAs. DB2 Version 4 Check Constraints. DB2 Update, January 1996. DB2 Version 4 provides the ability to code limitations on the values that can be stored in DB2 table columns. This is accomplished through the use of check constraints. This article outlines the capabilities of check constraints and gives advice on their proper usage. Most useful database designers and DBAs, but of general interest for most DB2 users. Reorganizing the System Catalog in DB2 Version 4. IDUG Solutions Journal, Winter 1996. Of the many new features added to DB2 Version 4 one of the most eagerly awaited by DBAs is the ability to REORG the DB2 Catalog and DB2 Directory in a systematic manner. This article discusses the steps to take to utilize the new V4 features to accomplish catalog reorganization. Useful for DB2 database administrators and systems programmers. Index by Year: 1996 \| 1995 \| 1994 \| 1993 \| 1992 \| 1991 Craig Mullins: Articles Published in 1995 Gathering DB2 Information in Cyberspace. Enterprise Systems Journal, December 1995. Finding information using on-line services can be a daunting task for the "newbie." This article focuses specifically on sources of DB2 information available on-line through the Internet, CompuServe, and other on-line services. Useful for all DB2 users. The Procedural DBA. Database Programming & Design, December 1995. More and more DBMS vendors are providing methods of including application code into the DBMS (in addition to the data). A proper methodology for handling these server code objects (triggers, stored procedures, check constraints, etc.) must be observed in order to effectively administer this change. This article discusses these new code-based objects and suggests a useful re-definition of the role of a DBA in this changing environment. Useful for all RDBMS users. DB2 V4 Outer Join Basics. DB2 Update, October 1995. Coding a DB2 SQL outer join used to be difficult and complex. However, DB2 Version 4 provides in-depth support for outer joins. This article discusses these features. Useful for all DB2 users. Referential Integrity in SYBASE SQL Server 10. Relational Database Journal, Sept-Oct 1995. Details the manner in which SYBASE supports referential integrity (RI). Covers declarative RI and trigger-supported RI. Useful for all SYBASE users. An Introduction to the Architecture of DB2 for OS/2. PLATINUM Edge, September 1995. An in-depth analysis of the architecture and composition of Version 2 of DB2 for OS/2. Fourth in a four part series. Useful for all users of DB2 for OS/2. Reprinted in the March 1996 edition of DB2 Update. DB2 V4 In-Line Views. DB2 Update September 1995. The ability to specify a SELECT statement in place of a table name in the FROM clause of a SQL statement is a major benefit provided by DB2 Version 4. This article discusses how to code these in-line views. Useful for all DB2 users. Distributed Query Optimization. IDUG Solutions Journal, July-Sept. 1995. Distributing data using RDBMS technology is quite popular, but few current products enable distributed joins-and those that do are not efficient. This article discusses the challenges of distributed querying and table joining. An Introduction to the Architecture of ORACLE. PLATINUM Edge, Summer 1995. An in-depth analysis of the architecture and composition of ORACLE7. Third in a four part series. Useful for all ORACLE and RDBMS users. Co-authored with Christopher T. Foot. Producing Quality Software. Systems Development Management, May 1995. Quality has become a buzzword, but it also has become necessary for survival in today's business environment. Software development managers must satisfy customers with quality systems. This article explores how to manage technology, techniques, and personnel to produce quality systems that meet clients' demands. This article was also published as a chapter in the Auerbach reference book entitled Handbook of Application Development, co-authored with Bernard S. Klopfer. 3rd edition published 4th quarter 1995. Stored Procedures in DB2 Version 4. IDUG Solutions Journal, April 1995. Although stored procedures are old features for many of the client/server RDBMS products, they are new to DB2 as of Version 4. This article details the manner in which stored procedures are implemented in DB2. Useful for all users of DB2. Reprinted in the June 1996 issue of Enterprise Client/Server. An Introduction to the Architecture of DB2. PLATINUM Edge, Spring 1995. A short analysis of the architecture and composition of DB2. Second in a four part series. Useful for all DB2 and RDBMS users. DB2 SQL Analysis Tools. DB2 Update, February 1995. The development of SQL to access DB2 tables is typically the responsibility of an application development team. However, because of the flexibility of SQL, the same request can be made in different ways, each yielding the same results but quite different performance. This article discusses how to ensure optimal SQL and the benefits of an automated tool to examine application SQL statements. Useful for DBAs, systems analysts, and programmer/analysts. Optimizing Client/Server Performance. Data Management Review, January 1995. Client/server applications are gaining wide acceptance and quite a lot of press, but there have been very few discussions of the performance implications of client/server processing. This article discusses those implications and provides some tuning advice. Useful for systems analysts, application developers, and programmers. Lock Avoidance in DB2 Version 3. DB2 Update, January 1995. Lock avoidance is a new feature of DB2 Version 3 that, in certain circumstances, enables the DBMS to bypass locking and maintain integrity. This article discusses the features that enable DB2 V3 to provide lock avoidance. Useful for DBAs, performance analysts, systems programmers, and Technical Support personnel. Data Set Closing From Deferred to Pseudo. Relational Database Journal, Jan-Feb 1995. DB2 Version 3 once again changed the manner in which the underlying physical data sets used by the RDBMS are opened and closed for usage. This article provides a short introduction to the past and present functionality of DB2 data set management. Useful for DBAs, performance analysts, systems programmers, and Technical Support personnel. Index by Year: 1996 \| 1995 \| 1994 \| 1993 \| 1992 \| 1991 Craig Mullins: Articles Published in 1994 Implementing DB2 in a Client/Server Environment. Mainframe Client/Server, December 1994. A short article that introduces some of the major differences between DB2 for MVS and the client/server member of the DB2 Family (DB2/2 and DB2/6000). Useful for anyone with DB2 for MVS experience who is investigating the potential of DB2 for OS/2 and/or AIX. New Catalog Statistics in DB2 Version 3. DB2 Update, December 1994. IBM added many new statistical tables and columns to the DB2 Catalog for Version 3. This article details the contents of these new statistics. Useful for DBAs, performance analysts, and systems programmers. What is a Stored Procedure? Enterprise Systems Journal, December 1994 This article provides a comprehensive introduction to database stored procedures. It defines what a stored procedure is, discusses the manner in which stored procedures are executed, provides sample code, and discusses the impact of stored procedures on application design. Useful for DBAs and programmer/analysts. An Introduction to the Architecture of SYBASE SQL Server. PLATINUM Edge, Winter 1994 A short analysis of the architecture and composition of SYBASE SQL Server. First in a four part series. Useful for all SYBASE and RDBMS users. DB2 V3 Bufferpool Tuning Options: A Trip to Tune Town. Relational Database Journal, November-December 1994. This article discusses the DB2 V3 tuning options for buffer pools and hiperpools, including several recommendations for buffer optimization. Useful for DBAs, performance analysts, and technical support personnel. Getting Integrity in SYBASE SQL Server. DBMS Magazine, November 1994. SYBASE SQL Server System 10 contains many useful features for ensuring the integrity of the data it houses. This articles discusses each of the techniques provided by SYBASE to ensure data integrity. Useful for SYBASE DBAs, database designer, and system developers. Views on Views. DB2 Update, October 1994. This article contains a concise set of rules defining and describing when, and when not, to use DB2 views. It discusses the limitations of conventional view usage and warns against using one view per base table in a DB2 application. Useful for DBAs, DAs, systems analysts, and programmer/analysts. Client/Server Development Considerations. Data Management Review, September 1994. This article discusses client/server development from an architectural and personnel perspective. It discusses the infrastructure deficiencies that abound in client/server implementation and what can be done to overcome them. Useful for anyone participating in a client/server development effort. What's in a Name? DB2 Update, September 1994. A critical look at traditional database object naming standards. This article takes a fresh look at how to name database objects and challenges some of the "tried and true" notions. Useful for all DB2 DBAs and database designers. Pursuing Procedural SQL. PLATINUM Edge, Fall 1994. The modification of SQL dialects to enable procedural processing is becoming more and more popular. SYBASE and ORACLE both provide looping and branching features that enable procedural logic to be coded using only SQL. This article discusses the pros and cons of such an implementation. Useful for anyone using SQL and RDBMS technology. What is a Trigger? Enterprise Systems Journal, August 1994. This article provides a comprehensive introduction to database triggers. It defines what a trigger is, discusses trigger types and methods of execution, provides sample code, and discusses the impact of triggers on application design. Useful for DBAs and programmer/analysts. DB2-IBM's Answer to Client/Server. Data Management Review, June 1994. Provides a closer look at the similarities and differences between IBM's DB2 for MVS and its workstation cousins, DB2/2 and DB2/6000. Useful for DBAs, programmer/analysts, database designers, and anyone who needs to work on multiple DB2 platforms. QMF Performance Tuning (Parts 1, 2, & 3). DB2 Update, Jun-Jul-Aug 1994. Three part article discussing tuning issues for users of QMF. Discusses basic QMF environment, DB2, and SQL tuning issues. Useful for DBAs, programmer/analysts, and technical support personnel. DB2 for MVS: Triggers & Stored Procedures. PLATINUM Edge, Summer 1994. A short synopsis of the features of DB2 V3 that approximate trigger and stored procedure functionality. Any user of DB2 would find this information interesting. The Future of DB2. DB2 Update, May 1994. This is basically an updated reprint of the article The Databases of Our Lives, which appeared in the April 1993 issue of PLATINUM SYSJOURNAL. It is a discussion of DB2 trends and directions. Probably DBAs and tech support personnel will find this article most interesting, but P/As might also find it useful. Dismissing Dynamic Dangers. Database Programming & Design, May 1994. This article tries to diminish the negative image of dynamic SQL. It discusses why and when to use dynamic SQL from performance, mathematical, and practicality viewpoints. Useful for DBAs, programmer/analysts and application developers/designers. The Wrapping: Package Implementation Considerations (Parts 1, 2, & 3). Relational Database Journal, May-Jun / Jul-Aug / Sept-Oct '94. A comprehensive three-part article covering the organizational, structural, and conversion aspects of implementing DB2 packages. Not another article on "What is a package," this 8000+ word, three-part article covers "how to use packages!" Useful for DBAs, Technical Support, programmer/analysts, and anyone who develops DB2 applications and/or databases. The Great Debate. Byte, April 1994. Discusses the differences between RDBMS and ODBMS in terms of dealing with the impedance mismatch problem. Two issues are examined: 1) set-level processing vs. record-level processing and; 2) type mismatch. Useful for DBAs, and anyone interesting in ODBMS and Object-Oriented Technology. DB2 Dataset Placement. DB2 Update, April 1994. Reprint from Summer 1993 SYSJOURNAL. Useful for beginning to intermediate DB2 shops. The Bufferpool: DB2 Tips, Thoughts, and Rumors (column). Relational Database Journal, Mar-Apr 1994. This is the third installment of a regular column discussing DB2 tips, tricks, and techniques. Useful for all DB2 users. Know Your Data. DB2 Update, March 1994. Discusses the importance of understanding the nature of the data in your DB2 tables. Provides techniques for exploiting this knowledge to enhance SQL performance. Useful for application developers, DBAs, and performance analysts. A Look at DB2 Version 3. DB2 Update, February 1994. Reprint of two part SYSJOURNAL article (Fall '93/Winter '93) on DB2 V3. Useful for DBAs, Technical Support, and anyone who designs DB2 databases. Index by Year: 1996 \| 1995 \| 1994 \| 1993 \| 1992 \| 1991
	Craig Mullins: Articles Published in 1993 DB2 Version 3: A Closer Look (Part 2). PLATINUM SYSJOURNAL, Winter '93. Second part of a multi-part series exploring the implementation considerations surrounding the new features of DB2 Version 3. This article discusses hiperpool support and Query I/O Parallelism. Useful for DBAs, Technical Support, and anyone who designs DB2 databases. The Object-Oriented Tutorial Series: Part IV. "Making Object Relational Successful" Data Management Review, December 1993. Delineates the components of OO technology that will need to be "merged" with relational technology to produce a new technology dubbed Object Relational. Useful for all technical audiences. (Last in the OO series) Preparing for DB2 Design Reviews. DB2 Update, December 1993. Outlines the seven design review phases that can be implemented over the course of a DB2 application development project. Each phase is documented detailing what needs to be accomplished at the review and who should attend it. Useful for all DB2 users. Denormalization Techniques for DB2 Tables. Relational Database Journal, November 1993 - January 1994. Discusses techniques for denormalizing DB2 tables for performance. Several reasons for denormalizing are presented after which techniques for accomplishing that type of denormalization are outlined. Also elaborates on administrative issues and re-analyzing denormalization decisions as systems change. Useful for all DB2 users. DB2 Version 3: A Closer Look (Part 1). PLATINUM SYSJOURNAL, Fall 1993. First part of a multi-part series exploring the implementation considerations surrounding the new features of DB2 Version 3. This article discusses data compression and extended buffer pool support. Useful for DBAs, Technical Support, and anyone who designs DB2 databases. A BASE for CASE. Data Management Review, September 1993. Opinion piece on the state of CASE in the early 1990's. Discusses CASE integration issues and human factors. Useful for all audiences. How DB2 2.3 Impacts EDM Pool Size. DB2 Update, September 1993. General purpose article on the impact of DB2 V2.3 on the size of the EDM Pool. Useful for intermediate to advanced DB2 users. Originally published in IDUG Globe, January 1993. Preparing for DB2 Version 3 Buffer pools. DB2 Today, August 1993. A very short synopsis of solutions for implementing a buffer pool strategy to exploit the 60 buffer pools available in DB2 Version 3. Intended audience is intermediate level DBAs and technical support. The Object-Oriented Tutorial Series: Part III: "Object vs. Relational" Data Management Review, August 1993. Provides a comparison of the benefits and drawbacks of ODBMS and RDBMS. Useful for all technical audiences. The Buffer Pool: DB2 Tips, Thoughts, and Rumors (column). Relational Database Journal, August - October 1993. This is the second installment of a regular column discussing DB2 tips, tricks, and techniques. Useful for all DB2 users. DB2 Tips & Techniques: DB2 Data Set Placement. PLATINUM SYSJOURNAL, Summer 1993. DBA-oriented article on DB2 data set placement. Covers system catalog, logs, table spaces, and indexes. Useful for beginning to intermediate DB2 shops. DB2 Organizational Issues: It's Here, But Now What? Data Management Review, July 1993. In-depth article on political and organizational issues that will be encountered as shops embrace DB2. Useful for DBAs, managers, technical support, and programmer/analysts. Targeted toward new DB2 shops. The Doors to DB2. (cover story) DB2 Today, May 1993. Discusses the teleprocessing monitor choices for DB2 application development. (i.e. CICS, IMS/DC, TSO, and CAF). Geared toward new and intermediate level DBAs, technical support, and programmer/analysts. The Object-Oriented Tutorial Series: Part II: "An Object Oriented Tutor" Data Management Review, May 1993. General discussion of object-oriented terminology. Useful for all audiences. How DB2 V2.3 Will Affect Your Standards. DB2 Update, May 1993. This article discusses DB2 standards development and maintenance and the impact of a new release of DB2 on shop standards. Useful for all DB2 users - beginning to advanced. The Buffer Pool: DB2 Tips, Thoughts, and Rumors (column). Relational Database Journal, May - July 1993. This is the first installment of a regular column discussing DB2 tips, tricks, and techniques. Sort of like Andy Rooney becomes a DBA! Useful for all DB2 users. The Databases of Our Lives. PLATINUM SYSJOURNAL, April 1993. Humorous discussion of DB2 trends and directions. Probably DBAs and tech support personnel will find this article most interesting, but P/As might also find it useful. The Object Oriented Tutorial Series: Part I: "To ODB or Not To ODB, That Is The Question" Data Management Review, February 1993. General discussion of object-oriented terminology. Useful for all audiences. A Critical Look at the DB2 Catalog (Parts I and II) Technical Support, January 1993 and February 1993. A technical article digging into the internals and structure of the DB2 Catalog. Mostly for intermediate to advanced DBAs and systems programmers. Many changes to the DB2 Catalog since V3 have caused much of this article to become outdated. Still, from an historical perspective, as well as from an academic design review and analysis perspective, this article may be of some interest. How DB2 V2.3 Impacts EDM Pool Size. IDUG Globe, January 1993. General purpose article on the impact of DB2 V2.3 on the size of the EDM Pool. Useful for intermediate to advanced DB2 users. Index by Year: 1996 \| 1995 \| 1994 \| 1993 \| 1992 \| 1991
	Craig Mullins: Articles Published in 1992 Technical Tips for Users of DB2 V2.3. PLATINUM SYSJOURNAL, September 1992. Basic tips and tricks for V2.3. Most of these tips are still useful as of DB2 V4. Geared mostly for DBAs and programmers. The Future of DB2 Security (Parts I and II). Data Management Review, July 1992 and August 1992. This is a "blue sky" type article containing my wish list for DB2 security features, some of which have been subsequently implemented by IBM. Written for all DB2 users. Index by Year: 1996 \| 1995 \| 1994 \| 1993 \| 1992 \| 1991
	Craig Mullins: Articles Published in 1991 and Earlier Dynamic SQL For DB2. Enterprise Systems Journal, December 1991. Contains in-depth discussion of each type of dynamic SQL supported by DB2. Oriented toward intermediate to advanced programmer/analyst types. Should also interest DBAs who have to support dynamic SQL applications. One View Per Base Table? Don't Do It! Database Programming & Design, February 1991. Designed to provoke thought, this has probably been my most commented-upon article. It provides reasons why DB2 shops should avoid using base table views. Useful for all levels of DB2 users - but probably most beneficial for new DB2 users (to help them avoid making a costly mistake). Mastering Disaster Recovery. Database Programming & Design, January 1991. This article discusses DB2 disaster recovery techniques and approaches as of DB2 V2.3. Many of the techniques are still applicable as of DB2 V4. Useful for all DB2 users - beginning to advanced. DBA Shoptalk: Dusting Off The Database. Database Programming & Design, August 1990. Outlines Mellon Bank's usage of DB2 circa 1990. There is probably not much general interest in this article at this late date, but it is an interesting period piece discussing the "data technology" division of a large commercial bank at the beginning of the 1990's. DB2 V2.2: A Few More Bells & Whistles. Database Programming & Design, June 1990. An overview of DB2 V2.2 features. Of limited historical interest only. Effective DB2 Object Monitoring Using The DB2 Catalog. Mainframe Journal, May 1990. Although this is an old article, it is still useful as of DB2 V4. Though some of the DB2 Catalog tables have changed (necessitating tweaking the SQL in the article), the approaches outlined are still useful. Geared toward beginning to intermediate DB2 users. Index by Year: 1996 \| 1995 \| 1994 \| 1993 \| 1992 \| 1991 © 2007, 1999 Craig S. Mullins, All rights reserved. Return to Home.