index_S

[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] [Y] [Z]

S-locks
Sagent Technology, Inc.
sample applications
        DSNTEP2 2nd 3rd
                batch environment
                comments
                error handling
                input data sets
                rerunning
                return codes
        DSNTIAD 2nd 3rd
                comments
                DDL
                error handling
                executing authority
                JCL
                preparations
                rerunning
                return codes
        DSNTIAUL 2nd 3rd
                data movement
                JCL
                LOCK TABLE statement
                maximum unloads
                preparations
                return codes
                SQL statemetns
                SYSREC data sests
                unloaded flat files
                views, unloading
                WHERE/ORDER BY clauses
sample databases
SAMPLE parameter
        UNLOAD utility
sample programs
        SQL stored procedures, creating 2nd
sample table spaces
sample tables
        activity
                DDL
        department 2nd
        employee 2nd
        employee assignment
        employee photo & resume 2nd
        project 2nd
        project activity 2nd
        storage group
        views 2nd 3rd
sample views 2nd 3rd
sampling
        RUNSTATS utility
SamplingRate UDF
        audio
        video
sargable processing
SAS Institute Inc.
savepoints
       external
                batch programs 2nd
SAVEPOINTs
        Version 7 enhancements 2nd
saving
        cursor positions
scalar fullselects
scalar functions 2nd
        ABS
        ABSVAL
        ACOS
        ADD_MONTHS
        ASIN
        ATAN
        ATAN2
        ATANH
        BLOB
        CCSID_ENCODING
        CEIL
        CEILING
        CHAR
        CLOB
        COALESCE
        CONCAT
        COS
        COSH
        DATE
        DAY
        DAYOFMONTH
        DAYOFWEEK
        DAYOFWEEK_ISO
        DAYS
        DBCLOB
        DEC
        DECIMAL
        DECRYPT_BIT
        DECRYPT_CHAR
        DECRYPT_DB
        DEGREES
        DIGITS
        DOUBLE
        ENCRYPT_TDES
        EXP
        FLOAT
        FLOOR
        GENERATE_UNIQUE
        GETHINT
        GETVARIABLE
        GRAPHIC
        GREATEST
        HEX
        HOUR
        IDENTITY_VAL_LOCAL
        IFNULL
        INSERT
        INT
        INTEGER
        JULIAN_DAY
        LAST_DAY
        LCASE
        LEAST
        LEFT
        LENGTH
        LN
        LOCATE
        LOG
        LOG10
        LOWER
        LTRIM
        MAX
        MICROSECOND
        MIDNIGHT_SECONDS
        MIN
        MINUTE
        MOD
        MONTH
        MULTIPLY_ALT
        NEXT_DAY
        NULLIF
        POSSTR
        POWER
        QUARTER
        RADIANS
        RAND
        REAL
        REPEAT
        REPLACE
        RIGHT
        ROUND
        ROUND_TIMESTAMP
        ROWID
        RTRIM
        SECOND
        SIGN
        SIN
        SINH
        SMALLINT
        SPACE
        SQRT
        STRIP
        SUBSTR
        TAN
        TANH
        TIME
        TIMESTAMP
        TIMESTAMP_FORMAT
        TRANSLATE
        TRUNC
        TRUNC_TIMESTAMP
        TRUNCATE
        UCASE
        UPPER
        VALUE
        VARCHAR
        VARCHAR_FORMAT
        VARGRAPHIC
        WEEK
        WEEK_ISO
        WHERE clauses
scalar user -defined functions
scalpel disaster recovery strategy 2nd 3rd 4th 5th
scans
        access path strategies 2nd 3rd
                limited partition
                partitioned tablespace
                segmented tablespace
                tablespace 2nd
        index
                matching 2nd
                non-matching 2nd
       indexes
                avoiding
scheduling
        COMMIT statements
        DSN1CHKR
        RUNSTATS utility
SCHEMA class privileges
SCHEMA column
        SYSIBM.SYSPSMOPTS table
Schema Evolution
        Version 8
SCHEMA_NAME column
        DSN_FUNCTION_TABLE table
schemas
        Procedural DBA
        snowflake
       star
                data warehouses 2nd 3rd
       tables
                duplicating
        UDFs 2nd
schemes
       encoding
                table spaces 2nd
                tables
                unloaded data
SCOPE parameter
        LOB references
SCOPE PENDING option
        REORG utility
SCOPE PENDING parameter
        CHECK DATA utility
Scratch Pad Areas.
SCRATCHPAD clause
scratchpads
screening
        indexes
scrollable cursors 2nd 3rd
        asensitive
        declared temporary tables
        dynamic 2nd 3rd
        insensitive 2nd
        keywords
        pseudo-conversational CICS programs
        result set navigation
        static 2nd
        types 2nd
        Version 7 enhancements 2nd
        warnings
SCT01 table space
SCT02 table 2nd
search criteria
        joins
search engines
        Internet
Search_Result UDF
        text
SEC tools 2nd
SECLABEL session variable
SECLABELs
        comparing
SECOND function
second normal form
second timestamp unit
secondary authids 2nd
secondary indexes
       partitioned
                Version 8
secondary space allocations
        indexes
secondary storage
        table spaces 2nd 3rd 4th 5th
                calculating
                cylinder allocations
                data type lengths 2nd
                default values
                segmented table spaces
SECQTY parameter
        0 option
        table spaces 2nd 3rd 4th 5th
                calculating
                cylinder allocations
                data type lengths 2nd
                default values
                segmented table spaces
