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 2ndScheduling 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 setsSearchcase-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 SectionsSecurityadministrative 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, privilegesdatabase 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 2ndSelecting data
[See querying data] Selective processing 2nd 3rd Selfreferencing constraints Selfreferencing rows Selfreferencing subqueries Selfreferencing tablesSemicolon (; ) in commands terminator characterSequences 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 2ndServersaccessing 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 parameterSoftware 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 statementscase 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 schemasStarting 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 9thStatistics collecting 2nd gathering, performance 2nd 3rd 4th maintaining 2nd profiles statistics no option 2nd statistics use profile option 2ndStored procedurescreating
[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 2ndStructured 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 4thSync 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 authoritySystem catalog
[See Partitions;catalog]System catalog tables description 2nd displaying by schema name displaying names ofextracting 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)