/bin directory of
the server’s configuration path.
|
Utility Name
|
Function
|
|---|---|
dfsadmin |
./bin/dfsadmin
start|stop|status|restartUse for server administration.
|
dfsutil |
./bin/dfsutil
backup|restoreUse for database backup
and restore. The options are backup and restore.
|
dfdbconf |
./bin/dfdbconf
A|D|XODBC configuration tool.
Use to add new data sources or edit existing ones. The options are
A –Add, D –Delete, and X – Exit.
|
dfdbview |
ODBC viewer used to
list data sources:
./bin/dfdbview –l(ist)To test data sources and run SQL:
./bin/dfdbview DSN-name |
dfsadmin utility, located
in the /bin directory of the server’s
configuration path. Run any of the commands using the following syntax: ./bin/dfsadminyourcommand where yourcommand is
one of the following:
Starts SAS Federation Server.
Example: ./bin/dfsadmin start
Stops SAS Federation Server.
Example: ./bin/dfsadmin stop
Checks the run status of SAS Federation Server.
Restarts SAS Federation Server.
dfsutil utility
is located in the /bin directory of the server’s
configuration path. With dfsutil, you can perform dynamic database backups without disruption to server operations.
You can back up the system database (SYSCAT.tdb) and the default SQL logging database
(SQL_Log). However, you cannot back up the SQL logging database
with dfsutil if it uses a third-party
data store. You can also restore databases using dfsutil if
the database was backed up using the same utility.
dfsutil, then you are required to restore
that database using dfsutil.
dfsutil to perform a
backup and restore for a SAS Federation Server database. Note that
you can run backups while the server is running.
dfsutil command with the –db parameter.
Note that you can run this command while the server is operational.
Using the configuration path, navigate to the directory that contains /bin and
use the following command syntax:
.bin/dfsutil
backup -db syscat /path_to_backupdfsutil command with the -db parameter.
Using the configuration path, navigate to the directory that contains /bin and
use the following command syntax:
.bin/dfsutil
restore -db syscat /path_to_backupdfdbconf to
add a new data source or edit existing data sources in your ODBC configuration.
./bin/dfdbconfA to
add a data source.
dfdbview to list data sources and run interactive SQL queries.
dfdbview —l.
./bin/dfdbview DSN-name.
For example, if you added a data source called my_oracle, run ./bin/dfdbview
my_oracle. You might be prompted for a user name and password if there is additional security
on the DSN. After establishing connection to the data source, you will see a prompt from which
you can enter SQL commands and query the database. If the connection fails, dfdbview displays
error messages describing one or more reasons for the failure.
dfsutil to
back up and restore the system catalog. This utility is located in \bin of
the configuration directory (for example, <drive>\SAS\config\Levn\FederationServer\bin).
With dfsutil, you can perform dynamic database
backups without disruption to server operations. If you back up a
database with dfsutil, then you are required
to restore that database using dfsutil.
–db parameter with the dfsutil command
and include the name of the database in the backup statement. You
do not need to stop the SAS Federation Server service to run this
command. Here is the command syntax: drive:\SAS\config\Levn\FederationServer\bin>dfsutil
backup -db syscat path_to_backup_directory\backup_filenamec:\SAS\config\Lev1\FederationServer\bin>dfsutil
backup -db syscat c:\dfsutilBackup\syscatbk.tdbdfsutil only if the database was backed
up with dfsutil. To restore a database, use the -db parameter
with the dfsutil command. Here is the command
syntax: drive:\SAS\config\Levn\FederationServer\bin>dfsutil
restore -db syscat\path_to_backup_directory\syscat.tdbC:\SAS\config\Lev1\FederationServer\bin>dfsutil
restore -db syscat\c:\dfsutilBackup\syscatbk.tdb