skip to content
DB2 universal database v8 handbook for Windows, Unix, and Linux Preview this item
ClosePreview this item

DB2 universal database v8 handbook for Windows, Unix, and Linux

Author: Philip K Gunning
Publisher: Upper Saddle River, N.J. : Prentice Hall, ©2003.
Series: IBM Press series--information management.
Edition/Format:   Print book : EnglishView all editions and formats

Straight from IBM, this guide offers start-to-finish coverage of DB2 Universal Database Version 8 administration. With Version 8 key topics such as Performance Enhancements and Manageability  Read more...


(not yet rated) 0 with reviews - Be the first.

More like this

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...


Genre/Form: Study guides
Document Type: Book
All Authors / Contributors: Philip K Gunning
ISBN: 0130661112 9780130661111
OCLC Number: 52902712
Notes: "DB2. Information management software."
Description: xxiv, 472 pages : illustrations ; 24 cm.
Contents: Foreword. Preface. 1. What's New. Product Changes. Manageability Enhancements. Performance Enhancements. Availability Enhancements. Serviceability Enhancements. Application Development Enhancements. Summary. 2. DB2 v8 Product Overview and Architecture. Enterprise Server Edition. DB2 Workgroup Server Edition (WSE). DB2 Personal Edition (PE). DB2 Universal Developers Edition (UDE). DB2 Personal Developers Edition (PDE). DB2 Warehouse Manager. DB2 Intelligent Miner Products. DB2 Spatial Extender. DB2 Net Search Extender. New Client. DB2 Architecture. Bufferpools. Prefetchers (db2pfchr). Page Cleaners (db2pclnr). Logs (db2loggr). Deadlock Detector. Connection Concentrator. Summary. 3. Logical and Physical Design. Business Model. Business Entities. Business Rules. Entities and Relationships. Special Entity Relationships. Normalization. First Normal Form. Second Normal Form. Third Normal Form (3NF). Boyce-Codd Normal Form (BCNF). Domain Key/Normal Form (DK/NF). Unified Modeling Language (UML). Logical Design Outputs. Physical Design. Denormalization. Creation of Indexes. Creation of Tablespaces and Tables. Bufferpool Strategy. Summary. 4. Application Development. Getting Started. DB2 Administration Client. DB2 Application Development Client. DB2 Personal Developers' Edition (PDE). DB2 Universal Developers' Edition. DB2 Development Center. DB2 Visual Explain. Development Center. Java Thread-Safe Routines. Java Common Client. SQL Enhancements. SQL Assist. SQL Enhancements. Informational Constraints. Insert Through Union All Views. Summary Tables. Current Refresh Age Special Register. Materialized Query Table (MQT). User-Maintained MQTs. eXtensible Markup Language. Summary. 5. Type-2 Indexes and Multidimensional Clustering. Benefits of Type-2 Indexes. Type-2 Indexes and Next-Key Locking. Migration Considerations for Type-2 Indexes. Suggested Migration Strategy for Type-2 Indexes. Multidimensional Clustering. MDC Table Considerations. Summary. 6. High Performance Tablespace Design and I/O Strategies. Tablespaces. Storage Models. Prefetching. Tables and Tablespace Considerations. The Life of an I/O Request. Redundant Array of Independent Disks (RAID). Tablespace Container Management. DB2 and IBM Enterprise Storage System (ESS SHARK). Keeping a Map of Your Database. Summary. 7. Utilities and Commands. Reorganizing Indexes/Tables. REORGCHK Utility. Database Logging. Backup Database Utility. Restore Database Utility. Roll-forward Database. Query Status. Archive Log Command. List History. List Tablespaces. Set Tablespace Containers Command. DB2TBST-Get Tablespace State Command. RUNSTATS Utility. LOAD Utility. LOAD QUERY Command. QUIESCE Command. UNQUIESCE Command. Migrate Database Utility. INSPECT Utility. Summary. 8. Tuning Bufferpools. Introduction. Maintaining Bufferpools. Monitoring Bufferpool Performance. Monitoring and Tuning Tables, Bufferpools, and Tablespaces. Summary. 9. Tuning Configuration Parameters. Autonomic Computing. Online Configuration Parameters. DB2 Memory Areas. Database Manager Shared Memory. Database Global Memory. Application Global Memory (app_ctl_heap_sz). Agent Private Memory. Agent Parameters. MAXAGENTS. MAXCAGENTS. MAXAPPLS. Agent Monitoring. Configuration Advisor. Summary. 10. Monitoring. Enabling Monitoring. Snapshots through New SQL Functions. Event Monitoring. Create Event Monitor Options. Table Options. Event Monitor Scope. Event Monitor Catalog Tables. General Consideration for Write-to-Table Event Monitors. Summary. 11. Problem Determination. Connectivity Problems. Performance and Application Problems. DB2 Code (Defect) Problems. DB2 Problem Determination Aids. DB2DIAG.LOG File. DB2DIAG.LOG SQLCA Entries. DB2 Administration Notification Log. System Logs. CLI Trace. DB2 Trace. DRDA Trace. Dumps. Traps. Call Stack Traces. Sending Information to DB2 Support. Summary. 12. Understanding and Tuning DB2 Sort. DB2 Sort Memory Areas. Types of Sorts. SHEAPTHRES. Sizing Sort Memory Areas. Monitoring Sort Performance. Eliminating Sorts. Changing SQL. Summary. 13. Enterprise Server Edition-Database Partitioning Feature. When Should You Use Partitioned Databases? DB2 v8.1 ESE Improvements. Partitioned Database Join Strategies. Dynamic Bitmap Index Anding (DBIA). Index Considerations in a DPF Environment. Load Utility Considerations in a DPF Environment. Load Utility Operations. Adding a Database Partition. Summary. APPENDIX A: DB2 Catalog Views. SYSCAT.ATTRIBUTES. SYSCAT.BUFFERPOOLDBPARTITIONS. SYSCAT.BUFFERPOOLS. SYSCAT.CASTFUNCTIONS. SYSCAT.CHECKS. SYSCAT.COLAUTH. SYSCAT.COLCHECKS. SYSCAT.COLDIST. SYSCAT.COLGROUPDIST. SYSCAT.COLGROUPDISTCOUNTS. SYSCAT.COLGROUPS. SYSCAT.COLOPTIONS. SYSCAT.COLUMNS. SYSCAT.COLUSE. SYSCAT.CONSTDEP. SYSCAT.DATATYPES. SYSCAT.DBAUTH. SYSCAT.DBPARTITIONGROUPDEF. SYSCAT.DBPARTITIONGROUPS. SYSCAT.EVENTMONITORS. SYSCAT.EVENTS. SYSCAT.EVENTTABLES. SYSCAT.FULLHIERARCHIES. SYSCAT.FUNCMAPOPTIONS. SYSCAT.FUNCMAPPARMOPTIONS. SYSCAT.FUNCMAPPINGS. SYSCAT.HIERARCHIES. SYSCAT.INDEXAUTH. SYSCAT.INDEXCOLUSE. SYSCAT.INDEXDEP. SYSCAT.INDEXES. SYSCAT.INDEXEXPLOITRULES. SYSCAT.INDEXEXTENSIONDEP. SYSCAT.INDEXEXTENSIONMETHODS. SYSCAT.INDEXEXTENSIONPARMS. SYSCAT.INDEXEXTENSIONS. SYSCAT.INDEXOPTIONS. SYSCAT.KEYCOLUSE. SYSCAT.NAMEMAPPINGS. SYSCAT.PACKAGEAUTH. SYSCAT.PACKAGEDEP. SYSCAT.PACKAGES. SYSCAT.PARTITIONMAPS. SYSCAT.PASSTHRUAUTH. SYSCAT.PREDICATESPECS. SYSCAT.PROCOPTIONS. SYSCAT.PROCPARMOPTIONS. SYSCAT.REFERENCES. SYSCAT.REVTYPEMAPPINGS. SYSCAT.ROUTINEAUTH. SYSCAT.ROUTINEDEP. SYSCAT.ROUTINEPARMS. SYSCAT.ROUTINES. SYSCAT.SCHEMAAUTH. SYSCAT.SCHEMATA. SYSCAT.SEQUENCEAUTH. SYSCAT.SEQUENCES. SYSCAT.SERVEROPTIONS. SYSCAT.SERVERS. SYSCAT.STATEMENTS. SYSCAT.TABAUTH. SYSCAT.TABCONST. SYSCAT.TABDEP. SYSCAT.TABLES. SYSCAT.TABLESPACES. SYSCAT.TABOPTIONS. SYSCAT.TBSPACEAUTH. SYSCAT.TRANSFORMS. SYSCAT.TRIGDEP. SYSCAT.TRIGGERS. SYSCAT.TYPEMAPPINGS. SYSCAT.USEROPTIONS. SYSCAT.VIEWS. SYSCAT.WRAPOPTIONS. SYSCAT.WRAPPERS. SYSSTAT.COLDIST. SYSSTAT.COLUMNS. SYSSTAT.INDEXES. SYSSTAT.ROUTINES. SYSSTAT.TABLES. APPENDIX B: DB2 Information on the Web. DB2-L Listserver. Newsgroup. Newsletters. e-zines. Web Sites. User Group. Vendor Web Sites. APPENDIX C: DB2 Limits. Identifier Length Limits. Numeric Limits. String Limits. Datetime Limits. Database Manager Limits. Database Manager Page Size-Specific Limits. APPENDIX D: DB2 Registry and Environmental Variables. General Registry Variables. System Environment Variables. Communications Variables. Command-Line Variables. MPP Configuration Variables. SQL Compiler Variables. Performance Variables. Miscellaneous Variables. Bibliography. Index.
Series Title: IBM Press series--information management.
Responsibility: Philip K. Gunning.


