|
10 Surprising Things to Do With IBM DB2 Query Monitor for z/OS, Part 2
Displaying performance-related information about specific queries is the traditional use for DB2 Query Monitor. But, as reader Tom Glaser points out, its full capabilities go way beyond the expected. Here is the second half of Glaser's top 10 list.
>Read On
Asked and Answered: Using Recursive SQL to Set a Delay in DB2 for z/OS
A reader shares his hand-written solution to a recursive SQL challenge.
>Read On
It's here! End-to-End Database Monitoring using IBM DB2 Performance Expert Extended Insight Feature
New insights into the complicated world of Java, SQL, and database performance.
>Read On
Data Architect: DB2 Programmers Do Exist
And the things they do with DB2 SQL might surprise you.
Issue 4, 2008
Data Architect: Get On the Enterprise Service Bus
It's no magic bullet, but enterprise service bus technology hits the mark for certain transactions.
Issue 3, 2008
Data Architect: Can SOA Perform?
The answer is yes, but only if you leave old-school application ideas behind.
Issue 2, 2008
DB2 DBA: Elevating the DBA Role
Is it time to retire the database administrator title for one that represents the real work DB2 DBAs do?
Issue 1, 2008
DB2 DBA: Ultra Availability
If you think "never down, don't lose anything" is an impossible goal for DB2, you should think again.
Issue 3, 2007
DB2 DBA: News from the Client Side
Application developers love Python, Perl, PHP, and Ruby. DB2 is ready to support them -- are you?
Issue 2, 2007
What DB2 Means to Business Value
Talk DB2 in business terms the suits can understand.
Issue 1, 2007
Asked & Answered
How do I prevent unauthorized users from accessing production data stored in a cloned database to preserve compliance with privacy and obfuscation requirements?
Issue 1, 2007
Asked & Answered
The application I work on currently uses Cobol DB2 stored procedures on z/OS running under the WLM address space. Would you recommend a plain COBOL sub-routine call or an exec SQL call?
Issue 4, 2006
Into the Wild (Big) Blue Yonder
From documentary filmmaking to extreme programming, IBM's lead innovator has always blazed his own trail.
Issue 4, 2006
DB2 DBA: Managing XML with DB2--The DBA's View
Issue 4, 2006
Asked & Answered
Issue 4, 2006
DB2 UDB 9 and XML: The IBM Perspective
Issue 3, 2006
Asked & Answered
Issue 3, 2006
DB2 DBA: SOA for DBAs
Issue 3, 2006
Distributed DBA: What's XML to You?
Issue 3, 2006
Youthful Enthusiasm
Issue 3, 2006
User Views
Issue 3, 2006
Certified Intelligence
Issue 2, 2006
PHP and IDS
Issue 3, 2006
Message Queue
Issue 3, 2006
News Bytes
Issue 3, 2006
XML in Focus
Issue 3, 2006
Opening the Door to XML
Issue 3, 2006
Asked & Answered
Issue 1, 2006
Message Queue
Issue 2, 2006
News Bytes
Issue 2, 2006
Asked and Answered
Issue 1, 2006
Advance to Go
Issue 1, 2006
Zooming In On Saturn
Issue 1, 2006
DB2 DBA: DB2 Disaster Recovery, Part 2
Issue 1, 2006
Asked & Answered
Where can I find a code snippet for accessing DB2 for z/OS stored procedures in Java using input parameters?
Issue 1, 2006
The Mainframe DBA Exam
Issue 4, 2005
DB2 DBA: DB2 Disaster Recovery
Issue 4, 2005
Up Start
Issue 4, 2005
Asked & Answered
In DB2 UDB for Linux, Unix, and Windows v.8, how do you calculate table size for a DMS tablespace (assuming the table has all data types)?
Issue 4, 2005
Thanks for the Memory
Issue 3, 2005
The Keys To The Database
A carefully chosen primary key can lock in better performance.
Issue 2, 2005
Protecting DB2's Image
When it comes to version recovery, the database backup image is everything.
Issue 2, 2005
The State Of Automation
Issue 2, 2005
Message Queue
Knowledge To A New Horizon
Issue 2, 2005
The New DBA: Conquering a World of Opportunity
With DBA shortages, increasing data volumes, and cost-cutting pressures affecting virtually every business, something's got to give. Autonomic features are changing the technology in response - and giving DBAs a chance to reshape their roles.
Issue 2, 2005
Pulling It All Together
One fact should be clear now: DB2 Magazine is not just about DB2 database software anymore.
Issue 1, 2005
Message Queue
More Available Than Ever; Wikipedia Woes
Issue 1, 2005
Window on the World
The Distributed Data Facility lets DB2 see beyond the mainframe.
Issue 1, 2005
Parlez-Vous BI?
Everything you need to know to talk intelligently about business intelligence.
Issue 4, 2004
Doing the Math
Issue 4, 2004
Think Of The Possibilities
With Linux delivering Unix performance and reliability at Intel prices, pioneering enterprises can take their information analysis to places they've never gone before.
Issue 4, 2004
Parlez-Vous DB2 For LUW? (Part 2)
Despite language differences, the DB2 family is united by common concepts.
Issue 2, 2004
Parlez-Vous DB2 for LUW? (Part 1)
Lessons in the Linux, Unix, Windows lingo for those in the mainframe milieu.
Issue 1, 2004
Basic DB2 UDB Performance Tuning, Part 3
For best performance, make database objects the target of your attention.
Issue 1, 2004
Stored Procedures Go Mainstream
DB2 shops are finally diving in with this underused feature.
Issue 4, 2003
Basic Performance Tuning, Part 2
How to change your instance and database parameters for the best Performance effect.
Issue 4, 2003
Just the Stats, Ma'am (Part 2)
A DB2 statistics report can be the key to better performance.
Issue 3, 2003
Basic Performance Tuning
Your platform-specific guide to getting the very best performance from DB2 UDB.
Issue 3, 2003
Distributed DBA: Storage, I/O, and DB2
Recommendations for deploying DB2 databases in network storage environments.
Issue 4, 2008
Distributed DBA: Mastering DB2 SQL Stored Procedures
To certify as a DB2 9.5 SQL Procedure Developer, make sure you know the ins and outs of creation and deployment.
Issue 3, 2008
Distributed DBA: Automatic Maintenance and Utility Throttling in DB2 9
DB2's adaptive utility throttling system allows maintenance during critical periods, without requiring down time.
Issue 2, 2008
Distributed DBA: DB2 Deep Compression, Part 2
Updates in DB2 9.5 improve this space-saving and performance-boosting technology.
Issue 1, 2008
Monitoring and Tuning Memory in DB2 9 for Linux, Unix, and Windows
DB2 9's self-tuning memory manager, which dynamically tunes to a specific workload, is one of many memory enhancements in that release. Understanding how DB2 memory usage works lets you get the most out of the new capabilities.
Issue 3, 2007
Info 2.0: Harnessing Data, Web 2.0's Driving Force
Web 2.0 technologies are hitting businesses like a gale-force wind. Launched this summer, IBM's Info 2.0 initiative attempts to capture, focus, and control this energy. Here's what database administrators, designers, developers, and programmers--and anyone else who works with DB2, IDS, and other information management technologies--need to know to tackle the changes Web 2.0 will bring.
Issue 3, 2007
DB2 "Viper 2" Accelerates IT Agility
The next DB2 release (due later this year) promises advances in XML development, availability, security, workload management, and other features that help IT go with the flow of changing business needs.
Issue 3, 2007
DB2 DBA: Ultra Availability
If you think "never down, don't lose anything" is an impossible goal for DB2, you should think again.
Issue 3, 2007
Distributed DBA: DB2 Deep Compression
New deep compression technology in DB2 9 shrinks storage requirements and can even boost performance.
Issue 3, 2007
IDUG User View: DB2 Makes Being Green Easy
Reusing DB2 resources makes good business--and performance--sense.
Issue 3, 2007
Skills Zone: Five Tips for Acing DB2 and other IBM Exams
What already certified DBAs (and developers) know can help you on the IBM certification tests.
Issue 3, 2007
Editor's Note: DB2 and Bono--Six Degrees of Separation
DB2 and the U2 front man help the National Geographic Society shed light on an ancient mystery.
Issue 2, 2007
Skills Zone: How to Certify for Free
Earn DB2, Informix, or other IBM certification without spending a cent.
Issue 2, 2007
DB2 DBA: News from the Client Side
Application developers love Python, Perl, PHP, and Ruby. DB2 is ready to support them -- are you?
Issue 2, 2007
Distributed DBA: Label-Based Access Control, Part 2
Protect data in individual columns with label-based access control, new in DB2 9 for Linux, Unix, and Windows.
Issue 2, 2007
Business Intelligence in the Balance: IBM tackles BI's complex future with dynamic warehousing
IBM's dynamic warehousing concept and the IBM Balanced Warehouse address the challenges companies face as they reorient business intelligence and data warehouse systems to answer the demand for information
Issue 2, 2007
DB2-Based Enterprise Data Warehouse Named Best in Class
Before the Balanced Warehouse, the balanced configuration unit methodology helped implementations like Ingenix's Galaxy enterprise data warehouse--which won TDWI's 2007 Best Practices Award--handle new business requirements, burgeoning data volumes, and changing regulations.
Issue 2, 2007
Analyzing Audit Data in DB2 "Viper 2"
Enhancements to the DB2 audit facility in the "Viper 2" release slated for later this year will help companies meet regulatory and security demands
Issue 2, 2007
Extreme SQL Performance Techniques for DB2
Use the right tuning technique for your workload to avoid hardware upgrades and optimize DB2 performance.
Issue 1, 2007
DB2 Express-C for Certification
DB2 Express-C provides hands-on experience at no cost.
Issue 1, 2007
What DB2 Means to Business Value
Talk DB2 in business terms the suits can understand.
Issue 1, 2007
Understanding Label-Based Access Control, Part 1
DB2 9's newest data security control combats threats from the inside.
Issue 1, 2007
Data Security: The Naked Truth
Restore your DB2 for Linux, Unix, and Windows modesty--and cover your database auditing and privacy requirements in the process.
Issue 1, 2007
Distributed DBA: DB2 Database Cloning
Issue 4, 2006
Distributed DBA: DB2 Isolation Levels--Beyond The Default (Part 1)
Issue 1, 2006
Distributed DBA: Storage, I/O, and DB2
Recommendations for deploying DB2 databases in network storage environments.
Issue 4, 2008
Distributed DBA: Mastering DB2 SQL Stored Procedures
To certify as a DB2 9.5 SQL Procedure Developer, make sure you know the ins and outs of creation and deployment.
Issue 3, 2008
Distributed DBA: Automatic Maintenance and Utility Throttling in DB2 9
DB2's adaptive utility throttling system allows maintenance during critical periods, without requiring down time.
Issue 2, 2008
Distributed DBA: DB2 Deep Compression, Part 2
Updates in DB2 9.5 improve this space-saving and performance-boosting technology.
Issue 1, 2008
Distributed DBA: DB2 Deep Compression
New deep compression technology in DB2 9 shrinks storage requirements and can even boost performance.
Issue 3, 2007
Distributed DBA: Label-Based Access Control, Part 2
Protect data in individual columns with label-based access control, new in DB2 9 for Linux, Unix, and Windows.
Issue 2, 2007
Understanding Label-Based Access Control, Part 1
DB2 9's newest data security control combats threats from the inside.
Issue 1, 2007
Programmers Only: The Mystery of DB2 Sorts
Can adding SORT syntax really improve DB2 for z/OS performance?
Issue 4, 2008
Programmers Only: The Mystery of DB2 for z/OS Index-only Updates and Deletes
Can a DB2 for z/OS index-only UPDATE or DELETE really be index only?
Issue 3, 2008
Programmers Only: The Mystery of the DB2 SIX Lock
The truth behind this enigmatic lock and other DB2 for z/OS stumpers.
Issue 2, 2008
Programmers Only: Optimistic Locking, Part 2
When it comes to DB2 for z/OS locks, a pessimistic approach rarely pays.
Issue 3, 2007
Programmers Only: Optimistic Locking, Part 1
An improvement to this age-old DB2 for z/OS concept helps programmers who look on the bright side.
Issue 1, 2007
REBIND Magic with V8
Issue 4, 2006
Table Spaces and Locking Levels, Part 3
Issue 3, 2006
Table Spaces and Locking Levels, Part 2
Issue 2, 2006
Fetching New Features
Issue 1, 2006
Manage, Don't Tune
Issue 4, 2005
Large Objects Get Bigger
Issue 3, 2005
Say What? Part 4
DB2's three Rs: Reorganize, run statistics, and rebind.
Issue 2, 2005
Table Spaces And Locking Levels, Part 1
Yes, programmers, you do acquire table space and table locks.
Issue 1, 2005
By Popular Demand
What Aunt Louise's grocery shopping method reveals about index usage.
Issue 4, 2004
Programs vs. Utilities Revisited
Utilities in DB2 for z/OS v.8 let you be the hero with very little programming.
Issue 3, 2004
Say What? Part 3
What to do when you find yourself in a bind.
Issue 2, 2004
Say What? Part 2
How the separated twins - modified source code Arnold and DB2 SQL Danny - find each other again.
Issue 1, 2004
Say What?
Plans + DBRMS + Packages + Collections + Versions = Confusion
Issue 4, 2003
Old Dogs, New Tricks
With all the advances in DB2, giving up old habits really pays off.
Issue 3, 2003
Into the Wild (Big) Blue Yonder
From documentary filmmaking to extreme programming, IBM’s lead innovator has always blazed his own trail.
Quarter 4, 2006
REBIND Magic with V8
It takes some time and some nerve, but it’s worth it.
Quarter 4, 2006
Database Cloning
The safe way to run tests and benchmarks on real data.
Quarter 4, 2006
Understanding XML
Your company is probably already using it. It’s time to figure out how to manage it.
Quarter 4, 2006
MultiMedia Management
Certifying in content management shows your information expertise.
Quarter 4, 2006
DB2 9 for z/OS Roars to Life
The mainframe DB2 data server revs up its new hybrid XML/relational engine. Security enhancements, SQL upgrades, and performance improvements complete the package.
Quarter 4, 2006
Under One Roof
Sleek, simple, and efficient, DB2 Data Warehouse Edition 9.1 promises a modern enterprise warehouse without the hassle.
Quarter 4, 2006
Youthful Enthusiasm
One year into his professional career, Anil Mahadev is anything but a novice.
Quarter 3, 2006
Table Spaces and Locking Levels, Part 3
Successful sharing ... with a little help from DSNZPARMs.
Quarter 3, 2006
PHP and IDS
The popular Web-development language provides a powerful and easy way to access Informix data.
Quarter 3, 2006
What's it to You?
DB2's XML support is here. Are you ready to handle it?
Quarter 3, 2006
Parlez-Vous SOA?
Master some SOA fundamentals, connect with your architecture colleagues, and then get building.
Quarter 3, 2006
Asked & Answered
Quarter 3, 2006
Certified Intelligence
The inside intel on passing IBM's DB2-based business intelligence exam.
Quarter 3, 2006
The Rubber Meets the Road
How will DB2 Viper's hybrid XML-relational data server work in the real world? Customers and partners are kicking the tires, revving the engine, and testing performance and handling. Here's what to look for when you take it out for a spin.
Quarter 2, 2006
High Design
In the face of soaring business pressures, DBAs are moving up from simple administrators to become architects of information-based innovation.
Quarter 2, 2006
By Any Other Name
Quarter 2, 2006
Beyond The Default (Part 2)
Quarter 2, 2006
A Memory Mystery
Quarter 2, 2006
Table Spaces and Locking Levels, Part 2
Quarter 2, 2006
Training on the Job
Quarter 2, 2006
Problem Masters
Quarter 2, 2006
Asked & Answered
Quarter 2, 2006
Zooming In On Saturn
DB2 version 8.2.2 introduced new features for SAP users that are as innumerable (and in some cases as invisible to the naked eye) as the rings of Saturn. An SAP/DB2 customer turns his lens on the features he expects will exert the greatest pull for SAP shops.
Quarter 1, 2006
Frequent Flier
Quarter 1, 2006
Staying Power, Part 2
Quarter 1, 2006
Beyond The Default
Quarter 1, 2006
The Biggest Users
Quarter 1, 2006
Fetching New Features
Quarter 1, 2006
Monitoring Tables & Indexes
Quarter 4, 2005
Manage, Don't Tune
Quarter 4, 2005
Asked and Answered
Quarter 4, 2005
User Views
Quarter 4, 2005
Staying Power
Quarter 4, 2005
Split Mirroring
Quarter 4, 2005
Up Start
Quarter 4, 2005
Firing Up The Hybrid Engine
IBM's new hybrid DB2 puts the full power of a relational engine to work on a truly native XML store that sits side by side with DB2's relational data repository.
Quarter 3, 2005
Asked and Answered
Quarter 3, 2005
Getting Together
Quarter 3, 2005
Thanks for the Memory
Quarter 3, 2005
Roll-Forward Recovery
Quarter 3, 2005
Disk Drivers
Quarter 3, 2005
Ms. Fix-It
Quarter 3, 2005
Asked and Answered
Quarter 2, 2005
The Keys To The Database
Quarter 2, 2005
Protecting DB2's Image
Quarter 2, 2005
New Releases of Old Favorites
Quarter 2, 2005
No Lone Star
Quarter 2, 2005
Advise and Consent
Quarter 2, 2005
Measure, Improve, Repeat
Quarter 2, 2005
Achieving New Heights with DB2 UDB Version 8.2.2
Quarter 2, 2005
Make Your Move
Quarter 2, 2005
Asked and Answered
Quarter 1, 2005
Window on the World
The Distributed Data Facility lets DB2 see beyond the mainframe.
Quarter 1, 2005
The Cornerstone Of Crash Recovery
Use DB2's transaction logs to restore your database after a system crash.
Quarter 1, 2005
The View From Outside
Unix utilities give a different look at database server performance.
Quarter 1, 2005
Banking On IT
Surviving and thriving in online trading.
Quarter 1, 2005
Think Of The Possibilities
IBM's Gary Schneider sheds light on how Linux lets pioneering enterprises take their information analysis to places they've never gone before.
Quarter 4, 2004
DB2 ICE: Scaling Data with Linux Clusters
DB2 Integrated Cluster Environment lets you cluster commodity servers for diamond-quality performance at Cubic Zirconia prices.
Quarter 4, 2004
Double Take
Developers took notice when IBM donated 500,000 lines of RDBMS code to an open-source group. Now they can choose between the open-source Apache Derby and its commercial twin, IBM Cloudscape.
Quarter 4, 2004
The Brave (And Secure) New World Of Web Access
Implementing the DB2 Web Query Tool on Linux lets SBC provide access to mainframe and distributed data via a Web browser, while leveraging developer skills, preserving security, and minding the budget. Here's an inside look at how they did it.
Quarter 4, 2004
Monitoring Performance, Part 3
The DB2 UDB Health Monitor and Health center keep an eye on system health so you don't have to.
Quarter 4, 2004
Parlez-Vous BI?
Everything you need to know to talk intelligently about business intelligence.
Quarter 4, 2004
Performance Monitoring, Part 2
Event monitors go beyond the snapshot for performance clues.
Quarter 3, 2004
Taking High Availability Higher
Getting more up time from DB2 UDB for z/OS or OS/390.
Quarter 3, 2004
Six Security Secrets Attackers Don't Want You to Know
How secure is your data? Looking at your information management resources through a would-be intruder's eyes can help you find (and fix) vulnerabilities.
Quarter 2, 2004
Stinger Takes Flight
A new release of DB2 UDB for Linux, Unix, and Windows contains a slew of new features and support for emerging technologies, including Microsoft's answer to Java: the Common Language Runtime.
Quarter 2, 2004
Parlez-Vous DB2 For LUW? (Part 2)
Despite language differences, the DB2 family is united by common concepts.
Quarter 2, 2004
Performance Monitoring, Part 1: It's a Snap(shot)
How do you know where to focus your tuning efforts? Take a picture.
Quarter 2, 2004
Take a Load Off: Archive Inactive Data
A data explosion threatens to bog down, fill up, slow, and generally complicate DBMSs. Archiving data that's rarely accessed lets businesses hold on to the data they need while keeping DB2 performing at top speed.
Quarter 4, 2003
SQl Under the Covers
Ever wonder what happens behind DB2's doors in response to a query? Peek inside to find out.
Quarter 4, 2003
Basic Performance Tuning, Part 2
How to change your instance and database parameters for the best Performance effect.
Quarter 4, 2003
Just the Stats, Ma'am (Part 2)
A DB2 statistics report can be the key to better performance.
Quarter 3, 2003
Basic Performance Tuning
Your platform-specific guide to getting the very best performance from DB2 UDB.
Quarter 3, 2003
Sharing the Load
Balanced workloads, better performance, and increased scalability can be yours — if you handle the data partitioning correctly.
Quarter 3, 2003
Taking Control: DB2 Query Patroller
How do you deal with the conflicting pressures of opening the data warehouse to more users while guaranteeing rapid response times? A preemptive query governor puts you in control of which queries from which users run (and when).
Quarter 2, 2003
Comparing Query Performance: MDC vs. Non-MDC Tables
IBM says the new multidimensional clustering feature in DB2 UDB for Linux, Unix, and Windows will speed complex queries. And they put the new feature to the test. Here's what tests revealed about when MDC really helps (and why).
Quarter 2, 2003
Just the Stats, Ma'am
Statistics reports can reveal surprising facts about the subsystem you thought you knew well.
Quarter 2, 2003
Effective Indexes for Data Warehouses
Creating the right indexes to boost performance is an art. These guidelines will help you master the process.
Quarter 2, 2003
Plugging in to Faster Data Access
As it matures with each release, DB2 provides faster distributed data access. Changes in version 8 take it to a whole new level.
Quarter 2, 2003
The Little Database Engine That Could
When IBM introduced a DB2 for Unix and Windows platforms, its competitors had a huge lead. IBM's Berni Schiefer sheds light on the underdog's impressive rise.
Quarter 2, 2003
The Power of Partitioning
Misconceptions about partitioning abound. Experts from the Toronto Lab set the record straight about this useful feature.
Quarter 2, 2003
The OLAP-Aware Database
RDBMSs have always tuned a fairly blind eye to the kind of relationships important to online analytical processing. That's about to change thanks to new features coming to DB2.
Quarter 2, 2003
Seeing the DB2 Light
A few surprises marked the road from DB2 skeptic to well-known DB2 columnist.
Quarter 1, 2003
Certification Strategies
One of the benefits of DB2 certification is that the certification process acquaints you with the wide range of DB2 resources.
Quarter 1, 2003
You Say CM, I Say DM...
...And then there are ECM and RM. You don't have to call the whole thing off if you know what to expect from each technology.
Quarter 1, 2003
Protecting DB2 Data
Your company's data is one of its most precious resources, and it's facing threats from all sides. Do you know how to protect it?
Quarter 1, 2003
Eight Breakthroughs That Changed DB2 Forever
Today, DB2 is king of the transaction processing hill. These innovations helped push it to the top.
Quarter 1, 2003
Demystifying FFDC Data
Don't let cryptic First Failure Data Capture (FFDC) information scare you. FFDC is one of DB2's most useful diagnostic tools.
Quarter 1, 2003
The Automated Future: Take 2
DB2 Magazine asked Craig S. Mullins, Director of DB2 Technology Planning for BMC Software, to tackle the question of the DBA's future. Read what he told us about the arrival of 'Robo-DBAs' on the data management scene.
Quarter 4, 2002
> Search for more articles on this topic
|