security
        administration
       authorization
                applications 2nd
                automatic security
                BINDAGENT authority
                built-in groupings
                DELETE/UPDATE/INSERT authorities
                dynamic authorities
                external 2nd
                grants 2nd
                group authorities
                group-level
                multilevel security 2nd
                packages
                plans
                proliferation avoidance rule
                public access 2nd
                public display authority
                re-creating
                REFERENCES privilege
                restricted userids
                secondary authids 2nd
                synonyms
                SYSADM authority, restricting
                SYSADM authority, revoking
                SYSCTRL authority
                SYSIBM.SYSDUMMY1 table
        automatic
        CICS
        database
        DB2 2nd
        DCE
        distributed data
                authid translations 2nd
                come-from checking
                PUBLIC AT ALL LOCATIONS parameter
       encryption
                DB2 data 2nd
                userids/passwords
        environment control commands
        extenders 2nd
        guide
       implementing
                views
        index-only access 2nd
        Kerberos
        LOAD utility
        multi-index access 2nd
       multi-level
                Version 8
        multilevel 2nd
        multilevel.
        Net.Data
        packages
        plans
       privileges
                granting 2nd
                revoking
        resource privileges
       row level
                MLS
        session variables 2nd
                user-created
        special registers 2nd
        stored procedures 2nd
        tables
        UDFs
        UNLOAD utility
        views 2nd
        write down
security label columns
SECURITY parameter
        UDFs
security tools 2nd
SECURITY UDF characteristic
segmented table spaces 2nd 3rd
        MQTs
        multiple tables, defining 2nd
        space search algorithm
        storing
segmented tablespace scans
SEGSIZE parameter
        table spaces
SEGUS Inc.
SELECT authority
        SYSIBM.SYSDUMMY1 table
SELECT statement
        ORDER BY clause 2nd
        selection/projection
SELECT statements
        application programs
        base table views
        existence, checking 2nd
        fixed-list SELECT dynamic SQL 2nd
                flexibility
                listing
                parameter markers 2nd
                prepared statements
                SQLDA
        fixed-list SELECT dynamic SQL SELECT dynamic SQL
        FOR READ ONLY clause
        FOR UPDATE OF clause
        host variables 2nd
        MQTs
        nesting 2nd 3rd
        non-SELECT dynamic
        singleton 2nd
                overhead, reducing
        varying-list
        varying-list SELECT dynamic SQL 2nd 3rd 4th 5th
                listing
                minimal SQLDA
                SQLDA 2nd
                SQLTYPE values 2nd
selecting
        access paths 2nd 3rd
        rows 2nd
selection
        SQL
selection priorities
self-referencing constraints 2nd
sensitive scrollable cursors
sequence authority query
sequence objects 2nd 3rd
SEQUENCE objects
sequence objects
        creating
        identity columns, compared 2nd
SEQUENCE objects
        navigational queries
sequence objects
        parameters
        performance
        rows/columns
sequences
        Version 8 2nd
sequencing
        columns/rows 2nd
        rows
sequential detection 2nd
sequential number assignments
sequential plans
sequential prefetch
        COPY utility
sequential prefetches
        access path strategies 2nd 3rd
        bufferpools 2nd
        CPU costs
        dynamic
        processing
        sequential detection
        skip sequential prefetch
        static
sequential values
        online applications
serializing
       resources
                claims 2nd
                claims/drains compatibility 2nd 3rd
                drains 2nd 3rd
servers
        location aliases
        OLAP
service level agreements.
service level management.
service levels
services
        precompiler
servlets (Java)
session
       DSN
                terminating
session variables 2nd
        DATA_SHARING_GROUP_NAME
        PACKAGE_NAME
        PACKAGE_SCHEMA
        PACKAGE_VERSION
        PLAN_NAME
        SECLABEL
        SYSTEM_ASCII_CCSID
        SYSTEM_EBCDIC_CCSID
        SYSTEM_NAME
        SYSTEM_UNICODE_CCSID
        user-created
        VERSION
sessions
        QMF
SET command
        QMF
SET ENCRYPTION PASSWORD statement
SET LOG SUSPEND command
        disaster recovery 2nd
SET NULL option
        referential constraints
SET SYSPARM command
set-level processing
        SQL 2nd 3rd 4th
SGML (Standard Generalized Markup Language)
shadow copies
        DB2 Catalog
shared read only data.
sharing
        data
                administration.
                advantages 2nd
                application support
                applications
                attachment interfaces
                binding
                CF.
                commits
                DCL
                DDL
                groups 2nd
                IMMEDWRITE parameter
                lock avoidance
                locks, minimizing
                naming conventions 2nd 3rd
                Parallel Sysplex
                pre-existing subystems
                requirements 2nd 3rd
                Sysplex 2nd
                sysplex parallelism
                tuning
                Version 7 enhancements
        IRLMs
SHDDEST RCT INIT macro parameter
Sheryl M. Larsen, Inc. Web site
short accounting reports 2nd 3rd 4th
Short Record Trace report
short statistics report 2nd 3rd 4th
SHRLEVEL CHANGE image copies
SHRLEVEL CHANGE parameter
        REORG INDEX utility
        REORG TABLESPACE utility
        REORG utility 2nd
SHRLEVEL NONE parameter
        REORG INDEX utility
        REORG TABLESPACE utility
SHRLEVEL parameter
        REORG utility
SHRLEVEL REFERENCE clause
        offsite copies
SHRLEVEL REFERENCE parameter
        COPY utility
        REORG INDEX utility
        REORG TABLESPACE utility
        RUNSTATS utility
shutdowns
       member
                speeding up
SIGN function
SIGNID parameter
        DB2CONN parameter
SIGNID RCT INIT macro parameter
simple data transformations
        data warehouses, populating
