Interested to Buy Any Domain ? << Click Here >> for more details...
How does DB2 determine what lock-size to use?
- 2 Answers
- 8945 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / techie
Can anyone of you explain me the below statement.
"A solution used for lock escalation in past jobs have been
to have the jobs take an explicit lock on the partition
which prevents lock escalation."
How do i take lock on the partition level, what would be
the definition for it. I googled but couldnt get any
| Is This Answer Correct ? | 1 Yes | 0 No |
what is the use of cursors?
What is the connection string to connect to the DB2 Database ?
Explain packages.
What are column-name qualifiers used?
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
What is runstats and reorg in db2?
What is tablespace?
What is the self-referencing constraint?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
Explain the contents that are a part of dclgen.
What is the physical storage length of date data type?
What does sqlcabc has?
COBOL 
