DB2 - What are the three lock types?

GeekInterview.com > Interview Questions > Mainframe > DB2

Go To First | Previous Question | Next Question

DB2 | Question 46 of 196

What are the three lock types?

The three types are shared, update and exclusive. Shared locks allow two or more programs to read simultaneously but not change the locked space. An exclusive lock bars all other users from accessing the space. An update lock is less restrictive; it allows other transactions to read or acquire shared locks on the space.

Total Answers and Comments: 1

Last Update: December 19, 2006

jQuery - Sorting Other Types of Data

Learning jQuery Sorting Other Types of Data Our sort routine should be able to handle not just the Title and Author columns but the Publish Dates and Price as well Since we streamlined our comparator function it can handle all kinds of data but the computed keys will need to be adjusted for other da

EDI Document Types

EDI Document Types EDI documents come in various forms each of which can appear differently depending on the company’ s internal computer system Also while each standard has code specificity each order may look very different a clothes company will send details of color and sizes while a f

Listening Skills - Types of Bad Listeners

Types of Bad Listeners What are the main types of bad listeners You might find in your work environment that some individuals are simply not very good at listening This can create a myriad of problems and make the performance of the most mundane day to day tasks nearly impossible to accomplish mosgo

C++ Function Passing Types

C Function Passing Types In this C tutorial you will learn about function passing types two types of arguments passing in functions passed by value  and  passed by reference are discussed here mosgoogle center The arguments passed to a function can be performed in two ways Passed

Types of Resumes and When to Use Them

Resumes are written to give our future employers an insight of who we are and why we should hire them. But resumes are more than just a collection of FYIs about you, it should be written in a way that highlights important things about yourself. Take note that you are not altering any information jus

SQL Data Types

SQL Data Types Overview In SQL, as in many other programming languages, every piece of data has a particular type. For example, 11 is an integer, and “Wall Street” is a text string. The SQL standard defines many data types to accommodate almost any type of data. Some cases aris

The Interview Snafu

How to turn someone else’s mistake to your advantage Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de

Winning a Job Interview with a Winning Resume

Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof

Types of IT Certification

For those that are considering an IT Certification, they may have found that there are several types to choose from.  Before deciding on a particular IT Certification, it is important to know what choices are available to you as well as what will be included in each of the types. 

Mainframe Features

Mainframe Features In this Mainframe tutorial you will learn about features of Mainframe Processing power memory capacity performance computing multiple operating system time sharing reliability serviceability availability clustering technology and other features available in Mainframe mosgoogle cen