simple statements
        guidelines
                access paths, customizing
                analysis tools
                arithmetic expressions 2nd 3rd
                automatic rebinds
                BETWEEN predicate
                built-in functions 2nd
                column expressions 2nd
                data sharing auto rebind
                data, limiting
                date and time arithmetic 2nd
                decimal precision/scale
                distributed query blocks
                dummy tables
                duplicate rows, deleting 2nd
                embedded SQL, pretesting
                equivalent data types 2nd
                EXPLAIN command 2nd
                FOR READ ONLY clause
                function tables
                host variables 2nd
                IN predicate
                index access, disabling
                indexability
                indexed columns
                isolation levels
                LIKE predicate
                list prefetch, disabling
                NOT keyword, avoiding
                ordering columns
                ordering rows
                partition key ranges
                PLAN_TABLE columns 2nd
                predicate sequence 2nd
                predicate stages 2nd 3rd
                predicates, reducing 2nd
                queries, limiting 2nd 3rd
                query tweaks
                renaming columns
                rows, returning
                rows, selecting 2nd
                scalar functions
                SQL Assist
                statement tables
                updates, serializing
                Visual Explain 2nd
simple table spaces 2nd
SIN function
single table spaces
singleton SELECT statements 2nd
        overhead, reducing
SINH function
sites.
size
        active logs
        application programs
                minimimzing
        BSDS, expanding
        buffer pools
                tuning 2nd 3rd
        CICS applications 2nd
        collections
        data set partitions 2nd
        data sharing group buffer pools
        DB2 Catalog
       DBDs
                reducing
        EDM pools 2nd 3rd
        index data sets 2nd 3rd
        locks
        log output buffer
        package lists
       pages
                denormalization
                table spaces 2nd
        partitioned table spaces 2nd
       SYSPRINT block size
                DSNTEP2 utility
                DSNTIAD utility
        SYSUT2 data set
Size UDF
        audio
        image
        video
sizes
        data set pages
SKCTs (skeleton cursor tables)
skeleton cursor tables.
skip sequential prefetches
SLAs (service level agreements)
sledgehammer disaster recovery strategy 2nd
SLM (service level management)
SMALLINT columns
SMALLINT data type
        Java
        promotability
SMALLINT function
SmartDBA
SMS (System Managed Storage) 2nd
        partitioned table spaces 2nd
SNAP RCT INIT macro parameter
snapshot tables 2nd
snapshots
        data warehouses, populating
snowflake schema
Softbase Systems Inc.
sort buffer pools
sort I/O
        tuning 2nd
sort pools
        tuning 2nd
sort work spaces
        DFSORT utility
SORTC GROUP column
        PLAN TABLE
SORTC JOIN column
        PLAN TABLE
SORTC ORDERBY column
        PLAN TABLE
SORTC PGROUP ID column
        PLAN TABLE
SORTC UNIQ column
        PLAN TABLE
SORTDEVT parameter 2nd
sorting
        data 2nd
                online
SORTKEYS keyword
SORTKEYS parameter
        REORG utility
SORTN GROUPBY column
        PLAN TABLE
SORTN JOIN column
        PLAN TABLE
SORTN ORDERBY column
        PLAN TABLE
SORTN PGROUP ID column
        PLAN TABLE
SORTN UNIQ column
        PLAN TABLE
SORTNUM parameter 2nd
SORTWKxx DD statement
SOURCE UDF characteristic
sourced functions 2nd
        UDTs 2nd
SOURCEDSN column
        SYSIBM.SYSPSMOPTS table
sources
        applications
        modified
SPACE column
        INDEXSPACESTATS table
        TABLESPACESTATS table
SPACE function
space map pages 2nd 3rd
SPACE option
        TEMPLATE statement
space search algorithm
        non-segmented table spaces
        segmented table spaces
SPACENAM parameter
        buffer pools
spams
        Internet
SPAs
        IMS
SPAs (Scratch Pad Areas)
SPAS (stored procedure address space)
SPAS (Stored Procedure Address Spaces)
SPB (Stored Procedure Builder)
SPEC_FUNC_NAME column
        DSN_FUNCTION_TABLE table
special registers
        AQR 2nd
        CURRENT PACKAGE PATH
special registers (security) 2nd
SPECIAL REGISTERS UDF characteristic
SPECIFIC UDF characteristic
speed tables
        hierarchies 2nd
split tables
        base table views 2nd
        denormalization 2nd
SPT01 table
SPT02 table space
SPUFI command
SPUFI option (DB2I) 2nd 3rd
        (SQL Processor Using File Input)
        defaults
        input data set 2nd
        SPUFI Defaults panel
        SPUFI panel
SPUFI optoion (DB2I) 2nd
SQ
        requests
                consolidating
