Understanding DB2: Learning Visually with Examples (2nd Edition)
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 functionsCasting 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, changingCharacter 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 2ndCLOB (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 pointsCOMMIT 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 filesConfiguration parameters database level [See parameters] definition [See parameters] instance level [See parameters] list of [See parameters] updating [See parameters] viewing [See parameters] Configuration toolsConfiguring 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 optionsCopying 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 onCREATE 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 3rdCursors ambiguous blocking CS (cursor stability) definition scrollable sensitivity 2nd unambiguous Custom installation Custom view |