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]

Satellite Administration Center 2nd 3rd 4th 5th 6th

Satellite control database 2nd Satellite Control Server 2nd 3rd 4th Satellite control servers Satellites savecount option

Savepoint levels

Savepoints SBCS (singlebyte character set) Scalar fullselect

Scalar functions 2nd 3rd Scale Schedule page 2nd

Scheduling tasks [See Task Center]

Schemas

     creating 2nd

     creating implicitly 2nd     definition 2nd

     dropping

     modifying     names, querying     privileges 2nd 3rd     SYSCAT

     SYSIBM

     SYSSTAT

Scrollable cursors

Scrollable result sets

Search

    case-insensitive [See querying data]

    definition [See querying data]

    pattern searches [See querying data]

    WHERE clause [See querying data, FETCH FIRST n ROWS ONLY clause, OVER function, ROWNUMBER function]

Search condition

Search discovery 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th

Search the network method 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th

Secondary log files 2nd 3rd

Secondary logs

Sections

Security    administrative authorities [See authenticating, authentication]    authorities, storing and retrieving [See authenticating, authentication]

    case study [See authenticating, authentication]

    for DB2 objects (Windows) [See authenticating, authentication]    overview [See authenticating, authentication]

Security, privileges

    database objects         federated database support

         implicit 2nd         indexes 2nd

         nicknames         packages 2nd         routines 2nd         schemas 2nd 3rd         sequences 2nd

         table spaces 2nd

         tables 2nd 3rd         views 2nd 3rd     storing and retrieving 2nd 3rd 4th 5th 6th

     Windows 2nd 3rd SELECT COUNT DISTINCT statement SELECT COUNT statement

SELECT DISTINCT statement

SELECT statement examples 2nd

Selecting data [See querying data]

Selective processing 2nd 3rd Selfreferencing constraints

Selfreferencing rows

Selfreferencing subqueries Selfreferencing tablesSemicolon (; )     in commands

     terminator character

Sequences

     case study 2nd 3rd 4th

     definition 2nd

     description

     privileges 2nd

Sequential prefetch

Serialization

SERVER authentication 2nd

SERVER objects 2nd

Server page 2nd 3rd

SERVER_ENCRYPT authentication 2nd

Servers

    accessing multiple [See federation]

     definition

     IBM     information management products     propagating data to 2nd

Service names

SESSION_USER register SET CLIENT CONNECT_NODE command

SET CURRENT ISOLATION statement, modifying isolation levels 2nd

set integrity command SET NULL rule

Set operators setup command

Setup Tools 2nd 3rdSetup Wizard, installing DB2     alert notification feature 2nd 3rd     DAS (Database Administration Server)     DB2 instance, creating and configuring 2nd 3rd 4th 5th 6th

     DB2 tools catalog, creating 2nd 3rd 4th

     generating a response file 2nd 3rd     health monitor notification 2nd     installation folder 2nd 3rd

     installation type     Linux/UNIX 2nd     partitioned database option 2nd

     security for DB2 objects (Windows) 2nd 3rd 4th

     setting user information

     starting the installation 2nd 3rd 4th

     Windows 2nd 3rd Shared memory

SHEAPTHRES parameter 2nd 3rd

SHEAPTHRES_SHR parameter 2nd show detail option 2nd 3rd 4thShowing [See listing] Silent install 2nd 3rd 4th 5th

Singlebyte character set (SBCS)

Singlepartition databases 2nd 3rd

Singlepartition partition groups

Singleprecision floating point numbers

Singleuser databases, DB2 UDB edition for

Size of log space

Slices 2nd

Small business environment, DB2 UDB edition for

Small integer (SMALLINT) data type 2nd

SMALLINT (small integer) data type 2nd

SMS (systemmanaged space) 2nd 3rd

SMS (systemmanaged space) table space

SNA (Systems Network Architecture)

Snapshot Monitor

     performance 2nd 3rd 4th

     troubleshooting locking problems 2nd 3rd 4th snapshot option 2nd Snapshot table functions, troubleshooting locking problems

SNAPSHOT_LOCK function

SNAPSHOT_LOCKWAIT functionSnapshots

     db2inidb snapshot command 2nd

     definition     explain snapshot

     performance 2nd 3rd 4th     table spaces 2nd 3rd 4th 5th 6th

     troubleshooting locking problems 2nd 3rd 4th Sockets Soft checkpoints Soft links 2nd SOFTMAX parameter

