| Other DB2 Interview Questions |
|| Asked @
|What is the function of buffer manager?
|What is an alias?
|If a non-DB2 program calls a DB2 program, the calling
program's name will be there in SYSIN of IKJEFT01 and the
plan name will be that of the called program. But is a bind
needed or a plan has to be created for the non-DB2 program
|wht steps we need will coding cobol and db2 pgm ?
|What are the functions in DB2?
|How do u achieve record level locking in DB2 versions when
record level locking is not allowed?
|How do run the JCL which has 25 steps by skipping the
following steps 5, 10,15 and 25 without using COND statement
|how to resolve -818 error. how to see timestamp token in
load module and plan
|db2 maintains information about the data...
b.in a set of tables known as db2 catalog.
c.in db2 database.
d.none of the above.
|Can we use select * statement in cobol program without
giving field names ???
|How to get Top 10 Salaries from a Table
|I have 3 cursors declared. Cursor1 retieves some data.
Based on this curso2 will also fetches some data. In cursor3
(using for some updation) I'm using the data retrieved by
the above 2 cursor. My question is, while working with
cursor3, periodically if I give commit, will all the three
crsors will be closed or only cursor3 will be closed?
|For more DB2 Interview Questions Click Here |