SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 67 / 271

SPDSCONV reads the SPD Server 3.x metadata file a section at a time, recreating each
structure in the SPD Server 4.4 metadata file as it is read. After the SPD Server 4.4 metadata
file is fully populated, the data partition file component is checked to determine if updates
are required.
If SPDSCONV detects the presence of compression block headers, then the data partition
file contains SAS 8 compression information that is not compatible in SPD Server 4.4, and
the data partition files must be updated. SPDSCONV updates the data partition file by
overwriting the compression block headers. SPDSCONV does not change the size of the
data partition file, of any file components, or any of the data contained in the files. The
increase in metadata file size is very modest and represents only a small percentage of
storage space when compared to its corresponding data partition file component.
Once SPDSCONV updates the data partition file, there is no provision to restore or recreate
the original SPD Server 3.x data partition file. You should ensure that you have complete
backup images of the SPD Server 3.x datasets that you intend to convert prior to running
the conversion.
After the SAS job file recreates the SPD Server 3.x indexes for use with SPD Server 4.4,
all remnants of the SPD Server 3.x table are deleted. The SPDSCONV utility does not
perform ACL checks during the conversion. The individual running the SPDSCONV utility
(usually an SPD Server Administrator) cannot browse the contents of table rows from
within the utility. During the metadata file conversion, no table rows are accessed, and
there are no options to expose table row contents as part of logging or index job creation.
The SPD Server 4.4 table retains the same SPD Server owner as the SPD Server 3.x table.
Using SPDSCONV
The SPDSCONV program is a command-line utility. You use a set of command-line
options and parameters to specify the name and location of tables you wish to convert, then
specify the options you desire for your conversion. If your SPD Server software is installed
on a UNIX platform, refer to the
“SPD Server UNIX Installation Guide ” on page 11 for
information on setup required prior to running SPDSCONV.
The form of the command line is as follows:
SPDSCONV <Options> [-a | table1 [table2]]
The order of options and table names on the command line does not matter. All of the
currently available options are global options. Placing a global option before or after a table
does not change the option setting for that table alone.
Options for the SPDSCONV command are:
-d pathname
the directory path corresponding to an existing SPD Server LIBNAME domain. The
pathname specification should be the same as the PATHNAME= directory path found
in the libnames.parm file.
-l logpath
the directory path to store SAS job files created during the conversion process. The
default logpath setting is the directory where the SPDSCONV command is issued.
-a
converts all SPD Server 3.x compatible tables in the -d pathnamedirectory to SPD
Server 4.4 compatible tables.
Using SPDSCONV
61