Name some fields from SQLCA
I use CS and update a page. Will the lock be released after I am done with that page?
what's the best lock size that you could use when you create a tablespace?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
What is cascading rollback?
What is the use of runstats in db2?
What is RUNSTATS?
What is isolation level in db2?
What are db2 objects?
How does DB2 store NULL physically?
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
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
Discuss about db2 bind?