Disconnecting a database in DB2

Source: Internet
Author: User
Tags db2 connection reset
What is the difference between the three commands of connect reset, disconnect current, and quit in DB2? Or which one can really disconnect after connecting to the DB2? Connect reset literally means "connection reset";
Disconnect current literally means "disconnecting the connection";
All of the above two commands can disconnect the database;
Quit is the exit interaction mode, equivalent to using CTRL + C to exit the interactive mode, after using this command only to exit the interactive mode, the database connection is not broken, if the input DB2 into interactive mode, you can continue to use the previous connection for SQL operations (if you do not use the Connect Reset or disconnect current command disconnects). And I always use is the QUIT command, now from the test results, this is a misuse, is not understand the cause of their own before, for this record. The correct way to do this is to use connect reset or the Disconnect current command to disconnect and quit. After connecting to the database, perform the Connect reset command result: Disconnect current command results after connecting to the database: Execute the QUIT command after connecting to the database result: add: DB2 Terminate-Disconnect the database. Reproduced in: http://blog.chinaunix.net/uid-20686525-id-95382.html recommend a good website: you can see the whole station 7500 video lessons, want to learn programming small partner speed. Limited time: http://e.jikexueyuan.com/invite/index.html? znjvbv9jb2rlpunknlaxnyz1bmftzt1xcv90czjmbtnqnszjagfubmvspwludml0zv9zagfyzwj1dhrvbl9kaxjly3qwna==

Disconnecting a database in DB2

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.