Filter
Top Products
34 IBM Sterling Connect:Direct for i5/OS User’s Guide
pswd specifies the current security password. The security system on the SNODE can use this
parameter to validate the current security password (1–64 alphanumeric characters). This is optional
unless you have security set to require a password.
newpswd specifies the new security password and is used by the security system to change the current
security password to the new security password (1–64 alphanumeric characters).
TBUFND(n)
specifies the number of I/O buffers VSAM uses for transmitting data between virtual and auxiliary
storage. Valid values range from 1–510. The default is 2. Increasing this number generally improves
the I/O performance on the file but requires more memory.
TDBPARMS (dbid, dbsubid)
indicates that the Sterling Connect:Direct SQL SERVER is to process the I/O request against the
database identified by the subparameters of this keyword and defined by the SQL= parameter. The
DBPARMS parameter is used with the optional Sterling Connect:Direct for SQL feature. This
parameter is valid for z/OS nodes only. Only DB2 is supported.
To determine the values to code to access a given DB2 table or set of DB2 tables, consult your
database administrator.
dbid specifies the DB2 database ID of one to four bytes.
dbsubid specifies the DB2 database sub-ID of one to four bytes.
TDCB (modeldcb, blksize, den, dsorg, keylen, linct, lrecl, optcd, recfm, rkp, trtch)
overrides attributes of the source file. For existing source and destination files, DCB attributes are
determined from the operating system unless specified. For a new destination file, use the DCB
attributes of the source file to allocate the destination file unless you provide DCB information in the
operation.
modeldcb specifies a model data set control block (DSCB).
blksize specifies the length in bytes of the block. The minimum length is 18 bytes, and the maximum
length is 32,760 bytes.
den specifies the magnetic tape mode setting. The following table shows the values for the DEN
parameter for 7- and 9-track tapes. When coded together, the DEN and TRTCH values are used to
select a tape device for allocation by the remote node.
dsorg specifies the file organization. Valid file organizations are BDAM, ISAM, PO, PS, and VSAM.
keylen specifies the length of the keys used in a file. Maximum length is 255 bytes.
limct specifies the blocks or tracks searched to find a free block or available space.
lrecl specifies the record length in bytes.
Note: newpswd is not supported if the remote node is an i5/OS node.
Parameter values are case sensitive.
DEN 7-Track Tape 9-Track Tape
1 556 bpi --
2 800 bpi 800 bpi
3 -- 1600 bpi
4 -- 6250 bpi