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 Checking 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 from http://www.microsoft.com/en-us/download/confirmation.aspx?id=13523 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
- Un-tar the openssl-1.0.1p.tar.gz file to c:\Traf-Windows-BldTools folder
- Launch Visual Studio 2013 tool x64 Cross Tools Command prompt
- Change to the directory where you have un-tarred openssl source file. For example:
cd c:\Traf-WinBld-Tools\openssl-1.0p) - Configure the target directory to install openssl using the command:
perl Configure VC-WIN64A --prefix=c:/openssl-1.0.1p.
- Run the following
- ms\do_nasm
- ms\do_win64a
- nmake –f ms\nt.mak clean (to clean)
- nmake -f ms\nt.mak install (to build static libraries and install it to the location specified during configure step)
- 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
- Launch Visual Studio 2013 tool x64 Cross Tools Command prompt
- Change to the directory where you have un-zipped zlib source location. For example: cd c:\Traf-WinBld-Tools\zlib-master
- Open the Visual Studio solution (zlibvc.sln) located in zlib-master\contrib\vstudio\vc11. Then do the following:
- Change the Solution Configuration to “Release” “x64” for the solution
- Do Build / Clean Solution; and Build Solution
- 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
Component | Start script | Stop script |
For all of Trafodion | sqstart | sqstop |
For DCS (Database Connectivity Service) | dcsstart | dcsstop |
For REST server | reststart | reststop |
For LOB server | lobstart | lobstop |
For RMS server | rmsstart | rmsstop |
|
|
|
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.