SQL 2nd
        (Structured Query Language)
        3VL 2nd
        access paths
        ad hoc
       analyzing
                Procedural DBA
        Cartesian products 2nd 3rd
        CASE expressions 2nd 3rd
        CICS
       clauses
                GROUP BY
                HAVING 2nd 3rd
                ORDER BY
                WHEN
                WHERE 2nd
        COBOL, compared 2nd
        complex statement guidelines
                Cartesian products
                clustered columns
                columns order 2nd
                columns, grouping
                denormalization
                exception reporting
                existence tests 2nd
                explicit inner joins
                explicit outer joins
                flexibility
                IN lists duplicates
                IN lists, ordering
                indexed columns
                join rows
                join table limits 2nd 3rd
                joins 2nd
                joins vs subqueries 2nd
                left outer joins
                multi-row fetches
                outer join nulls 2nd
                outer join predicates 2nd
                predicate transitive closure 2nd
                result sets, limiting 2nd
                row expressions 2nd
                rows, counting
                scalar fullselects
                search criteria
                sorting joins
                subqueries
                subquery negation logic
                table expressions 2nd 3rd 4th 5th 6th 7th
                Top Ten 2nd
                unions 2nd
        CTEs 2nd
                column names
                cyclic references
                recursion 2nd
        data customizations
                changed columns, updating
                column updates
                columns, listing
                DELETE statements
                FOR UPDATE OF clause
                generated values, retrieving
                indexed columns, updating
                large insertions
                long columns
                mass DELETE
                multiple rows, adding
                row updates
                self-referencing DELETE statements
                self-referencing sub-SELECT statements
                UPDATE statements
       date and time
                addition table
                built-in options
                data types 2nd
                dates/non-dates combination
                durations 2nd
                non-standard dates 2nd
                total number of days
       DB2 objects
                ALIAS
                COLUMN
                DATABASE
                defining 2nd
                hierarchy
                INDEX
                native data types 2nd
                security 2nd
                STOGROUP
                SYNONYM
                TABLE
                TABLESPACE
                VIEW
       debugging
                Procedural DBA
        dynamic 2nd 3rd
                access, customizing 2nd
                advantages/disadvantages
                avoiding
                bind-time authorization checking
                classes
                designs
                dynamic data, accessing
                EXECUTE IMMEDIATE statement
                EXECUTE IMMEDIATE statement.
                fixed-list SELECT 2nd 3rd 4th
                flexibility
                governing
                JDBC
                maintenance design
                non-SELECT 2nd
                non-SELECT.
                non-uniform data
                overvivew
                parallelism
                parameter markers
                performance 2nd
                prepared statements, caching 2nd 3rd
                prepares, reducing
                QMFCI
                reoptimization
                RLSTs
                static SQL, compared
                tuning
                varying-list SELECT 2nd 3rd 4th 5th
                varying-list SELECT statements
       embedded
                4GL applications
                application programs 2nd 3rd
                application programs.
                ODBC applications
                pretesting
        embedded.
        equivalent functionality
        existential
        functions
                column
                scalar
                system-defined
                user-defined
        grouping data 2nd
       IBM
                reserved words 2nd
        joins 2nd 3rd 4th 5th
                criteria
                data retrieval listing
                INNER keyword
                JOIN keyword
                outer.
                subqueries, compared 2nd
                table limits
                three-table
       keywords
                JOIN
       native
                SQL only applications
       nulls
                avoiding
                database design
                equivalency
                IS NOT DISTINCT FROM comparison operator
                IS NULL predicate
       performance
                access path selection 2nd 3rd
                optimizer
                optimizer.
        performance guide
        planned
        procedural
                Procedural DBA 2nd
        projection
       recursion
                data knowledge
                duplicate output rows
                necessity for
                stopping 2nd
        reducing in Java
        relational division 2nd
        reoptimizing
        reserved words 2nd
       rewriting
                Procedural DBA
        selection
        set-level processing 2nd 3rd 4th
        simple statement guidelines
                , limiting
                access paths, customizing
                analysis tools
                arithmetic expressions 2nd 3rd
                automatic rebinds
                BETWEEN predicate
                built-in functions 2nd
                column expressions 2nd
                data sharing auto rebind
                data, limiting
                date and time arithmetic 2nd
                decimal precision/scale
                distributed query blocks
                dummy tables
                duplicate rows, deleting 2nd
                embedded SQL, pretesting
                equivalent data types 2nd
                EXPLAIN command 2nd
                FOR READ ONLY clause
                function tables
                host variables 2nd
                IN predicate
                index access, disabling
                indexability
                indexed columns
                isolation levels
                LIKE predicate
                list prefetch, disabling
                NOT keyword, avoiding
                ordering columns
                ordering rows
                partition key ranges
                PLAN_TABLE columns 2nd
                predicate sequence 2nd
                predicate stages 2nd 3rd
                predicates, reducing 2nd
                queries, limiting 2nd
                query tweaks
                renaming columns
                rows, returning
                rows, selecting 2nd
                scalar functions
                SQL Assist
                statement tables
                updates, serializing
                Visual Explain 2nd
        sorting data 2nd
       statements
                dynamism
                execution types
                existence
                functionality
                writing
        statements. 2nd
        static 2nd 3rd
                dynamic SQL, compared
                packages
                reoptimization
        stored procedures 2nd 3rd 4th 5th
                advantages 2nd
                bodies 2nd
                creating 2nd
                creating with catalog 2nd 3rd
                creating with DSNTPSMP
                creating with JCL 2nd
                creating with sample programs 2nd
                developing
                disadvantages 2nd
                example 2nd
                executing
                external stored procedures, compared
        subqueries 2nd 3rd
                correlated
                joins, compared 2nd
                non-correlated
        UDF options 2nd 3rd
        unions 2nd
        unqualified
SQL activity (long accounting report) 2nd 3rd
SQL Assist 2nd
        Version 7 enhancements
SQL Communication Area.
SQL Long Trace report
SQL procedure processor.
SQL Processor Using File Input.
SQL result sets
        distribution performance
SQL Short Trace report
SQL system limits
        Verison 8
SQL trace report sets 2nd 3rd
SQL Trace Summary report 2nd
SQLABC field (SQLCA)
SQLCA
        application programs 2nd 3rd
        fields 2nd 3rd
        stored procedures
SQLCA (SQL Communication Area)
SQLCAID field (SQLCA)
SQLCODE field (SQLCA)
SQLCODE statement
        application programs 2nd
SQLCODEs
        SQLSTATEs, compared
SQLDA
        fixed-list SELECT
       minimal
                varying-list SELECT dynamic SQL
        varying-list SELECT dynamic SQL 2nd
