The primary file system
is the base directory that you assign to the LIBNAME domain by issuing
a PATHNAME= statement in the SPD Server LIBNAME parameter file, libnames.parm.
Here is an example of a libnames.parm parameter file entry:
spdsserv -acl
-acldir InstallDir/site
-nameserver samson
-libnamefile libnames.parm
Sample libnames.parm
file entry for a UNIX system:
LIBNAME=all_users
pathname=/disk1/peruser_tables;
Sample libnames.parm
file entry for Windows:
LIBNAME=all_users
pathname=d:\peruser_tables;
When SPD Server users
create new tables in a LIBNAME domain, you must keep in mind that
thee metadata component (.mdf) must start in the primary file system.
If all the available space in the primary file system is consumed,
SPD Server cannot create new tables until disk space becomes available.
Example 1 stores all
the component files (metadata, data, and index data) in the primary
file system. This arrangement can cause problems if you use large
tables. Large tables can quickly fill up the primary file system.
To avoid this problem, you should store the data and index components
separately from the primary file system. Example 2 shows how to do
this using ROPTIONS= with your LIBNAME statement in your libnames.parm
file.