What are the different methods of accessing db2 from tso?
How is the connection established between TSO & DB2?
Answers were Sorted based on User's Feedback
Answer / guest
You can access DB2 using the interactive TSO/ISPF panels
like SPUFI, QMF. You can also invoke DB2 through TSO batch
by invoking the DSN command processor to run a DB2 program.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / s
DB2I will invoke the DSN command processor to establish a
connection with DB2. SPUFI,QMF also allows access to DB2
from TSO/ISPF.
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / k murali krishna
By using QMF and SPUFI, we can access DB2 from TSO
Is This Answer Correct ? | 4 Yes | 1 No |
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
How do you do the EXPLAIN of a dynamic SQL statement?
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
What are data types?
What is cursor?
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
What is the size of a data page?
What is reorg and runstats in db2?
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?
What is the syntax of SELECT statement when embedded in a COBOL program?
What is referential integrity?
What do you need to do before you do EXPLAIN?