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.

What is the default page size of buffer pools?

1067

---

How many databases can be created inside an instance in db2 ?

976

---

What os does db2 run on?

923

---

What are the bind parameters ibm db2?

988

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

8989

---

Mention the location where the output received from explain statement is stored.

1053

---

Highlight all the advantages that are attached to a package.

1070

---

Explain various types of locks in db2?

1079

---

What r the comman abends in db2, jcl and cobol???????

2195

---

What is bind in db2?

975

---

How to resolve deadlock issue

19854

---

What is dbrm?

1046

---

How do I add a column in db2?

997

---

How to find the number of rows in db2 tables?

992

---

What is performance tuning db2?

1004

---