Deadlock occurs when transactions executing at the same time lock each other out of data that they need to complete their logical units of work. What are the four lockable units for DB2?

chpastor3

 Profile Answers by chpastor3 Questions by chpastor3

• Jun 12th, 2008

The 4 lock units are Row, Page, Table (if segmented), and Table space. Christine Pastor 

burelamanohar

• Feb 6th, 2007

Two transactions A & B enter into dthe DEADLOCK state whan a transaction A which has locked an object X , waits on an object Y locked by transaction B which itself is waiting for X.

Answer Question  Select Best Answer

i) Cursor should always be Opened before Fetching ii) Fetch Operation cursor retrieves Only ONE row for every execution. Of the Statement.Which are true?1 Both are True2 i) is only True3 ii) is False Both are True

a_barwa1

 Profile Answers by a_barwa1 Questions by a_barwa1

• Jun 27th, 2008

Both are true.

Answer Question  Select Best Answer

A54. The WHENEVER statement is coded once in the host program to control program actions depending on the SQL-CODE returned by each sql statement within the program.

DB2MAN

 Profile Answers by DB2MAN Questions by DB2MAN

• Jul 1st, 2008

IT IS USED TO PERFORM THE SPECIFIC USER DIFINED FUCNTION FOR THE PARTICULAR SQL RETURN CODE..For Ex ,Whenever sqlcode = 100  Display "whenever condition returncode is 100"whenever sqlco...

Answer Question  Select Best Answer

The clause avoids closing the cursor and repositioning it to the last row processed when the cursor is reopened.

prasenjit_in

 Profile Answers by prasenjit_in Questions by prasenjit_in

• Jul 18th, 2008

To explain it let us take an example....Suppose we have a query that updates a table once the task is complete the table gets updated(commit), and all the relevant resources acquired by the task is re...

Answer Question  Select Best Answer

sainathkb

 Profile Answers by sainathkb Questions by sainathkb

• Jul 25th, 2008

This error related to db2 table access, please check you have access to all?the table which are using in your program.I face this problem in my exp and? i resolved this by communicating with on-site and DBA

Answer Question  Select Best Answer

When using DB2 Connect, which of the following commands specifies the protocol information on how to connect to the host or to the server? A. CATALOG DCS B. CATALOG NODE C. CATALOG DATABASE D. CATALOG ODBC DATA SOURCE

betsysam

 Profile Answers by betsysam Questions by betsysam

• Aug 5th, 2008

Catalog Node

Answer Question  Select Best Answer

What are the flavours of DB2?

sethy.pradeep

 Profile Answers by sethy.pradeep Questions by sethy.pradeep

• Nov 17th, 2008

Oracle, Siebel like all relational databases are flavours of db2.

Answer Question  Select Best Answer

sethy.pradeep

 Profile Answers by sethy.pradeep Questions by sethy.pradeep

• Nov 18th, 2008

Yes you should do recompile otherwise you will get n abend -818.

mail_mathewsonyc

 Profile Answers by mail_mathewsonyc Questions by mail_mathewsonyc

• Sep 1st, 2007

Hi,when you first compile a cobol-db2 program the cobol precompiler seperates all your cobol statements and DB2 statements into two seperate modules.The module containing the DB2 statements is ca...

Answer Question  Select Best Answer

sethy.pradeep

 Profile Answers by sethy.pradeep Questions by sethy.pradeep

• Nov 18th, 2008

Reuse means you can use the same cluster for further use. Remember it alternate index doesn't support for reuseble cluster.Upgrade means when the base cluster is opened for processing then the alternate index is updated automatically.

Answer Question  Select Best Answer

sethy.pradeep

 Profile Answers by sethy.pradeep Questions by sethy.pradeep

• Nov 19th, 2008

For performance tuning for your COBOL/DB2 program you need to follow COBOL & DB2 standrads along with your organization standards.

Raja

• Aug 22nd, 2006

1. Make sure the SQL query is coded as simply and efficiently as possible.Make sure that no unused columns are selected and that there is nounneeded ORDER BY or GROUP BY. 2. Indexable predicates:...

Answer Question  Select Best Answer

sethy.pradeep

 Profile Answers by sethy.pradeep Questions by sethy.pradeep

