© 2021 Mullins Consulting, Inc. All Rights Reserved Privacy Policy Contact Us
Get Your Business Where it Needs to Go.
DB2 Magazine, OnDemand supplement, Quarter 4, 2003 Vol. 8, Issue 4
The right information infrastructure can support a company all the way to the top or hinder its rise. IBM’s offerings combine rock-
Business Eye for the DBA Guy: The DBA Corner.
Database Trends and Applications, December 2003.
Although most DBAs are easily engrossed by technology, knowledge of the business purposes served by technology is increasingly important. This installment of The DBA Corner column helps to explain why.
Why Data Still Matters. (link no longer active)
dbazine.com, December 2003.
Many technologies and marketers throughout the years have claimed that data has become irrelevant and that some “new and improved” technology, technique, or ideology will replace data as the center of IT and data processing. But it has yet to happen, and it never will happen, either!
An Introduction to Database Design: From Logical to Physical. (link no longer active)
dbazine.com, November 2003.
A proper database design cannot be thrown together quickly by novices. What is required is a practiced and formal approach to gathering data requirements and modeling data. This article provides a quick introduction to the concepts of logical modeling database design.
The Buffer Pool: Know Your Isolation Levels.
IDUG Solutions Journal, Vol. 10, No. 3
In this installment of The Buffer Pool column we examine the various options for setting the isolation level in DB2 programs and the implications of each.
Nuggets of Data Rambling Through my Mind: The DBA Corner.
Database Trends and Applications, November 2003.
The DBA Corner column is an exhaust pipe for the random database-
zData Perspectives: DB2 V8 Online Schema Evolution.
zJournal, October/November 2003.
Making changes to database structures can be tedious and error-
Measuring DBA Effectiveness. (link no longer active)
dbazine.com, October 2003.
Measuring the performance of IT professionals can be a difficult proposition. It can be particularly thorny when trying to measure the effectiveness of DBAs.
Round-
Database Trends and Applications, October 2003.
Business requirements are increasingly demanding downtime be diminished. This causes DBAs to scramble to address these needs. This piece looks at the increasing desire for 24x7 availability and the problems it can cause.
The Database Report: 3Q2003.
The Data Administration Newsletter, October 2003.
Another installation of regular column for TDAN covering the activities in the DBMS software marketplace. This edition focuses on Oracle's hostile acquisition bid for PeopleSoft, the announcement of Oracle 10g, as well as a look at news from IBM, Microsoft, and Sybase.
Q&A: Tips for Making Data Warehouses Manageable.
searchdatabase.com, September 19, 2003.
In this interview conducted by TechTarget, Craig discusses current issues in data warehouse administration and management.
Required Reading from the DBA's Bookshelf: The DBA Corner.
Database Trends and Applications, September 2003.
To be a successful DBA you will need to keep up-
An Overview of DB2 for z/OS Version 8. (link no longer active)
dbazine.com, August 2003.
Although V8 has been out for several months now on Linux, Unix, and Windows platforms, it was just recently announced in January 2003 for mainframe platforms. There is a reason for this — DB2 for z/OS Version 8 is a huge and complex beast. This article will provide you with an overview of the major features and functions of DB2 for z/OS V8.
zData Perspectives: DB2 V7 B4 V8.
zJournal, August/September 2003.
There has been a lot of excitement lately about the next version of DB2, V8, but in this installment of zData Perspectives column we examine several DB2 V7 features that can be implemented today, before V8 arrives.
The Buffer Pool: Choose the Proper Data Type.
IDUG Solutions Journal, Vol. 10, No. 2
In this third installment of my regular column that looks into misunderstood DB2 functionality we discuss the issue of using proper DB2 data types.
How to Curb the Curmudgeon in the Corner: The DBA Corner.
Database Trends and Applications, August 2003.
DBAs are frequently thought of as crusty curmudgeons with vast technical knowledge, but limited people skills. This month's column examines this phenomenon and offers guidance on how best to handle a curmudgeonly DBA.
The Database Report: 2Q2003.
The Data Administration Newsletter, July 2003.
Another installation of regular column for TDAN covering the activities in the DBMS software marketplace. This edition focuses on Oracle's hostile acquisition bid for PeopleSoft, Yukon delays, revised market share numbers, as well as our regular look at database software revenue figures for the major players.
Development and Production DBA Skills: The DBA Corner.
Database Trends and Applications, July 2003.
DBAs need different skills when operating in a development versus production capacity. Both, though, are critical for successful database processing. This month's column examines and compares the different disciplines required for each type of DBA.
No Black Boxes.
DB2 Update, July 2003.
This article focuses on debunking the practice of creating "black box" access routines that sit between application programs and DB2. Such configurations remove the requirement for programmers to know how to code SQL-
zData Perspectives: DB2 and the Old Dipsy Doo.
zJournal, June/July 2003.
The third installment of the bi-
Denormalization of DB2 Tables. (link no longer active)
searchdatabase.com, June 2003.
A short introduction to the various denormalization options available when designing physical DB2 databases.
A DBMS Architecture by Any Other Name Is Still Confusing: The DBA Corner.
Database Trends and Applications, June 2003.
As the DBMS vendors slice and dice their packaging into more and confusing editions and models life gets more confusing for DBAs. This month's column examines the many different DBMS packaging and architectural options for DB2 as an example of how confusing things have become.
Large Objects and DB2. (link no longer active)
dbazine.com, May 2003.
This article looks at mainframe DB2's ability to enable the storage and management of complex data types using large objects (LOBs).
What is a DBA? -
dbazine.com, May 2003.
The sixth and final installment in this series discusses newer technologies that rely on database administration — at least somewhat — to be effectively implemented: database-
Basic DB2 Buffering and Memory Guidelines.
searchDataCenter.com, May 2003.
One of the most important areas for tuning DB2 subsystem performance is memory usage. This tip offers some basic guidance for setting up and tuning DB2 memory usage.
The Buffer Pool: Dynamic Buffer Changes.
IDUG Solutions Journal, Vol. 10, No. 1
This column further investigated commonly misunderstood DB2 functionality – concentrating on dynamic buffer changes and parallel access and partitioning.
Follow the DBA Rules of Thumb for an Easier Life: The DBA Corner.
Database Trends and Applications, May 2003.
This month we discuss some basic rules of thumb for DBAs to follow to make their jobs — and lives — easier.
zData Perspectives: DB2—Versions, Service and Such.
zJournal, April/May 2003.
Keeping up-
DB2 Utilities Through the Looking Glass. (link no longer active)
dbazine.com, April 2003.
To pay for IBM's DB2 utility functionality or buy third-
SQL Server Transaction Log Guidelines. (link no longer active)
dbazine.com, April 2003.
The transaction log is a fundamental component of Microsoft SQL Server. All changes to data in the database are recorded in the transaction log. This article provides a basic introduction to the way in which SQL Server implements and uses transaction logs.
Complexity Complicates Database Upgrades & Migrations: The DBA Corner.
Database Trends and Applications, April 2003.
This month we continue our focus on the increasing complexity of DBMS software with particular attention paid to the task of DBMS upgrades and migrations.
What is a DBA? -
dbazine.com, April 2003.
The fifth installment in this series discusses how to handle the difficulty of managing multiple DBMSs in a multiplatform environment -
The Database Report: 1Q2003.
The Data Administration Newsletter, April 2003.
Another installation of regular column for TDAN covering the activities in the DBMS software marketplace. This edition focuses on Oracle's revenues, V8 of mainframe DB2, and the Microsoft SQL Server Slammer worm.
DBAs! You Should Fear XML!
The Data Administration Newsletter, April 2003.
A lot has been written about XML in the few years. It is one of the most hyped, and least exciting new technologies in years. XML ain’t all that groundbreaking and it is dangerous to the health of your databases!
DB2 Table Space Options, Part 2. (link no longer active)
Mainframe Week, April 2, 2003.
Second part of article discussing DB2 for OS/390 table spaces.
DB2 Table Space Options, Part 1. (link no longer active)
Mainframe Week, March 26, 2003.
When designing DB2 databases, DBAs can choose from three types of table spaces, each one useful in different circumstances. This article examines each table space type and your options for deploying DB2 table spaces. First of two parts.
Understanding DB2 Messages. (link no longer active)
dbazine.com, March 2003.
What does that message mean? Is there more information than the terse pseudo-
What is a DBA? -
dbazine.com, March 2003.
The fourth installment in this series discusses the different types of DBAs -
Dealing with DBMS Complexity: The DBA Corner.
Database Trends and Applications, March 2003.
This installment of The DBA Corner focuses on the rising complexity of Database Management Systems and how that impacts DBAs.
zData Perspectives: An Introduction to DB2 for z/OS V8.
zJournal, February 2003.
This article provides a very quick introduction to the feature functionality highlights of the next version of DB2 for z/OS -
Apps are Temporary, But Data is Forever.
Data Discussions, February 2003.
An interview of Craig S. Mullins, conducted by Tony Shaw, which focuses on the changing role of DBAs, problems in database application development, solutions for the data explosion and the future of DBMS technology.
What is a DBA? -
dbazine.com, February 2003.
The third installment in this series offers a quick overview of common DBA tasks.
DBAs Do Storage Management: The DBA Corner.
Database Trends and Applications, February 2003.
This installment of The DBA Corner focuses on how DBAs need to understand storage technology and sometimes take on the role of Storage Administrator in addition to Database Administrator.
Eight Breakthroughs That Changed DB2 Forever. (link no longer active)
DB2 Magazine, Quarter 1, 2003.
As DB2 celebrates its 20th anniversary, I look back over its history and discuss the features and functions that helped DB2 become the world-
Tuning DB2 Access Paths.
DB2 Developer Domain, January 2003.
Poorly coded SQL and application code can cause performance problems. This article explains the basics of access paths and join methods, and then shows you how tools such as Explain to monitor and tune your SQL performance. It is intended to give an overview of DB2 access paths and SQL tuning, particularly for, but not limited to, those who are using Borland Kylix and Delphi RAD tools.
An Introduction to DB2 Table Spaces. (link no longer active)
dbazine.com, January 2003.
This article takes a look at the three different types of DB2 table spaces: simple, segmented, and partitioned. It covers the pros and cons of using each type. Guidance is given as to the circumstances when it is advisable to use each type.
What is a DBA? -
dbazine.com, January 2003.
The second installment in this series examining the roles and responsibilities of the database administrator discusses the roles of the DA, DBA, and SA including how they overlap, how they differ, and how they complement each other.
Charting the Evolution from DBA to e-
Database Trends and Applications, January 2003.
This installment of The DBA Corner focuses on the changes in roles and responsibilities of the DBA as applications become Internet-
The Database Report: 4Q2002.
The Data Administration Newsletter, January 2003.
Another installation of regular column for TDAN covering the activities in the DBMS software marketplace. This edition focuses primarily on Oracle and Microsoft.
A DB2 for z/OS Performance Road Map.
DB2 Update, January 2003.
A database application, at its core, requires three components in order to operate: the system, the database and the application. To deliver performance, the DBA must be able to monitor and tune each of these components. This article provides a performance road map to mainframe DB2 based on these three components.
The Buffer Pool: Using Nulls in DB2.
IDUG Solutions Journal, December 2004.
This installment of The Buffer Pool discusses the thorny topic of nulls.
What is Knowledge and Can it be Managed?
Database Trends and Applications, December 2004.
A look at the controversial and confusing term "knowledge management."
High Speed Transaction Recovery.
Technical Support, November 2004
As the demand for 24x7 processing increases, DBAs are looking for ways to perform database maintenance tasks with minimal or not outages. This article discusses high availability database recovery techniques to meet this demand head on.
Ensuring Data Integrity is a Tricky Business.
Database Trends and Applications, November 2004.
The term "data integrity" can mean many different things. This installation of the DBA Corner column seeks to clarify these different meanings.
Facilitating Efficient Database Management.
Certification Magazine, November 2004.
This article provides an overview of the various types of tools and solutions available to improve database administration and management tasks.
The Top Ten Features of DB2 for z/OS V8.
zJournal, October/November 2004.
This installment of the z/Data Perspectives column looks at the top ten new features of DB2 Version 8. Of course, this is just my opinion, but I think I can back it up! Check it out.
Three Trusty Rules for DB2 Triggers.
DB2portal.com, October 2004.
This short piece summarizes a response to a question on when to use triggers into three basic rules.
Achieving the Five Nines of Database Availability.
Database Trends and Applications, October 2004.
How much availability is enough? As we push to provide continuous uptime we need to pause to define what is reasonable — and perhaps more importantly, what is achievable.
The Database Report: 3Q2004.
The Data Administration Newsletter, October 2004.
Check in with "The Database Report" to read the latest news regarding database management systems and the most popular DBMS vendors.
A View Review. (link is no longer active)
dbazine.com, October 2004.
One of the most fertile grounds for disagreement between DB2 professionals is the appropriate usage of views. But when views are properly implemented and managed, they can be useful tools. This article explores the many aspects and uses of views that make them essential for DB2 development.
Using Dynamic SQL for Maximum Flexibility.
DB2 Update, October 2004.
This article discusses the benefits of dynamic SQL along with coverage of each of the different types of dynamic SQL that can be used with DB2 for z/OS.
An Irregular Sorting Requirement. (link is no longer active)
dbazine.com, September 2004.
This article takes a look at a novel way of solving non-
Programmers Use Excuses, Too.
Database Trends and Applications, September 2004.
Last month we reviewed DBA excuses, but programmers are notorious for making excuses too. This month we examine the excuses programmers make as they work with relational database systems.
What is Large?
zJournal, August/September 2004.
What do people really mean when they talk about large databases? The term is nebulous and ever changing. This article examines just what is meant by the term large database today.
The Buffer Pool: The Hitchhiker's Guide to DB2.
IDUG Solutions Journal, August 2004.
DB2 is complex and can be intimidating to learn and master. There are a lot of details that need to be understood and difficulties can arise for any number of reasons. This article offers a short guide for DB2 developers showing how to find information and clear up some confusing issues.
Taming DB2 Performance Issues.
Database Trends and Applications, August 2004.
This article offers a high-
Reviewing the Top DBA Excuses and How to Overcome Them.
Database Trends and Applications, August 2004.
The number one all-
The Database Report: 2Q2004.
The Data Administration Newsletter, July 2004.
In this regular TDAN column you can read all about the latest news and issues going on in the world of database management systems. This installment is highlighted by latest on Oracle's attempt to acquire Peoplesoft, news from the analysts on DBMS market share, and technical and financial news on IBM and Oracle.
How Secure Are Your Databases?
Database Trends and Applications, July 2004.
Security is on everyone’s mind these days as we are constantly bombarded with images on the daily news that underscore just how important security is. But have you really thought about how secure your corporate databases are? This installment of The DBA Corner examines the many aspects of securing corporate databases.
IMS is Alive and Kicking.
zJournal, June/July 2004.
While hierarchical database systems have been surpassed in the marketplace by relational and SQL products like DB2, IMS can brag about its long and proud legacy that continues on today. This installment of my zData Perspectives column examines the current state and health of IBM's IMS.
DB2 Behind the Scenes.
dbazine.com, June 2004.
Ever wondered what is actually going on behind the scenes in DB2? When you create a table, how does DB2 create and store it? When you issue an SQL statement, what happens to it so that it returns your answer? Where are these application plans kept? What is going on “under the covers”? This article examines the answers to questions like these.
So You Want to Become a DBA?
Database Trends and Applications, June 2004.
One of the most common questions I am asked is “How can I become a DBA?” The question is actually not as simple as it seems and there are many different aspects to the question. But this article answers the question for most IT folks.
Using Real Time Statistics (RTS).
DB2 Update, June 2004.
This article discusses the Real Time Stats (RTS) feature of DB2 for z/OS including definitions of the RTS columns and suggested queries to use for DB2 performance management and administration.
DB2 Advice Your Daddy Didn't Give You. (link is no longer active)
search390.com, June 2004.
A collection of DB2 questions and answers from my gig as a contributor to the search390 ATE section.
The Buffer Pool: Recursion in DB2 V8, V8, V8...
IDUG Solutions Journal, Vol. 11, No. 1
In this installment of The Buffer Pool column we examine the recursive SQL capabilities of DB2 for z/OS Version 8. Recursion is demonstrated by means of a simple hierarchy and the SQL needed to walk the hierarchy.
Why Outsourcing the DBA is Not an Option.
Database Trends and Applications, May 2004.
Ever thought about outsourcing your DBA group? This article gives you several reasons why this might not be the best idea in the world.
Materialized Query Tables and the Death of Denormalization.
zJournal, April/May 2004.
Ever since the first relational DBMS products were introduced, DBAs have fought the battle of normalization versus denormalization. This installment of my zData Perspectives column examines MQTs and explains why denormalization may be on the brink of extinction.
Database Change Management & Schema Evolution in DB2 for z/OS Version 8. (link is no longer active)
dbazine.com, April 2004.
When building DB2 database applications, we create the database objects and then we build the application programs to access the DB2 data. When complete, everything is moved into production and we all live happily ever after, right? Well, eventually we will need to change the database to meet changing business needs. And then what? This article discusses the subject of database change management with particular emphasis given to online schema evolution.
The Engine of Intelligence. (link is no longer active)
Intelligent Enterprise, April 17, 2004.
This article examines the prospects of achieving optimal data warehouse performance in light of diminishing data latency.
The Database Report: 1Q2004.
The Data Administration Newsletter, April 2004.
In this regular TDAN column you can read up on the latest about the attempted Peoplesoft acquisition by Oracle, an update on IBM's Stinger and Microsoft's Yukon, as well as various other database news of interest.
Make the Most of Your DBA Reporting Structure.
Database Trends and Applications, April 2004.
Different companies take different approaches to the DBA reporting structure, but a few reporting hierarchies are common. Although there is no one correct answer, some reporting structures work better than others... and this article examines why.
A Look at the Modes of DB2 V8.
zJournal, February/March 2003.
This installment of zData Perspectives examines the three operational modes of DB2 Version 8 and how they impact migration and functionality of your DB2 subsystems.
Will Vendors Automate the DBA Out of Business?
Database Trends and Applications, March 2004.
With all the talk of autonomic computing and self-
An Introduction to DB2 Indexing. (link is no longer active)
dbazine.com, February 2004.
Learn the basics of DB2 for z/OS indexing in this introductory article. Includes discussion of up-
DB2 or VSAM? (link is no longer active)
dbazine.com, February 2004.
This short article provides a synopsis of the advantage of DB2 over VSAM and other flat file approaches. It can be used to reinforce concepts you already know or to educate those who ask that age-
Database Applications Require Multiple Design Reviews.
Database Trends and Applications, February 2004.
All aspects of the database and application code must be reviewed for efficiency, effectiveness, and accuracy. If done correctly, design reviews are conducted at various times during the application lifecycle.
Sequence Objects and Identity Columns.
DB2 Update, February 2004.
This article discusses two methods available for generating sequential values for a DB2 column: identity columns (available as of V6) and sequence objects (available as of V8).
The Death of Denormalization?
Database Trends and Applications, January 2004.
Ever since the first relational DBMS products were introduced, DBAs have fought the battle of normalization versus denormalization. This installment of The DBA Corner column explains why denormalization is on the brink of extinction.
New Year's Resolutions for a DBA. (link is no longer active)
dbazine.com, January 2004.
Another new year is upon us and everyone is making New Year’s resolutions that they probably will not keep. In fact, by the time you get to read this, many of you will have already broken your New Year’s resolutions. That’s okay; if you’re a DBA, this article has some suggested resolutions for you!
The Database Report: 4Q2003.
The Data Administration Newsletter, January 2004.
This installment of my regular column for TDAN covers the news in the DBMS software marketplace. In this edition I focus mostly on Oracle, but cover news regarding IBM DB2 and Microsoft SQL Server as well.
zData Perspectives: Sequence Objects and Identity Columns.
zJournal, December 2003/January 2004.
Identity columns and sequence objects make designing DB2 database and applications easier than ever before. This installment of the z/Data perspective column compares and contrasts the functionality of these two DB2 features.
DBA Staffing Considerations.
TechTarget, 2004
Determining how many DBAs are needed, who reports to whom, and where the DBA function fits best can be a very challenging hurdle for an IT organization. This article helps to clarify the issues.
The Automated Future: Take 2. (link no longer active)
DB2 Magazine Online, December 2002.
DB2 Magazine conducted this interview with Craig to get his views on the future of DB2 database administration in light of the recent IBM promotion of self-
The DBA and Application Design: The DBA Corner.
Database Trends and Applications, December 2002.
Many organizations erroneously assume that the DBA should not be involved in application design. But in an efficient organization the DBA will promote the concept of designing applications with an understanding of the database at the forefront. The uninformed approach database application development with no proactive performance engineering – the assumption being that any performance problems can be resolved after development by the DBA. But it may be impossible to tune an improperly designed application program without rewriting it. With proper care, appropriate procedures, and DBA involvement, database applications can be written correctly from the onset.
Using Java With DB2, Part 1 Part 2. (links no longer active)
Mainframe Week, December 2002.
This two part article discusses Java and the options available for accessing DB2 data using Java programs. The differences between each of the two options are covered (JDBC and SQLJ), as well as providing guidance for DBAs who must manage Java applications is provided.
DB2 Everyplace: A Mobile DB2.
DB2 Update, December 2002.
IBM offers a version of DB2 that is small enough to run on handheld devices called DB2 Everyplace. DB2 Everyplace enables the mobile work force to unplug—but still tune in. This article discusses the features and functionality of DB2 Everyplace.
The Buffer Pool: Clarifying Some Common Misconceptions.
IDUG Solutions Journal, Vol. 9, No. 3
There are some aspects of DB2 that are commonly misunderstood – not by everyone, of course – but by enough of us that it warrants some investigation and clarification. This article takes a look at several of the most common DB2 misunderstandings and tries to shed some light on them.
DB2 and the Procedural DBA, Part 1 Part 2. (links no longer active)
Mainframe Week, November 2002.
As DB2 applications mature, more application code is being stored in the database in the form of stored procedures, triggers, and user-
Data Modeling Concepts Every DBA Should Know: The DBA Corner.
Database Trends and Applications, November 2002.
Handling performance problems is an enterprise-
eDBA: Database Disaster Planning and the eDBA. (link no longer active)
dbazine.com, November 2002.
The eleventh installment of the eDBA series examines the ever-
What is a DBA? -
dbazine.com, November 2002.
The first installment in a series that examines the roles and responsibilities of the database administrator.
Optimizing database performance, part 3: Compression, page size, and more.
searchSQLServer.com, 05 November 2002
Part 3 of a three part series on optimizing database performance. This article is excerpted from Craig Mullins' new book Database administration: The complete guide to practices and procedures. The first and second parts of this series are also available.
Optimizing database performance, part 2: Denormalization and clustering.
searchSQLServer.com, 16 October 2002
Part 2 of a three part series on optimizing database performance. This article is excerpted from Craig Mullins' new book Database administration: The complete guide to practices and procedures. The first and third parts of this series are also available.
Optimizing database performance, part 1: Partitioning and indexing.
searchSQLServer.com, 16 October 2002
Part 1 of a three part series on optimizing database performance. This article is excerpted from Craig Mullins' new book Database administration: The complete guide to practices and procedures. The second and third parts of this series are also available.
Coding DB2 SQL for Performance: The Basics.
DB2 Developer Domain, October 2002.
Poorly coded SQL and application code can cause performance problems. This article is intended to give the basics of good SQL programming to application developers, particularly for, but not limited to, those who are using Borland Kylix and Delphi RAD tools.
The Database Report: 3Q2002.
The Data Administration Newsletter, October 2002.
Another installment of the regular TDAN column covering the activities of the major DBMS players in the market. This edition focuses on Oracle and IBM's introduction of DB2 Version 8.
Q&As on DB2 Dates. (link no longer active)
dbazine.com, October 2002.
The ability to store dates as a native DB2 data type is a great advantage. But proper usage of dates in DB2 is not universally understood. This article sheds some light on the topic in the form a questions and answers.
Optimize Your Database Performance: The DBA Corner.
Database Trends and Applications, October 2002.
Handling performance problems is an enterprise-
Getting Down to Data Basics.
The Data Administration Newsletter, October 2002.
Some daring young enterprises embark on Web-
Reorganizing the DB2 Catalog and Directory, Part 1 Part 2 Part 3. (links no longer active)
Mainframe Week, October 2002
Since DB2 V4 it has been possible to reorganize the DB2 Catalog and DB2 Directory using the native IBM REORG utility. This article describes how to reorganize the DB2 catalog and provides some implementation tips and advice.
Why DBAs Must be Jacks-
InformIT, September 2002.
This article is an excerpt from my book, Database Administration: The Complete Guide to Practices and Procedures. It provides a nice introduction to the management discipline of database administration and is useful for DBAs, DBA managers, and anyone who has to interact with DBAs. After reading this article folks should gain a better appreciation for what a DBA does all day long.
The Changing Face of the Database.
eServer Magazine (Mainframe Edition), September 2002.
Database management systems (DBMSs) are the heart of the modern IT infrastructure. Modern database systems, however, are becoming increasingly large and complex. This article looks at the changing trends for database management systems including Internet enabling databases, management and administration issues, and incorporating procedural logic into the DBMS.
Keeping Your Databases up to P.A.R.: The DBA Corner.
Database Trends and Applications, September 2002.
A day in the life of a DBA is usually quite hectic... and to add to the chaos, DBAs are expected to know everything about everything. This article discusses how DBAs can focus on P.A.R. (Performance, Administration, and Recovery) to institute a proactive approach to database administration.
DB2 User-
dbazine.com, August 2002.
As of DB2 Version 6, it is possible to create user-
DBA Certification: The DBA Corner.
Database Trends and Applications, August 2002.
Professional certification is a recent trend in IT and is available for many different IT jobs. Certifications programs are available for most of the popular DBMS platforms today. This article discusses the trend and offers guidance on certification for database administrators.
Temporary Tables -
DB2 Update, August 2002.
As of V5, DB2 enables developers to create and utilize temporary tables. But why are they needed? And how are temporary tables supported in DB2 for OS/390? This article examines these issues.
Craig Mullins Answers Your Database Administration Questions.
searchdatabase.com, August 2002.
This Q&A session is from a web seminar Craig conducted on searchdatabase.com on the topic of Introduction to Database Administration, (or DBA 101). You can watch this web seminar now by clicking here.
Using TIMESTAMP Columns versus DATE and TIME Columns, Part 1 and Part 2. (links no longer active)
Mainframe Week, August 2002.
This two-
Managing the Performance of DB2 for OS/390 and z/OS. (link no longer active)
IT Tool Box, July 2002.
This article examines DB2 performance tuning from three different aspects: the system, the database and the application. It provides general guidance on tuning in each of the areas and then discusses how BMC Software's performance solutions can be used to deliver optimal performance.
DB2 Data Type Usage Tips. (link no longer active)
dbazine.com, July 2002.
Data type and length are the most fundamental integrity constraints applied to data in a database. This article provides an introduction to data type and length choices and discusses the ramifications of several different DB2 data type scenarios.
The Database Report: 2Q2002.
The Data Administration Newsletter, July 2002.
Latest installation of regular column for TDAN covering the activities in the DBMS software marketplace. This edition focuses primarily on the recent DBMS vendor rankings from Gartner and IDC (as well as the highlights of Oracle's antics in the second quarter).
Database Design -
Database Trends and Applications, July 2002.
Database design is the process of transforming a logical data model into an actual physical database. Assuming that the logical data model is complete, though, what must be done to implement a physical database? This article briefly discusses an approach to transforming logical models to physical databases.
DB2 Performance Traces. (link no longer active)
dbazine.com, June 2002.
This article, excerpted from Craig's book, DB2 Developer's Guide, provides an introduction to DB2 performance traces.
DBMS Architecture: The DBA Corner.
Database Trends and Applications, June 2002.
Choosing a DBMS is not as simple as you might expect. There are different types of DBMS each with different architectures and purposes. This article discusses the impact of architecture on the DBMS decision.
A DB2 for z/OS Performance Road Map. (link no longer active)
dbazine.com, May 2002.
A database application, at its core, requires three components in order to operate: the system, the database and the application. To deliver performance, the DBA must be able to monitor and tune each of these components. This article provides a performance road map to mainframe DB2 based on these three components.
How Much Availability is Enough?: The DBA Corner.
Database Trends and Applications, May 2002.
In this Internet age the push to provide never-
eDBA: Online Database Reorganization. (link no longer active)
dbazine.com, May 2002.
The tenth installment of the eDBA series examines the impact of reorganization on availability and the growing trend of reorganizing databases while they remain online.
The 'Top Ten' Problem.
DB2 Update, May 2002.
A common application development problem is the need to retrieve a limited number of qualifying rows from a database. For example, maybe you need to list just the top ten best selling items from inventory, or a list of the ten employees with the highest salary. This article discusses several ways to accomplish this using DB2.
A DB2 for z/OS Performance Road Map.
eServer Magazine (Mainframe Edition), April 2002.
A database application, at its core, requires three components in order to operate: the system, the database and the application. To deliver performance, the DBA must be able to monitor and tune each of these components. This article provides a performance road map to mainframe DB2 based on these three components.
The Database Report: 1Q2002.
The Data Administration Newsletter, April 2002.
Latest installation of regular column for TDAN covering the activities in the DBMS software marketplace. This edition focuses primarily on Oracle, including coverage of their security, financials for their fiscal third quarter, pricing flare-
What is a DBA?: The DBA Corner.
Database Trends and Applications, April 2002.
If your company uses a database management system (DBMS) then you most likely have a database administration group. But what is a DBA and why are they needed? This article discusses how DBAs are required in order to ensure effective database usage.
Using Templates and Lists in DB2 Utilities.
DB2 Update, April 2002.
As of DB2 V7, IBM offers more functionality in their basic utilities. This article examines how to use templates and lists to enable utilities to operate on groups of DB2 objects.
A View to a Kill.
dbazine.com, March 2002.
An adaptation of a presentation that discusses the lack of merit in creating base table views.
Select Database Utilities With Care: The DBA Corner.
Database Trends and Applications, March 2002.
Every DBA uses database utilities to manage and control their databases. But there is a lot of confusion in the marketplace with regard to utilities these days. This DBA Corner column looks at database utilities, particularly as they impact the DB2 for OS/390.
Issuing SQL Statements in DB2 Utilities.
DB2 Update, March 2002.
This short article discusses the EXEC SQL utility control statement. EXEC SQL was added to Version 7 of DB2 for OS/390 to allow SQL statements to be issued in conjunction with DB2 utilities.
eDBA: Intelligent Automation of DBA Tasks. (link no longer active)
dbazine.com, February 2002.
The ninth installment of the on-
Forty Tips in 60 Minutes. (link no longer active)
dbazine.com, February 2002.
Forty quick tips on administration and performance aspects of DB2 for OS/390. Adapted from a 1999 IDUG presentation.
An Introduction to Triggers in DB2 for OS/390.
dbazine.com, February 2002.
A quick introduction to the features and functionality of triggers available to mainframe DB2 databases and applications.
DRDA.
dbazine.com, February 2002.
A short introduction to IBM's Distributed Relational Database Architecture (DRDA). Adapted from my book, DB2 Developer's Guide.
Measuring DBA Effectiveness: The DBA Corner.
Database Trends and Applications, February 2002.
Measuring the performance of IT professionals can be a difficult proposition. This DBA Corner column looks at several different ways of measuring the effectiveness of DBAs.
Architectures for Clustering: Shared Nothing and Shared Disk.
DB2 Magazine, 1Q2002.
Clustering can bring extra computing power and improved availability. Choosing the architecture that makes sense with your hardware and software makes all the difference. This article discusses the predominant clustering architectures as well as an overview of how they are deployed for the various DB2 platforms.
Dealing With Downtime: The DBA Corner.
Database Trends and Applications, January 2002.
This installment of The DBA Corner focuses on the issues, concerns, and techniques DBAs can use to achieve high database availability.
The Database Report: 4Q2001.
The Data Administration Newsletter, January 2002.
Another installation of regular column for TDAN covering the activities in the DBMS software marketplace. This edition focuses on Oracle's heightened competition with IBM, Larry Ellison, as well as coverage of the goings on at Sybase, IBM, and Microsoft.
Using Check Constraints to Simulate Domains.
DB2 Update, December 2001.
An introduction to the capabilities of DB2 check constraints and how they can be used to somewhat simulate the relational concept of domains.
Database Fragmentation and Disorganization: The DBA Corner.
Database Trends and Applications, December 2001.
This installment of The DBA Corner focuses on the reasons databases need to be reorganized, and how reorganization can be performed.
Database Disaster Planning: The DBA Corner.
database Trends and Applications, November 2001.
It is imperative that the DBA group is prepared to continue business operations in the event of a disaster. This installment of The DBA Corner discusses aspects of planning for database disaster recovery.
Modern Database Administration, Part 3.
DM Review, November 2001.
The final installment of this three part article covering the changing role of the DBA discusses the growing size of databases, PDA database management, heterogeneity, and rapidly change DBMS software. Each is examined for its impact on corporate DBAs and intelligent automation is presented as a useful solution to database systems management issues and problems. Part 2 Part 1
COPYTOCOPY -
DB2 Update, November 2001.
This article examines the new (as of V7) COPYTOCOPY utility for DB2 for OS/390 and z/OS. The article provides a basic outline of the benefits and usage of this new utility.
Logic, e-
dbazine.com, October 2001.
This final installment of the regular eDBA column discusses the impact of procedural logic in the form of triggers, stored procedures, and user-
eDBA columns: Availability Design Backup/Recovery Online Resources XML Java Basics
The Database Report: 3Q2001.
The Data Administration Newsletter, October 2001.
Fourth installment of my regular column for TDAN covering the activities in the DBMS software marketplace. This edition focuses on the events of July 2001 through September 2001, and includes a special focus on the open source DBMS market.
Dissecting Database Performance: The DBA Corner.
Database Trends and Applications, October 2001.
This installment of The DBA Corner focuses on database performance, breaking the discussion down into three components that must be monitored and tuned to optimize database systems: the DBMS/system, the database, and the application.
Modern Database Administration, Part 2.
DM Review, October 2001.
The second part of this three part article discussing the changing role of the DBA covers the management and administration of procedural database objects such as triggers, stored procedures, and user-
The Role of the DBA Has Expanded: The DBA Corner.
Database Trends and Applications, September 2001.
Premier edition of a new column exclusively covering database administration policies, procedures, tools, and technologies. This initial column outlines database administration and topics that will be covered in subsequent columns.
Modern Database Administration, Part 1.
DM Review, September 2001.
This first part of a three part article discussing the changes in database administration covers the role of the DBA as databases are hooked up to the Internet.
An Introduction to DB2 for OS/390, Version 7.
dbazine.com, August 2001.
IBM released Version 7 of their mainframe DB2 DBMS in late March 2001. This overview examines the new features and functionality available in DB2 V7.
Design and the eDBA.
dbazine.com, August 2001.
This installment of the on-
Control Your DB2 Memory Usage Before It Controls You. (link no longer active)
BMC TechNews, July 2001.
A product overview of BMC Pool Advisor for DB2 for OS/390. The article discusses how Pool Advisor automatically analyzes and tunes DB2 memory structures based on throughput and usage.
The Database Report: 2Q2001.
The Data Administration Newsletter, July 2001.
Third installation of a regular column for TDAN covering the activities in the DBMS software marketplace. This edition focuses on the events of April 2001 through June 2001: including the IBM acquisition of Informix and its impact on the DBMS market and the release of Oracle9i.
Online Resources of the eDBA.
dbazine.com, July 2001.
This article exposes some of the many sources of information on DBMS software and database administration that are available online.
Intelligently Managing DB2 Memory Structures.
Database Trends, May 2001.
Relational databases perform better when sufficient computer memory is allocated for their use. This article discusses the four types of memory structures used by DB2 for OS/390 and discusses a solution for intelligently managing memory for DB2's usage.
DB2 Table Space Options.
DB2 Update, May 2001.
This article examines the three types of DB2 table spaces and discusses the pros and cons of using each type.
Why Data Still Matters.
Database Trends, April 2001.
Throughout the years marketers have proclaimed that many new technologies or techniques will make data somehow irrelevant. This article discusses this odd behavior and tries to explain why data will never become obsolete.
The Database Report: 1Q2001.
The Data Administration Newsletter, April 2001.
Second installation of a regular column for TDAN covering the activities in the DBMS software marketplace. This edition focuses primarily on the activities of Oracle, IBM, Microsoft, and Sybase during the first quarter of 2001.
High Speed Transaction Recovery. (link no longer active)
Storage, Inc., Q1 2001
As the demand for 24x7 processing increases, DBAs are looking for ways to perform database maintenance tasks with minimal or not outages. This article discusses high availability database recovery techniques to meet this demand head on.
The eDBA and Recovery.
dbazine.com, March 2001.
This article discusses database recovery within an e-
IT's a Crazy World.
Database Trends, March 2001.
The world of Information Technology (IT) never ceases to amaze. There's always something new and often times some crazy things are passed off as logical and considered common knowledge. This article takes a second look at some misconceptions held within the IT community.
Getting Down to Data-
dbazine.com, February 2001.
For e-
The 24x365 Availability Challenge.
Database Trends, February 2001.
In the day and age of e-
The Database Report: 4Q2000.
The Data Administration Newsletter, January 2001.
First installation of a regular column for TDAN covering the activities in the DBMS software marketplace. The primary focus of this quarterly column will be on the major players in the industry, namely Oracle, IBM (DB2), and Microsoft (SQL Server). Additional coverage from time to time will discuss the other players such as Informix, Sybase, NCR/Teradata, Software AG (Adabas and Tamino), PostgreSQL, MySQL, and others. This first article provides an overview of recent happenings at Oracle and IBM.
An Update on Oracle.
Database Trends, January 2001.
This article provides a glimpse into the activities of Oracle Corporation during the fourth quarter of 2000 discussing Oracle's recent personnel issues, Oracle9i, and financial issues, among others.
LOB Columns vs. VARCHAR and VARGRAPHIC. (link no longer active)
Revealnet Pipeline Newsletter, December 2000
A quick review and comparison of new (V6) LOB columns versus DB2's older data types for storing large character (VARCHAR) and graphic (VARGRAPHIC) data.
The eDBA and XML.
dbazine.com, December 2000
As DBAs become eDBAs they must understand the requirements and technology driving e-
Using TIMESTAMP Columns Versus DATE & TIME Columns.
DB2 Update, December 2000.
This article examines the pros and cons of using a TIMESTAMP column versus using DATE and TIME columns to store date and time information in a DB2 table.
Denormalization Guidelines for SQL Server Databases.
SQL Server Update, December 2000.
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.
Updates, Trends, and Thoughts.
Database Trends , December 2000.
A quick year-
News From the Front -
Database Trends , November 2000.
There were numerous battles in the database wars during August and September 2000. Each of the major players was involved in skirmishes and attacks. This articles takes a quick look at the recent events with coverage of the regular players IBM, Microsoft, and Oracle, as well as a brief look at what is happening at Informix.
Using Java With DB2 for OS/390.
DB2 Update, November 2000.
This article discusses Java and the options available for accessing DB2 data using Java programs. The differences between each of the two options are covered (JDBC and SQLJ), as well as providing guidance for DBAs who must manage Java applications is provided.
Managing Database Change.
Database Trends , October 2000.
There are many different aspects of managing change, but DBAs are faced with a particularly daunting challenge: database change management. This article discusses the many aspects of managing and handling change, specifically with regard to database change.
Character Versus Numeric Data Types.
SQL Server Update, October 2000.
Most DBAs have faced the situation in which a code is required to identify products, accounts, or some other business object, and the code values are always numeric and will stay that way. This article discusses the benefits and drawbacks of using character and numeric data types in this situation.
Managing for the Future. (link no longer active)
BMC Tech News, September 2000
Solutions composed of "smart software" can provide capabilities that go significantly beyond tools, utilities and simple automation. BMC Software's Advisor technology is raising the management bar by enabling intelligent systems management. An Advisor-
The eDBA and Java.
dbazine.com, September 2000
As DBAs become eDBAs they will migrate their skill-
Pervasive Computing And Pocket Databases.
Database Trends , September 2000.
Most of the major DBMS vendors supply versions of their products that run on the popular PDA devices of today: the Palm Pilot and the Microsoft Pocket PC. IBM's DB2 Everyplace, Oracle8i Lite, and Sybase Adaptive Server Anywhere are prime examples. This article discusses the application and management of PDA databases.
The 'Top Ten' Problem.
SQL Server Update, September 2000.
A common application development problem is the need to retrieve a limited number of qualifying rows from a database. For example, maybe you need to list just the top ten best selling items from inventory, or a list of the ten employees with the highest salary. This article discusses several ways to accomplish this using SQL Server.
Intelligent Automation Answer to DBA Overload.
Database Trends, August 2000.
To effectively manage enterprise databases, a DBA must understand both the business reasons for storing the data in the database and the technical details of how the data is structured and stored. To achieve this level of understanding DBAs require "smart" software that intelligently automates database management tasks.
DB2 Everyplace: You Can Take It With You.
DB2 Magazine, Fall 2000.
Enabling relational databases small enough to run on handheld devices, DB2 Everyplace lets the mobile work force unplug—but still tune in. This article discusses the features and functionality of DB2 Everyplace V7.
DB2 User Defined Functions. (link no longer active)
Revealnet Pipeline Newsletter, July 2000
A basic introduction to the capabilities and implementation of user-
Reorganizing the DB2 Catalog and Directory.
DB2 Update, July 2000.
As of Version 4 of DB2 for OS/390 it is possible to REORG the DB2 Catalog and DB2 Directory using the native DB2 REORG utility. This article discusses the steps necessary to accomplish catalog reorganization. Useful for DB2 database administrators and systems programmers.
Open Source Database Management Systems.
Database Trends, July 2000.
The media circus surrounding Linux has enlivened the Open Source community. The term "open source" refers to software that users are free to run, copy, distribute, study, change and improve. There are now open source alternatives for DBMS software on the market. This article examines some of them.
Transaction Log Basics.
SQL Server Update, June 2000.
The transaction log is a fundamental component of Microsoft SQL Server. All changes to data in the database are recorded in the transaction log. This article provides a basic introduction to the way in which SQL Server implements and uses transaction logs.
An Update on the Database Wars.
Database Trends, June 2000.
IBM, Oracle, and Microsoft have been actively updating their respective, industry-
Using DB2 Stored Procedures. (link no longer active)
devx, May 2000.
Stored procedures are specialized programs that are executed under the control of the relational database management system, in this case DB2. This article, excerpted from DB2 Developer's Guide, examines how DB2 stored procedures work.
The eDBA and Data Availability.
dbazine.com, May 2000
The most critical issue facing DBAs as their businesses morph into e-
High Speed Transaction Recovery.
Enterprise Systems Journal, May 2000
If your data is not available, your applications cannot run, and therefore, your company is losing business. Lost business translates into lower profitability and, perhaps, a lower stock valuation for your company. These are all detrimental to the business, so the DBA must do everything to ensure that databases are kept online and operational.
High Speed Transaction Recovery. (link no longer active)
Farber LaChance, May 2000.
A two part article on how to increase data availability by recovering transactions from the database log instead of traditional file-
The DAMA Symposium and Meta Data Conference 2000.
Database Trends, May 2000.
The 12th Annual DAMA Symposium conference was held during the week of March 19th, 2000, in Washington, D.C. The event was held in conjunction with the 4th Annual Meta Data Conference and the combined event drew a healthy audience of over 800 attendees and speakers. This article provides a short trip report for those who could not, but probably should have attended.
Creating SQL Results Sets with Aggregate and Detail Data.
SQL Server Update, April 2000.
Sometimes it is necessary to combine detail information with grouped information on the same row. Formulating SQL queries that accomplish this task can be complex and difficult for the SQL novice. This article describes several useful techniques for mastering this requirement.
A Basic IT Library.
Database Trends, April 2000.
Technology is best learned through reading books, but there are a lot of books out there. Which ones are the best? This article describes a small core library of technology books that every IT professional should own, read, and use.
DB2 Triggers. (link no longer active)
Revealnet Pipeline Newsletter, March 2000
A basic introduction to the capabilities and implementation of triggers in DB2 for OS/390 Version 6.
Accuracy Versus Speed.
Database Trends, March 2000.
Speed is the enemy of accuracy. Sometimes we strive for speed so much that we sacrifice correctness. This short article discusses examples of this phenomenon.
Minimizing Outages With Transaction Recovery.
Database Trends, February 2000.
Data availability is high on the list of objectives for all DBAs and the demands of modern database applications (such as e-
DB2 and the Procedural DBA.
DB2 Update, February 2000.
As DB2 applications mature, more application code is being stored in the database. This may take the form of a stored procedure, a trigger, or a user-
Two Interesting Acquisitions.
Database Trends, January 2000.
In early December 1999, we witnessed a rare occurrence in the software industry as two DBMS vendors—Informix and Sybase—made wise acquisition announcements. The acquisitions were not the rare part—it was the fact that the acquisitions were wise that was surprising.
