DB2 Administration All-in-One Exam Guide

part 1 db2 certification

chapter 1 db2 universal database professional certification

the professional certification program from ibm

db2 universal database certification roles

ibm certified specialist-db2 udb v6/v7 user

ibm certified solutions expert-business intelligence

ibm certified solutions expert-db2 udb v7.1 database

adiministration for unix,windows,and os/2

ibm certified solutions expert-db2 udb v7.1

family application development

ibm certified solutions expert-db2 udb v7.1

database administration for os/390

ibm certified advanced technical expert-db2 for clusters

ibm certified advanced technical expert-db2-drda

ibm certified advanced technical expert-db2 data replication

the certification process

preparing for the tests

the testing procedure

benefits professional certification provides

summary

.part ii db2 udb fundamentals(tests 509 and 512)

chapter 2 installation and planning

the db2 universal database family

db2 universal database products

db2 universal database clients

other db2 universal database products

db2 universal database packages

db2's administration tools

the control center

the command center

the script center

the alert center

the journal

the command line processor(clp)

the performance monitor

the client configuration assistant(cca)

summary

questions

answers

chapter 3 instances and security

instances

the db2 administration server(das)instance

controlling database access

authentication

authorities

privileges

granting and revoking authorities and privileges

summary

questions

answers

chapter 4 creating and accessing db2 database and db2 database objects

the relational database model

what is a db2 universal database database?

creating a db2 universal database database

destroying a db2 universal database database

the db2 universal database directory files

uncataloging a db2 universal database database

cataloging a db2 universal database database

understanding ojbects

system objects

recovery objects

storage objects

database(or data)ojbects

summary

questions

answers

chapter 5 creating table ojbects

understanding data types

small integer

integer

big integer

decimal

single-precision floating point

double-precision floating point

fixed-length character string

varying-length character string

varying-length long character string

fixed-length double-byte character string

varying-length double-byte character string

varying-length double-byte long character string

date

time

timestamp

binary large object

character large object

double-byte character large ojbect

datalink

user-defined data types(udts)

extenders

understanding constraints

the not null constraint

the column default constraint

unique constraints

referential constraints

check constraints

the create table sql statement

create table sql statement examples and resulting table characteristics

system catalog tables

summary

questions

answers

chapter 6 basic sql

structured query language(sql)

data definition language(ddl)statements

creating nodegroups-the create nodegroup statement

creating buffer pools-the create bufferpool statement

creating tables-the create tablespace statement

creating views-the create table statement

creating views-the create view statement

creating indexes-the create index statement

creating schemas-the create schema statement

creating aliases-the create alias statement

describing an object-the comment on statement

dropping an object-the drop statement

modifying object definitions

data manipulation language(dml)statements

retrieving data-the select statement and its clauses

adding data-the insert statement

changing data-the update statement

deleting data-the delete statement

summary

questions

answers

chapter 7 database concurrency

what is data consistency?

transactions

concurrency and isolation levels

repeatable read

read stability

cursor stability

uncommitted read

specifying the isolation level

choosing the proper isolation level

locking

lock attributes and lock states

lock compatibility

lock conversion

lock escalation

deadlocks

lock waits and timeouts

how locks are acquired

factors that affect locking

summary

questions

answers

part iii db2 udb administration(tests 513)

chapter 8 server management

instances

attaching to an instance

detaching from an instance

the db2 administration server(das)instance

distributed connections

configuring communications

db2 discovery

controlling database access-revisited

authentication

a word about users and groups

authorities

privileges

granting and revoking authorities and privileges

taking control of a server to perform maintenance operations

scheduling maintenance with the journal

summary

questions

answers

chapter 9 data placement

creating a db2 universal database database-a review

the db2 universal database storage model

buffer pools

table spaces

containers

basic buffer pool and table space requirements

characteristics that affect table space performance

page size

extent size

prefetch size

obtaining information about existing table spaces

table space states

obtaining information about table space containers

altering an existing table space

summary

questions

answers

chapter 10 data access

tables-a review

views

types of views

imposing restrictions on views with the with check option clause

indexes and constraints

indexes-a review

understanding constraints

unique(and nonunique)indexes

referential constraints revisited

examples of referential constraints

improving performance with a clustering index

system catalog tables and views

using the script center

an alternative method for viewing information stored in tables and views

reverse-engineering a database with db2look

expanding a database's boundaries with federated systems

summary

questions

answers

chapter 11 monitoring database activity

the database system monitor

the snapshot monitor

event monitors

the performance monitor

starting,stopping,and viewing the performance monitor

sending messages to the journal

a word about the query patroller tracker

monitoring sql behavior

the explain faciity

configuring database and database manager resources

viewing the db2 database manager's configuration

viewing a database's configuration

changing the value of a db2 database manager configuration parameter

changing the value of a database's configuration parameter

changing the value of a db2 registry or environment variable

summary

questions

answers

chapter 12 db2 universal database's data movement and data management utilities

db2 universal database's data movement utilities

supported file formats

obtaining columnar data from external files

the export utility

the import utility

the load utility

the db2move utility

db2 universal database's data maintenance utilities

the reorganize check utility

the reorganize table utility

the run statistics utility

summary

questions

answers

chapter 13 database recovery and maintenance

transaction logging

circular logging

archival logging

returning a database to a consistent state

managing database recovery

creating a backup image of a database

the recovery history file

restoring a database(or a table space)from a backup image

roll-forward recovery

rebuilding invalid indexes

configuration parameters that affect logging and data recovery

summary

questions

answers

chapter 14 problem determination

common types of errors

error codes

viewing error messages

first failure data capture(ffdc)information

the db2diag.log file

interpreting db2diag.log entry headers

interpreting sqlcad data structure value entries

interpreting hexadecimal codes

locating failed objects

an example scenario

summary

questions

answers

appendix a system catalog views

appendix b bibliography