Username: Password:
 Home |  | Exam Engines | Study Packs | Labs |  | Sample | FAQ | Guarantee | Support | Order
Go
  Total (3799)
  3Com (14)
  AccessData (2)
  ACE (1)
  ACI (9)
  Acme Packet (1)
  ACSM (8)
  Adobe (129)
  AIIM (2)
  Alcatel Lucent (17)
  Altiris Exams (4)
  American College (1)
  APC (4)
  Apple (63)
  Arm (4)
  Aruba (2)
  ASQ (4)
  ASTQB (2)
  AUTODESK (2)
  Automotive (0)
  Avaya (58)
  Axis (2)
  Banking (2)
  BICSI (2)
  BlackBerry (17)
  Blue Coat (2)
  BMC (2)
  Business Objects (16)
  CA (31)
  Certiport (6)
  CheckPoint (44)
  CIPS (5)
  Cisco (736)
  Citrix (135)
  CIW (47)
  Cloudera (4)
  CLP (2)
  CompTIA (147)
  CWNA (16)
  Dassault (2)
  Dell (5)
  ECCouncil (19)
  EMC (136)
  ENTERASYS (16)
  Ericsson (4)
  Esri (4)
  Exam Express (18)
  EXIN (41)
  Extreme Networks (4)
  F5 Networks (21)
  FileMaker (11)
  Financial (56)
  Fitness (6)
  FORTINET (5)
  Fujitsu (4)
  GAQM (1)
  Genesys (2)
  GIAC (17)
  GRE (2)
  GuidanceSoftware (5)
  H3C (2)
  HDI (10)
  Healthcare (4)
  HIPAA (2)
  Hitachi (17)
  Hospitality (3)
  HP (751)
  HRCI (6)
  Huawei (13)
  Hyperion (15)
  IASSC (1)
  IBM (963)
  ICDL (8)
  IELTS (3)
  IFPUG (2)
  IIA (1)
  IIBA (4)
  IISFA (1)
  Intel (2)
  IRS (4)
  Isaca (5)
  ISC (15)
  ISEB-ITIL (37)
  Isilion (4)
  ISM (0)
  ISM (8)
  iSQI (12)
  Juniper (53)
  Legato (5)
  Lotus (135)
  LPI (18)
  LSI (6)
  Magento (4)
  Maintenance (4)
  Marketing (2)
  McAfee (7)
  McData (5)
  Microsoft (912)
  Mile2 (5)
  Motorola (6)
  MySQL (5)
  Network Appliance (31)
  Nework-GENERAL (16)
  NI-LabVIEW (1)
  NOKIA (3)
  Nortel (176)
  Novell (77)
  OMG (12)
  Open Group (4)
  Oracle (297)
  Pegasystems (4)
  PEOPLECERT (2)
  PMI (7)
  Polycom (3)
  PostgreSQL CE (1)
  Prince2 (1)
  PRMIA (2)
  Quality Assurance (6)
  Real Estate (2)
  RedHat (4)
  RES Software (8)
  Research (2)
  Riverbed (3)
  RSA (19)
  SAIR (16)
  SAP (45)
  SAS Institute (19)
  SCO (11)
  SCP (9)
  SDI (4)
  SeeBeyond (2)
  SNIA (9)
  SOA (15)
  SolarWinds (1)
  SpringSource (1)
  SPSS (8)
  Sybase (20)
  Symantec (158)
  The Open Group (4)
  Tibco (28)
  TruSecure (2)
  TSEP (2)
  Veritas (12)
  VMWare (16)
  XML Master (6)
 
New  Releases More...
 
   Study Pack
 
     DB2 for z/OS Version 8 DBA Certification Guide   
     
Lifetime member (All Exams and Study Packs Only $ 79.99)   
 
  Introduction




