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 |
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
what is Static and dynamic linking
Is it possible to precompile if db2 goes down?
What is buffer pool in the db2 database?
can i code union in cobol-db2 pgm ?
What are host variables in db2?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
can all users have the privilage to use the sql statement select * (dml)?
What will the COMMIT accomplish?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is an alias?
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2