index_C

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

C/S tools
cache
       authorization
                EDM pools
cache structures
CACHESIZE parameter
        BIND command
        BIND statements
caching
        indexes
        package authorization
        plan authorization
        plans
        prepared statements 2nd 3rd
        table spaces
CAE (Client Application Enabler)
CAF
        advantages/disadvantages 2nd
        calls
        sample applications
        threads, creating 2nd
        vendor tools
CAF (Call Attach Facility)
Call Attach Facility.
Call Level Interface.
CALL statements
        stored procedures
calling
        stored procedures 2nd
calls
        CAF
Candle Computer Report (ital)
Candle Corporation
cardinal rule (RDBMS development)
cardinality
       column
                indexes 2nd
cardinality (table UDFs)
        overriding
CARDINALITY keyword
CARDINALITY UDF characteristic
Cartesian products
        avoiding
        SQL 2nd 3rd
CASCADE option
        referential constraints
cascading delete rule
        online applications
CASE (computer-aided software engineering)
CASE expressions 2nd 3rd
        rows, counting
CASE tools
        application development 2nd
                business strategy support
                data modeling support
                development support
                diagramming support
                generated SQL
                I/O routines
                integrated development platforms
                metadata support
                multiple platform support
                process modeling support
                prototyping support
                quality assurance support
                runtime modules
                system testing support
                technical environment support
CAST function
        data type equivalency
        UDFs
casting functions
        UDTs 2nd
CASTOUT parameter
        member shutdowns
castout process
        data sharing group buffer pools
CASTOWNR parameter
        buffer pools
CAT tools 2nd
Catalog
        statistics, customizing
Catalog (DB2)
        active 2nd
        CHECK INDEX utility
        columns , customizing
       data sets
                multiple extents
                reorganizing
                SQL access, monitoring
        DDL
        first-time effect
        I/O
       indexes
                rebuilding
        integrated
        links 2nd 3rd
        nonsubvertible
        proliferation
        queries 2nd
        queries.
        reorganizing 2nd
                synchronizing 2nd
                table spaces 2nd
        REPAIR LOCATE utility
        semiactive
        shadow copies
        size
        statistics 2nd 3rd 4th 5th 6th 7th 8th
                column cardinality
                filter factors
                first key cardinality
                HIGH2KEY/LOW2KEY 2nd
                inner/outer tables
                maintenance
                optimizing 2nd 3rd
                relationships
                RUNSTATS
                SYSADMs 2nd
                troublesome queries
                unclustered indexes
                updateable 2nd 3rd 4th
                updating
                values
        structure 2nd 3rd
        tables 2nd 3rd 4th 5th
                IPLIST
                IPNAMES
                LOCATIONS
                LULIST
                LUMODES
                LUNAMES
                MODESELECT
                SYSAUXRELS
                SYSCHECKDEP
                SYSCHECKS
                SYSCHECKS2
                SYSCOLAUTH 2nd
                SYSCOLDIST
                SYSCOLDIST_HIST
                SYSCOLDISTSTATS
                SYSCOLSTATS
                SYSCOLUMNS
                SYSCOLUMNS_HIST
                SYSCONSTDEP
                SYSCOPY
                SYSDATABASE
                SYSDATATYPES
                SYSDBAUTH
                SYSDBRM
                SYSDUMMY1
                SYSFIELDS
                SYSFOREIGNKEYS
                SYSINDEXES
                SYSINDEXES_HIST
                SYSINDEXPART
                SYSINDEXPART_HIST
                SYSINDEXSTATS
                SYSINDEXSTATS_HIST
                SYSJARCLASS_SOURCE
                SYSJARCONTENTS
                SYSJARDATA
                SYSJAROBJECTS
                SYSKEYCOLUSE
                SYSKEYS
                SYSLINKS
                SYSLOBSTATS
                SYSLOBSTATS_HIST
                SYSPACKAGE
                SYSPACKAUTH
                SYSPACKDEP
                SYSPACKLIST
                SYSPACKSTMT
                SYSPARMS
                SYSPKSYSTEM
                SYSPLAN
                SYSPLANDEP
                SYSPLSYSTEM
                SYSPROCEDURES
                SYSRELS
                SYSRESAUTH
                SYSROUTINEAUTH
                SYSROUTINES
                SYSROUTINES_OPTS
                SYSROUTINES_SRC
                SYSSEQUENCEAUTH
                SYSSEQUENCES
                SYSSEQUENCESDEP
                SYSSTMT
                SYSSTOGROUP
                SYSSTRINGS
                SYSSYNONYMS
                SYSTABAUTH
                SYSTABCONST
                SYSTABLEPART
                SYSTABLEPART_HIST
                SYSTABLES
                SYSTABLES_HIST
                SYSTABLESPACE
                SYSTABSTATS
                SYSTABSTATS_HIST
                SYSTRIGGERS
                SYSUSERAUTH
                SYSVIEWDEP
                SYSVIEWS
                SYSVLTREE
                SYSVOLUMES
                SYSVTREE
                USERNAMES
       tablespaces
                separating
        tuning 2nd 3rd 4th
                contnetion 2nd 3rd
                data set placement 2nd
                data sets
                indexes 2nd
                performance
                reorganizing
                RUNSTATS
                size
                SQL access, monitoring
                tablespaces, separating
                timeouts/deadlocks
        updates
       utilities
                CATENFM
                CATMAINT 2nd
                DSNJCNVB 2nd 3rd
                MODIFY.
                RUNSTATS 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th
                RUNSTATS.
                STOSPACE 2nd 3rd
        Version 4 features
        Version 5 features
        Version 6 features
