Home Page Icon
Home Page
Table of Contents for
Glossary
Close
Glossary
by Susan Graziano Sloan
Official Introduction to DB2® for z/OS®, The, 2nd Edition
Copyright
IBM Press Series—Information Management
About Prentice Hall Professional Technical Reference
Foreword
About this book
Overview
An overview of DB2
Scenarios for using DB2
The IBM DB2 information management strategy
The DB2 Universal Database family
Open standards
For more information
Practice exam questions
Answers to practice exam questions
DB2 concepts
Structured query language
DB2 data structures
Enforcement of business rules
Application processes and transactions
Packages and application plans
Routines
Distributed data
DB2 system structures
Practice exam questions
Answers to practice exam questions
DB2 UDB for z/OS architecture
z/OS overview
DB2 in the z/OS environment
DB2 lock manager
DB2 and the z/OS Security Server
DB2 attachment facilities
Distributed data facility
The Parallel Sysplex environment
For more information
Working with your data
Designing objects and relationships
Logical database design with entity-relationship model
Logical database design with Unified Modeling Language
Physical database design
For more information
Practice exam questions
Answers to practice exam questions
Working with SQL: The language of DB2
Executing SQL
Writing SQL queries to answer questions: The basics
Modifying data
For more information
Practice exam questions
Answers to practice exam questions
Writing an application program
Using integrated development environments
Choosing programming languages and methods to use
Preparing an application program to run
Writing static SQL applications
Writing dynamic SQL applications
Using ODBC to execute dynamic SQL
Using Java to execute static and dynamic SQL
Using an application program as a stored procedure
For more information
Practice exam questions
Answers to practice exam questions
Implementing your database design
Defining tables
Defining columns and rows in a table
Defining a table space
Defining indexes
Defining views
Defining large objects
Defining databases
Defining relationships with referential constraints
Defining other business rules
For more information
Practice exam questions
Answers to practice exam questions
Managing DB2 performance
Understanding performance issues
Moving data efficiently through the system
Improving performance for multiple users: Locking and concurrency
Improving query performance
Learning about specific performance considerations
For more information
Practice exam questions
Answers to practice exam questions
Managing DB2 operations
Using tools to manage DB2
Issuing commands and running utilities
Managing data sets
Authorizing users to access data
Backup and recovery
For more information
Practice exam questions
Answers to practice exam questions
Specialized topics
DB2 and the Web
Web application environment
Web-based applications and WebSphere Studio Application Developer
XML and DB2
Web services and DB2
For more information
Distributed data access
Introduction to distributed data access
Programming techniques for accessing remote servers
Coordination of updates
Network traffic reduction
For more information
Data sharing with your DB2 data
Advantages of DB2 data sharing
How data sharing works
Some data sharing considerations
For more information
Appendixes
Example tables in this book
Employee table
Department table
Project table
Employee-to-project activity table
Products table
Parts table
IBM DB2 UDB certification program
Examining the DB2 UDB Version 8 certification roadmap
Exploring Exam 700: DB2 UDB V8.1 Family Fundamentals
Preparing for the exam
Scheduling your exam
Earning more advanced certifications
Glossary
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Z
Bibliography
IBM DB2 Universal Database for z/OS Version 8 product library:
IBM books and resources about related products:
Non-IBM books and resources:
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Earning more advanced certifications
Next
Next Chapter
A
Glossary
The following terms and abbreviations are used in this book.
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset