What information is contained in a SYSCOPY entry?
- 2 Answers
- 9200 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 |
How do I connect my db2 database to ibm?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
How could one combine a set of incremental image copies into a single copy?
What is sqlca?
Request to database but database is not available so what is was abend is raised?
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
What is the command used by TSO users to invoke DB2?
how to fetch first 100 rows in db2
What is CHECK PENDING ?
What is QUIESCE?
What is index cardinality?
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
COBOL 
