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