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 ?    4 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



Post New Answer



More DB2 Interview Questions

How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,


What is cursor stability?

1 Answers  


What is the format (internal layout) of ?TIMESTAMP??

1 Answers  


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

0 Answers  


what is a plan and how do you refer the plan in the program?

2 Answers   Xansa,


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   Syntel, ITC Infotech,


when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations

3 Answers   IBM,


Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam

1 Answers   Mphasis,


how many bytes timestamp token occupies?

6 Answers   TCS, Cap Gemini, Boss Global,


what is the use of bind parameter, Replace?

5 Answers   IBM,


What is a SELECT statement?

1 Answers  


What is a view? Why use it?

2 Answers  




Categories