Answer Posted / mehdee

- If you mean what displays the number of time that a DB2
row has been modified, then my answer is when you create
this DB2 table add a column like SEQ_NUM and as you define
it like SMALLINT, right there you can have it increamented
by 1. Please look into manual for it's exact format.

Which components manage deadlocks in db2?

1071

---

Is db2 a mainframe database?

1003

---

How can record locking be achieved in those DB2 versions which do not support it?

1078

---

What are the 2 sqlcodes that are returned?

1190

---

What is cascading rollback?

1215

---

Comment whether the cursor is closed during commit or not.

1107

---

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1082

---

What is consistency token in db2?

1145

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2853

---

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 ?...

4317

---

What are the contents of a dclmgen?

1131

---

What is dclgen in db2?

1150

---

What is the physical storage length of time data type?

1129

---

What is the difference between plan and package in db2?

1117

---

What is a storage group (stogroup)?

1247

---