User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...


Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data

Primary Entity

<> # DB2 universal database v8 handbook for Windows, Unix, and Linux
    a schema:Book, schema:CreativeWork ;
   library:oclcnum "52902712" ;
   library:placeOfPublication <> ;
   library:placeOfPublication <> ; # Upper Saddle River, N.J.
   schema:about <> ; # Electronic data processing personnel--Certification
   schema:about <> ; # Operating systems (Computers)
   schema:about <> ; # IBM Database 2.
   schema:about <> ;
   schema:about <> ; # Database management--Certification
   schema:about <> ; # Electronic data processing personnel--Certification
   schema:about <> ; # Database management--Certification
   schema:about <> ; # IBM Database 2.
   schema:bookFormat bgn:PrintBook ;
   schema:copyrightYear "2003" ;
   schema:creator <> ; # Philip K. Gunning
   schema:datePublished "2003" ;
   schema:exampleOfWork <> ;
   schema:genre "Study guides"@en ;
   schema:inLanguage "en" ;
   schema:isPartOf <> ; # IBM Press series--information management.
   schema:name "DB2 universal database v8 handbook for Windows, Unix, and Linux"@en ;
   schema:productID "52902712" ;
   schema:publication <> ;
   schema:publisher <> ; # Prentice Hall
   schema:workExample <> ;
   umbel:isLike <> ;
   wdrs:describedby <> ;

