T

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Z]

Table spaces
     backup
     container tags
    containers
         adding 2nd 3rd 4th 5th
         description
         DMS (database-managed space) 2nd
         SMS (systemmanaged space) 2nd 3rd
     creating 2nd 3rd
     default 2nd
     definition 2nd 3rd
     DMS (database-managed space) 2nd
     DPF
     dropping 2nd
     enlarging 2nd 3rd 4th 5th
     extents 2nd
     file extensions
     highwater mark
     information snapshots 2nd 3rd 4th 5th 6th
     large
     listing 2nd 3rd 4th 5th 6th
     long 2nd
     multipartition environment 2nd
     pages
     privileges 2nd
     quiescing
     recovery 2nd
     regular
     roll forward recovery 2nd
     shrinking 2nd 3rd 4th
     sizing
     SMS (systemmanaged space) 2nd 3rd
     specifying 2nd
     striping 2nd
     system
     temporary
     types of 2nd 3rd
     user
Tables
    automatic value generation [See databases, views]
    check constraints
        definition [See databases, views]
        enforcing data integrity [See databases, views]
    classification [See databases, views]
    collocation [See databases, views]
    columns
        changing [See databases, views]
        combining [See databases, views]
        delimiter character [See databases, views]
        delimiter, changing [See databases, views]
        derived [See databases, views]
        derived from other columns [See databases, views]
        generated [See databases, views]
        identity [See databases, views]
        intersecting values [See databases, views]
        names, specifying [See databases, views]
        removing [See databases, views]
        selecting for import [See databases, views]
        unique identifiers [See databases, views]
    compression [See databases, views]
    creating
        based on another table [See databases, views]
        from query results [See databases, views]
        in a given table space [See databases, views]
        temporary [See databases, views]
        user tables [See databases, views]
    data types, changing [See databases, views]
    default values [See databases, views]
    definition [See databases, views]
    dropping [See databases, views]
    empty cells [See databases, views, Tables;NULL values]
    emptying [See databases, views]
    exception [See databases, views]
    expressions [See databases, views]
    functions [See databases, views]
    joining [See databases, views]
    loading [See databases, views, data movement utilities]
    locking [See databases, views, lock, locking, locks]
    locks [See databases, views]
    MDC (multidimensional clustering)
        block indexes [See databases, views]
        block maps [See databases, views]
        cells [See databases, views]
        choosing dimensions [See databases, views]
        composite block indexes [See databases, views]
        defining [See databases, views]
        definition [See databases, views]
        description [See databases, views]
        dimension block indexes [See databases, views]
        slices [See databases, views]
    MQTs (materialized query tables) [See databases, views]
    not logged initially [See databases, views]
    NULL values [See databases, views]
    privileges [See databases, views]
    reorganizing [See databases, views]
    reorganizing data for performance [See databases, views]
    rows
        counting in result sets [See databases, views]
        delimiter character [See databases, views]
        eliminating duplicates [See databases, views]
        grouping [See databases, views]
    rows, retrieving
        adding to result sets [See databases, views]
        between specified values [See databases, views]
        by distinct values [See databases, views]
        by specified values [See databases, views]
        first n [See databases, views]
        higher than n [See databases, views]
        in specified order [See databases, views]
        maximum of n [See databases, views]
    rules for data [See databases, views, tables, constraints]
    sequences
        case study [See databases, views]
        definition [See databases, views]
        description [See databases, views]
    space containers [See databases, views]
    space high water marks [See databases, views]
    space states [See databases, views]
    states [See databases, views]
    summary [See databases, views]
    system catalog [See databases, views]
    temporary [See databases, views]
    user [See databases, views]
Tables, constraints
     case study 2nd
     check 2nd 3rd
     enforcing 2nd 3rd 4th 5th
     foreign key 2nd 3rd
     informational 2nd 3rd 4th
     primary key 2nd 3rd
     referential 2nd 3rd 4th
    referential integrity
         establishing 2nd 3rd
         SQL implications 2nd 3rd 4th
     unique 2nd
     unique key 2nd 3rd
