Answer Posted / ram

Bind Parameters are below...

Bind Package/Plan
Owner (Authorization ID)
Qualifier (qualifier name)
Member (member name)
Library (DBRM Pds name)
ACTION (ADD/REPLACE)
Explain (Yes/No)
Flag (I/W/E/C)
ISOLATION (RR/RS/CS/UR)
Release (Commit/Deallocate)
Validate(Run/Bind)
Acquire(Use/Allocate)

What is a db2 table?

1065

---

How many types of page locks can be held in db2?

1088

---

What is db2 command?

1091

---

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1136

---

What type of database is db2?

1019

---

What is the role of data manager in the db2 database?

1155

---

How to execute stored procedure in db2 command editor?

1100

---

What is db2 stogroup?

1223

---

What is the advantage in De-normalizing tables in DB2?

1233

---

Explain the contents that are a part of dclgen.

1137

---

What is dbrm? What it contains? When it will be created?

1102

---

What is cursor stability in db2?

1414

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3263

---

What is the physical storage length of time data type?

1176

---

On which levels locks can be applied?

1204

---