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 |
How does coalesce work?
what is REORG? what is the use?
What are the two types of logging in the db2 database? Explain them.
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
why we create view.
What is runstats and reorg in db2?
Which component is responsible for processing sql statements and selecting access paths?
What are host variables in db2?
What is alias in db2?
What are the uses of db2 optimizer?
What is the difference between static and dynamic SQL?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?