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 an instance in db2?
What is a db2 package?
What is the difference between oracle and db2?
What is dbrm? What it contains?
Which component is responsible for processing sql statements and selecting access paths?
What is cursor stability in db2?
Who uses db2?
Is schema the same as database?
What is the physical storage length of date data type?
Define data page.
What are union and union all?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is a db2 cursor?
What is clone table?
What is buffer pool and list some of them?