ubTools Suite is a suite which consists of ubSQL, itrprof SQL Analyzer and iStatsPackAnalyzer. Download the suite.

ubSQL:

	Production	Evaluation
Expiry	Never expires	Never expires
Fetch threads	Usually unreached	up to 2
Fetched rows per fetch thread	Unlimited	up to 10,000,000

ubTools Web Package:

	Production	Evaluation
Expiry	Never expires	15 days

Linking ubSQL:

If installed ubSQL executable is compatible with your environment, skip linking step and just run ubSQL executable. Otherwise, you should link ubSQL to generate ubSQL executable as <oracle> user:

• cd <ubSQL.o_directory>
  

• make -f $ORACLE_HOME/rdbms/demo/demo_rdbms.mk build EXE=ubSQL OBJS=ubSQL.o

The steps above will generate ubSQL executable. If you don't have a certified C compiler, you get error. See Oracle Note:43208.1 for the certified C compilers.


Verifying Installation

If you want to evaluate ubSQL, set LICENSE_KEY=EVALUATION in ubSQL.ini and run ubSQL. After running ubSQL, you should see the following messages:

• ./ubSQL
  
  ubSQL: Release 4.2.2 - Production - _POSIX_VERSION: 200112
  
  Copyright (c) 2005, ubTools, Adana/Turkey.  All rights reserved.
  
  Not connected to an instance.
  
  WARNING: This is an evaluation version.
  Targeted unload rows per session thread: <rowLimitPerSessionThread>
  Maximum session thread                             : <sessionThreadLimit>
  
  ubSQL>

Production License Key:

If you need a production license key, set LICENSE_KEY=NULL in ubSQL.ini and run ubSQL. It will generate a pre-license key.

• ./ubSQL
  
  ubSQL: Release 4.2.2 - Production - _POSIX_VERSION: 200112
  
  Copyright (c) 2005, ubTools, Adana/Turkey.  All rights reserved.
  
  Not connected to an instance.
  
  Contact Support with the pre-license key: <preLicenseKey>
  
  ubSQL>
  

Email this key to ubTools. Then, ubTools provides a production license key.

ubTools Web Package consists of itrprof SQL Analyzer and iStatsPackAnalyzer, which require Java and servlet container. If there is no web admin in your company and you're not familiar with java servlets, It's still not a problem. It's very easy to install Java, and Tomcat as a servlet container.

Java and Tomcat are free softwares. Yo don't have to integrate Tomcat to Apache. Standalone Tomcat is enough to run ubTools Web Package.

Download and configure Java and Tomcat as below:

• Download and install J2SE 1.4.2.

• Set an environment variable JAVA_HOME to the pathname of the directory into which you installed the Java release.

• Download and install Tomcat 4.1.

Windows (Service) Installer is recommended for Windows. This download can create a Windows Service for Tomcat.

• Set an environment variable CATALINA_HOME to the path of the directory into which you have installed Tomcat.
• Starting up Tomcat:
  

Windows:

If you downloaded Windows (Service) Installer, just start Apache Tomcat service from Control Panel.

If you downloaded a compressed one:

cd %CATALINA_HOME%\bin
startup

Unix:

cd $CATALINA_HOME/bin
./startup.sh

• Test if Tomcat is started up:

http://yourHostName:8080

• Shutting down Tomcat:

Windows:

If you downloaded Windows (Service) Installer, just stop Apache Tomcat service from Control Panel.

If you downloaded a compressed one:

cd %CATALINA_HOME%\bin
shutdown

Unix:

cd $CATALINA_HOME/bin
./shutdown.sh