SQLERRD field (SQLCA)
SQLERRM field (SQLCA)
SQLERROR parameter
SQLError() function
        ODBC
SQLERRP field (SQLCA)
SQLJ
        code fragment
        program preparation
SQLSTATE field (SQLCA)
SQLSTATEs
        SQLCODEs, compared
SQLTYPE field
       values
                varying-list SELECT dynamic SQL 2nd
SQLWARN0 field (SQLCA)
SQLWARN1 field (SQLCA)
SQLWARN2 field (SQLCA)
SQLWARN3 field (SQLCA)
SQLWARN4 field (SQLCA)
SQLWARN5 field (SQLCA)
SQLWARN6 field (SQLCA)
SQLWARN7 field (SQLCA)
SQLWARN8 field (SQLCA)
SQLWARN9 field (SQLCA)
SQLWARNA field (SQLCA)
SQRT function
SRM
        z/OS
SRM (Systems Resource Manager)
SROD
        Version 6 2nd
SROD (shared read only data)
SSAS (System Services Address Space)
SSMs
        parameters 2nd
SSMs (subsystem member)
SSN parameter
        SSMs
SSR (/ before) command
stability
        cursors
        reads
stable data
        RI, avoiding
STACK option
        TEMPLATE statement
Stage 1
        predicates 2nd 3rd
Stage 1 processing
Stage 2
        predicates 2nd 3rd
Stage 2 processing
stand-alone utilities 2nd
        DSN1CHKR 2nd
                integrity verification
                JCL
                read-only mode
                scheduling
                table spaces
        DSN1COMP
                compression, planning
                DSSIZE parameter
                JCL
                PAGESIZE parameter
                parameters
                prefixes
        DSN1COPY 2nd
                BUFND parameter
                hex dumps
                identity columns
                JCL listing
                large table spaces
                LOB table spaces
                log data sets
                OBIDXLAT option
                OBIDXLAT option JCL
                PAGESIZE parameter
                prefixes
                record OBIDs, translating
                running
                SYSUT2 data set
                SYSXLAT file
        DSN1LOGP
                active logs
                JCL
                output reports
        DSN1PRNT 2nd 3rd
                errors
                JCL
                LOB table spaces
                page sizes
                PAGESIZE parameter
                running
        DSN1SDMP 2nd
                data sets
                JCL
                user authority
        DSNJLOGF 2nd
                JCL listing
                timestamps
        DSNJU003 2nd 3rd
                CCSID information
                data sharing
                JCL listing
                RESTORE SYSTEM utility combination
                running
standard deviation
Standard Generalized Markup Language.
standard libraries
        maintenance
standard methods
        optimizer, influencing 2nd 3rd 4th 5th
standards (DB2 implementation)
        application development guide
        data administration 2nd
        database administration guide
        design review 2nd 3rd 4th
                phase five
                phase four
                phase one
                phase seven
                phase six
                phase three
                phase two
        migrations/turnovers
        naming conventions 2nd
        QMF guide
        roles/responsibilities 2nd 3rd
        security guide
        SQL performance guide
        system administration guide
        vendor tools guide
STANDBY RCT INIT macro parameter
STANDBYMODE parameter
        DB2CONN parameter
star joins 2nd
star schema
        data warehouses 2nd 3rd
START (/ before) command
START command
        UDFs
START DATABASE command 2nd
start day timestamp unit
START DB2 command
START DDF command 2nd
START PROCEDURE command 2nd
START RLIMIT command
START TRACE command 2nd
STARTBR command
        CICS file processing
starting
        DB2 PM report traces 2nd 3rd
        RLSTs
        stored procedures
        traces
        UDFs 2nd 3rd 4th 5th 6th
