The in-database deployment
package binary files for Aster are contained in a self-extracting
archive file named sepcoreastr-12.00000-1.sh. To install the in-database
deployment package binary files for Aster, you need root privileges
for the queen node. Once you are logged in to the queen node as root,
you need to create a directory in which to put sepcoreastr-12.00000-1.sh,
execute sepcoreastr-12.00000-1.sh, and install the SAS_SCORE( )
and the SAS_PUT( ) SQL/MR functions.
Enter these commands
to install the SAS System Libraries and the binary files:
-
Log on to the queen
node.
ssh -l root name-or-ip-of-queen-node
-
Move to the parent of
the partner directory.
-
Create a partner directory
if it does not already exist.
-
Move to the partner
directory.
-
From the SAS client
machine, copy the sepcoreastr-12.00000-1.sh from the client EPZipDir directory
to the partner directory on the queen node.
-
Navigate to the /EPZipDir/sasexe directory
on the client machine.
-
Copy the self-extracting
archive file to the partner directory on the queen node. This example
uses secure copy.
scp sepcoreastr-12.00000-1.sh root@astmach1:/home/beehive/partner
-
If your client does
not copy the executable attribute from the client machine to the server,
add the EXECUTE permission to the self-extracting archive file after
the file is transferred to the server.
chmod 755 -r sepcoreastr-12.00000-1.sh
-
Unpack the self-extracting
archive file in the partner directory.
./sepcoreastr-12.00000-1.sh
This installs the SAS
Embedded Process on the queen node. When Aster synchronizes the beehive,
the files are copied to all the nodes. This can take a long time.
-
(Optional) There are
two methods to copy the files to the nodes right away. You can do
either of the following steps:
-
Run the following code to manually
move the files across all nodes on the beehive by using secure copy
and SSH:
location=/home/beehive/partner
cd $location
for ip in `cat /home/beehive/cluster-management/hosts |
grep node | awk '{print $3}'`; \
do \
echo $ip; \
scp -r sepcore* root@$ip":$location"; \
ssh $ip "cd $location; ./sepcoreastr-12.00000-1.sh";
done
-
Run this command to synchronize
the beehive and restart the database:
/home/beehive/bin/utils/primitives/UpgradeNCluster.py -u
-
Navigate to the directory
where the SAS Embedded Process is installed.
cd /home/beehive/partner/SASEPHome/sasexe
-
Install the SAS_SCORE( ),
SAS_PUT( ), and other SQL/MR functions.
-
Start the ACT tool.
/home/beehive/clients/act -U db_superuser -w db_superuser-password
-d database-to-install-sas_score-into
-
Run this command to
verify if there are any existing SQL/MR functions installed:
If you see existing
SAS functions installed, it is recommended that you remove them before
installing the new ones. Enter these commands to remove the functions:
\remove sas_score.tk.so
\remove sas_put.tk.so
\remove sas_row.tk.so
\remove sas_partition.tk.so
-
Enter the following
commands to install the new SQL/MR functions. The SQL/MR functions need to be installed under the PUBLIC schema.
\install sas_score.tk.so
\install sas_put.tk.so
\install sas_row.tk.so
\install sas_partition.tk.so
-
-
Verify the existence
and current date of the tkast-runInCluster and tkeastmr.so files.
These two binary files are needed by the SAS SQL/MR functions.
for ip in \
`cat /home/beehive/cluster-management/hosts | grep node | awk '{print $3}'`; \
do \
echo $ip; \
ssh $ip "ls -al /home/beehive/partner/SASEPHome/sasexe/tkeastmr.so"; \
ssh $ip "ls -al /home/beehive/partner/SASEPHome/utilities/bin/
tkast-runInCluster"; \
done