Administration Getting Started

Index

A B C D F I J L N O P Q R S T U V

active logs (563)

adding

remote database (658)

remote instance (657)

remote system (656)

Administration Server (369)

administration tools

Administration Server (370)

creating new objects (378)

Journal (640)

opening the Control Center (357)

overview (355)

remote administration (654)

Script Center (638)

setting preferences (366)

where installed (356)

applications (embedded SQL), running (528)

archived logs (566)

authorities (536)

backups

about database backups (554)

choosing a strategy (579)

performing (524)

buffer pools

increasing size of default (613)

overview (427)

check constraints

adding (510)

overview (493)

circular logging (560)

Client Configuration Assistant (655)

columns, defining (463)

concepts map (662)

configuration files

database (431)

database manager (430)

modifying (432)

configuration parameters

database logging (576)

database manager parameters, modifying (606)

database parameters, modifying (604)

modifying (433)

overview (429)

constraints

check (492)

creating an index (505)

creating unique (504)

foreign key (491)

index (495)

NOT NULL (487)

overview (485)

primary key (490)

unique (488)

containers

creating DMS (457)

creating SMS (456)

overview (422)

relation to buffer pool (428)

relation to disks (423)

relation to table space (424)

suggestions (447)

Control Center

Administration Server (371)

contents pane (361)

contents pane toolbar (364)

displaying systems (368)

menu bar (362)

object tree (358)

objects displayed (386)

setting preferences (365)

Systems icon (360)

toolbar (363)

creating

container (455)

database (375), (434)

database, events that occur by default (438)

index (501)

new objects (379)

primary key on existing tables (508)

schema (515)

table (458)

table check contraint (511)

table space (442)

unique constraint (500)

view (543)

data

applying constraints (484)

backing up (522), (552)

check constraint, adding (509)

choosing space for storing (468)

collecting statistics (517)

controlling access (533)

creating a unique constraint (502)

creating an index (503)

enforcing business rules (483)

importing into a table or view (471)

index (496)

loading into a table (478)

primary key, defining on existing tables (506)

recovery situations (545)

replicating (481)

separating different types (591)

triggers (498)

database capacity management

adding more space to a table space (596)

checking available space (DMS) (593)

database design

logical (435)

physical (436)

database managed space (DMS) (416)

database manager (373)

configuration parameters, modifying (608)

database objects

Alert Center (627)

buffer pool (426)

container (421)

definitions (400)

index (392)

monitoring performance (616)

privileges, granting and revoking (541)

privileges, overview (537)

recovery history file (406)

recovery log files (403)

relationship among tables and views (391)

schema (513)

storage-related (409)

system catalog tables (399)

table (387)

table space (411)

unique index (395)

view (389), (542)

databases

adding remote (659)

authorities, granting and revoking (540)

authorities, overview (534)

backing up (523), (553)

backup strategy, choosing (580)

configuration parameters for logging (574)

configuration parameters, modifying (607)

creating (376)

events that occur when created (437)

full restore (584)

index considerations (598)

logs (555)

restore to point in time (586)

system authorities (538)

tuning using Create Database SmartGuide (440)

defining

table columns (464)

definitions map (663)

disk failure (589)

foreign key constraint

importing data

file formats supported (473)

into a table or view (470)

overview (469)

retrieving large objects from separate files (474)

specifying column import options (475)

specifying file formats (472)

index (494)

indexes

collecting statistics (519)

considerations (599)

key (398)

overview (393)

unique (397)

instance (372)

instance, starting and stopping (660)

introduction to DB2 administration (353)

Java, running programs (532)

JDBC, running programs (531)

jobs and scripts

command scripts (644)

creating and saving command scripts (642)

scheduling saved command script (648)

using an existing script (646)

working with jobs (651)

Journal (641)

loading data

into a table (477)

overview (476)

logs

active (557), (562)

archived (565)

circular logging (559)

configuration parameters (575)

off-line archived (571)

online archived (568)

overview (556)

recovery history file (407)

recovery log files (404)

NOT NULL constraint (486)

ODBC

running programs (530)

off-line archived logs (572)

online archived logs (569)

package (439)

performance

adding more space to a table space (597)

addressing problem queries (632)

analyzing simple dynamic SQL statements (635)

checking available space (DMS) (594)

collecting statistics (520)

database configuration parameters (603)

database manager configuration parameters (605)

default buffer pool, increasing size (614)

index considerations (600)

managing initialization overhead (637)

Performance Configuration SmartGuide (610)

Performance Configuration SmartGuide, hints for using effectively (612)

reorganizing tables (601)

performance monitoring

an event at a point in time (622)

an event for a period of time (630)

benefits of the tools (617)

considerations (620)

database objects monitored by the Snapshot Monitor (624)

defining a simple monitor scenario (626)

event types (631)

objects in state of alert (628)

overview (615)

performance variables monitored by the Snapshot Monitor (625)

types of information captured by the Snapshot Monitor (623)

using Snapshot Monitor (621)

using the Event Monitor tools (629)

when to use Event Analyzer (619)

when to use Snapshot Monitor (618)

physical database design considerations (590)

point-in-time recovery (587)

preferences, setting (367)

prerequisites (354)

primary key

defining (466)

defining on existing tables (507)

primary key constraint (489)

privileges (535)

programs (embedded SQL), running (529)

query performance, improving (634)

recovery

active logs (564)

application error (550)

archived logs (567)

circular logging (561)

configuration parameters for roll-forward (577)

disaster (551)

disk failure (588)

from power failure (581)

full database restore (582)

media failure (549)

modifying configuration parameters (578)

off-line archived logs (573)

online archived logs (570)

overview of logs (558)

point in time (585)

situations (546)

system crash or power failure (547)

transaction failure (548)

recovery history file

overview (408)

viewing (526)

recovery log files (405)

relational database (374)

remote administration (653)

replicating data

general procedure (482)

overview (480)

scheduling jobs (650)

schema (514)

Script Center (639)

scripts and jobs

command scripts (645)

creating and saving command scripts (643)

scheduling saved command script (649)

using an existing script (647)

working with jobs (652)

slow queries, improving performance (633)

SmartGuides

Backup Database (383), (525)

Create Database (377), (380)

Create Table (382), (460)

Create Table Space (381), (444)

Performance Configuration (385), (609)

Performance Configuration, hints for using effectively (611)

Restore Database (384), (583)

SQL (embedded) applications, running programs (527)

SQL optimizer (394)

SQL, analyzing statements (636)

statistics about the data

collecting (521)

overview (516)

storage

allocating for a dedicated server (454)

suggestions (446)

storage-related objects (410)

suggestions for

containers (451)

storage (450)

table spaces (452)

tables (453)

system authorities (539)

system catalog tables (401)

system managed space (SMS) (415)

Systems icon (359)

table spaces

adding more space (595)

checking available space (DMS) (592)

creating (443)

database managed space (DMS) (414)

default USERSPACE1 (445)

long (419)

overview (413)

regular (417)

suggestions (448)

system managed space (SMS) (412)

temporary (418)

types (420)

tables

choosing space for storing data (467)

collecting statistics (518)

creating (459)

creating a check contraint (512)

defining a primary key (465)

identifying a schema name (461)

loading data into (479)

overview (388)

relation to table spaces (425)

reorganizing (602)

selecting columns (462)

suggestions (449)

system catalog (402)

terminology map (661)

trigger (497)

troubleshooting, basic introduction (664)

tuning a database (441)

unique constraint (499)

unique index (396)

views

creating (544)

overview (390)

[ Top of Page | Previous Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]