Starware Software
statement tables
statement-level triggers
statements
        ALTER TABLE
                ADD PART parameter
                query rewrites
        ALTER TABLE ALTER PART ROTATE FIRST TO LAST
        ALTER TABLE ALTER PART VALUES
        base table views
       BIND
                ACTION parameter
                CACHESIZE parameter
                collections
                DBRMs, retaining
                default parameters
                dirty reads 2nd 3rd 4th
                dynamic reoptimization
                DYNAMICRULES parameter 2nd 3rd
                ENABLE/DISABLE parameters 2nd
                errors
                explicit consistency tokens
                IMMEDWRITE parameter
                initial administration
                isolation levels
                kplans
                like programs, grouping
                lock avoidance
                mirror tables
                multiple qualified tables
                OPTHINT parameter
                packages 2nd
                packages, creating
                parallelism 2nd
                PATH paraemter
                prepared statements
                production BNDs
                QUALIFIER parameter
                read stability
                reoptimization
                reoptimzation, isolating
                repeatable reads 2nd 3rd
                RETAIN parameter
                statistics (current)
                table space locking 2nd
                validation
                wildcard package lists
        block style coding 2nd 3rd
       CALL
                stored procedures
       CLOSE
                cursors 2nd
        code literals
       COMMENT ON
                tables
        comments
       COMMIT
                batch programs 2nd 3rd 4th
                stored procedures
       complex
                application prorams
        CONNECT
        CREATE GLOBAL TEMPORARY TABLE
        CREATE INDEX 2nd
        CREATE LOB TABLESPACE
        CREATE PROCEDURE
       CREATE TABLE
                AUDIT clause
        CREATE TRIGGER DDL 2nd 3rd 4th 5th 6th
                activation
                events, selecting
                examples 2nd 3rd
                granularity
                logic
                SQL statements
                tables, defining
                transition variables 2nd
                WHEN clause
       DCLGEN
                break apart columns 2nd
                DCLGEN libraries
                DCLGEN members 2nd
                field name PREFIX
                host variables, prefixing
                unqualified table references
       DECLARE
                cursors
       DECLARE CURSOR
                FOR UPDATE OF clause
                order
        DECLARE GLOBAL TEMPORARY TABLE
        DECLARE TABLE
        DELETE
                cursor controlled
                cursors
                mass
                self-referencing
        DESCRIBE PROCEDURE
       dynamic
                stored procedures
        dynamic SQL, avoiding
        EXEC SQL control 2nd 3rd 4th
                cursor-driven SELECT statements
                issuing 2nd
                non-SELECT dynamic statements
        EXECUTE IMMEDIATE 2nd
                host variables
                non-SELECT dynamic SQL, compared
                one-time processing
                syntax
       FETCH
                cursors
                host variables
        FREE LOCATOR
       GETDIAGNOSTICS
                application programs 2nd 3rd 4th 5th
                combined information
                condition information 2nd
                connection information 2nd
                statement information 2nd
       GRANT
                privileges 2nd
        HOLD LOCATOR
       INSERT
                base table views
                columns, listing
                LOAD utility, compared
                multiple rows
                set-level processing
        invalidating
                RUNSTATS utility
       LISTDEF
                database object lists 2nd 3rd 4th
                database object lists, previewing
                example 2nd
                indexes
                list expansion 2nd
                LIST keyword 2nd
                LOBs 2nd
                RI parameter
                RUNSTATS utility
                utilities
                wildcards 2nd
       LOAD control
                creating
        LOCK TABLE 2nd
                DSNTIAUL utility
       OPEN
                cursors
        optimizer
        OPTIONS control
                OFF keyword
                PREVIEW keyword
       prepared
                caching 2nd 3rd
                holding past COMMIT
                non-SELECT dynamic SQL
       REFRESH TABLE
                MQTs
       REVOKE
                privileges
       ROLLBACK
                stored procedures
       SELECT
                application programs
                existence, checking 2nd
                fixed-list 2nd 3rd
                fixed-list SELECT dynamic SQL
                FOR READ ONLY statements
                FOR UPDATE OF clause
                host variables 2nd
                MQTs
                non-SELECT dynamic
                ORDER BY clause 2nd
                singleton 2nd 3rd
                varying-list
                varying-list SELECT dynamic SQL 2nd 3rd 4th 5th
        SET ENCRPTION PASSWORD
        SORTWKxx DD
       SQL
                dynamism
                execution types
                existence
                functionality
                REXX procedures
                writing
        SQL Assist
       SQLCODE
                application programs 2nd
       static
                stored procedures
       sub-SELECT
                self-referencing
       TEMPLATE
                data sets, allocating 2nd
                database object lists
                disk options 2nd
                examples 2nd
                names
                options 2nd
                symbolics 2nd
                tape options
                utilities
       UNION
                UDTs 2nd
        UPDATE
                cursor controlled
                cursors
       VALUES
                triggers
       WHENEVER
                application programs 2nd
statements (SQL)
        DSNTIAUL utility
        dynamic 2nd
       performance analysis
                EXPLAIN feature 2nd 3rd
       SELECT
                nesting 2nd 3rd
                selection/projection
       simple
                guidelines.
        static 2nd
        triggers
       tweaking
                optimizer, influencing 2nd 3rd
states
       exception
                online schema changes
        pending
                correcting 2nd 3rd
                pending flags
                reasons for 2nd
STATIC DISPATCH UDF characteristic
STATIC parameter
        scrollable cursors 2nd
static scrollable cursors 2nd
static sequential prefetches
static SQL 2nd 3rd
        dynamic SQL, compared
        packages
        reoptimization
static SQL statements
        stored procedures
statistics
        access paths 2nd
        column data type changes
       column/column group
                gathering 2nd
        DB2 Catalog 2nd 3rd 4th 5th 6th 7th 8th
                column cardinality
                filter factors
                first key cardinality
                HIGH2KEY/LOW2KEY 2nd
                inner/outer tables
                maintnenace
                optimizing 2nd 3rd
                relationships
                RUNSTATS
                SYSADMs 2nd
                troublesome queries
                unclustered indexes
                updateable 2nd 3rd 4th
                updating
                values
        DBAs 2nd 3rd
        EXPLAIN feature
       gathering
                LOAD utility
       historical
                gathering 2nd
        indexes
       inline
                gathering 2nd 3rd 4th 5th
       list of objects
                gathering
       nonuniform distribution
                deleting 2nd
       partition-level
                RUNSTATS utility
       partitions
                queries 2nd
        physical index queries
        physical tablespaces query
        Real Time.
       reports
                RUNSTATS utility
        table spaces
       UDF
                monitoring
       value
                gathering
STATISTICS keyword
        LOAD utility
statistics report sets 2nd 3rd
        EDM pools
        locking
        log management
        short 2nd 3rd 4th
Statistics Short report 2nd 3rd 4th
statistics traces 2nd
STATSDELETES column
        INDEXSPACESTATS table
        TABLESPACESTATS table
STATSINSERTS column
        INDEXSPACESTATS table
        TABLESPACESTATS table
STATSLASTTIME column
        INDEXSPACESTATS table
        TABLESPACESTATS table
STATSMASSDELETE column
        INDEXSPACESTATS table
        TABLESPACESTATS table
STATSQUEUE parameter
        DB2CONN parameter
STATSTIME column
STATSUPDATES column
        TABLESPACESTATS table
statuses
        GRECP
        LPL
STAY RESIDENT parameter
STAY RESIDENT UDF characteristic
STDDEV function
stealing
        buffer pools
STMT ENCODE column
        DSN STATEMENT TABLE
