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.