Data Management Global

       This document provides the steps to install the Db2Connect VS Code extension. It also provides the steps to use the extension.

1. Install and start Visual Studio Code:
   1. Download and install Visual Studio Code on your machine.
   2. Launch Visual Studio Code.
2. Install the Db2Connect Extension:
   1. The Db2Connect extension allows the user to connect to a Db2 Server and perform operations.
   2. In Visual Studio Code, select ‘Extensions’ from the sidebar.
      1. Search for ‘Db2Connect’.
      2. Install the Extension based on your platform.
         
3. Db2: Manage connection profiles
   1. User can create, edit and delete connection profiles using Manage connection profiles. 
   2. Press Ctrl+Shift+P or F1 to open the Command Palette.
      
   3. Type Db2 to display the Db2 commands and then select Db2: Manage Connection Profiles.
      
   4. Please choose one of the options.
      
   5. User can create a connection profile by entering the following details
      1. Profile Name: Enter the profile name.
      2. Database: Enter the database name.
      3. Hostname: The Db2 server that user want to use.
      4. Port: Enter the Port number.
      5. Userid: Enter the name of a user with access to a Db2 server.
      6. Password: Enter the password for the specified user.
   6. User can test the profile by clicking on the Test Connection button
      
   7. Click on “Save and Close” and Profile will be saved.
      
      
   8. User can Edit Connection profile by selecting a profile that user want to edit:
      1. Database: Enter the database name.
      2. Hostname: The Db2 server that user want to use
      3. Port: Enter the Port number
      4. Userid: Enter the name of a user with access to a Db2 server
         
      5. User can change the password by checking on the checkbox.
      6. Click on “Update and Close” and profile will be saved.
   9. User can delete connection profile by selecting a profile that user want to delete
      
      Click on “Delete” and profile will be deleted.
4. Db2: Connect
   1. Select View > Command Palette > Db2: Connect 
      
   2. Choose one of these options.
      
   3. If the user selects the first option, an input box where a user can enter the connection string will be prompted.
      
   4. If the user selects the second option, a Connection Parameters window will be shown.
      
      Enter details such as Database, Hostname, port, user id, password and click on “Connect” for making a connection.
   5. If the user chooses the third option, a list of profiles is displayed.
      1. User can choose any profile and make a connection.
         
5. Db2: Execute Query
   1. Select View > Command Palette > Db2: Execute Query
      
   2.  when the user selects Db2: Execute Query user will be prompted to enter the query.
      
   3.  Enter the Query and press ‘Enter’ to confirm it.
   4.  The result will we displayed in a grid view.
      
6. Db2: Execute Non-Query
   1. Select View > Command Palette > Db2: Execute Query
      
   2. when the user selects Db2: Execute Non-Query user will be prompted to enter the sql.
      
   3.  Enter the sql and press ‘Enter’ to confirm it.
      
7. Db2: View Command History
   1. Select View > Command Palette > Db2: View Command History
      
   2. when the user selects Db2: View Command History untitled file will be opened where a list of user executed commands are displayed with time.
      
   3. User has to copy the sql and paste in the input box of Execute Query or Execute Non-Query
   4. While closing the untiled file click on don’t save.
8. Db2: Rebuild Native Modules
   1.  Select View > Command Palette > Db2: Rebuild Native Modules
      
   2.  This option is used when a new version of an electron is introduced into the vs code Editor. One can use this command to install the latest ibmdb driver which is compatible with the latest electron version.
9. Db2: Disconnect 

   1. Select View > Command Palette > Db2: Disconnect

      

   2. Disconnects the current opened connection.

10. Db2: Report an Issue
    1. Select View > Command Palette > Db2: Report an Issue
       
    2. This option opens the GitHub repository in the browser where the user can raise any issues related to this extension.