Download options

Download, build, and install Trafodion using git repository

If you would like to contribute to Trafodion, see instructions: Contribute to the Software.

Download, build, and install Trafodion using source tar file on Apache distribution site

The source code for Apache Trafodion can be downloaded from Apache Trafodion Incubator release as a tar file.  If you wish to contribute, we recommend that you follow instructions described in Contribute to the Software.

Instructions for building Trafodion:

• Download the source tar file to your <trafodion download directory>
• Check the tar file validity by checking signatures, see Verify Signatures. Our Trafodion releases have been signed using The GNU Privacy Guard. 
• cd <trafodion download directory>
• tar -xzf <tar file>
• Follow the instructions for building Trafodion - Building the Software

Download and Install Trafodion using software binaries

Download the latest version of the Trafodion software binaries from downloads.trafodion.org. 
To install the Trafodion software binaries on a cluster, see the instructions in Installation page.

Building Trafodion Windows driver  (Optional)

If you wish to build the Trafodion Windows driver, perform the following steps on your Windows machine. We recommend Windows 8 or greater.

• Create the following build directories:  C:\Build\win-odbc64\lib, C:\Build\win-odbc64\inc, C:\Build\win-odbc64\redist, and C:\Traf-Windows-BldTools
• Download and install Active perl for windows, download from https://www.perl.org/get.html
• Download and install Visual Studio 2013 community edition, download the 2013 community version from https://www.visualstudio.com
• Download, build and install openSSL version (openssl-1.0.1p.tar.gz), download from ftp://ftp.openssl.org/source/ and follow instructions in Build openssl static libraries for Windows 64 bit
• Download zlib for Windows, download from https://github.com/madler/zlib/ and follow instructions in Build zlib libraries for Windows 64 bit
• Download  and install Unicode version of Inno software for packaging, download from http://www.jrsoftware.org/isdl.php
  Download the  C++  Redistributable runtime library(vcredist_x64.exe) from http://www.microsoft.com/en-us/download/details.aspx?id=40784 and copy it to C:\Build\winodbc64\redist (Note: if the folder does not exist please create it)
• If you plan to contribute, download github  ( http://git-scm.com/downloads )
• Download Trafodion source (which contains Windows ODBC driver code) as described earlier and follow instructions in Build Trafodion Windows ODBC driver for Windows 64 bit

Build openssl static libraries for Windows 64 bit

1. Un-tar the openssl-1.0.1p.tar.gz file to c:\Traf-Windows-BldTools folder
2. Launch Visual Studio 2013 tool x64 Cross Tools Command prompt
3. Change to the directory where you have un-tarred openssl source file. For example:  
     cd c:\Traf-WinBld-Tools\openssl-1.0p)
4. Configure the target directory to install openssl using the command:
   

    perl Configure VC-WIN64A --prefix=c:/openssl-1.0.1p.
    

5. Run the following
   
   1. ms\do_nasm
   2. ms\do_win64a
   3. nmake –f ms\nt.mak clean (to clean)
   4. nmake -f ms\nt.mak install (to build static libraries and install it to the location specified during configure step)
6. Copy the file “applink.c” to the installed openssl include location. For example:

       copy c:\Traf-WinBld-Tools\openss-1.0.1p\ms\applink.c c:\openssl-1.0.1p\include)

Build zlib libraries for Windows 64 bit 

1. Launch Visual Studio 2013 tool x64 Cross Tools Command prompt
2. Change to the directory where you have un-zipped zlib source location. For example: cd c:\Traf-WinBld-Tools\zlib-master
3. Open the Visual Studio solution (zlibvc.sln) located in zlib-master\contrib\vstudio\vc11. Then do the following:
   1. Change the Solution Configuration  to “Release” “x64” for the solution
   2. Do Build / Clean Solution; and Build Solution
   3. Following error will be seen 

                 error LNK1118: syntax error in 'VERSION' statement    C:\Traf-Windows-bldTools\zlib-master\contrib\vstudio\vc11\zlibvc.def  

                 To resolve the above error, Double click on the error when it opens in the editor change the Version from 1.2.8 to 1.28

                          VERSION              1.2.8   to  VERSION              1.28

                  Click Save and Build the solution again

                  Build will succeed

          Close the Visual studio solution.

