DB2 INTERVIEW QUESTIONS FAQS - MAINFRAME

mainframe discussion forum - cobol, db2,cics, interview questions, quizs

Interview Questions 1 | Interview Questions 1 | Interview Questions 2 | Interview Questions 3 | Interview Questions 5 |
Interview Questions 6 | Interview Questions 7 | Interview Questions 8 | Interview Questions 9 | Interview Questions 10 |
Interview Questions 11 | Interview Questions 12 | Interview Questions 13 | Interview Questions 14 | Interview Questions 15 |
Interview Questions 16 | Interview Questions 17 | Interview Questions 18 | Interview Questions 19 | Interview Questions 20 |
Interview Questions 21 | Interview Questions 22 |

DB2 INTERVIEW QUESTIONS - Page 12

Java inteview questions
DB2 SQL Tutorial
Mainframe inteview questions
DB2 Discussion Forum

56) What are the disadvantages of PAGE level lock? - RAMESH www.mainframegurukul.com/srcsinc

High resource utilization if large updates are to be done

57) What is lock escalation?

Promoting a PAGE lock-size to table or tablespace lock-size when a transaction has acquired more locks than specified in NUMLKTS. Locks should be taken on objects in single tablespace for escalation to occur.

58) What are the various locks available?

SHARE, EXCLUSIVE, UPDATE

59) Can I use LOCK TABLE on a view?

No. To lock a view, take lock on the underlying tables.

60) What is ALTER ? –

SQL command used to change the definition of DB2 objects.

DB2 INTERVIEW QUESTIONS - advertisement

Java inteview questions DB2 SQL Tutorial Mainframe inteview questions > Mainframe inteview questions

DB2 DISCUSSION TOPICS IN MAINFRAMEGURUKUL.COM

DB2 query !!
DB2 Certification
db2 703 application developmetn certification
DB2
db2 query
How to know the Primary and Foriegn keys?
Inserting NULL
bulk insert
Call & Execute a COBOL-DB2 from a COBOL program?
Important Links Mainframes
SQL update query - need help urgently please
Reg: DCLGEN copybook compilation
Testing a field in db2.
Using Index
doubt in db2
Locking Heirarcy and Compatibility?
what s the difference between DB2 & ADB2?
Performance tuning..
Various Locking mechanism for cursors and other SQL?
IJKEFT01 or IJKEFT1A
Calling a COBOL DB2 subroutine using non-DB2 program
PERFORMANCE TUNING.
Finding PLAN(or Package)
Updating a Table?
DB2 References
SINGLE ROW
A query in DB2 with "<>".
Query on SQL
How to handle the null indiactor
Reg: CASE usage in DB2
Reg : DB2 700 certification
DB2 table -selective download to a flat file
db2 certification
latest and best DB2 certification
DB2 Questions - answers required.
DB2 catalog tables
Reg:Performance of a DB2 query
S0C6 Abend while Opening a Cursor in a DB2-PLI Proram - Sugg
S0C6 Abend while Opening a Cursor in a DB2-PLI Proram
Reg : DB2 certifications
DSNTIAUL
Deleting large numbers of rows quickly
NULL value
DB2 Certification Guidelines
date -updation
DB2 PERFORMANCE TUNING TIPS
DB2 Certification
how to reteieve the cursor randomly??
Db2 DBA training needed
current date,time
Stored procedure parm limit
chords---help
db2
db2 doubt
FOREIGN KEY
VSAM LDS used in DB2
PACKAGE VS PLAN ?
to overcome -407 error in Db2
ROWID
SQLCA
CURSOR
To update a Comment in Lower case in DB2
What is the diff between declaring a cursor in WSS or PD?
How to display in SYSOUT?
DB2 Cursor
new member
query on sql
how to proceed
which is the best
pls help me abt these questions..
foreign key
CAST function
thanks
DB2 checkpoint-restart doubts
db2 begginer
cursors
cursors
how to resolve abends
CONSTRAINT with ON DELETE CASCADE
DB2 Query
with Hold cursor in a stored procedure
Difference between IBMLOAD and BMCLOAD
How you add column in between a table?
Partition 1 is in Copy Pending
I am beginer in db2 , why r using bind ,plan & packge?
sql query required
DB2 SQL CODE -904 Explainations
how to see VSAM DATASET
Hi, query for table structure?
Array setup
can any one tel something about db2 loading
Get week from date
How to add two coloumns of table inm DB2
Db2 Certificaiton Info needed
DB2 certification
DB2 basic
DB2 COMMIT??
Regarding Host variables
Doubt in cursor
HOME DB2 Interview Questions | COBOL Interview Questions | JCL interview questions | JCL interview questions | vsam Interview Questions | cics Interview Questions |DB2 Interview Questions | COBOL Interview Questions | JCL interview questions | JCL interview questions | vsam Interview Questions | cics Interview Questions