A Guide to Better Risk Management for DB2 LUW DBAs
IBM DB2 DBAs intuitively deal with risk identification and management every day, yet they may still be impacted by risk management in ways that they may not recognize. Rebecca Bond discusses seven steps to help DB2 LUW DBAs better understand Risk Management.
Data in Memory
In-memory databases are becoming increasingly popular and an ever-more important factor in performance-critical activities such as stream processing and deep data analytics. Join Julian Stuhler as he delves into the world of in-memory databases: a technology that’s both reassuringly familiar and intriguingly novel at the same time.
DB2 for z/OS Database Recovery - Get it Right
Database backup copies may not be enough to ensure data recoverability. The DBA must "bake" recoverability into the database design process; additionally, for current systems, the DBA needs to know whether current backup processes support recovery procedures that will meet application recovery objectives.
GRC 101 for DB2 LUW DBAs
Rebecca Bond attended IOD recently where the "hall conversation" centered on Governance, Risk Management and Compliance (GRC) and the potential impact for DB2 DBAs. Read what she discovered as she researched answers to some basic GRC questions.
PureScale Performance Proven
DB2 for z/OS provides mainframe users with unmatched levels of resilience and scalability through technology known as data sharing. IBM announced that similar capabilities would be delivered for DB2 for LUW, in an optional facility dubbed pureScale. Read on to learn whether DB2 pureScale has met or exceeded expectations.
Dynamic SQL Performance Tuning Techniques for IBM DB2 z/OS
Applications running with dynamic SQL are ever-increasing. Without some methods to contain the onslaught of queries, performance drops and phone calls increase. What can a DBA do to remain sane and avoid a visit from the head of IT?
Understanding IBM DB2 DB2SET
Despite the fact that db2set has been around for a while, it seems that db2set is not always well understood. According to IBM’s documentation, the IBM DB2 Profile Registry command (db2set) allows for centralized control of environmental variables. Read on to learn more...
Let's Do the Time Warp: Temporal Data Comes To IBM DB2
A couple of months ago, I included DB2's new temporal data capabilities as one of my "Top 10 IBM Data Management Trends for 2010". As DB2 10 for z/OS is now Generally Available, we're going to dig into this popular new feature in a little more detail in this month's column.
Performance Tune IBM DB2 z/OS Applications using Resource Constraint Analysis
For the DB2 for z/OS professional the two most common systems tuning scenarios are tuning a DB2 data sharing group or tuning a series of application SQL statements. The data sharing group environment can involve multiple hardware installations and many other cross-system features and functions such as coupling facilities and management policies. Resource constraint analysis is a useful tool in both situations.
IBM Shakes Up Data Warehousing Market
IBM has been on the acquisition trail again, and this time it was Netezza's turn to take the call. In this month's column, we'll take a look at some of the possible implications of the purchase, as well as rounding up a couple other significant announcements around pureScale and DB2 for z/OS.
Logical and Physical Locking in IBM DB2 for z/OS
Many DBAs and analysts are confused by the variety of serialization mechanisms used by IBM DB2 for z/OS to ensure data consistency and maintain concurrency control. Understanding logical and physical locking can help you better understand and improve application and system performance.
Top 5 New DB2 10 for z/OS Features Aimed at SAP Applications
As IBM draws ever nearer to announcing an availability date for DB2 10 for z/OS, the list of new features has solidified. This month’s article examines the top five features aimed specifically at SAP applications running under DB2 for z/OS.
IBM DB2 LUW Security Helps DBAs Beat the Odds
IBM DB2 DBAs fight many security battles, but they don't have to fight them alone. Rebecca Bond, the IBM DB2 Locksmith, shares five tips to help DB2 LUW DBAs beat the database security odds.
IBM DB2 for z/OS V8: The End Is Nigh
Despite the traditional news dead zone as many people take a well-earned summer holiday, this month has seen a couple of interesting announcements from IBM which will impact many of us over the next year or two.
Tuning an IBM DB2 for z/OS Application: CPU Constraints
When involved in application performance tuning, the database administrator usually concentrates on reducing elapsed times or I/O waits. Too often, the CPU is forgotten, perhaps because of recent advances in CPU speeds, parallelism, and specialty processors.
With IBM DB2 9.7, Change is Easy
IBM DB2 database administrators can now rename a column without the need to unload, drop, rebuild, reload and re-grant on the table. Rebecca Bond introduces AUTO_REVAL, a recent addition to IBM DB2 configuration options.
IBM DB2 pureScale: The Next Big Thing or a Solution Looking for a Problem?
In October 2009, IBM announced that some rather neat technology known as data sharing would be delivered for the IBM DB2 for Linux, Unix and Windows product, in an optional facility dubbed pureScale. Julian Stuhler takes a closer look at this technology and the possible implications for the entire IBM DB2 world.
How DBAs Can Tune Distributed IBM DB2 Applications
Many critical business applications now execute in an environment separate from that of the enterprise database server. The database administrator often finds monitoring and performance tuning of these "distributed" applications to be especially difficult. This article looks at common performance issues of distributed applications and presents advice to assist the IBM DB2 database administrator in mitigating performance problems.
DB2 