Build Trafodion Windows ODBC driver for Windows 64 bit    

• Launch Visual Studio 2013 tool x64 Cross Tools Command prompt
• cd  c:\incubator-trafodion\ win-odbc64\odbcclient
• Edit build_os.bat and update the following:

                     set ZLIB_INCLUDE_PATH=C:\zlib-master\include
                     set ZLIB_LIB_PATH= C:\Traf-Windows-bldTools\zlib-master\contrib\vstudio\vc11\x64\ZlibStatRelease
                     set OPENSSL_INCLUDE_PATH= C:\openssl-1.0.1p\include
                     set OPENSSL_LIB_PATH= C:\openssl-1.0.1p\lib

• Run the build script by executing, build_os.bat file

• Trafodion ODBC driver executable will be created in c:\Build\win-odbc64 folder

Starting and Stopping Trafodion

After the successful installation of Trafodion, Trafodion should already be started, initialized, and ready to use. If you need to stop and restart Trafodion, such as to install a new Trafodion build, please use the following commands.

If you started a new ssh session, be sure to setup your environment by:

   cd <download directory>/apache-trafodion-1.3.0-incubating
   source ./env.sh

Stopping Trafodion

CAUTION: You should stop Trafodion when it is idle. If you stop Trafodion while it is busy, there is a possibility of corrupting data and not being able to recover it.

If you are installing a new Trafodion build, you will need to stop the current instance. To shut down the Trafodion instance, log in as the trafodion user and run the sqstop command:

cd $MY_SQROOT/sql/scripts
sqstop

Starting Trafodion

To start the Trafodion instance, log in as the trafodion user and run the sqstart command:

cd $MY_SQROOT/sql/scripts
sqstart

Starting and Stopping Trafodion components

In case of any issues or if there is a need to stop and restart a specific Trafodion component, you can use the component based  start/stop scripts.
These scripts exist in $MY_SQROOT/sql/scripts 

Checking the status of Trafodion and its components

There are several health check scripts that are available which will provide the status of Trafodion. They exist in $MY_SQROOT/sql/script :

sqcheck   (For all of Trafodion)
dcscheck  (For Database Connectivity Service)
rmscheck  (For RMS Server)

Reinitializing Trafodion

Typically, if you have installed Trafodion, you will not need to reinitialize Trafodion. However, if you have purged all your data from Hadoop, you will need to reinitialize Trafodion.
To reinitialize the Trafodion database objects, log in as the trafodion user, start a sqlci session, and run the INITIALIZE TRAFODION command:

sqlci | cat
  initialize trafodion;
  exit;

Migrating or Loading Data into Trafodion

After you successfully install and start running Trafodion, you might want to move data from another relational database management system (RDBMS) to Trafodion. For guidelines, please see Data Loading.

Examples and Sample Programs

Sample programs that you can build and run against a Trafodion database are packaged with the ODBC and JDBC drivers. To install those drivers, connect to Trafodion, and run the sample programs, please see the Trafodion Client Installation Guide (pdf, 1.12 MB). That guide also explains how to configure various third-party tools to talk to Trafodion. For examples of the Trafodion SQL syntax, please see the Trafodion SQL Reference Manual (pdf, 3.98 MB).

Trafodion works with the OpenCart application, which is an open-source shopping cart solution. In the initial release of the Trafodion OpenCart demo, a limited set of OpenCart features has been implemented to work with Trafodion, mainly a simple shopping example using a guest account. Additional features may be available in future releases of the Trafodion OpenCart demo. See the Trafodion OpenCart Demo Guide (pdf, 1.4 MB) for instructions on how to download, install, configure, and run the Trafodion OpenCart demo.