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
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is dbrm?
What is host variable?
How can you quickly find out the # of rows updated after an update statement?
What is a page in db2?
What is explain plan in db2?
Explain the contention situations caused by locks?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How will you return the number of records in table?
What is the usage of open cursor command?
How many databases can be created inside an instance in db2 ?
How would you find out the total number of rows in a db2 table?
What is role in db2?
What is a bind in db2?
How connect db2 database to datastage?
What is dclgen (declaration generator)?
