[Table...]
The table(s) to list. (If no table is specified, all tables in the LIBNAME domain are
listed.)
Return Values
When spdsls exits, it generates a return value. If the spdsls return value is 0, the utility was
successful. If the spdsls return value is 1, the utility was unable to complete normally.
Spdsls Examples
Use Spdsls to List All Components in a Domain
You can use the - l option of the spdsls command to display index, owner, and size
information for component files in domain /bigdisk/sas/data/public as follows:
spdsls -l -i -o -s /bigdisk/sas/data/public
SAS Scalable Performance Data Server 4.5(TS M0) Build(Feb 26 2009, 11:51:36) - Domain List Utility
Copyright (c) 1996-2008 by SAS Institute Inc, Cary NC 27513 USA
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
You can use the -info option of the spdsls command 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 4.50(TS M0) Build(Feb 26 2009, 11:51:36) - Domain List Utility
Copyright (c) 1996-2008 by SAS Institute Inc, Cary NC 27513 USA
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
Spdsls Examples 229