Catalog Integrity Verification utility.
Catalog query and analysis tools 2nd
CATENFM utility
CATMAINT utility 2nd
CCSID parameter
        DSNJU003 utility
        table spaces 2nd
        tables
CCSID UDF
        text
CCSID_ENCODING function
CDB 2nd
CDB (Communication Database)
CDB (Communications Database)
CDB Sofware Inc.
CDRA (Character Data Representation Architecture)
CEIL function
CEILING function
century timestamp unit
CF
        cache structures
        defining
        failures
        global data buffering 2nd
                buffer pools
                group buffer pool duplexing 2nd
                updating/reading data 2nd
        global locking management 2nd
        inter-system communications
        list structures
        lock structures
        multiple
        naming conventions
        recovery
CF (Coupling Facility)
CFRM (Coupling Facility Resource Management)
CHANGE (/ before) command
Change Log Inventory utilty.
CHANGELIMIT parameter
        COPY utility 2nd 3rd
CHAR data type
        promotability
CHAR function
character data
        Java
Character Data Representaiton Architecture.
character data types (DB2 Connect)
Character Large Objects.
characteristics
        UDFs 2nd 3rd
characters
        naming conventions
CHARDEL parameter
CHARONWARE
check constraints 2nd 3rd
        advantages
        checking 2nd
        data warehouses
        domains, simulating 2nd 3rd
        names
        navigational queries
        semantics
        table-level coding
        triggers, compared 2nd
CHECK DATA utility
        bypassing
        check constraints 2nd
        check pending status
        DELETE YES parameter
        exception tables
        indexes
        informational referential constraints
        LOB references 2nd
                AUXERROR parameter
                SCOPE parameter
        locks
        partition levels
        phases 2nd
        referential integrity
        rerunning
        running
        SCOPE PENDING option
        work data sets 2nd
CHECK INDEX utility 2nd 3rd
        dangerous operations
        DB2 Catalog
        locks
        partition levels
        phases
        rerunning
        running
        work data sets 2nd
CHECK LOB utility 2nd
        EXCEPTIONS parameter
        locks
        phases
check pending flags
        correcting
        reasons for 2nd
        repairing
check pending status
        checking
CHECK utility
Chicago-Soft Products Ltd.
CHKFREQ parameter
CICS 2nd
        accounting records
        AEY9 bends, avoiding
        application size 2nd
        Attach Facility 2nd 3rd 4th
        Attach Facility availability 2nd
        COBOL file processing
        COBOL verbs
        COMD entries
        command thread attributes 2nd
        conditional table access
        connection attributes 2nd
        conversational applications
        DDLs
        debugging
        design
        DSNC DISPLAY STATISTICS command
        dynamic plan selection 2nd
        file processing commands
        IMS, compared
        language interface
        linking
        locking problems
        paragraphs, executing
        plan management 2nd
        plans
        pool thread attributes 2nd 3rd
        pool threads 2nd
        program preparation 2nd
        prorams
        protected threads
        RACF authoriation
       RCT
                RDO, compared 2nd
        RCT parameters 2nd 3rd
                AUTH values
                COMD macro 2nd 3rd
                ENTRY macro 2nd 3rd 4th
                INIT macro 2nd 3rd 4th
                POOL macro 2nd
       RCTs
                migrating to RDO
        RDO 2nd
        RDO parameter wildcarding
        RDO parameters
                DB2CONN 2nd 3rd 4th 5th 6th 7th 8th
                DB2ENTRY 2nd 3rd 4th
                DB2TRAN 2nd
        RDO vs RCT 2nd
        rollbacks
        security
        sequential number assignments
        SQL
        subsystem IDs
        synchronization
        tables 2nd
                FCT
                PCT
                PPT
                RCT
        tasks
       TCBs
                maximum
        THRDA parameter
        THRDM parameter
        thread operation attributes 2nd
        thread selection attributes
        thread types 2nd
        threads 2nd
        transactions
        transactions, grouping
        two-phase commits 2nd
        variables , iniatilizing
