Unless a command line process is directed to a server, the process is executed locally and the settings in pstserv.cfg do not apply. Use the pstlocal configuration file to provide settings for these local processes. An example of pstlocal.cfg is in the /etc subdirectory to the PSTHOME directory.
Before using the command line utility, modify the following parameters to reflect your requirements, as applicable. In the following syntax, defaults are shown in bold text:
[ customerid [ n | 000000 ] ]
[ customername [ name | xxxxxxx ] ]
[ license [ license key | 000000 ] ]
tempdir directory
datadir directory
[ archivedir [ directory | datadir ] ]
[ archivediridx [ directory | archivedir ] ]
[ archivebroidx [ directory | archivedir ] ]
[ tracedays [ n | 5 ] ]
[ server ( name address port userid { password | ? } domain ) ]
pstdir ( name dbmstype dbmsver dbqual connectstring
{ dbname | * userid { password | ? } } )
dbalias ( pstdir name { connectstring | * [userid { password | ? }] })
[ loader ( { ( pstdir dbalias ) | (* dbmstype ) }
pathtoloaderexcptntblcid ]]
[ teraloader{ * | pstdir dbalias } dbmstype loader-program-full-path
{(mload) | (fastload) | (bteq) | NULL } rowcntgle n]
[ teradataconfig { * | pstdir dbalias } tdatasvr userid password ]
[ teratemptbloption { Never | When_Possible } ]
[ teratempdb dbname ]
[ teratptoption { Never | When_Possible } [ teratptsessmax n ] | [ teratptsessmin n ]
| [ teratptsleep n ] | [ teratpttenacity n ]
[ auditfacility { true | false}] [ Audit OptimDirName1 {enabled | disabled } ]
[ retention-days n] [ Audit RecordLimit n]
[ <FailureAction> { CONTINUE | STOP }]
[ allowlocktbls [ 0 | 1 ] ]
[ cmmaxshuffleretries [ n | 10 ] ]
[ codepage [ codepgenum | db2default ] ]
[ dbconnections [ 0 | 1 n | 1 maximum ] ]
[ formatnumerics [ 0 | 1 ] ]
[ maxcommitfreq [ n | 200 ] ]
[ maxextractrows [ n | 100000 ] ]
[ onlyidxsearch [ 0 | 1 ] ]
[ orausearraydelete [ 0 | 1 ] ]
[ DMLOprByRowID { never | dynamic | always | user-defined }
[ reviewdelafterarchive [ 0 | 1 ] ]
[ reportdir [ directory | unixtempdir ] ]
[ reportlevel [ 0 | n ] ]
[ centeraallowaltret [ 0 | 1 ] ]
[ centeraavail [ 0 | 1 ] ]
[ centeraretention [ none | default | interval | infinite ] ]
[ centeradays [ 0 | n ] ]
[ centerayears [ 0 | n ] ]
[ networkeravail [ 0 | 1 ] ]
[ tivoliavail [ 0 | 1 [ userid { password | ? } ] ] ]
[ rmfixedsegsize [ 0 | n ] ]
[ rmremsegsize [ 10 | n ] ]
[ scriptmaxlines [ 500 | n ] ]
[ scriptprefixout [ 0 | 1 ] ]
[ scriptshowfullcol [ 0 | 1 4 4 | 1 ln rn ] ]
[ scriptshowfulltbl [ 0 | 1 4 4 | 1 ln rn ] ]
[ scriptwarnmissing [ 0 | 1 ] ]
[ wormdeviceallowaltret { 0 | 1 } ]
[ wormdeviceretention { none | interval | maximum } ]
[ wormdevicedays [ 0 | n ]
[ wormdeviceyears [ 0 | n ]
[ sybaseunchain { active | inactive | defaultactive | defaultinactive } ]
[ uncommittedread { active | inactive | defaultactive |
defaultinactive } ]
customerid 000000
customername xxxxxxx
license 000000-000000-000000-000000-000000
tempdir ${PSTHOME}/temp
datadir ${PSTHOME}/data
archivedir ${PSTHOME}/archive
archivediridx ${PSTHOME}/archiveidx
archivebroidx ${PSTHOME}/archivebro
tracedays 5
Specify “?” as the password when a secure password is supplied in a password file. (See Securing the Configuration Files for more information.) To use OS Authentication for Oracle, specify a forward slash (/) for userid and do not provide a password.
server optuser 172.16.8.76 1024 rt password test.dom
Specify “?” as the password when a secure password is supplied in a password file. (See Securing the Configuration Files for more information.) To use OS Authentication for Oracle, specify a forward slash (/) for userid and do not specify a password.
pstdir ORA806 Oracle 8.0 OPTUSER DO806 * rt password
(Enter ‘*' if the database designated by the DB alias includes the Optim directory.)
Specify “?” as the password when a secure password is supplied in a password file. (See Securing the Configuration Files for more information.) To use OS Authentication for Oracle, specify a forward slash (/) for userid and do not specify a password.
dbalias ORACLE806 ORACLE806 DO806 rt password
path/loader/exec(mload)NULL NULL
path/loader/exec(mload)path/loader2/exec(fastload)NULL
path/loader/exec(mload)path/loader2/exec(fastload)path/loader3/exec(bteq)
teradataconfig pstdir dbalias tdatasvr userid password rowcntgle n
For
any DB alias:teradataconfig * tdatasvr userid password rowcntgle n
auditfacility true
allowlocktbls 1
codepage 871
Using a high retry value with columns that contain many duplicate values increases the processing time. For these columns, it might be best to use a retry value of zero.
cmmaxshuffleretries 10
dbconnections 1 maximum
formatnumerics 0
maxcommitfreq 200
maxextractrows 100000
onlyidxsearch 1
orausearraydelete 1
DMLOprByRowID never
reviewdelafterarchive 1
reportdir /users/RTuser/DDRIVE/OUTDIR/REPORTS
reportlevel 0
centeraallowaltret 1
centeraavail 0
centeraretention none
centeradays 250
centerayears 10
networkeravail 0
tivoliavail 1
rmfixedsegsize 0
rmremsegsize 10
scriptmaxlines 500
scriptprefixout 1
scriptshowfullcol 1 3 3
scriptshowfulltbl 1 6 6
scriptwarnmissing 1
wormdeviceallowaltret 1
wormdeviceretention none
wormdevicedays 60
wormdeviceyears 20
sybaseunchain active
uncommitedread inactive