Software development

     ondemand business model 2nd     packages 2nd     PDE (DB2 Personal Developer's Edition) 2nd

     UDE (DB2 Universal Developer's Edition)     updates (FixPaks) 2nd 3rd 4th SORT BUFFER modifier

Sort heap threshold, configuring instances 2nd

SORTHEAP parameter 2nd

Sorting, configuring

Source programs Source tables

Source type

Spatial Extender Special registers 2nd 3rd 4th Split mirroring 2nd 3rdSQL (Structured Query Language)

    connections [See modifying, Updating;data, querying data]

    definition [See modifying, Updating;data, querying data]

    escape characters [See modifying, Updating;data, querying data]

    functions [See modifying, Updating;data, querying data]

    methods [See modifying, Updating;data, querying data]

    procedures [See modifying, Updating;data, querying data]

    return codes [See modifying, Updating;data, querying data]

SQL Assist 2nd 3rd 4th

SQL Assistant

SQL communication area (SQLCA)

SQL descriptor area (SQLDA)

SQL PL (SQL procedural language)

SQL statements

    case sensitivity [See commands]

    DCL (Data Control Language) [See commands]

    DDL (Data Definition Language) [See commands]    DML (Data Manipulation Language) [See commands]    examples [See commands]

    help for [See commands]

    issuing from DPF [See commands]    listing [See commands]

    overview [See commands]

SQL0805N "Package not found" error SQL1015N message

SQL_AUTHENTICATION_DATAENC authentication SQL_AUTHENTICATION_DATAENC_CMP authentication

SQLCA (SQL communication area) SQLDA (SQL descriptor area) SQLDBDIR file 2nd 3rd 4th SQLJ SQLNODIR file 2nd

SRV_PLUGIN_MODE parameter

SRVCON_GSSPLUGIN_LIST parameter 2nd SRVCON_PW_PLUGIN parameter 2nd Standard databases

Standby databases standby option 2nd Star schemas

Starting

     CLP (Command Line Processor)

     Command Editor 2nd 3rd 4th 5th

     Command Window 2nd     DAS

     DAS (Database Administration Server)

     DB2 installation 2nd 3rd 4th     DB2INSTANCE environment variable 2nd 3rd 4th     instances 2nd Statement level isolation levels 2nd

Statement savepoints

Statements [See also commands, SQL statements]

States of logs 2nd

Static SQL

Statistic profiles 2nd

Statistical modeling 2nd 3rd 4th 5th 6th 7th 8th 9th

Statistics

     collecting 2nd

     gathering, performance 2nd 3rd 4th

     maintaining 2nd

     profiles

statistics no option 2nd

statistics use profile option 2nd

Stored procedures

    creating [See development tools]

    definition [See development tools]    description [See development tools]    dropping [See development tools]

    fenced [See development tools]

    modifying [See development tools]    unfenced [See development tools]

String data type 2nd 3rd

Strings Striping 2nd

Strong typing STRUCTURE UDTs 2nd

Structured Query Language (SQL) [See SQL (Structured Query Language] Structured type Structures SubagentsSubordinate agents [See subagents]

Subqueries

Subselect Subset Summary tables 2nd 3rd

Superusers Suspended I/O support 2nd SVCENAME parameter, port specification 2nd 3rd

Symbolic links 2nd

Symphony worksheet format 2nd

SYNC (Synchronous) mode 2nd 3rd 4th

Sync point [See points of consistency] Synchronization

Synchronization modes 2nd 3rd 4th

SynchronousSyntax     diagrams 2nd     displaying

SYSADM authority

SYSCAT schema

SYSCAT... catalog views

SYSCATSPACE

SYSCATSPACE (catalog) table space

SYSCTRL authority

SYSIBM schema

SYSMAINT authority

SYSMON authority

SYSSTAT schema

SYSSTAT tables 2nd 3rd 4th 5th 6th 7th 8th 9th

System administrators

System authority

System catalog [See Partitions;catalog]

System catalog tables

     description 2nd     displaying by schema name     displaying names of

    extracting information from

         buffer pool data 2nd 3rd 4th         buffer pool table spaces 2nd 3rd 4th 5th

         views 2nd

     overview 2nd     statistical modeling 2nd 3rd 4th 5th 6th 7th 8th 9th

     SYSSTAT tables 2nd 3rd 4th 5th 6th 7th 8th 9th     whatif modeling 2nd 3rd 4th 5th 6th 7th 8th 9th

System commands 2nd System database directory 2nd 3rd 4th 5th 6th 7th System monitors System table spaces System/server configuration, performance 2nd 3rd

SYSTEM_USER register

Systemmanaged space (SMS) 2nd 3rd Systemmanaged space (SMS) table space Systems Network Architecture (SNA)