Interested to Buy Any Domain ? << Click Here >> for more details...
DB2 is a
A) data base/data communication system
B) data base
C) RDBMS
D) Programming language
- 4 Answers
- 9385 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ankit
data base 2 is data base and data communication system
which help rdbms to specific operation on any database or
solve any queries.
| Is This Answer Correct ? | 2 Yes | 0 No |
What is concurrency in db2?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
What is the syntax required for the creation of a cursor?
What is buffer pool and list some of them?
I use CS and update a page. Will the lock be released after I am done with that page?
What is a DB2 bind?
What is the use of db2?
How would you find out the total number of rows in a db2 table?
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 also?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
How do I add a column to an existing table in db2?
COBOL 
