What is a thread?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is a thread?

A thread is the connection between DB2 and some other subsystem, such as CICS or IMS/DC.
A thread is a control structure used by DB2 to communicate with an application programme. Every programme must communicate with DB2 by means of Thread.

(Continued on next question...)

Other Job Interview Questions

• How would you print the output of an SQL statement from SPUFI? –
• What are the various locks available?
• Lot of updates have been done on a table due to which indexes have gone haywire. What do you do? –
• What techniques are used to retrieve data from more than one table in a single SQL statement?
• At what stage DB2 must be up?
• How do you concatenate the FIRSTNAME and LASTNAME from EMP table to give a complete name?
• Is DECLARE TABLE in DCLGEN necessary? Why it used?
• What is the difference between IN subselects and EXISTS subselect?
• What is a cursor? why should it be used? –
• What is a thread?
• More...