34IBM 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).

Note: newpswd is not supported if the remote node is an i5/OS node.

Parameter values are case sensitive.

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.

DEN

7-Track Tape

9-Track Tape

 

 

 

1

556 bpi

--

 

 

 

2

800 bpi

800 bpi

 

 

 

3

--

1600 bpi

 

 

 

4

--

6250 bpi

 

 

 

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.

Page 34
Image 34
IBM CDI5UG1107 manual TBUFNDn, Tdbparms dbid, dbsubid