Related Entities

<> # Prentice Hall
    a bgn:Agent ;
   schema:name "Prentice Hall" ;

<> # Upper Saddle River, N.J.
    a schema:Place ;
   schema:name "Upper Saddle River, N.J." ;

<> # IBM Press series--information management.
    a bgn:PublicationSeries ;
   schema:hasPart <> ; # DB2 universal database v8 handbook for Windows, Unix, and Linux
   schema:name "IBM Press series--information management." ;
   schema:name "IBM Press series--information management" ;

<> # Electronic data processing personnel--Certification
    a schema:Intangible ;
   schema:name "Electronic data processing personnel--Certification"@en ;

<> # Operating systems (Computers)
    a schema:Intangible ;
   schema:name "Operating systems (Computers)"@en ;

<> # IBM Database 2.
    a schema:CreativeWork ;
   schema:name "IBM Database 2." ;

<> # Database management--Certification
    a schema:Intangible ;
   schema:name "Database management--Certification"@en ;

<> # Electronic data processing personnel--Certification
    a schema:Intangible ;
   schema:name "Electronic data processing personnel--Certification"@en ;

<> # Philip K. Gunning
    a schema:Person ;
   schema:birthDate "1955" ;
   schema:familyName "Gunning" ;
   schema:givenName "Philip K." ;
   schema:name "Philip K. Gunning" ;

    a schema:ProductModel ;
   schema:isbn "0130661112" ;
   schema:isbn "9780130661111" ;

Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.