Three types of DB2 clients

I believe everyone has some knowledge about using the DB2 database and the DB2 client. The following describes the three types of the DB2 client, hoping to help you.

The most basic DB2 client tool is the control center provided by IBM. This tool can be downloaded from the official IBM website. It has three versions, both of which consume resources and are very slow, it is better to use command line db2cmd.

DB2 client information:

DB2 provides clients for communication with the DB2 server. There are three types of DB2 clients:

DB2 runtime DB2 Client DB2Runtime Client): This type of Client provides the ability to access the DB2 database for workstations running on various platforms. It only provides basic connectivity-not many are just right.

If you want to establish connectivity to a remote DB2 server or DB2 connection Gateway Connect Gateway) that helps you access DB2 on a mainframe or host system similar to DB2for z/OS, you must at least use this client. Of course, you can use any client to connect.

DB2 administration DB2 Client): This type of Client provides workstations on various platforms with the ability to access and manage DB2 databases through the control center or Configuration Assistant.

DB2 management DB2 client has all functions of the DB2 runtime client, and also contains all DB2 management tools, documents, and support for thin clients. It also provides the ability to manage the z/OS and IMS subsystems if you have DB2Connect ).

DB2 Application Development Client (DB2Application Development Client): This type of Client provides the tools and environment required for developing applications that access the DB2 server. You can use the DB2 Application Development client to build and run DB2 applications. Of course, because this is a DB2 client, it also provides the connectivity feature to users.
 

Introduction to DB2 database Permissions

Policy Selection for DB2 environment variable Management

Several Simple DB2 operation statements

DB2 isolation level-Repeatable read

DB2 query Management Utility