![[Contents]](FIGURE/CONTENT.GIF)
Nonstop Database, HiRDB Version 9 Command Reference
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
This section presents examples of using the optimizing information collection utility.
In the examples, the authorization identifier used to connect to HiRDB is USERID, the table owner's authorization identifier is AUTHID, and the password is PASSWD.
This example collects optimization information for table T1:
pdgetcst -u USERID -a AUTHID -p PASSWD -t T1
This example collects optimization information for table T2 and saves the processing result in a file (/tmp/LOG):
pdgetcst -u USERID -a AUTHID -p PASSWD -t T2 -l /tmp/LOG
This example deletes optimization information for table T3 from the data dictionary table:
pdgetcst -u USERID -a AUTHID -p PASSWD -t T3 -d
This example registers the contents of the optimization information parameter file (/tmp/prmfile). The example registers optimization information for table T4 only:
pdgetcst -u USERID -a AUTHID -p PASSWD -t T4 -s /tmp/prmfile
This example saves optimization information for table T5 in an optimization information parameter file (/tmp/prmfile):
pdgetcst -u USERID -a AUTHID -p PASSWD -t T5 -e /tmp/prmfile
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.