C


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]

CA (Configuration Assistant)
    configuring connections
        manually [See Add Database Wizard]
        with access profiles [See Add Database Wizard]
    definition [See Add Database Wizard]
    illustration [See Add Database Wizard]
    uses for [See Add Database Wizard]
Caches
Caching 2nd
Call-level interface (CLI) 2nd 3rd 4th
Cardinality
Cascade delete
CASCADE rule
CASE expression 2nd 3rd 4th
Case sensitivity
     case-insensitive search
     DB2 commands
     requirements 2nd
     SQL statements
Case studies
    agents [See examples]
    backup [See examples]
    careers in DB2 [See examples]
    configuring database connections [See examples]
    configuring databases [See examples]
    connection concentrator [See examples]
    connectivity [See examples]
    creating databases [See examples]
    data movement utilities [See examples]
    database configuration file [See examples]
    database objects [See examples]
    DB2 environment [See examples]
    DPF (database partitioning feature) [See examples]
    indexes [See examples]
    installing DB2 [See examples]
    locking [See examples]
    memory [See examples]
    partitions [See examples]
    performance [See examples]
    process model [See examples]
    querying data [See examples]
    recovery [See examples]
    security [See examples]
    sequences [See examples]
    table constraints [See examples]
    tools and utilities [See examples]
    troubleshooting [See examples]
Case-insensitive search
CAST expression
Cast functions
Casting
     data types
     functions 2nd