STMT TYPE column
        DSN STATEMENT TABLE
STOGROUP DB2 object
STOGROUP function
STOGROUP sample table
STOGROUP-defined data sets
       moving
                REORG utility
STOGROUPs.
STOP (/ before) command
STOP command 2nd
STOP DATABASE command
STOP DB2 command
STOP DDF command 2nd
STOP FUNCTION SPECIFIC command
        UDFs
STOP PROCEDURE command
stopping
        stored procedures 2nd
        UDFs 2nd 3rd 4th 5th 6th
storage
        4GL applications
        EDM pools, moving
        extended
        frequently used data
        indexes 2nd
        physical
                limits 2nd 3rd
        real
        Type 2 indexes 2nd 3rd
        virtual
                common areas
                private areas
        virtual.
storage areas
        EDM pools
storage group table
storage groups 2nd
        buffer pools
        default
        defining 2nd 3rd
        disk volumes
        names
        navigational queries
        SMS 2nd
                partitioned table spaces 2nd
        user-defined VSAM data sets 2nd 3rd
        volumes, assigning
STORCLAS option
        TEMPLATE statement
stored procedure address space.
Stored Procedure Address Space.
Stored Procedure Builder. 2nd
stored procedures 2nd
        application programs
        atomic parameters
        built-in 2nd
        calling 2nd
        client/server applications
        CODE/370 language
        collection IDs
        column names, returning
        consistency
        creating 2nd
                parameter lists, configuring 2nd
        data integrity
        data types
        DB2 Development Center 2nd
        DBMS protection
        developing
                LE/370 language
                nested procedure calls 2nd
                parameters 2nd
                program preparations
                result sets, returning 2nd 3rd
        DSNACCOR 2nd
        executing 2nd 3rd 4th
       external
                SQL stored procedures, compared
        failures, controlling
        flexibility
        identical input parameters
        implementing 2nd 3rd
        IMS databases, accessing
        internal DBA tools
        LE/370 language
        learning
        LONG VARCHAR/LONG VARGRAPHIC parameters
        maintenance
        managing 2nd
        monitoring 2nd
        names
        nesting
        Net.Data
        PARAMETER STYLE options
        performance
        reentrant
       registration
                Version 6 2nd
        resident
        reuseability 2nd
        security
        security, implementing
        SPB 2nd
        SQL.
        SQLCA
        starting
        static/dynamic SQL statements
        stopping 2nd 3rd
        subprograms
        temporary tables 2nd
        triggers, compared
        WLM 2nd 3rd
stored proceduress
        failures, controlling
storing
        declared temporary tables 2nd
        indexes
        metadata
        package information
        plan information
        table spaces 2nd 3rd
                primary storage 2nd 3rd 4th 5th
                secondary storage 2nd 3rd 4th 5th
        triggers
STOSPACE utility 2nd 3rd
        concurrency
        DASD usage
        DB2 Catalog updates
        JCL generation
        JCL listing
        locking
        phases
        running
strategies
        access paths
                compatibility 2nd
                indexed access 2nd 3rd 4th 5th 6th
                joins 2nd 3rd 4th 5th 6th 7th 8th 9th
                joins.
                query parallelism 2nd 3rd 4th 5th 6th
                scans 2nd 3rd
                sequential prefetch 2nd 3rd
streams
        reorganization jobs 2nd
STRIP function
Striva Corporation
strong typing
        UDTs 2nd 3rd
STRTWT RCT INIT macro parameter
structural limits 2nd 3rd 4th
structure
        indexes 2nd
Structured Query Language.
structures
        cach
       databases
                DB2 Family differences
        DB2 Catalog 2nd 3rd
        host 2nd
                application programs
        list
        lock
       locking
                specifying
sub-SELECT statements
        self-referencing
SUBID RCT INIT macro parameter
subprograms
        stored procedures
subqueries
        access paths 2nd 3rd 4th
                correlated 2nd
                inside-out subquery access
                non-correlated
                outside-in-outside subquery access
                view materialization 2nd
                view merge
        joins, compared 2nd
        multiple table data retrieval
        negation logic
        SQL 2nd 3rd
                correlated
                joins, compared 2nd
                non-correlated
subscribing
        mailing lists 2nd
SUBSTR function
subsystem
        tuning
                buffer pool parameters
                buffer pool parameters.
                buffer pool size 2nd 3rd
                buffer pools 2nd 3rd 4th 5th 6th 7th 8th
                data sharing group buffer pools 2nd 3rd 4th 5th
                DB2 Catalog 2nd 3rd 4th
                DSNZPARMs 2nd 3rd 4th 5th 6th 7th 8th 9th
                hiperpools 2nd 3rd 4th 5th
                IRLM address space 2nd
subsystem IDs
        CICS
subsystem members.
subsystem size
        buffer pool size
subsystems
        data sharing availability
       pre-exisiting
                merging into data sharing
SUFFIX RCT INIT macro parameter
suites
        Operational Utilities
        Recover and Diagnostics
SUM function
summarization data transformations
        data warehouses, populating
summary report sets 2nd
support
        education 2nd 3rd
                advanced topics
                external training
                in-house training
                industry periodicals 2nd 3rd 4th
                introductory courses (DB2)
                mailing lists
                on-site library
                reference material
        environmental
        operational 2nd
        tools required
support tables
        XML administration 2nd
                backing up
                DTD repository table 2nd
                XML usage table 2nd
surrogate keys
        rows/columns
suspending
        locks
        logs
swappable jobs
Sybase Corporation
symbolic cursors.
synchronization
        CICS
       data/indexes
                COPY utility
synchronizing
        DB2 Catalog reorganization 2nd
        views 2nd
