Summary of db2 management tools

Source: Internet
Author: User
Tags db2 client

Summary of db2 management tools
Recently I have been studying the db2 Connection Tool. I have studied it well. Every time I go to the db2 Client Forum, I am recommended that I use toad for db2 because of the company's network speed problem and working progress problem, so I have not studied it, this evening I suddenly studied IBM's toad for db2 tool with great interest. 1 File> new connection

2. Select the "Client Configuration Wizard" icon on the login tab (similar to the one on the TV)

3. Click "Add Catalog Entry" to bring up the Add a host dialog box.

4. Select the operating System Opeartion System (windows) TCP/IP Settings: Host name: 172.16.17.7 (Server IP address for installing DB2) Port Number: 50000

5. next click "next" to Specify an Instanse. 6. Set the DB2 strength information: Node name: NODE1 (name of the Instance connected to the db2 database, whatever the name is) Instance name: db1; remarks comment: Stage Description: now we have created a connection node NODE1 with db2 on Toad. NODE1 can configure many db2 database links db1, db2, db3... 7. next to Add a Database

8. Set the Database information: db2 Database name: YFGL (name of the data already created on db2) Database alias: YFGL (the system automatically adds the Database name when it is filled in, (do not change) Authentication: server (default, do not change) 9 until finish. If you see The following information, the configuration is successful: DB20000I The catalog database command completed successfully. DB21056W Directory changes may not be valid tive until the directory cache is refreshed.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.