Answer Posted / kiran bhamare

Hi,

You can do same by following tric.
STOP database and start it again using DB2 commands.
1)-DIS DATABASE (DATABASENAME) SPACE (TABLESPACENAME)
to dsisplay status of DB
2)-STOP DATABASE (DATABASENAME) SPACE (TABLESPACENAME)
to stop database.
3)-START DATABASE (DATABASENAME) SPACE (TABLESPACENAME) ACC
(FORCE)
to start database.

Is db2 free?

1094

---

What is release/acquire in bind?

1102

---

Explain about rct.

1085

---

Explain about dbrm.

1043

---

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1735

---

What is db2 catalog database?

1041

---

Explain about rct in db2?

1104

---

What is buffer pool in the db2 database?

1092

---

What is dbrm? What it contains?

1163

---

What are foreign keys in db2?

1101

---

How and when does the db2 enforces the unique key?

1083

---

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3152

---

How do we specify index to include or not during bind process.

2126

---

What is precompiler in db2?

1012

---

Mention some fields that are a part of sqlca.

1019

---