• Nov 19th, 2008

Collection means grouping of db2 packages.

sethy.pradeep

 Profile Answers by sethy.pradeep Questions by sethy.pradeep

• Nov 18th, 2008

Collection is generally used for grouping of db2 packages.For each collection there is one collection id should be created.

Answer Question  Select Best Answer

sethy.pradeep

 Profile Answers by sethy.pradeep Questions by sethy.pradeep

• Nov 19th, 2008

It does not make any difference that you are defining cursor in working storage section or in procedure division. You can define it in both places. If you are defining a cursor in procedure division it doesn't affects at all of your Cobol/db2 program.
Regards,
Pradeep

Raghuram Balakrishnan

 Profile Answers by Raghuram Balakrishnan Questions by Raghuram Balakrishnan

• Jul 19th, 2007

There is no difference in declaring a cursor in working storage or procedure division.  The only constraint with declaring a cursor is that it should be done before any OPEN CURSOR statement.

Answer Question  Select Best Answer

The common aggregate, built-in functions are AVG, SUM, MIN, MAX, COUNT and DISTINCT.

ramanatcs

 Profile Answers by ramanatcs Questions by ramanatcs

• Dec 24th, 2008

STDDEV ( Standard Deviation )VARIANCE These are used in stastical calculations.

Answer Question  Select Best Answer

SQL statements may return any number of rows, but most host languages deal with one row at a time by declaring a cursor that presents each row at a unique isolation level.

ramanatcs

 Profile Answers by ramanatcs Questions by ramanatcs

• Dec 24th, 2008

Isolation  Level determines the duration of the lock over a page.3 level are there.1. Cursor Stability : lock is retained when untill the cursor moves from one record in one page to the next reco...

Answer Question  Select Best Answer

ruth suganya sebastian

 Profile Answers by ruth suganya sebastian Questions by ruth suganya sebastian

• Jan 6th, 2009

sysibm is a default schema which has all the base tables and syscat is also a default schema which has the tables and views of sysibm objects...

uma

• Jan 23rd, 2007

hi,  sys cat will give all data sets that are catalogged ang sys ibm will give all data sets.

Answer Question  Select Best Answer

How many DB2 plans can be connected to CICS region at a time? a). Infinite b). 1 c). Depends on CICS region definitions d). 255 e). None of the above

sravanthivajpaee

 Profile Answers by sravanthivajpaee Questions by sravanthivajpaee

• Jan 28th, 2009

Plans are allocated to transactions rather than regions. For every transaction there exsists an entry for the Plan in the RCT table.In a region multiple transactions can be present so multiple Plans can be holded to each region.

Answer Question  Select Best Answer

Which of the following can duplicate the structure and related objects of a database table? A. Copy table B. Alter table C. Export table D. Generate DDL

anilsreepad

 Profile Answers by anilsreepad Questions by anilsreepad

• Mar 25th, 2009

Generate DDL [using db2look utility]

Answer Question  Select Best Answer

Two or more transactions in a simultaneous wait state, each waiting for other to release before it can proceed, is calleda.Lost Updateuncommitted dependencyinfinite loopd.Deadlocke.With holdDeadlock

veluvpv

 Profile Answers by veluvpv Questions by veluvpv

• Apr 16th, 2009

DeadLock

Answer Question  Select Best Answer

I) Index Space are created automatically when Index are created. II) Table Space are created automatically when Tables are created. Of the above statementBoth are True( I ) is Only True( II) is only TrueBoth are False( I ) is Only True

sumanthvm

 Profile Answers by sumanthvm Questions by sumanthvm

• May 27th, 2009

You need tablespace created when you want to create index or Table.We cant create the table/Index in the table Spaces, thus both are false

eat_raj

 Profile Answers by eat_raj Questions by eat_raj

• Jan 3rd, 2008

Only I is true

Answer Question  Select Best Answer

Indexes is Stored in 1 B - Tree format2 Hash Table3 AVL Tree4 Red Black Tree
B - Tree format

sumanthvm

 Profile Answers by sumanthvm Questions by sumanthvm

• May 27th, 2009

B tree by default in DB2 UDB for LUW

Answer Question  Select Best Answer