These articles are geared toward beginning users. The DB2 basics series introduces fundamental topics and provides a walk-through of situations often encountered by the first time user.
DB2 9 Fundamentals 730 exam prep
tutorials
Get ready for DB2 9
certification with this introduction to SQL, the basics of
creating databases and objects, security, and transaction
isolation.
Understand how authorities and privileges are
implemented in DB2 UDB
Confused about
how to grant access and administer authority levels and
privileges in DB2 UDB? Part 4 in a series on security, this
article makes it all clear.
DB2 Basics: An introduction to materialized
query tables
Roman Melnyk takes the
mystery out of MQTs, specialized tables that that can
significantly improve the performance of complex queries. In
addition, he introduces staging tables and summary tables and
explains their use and benefits.
How users and groups interact with DB2
UDB
Need to understand how users and
groups authenticate with DB2 UDB, and then how they obtain
authorization to perform actions on your database? Our authors
make it all clear.
Introducing DB2 UDB structured data types and
typed tables
Learn the basic concepts
of structured data types, type hierarchies, and typed tables
and explore working examples that will get you up and running.
DB2 Basics: Introduction to the DB2 UDB SQL
administrative routines
The DB2 UDB
SQL administrative routines represent an easy-to-use API to
DB2 administrative functions through SQL. Working examples
show you how to use some of these routines, which can be
invoked from a DB2 command line, a command script, or an
application containing embedded SQL.
DB2 Basics: DB2 UDB command line
processor
Explore the three modes in
which the command line processor operates, get a detailed
explanation of the db2 command, and learn about some recent
usability enhancements to this handy interface to DB2 UDB
functions. Includes info on the Command Editor too.
Unlock the secrets surrounding the locking
behavior of the DB2 UDB data movement
utilities
Export, import and load
place locks on database resources in order to support various
levels of concurrency. This article describes the locking
behaviour of these utilities and shows you, through working
examples, how to use tools such as the DB2 UDB snapshot
monitor to view and acquire a better understanding of this
behavior.
The DB2 UDB Backup Utility: A
primer
Understand the latest, newest
features of DB2 UDB backup. This article includes the backup
process model, details on the various types of both online and
offline backup, hints and tips on backing up using Tivoli
Storage Manager, and info on self-tuning capabilities, as well
as the whys and wherefores of a well-planned backup strategy.
DB2 Basics: How to get useful information
from the DB2 UDB system catalog
This
article introduces the DB2 UDB system catalog and shows how
this rich repository of database information can be put to
good use.
DB2 Basics: An introduction to the DB2 UDB
trace facility
This article
introduces the fundamentals of the DB2 UDB trace facility and
shows you by way of working examples how to use the db2trc
command to capture trace information.
DB2 Basics: Demystifying table and table
space states
DB2 uses table and table
space states to control access to data or to help protect the
integrity of the database. This article describes these states
and shows you, by way of working examples, typical conditions
under which they appear, and how to respond to them.
More DB2 basics articles
- DB2 Basics: Exploit file type modifiers that are built into the DB2 data movement utilities
- DB2 Basics: Use DB2 utilities to clone databases across different platforms
- DB2 Basics: Constraints
- DB2 Basics: Creating Your First Trigger in DB2 Universal Database
- DB2 Basics: Table Spaces and Buffer Pools
- DB2 Basics: Fun with Dates and Times
- DB2 Basics: Cloning DB2 Databases Using Redirected Restore
- Getting Started with DB2 V8 and ADO using Visual Basic 6
- More DB2 basics