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 is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
How do I add a column in db2?
What are the three lock types?
Highlight all the advantages that are attached to a package.
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
How to get the ddl of a table in db2?
What are the various data types available in db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
How to find schema of a table in db2?
What is the use of db2?
How can you get the number of rows impacted by the last executed query?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?