Answer Posted / sabahat khan

Main Coloumn name present in Sysibm.Syscopy are
1)DBNAME 2)TSNAME 3)DSNUM 4)ICTYPE 5)ICDATE
6)Start_Rba 7)DSNAME 8)TIMESTAMP 9)AUTHID

to select any of the above mention column run
select * from sysibm.syscopy where DBNAME=' '
or
select * from sysibm.syscopy where TSNAME=' '

ETC

What is bufferpool in db2?

983

---

What is the difference between cursor stability and repeatable read isolation levels?

1112

---

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.

1660

---

How to find the number of rows in db2 tables?

992

---

What are the contents of a dclmgen?

1066

---

Is the primary key a clustered index?

1077

---

How do I add a column in db2?

997

---

What is check constraint. Explain with example.

1041

---

What is rct?

1158

---

What is null indicator in cobol db2?

991

---

What is the syntax for seeing the columns and data types of a table in the db2 database?

1079

---

What is buffer pool and list some of them?

980

---

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1216

---

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

3088

---

What is table space in db2?

959

---