db2-cert7306-a4 - Data concurrency

Db2-cert7306-a4- - DB2 9 Fundamentals exam 730 prep Part 6 Data concurrency Skill Level Introductory Roger E Sanders([email protected] Senior

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
DB2 9 Fundamentals exam 730 prep, Part 6: Data concurrency Skill Level: Introductory Roger E. Sanders ( [email protected] ) Senior Manager - IBM Alliance Engineering Network Appliance, Inc. 20 Jul 2006 This tutorial introduces the concept of data consistency and the various mechanisms that are used by DB2® to maintain consistency in both single- and multi-user database environments. This is the sixth in a series of seven tutorials to help you prepare for the DB2® 9 for Linux®, UNIX®, and Windows™ Fundamentals exam 730. Section 1. Before you start About this series Thinking about seeking certification on DB2 fundamentals (Exam 730)? If so, you've landed in the right spot. This series of seven DB2 certification preparation tutorials covers all the basics -- the topics you'll need to understand before you read the first exam question. Even if you're not planning to seek certification right away, this set of tutorials is a great place to start getting to learn what's new in DB2 9. About this tutorial This tutorial will introduce you to the concept of data consistency and to the various mechanisms that are used by DB2 V9 for Linux, UNIX, and Windows to maintain data consistency in both single and multi-user database environments. This is the sixth in a series of seven tutorials you can use to help prepare for the DB2 9 Fundamentals exam 730. The material in this tutorial primarily covers the objectives in Section 6 of the test, which is entitled "Data concurrency". You can view these objectives at: http://www-03.ibm.com/certify/tests/obj730.shtml . Data concurrency © Copyright IBM Corporation 1994, 2006. All rights reserved. Page 1 of 27
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Objectives After completing this tutorial, you should be able to: • Identify factors that influence locking • List objects on which locks can be obtained • Identify characteristics of DB2 locks • Identify the isolation level that should be used for a given situation Prerequisites To understand some of the material presented in this tutorial, you should be familiar with the following terms: Object: Anything in a database that can be created or manipulated with SQL (e.g., tables, views, indexes, packages). Table: A logical structure that is used to present data as a collection of unordered rows with a fixed number of columns. Each column contains a set of values, each value of the same data type (or a subtype of the column's data type); the definitions of the columns make up the table structure, and the rows contain the actual table data. Record: The storage representation of a row in a table. Field: The storage representation of a column in a table. Value: A specific data item that can be found at each intersection of a row and column in a database table.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/11/2011 for the course IT 232 taught by Professor Drehr during the Spring '11 term at NJIT.

Page1 / 27

Db2-cert7306-a4- - DB2 9 Fundamentals exam 730 prep Part 6 Data concurrency Skill Level Introductory Roger E Sanders([email protected] Senior

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online