|
NEW:
Thanks
for the Memory by Robert Catterall
A
Guide to DB2 Locking, part 3 by Craig S. Mullins
DB2
for z/OS database design: Principles of peak performance
by Fred Whitlark
Disk
storage access with DB2 for z/OS
Data
Integrity with DB2 for z/OS
ARCHIVED:
A
Guide to DB2 Locking, part 1 by Craig S. Mullins
A
Guide to DB2 Locking, part 2 by Craig S. Mullins
Staying
Power, Part 2 by Robert Catterall
Conserving
Disk Space by Robert Catterall
Assuring
Data Integrity in DB2 by Craig S.
Mullins
A
View Review by Craig S. Mullins
Using
Real Time Statistics (RTS) by Craig S. Mullins
Conserving
Disk Space on the Mainframe? by Robert Catterall
Large
Objects Get Bigger by Roger Miller
Ms.
Fix-It by Kim Moutsos
Using
Nulls in DB2 by Craig S. Mullins
DDF
Vs. CICS
by Robert Catterall
How do you decide between these two viable alternatives in a DB2
for OS/390 environment? You may not have to.
A Data Strategy
for the Enterprise
by Michael L. Gonzales
Tired of data integration problems? This article looks at what it
takes to create an enterprise data strategy.
DB2 and the Procedural DBA
by Craig Mullins
This article discusses these new code-based objects from a DB2 for
OS/390 perspective and suggests a useful re-definition of the role
of a DBA in this changing environment.
Materialized
Query Tables and the Death of Denormalization
by Craig S. Mullins,
craigmullins.com
DB2 V8 offers a very useful new feature known as Materialized Query
Tables (MQTs). Though not exclusively for data warehousing, MQTs can improve the elegance and efficiency of DB2-based
data warehouses.
A Short
Introduction to Lock Avoidance in DB2 for z/OS by
Craig S. Mullins
An Introduction
to DB2 Table Spaces by
Craig S. Mullins
Large Objects and
DB2 by
Craig. S. Mullins
Q&As
on Dates and DB2 by
Craig S. Mullins
DRDA by
Craig Mullins
DB2 Data Type Usage
Tips by
Craig S. Mullins
An Introduction
to Database Design: From Logical to Physical by
Craig S. Mullins
A View to a Kill
by
Craig Mullins
A View Review
by
Craig S. Mullins
DB2 Behind the Scenes by
Craig S. Mullins
Database
Change Management and Schema Evolution in DB2 for z/OS Version 8
by
Craig S. Mullins
Maximize
Access to Relational Data
by
Fred Whitlark
With concurrency, multiple database users can
access data at the same time while maintaining the integrity and
consistency of the data. This article provides some general guidelines
and recommendations for improving concurrency in DB2 for z/OS environments.
An Introduction
to DB2 Indexing by Craig S. Mullins
LOBs Performance
with DB2 for z/OS Version 7 IBM
Corp.
Some recommendations on how to choose the best
options when inserting or loading relatively small LOBs.
Choose the Proper Data Type by
Craig S. Mullins
The most fundamental integrity constraints
applied to data in a database are data type and length. The DBA
must choose the data type and length of each column wisely.
Pros and Cons
of Defining Tablespaces as Locksize
Row in DB2
by ITtoolbox
What DB2 users have to say about the pros and cons to defining all
the tablespaces with Locksize Row.
Compliance’s
Bright Side
by David Beulke,
DB2 Magazine
The latest versions of both DB2 for z/OS and DB2 for Linux, Unix,
and Windows offer enhancements that help organizations comply with
regulatory requirements such as the United
States' Health Insurance Portability
and Accountability Act (HIPAA) and Sarbanes-Oxley Act of 2002.
Unleashing
the Power of Data
by Howard Goldberg,
DB2 Magazine
With its flexible, extensible data warehousing model, Merrill Lynch
shows how IT investments can pay off with cost efficiency and support
for Sarbanes-Oxley compliance efforts and other emerging priorities.
DB2 V8 Online Schema Evolution
by Craig S. Mullins,
zJournal
The process of making more types of database
change possible without requiring objects to be dropped and re-created
is known as online schema evolution.
Where Do You
Want to Go Next?
by Kim Moutsos
Automating the DBA: What IBM's SMART DB2 will mean to the DBA of
the future.
Can I Use SMS for the DB2 Catalog
and Directory Data Sets?
by Robert Catterall
Author Robert Catterall responds.
Pros and Cons of
Defining Tablespaces as Locksize
Row In DB2
by ITtoolbox
FAQ Team
When defining a new major system in DB2 V7.1 on Z/OS, what are the
pros and cons to defining all the tablespaces
with Locksize Row?
DB2 DBA: Virtual
Realities
by Robert Catterall
Remember the days wehn
2GB of virtual storage was excessive? Today, it's a precious resource,
to be managed carefully.
Just the Stats,
Ma'am
by Robert Catterall
About statistics reports: they can deliver more than just a little
knowledge.
Just
the Stats, Ma'am (Part 2)
by Robert Catterall
More about the importance of statistics reports, including logging,
rids, locking activity, and more. (See
part 2.)
Using
LOBs and Extenders in DB2
by Susan Lawson
Author Susan Lawson offers information on how DB2 DBAs can deal
effectively with LOBs and extenders.
Time to Reconsider
SMS
by Robert Catterall
Recent advances in DASD technology are making even the staunchest
critics of DB2's Systems Managed Storage take another look.
DB2
UDB Problem Determination in WebSphere
Environment
by IBM Corporation
Basic information for problem determination from IBM.
The Automated
Future – An Interview with Craig
S. Mullins
Even with the advent of "robo-DBAs,"
DB2 expert Craig Mullins thinks the DBAs of tomorrow will have plenty
to keep them busy.
Architectures
for Clustering: Shared Nothing and Shared Disk
by Craig S. Mullins
Clustering can bring extra computing power and improved availability.
Choosing the architecture that makes sense with your hardware and
software makes all the difference.
Dealing with Non Partitioning
Indexes
by Rob Catterall
What to do when INSERTING into a very large table becomes time consuming
and complex
Using
DB2 Incremental Backup
by Miro Flasza
Discusses one of the most powerful backup improvements for data
warehouses: incremental backup. It provides additional flexibility
in designing a backup strategy for some types of databases environments.
Using TIMESTAMP Columns Versus DATE and TIME Columns
by Craig S. Mullins
Methods for storing this information in each format and a look
at the differences.
DB2 or VSAM?
by Craig S. Mullins
Making
DB2 Case-Insensitive
by Brian Adamache
Case insensitivity is important if you can’t control the data coming
into the database -- basically, in any circumstance in which users
enter data for themselves or when you are loading outside data.
A
Report on DB2 UDB for OS/390 Catalog Migration Performance by
Ching Lee, John Lyle, Mai Nguyen, and Akira Shibamiya
This team responded to a customer's problem by significantly reducing
the time required for a catalog migration and providing a technique
to estimate how long a given migration job would take as a function
of the catalog size.
What is the Architecture of DB2?
by Craig S. Mullins
An overview of the DB2 architecture by DB2 expert Craig Mullins.
|
