S

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 tables
Semicolon (; )
     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 3rd
Setup 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 4th
Showing [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 function
Snapshots
     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 3rd
SQL (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
Subagents
Subordinate 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
Synchronous
Syntax
     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)