Utilities for SAS Federation Server

SAS Federation Server for UNIX contains the dfsadmin utility, located in the bin directory of the installation root. Run any of the commands in dfsadmin using the following syntax: ./bin/dfsadmin yourcommand where yourcommand is one of the following commands:

The dfsadmin utility contains a crypt command from where you can key the password on the command line in plain text, or let it prompt you so that the password is not echoed to terminal. The password is encrypted using the encryption type installed on the server.

Here is an example:

./bin/dfsadmin crypt my_passwd

Key a password with the crypt command:

[admin@reason fedserver]$ ./bin/dfsadmin crypt my_passwd
{SAS002}1950043249132FE80CEC515733C508D5

Invoke the crypt command and let it prompt for a password:

[admin@reason fedserver]$ ./bin/dfsadmin crypt
Enter password:
Confirm password:
Encrypted value: {SAS002}1950043249132FE80CEC515733C508D5

It is recommended that you backup the Federation Server databases periodically, especially the system catalog, SYSCAT.tdb. A utility named dfsutil is provided with SAS Federation Server installation and is located in /bin of the installation directory. With dfsutil, dynamic database backups can be performed without disruption to server operations. You can back up the system database (SYSCAT.tdb) and other databases such as the SQL Logging database (SQL_Log). However, the SQL Logging database cannot be backed up with dfsutil if it was changed to a third-party data store. You can also restore databases using dfsutil as long as the database was backed up using the same utility.

The procedures below describe how to use dfsutil to perform a backup or restore for a SAS Federation Server database. Note that you can run dfsutil while the server is running.

To backup a database, use the -db parameter with the dfsutil command. Note that you can run this command while the server is running. For example:

install-path/bin/dfsutil
backup -db syscat
/path/to/backup           
install-path/bin/dfsutil
backup -db sql_log
/path/to/backup

To restore a database, use the -db parameter with the dfsutil command. For example:

install-path/bin/dfsutil
restore -db syscat
/path/to/backup           
install-path/bin/dfsutil
restore -db sql_log
/path/to/backup

Use the dfs_crypt utility to encrypt passwords. dfs_crypt, is located in the /bin directory of the installation path for SAS Federation Server.

It is recommended that you backup the Federation Server databases periodically, especially the system catalog, SYSCAT.tdb. A utility named dfsutil is provided with SAS Federation Server installation and is located in /bin of the installation directory. With dfsutil, dynamic database backups can be performed without disruption to server operations. You can back up the system database (SYSCAT.tdb) and other databases such as the SQL Logging database (SQL_Log). However, the SQL Logging database cannot be backed up with dfsutil if it was changed to a third-party data source. You can also restore databases using dfsutil as long as the database was backed up using the same utility.

The procedures below describe how to use dfsutil to perform a backup or restore for a SAS Federation Server database. Note that you can run dfsutil while the server is running.

To backup a database, use the -db parameter with the dfsutil command. Note that you can run this command while the server is running. For example:

install-path\bin\dfsutil
backup -db syscat
\path\to\backup           
install-path\bin\dfsutil
backup -db sql_log
\path\to\backup

To restore a database, use the -db parameter with the dfsutil command. For example:

install-path\bin\dfsutil
restore -db syscat
\path\to\backup           
install-path\bin\dfsutil
restore -db sql_log
\path\to\backup