Which is better? “BETWEEN” vs. “<=” and “>=”.
datAvail Blog, December 20, 2017.
Checking if a value is between two other values seems simple enough, but there are a lot of variations that can impact how your SQL performs.
The Rising Need for Database Scalability.
NuoDB Blog, December 19, 2017.
Database Management Systems are at the heart of most applications and, as such, the ability to scale database systems elastically is important. This is the first in a series of pieces on the various methods of accomplishing database availability and elasticity.
The Pros and Cons of Database Scaling Options.
NuoDB Blog, December 11, 2017.
As cloud and container-
Evaluating a DBA Job Offer.
datAvail Blog, December 7, 2017.
Are you a DBA? Are you thinking about changing employers? If so, make sure that you read this post that outlines things to look for and ask about as you interview for your next DBA job.
In this month’s DBA Corner we examine the important topic of data quality and the impact when that quality is poor.
As we move beyond relational as the only DBMS type that matters and embrace NoSQL and Hadoop data platforms, data integration can become more challenging and require new tools and approaches to achieve success.
Replacing UNION with CASE (Db2).
datAvail Blog, November 22, 2017.
When writing UNION to put together data from multiple queries, you might be able to use a CASE statement instead. The CASE statement can potentially enhance performance by minimizing the number of times the data is read.
Quick Thoughts on Db2 Performance.
datAvail Blog, November 9, 2017.
An overview on the cause of Db2 performance problems.
In this month’s DBA Corner we examine what ACID means for your data integrity.
The idea of information overload has been around for a long time, even pre-
Reading Things That Aren’t There… and Missing Things That Are!
datAvail Blog, October 26, 2017.
This article takes a look at how different database options can impact what data your programs will read. Specifically, it looks at the Db2 options SKIP LOCKED DATA and ISOLATION(UR).
In this month’s DBA Corner we take a look at the different types of DBAs, compare the roles of generalist and specialist, and examine the responsibilities of several types of specialist DBAs.
On The Importance of Choosing the Correct Data Types.
datAvail Blog, October 11, 2017.
DBAs regularly deal with the pros and cons of choosing one data type over another. Sometimes the decision is easy, other times it is a bit more difficult. This article looks at both situations.
Limiting the Number of Rows Fetched.
datAvail Blog, September 27, 2017.
Application developers frequently need to retrieve a limited number of qualifying rows from a table. This article reviews different ways of achieving this.
The “Dirty Read” (AKA Uncommitted Read).
datAvail Blog, September 13, 2017.
An overview of using isolation level UR to achieve dirty reads including what is it, how it impacts your applications, the dangers involved if you choose to use it, and some administrative queries to help you understand where it is being used in your shop.
Database performance is the focus of this month’s DBA Corner column. This article looks at various techniques and capabilities for optimizing database performance.
Standards are required for database access and development, but they should not be set in stone. They need to live and breathe and react to changing needs and requirements.
Know Your ISOLATION Levels.
datAvail Blog, August 30, 2017.
On overview of Db2’s capabilities for controlling how locks are acquired using ISOLATION level (the I in ACID).
Ensuring Data Integrity is a Tricky Business.
datAvail Blog, August 18, 2017.
Making sure that the data in your database is accurate should be a top priority. This article discusses various methods and mechanisms for ensuring data integrity.
This month’s DBA Corner column examines the importance of using referential integrity to improve data quality in relational database systems and applications.
Approaches to Access Path Management… or The Five R’s.
datAvail Blog, July 25, 2017.
BIND and REBIND are important tools in assuring optimal performance… but there are more steps involved in the process. This post outlines access path management best practices for DB2 for z/OS.
An overview of the new capabilities of the IBM z14 mainframe announced on July 17, 2017.
Basic DB2 Buffering and Memory Guidelines.
datAvail Blog, July 11, 2017.
One of the most important areas for tuning DB2 subsystem performance is memory usage. This post summarizes the basic buffer pool options and how they impact performance.
In this edition of the DBA Corner we examine in-
Cost vs. Advantage of Moving From IMS DB to Db2.
datAvail Blog, June 28, 2017.
This post offers up an answer to a question that was sent my way. In it, I evaluate (at a high level) the pros and cons of migrating from IMS DB databases to DB2 for z/OS database.
The trend toward automation of DBA activities is clear and it is being augmented with autonomics as we move towards systems that are more self-
A quick look at the Internet of Things (IoT) and how it is causing data growth and changes to the way in which we manage data.
In this edition of the DBA Corner we take a look at the various options and scenarios involved in planning for database recovery situations.
A Short Introduction to Lock Avoidance.
datAvail Blog, May 29, 2017.
This article offers a good overview of lock avoidance in DB2 for z/OS explaining how it works, why it is important to know, and how you can use it to improve performance without degrading data integrity.
Security is an ever-
This month’s DBA Corner column offers up some high-
Before we can understand and improve DB2 performance, we need a definition for database performance. This article provides that as well as a high-
Embracing the Challenges of Gaining Value from Analytics.
DirectionIT Magazine, April 17, 2017.
Customer expectations are changing dramatically in the age of big data and analytics. And much can be achieved but there are issues and technology hurdles to overcome. Doing so, though, promises a big ROI.
What is a data lake? This new term is not well-
This month in the DBA Corner we look at the important topic of backup and recovery and the difference between full and incremental image copy backups.
Appreciating Metadata Through Music.
TDAN, April 5, 2017.
Although metadata is extremely important, many data professionals do not understand it… or simply ignore metadata management. This article discusses the importance of metadata using the familiar topic of popular music.
The Most Common Types of DBAs.
datAvail Blog, March 30, 2017.
Database administration encompasses many different skills and there are several different types of DBAs that correlate to those skills. This post takes a look at the most common DBA types.
Structuring Your DBA Staff: Generalists or Specialists?
datAvail Blog, March 23, 2017.
The job of a DBA is quite unique in any organization. A large organization typically will hire many DBAs, but in a small-
Don’t Forget DISPLAY as a Part of Your DB2 Tuning Efforts.
datAvail Blog, March 16, 2017.
The DISPLAY command is a very useful and versatile command that DBAs can use to gather a lot of interesting performance and administrative details in DB2 for z/OS.
In this month’s edition of DBA Corner we examine the heart of any RDBMS: the system catalog, and explain how it is used and give guidance on how optimize it for your database environment.
VOLATILE: A Useful Little Keyword.
datAvail Blog, March 2, 2017.
A discussion on volatile tables and how judicious use of the VOLATILE keyword (in DB2) can improve the performance of accessing them.
The market for operational DBMS products can be confusing, especially with so many choices. But knowing your application requirements can help point you in the right direction.
This month’s DBA Corner takes a look at digital transformation… what is it? And how is it impacting DBAs and their duties.
Using INTERSECT and EXCEPT in DB2.
datAvail Blog, February 9, 2017.
This article take a quick look at two seldom-
Sorting Out a Solution in DB2.
datAvail Blog, January 26, 2017.
A common problem involves sorting a column that contains a day-
Mobile Computing, The Mainframe, and z/OS Connect.
Planet Mainframe, January 11, 2017.
Mobile computing has altered our modern computing architecture, and it is impacting the mainframe, too. This article looks at how z/OS Connect can be used to incorporate your mainframe computing assets into your modern, mobile workload.
This month’s DBA Corner examines the trends impacting database administration circa 2017 and gives DBAs advice on how to succeed in a world of increasing complexity.