T

Table check, 605

Table check constraints, 378, 457. See also CHECK constraints

Table functions, external, 229, 330

Table partitioning, 43, 609

Table spaces, 11, 107, 108, 109, 112, 169, 174–175

authorities and privileges using, GRANT and, 128

authorities and privileges using, REVOKE and, 138

containers for, 174–175

database-managed (DMS), 174, 175

privileges available with, 114, 114

setting parameters of, 175–175

SYSCATSPACE, 115

system-managed (SMS), 174, 175

USE privilege and, 114

Tables, 9, 192, 196–203, 197, 244, 365, 401–418, 445, 447, 455–456, 592, 609, 610

ALTER TABLE and, 416

authorities and privileges using, 152, 153, 158

authorities and privileges using, GRANT and, 129

authorities and privileges using, REVOKE and, 139

base, 197

cataloging, 582

Check Pending state of, 399–401

columns and rows in, 196, 403–409

common table expressions and, 289–291, 360–361

Control Center granting/revoking of privileges for, 126, 126

Control Center to create, 201–202, 201, 202, 401

CREATE TABLE for, 198–201, 198–200t, 402, 419–427. See also CREATE TABLE

Create Table Wizard for, 201–202, 201, 202, 401

CREATETAB privilege and, 113, 127, 137, 157, 171, 574, 577

data concurrency and, 470

data type definitions for, 198–200t, 404–405t

Database Manager defined, 197

DECLARE GLOBAL TEMPORARY TABLE for, 203, 428, 431, 432, 610

declared temporary, 197, 202–203, 245, 250, 428–432, 453, 463, 585, 586, 610. See also declared temporary tables

duplicate, creation of, 417, 601

fields in, 196

identity columns in, 218, 583, 411–413, 455, 601

indexes and, 214

inner joins in, 298–301, 300, 354, 355–356, 588, 589–590

joining, using SELECT, 295–306. See also joining tables, 295

locks and, 483

materialized query (MQT), 9, 14, 39, 43, 80, 81, 197, 568, 585

outer joins in, 298, 301–306, 354, 357, 588, 591, 592, 595. See also outer joins

ownership of, privileges and, 117

parent and child, 365

partitioned, 413–416, 462

ALTER TABLE, 416

ATTACH/DETACH PARTITION in, 416

roll-in and roll-out of data using, 416

privileges available with, 115–117, 116, 126, 126

records in, 196

referential integrity constraints in, 409–410

reorganizing with REORG, 4, 7, 438, 570

result, 197

schemas and, 192, 193, 418–419, 418

triggers and, 220, 438

typed, 198

user-defined, 197, 198

VALIDATED predicate and, 410–411

views in, 150, 151

XML columns in, 410–411

XMLVALIDATED() and, 410–411

Taking certification exams, 19–34

Close button in, 26

End button in, 30

Exam results panel in, 32, 32

Exhibit button in, 25, 26

Exit button in, 21

Help button in, 21, 25, 29

identification requirements for, 19

illustrations/exhibits in, 25–26, 26, 27

Mark button in, 28

Mark checkboxes in, 23

multiple-answer questions in, 25, 25

Previous/Next question buttons in, 24, 25, 29

question panel in, 22–23, 22

Review Incomplete/Review Marked buttons in, 29–30

Review Item button in, 29–30

reviewing items in, 27–30, 28, 30

section scores panel in, 33, 33

Start button in, 21, 22

Tile button in, 26

Time Remaining dialog in, 23–24, 23

title screen in, 20–21, 20

Warning dialog for end of exam in, 30, 30

TARGET PRINCIPAL, 581

Task Center, 71–72, 72, 94, 569, 570

Task History, Journal, 75–76, 76

TCP/IP, 52, 181, 243

Template functions, 229, 330

Temporary suspension of constraints, using SET INTEGRITY, 398–401, 398

Temporary tables. See declared temporary tables, 428

TEMPSPACE1, 169

TERM UTILITY, 7

Territory, SQL and, 173

Text Extender, 55, 56, 572

Thompson Prometric, 17, 19

Time (TIME), 199, 370, 601

Time Remaining dialog, in IBM Certification exam, 23–24, 23

Time. See date/time data types

Timeouts, locks and, 492

Timestamp (TIMESTAMP), 199, 370–371, 601

Title screen, IBM Certification exam, 20–21, 20

Tivoli System Automation for Multiplatforms (TSA MP), 39, 43

Token values, INSERT and, 259–260

Tool set for DB2 9, 35, 60–85

Command Editor in, 66–71, 67

Command Line Processor (CLP) in, 60, 82–83, 83

Configuration Assistant in, 77–78, 78, 93

Control Center in, 61–64, 62, 63, 64. See also Control Center

Design Advisor in, 13, 78–81, 81, 88, 93, 568

Developer Workbench in, 10, 83–84, 85, 89, 94, 569, 570

graphical user interface (GUI) in, 60

Health Center in, 72–75, 74

Journal in, 75–76, 76, 90, 94

License Center in, 76, 77

Replication Center in, 64, 65

Satellite Administration Center in, 65–66

SQL Assist tool in, 66, 67–68, 68

Task Center in, 71–72, 72, 94

Visual Explain in, 68–71, 69

Trace, 6, 9, 108

Trademark, Professional Certification, 34

Transaction logging, 4

Transactions and transaction boundaries, 255, 322–329, 350, 351, 361, 596–597

atomic nature of, 322

automatic commit feature and, 322

autorestart and, 326

change, 486t

COMMIT and, 322–326, 323, 325, 361

cursor-controlled, 486t

data concurrency and, 322, 325, 466

data consistency and, 322

Database Manager and, 326

DELETE and, 326

intent-to-change, 486t

interleaved or parallel, 467

isolation levels and, 325

locks associated with, 486–487, 486t

read-only, 486t

RELEASE SAVEPOINT and, 327–328, 329

ROLLBACK and, 322–326, 324, 325, 327, 361, 362

ROLLBACK TO SAVEPOINT and, 329

SAVEPOINT and, 327

savepoints and, 236, 326–329, 362, 597

SQL and, to manage, 256

Uncommitted Read isolation level and, 325, 468, 469t, 474–476, 475, 498, 499, 501, 610, 611, 613

UPDATE and, 326

TRANSFER OWNERSHIP, 111

Transition tables/transition variables, triggers and, 221, 439

Transmission control protocol/Internet protocol. See TCP/IP

Triggers, 9, 192, 220–225, 246, 251, 365, 438–443, 451, 461, 582, 583, 584, 586, 602, 608

action of, 221, 439

activation time for, 220–221, 438–439

AFTER, 220–221, 439, 440, 442

BEFORE, 220–221, 438–439, 440

business rule enforcement using, 220

cascading of, 225

Control Center to create, 223, 224

Create Trigger dialog to create, 223, 224

CREATE TRIGGER for, 221–223, 223t, 439–443

data integrity rule enforcement using, 220

Data Manipulation Language (DML) operations and, 225

DELETE and, 225

event for, 220, 438, 441

granularity of, 221, 439

INSERT and, 225

INSTEAD OF, 220–221, 439, 440

rows affected by, setting, 221, 439

table/view associated with, 438

tables using, 220

transition variables, transition tables and, 221, 439

UPDATE and, 225

views using, 220

TRUE/FALSE/Unknown, 603, 609

CASE expressions and, 295

CHECK constraints and, 378–379, 379, 457

SELECT and, 272, 284

VALIDATED and, 411

Trusted context, 50

Trusted vs. untrusted clients, 102–103

Tuning memory, 11

Typed tables, 198