Home Database Mysql Tutorial DB2 客户端工具

DB2 客户端工具

Jun 07, 2016 pm 03:17 PM
db2 Basic client tool

DB2 客户端工具最基本的就是IBM提供的控制中心了,这个可以在IBM的官方网站下载到,有三个版本,都比较耗资源而且很慢,还不如用命令行db2cmd:) 下面这些是从IBM网站摘录的db2 client的相关信息: DB2 提供了用于与 DB2 服务器通信的客户机。DB2 客户机有

   DB2 客户端工具最基本的就是IBM提供的控制中心了,这个可以在IBM的官方网站下载到,有三个版本,都比较耗资源而且很慢,还不如用命令行db2cmd:)

  下面这些是从IBM网站摘录的db2 client的相关信息:

DB2 提供了用于与 DB2 服务器通信的客户机。DB2 客户机有三种类型:

  • DB2 运行时客户机(DB2 Runtime Client): 这类客户机为运行各种平台的工作站提供了访问 DB2 数据库的能力。它只提供基本连通性 — 不多不少刚刚好。如果您要建立到远程 DB2 服务器或 DB2 连接网关(Connect Gateway)(它帮助您访问类似 DB2 for z/OS 的大型机或主机系统上的 DB2)的连通性,那么您至少必须使用这个客户机。当然,您可以使用任何客户机进行连接。

  • DB2 管理客户机(DB2 Administration Client): 这类客户机为各种平台的工作站提供了通过控制中心或配置助手(Configuration Assistant)访问并管理 DB2 数据库的能力。DB2 管理客户机具有 DB2 运行时客户机的所有功能,并且还包含所有 DB2 管理工具、文档以及对瘦客户机的支持。它还提供了管理 z/OS 和 IMS 子系统的能力(如果您有 DB2 Connect)。

  • DB2 应用程序开发客户机(DB2 Application Development Client): 这类客户机提供了开发访问 DB2 服务器的应用程序所需的工具和环境。您可以使用 DB2 应用程序开发客户机来构建和运行 DB2 应用程序。当然,由于这是 DB2 客户机,所以它还向用户提供了连通性功能。


    这三种客户端都可以在ibm的网站上下载,下面是链接
    http://www-1.ibm.com/support/docvie...s=UTF-8&lang=en 
    http://www-306.ibm.com/software/data/db2/udb/support/downloadv8_windows32bit.html

    当然,还有一些第三方的工具可以连接DB2,有:

    ■ Quest公司的QuestCentral和Toad(http://www.toadsoft.com/)

    ■ Embarcadero的DBArtisan和Rapid SQL

    ■ EMS的sql manager(http://www.sqlmanager.net/)

    这些工具里面Toad和ems sql manager都有免费版本的工具可以使用,比IBM自带的客户端速度要快一些,界面也人性化一些(不得不在这里抱怨一下,IBM的工具做得实在是$%#^,太难用了)。这些工具里面好像Quest公司的QuestCentral用户要多一些,Toad就差一些,耗资源比较多,而且比较慢:(

    哦,还有一个开源的java数据库工具squirrel-sql(http://squirrel-sql.sourceforge.net/),功能稍弱一些,不过这个工具最大的好处是只要有JDBC驱动就可以连数据库,不用限制于一种客户端只能连一种数据库了。

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial
1663
14
PHP Tutorial
1264
29
C# Tutorial
1237
24
What kind of software is a digital currency app? Top 10 Apps for Digital Currencies in the World What kind of software is a digital currency app? Top 10 Apps for Digital Currencies in the World Apr 30, 2025 pm 07:06 PM

With the popularization and development of digital currency, more and more people are beginning to pay attention to and use digital currency apps. These applications provide users with a convenient way to manage and trade digital assets. So, what kind of software is a digital currency app? Let us have an in-depth understanding and take stock of the top ten digital currency apps in the world.

What is the difference between php framework laravel and yii What is the difference between php framework laravel and yii Apr 30, 2025 pm 02:24 PM

The main differences between Laravel and Yii are design concepts, functional characteristics and usage scenarios. 1.Laravel focuses on the simplicity and pleasure of development, and provides rich functions such as EloquentORM and Artisan tools, suitable for rapid development and beginners. 2.Yii emphasizes performance and efficiency, is suitable for high-load applications, and provides efficient ActiveRecord and cache systems, but has a steep learning curve.

How to uninstall MySQL and clean residual files How to uninstall MySQL and clean residual files Apr 29, 2025 pm 04:03 PM

To safely and thoroughly uninstall MySQL and clean all residual files, follow the following steps: 1. Stop MySQL service; 2. Uninstall MySQL packages; 3. Clean configuration files and data directories; 4. Verify that the uninstallation is thorough.

Steps to add and delete fields to MySQL tables Steps to add and delete fields to MySQL tables Apr 29, 2025 pm 04:15 PM

In MySQL, add fields using ALTERTABLEtable_nameADDCOLUMNnew_columnVARCHAR(255)AFTERexisting_column, delete fields using ALTERTABLEtable_nameDROPCOLUMNcolumn_to_drop. When adding fields, you need to specify a location to optimize query performance and data structure; before deleting fields, you need to confirm that the operation is irreversible; modifying table structure using online DDL, backup data, test environment, and low-load time periods is performance optimization and best practice.

How to use MySQL functions for data processing and calculation How to use MySQL functions for data processing and calculation Apr 29, 2025 pm 04:21 PM

MySQL functions can be used for data processing and calculation. 1. Basic usage includes string processing, date calculation and mathematical operations. 2. Advanced usage involves combining multiple functions to implement complex operations. 3. Performance optimization requires avoiding the use of functions in the WHERE clause and using GROUPBY and temporary tables.

Quantitative Exchange Ranking 2025 Top 10 Recommendations for Digital Currency Quantitative Trading APPs Quantitative Exchange Ranking 2025 Top 10 Recommendations for Digital Currency Quantitative Trading APPs Apr 30, 2025 pm 07:24 PM

The built-in quantization tools on the exchange include: 1. Binance: Provides Binance Futures quantitative module, low handling fees, and supports AI-assisted transactions. 2. OKX (Ouyi): Supports multi-account management and intelligent order routing, and provides institutional-level risk control. The independent quantitative strategy platforms include: 3. 3Commas: drag-and-drop strategy generator, suitable for multi-platform hedging arbitrage. 4. Quadency: Professional-level algorithm strategy library, supporting customized risk thresholds. 5. Pionex: Built-in 16 preset strategy, low transaction fee. Vertical domain tools include: 6. Cryptohopper: cloud-based quantitative platform, supporting 150 technical indicators. 7. Bitsgap:

Laravel logs and error monitoring: Sentry and Bugsnag integration Laravel logs and error monitoring: Sentry and Bugsnag integration Apr 30, 2025 pm 02:39 PM

Integrating Sentry and Bugsnag in Laravel can improve application stability and performance. 1. Add SentrySDK in composer.json. 2. Add Sentry service provider in config/app.php. 3. Configure SentryDSN in the .env file. 4. Add Sentry error report in App\Exceptions\Handler.php. 5. Use Sentry to catch and report exceptions and add additional context information. 6. Add Bugsnag error report in App\Exceptions\Handler.php. 7. Use Bugsnag monitoring

Easeprotocol.com directly implements ISO 20022 message standard as a blockchain smart contract Easeprotocol.com directly implements ISO 20022 message standard as a blockchain smart contract Apr 30, 2025 pm 05:06 PM

This groundbreaking development will enable financial institutions to leverage the globally recognized ISO20022 standard to automate banking processes across different blockchain ecosystems. The Ease protocol is an enterprise-level blockchain platform designed to promote widespread adoption through easy-to-use methods. It announced today that it has successfully integrated the ISO20022 messaging standard and directly incorporated it into blockchain smart contracts. This development will enable financial institutions to easily automate banking processes in different blockchain ecosystems using the globally recognized ISO20022 standard, which is replacing the Swift messaging system. These features will be tried soon on "EaseTestnet". EaseProtocolArchitectDou

See all articles