index_O

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

OBID parameter
        tables
OBID queries
        QMF forms
OBIDs
       record
                translating
        specifying
OBIDXLAT option (DSN1COPY utility)
object migration tools
object/relational database management system
        defined 2nd
objects
       active
                viewing
       DB2
                ALIAS
                COLUMN
                DATABASE
                defining 2nd
                hierarchy
                INDEX
                native data types 2nd
                security 2nd
                STOGROUP
                SYNONYM
                TABLE
                TABLESPACE
                VIEW
        dropping
        large.
        naming conventions
        non-partitioned
                VSAM data sets 2nd
        pages 2nd
       partitioned
                VSAM data sets 2nd
        physical
        program preparation 2nd
       restricted
                viewing
       RI- related
                copying
        sequence 2nd 3rd
        SEQUENCE
       sequence
                creating
                identity columns , compared 2nd
       SEQUENCE
                navigational queries
       sequence
                parameters
                performance
        stopped
                starting
objects (DB2)
        identifiers
ODBC
        application development 2nd 3rd 4th
                administration
                COMMIT/ROLLBACK
                cursors
                DRDA, compared
                embedded SQL
                parameter markers
                portability
                restrictions
                return codes
                sample code 2nd
                SQLError() function
ODBC ( Open Database Connectivity)
ODS 2nd
ODS (Operational Data Store)
OFF keyword
        OPTIONS control statement
Offline Copy utility.
offloading
        logs
                performance
offloading logs
OFFPOSLIMIT parameter
        REORG utility
offsite copies
        SHRLEVEL REFERENCE clause
OLAP 2nd
OLAP (on-line analytical processing)
OLAP (On-Line Analytical Processing)
OLAP server
old recovery information
OLTP (on-line transaction processing)
on-line analytical processing.
On-Line Analytical Processing.
on-line transaction processing.
on-site library
one-phase commit distribution
        two-phase, compared
one-time processing
        EXECUTE IMMEDIATE statement
online
        IMS/TM applications 2nd
online applications
        cascading delete rule
        commits
        concurrency, increasing
        cursor repositioning 2nd
        data sorting
        direct row access 2nd
        empty tables
       joins
                limiting
        list prefetch, disabling
        modifications, saving
        overactive data 2nd
        pages retrieved
        sequential values
        timestamps
        transactions
        TSO
                binding
                design 2nd 3rd 4th 5th
                DSN command processor 2nd
online DB2 performance monitors
        GUI workstations
        MainView
        overview
        VTAM 2nd
online reorganizations 2nd
        disadvantages
        mapping tables 2nd
        parameters
                DEADLINE
                DELAY
                LONGLOG
                MAXRO 2nd
online schema changes
        column data types 2nd 3rd 4th
                impact 2nd 3rd
                limitations
        exception states
        implementing
        indexes
                clustering 2nd
                columns, adding 2nd
                variable index keys 2nd
        pre-V8
        table space partitioning 2nd 3rd 4th
                adding partitions 2nd
                boundaries
                rebalancing partitions 2nd
                rotating partitions 2nd
        V8 new features 2nd
        versioning 2nd
                deactivating versions
                new versions
online utilities
        generating
                DB2I JCL generation panels 2nd 3rd 4th
        monitoring 2nd
        partition levels
        return codes
        UIDs
        work data sets 2nd 3rd
open data sets
        tuning 2nd 3rd
Open Database Connectivity.
OPEN statement
        cursors
opening
        cursors 2nd
operating environments
        batch processing
        feasibility 2nd
        resource availability 2nd 3rd
        selecting
operating systems
        explotation
        tuning
                CPUs 2nd 3rd 4th 5th
                I/O 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th
                memory 2nd
                memory.
                z/OS 2nd 3rd 4th 5th
Operational Data Store.
operational databases
        data warehouses, compared
operational support 2nd
operational support tools 2nd
operational utilities
Operational Utilities suite
operators
       comparison
                UDTs
        comparison.
        UNION
        UNION ALL
OPTHINT column
        PLAN TABLE
OPTHINT parameter
        access paths
optimization
        distributed 2nd 3rd
optimization hints 2nd
        advantages
        defining 2nd
        implementing
        performance improvements
OPTIMIZE FOR n ROWS clause
        distribution performance
        optimizer, influencing 2nd 3rd
optimizer
        access path selection 2nd 3rd
        access path strategies
                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
        access path strategy compatibility 2nd
        access paths, selecting
        CPU costs
        DB2 Catalog statistics 2nd 3rd
        DB2 Family differences
        filter factors 2nd 3rd
        functionality 2nd
        hints 2nd 3rd
        I/O costs
        influencing 2nd
                DB2 Catalog statistics.
                optimization hints 2nd 3rd 4th 5th
                OPTIMIZE FOR n ROWS clause 2nd 3rd
                SQL statements, tweaking 2nd 3rd
                standard methods 2nd 3rd 4th 5th
        overview 2nd 3rd
        physical data independence 2nd 3rd
        predicate transitive closure 2nd
        SQL statements
        subqueries 2nd 3rd 4th
                correlated 2nd
                inside-out subquery access
                non-correlated
                outside-in-outside subquery access
                view materialization 2nd
                view merge
        transitivity 2nd
optimizing
        BP0
options
       CASCADE
                referential constraints
        date and time
       FORCE
                MODE parameter
       NO ACTION
                referential constraints
       RESTRICT
                referential constraints
       SET NULL
                referential constraints
OPTIONS control statement
        OFF keyword
        PREVIEW keyword
ORDER BY clause
        columns
        DSNTIAUL utility
        GROUP BY, compared
        joins
        row sequencing
        rows
        top ten retrieval
organizational issues
        education 2nd 3rd
                advanced topics
                external training
                in-house training
                industry periodicals 2nd 3rd 4th
                introductory courses
                mailing lists
                on-site library
                reference material
        environmental support
        operational support 2nd
        personnel issues
        political 2nd 3rd
        standards/procedures
                application development guide
                data administration 2nd
                database administration guide
                design review 2nd 3rd 4th
                migrations/turnovers
                naming conventions 2nd
                QMF guide
                roles/responsibilities 2nd 3rd
                security guide
                SQL performance guide
                system administration guide
                vendor tools guide
organizationl issues
        tools required
OS/390
        tuning 2nd
OUT parameter
        CREATE PROCEDURE statement
outbound authid translations
outer joins 2nd 3rd 4th
        explicit
        FULL OUTER JOIN
       left
                right outer joins, compared
        LEFT OUTER JOIN
        nulls 2nd
        predicate placement 2nd
        RIGHT OUTER JOIN
outer tables
OuterBay Technologies
output data sets
        utilities
outside-in-outside subquery acess
overactive data
        online 2nd
overhead
       LOBs
                limiting
        reducing
       traces
                accounting
                audit
                monitor
                performance
                statistics
overloading
        functions
OVERVIEW parameter
        DISPLAY command