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 |
When is the skeleton cursor table created?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
What is bufferpool in db2?
What is sqlca’s maximum length?
What is a clustered index?
What is isolation level in db2?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
What is the difference between TYPE 1 index & TYPE 2 index
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
what is the name of the default db2 catalog database?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?