PREFACE
ACKNOWLEDGMENTS
Part I. DB2 Family and DB2 for z/OS Environment
Chapter 1. Product Overview
DB2 and the On-Demand Business
DB2 Universal Database
DB2 Middleware and Connectivity
DB2 Application Development
DB2 Administration
Data Management Tools
Summary
Additional Resources
Chapter 2. DB2 Environment
z/OS
Address Spaces
Security
Parallel Sysplex Support
DFSMS
Interfaces
Installation and Migration
System Parameters
Commands
Utilities
Catalog and Directory
Distributed Data
Subsystem Pools
Summary
Additional Resources
Chapter 3. DB2 Access and Security
Subsystem Access
Data Set Protection
Access to DB2 Objects
Multilevel Security
Auditing
Summary
Additional Resources
Part II. Structured Query Language
Chapter 4. Database Objects
Understanding Data Structures
Managing Database Objects
Creating Database Objects
Database Design and Implementation
Summary
Additional Resources
Chapter 5. Retrieving and Manipulating Database Objects
Data Retrieval
Data Modification
Summary
Additional Resources
Chapter 6. Advanced SQL Coding
Subqueries
Unions
Joins
Nested and Common Table Expressions
CASE Expressions
Row Expressions
OLAP and Star Joins
Predicates and Filtering
Summary
Additional Resources
Part III. Database Administration
Chapter 7. Maintaining Data
Data Movement
Data Maintenance
Gathering Statistics
Statistics Usage
Resolving Restrictive and Advisory States
Summary
Additional Resources
Chapter 8. Recovery and Restart
Database Recovery Concepts
Logging
Image Copies
Data Recoveries
Disaster Recoveries
System-Level Backup and Recovery
DB2 Restart
Summary
Additional Resources
Part IV. Developing Applications with DB2
Chapter 9. Data Sharing
Data Sharing Components
Maintaining Data Integrity
Performance and Processing Costs
Movement to Data Sharing
Recovery Considerations
Summary
Additional Resources
Chapter 10. Using SQL in an Application Program
Delimiting SQL in a Program
Table and View Definitions
Host Variables and Structures
SQL Execution Validation
Cursors
Dynamic SQL
Summary
Additional Resources
Chapter 11. Binding an Application Program
Precompiling
Binding
Plan or Package Ownership
Summary
Additional Resources
Chapter 12. Application Program Features
Commit, Rollback, and Savepoint Operations
Global Transactions
Global Temporary Tables
Fetch for Limited Rows
Identity Columns
Sequence Objects
Summary
Additional Resources
Part V. Advanced Functions and Performance
Chapter 13. Stored Procedures
Benefits of Using Stored Procedures
Writing Stored Procedures
Defining Stored Procedures
Execution Environments
SQL Procedure Language
Developing SQL Stored Procedures
DB2 Development Center
Summary
Additional Resources
Chapter 14. Accessing Distributed Data
Distributed Data
Coding Methods for Distributed Data
Programming Considerations
Remote Query Performance
Summary
Additional Resources
Chapter 15. Object-Relational Functionality
Triggers
Object-Relational Extensions
Large Objects
Summary
Additional Resources
Chapter 16. Locking and Concurrency
Locking Data
Avoiding Locks
Claims and Drains
Locking Issues and Problems
Designing for Concurrency
Summary
Additional Resources
Chapter 17. SQL Optimization and Performance
Access Paths and Optimization
Designing Indexes and SQL for Performance
Summary
Additional Resources
Chapter 18. DB2 Monitoring and Tuning
Overview of Performance and Tuning
Database Monitoring
Using Traces to Solve Problems in DB2
Memory Tuning
Summary
Additional Resources
Appendix A. DDL for the DB2CERT Database
Appendix B. IBM Certified Database Administrator for DB2 UDB Version 8 for z/OS
DB2 UDB V8 Family Fundamentals: 700 Exam
DB2 UDB V8 for z/OS Database Administration: 702 Exam
Appendix C. 702 Sample Exam
Questions
Answers and Chapter References
BIBLIOGRAPHY
Index

  Index
 
 
Home | Training List | Study Pack | Free Demo | F A Q | Guarantee | Support | Order | Privacy Policy| Website Index
Copyright 2000 - 2018 ITExamWorld.net , All rights reserved.