Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Is db2 a database?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How do I import data from excel to db2?
Explain about dbrm.
What is the use of with ur in db2?
What are concurrency issues?
What is dclgen (declaration generator)?
What is explain in db2?
List out the data types available.
How do I start db2 in windows?
What is the clustering index in the db2 database?
What is the use of commit in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What are the 2 sqlcodes that are returned?
