DB2 (R) Universal Database for OS/390 V7.1 Application Certification Guide
Published on 6. December 2002
Book
Mixed media product
624 pages
978-0-13-100771-0 (ISBN)
Description
Direct from IBM, this comprehensive day-to-day reference for running DB2 UDB in OS/390 environments is also the only book that delivers the depth of knowledge professionals need to pass IBM's challenging DB2 for OS/390 application certification exam (exam 514). Full of useful tips, practical techniques, and expert guidelines, it covers virtually every aspect of working with DB2 UDB in OS/390 and z/OS environments: administration, connectivity, middleware, development, and much more. This book is part of the IBM Toronto Lab's DB2 Certification program. This book and CD-ROM will help candidates prepare for taking Exam 512 and Exam 516 that leads to an IBM Certification in Database Administration for OS/390.
More details
Language
English
Place of publication
Armonk
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 235 mm
Width: 178 mm
Thickness: 22 mm
Weight
889 gr
ISBN-13
978-0-13-100771-0 (9780131007710)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Person
SUSAN LAWSON is an internationally recognized consultant and lecturer who currently works with several clients to help develop, implement, and tune some of the world's largest and most complex DB2 databases. She is an IBM Gold Consultant for DB2 and S/390 and an IBM Certified DBA and Application Developer for DB2 UDB Version 7 for OS/390.
Content
Preface.
Part 1: Introduction to DB2 UDB for OS/390 and z/OS.
Part 2: Structured Query Language.
Part 3: Developing Applications.
Part 4: Programming and Language Environments.
Part 5: Advanced Programming Functions.
I. INTRODUCTION TO DB2 UDB FOR OS/390 AND Z/OS.
1. Product Overview.
DB2 and e-business. DB2 Universal Database. DB2 Middleware and Connectivity. DB2 Application Development. DB2 Administration. Data Management Tools. Summary. Additional Product Resources.
2. Database Objects.
Understanding Data Structures. Managing Database Objects. Database Design and Implementation. Access to DB2 Objects. Summary. Additional Resources.
II. STRUCTURED QUERY LANGUAGE.
3. Basic SQL Coding.
Data Retrieval. Data Modification. Inserting Data Records. Updating Data Records. Removing Data. View Classification. Summary. Additional Resources.
4. Advanced SQL Coding.
Subqueries. Unions. Nested Table Expressions. Joins. CASE Expressions. Row Expressions. OLAP Features. Summary. Additional Resources.
III. DEVELOPING APPLICATIONS.
5. Using SQL in an Application Program.
DB2 Application Development Environment. Delimiting SQL in a Program. Declaring Table and View Definitions. Host Variables and Host Structures. SQL Execution Validation. Using Cursors. Using Dynamic SQL. Summary. Additional Resources.
6. Binding an Application Program.
Precompile and Bind. Plan or Package Ownership. Summary. Additional Resources.
7. Application Program Features.
Application Program Features. Commit, Rollback, and Savepoint. Global Transactions. Global Temporary Tables. Fetch for Limited Rows. Identity Columns. Summary. Additional Resources.
8. Stored Procedures.
Stored Procedures. Benefits. Writing Stored Procedures. Defining Stored Procedures. Execution Environments. Stored Procedure Address Space (SPAS). Workload Manager. SQL Procedure Language. Developing SQL Stored Procedures. Stored Procedure Builder. Summary. Additional Resources.
9. Testing and Debugging Applications.
Establishing a Test Environment. Debugging Application Programs. Locating the Problem. Testing and Debugging Stored Procedures. Summary. Additional Resources.
10. Accessing Distributed Data.
Distributed Data. Coding Methods for Distributed Data. Programming Considerations. Remote Query Performance. Summary. Additional Distributed Resources.
IV. PROGRAMMING AND LANGUAGE ENVIRONMENTS.
11. ODBC/CLI Programming.
Embedded Dynamic Versus Call-Level Interface. The DB2 ODBC Environment. Handles. Database Connections. Transaction Control. Executing SQL Statements. Retrieving Results. ODBC Stored Procedures. Error Handling and Problem Determination. Sample program. Summary. Additional Resources.
12. DB2 Traditional Programming.
COBOL. C and C++. REXX. Summary. Additional Resources.
13. Java Programming.
DB2 and Java. JDBC. SQLJ. Design Guidelines for Applications. Java Stored Procedures and UDFs. Summary. Additional Resources.
14. Attachment Programming.
Attachments. TSO. CICS. IMS. Call Attachment Facility. RRSAF. Summary. Additional Resources.
V. ADVANCED PROGRAMMING FUNCTIONS.
15. Object-Relational Programming.
Triggers. Object-Relational Extensions. Extenders. LOB and Extender Usage. Enabling Extenders. Summary. Additional Resources.
16. Locking and Concurrency.
Locking Data. Avoiding Locks. System Parameters. Claims and Drains. Locking Issues and Problems. Summary. Additional Resources.
17. Application Performance and Optimization.
Elements of Performance. Tuning Guidelines. Access Paths and Optimization. Designing Indexes for Performance. Query Parallelism. Database Monitoring. Tracing Problems in DB2. Using DISPLAY Commands. Summary.
Appendix A. IBM Certified Solutions Expert-DB2 UDB Family Application Development.
Certification Test Objectives. Sample Test.
Appendix B. Resources.
DB2 Universal Database Server for OS/390 v7 Product Libraries.
Appendix C. DB2CERT Database DDL.
Index.
Part 1: Introduction to DB2 UDB for OS/390 and z/OS.
Part 2: Structured Query Language.
Part 3: Developing Applications.
Part 4: Programming and Language Environments.
Part 5: Advanced Programming Functions.
I. INTRODUCTION TO DB2 UDB FOR OS/390 AND Z/OS.
1. Product Overview.
DB2 and e-business. DB2 Universal Database. DB2 Middleware and Connectivity. DB2 Application Development. DB2 Administration. Data Management Tools. Summary. Additional Product Resources.
2. Database Objects.
Understanding Data Structures. Managing Database Objects. Database Design and Implementation. Access to DB2 Objects. Summary. Additional Resources.
II. STRUCTURED QUERY LANGUAGE.
3. Basic SQL Coding.
Data Retrieval. Data Modification. Inserting Data Records. Updating Data Records. Removing Data. View Classification. Summary. Additional Resources.
4. Advanced SQL Coding.
Subqueries. Unions. Nested Table Expressions. Joins. CASE Expressions. Row Expressions. OLAP Features. Summary. Additional Resources.
III. DEVELOPING APPLICATIONS.
5. Using SQL in an Application Program.
DB2 Application Development Environment. Delimiting SQL in a Program. Declaring Table and View Definitions. Host Variables and Host Structures. SQL Execution Validation. Using Cursors. Using Dynamic SQL. Summary. Additional Resources.
6. Binding an Application Program.
Precompile and Bind. Plan or Package Ownership. Summary. Additional Resources.
7. Application Program Features.
Application Program Features. Commit, Rollback, and Savepoint. Global Transactions. Global Temporary Tables. Fetch for Limited Rows. Identity Columns. Summary. Additional Resources.
8. Stored Procedures.
Stored Procedures. Benefits. Writing Stored Procedures. Defining Stored Procedures. Execution Environments. Stored Procedure Address Space (SPAS). Workload Manager. SQL Procedure Language. Developing SQL Stored Procedures. Stored Procedure Builder. Summary. Additional Resources.
9. Testing and Debugging Applications.
Establishing a Test Environment. Debugging Application Programs. Locating the Problem. Testing and Debugging Stored Procedures. Summary. Additional Resources.
10. Accessing Distributed Data.
Distributed Data. Coding Methods for Distributed Data. Programming Considerations. Remote Query Performance. Summary. Additional Distributed Resources.
IV. PROGRAMMING AND LANGUAGE ENVIRONMENTS.
11. ODBC/CLI Programming.
Embedded Dynamic Versus Call-Level Interface. The DB2 ODBC Environment. Handles. Database Connections. Transaction Control. Executing SQL Statements. Retrieving Results. ODBC Stored Procedures. Error Handling and Problem Determination. Sample program. Summary. Additional Resources.
12. DB2 Traditional Programming.
COBOL. C and C++. REXX. Summary. Additional Resources.
13. Java Programming.
DB2 and Java. JDBC. SQLJ. Design Guidelines for Applications. Java Stored Procedures and UDFs. Summary. Additional Resources.
14. Attachment Programming.
Attachments. TSO. CICS. IMS. Call Attachment Facility. RRSAF. Summary. Additional Resources.
V. ADVANCED PROGRAMMING FUNCTIONS.
15. Object-Relational Programming.
Triggers. Object-Relational Extensions. Extenders. LOB and Extender Usage. Enabling Extenders. Summary. Additional Resources.
16. Locking and Concurrency.
Locking Data. Avoiding Locks. System Parameters. Claims and Drains. Locking Issues and Problems. Summary. Additional Resources.
17. Application Performance and Optimization.
Elements of Performance. Tuning Guidelines. Access Paths and Optimization. Designing Indexes for Performance. Query Parallelism. Database Monitoring. Tracing Problems in DB2. Using DISPLAY Commands. Summary.
Appendix A. IBM Certified Solutions Expert-DB2 UDB Family Application Development.
Certification Test Objectives. Sample Test.
Appendix B. Resources.
DB2 Universal Database Server for OS/390 v7 Product Libraries.
Appendix C. DB2CERT Database DDL.
Index.