CICS (Customer Information Control System)
CICS commands 2nd 3rd
        controlling
        transactions, monitoring
CICS preprocessors
        program preparation
CLAIMERS clause
        DISPLAY DATABASE command
claims 2nd
        classes
        drains compatibility 2nd 3rd
classes
        accounting trace
        accounting traces
        applications 2nd
        audit trace
        claims
        dynamic SQL
        monitor traces
        performance traces 2nd
       privileges
                COLLECTION
                DATABASE
                DISTINCT TYPE
                FUNCTION
                PACKAGE
                PLAN
                SCHEMA
                SYSTEM
                TABLE
                USE
                VIEW
        statistics traces
clasues
        GROUP BY
        HAVING
                WHERE clause, compared 2nd
        ORDER BY
       WHERE
                HAVING clause, compared 2nd
clauses
       ACTION
                stored procedures
        AUDIT
       CLAIMERS
                DISPLAY DATABASE command
        DISTINCT keyword
       EDITPROC
                compression routines
       EXCLUDE
                LISTDEF statement 2nd
        FETCH FIRST n ROWS ONLY
       FOR FETCH ONLY
                cursors
        FOR READ ONLY
                cursors 2nd
        FOR UPDATE OF
                data integrity
                DECLARE CURSOR statement
                SELECT statements
       GROUP BY
                columns
                ORDER BY clause, compared
       HAVING
                column function results
                MQTs
       IN DATABASE
                tables
       INCLUDE
                LISTDEF statement 2nd
        join search criteria
        KEEP UPDATE LOCKS
       LIKE
                table schemas
       LOCKS
                DISPLAY DATABASE command
       NEXT VALUE FOR
                sequence objects
        OPTIMIZE FOR n ROWS
                optimizer, influencing 2nd 3rd
       OPTIMIZE FOR n ROWS clause
                distribution performance
       ORDER BY
                columns
                DSNTIAUL utility
                GROUP BY, compared
                joins
                row sequencing
                rows
                top ten retrieval
        PIECESIZE 2nd 3rd
        RETAIN CURSORS SAVEPOINT
        RETAIN LOCKS
        SCRATCHPAD
       SHRLEVEL REFERENCE
                offsiet copies
        UNIQUE WHERE NOT NULL
       WHEN
                CASE expressions
                triggers
       WHERE
                data filtering
                DSNTIAUL utility
                primary keys
                scalar functions
       WHERE CURRENT OF
                UPDATE/DELETE statements
       WITH
                isolation levels
        WITH CASCADED CHECK OPTION
       WITH CHECK OPTION
                views 2nd
       WITH HINT
                data encryption
       WITH HOLD
                locks
        WITH LOCAL CHECK OPTION
       WITH NO DATA
                MQTs 2nd
cleansing
       data
                data warehouses 2nd
                data warehouses, populating 2nd 3rd
                data warehouses, populating;reformatting
                data warehouses, populating;value validation 2nd
CLI (Call Level Interface)
CLIENT ACCTNG register
Client Application Enabler.
CLIENT APPLNAME register
CLIENT USERID register
CLIENT WORKSTNNAME register
client/server applications
        complex environment
        DB2 connections 2nd
        distributed cursors
        SQL anomalies
        SQL requests , consolidating
        stored procedures
        tools documentation
        triggers
client/server environments
        Net.Data support
client/server processing
client/server tools
clients /servers
        Version 4 features
CLIST
        program preparation
                bind CLIST 2nd
                precompile/compile/link CLIST 2nd
CLOB data type
        promotability
CLOB function
CLOBs (Character Large Objects)
cloning
        programs
CLOSE parameter
        table spaces 2nd 3rd
CLOSE statement
        cursors
CLOSE statements
        cursors
closing
        cursors
        VSAM data sets 2nd 3rd
closing points
        cursors
CLUSTER keyword
clustered columns
        joins
clustered index access
clustering
        indexes 2nd
                customizing 2nd
        locks
        partitioned table spaces
        REORG utility
        RUNSTATS utility
clustering indexes
        ignoring
