Using the Aster Command Tool (ACT) with Aster Express

Document created by jthuma on Nov 26, 2014Last modified by jthuma on Apr 5, 2015
Version 6Show Document
  • View in full screen mode


What is the Aster Command Tool (ACT)

 

The Aster Command Tool, or ACT, is a utility that allows a user to run commands against an Aster System.  With ACT you can run ANSI SQL, SQL-MR, and SQL-GR queries against databases within the Aster environment. 

 

ACT is a terminal-based query tool that connects with Aster Database.  ACT is installed on the queen during a typical Aster Database installation.  ACT can be installed on another machine. 

 

 

How do I use the Aster Command Tool (ACT)

 

1.  Start an SSH tool from your desktop, this example uses PuTTy.  Click the PuTTy icon from your desktop.  The following screen should appear:

 

To download and install PuTTy:  SSH/Terminal Software

act2.png


2.In the Host Name (or IP address) enter the following IP address:

192.168.100.100

 

3.  In the Port enter:

 

22

 

4.Click ‘Open’

 

5.A terminal window should appear.  It should look like the image below:

 

act3.png

 

  Now we we will log into Aster Command Tool (ACT)

 

9.  From the terminal window enter the following command:

 

act –U db_superuser –w db_superuser –d beehive

 

This command will log you into the beehive database as user db_superuser

 

Press enter on your keyboard, your screen should look like the one below


act4.png

 

How to run a query from ACT

 

Type the following ANSI SQL Command into the command window:

 

SELECT * FROM public.namefind_configure;

 

Your screen should look like this:

act5.png

Press Enter on your keyboard to run the command.


The query will run and provide the query results.   See below:

act6.png

Attachments

    Outcomes