Catalog (SYSCATSPACE) table space
catalog database command 2nd
catalog db command
catalog DCS database command
Catalog nodes
Catalog partitions 2nd
Catalog tables
catalog TCPIP node command
Catalog views
Catalogs
CDB (communications database)
Cells 2nd
CHAR (character) data type 2nd
Character (CHAR) data type 2nd
Character conversions
Character delimiter, changing
Character large object (CLOB) [See CLOB (character large object]
Character sets
Character string delimiters
Character strings
chardel modifier
CHECK clause
Check condition
Check constraints
     definition
     enforcing data integrity 2nd
Check for DB2 Updates option 2nd 3rd 4th
Check integrity
Check pending
Checkpoints
CHNGPGS_THRESH parameter
Circular logging 2nd 3rd 4th
Clauses
CLI (call-level interface) 2nd 3rd 4th
CLIENT authentication 2nd
Client instances 2nd
Client profiles
Clients
     administration
     application development
     definition 2nd
     dumb terminal
     local
     remote
     runtime
     thin
     types of 2nd
CLNT_PW_PLUGIN parameter 2nd
CLOB (character large object)
     definition
     description
     exporting 2nd
Cloning a database 2nd [See also backups, Databases;relocating]
CLP (Command Line Processor)
     ! (exclamation mark), escape character
     " (double quotes), command delimiters 2nd 3rd
     # (pound sign), comment delimiter 2nd 3rd 4th
     + (plus sign), turning off CLP options
     - (dash), turning on CLP options
     ; (semicolon), terminator character
     ? (question mark), help request 2nd 3rd
     \ (backslash), CLP line continuation 2nd 3rd 4th
     autocommit, disabling
     back-end process 2nd
     command options 2nd 3rd 4th
     comments 2nd 3rd 4th 5th
     definition 2nd
     disconnect statement 2nd
     echoing commands 2nd
     edit command
     file permissions 2nd
     files as input 2nd 3rd 4th 5th 6th 7th
     front-end process 2nd
     help information 2nd 3rd
     history command
     interactive mode 2nd
     line continuation 2nd 3rd 4th
     modes 2nd 3rd 4th 5th 6th 7th 8th 9th 10th
     noninteractive mode 2nd 3rd 4th 5th 6th 7th
     rem command 2nd 3rd
     removing database connections 2nd
     reset statement 2nd
     resetting default values
     runcmd command
     starting
     terminate command 2nd
     v (verbose) option 2nd
     versus Command Window 2nd 3rd 4th 5th
     wrapping lines 2nd 3rd 4th
CLP commands
Clustered index
Clustering block index
Clustering indexes 2nd
COALESCE function 2nd
Code pages 2nd
Code points
Code sets
Code updates (FixPaks) 2nd 3rd 4th
Coded character sets
codepage modifier
coldel modifier
Collating sequence
Collocated joins 2nd
Column distribution value
Columns
     adding 2nd
     changing 2nd
     data
     delimiter, changing
     delimiters, changing
     functions 2nd 3rd
     generated 2nd
     identity 2nd 3rd 4th 5th 6th
     names, specifying 2nd
     removing 2nd
     selecting for import
     unique identifiers 2nd 3rd 4th
Command Editor 2nd 3rd 4th 5th 6th 7th
Command Line Processor (CLP) [See CLP (Command Line Processor]
Command options, CLP 2nd 3rd 4th
Command Window
     availability
     modifying isolation levels 2nd
     starting 2nd
     versus (Command Line Processor) 2nd 3rd 4th 5th
Commands
    case sensitivity [See SQL statements]
    CLP (Command Line Processor) commands [See SQL statements]
    DB2 commands [See SQL statements]
    definition [See SQL statements]
    help for [See SQL statements]
    issuing from DPF [See SQL statements]
    listing [See SQL statements]
    overview [See SQL statements]
    syntax, displaying [See SQL statements]
    system commands [See SQL statements]
    types of [See SQL statements]
Comments, CLP 2nd 3rd 4th 5th
Commit points
COMMIT statement
     and autocommit
     functional description
     lost updates
commitcount option
Commits
Common table expressions (CTE) 2nd 3rd
Communications database (CDB)
Compact installation
Comparison operators
Composite block indexes 2nd
Composite keys
Compound SQL statement
COMPRESS SYSTEM DEFAULT clause 2nd
Compression, tables 2nd
Concurrency
     definition
    scenarios
        lost updates [See isolation levels, locking]
        nonrepeateable reads [See isolation levels, locking]
        phantom reads [See isolation levels, locking]
        transactions [See isolation levels, locking]
        uncommitted reads [See isolation levels, locking]
Concurrent write access 2nd 3rd 4th
Configurable configuration parameters
Configurable online configuration parameters
Configuration Advisor
    Connections page [See performance]
    definition [See performance]
    Introduction page [See performance]
    invoking
        command line [See performance]
        Control Center [See performance]
    Isolation page [See performance]
    Populated page [See performance]
    Priority page [See performance]
    Results page [See performance]
    Schedule page [See performance]
    Server page [See performance]
    Transactions page [See performance]
    Workload page [See performance]
Configuration Assistant (CA) [See CA (Configuration Assistant]
Configuration files
Configuration parameters
    database level [See parameters]
    definition [See parameters]
    instance level [See parameters]
    list of [See parameters]
    updating [See parameters]
    viewing [See parameters]
Configuration tools
Configuring
    database connections
        case study [See performance]
        manually, with CA Configuration Assistant [See performance]
        manually, with DB2 commands [See performance, connectivity, Connectivity;scenarios]
        with system tools [See performance, Add Database Wizard, CA (Configuration Assistant]
    databases
        average active applications [See performance]
        buffer pool, prefetching and cleaning [See performance]
        case study [See performance]
        commands for [See performance]
        configuration file [See performance]
        Control Center [See performance]
        instances [See performance]
        locking [See performance]
        logging [See performance]
        number of commits to group [See performance]
        parameters [See performance]
        Setup tools [See performance]
        sorting [See performance]
        write-ahead logging [See performance]
    instances
        agent pool [See performance]
        intra-partition parallelism [See performance]
        parameters [See performance]
        requester I/O block size [See performance]
        sort heap threshold [See performance]
    system/server for performance [See performance]
Connect 2nd 3rd [See also host connectivity]
CONNECT authority 2nd
Connection concentrator
     case study
     definition
     description
Connections
     definition
     versus attachments
Connections page 2nd
Connectivity
    case study [See configuring, Configuring;database connections, directories]
    client-server TCP/IP problems [See configuring, Configuring;database connections, directories]
    DB2 environment [See configuring, Configuring;database connections, directories]
    iSeries client to
        iSeries server [See configuring, Configuring;database connections, directories]
        Linux server [See configuring, Configuring;database connections, directories]
        UNIX server [See configuring, Configuring;database connections, directories]
        Windows server [See configuring, Configuring;database connections, directories]
        z/OS server [See configuring, Configuring;database connections, directories]
    listener processes [See configuring, Configuring;database connections, directories]
    scenarios
        binding utilities [See configuring, Configuring;database connections, directories]
        database directory, cataloging [See configuring, Configuring;database connections, directories]
        database server, enabling [See configuring, Configuring;database connections, directories]
        DCS directory, cataloging [See configuring, Configuring;database connections, directories]
        local from DB2 client to DB2 server [See configuring, Configuring;database connections, directories]
        node directory, cataloging [See configuring, Configuring;database connections, directories]
        remote from DB2 client to DB2 host server [See configuring, Configuring;database connections, directories]
        remote from DB2 client to DB2 server [See configuring, Configuring;database connections, directories]
    to local database [See configuring, Configuring;database connections, directories]
    to remote database [See configuring, Configuring;database connections, directories]
    troubleshooting [See configuring, Configuring;database connections, directories]
    z/OS client
        communications database [See configuring, Configuring;database connections, directories]
        to iSeries server [See configuring, Configuring;database connections, directories]
        to Linux server [See configuring, Configuring;database connections, directories]
        to UNIX server [See configuring, Configuring;database connections, directories]
        to Windows server [See configuring, Configuring;database connections, directories]
        to z/OS server [See configuring, Configuring;database connections, directories]
Constants
CONSTRAINT clause
Constraints [See also tables, constraints]
Container tags 2nd
Containers
     adding 2nd 3rd 4th 5th
     definition
     description
     DMS (database-managed space) 2nd
     SMS (systemmanaged space) 2nd 3rd
Content management
Contention
Contents pane
Control Center 2nd 3rd 4th 5th 6th
Control server
Coordinated Universal Time (UTC)
Coordinator agents 2nd 3rd 4th 5th 6th
Coordinator nodes
Coordinator partitions 2nd
copy yes/no options
Copying databases [See backups, Databases;cloning, Databases;relocating]
Core files
Corrective code (FixPaks) 2nd 3rd 4th
Correlated subquery
Correlation names
Cost
Counters
Country/region codes
CPU requirements, performance 2nd
CPU_PARALLELISM modifier
Crash recovery 2nd [See also backups, recovery]
CREATE BUFFERPOOL statement 2nd 3rd 4th 5th 6th
create database command
     connectivity
     creating a database 2nd 3rd
     partitioning a database 2nd 3rd 4th
     syntax
CREATE DATABASE PARTITION GROUP statement 2nd 3rd
CREATE DISTINCT TYPE statement 2nd
CREATE EVENT MONITOR statement
CREATE FUNCTION statement 2nd
CREATE import mode 2nd
CREATE NICKNAME statement
CREATE PROCEDURE statement
CREATE SCHEMA statement
CREATE statement, objects used on
CREATE TABLE statement
     creating partitioning keys 2nd
     creating tables
CREATE TABLESPACE statement
     creating table spaces 2nd 3rd
     EXTENTSIZE clause
     IN DATABASE PARTITION GROUP statement
     MANAGED BY DATABASE clause
     MANAGED BY SYSTEM clause
     syntax 2nd 3rd
CREATE TOOLS CATALOG command 2nd
CREATE TRIGGER statement
CREATE USER MAPPING statement
CREATE VIEW statement
CREATE_EXTERNAL_ROUTINE authority 2nd
CREATEIN schema privilege 2nd 3rd
CREATETAB authority 2nd
Creating
     buffer pools 2nd 3rd 4th 5th
     DAS (Database Administration Server) 2nd
     database backup image 2nd
    databases
        cloning [See backups, recovery]
        CREATE DATABASE statement [See backups, recovery]
        examples [See backups, recovery]
        INSERT statement [See backups, recovery, import utility, load utility]
        multipartition environment [See backups, recovery]
        relocating [See backups, recovery]
        sample [See backups, recovery]
        singlepartition environment [See backups, recovery]
     DB2INSTANCE environment variable 2nd 3rd 4th
     DB2NODE environment variable 2nd 3rd 4th
     environment variables 2nd 3rd 4th
     identity columns 2nd 3rd 4th
     indexes
     instances
         64-bit
         at installation 2nd
         client 2nd
         db2icrt command
         in multipartitioned environment
     packages
     partition groups 2nd 3rd
     partitioning keys 2nd
     partitions 2nd 3rd
    rules for table data [See tables, constraints]
     schemas 2nd
     sequences
     standby database 2nd
     stored procedures
     table spaces 2nd 3rd
    tables
         based on another table 2nd 3rd 4th
         from query results 2nd 3rd 4th
         in a given table space
         MQTs (materialized query tables) 2nd
         not logged initially 2nd
         temporary 2nd
         user tables 2nd
     UDTs (userdefined types)
     views
CS (cursor stability) 2nd 3rd
CTE (common table expressions) 2nd 3rd
Cumulative backups 2nd 3rd 4th
CURRENT DATE register
CURRENT ISOLATION register 2nd 3rd
CURRENT LOCK TIMEOUT parameter 2nd
CURRENT LOCK TIMEOUT register
CURRENT PACKAGE PATH register
CURRENT PATH register
Current paths
CURRENT SCHEMA register
CURRENT TIME register
CURRENT TIMESTAMP register
Current working directory
Cursor blocking
Cursor format 2nd
Cursor sensitivity 2nd
Cursor stability (CS) 2nd 3rd
Cursors
     ambiguous
     blocking
     CS (cursor stability)
     definition
     scrollable
     sensitivity 2nd
     unambiguous
Custom installation
Custom view



Understanding DB2(R. Learning Visually with Examples)
Understanding DB2: Learning Visually with Examples (2nd Edition)
ISBN: 0131580183
EAN: 2147483647
Year: 2004
Pages: 313

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net