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 |
Mention the definition of cobol in varchar field.
wht happens if we close cursor with cursor with hold option?
What is the maximum number of columns in a db2 table?
How is deadlock resolved?
What is a host variable?
What is a system catalog table in db2?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
Which transaction use a command thread ?
What is the difference between static and dynamic SQL?
Explain an outer join?
What is a LIKE table and how is it created?
What are PACKAGES ?