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 the information associated with sysibm.syslinks table?
Explain various types of locks in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Can you use max on a char column?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Why do we bind in db2?
How do I connect my db2 database to ibm?
What is page size in db2?
What is rebind in db2?
What is host variable in db2 cobol?
How can you quickly find out the # of rows updated after an update statement?
Which component is responsible for db2 startup and shutdown?
What does runstats do in db2?
What do you mean by storage group (stogroup)?
What is a db2 schema?