Updated on 2023-04-03 GMT+08:00

Installing DSC

Before using DSC, install it on a Linux or Windows server. DSC supports 64-bit Linux OSs. For details about other OSs supported by DSC, see Compatible OSs.

Prerequisites

  • In Linux, do not install or perform operations on DSC as the root user. To execute the install.sh script, you must have the permission for creating folders.
  • The size of the target folder must be at least four times that of the SQL files in the input folder.

    For example, if the size of the SQL files in the input folder is 100 KB, the target folder must have available disk space of at least 400 KB to process the SQL files.

    • To query the available disk space of the target folder in Linux, run the following command:
      df -P <Folder path>
    • To query the size of the input file in Linux, run the following command in the directory where the file resides:
      ls -l
  • JRE 1.8 or later and Perl have been installed. For details about the hardware and software requirements, see System Requirements.
    To check the installed Java version and set the Java path, perform the following steps:
    1. Check whether the Java version meets requirements.
      java -version
    2. Ensure that the Java path is correctly set.
      • Linux
        1. Check whether the Java path is correctly set.
          echo $JAVA_HOME
        2. If no information is returned, add the following two lines to the .bashrc file of the current user, save the modification, and exit.
          Assume that the Java installation path is /home/user/Java/jdk1.8.0_141.
          export JAVA_HOME=/home/user/Java/jdk1.8.0_141
          export PATH=$JAVA_HOME/bin:$PATH
        3. Activate Java environment variables.
          source ~/.bashrc
      • Windows
        1. Right-click My Computer and choose Properties from the shortcut menu. The System window is displayed.
        2. Click Advanced System Settings. The System Properties dialog box is displayed.
        3. On the Advanced tab page, click Environment Variables. The Environment Variables dialog box is displayed.
        4. Select Path in the System variables area. Click Edit and check the Java installation path.

          If the Java installation path does not exist or is incorrect, add the Java path of this PC to Path.

          Assume that the Java installation path is C:\Program Files\Java\jdk1.8.0_141\bin and the environment variable in Path is c:\windows\system32;. Set Path to c:\windows\system32;C:\Program Files\Java\jdk1.8.0_141\bin;.

Procedure

DSC is an installation-free tool. You can use it after downloading and decompressing the software package.

The following procedure describes how to obtain the package. Decompress the package DSC.zip and then DSC.rar to obtain the files shown in Table 1.

Windows:

  1. Log in to the GaussDB(DWS) management console and download the DCS software package. For details, see Downloading Client Tools.
  2. Decompress the DSC.zip package.

    The DSC folder is generated.

    You can decompress DSC.zip to any folder you need.

  3. Go to the DSC directory.
  4. Find and check the files in the DSC directory.

    Table 1 describes the obtained folders and files.

Linux:

  1. Log in to the GaussDB(DWS) management console and download the DCS software package. For details, see Downloading Client Tools.
  2. Extract files from DSC.zip.

    sh install.sh

  3. Go to the DSC directory.

    cd DSC

  4. Check the files in the DSC directory.

    ls 
    config   lib   scripts   bin  input output runDSC.sh  runDSC.bat

Table 1 DSC directory

Folder or File

Description

DSC

bin

DSC-related JAR package (executable)

config

Configuration file of DSC

input

Input folder

lib

Library files required for the normal running of DSC

output

Output folder

scripts

Customized configuration scripts for Oracle and Teradata migration, which can be executed to implement corresponding functions

runDSC.sh

Application executed on the Linux OS

runDSC.bat

Application executed on the Windows OS

changelog

To notify users of the current modifications

Install.sh

To set the file permissions for DSC

readme

Instructions of installation and configuration

If you do not need DSC, you can uninstall it by deleting the DSC folder.