Author: Craig Mullins

DB2 Pro Members Standard Members

Issuing SQL Statements in DB2 Utilities

Issuing SQL Statements in DB2 Utilities By Craig S. Mullins The EXEC SQL utility control statement can be used to declare cursors and execute dynamic SQL statements during an IBM DB2 for z/OS utility execution. The EXEC SQL control statement produces a result table when you specify a cursor. The EXEC SQL control statement executes entirely in the EXEC phase...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

First, You Must Define Data Integrity…

First, You Must Define Data Integrity… By Craig S. Mullins The term "data integrity" can mean different things to different people… and depending on context. At the top level, there are two aspects of integrity with respect to databases: database structure integrity and semantic data integrity. Keeping track of database objects and ensuring that each object is created, formatted and...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Managing Database Storage

Managing Database Storage By Craig S. Mullins Database systems require data files to store the data under management. These files, or data sets, reside on storage media. So storage management should be a key part of the database operations required of a database administrator (DBA). Unfortunately, storage is sometimes relegated to an afterthought; after all, don’t we have storage administrators...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Preparing for Database Application Design Reviews

Preparing for Database Application Design Reviews By Craig S. Mullins Design reviews are an important facet of the system development lifecycle for database applications. It is imperative that all database applications, regardless of their size, participate in some form of design review both before and after implementation. Design reviews are critical for ensuring that an application is properly designed to...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
DB2 Pro Members Standard Members

SELECT from INSERT, DELETE, UPDATE, and MERGE

SELECT from INSERT, DELETE, UPDATE, and MERGE By Craig S. Mullins A somewhat under-utilized feature of DB2 SQL provides the ability to SELECT from INSERT, DELETE, UPDATE, and MERGE statements. This capability was introduced to DB2 for z/OS over two versions: version 8 and version 9. SELECT from INSERT was introduced with DB2 V8, the remaining with V9. Let’s start...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Database Administration in an Increasingly Complex World

Database Administration in an Increasingly Complex World by Craig S. Mullins The Database Management Systems we use every day are becoming more and more complex – there can be no denying this basic fact of life. Whether you are using DB2 or SQL Server or Oracle or any other popular DBMS, each and every new version adds new features, functionality,...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Curbing the Curmudgeons in the Corner

Curbing the Curmudgeons in the Corner By Craig S. Mullins Sometimes viewed as prima donnas, DBAs can be curmudgeons who have vast technical knowledge, but limited people skills. Just about every database programmer has their favorite DBA story — those famous anecdotes that begin with “I have a problem…” and end with “…and then he told me to stop bothering...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Safeguarding Financial Data

Safeguarding Financial Data By Craig S. Mullins Regulatory compliance has become a critical aspect of the IT landscape, and is a special consideration for financial institutions that house sensitive data. More and more regulations are being passed that dictate increased effort be exerted to better secure and protect the accuracy and privacy of mainframe data. The most valuable enterprise data...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
DB2 Pro Members Standard Members

Working With Variable Length Data

Working With Variable Length Data by Craig S. Mullins One of the key design issues that must be addressed in most database applications is how to implement character data that varies in size from row to row. The basic trade-off is “ease-of-use and performance” versus “storage requirements.” It is possible to save disk storage space by using variable columns instead...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Database Capacity Planning

Database Capacity Planning By Craig S. Mullins Most database implementations are anything but static. Once deployed, databases are queried, updated, loaded, unloaded, reorganized, and data is deleted and inserted from them on an ongoing basis. As the data composition of a database changes, it storage requirements will change as well. The DBA must be ever vigilant to plan for future...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register