DB2 Developers Guide Book

Question 1

What are the 5 environments that can access DB2 Data?

Answer 1

TSO, CICS, IMS/VS, CAF, RRSAF

Question 2

Each DB2 program must be connect to DB2 by an ____ ____, which is the mechanism by which an environment is connect to a DB2 subsystem.

Answer 2

Attachement Facility

Question 3

What is a thread?

Answer 3

Is a control structure used by DB2 to communicate with an application.

Question 4

When is a thread established?

Answer 4

A thread is established for each embedded SQL Program that is executing.

Question 5

How is the thread used?

Answer 5

The thread is used to send requests to DB2, to send data from DB2 to the program, and to communicate (through SQLCA) the status of each SQL statement after it is executed.

Question 6

What is SQLCA?

Answer 6

SQL Communication Area is a collection of variables that is updated at the end of the execution of every SQL statement.

Question 7

What is SQLDA?

Answer 7

An SQL Descriptor Area is a collection of variables that is required for execution of the SQL DESCRIBE statement.