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 |
What will the DB2 optimizer do?
What is role in db2?
what is cursor stability?
What are the contents of dclgen?
What are leaf pages?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
How to fetch the last row from the table in SQL (db2)?
What is the error code -803 ?
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
What is a bind in db2?
When is the authorization check on DB2 objects done - at BIND time or run time?
what is the maximum number of tables that can be joined ?