Examples :: SAS® Scalable Performance Data Server 5.3: Administrator's Guide

Use spdsls to List All Components in a Domain

This sample command executes spdsls with the -l, -i, -o, and -s options to display owner and size information for component files in the domain /bigdisk/sas/data/public.

spdsls -l -i -o -s /bigdisk/sas/data/public

SAS Scalable Performance Data Server 5.3  Build(Thu Feb  4 21:05:05 EST 2016) -
Domain List Utility
Copyright (c) 1996-2011 SAS Institute Inc., Cary, NC, USA, All Rights Reserved

ANONYMOU     31196 /bigdisk/sas/data/public/cars.mdf.0.0.0.spds9
               648 /bigdisk/sas/data/public/cars.dpf._bigdisk_sas_data_public.0.1.spds9
ANONYMOU     30588 /bigdisk/sas/data/public/a.mdf.0.0.0.spds9
              8000 /bigdisk/sas/data/public/a.dpf._bigdisk_sas_data_public.0.1.spds9
ANONYMOU     31956 /bigdisk/sas/data/public/trx.mdf.0.0.0.spds9
          16774912 /bigdisk/sas/data/public/trx.dpf._bigdisk_sas_data_public.0.1.spds9
          16774912 /bigdisk/sas/data/public/trx.dpf._bigdisk_sas_data_public.1.1.spds9
          16774912 /bigdisk/sas/data/public/trx.dpf._bigdisk_sas_data_public.2.1.spds9
          16774912 /bigdisk/sas/data/public/trx.dpf._bigdisk_sas_data_public.3.1.spds9
          16774912 /bigdisk/sas/data/public/trx.dpf._bigdisk_sas_data_public.4.1.spds9
          16774912 /bigdisk/sas/data/public/trx.dpf._bigdisk_sas_data_public.5.1.spds9
          16774912 /bigdisk/sas/data/public/trx.dpf._bigdisk_sas_data_public.6.1.spds9
           9430190 /bigdisk/sas/data/public/trx.dpf._bigdisk_sas_data_public.7.1.spds9
ANONYMOU     47328 /bigdisk/sas/data/public/ida.mdf.0.0.0.spds9
                80 /bigdisk/sas/data/public/ida.dpf._bigdisk_sas_data_public.0.4.spds9
              8192 /bigdisk/sas/data/public/ida.idxx._bigdisk_sas_data_public.0.4.spds9
             24576 /bigdisk/sas/data/public/ida.hbxx._bigdisk_sas_data_public.0.4.spds9

Use spdsls to List Sizing Information and Table Information for a Domain

This spdsls command specifies the -info, -s, and -verbose options to get size and verbose descriptive information about tables in the domain /bigdisk/sas/data/public.

spdsls -info -s -verbose /bigdisk/sas/data/public

SAS Scalable Performance Data Server 5.3  Build(Thu Feb  4 21:15:09 EST 2016) -
Domain List Utility
Copyright (c) 1996-2011 SAS Institute Inc., Cary, NC, USA, All Rights Reserved

 DPF_SIZE IDX_SIZE MDF_SIZE NUMOBS OBSLEN SEGSIZE   PARTSIZE CMP ENC CLM TABLE
      648        0    31196      9     72    8192 1073740032  NO  NO  NO CARS
     8000        0    30588   1000      8    8192 1073741824  NO  NO  NO A
126854574        0    31956 489786    259    8192   16774912  NO  NO  NO TRX_RESULT_SEG1
       80    32768    47328     10      8    8192   16777216  NO  NO  NO IDA

Use spdsls to List Related Files for a Specified Table File

This spdsls command specifies the -c and -i options and specifies the full path to a data partition file to list component files that are related to the specified file. The full path to the data partition file is /users/tuser/testdata/tbl1.dpf._users_tuser_test.2.1.spds9. In the path, /users/tuser/testdata is the actual path of the component file, Tbl1 is the table name, and .dpf._users_tuser_test.2.1.spds9 is an extension that SPD Server generates to associate related component files. The file extension specifies the file type and the domain primary path, replacing the directory delimiters with underscores, among other things.

spdsls -c -i /users/tuser/testdata/tbl1.dpf._users_tuser_test.2.1.spds9

SAS Scalable Performance Data Server 5.3  Build(Thu Mar  3 10:07:09 EST 2016) -
Domain List Utility
Copyright (c) 1996-2011 SAS Institute Inc., Cary, NC, USA, All Rights Reserved

/users/tuser/test/tbl1.mdf.0.0.0.spds9
/users/tuser/testdata/tbl1.dpf._users_tuser_test.0.1.spds9
/users/tuser/testdata/tbl1.dpf._users_tuser_test.1.1.spds9
/users/tuser/testdata/tbl1.dpf._users_tuser_test.2.1.spds9
/users/tuser/testdata/tbl1.dpf._users_tuser_test.3.1.spds9
/users/tuser/test/tbl1.idxy._users_tuser_test.0.1.spds9
/users/tuser/test/tbl1.hbxy._users_tuser_test.0.1.spds9

Use spdsls to List Related Files for a Table File Whose Domain Primary Path Has an Underscore

This spdsls command specifies the -c and -i options and specifies the full path to a data partition file that has an underscore in one of the directory names in its domain’s primary path. The full path for this component file is /users/tuser/testdata/tbl2.dpf._users_tuser_test_tables.3.1.spds9. The primary path for the domain is /users/tuser/test_tables. When a directory in the primary path for a domain contains an underscore, escape the underscore in the component file as follows:

Enclose the full pathname in quotation marks.
Escape the underscore with a backslash in the file extension portion of the name.

In the example below, note the backslash in_test\_tables. near the end of the path.

spdsls -c -i
"/users/tuser/testdata/tbl2.dpf._users_tuser_test\_tables.3.1.spds9"

SAS Scalable Performance Data Server 5.3  Build(Thu Mar  3 10:07:09 EST 2016) -
Domain List Utility
Copyright (c) 1996-2011 SAS Institute Inc., Cary, NC, USA, All Rights Reserved

/users/tuser/test_tables/tbl2.mdf.0.0.0.spds9
/users/tuser/testdata/tbl2.dpf._users_tuser_test_tables.0.1.spds9
/users/tuser/testdata/tbl2.dpf._users_tuser_test_tables.1.1.spds9
/users/tuser/testdata/tbl2.dpf._users_tuser_test_tables.2.1.spds9
/users/tuser/testdata/tbl2.dpf._users_tuser_test_tables.3.1.spds9
/users/tuser/test_tables/tbl2.idxy._users_tuser_test_tables.0.1.spds9
/users/tuser/test_tables/tbl2.hbxy._users_tuser_test_tables.0.1.spds9