6. The user ANONYMOU performs a WHERE clause on the table BIGX. Show all of
the open tables in LIBNAME FOO:
showlibname FOO/data=_all_;
LIBREF(FOO):Dataset name=BIGX
LIBREF(FOO):ACL Owner=ANONYMOU
LIBREF(FOO):ACL Defaults(R,W,A,C)=(N,N,N,N)
LIBREF(FOO):WHERE clause read thread active
7. User ANONYMOU performs a WHERE clause on the table BIGX and displays
detailed information about the table BIGX:
showlibname FOO/data=bigx;
LIBREF(FOO):Dataset name=BIGX
LIBREF(FOO):ACL Owner=ANONYMOU
LIBREF(FOO):ACL Defaults(R,W,A,C)=(N,N,N,N)
LIBREF(FOO):WHERE clause read thread active
LIBREF(FOO):Type=
LIBREF(FOO):Label=
LIBREF(FOO):Number observations=5000000
LIBREF(FOO):Observation length=41
LIBREF(FOO):Wire blocksize=32718
LIBREF(FOO):Wire block factor=798
LIBREF(FOO):Data port number=58392
LIBREF(FOO):Active data socket=33
LIBREF(FOO):Metafile=/bigdisk/test/qabig1_dev/bigx.mdf.0.0.0.spds9
LIBREF(FOO):Metafile size=31
LIBREF(FOO):Datafile=
/spds02/test/qabig1_dev/bigx.dpf._bigdisk_test_qabig1_dev.0.1.spds9:
/spds03/test/qabig1_dev/bigx.dpf._bigdisk_test_qabig1_dev.1.1.spds9:
/spds04/test/qabig1_dev/bigx.dpf._bigdisk_test_qabig1_dev.2.1.spds9:
/spds01/test/qabig1_dev/bigx.dpf._bigdisk_test_qabig1_dev.3.1.spds9:
/spds02/test/qabig1_dev/bigx.dpf._bigdisk_test_qabig1_dev.4.1.spds9:
/spds03/test/qabig1_dev/bigx.dpf._bigdisk_test_qabig1_dev.5.1.spds9:
/spds04/test/qabig1_dev/bigx.dpf._bigdisk_test_qabig1_dev.6.1.spds9:
/spds01/test/qabig1_dev/bigx.dpf._bigdisk_test_qabig1_dev.7.1.spds9:
/spds02/test/qabig1_dev/bigx.dpf._bigdisk_test_qabig1_dev.8.1.spds9:
/spds03/test/qabig1_dev/bigx.dpf._bigdisk_test_qabig1_dev.9.1.spds9:
/spds04/test/qabig1_dev/bigx.dpf._bigdisk_test_qabig1_dev.10.1.spds9:
/spds01/test/qabig1_dev/bigx.dpf._bigdisk_test_qabig1_dev.11.1.spds9:
/spds02/test/qabig1_dev/bigx.dpf._bigdisk_test_qabig1_dev.12.1.spds9
LIBREF(FOO):Datafile size=200196
LIBREF(FOO):Number of Indexes=0
8. List all locking users for the server 'sunburn.6100':
list users/locking;
Users Currently Connected to the Record Level Proxy
SPDUserName Client Login Thread Id
----------------------------------------
ANONYMOU SASTEST 7
TEST SASTEST 8
9. Set the user to ANONYMOU and specify thread ID 7:
212
Chapter 16 • SPD Server Operator Interface Procedure (PROC SPDO)
Содержание Scalable Performance Data Server 4.5
Страница 1: ...SAS Scalable Performance Data Server 4 5 Administrator s Guide...
Страница 7: ...Part 1 Product Notes Chapter 1 SPD Server 4 5 Product Notes 3 1...
Страница 8: ...2...
Страница 12: ...6...
Страница 63: ...Part 3 Migration Chapter 5 SPD Server 3 x to SPD Server 4 5 Conversion Utility 59 57...
Страница 64: ...58...
Страница 70: ...64 Chapter 5 SPD Server 3 x to SPD Server 4 5 Conversion Utility...
Страница 72: ...66...
Страница 76: ...70 Chapter 6 Using the SPD Server Name Server to Manage Resources...
Страница 94: ...88 Chapter 7 Administering and Configuring SPD Server Using the SAS Management Console...
Страница 98: ...92 Chapter 8 SPD Server SQL Query Rewrite Facility...
Страница 116: ...110 Chapter 10 Configuring Disk Storage for SPD Server...
Страница 128: ...122 Chapter 11 Setting Up SPD Server Parameter Files...
Страница 154: ...148...
Страница 198: ...192 Chapter 14 ACL Security Overview...
Страница 212: ...206 Chapter 15 Managing SPD Server Passwords Users and Table ACLs...
Страница 214: ...208...
Страница 224: ...218 Chapter 16 SPD Server Operator Interface Procedure PROC SPDO...
Страница 236: ...230 Chapter 18 SPD Server Table List Utility Spdsls...
Страница 256: ...250 Chapter 19 SPD Server Backup and Restore Utilities...
Страница 264: ...258 Chapter 20 SPD Server Directory Cleanup Utility...
Страница 270: ......