CLUSTERRATIOF column
CMs (conversation managers)
COALESCE function
        outer joins 2nd
        table expressions
COBOL
        host variables
        SQL, compared 2nd
        verbs
COBOL error-handling paragraph example 2nd
COBOL EXECUTE IMMEDIATE statement listing
COBOL file processing
COBOL non-SELECT dynamic SQL program
COBOL stored procedure shell 2nd
Codd, E. F
code (DB2)
        tuning
code bases
        DB2 Family
code literals
        SQL statements
code tables
        multi-table table spaces
CODE/370 language
        stored procedures
Cognos Inc.
COLARDF column
COLDEL parameter
collection access method
COLLECTION class privileges
collection identifiers
        packages
collection IDs
        stored procedures
collections 2nd 3rd 4th
        BIND statements
        CURRENT PACKAGE PATH special register
       multiple
                packages
        names
        package list size
        size
COLLID column
        DSN STATEMENT TABLE
        DSN_FUNCTION_TABLE table
        PLAN TABLE
COLLID parameter
        stored procedures
column access method
column authority query
column cardinality
        indexes 2nd
COLUMN DB2 object
COLUMN FN EVAL column
        PLAN TABLE
column functions 2nd 3rd
        AVG
        COUNT 2nd
        COUNT_BIG
        MAX
        MIN
        STDDEV
        SUM
        VARIANCE
column group statistics
       gathering
                RUNSTATS utility 2nd
column statistics
       gathering
                RUNSTATS utility 2nd
