What information is contained in a SYSCOPY entry?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kislay
Included is the name of the database, the table space
name, and the image copy type(full or incremental etc.,) as
well as the date and time each copy was made.
Is This Answer Correct ? | 1 Yes | 0 No |
How to resolve -502 sql code in DB2?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
List out the buffer pools in db2
Explain transactions, commits and rollbacks in DB2.
What's The Percentage Free Space ?
How to handle null values in db2
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
What is a correlated sub query?
what is load and unload in db2
What is ibm db2 database?
How to define the a field which accepts value till 99999.99 in db2
Explain how can you do the explain of a dynamic sql statement?