Task Center 2nd 3rd
Tasks
TCP/IP (Transmission Control Protocol/Internet Protocol)
TCP/IP port
TCP/IP problems, troubleshooting 2nd 3rd 4th 5th 6th 7th 8th 9th
Temporary table spaces 2nd
Temporary tables 2nd 3rd
TEMPSPACE1 2nd
terminate command 2nd
Territory codes
Text Extender
Thin clients
Threads, EDUs 2nd
Throttled utilities
Timerons 2nd
timestampformat modifier
Timestamps 2nd
Tivoli brand 2nd
Tivoli Storage Manager (TSM)
Tools and utilities
    Activity Monitor [See troubleshooting]
        troubleshooting locking problems [See troubleshooting]
    case study [See troubleshooting]
    Check for DB2 Updates option [See troubleshooting]
    CLP (Command Line Processor)
        ! (exclamation mark), escape character [See troubleshooting]
        " (double quotes), command delimiters [See troubleshooting]
        # (pound sign), comment delimiter [See troubleshooting]
        + (plus sign), turning off CLP options [See troubleshooting]
        - (dash), turning on CLP options [See troubleshooting]
        ; (semicolon), terminator character [See troubleshooting]
        ? (question mark), help request [See troubleshooting]
        \ (backslash), CLP line continuation [See troubleshooting]
        autocommit, disabling [See troubleshooting]
        back-end process [See troubleshooting]
        command options [See troubleshooting]
        comments [See troubleshooting]
        definition [See troubleshooting]
        disconnect statement [See troubleshooting]
        echoing commands [See troubleshooting]
        edit command [See troubleshooting]
        file permissions [See troubleshooting]
        files as input [See troubleshooting]
        front-end process [See troubleshooting]
        help information [See troubleshooting]
        history command [See troubleshooting]
        interactive mode [See troubleshooting]
        line continuation [See troubleshooting]
        modes [See troubleshooting]
        noninteractive mode [See troubleshooting]
        rem command [See troubleshooting]
        removing database connections [See troubleshooting]
        reset statement [See troubleshooting]
        resetting default values [See troubleshooting]
        runcmd command [See troubleshooting]
        terminate command [See troubleshooting]
        v (verbose) option [See troubleshooting]
        versus Command Window [See troubleshooting]
        wrapping lines [See troubleshooting]
    collecting diagnostic information [See troubleshooting]
    Command Editor
        access plans, displaying [See troubleshooting, Visual Explain]
        DB2 Optimizer [See troubleshooting]
        overview [See troubleshooting]
        starting [See troubleshooting]
        Visual Explain tool [See troubleshooting]
    Command Window
        overview [See troubleshooting]
        starting [See troubleshooting]
        versus (Command Line Processor) [See troubleshooting]
    Configuration Assistant [See troubleshooting]
    configuring database connections [See troubleshooting, Add Database Wizard, CA (Configuration Assistant]
    DB2 [See troubleshooting]
    db2dart [See troubleshooting]
    db2pd tool [See troubleshooting]
    DB2SUPPORT tool [See troubleshooting]
    Development Center [See troubleshooting]
    development tools [See troubleshooting]
    displaying access plans [See troubleshooting]
    Event Analyzer [See troubleshooting]
    Event Monitor
        performance [See troubleshooting]
        troubleshooting locking problems [See troubleshooting]
    First Steps [See troubleshooting]
    general administration [See troubleshooting]
    General Administration Tools
        Basic view [See troubleshooting]
        Contents pane [See troubleshooting]
        Control Center [See troubleshooting]
        Custom view [See troubleshooting]
        Journal tool [See troubleshooting]
        Object Details pane [See troubleshooting]
        Replication Center [See troubleshooting]
        Task Center [See troubleshooting]
    Health Center [See troubleshooting]
    IBM DB2 menu [See troubleshooting]
    IMS [See troubleshooting]
    Indoubt Transaction Manager [See troubleshooting]
    Information Center [See troubleshooting]
    information management products [See troubleshooting]
    Information menu
        Check for DB2 Updates option [See troubleshooting]
        Information Center [See troubleshooting]
    information tools [See troubleshooting]
    INSPECT [See troubleshooting]
    inspecting a database [See troubleshooting]
    Journal tool [See troubleshooting]
    License Center [See troubleshooting]
    Memory Visualizer [See troubleshooting]
    monitoring tools [See troubleshooting]
    Project Deployment Tool [See troubleshooting]
    Register Visual Studio AddIns [See troubleshooting]
    Register Visual Studio AddIns menu [See troubleshooting]
    Replication Center [See troubleshooting]
    Satellite Administration Center [See troubleshooting]
    scheduling tasks [See troubleshooting]
    Setup tools [See troubleshooting]
    Snapshot Monitor
        performance [See troubleshooting]
        troubleshooting locking problems [See troubleshooting]
    SQL Assist [See troubleshooting]
    Task Center [See troubleshooting]
    tool settings [See troubleshooting]
    tracking error messages [See troubleshooting]
    troubleshooting [See troubleshooting]
    utilities, definition [See troubleshooting]
    Visual Explain [See troubleshooting]
Tools catalog 2nd 3rd 4th 5th
Tools metadata
tpm keyword
Trace facility
Tracking error messages
TRACKMOD parameter 2nd
Training
    books and publications [See resources]
    computer-based training [See resources]
    conferences [See resources]
    course offerings [See resources]
    e-mail services [See resources]
    IBM business partners [See resources]
    IBM certification program [See resources]
    news groups [See resources]
    periodicals [See resources]
    technical resources [See resources]
    tutorials [See resources]
    user groups [See resources]
    Web sites in this book [See resources]
Transaction logs
    active log directory [See recovery]
    active logs [See recovery]
    archival logging [See recovery]
    circular logging [See recovery]
    database configuration parameters [See recovery]
    handling [See recovery]
    infinite active logging [See recovery]
    log disk full condition [See recovery]
    log full condition [See recovery]
    log space [See recovery]
    logging methods [See recovery]
    offline archive logs [See recovery]
    online archive logs [See recovery]
    overview [See recovery]
    primary log files [See recovery]
    secondary log files [See recovery]
    size of log space [See recovery]
    states of logs [See recovery]
    user exit [See recovery]
Transaction managers
Transactions 2nd 3rd
     UOW (unit of work)
Transactions page 2nd 3rd
Transition tables 2nd 3rd
Transition variables
Transmission Control Protocol/Internet Protocol (TCP/IP)
Trap files
Triggers
     after trigger
     AFTER triggers 2nd
     before trigger
     BEFORE triggers 2nd
     CREATE TRIGGER statement
     creating
     definition 2nd
     description 2nd 3rd
     inoperative
     insert trigger
     INSTEAD OF triggers 2nd
     temporary tables
Troubleshooting
    Activity Monitor [See books and publications, online resources, resources, tools and utilities]
    administration notification log [See books and publications, online resources, resources, tools and utilities]
    case study [See books and publications, online resources, resources, tools and utilities]
    Check for DB2 Updates option [See books and publications, online resources, resources, tools and utilities]
    client-server TCP/IP problems [See books and publications, online resources, resources, tools and utilities]
    core files [See books and publications, online resources, resources, tools and utilities]
    db2diag.log [See books and publications, online resources, resources, tools and utilities]
    DB2SUPPORT tool [See books and publications, online resources, resources, tools and utilities]
    diagnosing problems [See books and publications, online resources, resources, tools and utilities]
    dump files [See books and publications, online resources, resources, tools and utilities]
    e-mail notification [See books and publications, online resources, resources, tools and utilities]
    error messages [See books and publications, online resources, resources, tools and utilities]
    Event Analyzer [See books and publications, online resources, resources, tools and utilities]
    FFDC (first-failure data capture)
        default error level for logging [See books and publications, online resources, resources, tools and utilities]
        description [See books and publications, online resources, resources, tools and utilities]
        DIAGLEVEL parameter [See books and publications, online resources, resources, tools and utilities]
        DIAGPATH parameter [See books and publications, online resources, resources, tools and utilities]
        error messages, logging [See books and publications, online resources, resources, tools and utilities]
        fully qualified path [See books and publications, online resources, resources, tools and utilities]
        NOTIFYLEVEL parameter [See books and publications, online resources, resources, tools and utilities]
        related parameters [See books and publications, online resources, resources, tools and utilities]
    Health Center [See books and publications, online resources, resources, tools and utilities]
    IBM DB2 menu [See books and publications, online resources, resources, tools and utilities]
    Indoubt Transaction Manager [See books and publications, online resources, resources, tools and utilities]
    information tools [See books and publications, online resources, resources, tools and utilities]
    Journal tool [See books and publications, online resources, resources, tools and utilities]
    known problems [See books and publications, online resources, resources, tools and utilities]
    Memory Visualizer [See books and publications, online resources, resources, tools and utilities]
    monitoring tools [See books and publications, online resources, resources, tools and utilities]
    Project Deployment Tool [See books and publications, online resources, resources, tools and utilities]
    Register Visual Studio AddIns menu [See books and publications, online resources, resources, tools and utilities]
    Replication Center [See books and publications, online resources, resources, tools and utilities]
    reporting problems [See books and publications, online resources, resources, tools and utilities]
    Satellite Administration Center [See books and publications, online resources, resources, tools and utilities]
    setup tools [See books and publications, online resources, resources, tools and utilities]
    SQL Assist [See books and publications, online resources, resources, tools and utilities]
    Task Center [See books and publications, online resources, resources, tools and utilities]
    trace facility [See books and publications, online resources, resources, tools and utilities]
    tracking error messages [See books and publications, online resources, resources, tools and utilities]
    trap files [See books and publications, online resources, resources, tools and utilities]
    Visual Explain [See books and publications, online resources, resources, tools and utilities]
    with processes [See books and publications, online resources, resources, tools and utilities]
Truncation
TRUST_ALLCLNTS parameter 2nd 3rd 4th 5th 6th
TRUST_CLNTAUTH parameter 2nd 3rd 4th 5th 6th
Trusted clients 2nd 3rd 4th 5th 6th 7th
Try and Buy
TSM (Tivoli Storage Manager)
Tuning
     agents 2nd 3rd
     EDUs 2nd
Tuple
Twophase commit
Typed tables
Typical installation