columns
        abbreviation standards
        ACENDATE
        ACSTDATE
       adding
                base table views 2nd 3rd
                indexes 2nd
       APPLNAME
                DSN_FUNCTION_TABLE table
       attributes
                MQTs 2nd
        average per table query
        averages
        avoiding (indexes)
       BIND_OPTS
                SYSIBM.SYSPSMOPTS table
       BUILDNAME
                SYSIBM.SYSPSMOPTS table
       BUILDOWNER
                SYSIBM.SYSPSMOPTS table
       BUILDSCHEMA
                SYSIBM.SYSPSMOPTS table
        changed, updating
       clustered
                joins
        CLUSTERRATIOF
        COLARDF
       COLLIC
                DSN_FUNCTION_TABLE table
       COMPILE_OPTS
                SYSIBM.SYSPSMOPTS table
        compressing
        correlated
        critical
        data types 2nd
                customizing 2nd 3rd 4th
        data types, selecting 2nd 3rd
        date/time data
        date/time stamp 2nd
       DB2 Catalog
                customizing
        decimal
       DECIMAL
                LOAD utility
        defaults 2nd
        defining
       deleting
                base table views
        DSN FUNCTION TABLE
        DSN STATEMENT TABLE 2nd 3rd
                APPLNAME
                COLLID
                COST CATEGORY
                EXPLAIN TIME
                GROUP MEMBER
                PROCMS
                PROCSU
                PROGNAME
                QUERYNO
                REASON
                STMT ENCODE
                STMT TYPE
        DSN_FUNCTION_TABLE table 2nd
        EMENDATE
        EMSTDATE
       EXPLAIN_TIME
                DSN_FUNCTION_TABLE table
        expressions 2nd
        extra (indexes)
        FARINDREF
        FAROFFPOSF
        FIRSTKEYCARDF
        FULLKEYCARDF
        function results, searching
       FUNCTION_NAME
                DSN_FUNCTION_TABLE table
       FUNCTION_TEXT
                DSN_FUNCTION_TABLE table
       FUNCTION_TYPE
                DSN_FUNCTION_TABLE table
       GROUP_MEMBER
                DSN_FUNCTION_TABLE table
        grouping
        homonyms
       ICTYPE
                SYSIBM.SYSCOPY table
        identity 2nd
        IDENTITY
       identity
                copying
       IDENTITY
                navigational queries
       identity
                problems 2nd
                sequence objects, compared 2nd
                values
                Version 7 enhancements 2nd
        indexed
                joins
                updating
        indexes
        INDEXSPACESTATS table 2nd 3rd
        integer 2nd
        labels
        largest values, returning
        LEAFDIST
       LINK_OPTS
                SYSIBM.SYSPSMOPTS table
        listing
       LOB
                pages 2nd
       LOBs
                defining 2nd
        LOBs, creating 2nd 3rd
                auxiliary tables
                defining
                example 2nd
                LOB table spaces
                populating
                unique indexes
        long
       multiple
                indexes
        names 2nd 3rd
                CTEs
                returning
                views
        NEARINDREF
        NEAROFFPOSF
       null
                referencing
        nullable
                LOAD utility
        nulls 2nd 3rd 4th
                avoiding
                database design
                equivalency
                IS NOT DISTINCT FROM comparison operator
                IS NULL predicate
                overview
        ordering 2nd 3rd
        PAGESAVE
       PATH
                DSN_FUNCTION_TABLE table
        PERCDROP
        PLAN TABLE 2nd 3rd 4th 5th 6th
                ACCESS DEGREE
                ACCESS PGROUP ID
                ACCESSCREATOR
                ACCESSNAME
                ACCESSTYPE
                APPLNAME
                BIND TIME
                COLLID
                COLUMN FN EVAL
                CORRLEATION NAME
                CREATOR
                GROUP MEMBER
                HINT USED
                IBM SERVICE DATA
                INDEXONLY
                JOIN DEGREE
                JOIN PGROUP ID
                JOIN TYPE
                MATCHCOLS
                MERGE JOIN COLS
                METHOD
                MIXOPSEQ
                OPTHINT
                PAGE RANGE
                PARALLELISM MODE
                PARENT QBLOCKNO
                PARIMARY ACCESSTYPE
                PLANNO
                PREFETCH
                PROGNAME
                QBLOCK TYPE 2nd
                QBLOCKNO
                QUERY NO
                REMARKS 2nd
                ROUTINE ID
                SORTC GROUP
                SORTC JOIN
                SORTC ORDERBY
                SORTC PGROUP ID
                SORTC UNIQ
                SORTN GROUPBY
                SORTN JOIN
                SORTN ORDERBY
                SORTN PGROUP ID
                SORTNO UNIQ
                TABLE DCCSID
                TABLE ENCODE
                TABLE MCCSID
                TABLE SCCSID
                TABLE TYPE
                TABNO
                TIMESTAMP
                TNAME
                TSLOCKMODE
                VERSION
                WHEN OPTIMIZE
        PLAN_TABLE 2nd
       PRECOMPILE_OPTS
                SYSIBM.SYSPSMOPTS table
        prefixing 2nd
       PRELINK_OPTS
                SYSIBM.SYSPSMOPTS table
       PROCEDURENAME
                SYSIBM.SYSPSMOPTS table
       PROGNAME
                DSN_FUNCTION_TABLE table
       QBLOCKNO
                DSN_FUNCTION_TABLE table
       QUERYNO
                DSN_FUNCTION_TABLE table
        renaming 2nd
       required
                Java
        RLSTs 2nd
       ROWID
                direct row access
                LOBs 2nd
       SCHEMA
                SYSIBM.SYSPSMOPTS table
       SCHEMA_NAME
                DSN_FUNCTION_TABLE table
        security label
        sequence objects 2nd 3rd
                creating
                identity columns, compared 2nd
                parameters
                performance
        sequencing 2nd
        smallest values, returning
        SMALLINT
       SOURCEDSN
                SYSIBM.SYSPSMOPTS table
       SPEC_FUNC_NAME
                DSN_FUNCTION_TABLE table
        STATSTIME
        sum
        surrogate keys
        synonyms
        tables 2nd
                ROWID
                sequence objects
        TABLESPACESTATS table 2nd 3rd
        uniqueness
        updating
        values, counting 2nd
       VARCHAR
                indexes
                LOBs, compared 2nd 3rd
                maximum size
                REORG utility
       VARGRAPHIC
                LOBs, compared 2nd 3rd
       variable
                indexes 2nd
        variable character 2nd
                compression, compared
                customizing
                effectiveness 2nd
       VIEW_CREATOR
                DSN_FUNCTION_TABLE table
       VIEW_NAME
                DSN_FUNCTION_TABLE table
        wasted space
COM tools 2nd
COMAUTHID parameter
        CICS command thread attributes
COMAUTHTYPE parameter
        CICS command thread attributes
combined tables
        base table views
        denormalization
COMD entries
        CICS
COMD macro parameters
        RCT 2nd 3rd
                AUTH
                EOLBE
                THRDA
                THRDM
                THRDS
                TWAIT
come-from checking
command processors
       DSN
                invoking
command thread attributes
        DB2CONN parameter 2nd
