SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 68 / 271

-j
creates a SAS job in the log directory for each SPD Server 3.x table conversion where
indexes are present. When run, the SAS job recreates the indexes on the SPD Server
4.4 table. The SAS job must be run after the SPDSCONV utility completes. Because
index recreation may be computation-intensive, users may want to schedule SAS index
recreation jobs as a SAS batch jobs for off-peak hours. The utility generates the name
of the SAS job file as follows:
TableName_v4ix.sas
where TableName is the name of the SPD Server 4.4-compatible table. The SAS job
file contains the SAS language statements necessary to recreate the indexes that the
SPD Server 3.x table used. The job file will need to be edited prior to execution to
ensure that the proper SPD Server 4.4 LIBNAME is used with the PROC DATASETS
statement.
-v
create verbose output for the conversion process.
SPDSCONV Utility Examples
Suppose you have the LIBNAME parameter file for your SPD Server installation:
libname=usmkt pathname=/mdat1/usmkt
roptions="datapath=('/dat11/usmkt'
'/dat12/usmkt'
'/dat13/usmkt'/
'/dat14/usmkt')
indexpath=('/ix11/usmkt'
'/ix12/usmkt')";
libname=sales pathname=/mdat1/sales
roptions="datapath=('/dat21/sales'
'/dat22/sales'
'/dat23/sales'/
'/dat24/sales')
indexpath=('/ix21/sales'
'/ix22/sales')";
Converting a Simple Table
Suppose you have an SPD Server 3.x table named CT010299 that belongs to the usmkt
domain, and you want to convert CT010299 to SPD Server 4.4 use. The table CT010299
has no indexes and you want a verbose output of the table conversion.
SPDSCONV -v -d /mdat1/usmkt CT010299
62
Chapter 5 • SPD Server 3.x to SPD Server 4.5 Conversion Utility