What information is contained in a SYSCOPY entry?
- 2 Answers
- 9412 Views
- I also Faced
- E-Mail Answers
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 |
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
what are stage one indexable predicates?
How to resolve -805 error in DB2?
What do you mean by storage group (stogroup)?
how to unload different table data into different gdg files/ vsam files.
When do you use the IMAGECOPY?
what is the process of precompiler?
What else is there in the PLAN apart from the access path?
What does DML stand for and what are some examples of it?
Can you use max on a char column?
What is the difference between base table and view?
What is difference between isnull and coalesce?
COBOL 