commands
        /CHANGE
        /DISPLAY
        /SSR
        /START
        /STOP
        /TRACE
        ABEND
        administrative 2nd 3rd 4th
                active traces
                ALTER BUFFERPOOL
                ALTER UTILITY
                ARCHIVE LOG 2nd
                RECOVER INDOUBT
                START DATABASE 2nd
                START PROCEDURE
                START RLIMIT
                START TRACE 2nd
                START/STOP
                STOP
                STOP DATABASE
                system parameters
                TERM UTILITY 2nd
        ALTER BUFFERPOOL 2nd
        ALTER UTILITY
        ARCHIVE LOG 2nd
                disaster recovery
        BIND
                CACHESIZE parameter
                program preparation 2nd
                reactive governing
       BIND PACKAGE
                program preparation
       BIND PLAN
                program preparation
        CICS 2nd 3rd
                controlling
                transactions, monitoring
        CICS file processing
        cursors
        DCLGEN
                program preparation 2nd 3rd 4th 5th
       DELETE
                CICS file processing
        DISPLAY
                OVERVIEW parameter
                resource status, viewing
        DISPLAY BUFFERPOOL
                DETAIL parameter
        DISPLAY DATABASE 2nd 3rd 4th 5th
                ACTIVE parameter
                CLAIMERS/LOCKS clauses
                RESTRICT parameter
                USE parameter
                wildcards
        DISPLAY FUNCTION SPECIFIC 2nd
        DISPLAY GROUP
        DISPLAY LOG
        DISPLAY PROCEDURE 2nd
        DISPLAY UTILITY 2nd
                LOAD utility
                utilities, monitoring
       DRAW
                QMF
        DSN 2nd 3rd 4th
                group attach processing
                sessions, terminating
                tracing
        DSNC
        DSNC DISCONNECT
        DSNC DISPLAY
        DSNC DISPLAY STATISTICS 2nd
        DSNC MODIFY
        DSNC STOP
        DSNC STRT
        DSNH
        DSNU
        END
       ENDBR
                CICS file processing
        environment
                information-gathering.
                issuing with DB2I 2nd
                structure
        environment control 2nd
                security
       EXPLAIN
                auto rebinds
                simple statements 2nd
       EXPORT
                QMF
        FREE
        IMS 2nd 3rd
        information-gathering 2nd
                active objects, viewing
                buffer pools, monitoring
                buffer pools, tuning
                centralized areas
                database information, viewing
                database usage
                grouping buffer pools
                information, limiting
                LIMIT parameter
                LIST/LSTATS parameters
                locking information, viewing
                logging, monitoring
                LPLs, viewing
                objects, monitoring 2nd 3rd 4th
                OVERVIEW parameter
                restricted objects
                stored procedures, monitoring
                UDF statistics, monitoring
                utilities, monitoring 2nd
                wildcards
        IRLM 2nd 3rd
       LOCK TABLE
                batch programs
       LOG SUSPEND
                Version 7 enhancements
       READ
                CICS file processing
       READNEXT
                CICS file processing
       READREADPREV
                CICS file processing
        REBIND
        RECOVER INDOUBT
       RESETBR
                CICS file processing
       REWRITE
                CICS file processing
        RUN
       SET
                QMF
       SET LOG SUSPEND
                disaster recovery 2nd
        SET SYSPARM
        SPUFI
        START
                UDFs
        START DATABASE 2nd
        START DB2
        START DDF 2nd
        START PROCEDURE 2nd
        START RLIMIT
        START TRACE 2nd
       STARTBR
                CICS file processing
        STOP 2nd
        STOP DATABASE
        STOP DB2
        STOP DDF 2nd
       STOP FUNCTION SPECIFIC
                UDFs
        STOP PROCEDUREs
       TERM
                utilities, monitoring
        TERM UTILITY 2nd
        TSO
       WRITE
                CICS file processing
       XRST
                IMS
COMMENT ON statement
        tables
Comment UDF
        audio
        image
        video
comments
        DSNTEP2 utility
        DSNTIAD
        embedded SQL statements
        REXX
        SQL statements
        tables
commit scope.
COMMIT statements
        stored procedures
COMMIT statemetns
       batch programs
                data customizations 2nd
                lock timeouts
                scheduling
commits
        data sharing
        online applications
        TSO
       two-phase
                CICS 2nd
                IMS 2nd 3rd
common areas
        virtual storage
common table expressions.
Common Table Expressions.
common threads
        CICS
Communication Database.
communications
       inter-system
                CF
Communications Database.
comparison operators
       IS NOT DISTINCT FROM
                nulls
        UDTs
comparisons
        BETWEEN predicate
        IN predicate
        LIKE predicate
compatibility
        access paths strategy 2nd
        claims/drains 2nd 3rd
        page locks
        row locks
        table space locks
COMPILE_OPTS column
        SYSIBM.SYSPSMOPTS table
compiling
        programs
complex SQL statements
        application programs
complex statements
        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
                Top Ten 2nd
                unions 2nd
