Disconnecting from Db2 while under TSO

Several conditions can cause the TSO connection to Db2 to end.

About this task

Begin general-use programming interface information.The connection to Db2 ends, and the thread is terminated, when:

  • You enter the END subcommand.
  • You enter DSN again. (A new connection is established immediately.)
  • You enter the CANCEL THREAD command (for threads that are active or suspended in Db2).
  • You enter the MVS CANCEL command.
  • You press the attention key (PA1).
  • Any of the following operations end, or you enter END or RETURN when using any of them:
    • SQL statements using SPUFI
    • DCLGEN
    • BIND/REBIND/FREE
    • RUN

For example, the following command and subcommands establish a connection to Db2, run a program, and terminate the connection:

TSO displays: 

READY
You enter: 
DSN SYSTEM (DSN)
DSN displays: 
DSN
You enter: 
RUN PROGRAM (MYPROG)
DSN displays: 
DSN
You enter: 
END
TSO displays: 
READY

End general-use programming interface information.