Answer / nahid gorji

DB2 catalogs store MetaData , which means Data about Data.
Such as information about the DB2 objects created/Altered
by users or output of RUNSTATS utility which are utilized
when running SQL statement or selecting access path.

Answer / s

DB2 stores information about all the ojects in the db2
subsystem in the catalog tables.

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

---

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 Answers  

---

What is bind and rebind in db2?

1 Answers  

---

What is the command used by TSO users to invoke DB2?

2 Answers   IBM,

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?

6 Answers  

---

What is index cardinality?

3 Answers  

---

What is meant by a unit of recovery?

1 Answers  

---

Can I use LOCK TABLE on a view?

1 Answers  

---

Is ibm db2 open source?

1 Answers  

---

Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,

---

What does the CHECK Utility do ?

1 Answers  

---