compliance
        names
COMPRESS parameter
        table spaces
                third-party solutions 2nd 3rd
compressing
        columns
        data
                data warehouses
       image copies
                COPY utility
        PLAN TABLEs
        table spaces
                advantages
                disadvantages
                third-party solutions 2nd
compression
        disaster recovery
       planning
                DSN1COMP utility
Compression Analyzer utility.
compression dictionaries
compression tools 2nd
CompressType UDF
        video
Computer Associates
computer-aided software engineering.
ComputerWorld (ital)
Compuware Corporation
COMTHREADLIMIT parameter
        CICS command thread attributes
CONCAT function
concentrators (connection)
concurrency
        BACKUP SYSTEM utility
        COPY utility 2nd
        COPYTOCOPY utility
        LOAD utility 2nd
        MERGECOPY utility
        online applications
        QUIESCE utility
        REBUILD INDEX utility
        RECOVER utility
        REORG utility
        RESTORE SYSTEM utility
        RUNSTATS utility
        STOSPACE utility
        UNLOAD utility
concurrent copies
        recovering
concurrent copying
concurrent packages
        estimating
concurrent plans
        estimating
concurrent users
conditional table access
        CICS
CONNECT statement
CONNECTERROR parameter
        CICS connection attributes
connecting
        DB2 2nd
connection attributes
        DB2CONN parameter 2nd
connection concentrators
CONNECTION parameter
        SSMs
connection pooling 2nd
connection pools
        inactive threads 2nd
connections
       application-directed distribution
                establishing
                releasing 2nd
        Net.Data
        type-2
consistency
        stored procedures
        UDFs
       utilities
                CHECK
                CHECK DATA 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd
                CHECK DATA.
                CHECK INDEX 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
                CHECK LOB 2nd 3rd 4th 5th
                DIAGNOSE
                REPAIR 2nd 3rd
                REPAIR DBD 2nd 3rd 4th 5th
                REPAIR LOCATE 2nd 3rd 4th 5th 6th 7th 8th 9th 10th
                REPAIR SET 2nd 3rd 4th 5th 6th
                REPORT
                REPORT TABLESPACESET 2nd 3rd 4th
consistency tokens
        BIND statements
consistent authids
consistent image copies
        recovering
console messages
        performance monitoring 2nd 3rd 4th
                BCT plan
                BINDCT plan
                locking contention
                log offloading
                resource unavailable
                timeouts
constants
        UDTs 2nd
constraints
       check
                checking 2nd
                data warehouses
        column data type changes
        informational referential
       referential
                AQR 2nd
        specifying
constratins
       informational referential
                checking
Contains UDF
        text
Content Manager
Content UDF
        audio
        image
        video
        XML extenders
ContentA UDF
        audio
        image
        video
contention
        monitoring
        throughput
contentsion
        utilities 2nd 3rd
continuous block fetches 2nd 3rd
control cards
        utilities 2nd
control statements
        EXEC SQL 2nd 3rd 4th
                cursor-driven SELECT statements
                issuing 2nd
                non-SELECT dynamic statements
        LISTDEF
       LOAD
                creating
        OPTIONS
                OFF keyword
                PREVIEW keyword
        TEMPLATE
controls
       access
                row-level MLS
conversation managers.
conversational applications
conversions
       data
                LOAD utility
CONVLIMIT parameter
coordinators (parallelism)
COPY jobs
copy pending flags
        correcting
        repairing
COPY utility 2nd 3rd
        backups
        CHANGELIMIT parameter 2nd 3rd
        concurrency 2nd
        data/index synchronization
        DFSMS
        disks
        dual image copies
       full image copies
                small table spaces
        full image copy JCL
        image copies, compressing
        incremental image copy JCL
        incremental/full image copies, balancing
        index copy JCL
        indexes 2nd
        locking 2nd
        logs, suspending
        performance
        phases
        recovery points
        recovery time
        restarting
        RI- related objects, copying
        sequential prefetch
        SYSCOPY data set, allocating 2nd
        SYSCOPY data set, buffering
        SYSIBM.SYSCOPY table
        system page placement
COPYCHANGES column
        INDEXSPACESTATS table
        TABLESPACESTATS table
copying
        concurrent
        disaster recovery plans
       indexes
                COPY utility
        PCBs
        RI-related objects
COPYLASTTIME column
        INDEXSPACESTATS table
        TABLESPACESTATS table
COPYTOCOPY utility 2nd
        concurrency
        inline copies
        JCL example
        locking
        phases
        running 2nd 3rd
