Using the Aster Command Tool (ACT) with Aster Express

Document created by John Thuma on Nov 26, 2014Last modified by John Thuma 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


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


3.  In the Port enter:




4.Click ‘Open’


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




  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



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:


Press Enter on your keyboard to run the command.

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