syncpoint coordinator
syncpoint trees
synonym columns
SYNONYM DB2 object
synonyms 2nd
        authorizations
        built-in functions 2nd
       listing
                navigational queries
        names
SYSADM authority
        restricting
        revoking
SYSADM group-level authorization
SYSADM utility
        Catalog statistics, customizing
SYSADMs
        DB2 Catalog statistics 2nd
SYSAUXRELS table
SYSCHECKDEP table
SYSCHECKS table
SYSCHECKS2 table
SYSCOLAUTH table 2nd
SYSCOLDIST table 2nd 3rd
SYSCOLDIST_HIST table
SYSCOLDISTSTATS table 2nd
SYSCOLSTATS table 2nd
SYSCOLUMNS table 2nd 3rd
SYSCOLUMNS_HIST table
SYSCONSTDEP table
SYSCOPY data set
        allocating 2nd
        buffering
        MERGECOPY utility 2nd
SYSCOPY queries
        QMF forms
SYSCOPY table
SYSCOPY table space
SYSCTRL authority
SYSCTRL group-level authorization
SYSDATABASE table
SYSDATATYPES table
SYSDBASE table space
SYSDBAUT table space
SYSDBAUTH table
SYSDBRM table
SYSDDF table space
SYSDEFLT parameter
SYSDISC data sets
        space requirements
SYSDUMMY1 table
SYSFIELDS table
SYSFOREIGNKEYS table
SYSGEN
       IMS
                PROCLIM parameter
                read-only transactions
                transaction modes
                WFI transactions
SYSGPAUT table space
SYSGROUP table space
SYSGRTNS table space
SYSIBM.SYSCOPY table
        ICTYPE column
SYSIBM.SYSDUMMY1 table
       access
                granting
SYSIBM.SYSPSM table
        SQL stored procedures, creating
SYSIBM.SYSPSMOPTS table
        SQL stored procedures, creating 2nd
SYSINDEXES table 2nd 3rd
SYSINDEXES_HIST table
SYSINDEXPART table 2nd 3rd
SYSINDEXPART_HIST table
SYSINDEXSTATS table 2nd
SYSINDEXSTATS_HIST table
SYSJARCLASS_SOURCE table
SYSJARCONTENTS table
SYSJARDATA table
SYSJAROBJECTS table
SYSJAVA table space
SYSKEYCOLUSE table
SYSKEYS table
SYSLGRNX table
SYSLGRNX table space
SYSLINKS table
SYSLOBSTATS table 2nd
SYSLOBSTATS_HIST table
SYSLOCATIONS table
SYSLULIST table
SYSLUMODES table
SYSLUNAMES table
SYSMAP data sets
SYSMODESELECT table
SYSOBJ table space
SYSOPR group-level authorization
SYSPACKAGE table
SYSPACKAUTH table
SYSPACKDEP table
SYSPACKLIST table
SYSPACKSTMT table
SYSPARMS table
SYSPKAGE table space
SYSPKSYSTEM table
SYSPLAN table
SYSPLAN table space
SYSPLANDEP table
Sysplex
        distributed access requests
        query Sysplex parallelism 2nd
sysplex parallelism
        dat sharing
SYSPLSYSTEM table
SYSPRINT
       block size
                DSNTEP2 utility
                DSNTIAD utility
SYSPROCEDURES table
SYSREC data sets
        synchronizing
SYSRELS table
SYSRESAUTH table
SYSROUTINEAUTH table
SYSROUTINES table 2nd 3rd
SYSROUTINES_OPTS table
SYSROUTINES_SRC table
SYSSEQ2 table space
SYSSEQUENCEAUTH table
SYSSEQUENCES table
SYSSEQUENCESDEP table
SYSSTATS table space
SYSSTMT table
SYSSTOGROUP table
SYSSTR table space
SYSSTRINGS table
SYSSYNONYMS table
SYSTABAUTH table
SYSTABCONST table
SYSTABLEPART table 2nd
SYSTABLEPART_HIST table
SYSTABLES table 2nd 3rd
SYSTABLES_HIST table
SYSTABLESPACE table 2nd 3rd
SYSTABSTATS table 2nd 3rd
SYSTABSTATS_HIST table
system
        administration guide
       backing up
                BACKUP SYSTEM utility 2nd 3rd 4th 5th
       restoring
                RESTORE SYSTEM utility 2nd 3rd 4th
SYSTEM class privileges
system databases
        QUIESCE utility
system indexes
        reorganizing
System Managed Storage.
system of records
system pages
       placement
                COPY utility
system parameters
       customizing
                on the fly
        dynamic
system parameters report sets 2nd 3rd
system parameters.
System Services Address Space.
system table spaces
        recovering
system testing
        CASE tools support
system-defined functions
system-directed distribution 2nd
        application-directed distribution, compared
        three-part names 2nd
SYSTEM_ASCII_CCSID session variable
SYSTEM_EBCDIC_CCSID session variable
SYSTEM_NAME session variable
SYSTEM_UNICODE_CCSID session variable
systematic rebinding
        packages
systems
       MVS
                monitoring 2nd
       read-only
                RI
systems analysts
Systems Resource Manager.
SYSTRIGGERS table
SYSUSER table space
SYSUSERAUTH table
SYSUSERNAMES table
SYSUT1 data set
        MERGECOPY utility 2nd 3rd
SYSUT1 data sets
        REBUILD INDEX utility
SYSUT2 data set
        size
SYSUTILX table space
SYSVIEWDEP table
SYSVIEWS table
SYSVIEWS table space
SYSVLTREE table
SYSVOLUMES table
SYSVTREE table
SYSXLAT file
        DSN1COPY utility