COPYUPDATEDPAGES column
        INDEXSPACESTATS table
        TABLESPACESTATS table
COPYUPDATELRSN column
        INDEXSPACESTATS table
        TABLESPACESTATS table
COPYUPDATETIME column
        INDEXSPACESTATS table
        TABLESPACESTATS table
core functionality
        utilities 2nd
correlated columns
correlated subqueries 2nd 3rd
CORRELATION NAME column
        PLAN TABLE
COS function
COSH function
CoSORT
COST CATEGORY column
        DSN STATEMENT TABLE
cost estimates
        DSN STATEMENT TABLE 2nd
                columns 2nd 3rd
                creating
                version 8
cost estimations
        EXPLAIN feature
costs
       CPU
                optimizer
       I/O
                optimizer
COUNT function 2nd
COUNT_BIG function
Coupling Facility Resource Management.
Coupling Facility.
CPU and Elapsed Time (long accounting report) 2nd 3rd
CPU costs
        optimizer
CPU parallelism
CPUs
        query CP parallelism
        tuning 2nd 3rd 4th 5th
CRC parameter
        SSMs
CREATE GLOBAL TEMPORARY TABLE statement
CREATE INDEX statement
CREATE INDEX statemetn
CREATE LOB TABLESPACE statements
CREATE PROCEDURE statement
CREATE TABLE statement
        AUDIT clause
CREATE TRIGGER DDL statement 2nd 3rd 4th 5th 6th
        activation
        events, selecting
        examples 2nd 3rd
        granularity
        logic
        SQL statements
        tables, defining
        transition variables 2nd
        WHEN clause
created temporary tables 2nd
        advantages
CREATOR column
        PLAN TABLE
critical columns
critical masses 2nd
critical programs
        resident, creating
Cross Access Corp.
cross-posting
        newsgroups
Cross-system Coupling Facility.
Crystal Decisions
CSECTs
CTEs 2nd
        column names
        cyclic references
        recursion 2nd
        Version 8
CTEs (common table expressions)
CTEs (Common Table Expressions)
CTHREAD paraemter
CURRENT keyword
        scrollable cursors
CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION register
CURRENT PACKAGE PATH special register
CURRENT REFRESH AGE register
CURRENTCOPYONLY parameter
CURRENTDATA parameter 2nd
CURRENTSERVER parameter
cursor-driven SELECT statements
cursors
        ambiguous
        application programs
        avoiding
        block fetches
                ambiguous
                FOR READ ONLY/FOR FETCH ONLY clauses
                non-updateable
                read-only
        closing
        closing points
        column updates
        commands
        data customizations 2nd 3rd
        declaring
        defining
       distributed
                client/server applications
        host variables, initializing
        non-updatable
        ODBC
        opening 2nd
        positioning, saving
        processing 2nd
        read-only access
        repositioning
                batch programs
                online browsing 2nd
        resources, releasing
       results table data, returning results tables
                data, returning;cursors tables;results;data, returning
        row retrieval
        rows, deleting
        rowset positioning 2nd
                data customizations
                multiple rows, adding
        scrollable 2nd 3rd
                asensitive
                declared temporary tables
                dynamic 2nd 3rd
                insensitive
                keywords
                pseudo-conversational CICS programs
                result set navigation
                sensitive
                static 2nd
                types 2nd
                Version 7 enhancements 2nd
                warnings
        stability
        unambiguous
        UPDATE/DELETE statements
        updating
Customer Information Control System.
customizing
       access
                dynamic SQL 2nd
        access paths
        Catalog statistics
        column data types 2nd 3rd 4th
                impact 2nd 3rd
                limitations
        data
                changed columns, updating
                column updates
                columns, listing
                cursors 2nd 3rd
                DELETE statements
                FOR UPDATE OF clause
                generated values, retrieving
                indexed columns, updating
                large insertions
                long columns
                mass DELETE
                multiple rows, adding
                row updates
                rowset positioning cursors
                self-referencing DELETE statements
                self-referencing sub-SELECT statements
                UPDATE statements
        databases.
        DB2 Catalog columns
        indexes 2nd
                clustering 2nd
                columns, adding 2nd
       system parameters
                on the fly
        table space partitioning 2nd 3rd 4th
                adding partitions 2nd
                boundaries
                rebalancing partitions 2nd
                rotating partitions 2nd
        variable character columns
        variable index keys 2nd
customizing data
        data integrity
        INSERT statements
        LOAD utility vs INSERT statements
        multiple rows, adding
        primary keys
        UPDATE/DELETE statements
cyclic references
        CTEs
cylinder allocations
        table space storage allocation