What information is contained in a SYSCOPY entry?
- 2 Answers
- 8917 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 |
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
How to resolve deadlock issue
can any one expalin check point with an example?
how to resolve -811 sqlcode .give clear explaination
What is the difference between CS and RR isolation levels?
what is datacom db?
how to resolve -805. give clear explination for that
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What are the various locking levels available?
How connect db2 database to datastage?
cobol-db2 runjcl please?
What is DCLGEN ?
COBOL 
