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 |
For Read Stability locks are not applicable for phantoms, What is Phantoms?
What are the functions of Bind?
What are concurrency issues?
Can you define an Index if the table size less than 10 PAGES?
Return code 100 means?
How do you retrieve the data from a nullable column?
How to view db2 table structure?
How to check last update on table in db2?
What is meant by dclgen?
what's the best lock size that you could use when you create a tablespace?
What is query_cache_limit?
EXPLAIN has output with MATCHCOLS = 0. What does it mean?