What are the ways to execute DB2 commands

Environmental Products: DB2 UDB

Platform: z/OS

Version: V8

What are the ways in which the question executes the DB2 command?

The answer to the DB2 command can be done in the following ways:

1, through the z/OS of the console or z/OS applications, for the environment containing multiple DB2 subsystems. If you want to execute the DB2 command on a particular DB2 system, you need to use the command prefix, for example:-DSN1 DIS GROUP DETAILS. All DB2 commands can be executed.

2. All DB2 commands other than start DB2 can be run through IMS Console or application. A specific command qualifier is also required.

3, through the CICS console, you can run all DB2 commands except start DB2. Since CICS can only be connected to one DB2 system, executing the DB2 command does not require a specific prefix symbol.

4, through the TSO console or db2i, you can use the following command to open the DB2 command console: TSO DSN SYSTEM (subsystem-name). It is also possible to run all DB2 commands except the start DB2.

5, execute the DB2 command through apf-authorized application, can execute all DB2 commands

6, through IFI (Instrumentation facility Interface) application. All DB2 commands can be executed.