Answer Posted / s
Intent lock is a lock taken at the tablespace or table
level and indicates the type of locks are held at the lower
levels, page or row.
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
Which command is used to connect to a database in DB2 ? Give the Syntax.
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is explain plan in db2?
Explain in brief how does db2 determine what lock-size to use?
What is a db2 schema?
How can you quickly find out the # of rows updated after an update statement?
How to compare data between two tables in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
How would the varchar column remarks defined?
How to find the maximum value in a column in the db2 database?
How do I change the column size in db2?
What is the physical storage length of time data type?
Explain how can you do the explain of a dynamic sql statement?
Explain the function of data manager.