Learning Visually with Examples [Electronic resources] نسخه متنی

اینجــــا یک کتابخانه دیجیتالی است

با بیش از 100000 منبع الکترونیکی رایگان به زبان فارسی ، عربی و انگلیسی

Learning Visually with Examples [Electronic resources] - نسخه متنی

Raul F. Chong, Clara Liu, Sylvia F. Qi, Dwaine R. Snow

| نمايش فراداده ، افزودن یک نقد و بررسی
افزودن به کتابخانه شخصی
ارسال به دوستان
جستجو در متن کتاب
بیشتر
تنظیمات قلم

فونت

اندازه قلم

+ - پیش فرض

حالت نمایش

روز نیمروز شب
جستجو در لغت نامه
بیشتر
لیست موضوعات
توضیحات
افزودن یادداشت جدید

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

/ 312