HPNonStop Sysopts for File Copy
Syntax
SYSOPTS =(
[“SET TYPE [U | 0] | [R | 1] | [E | 2] | [K | 3]”]
[“SET CODE file-code”]
[“SET EXT (extent.size) | (pri.ext.size,sec.ext.size)”]
[“SET REC record-length”]
[“SET BLOCK data-block-length”]
[“SET [NO] COMPRESS”]
[“SET [NO] DCOMPRESS”]
[“SET [NO] ICOMPRESS”]
[“SET KEYLEN key-length”]
[“SET KEYOFF key-offset”]
[“SET ALTKEY
( [key-specifier]
[FILE key-file-number]
[KEYLEN key-length]
[KEYOFF key-offset ]
[[NO] NULL]
[[NO] UNIQUE]
[[NO] UPDATE]
)"]
[“SET ALTFILE key-file-number , filename”]
[“SET [NO] ALTCREATE”]
[“SET PART
( [sec.partition.num]
[\system.name.$volume]
[pri.ext.size]
[sec.ext.size]
[partial.key.value]
)"]
[“SET [NO] PARTONLY”]
[“SET ODDUNSTR”]
[“SET [NO] REFRESH”]
[“SET [NO] AUDIT”]
[“SET MAXEXTENTS maximum-extents”]
[“SET BUFFERSIZE unstructured-buffer-size”]
[“SET [NO] BUFFERED”]
[“SET [NO] AUDITCOMPRESS”]
[“SET [NO] VERIFIEDWRITES”]
[“SET [NO] SERIALWRITES”]
[“SET [NO] BLOCKIO”]
[“SET [NO] LARGEIO”]
[“SET FAST.LOAD Y”]
[“SET FAST.LOAD.PRI priority”]
[“SET FAST.LOAD.CPU cpu-number”]
[“SET FAST.LOAD.SORTED Y”]
[“SET XLATE ON | YES | OFF | NO | table-name"]
[“SET FORMAT 0|1|2”]
Description
specifies system operation parameters on the Copy statement. It is an alternative way of specifying file creation attributes. You can use HP NonStop File Utility Program (FUP) syntax to create HP NonStop-specific file options that are available through Sterling Sterling Connect:Direct syntax.
SYSOPTS are expressed as HP NonStop SET commands. There are two ways to express multiple SET command parameter:
- SET precedes each parameter. For example:
SYSOPTS=("SET parameter" "SET parameter" "SET parameter")
- SET precedes the first parameter, and commas separate subsequent
parameters. For example:
SYSOPTS=(“SET parameter, parameter, parameter”)
Enclose each sysopts string in double quotation marks except when copying from Microsoft Windows to HP NonStop. For copies from Microsoft Windows to HP NonStop, enclose each SET parameter in single quotation marks and enclose the entire SYSOPTS string in double quotation marks. For example:
SYSOPTS="’SET parameter’ ’SET parameter’ ’SET parameter’"
Do not use continuation marks in the SYSOPTS parameter. Type the text in a continuous string, with blanks separating each subparameter.
For details on listed FUP SET commands, refer to the appropriate HP NonStop manual. The following commands are Sterling Connect:Direct HP NonStop SET commands and are described only in the documentation set for Sterling Connect:Direct HP NonStop: SET [NO] BLOCKIO, SET [NO] LARGEIO, SET XLATE, SET SPOOLER, SET FAST.LOAD Y, SET FAST.LOAD.PRI, SET FAST.LOAD CPU, SET FAST.LOAD.SORTED Y, and SET SPOOLNUM.
SET parameter
commands define HP NonStop file attributes or special processing instructions for Sterling Connect:Direct HP NonStop. The SET commands follow in alphabetical order.
TYPE
specifies the file type. Values include:
- Use U or 0 for an unstructured file.
- Use R or 1 for a relative record file.
- Use E or 2 for an entry-sequenced file.
- Use K or 3 for a key-sequenced file.
CODE
specifies the file code. Values range from 0-65,535. Codes 100-999 are used exclusively by the system. The default is 0.
EXT
specifies the size of the extents. Valid values are as follows:
- extent.size specifies the extent size. The default is 10.
- pri.ext.size , sec.ext.size specifies the sizes of the primary and secondary extents.
- The default is 10.
REC
specifies the length of the records. For relative and entry-sequenced files, values range from 1-4072. For DP1 key-sequenced files, values range from 1-2035. For DP2 key-sequenced files, values range from 1-4062. The default is 80. REC is not valid if the destination file is unstructured.
BLOCK
specifies the data block length. Values range from 1-4096. The default is 1024.
[NO] COMPRESS
specifies whether keys will be compressed in both index and data blocks. In data blocks, the key offset must be 0, and the maximum record size will be reduced by 1 byte. The default is NO COMPRESS.
[NO] DCOMPRESS
specifies whether keys will be compressed in data blocks. The key offset must be 0, and the maximum record size will be reduced by 1 byte. The default is NO DCOMPRESS.
[NO] ICOMPRESS
specifies whether keys will be compressed in index blocks. The default is NO ICOMPRESS.
KEYLEN
specifies the primary-key length. Values range from 1-255. KEYLEN must be specified to create key-sequenced files.
KEYOFF
specifies the primary-key offset. Values range from 0-2034. The default is 0.
ALTKEY
specifies an alternate key. When using the SET ALTFILE or SET ALTKEY commands, the first key file number must be equal to zero (0). Valid values are as follows:
- key-specifier is a 2-byte value that uniquely identifies the alternate-key field.
- FILE specifies the key file number. Valid entries range from 0-255. The default is 0.
- KEYLEN specifies the length of the key. This parameter is required for creating a key-sequenced file.
- KEYOFF specifies the offset for the key. The default is 0.
- [NO] NULL specifies the null value set for the key. Valid entries are an ASCII character in quotation marks or an integer ranging from 0-255. The default is NO NULL.
- [NO] UNIQUE specifies whether the key is unique. The default is NO UNIQUE.
- [NO] UPDATE specifies whether automatic updating is set for the alternate-key file. The default is UPDATE.
ALTFILE
specifies the file number and file name of an alternate-key file. When using the SET ALTFILE or SET ALTKEY commands, the first key file number must be equal to zero (0).
- key-file-number is an integer from 0-255, inclusive.
- filename is the name of the alternate-key file for the key-file-number.
[NO] ALTCREATE
specifies whether automatic alternate-key files will be created. The default is ALTCREATE.
PART
specifies secondary partition specifications for partitioned files. Valid values are as follows:
- sec.partition.num specifies the name of the volume where this secondary partition will reside. Values range from 1-15.
- \system.name.$volume specifies the names of the system and volume to contain the partition.
- pri.ext.size specifies the primary extent size. The default is 1.
- sec.ext.size specifies the secondary extent size. The default is 1.
- partial.key.value specifies the lowest key value that can reside in this partition. This value is only for key-sequenced files. Valid entries include a string of characters enclosed in double quotation marks; a list of single characters, each enclosed in double quotation marks and separated by commas; and integers representing byte values, ranging from 0-255, and separated by commas.
[NO] PARTONLY
specifies whether subsequent file creations will create all partitions of a partitioned file or only a single partition. The default is NO PARTONLY.
ODDUNSTR
specifies that no upward rounding of an odd byte count will occur.
[NO] REFRESH
specifies whether the file label will be automatically copied to disk each time the file control block is marked as dirty. The default is NO REFRESH.
[NO] AUDIT
specifies whether the file will be audited by the Transaction Monitoring Facility (TMF). The default is NO AUDIT.
MAXEXTENTS
specifies the maximum number of extents for the file. Values range from 16-n, where n is the maximum value determined by the amount of free space remaining in the file label.
BUFFERSIZE
specifies the size in bytes of the internal buffer used when accessing an unstructured file. Values range from 1-4096. The default is 4096.
[NO] BUFFERED
specifies the mode of handling write requests. To buffer write requests into the disk-process cache, specify BUFFERED. The default for audited files is BUFFERED. The default for nonaudited files is NO BUFFERED.
[NO] AUDITCOMPRESS
specifies whether auditing mode is to compress or generate entire before/after messages. The default is NO AUDITCOMPRESS.
[NO] VERIFIEDWRITES
specifies whether disk writes will be verified. The default is NO VERIFIEDWRITES.
[NO] SERIALWRITES
specifies whether serial or parallel mirror writes will occur at file open. The default is NO SERIALWRITES, which will result in parallel mirror writes at file open.
[NO] BLOCKIO
specifies that Sterling Connect:Direct will perform its own block I/O for high performance. With BLOCKIO specified, data is transferred in blocks determined by the file block size, with a 4K-maximum block size. Specifying BLOCKIO or NO BLOCKIO in the SYSOPTS parameters overrides the setting in the initialization parameters file.
Improving I/O performance for entry-sequenced and relative files with alternate keys must be handled differently. The alternate key is not updated if BLOCKIO is activated unless a Run Task statement to run the FUP LOADALTFILE utility is added to the Process. FUP is then instructed to update the alternate keys for any alternate key files.
[NO] LARGEIO
specifies the transfer of data in blocks of 28K. Specifying LARGEIO or NO LARGEIO in the SYSOPTS parameters overrides the setting in the initialization parameters file.
Improving I/O performance for entry-sequenced and relative files with alternate keys must be handled differently. The alternate keys are not updated if LARGEIO is activated unless a Run Task statement to run the FUP LOADALTFILE utility is added to the Process. FUP would then be instructed to update the alternate keys for any alternate key files.
The default is 16, and the maximum value allowed is 978. For partitioned files, this value is always 16.
FAST.LOAD Y
indicates that the FASTLOAD facility be used. FASTLOAD is a function that can reduce disk I/O overhead and is used when the HP NonStop node is the destination. With FASTLOAD, the Sterling Connect:Direct HP NonStop system passes data through the SPI interface to FUP to load into a destination data file. The feature is particularly useful for key-sequenced files, although FASTLOAD is also supported for entry-sequenced and relative record files. Because edit files are unstructured, they cannot be loaded with the FASTLOAD feature.
FAST.LOAD.PRI <priority>
sets FASTLOAD and specifies the priority to run FUP. Valid values for priority range from 1-199. The default priority is the priority of the session manager (NDMSMGR). It is recommended to set this priority higher than that for NDMSMGR.
FAST.LOAD.CPU <cpu number>
sets FASTLOAD and specifies the CPU to use to run FUP. Valid values for the CPU number range from 0-15. The default CPU is the CPU of the session manager (NDMSMGR).
FAST.LOAD.SORTED Y
sets FASTLOAD and indicates to FUP that the data is sorted. This option (valid only for key-sequenced files) bypasses invocation of FASTSORT by FUP. The default is NO; that is, the data is not assumed to be sorted and FASTSORT is called.
XLATE
indicates whether the file being transferred will be converted from either ASCII to EBCDIC or EBCDIC to ASCII.
If XLATE ON or XLATE YES is specified or the file being copied is a spooler file or an edit file (unstructured file, code 101), Sterling Connect:Direct HP NonStop will check the XLFILE for a table named DEFAULT. If the DEFAULT table is not in XLFILE, then Sterling Connect:Direct HP NonStop will use the standard English language ASCII/EBCDIC table as defined by HP NonStop.
For spooler or edit files: If the file being copied is a spooler file or an edit file (unstructured file, code 101), XLATE does not need to be specified because these files are automatically translated.
- ON | YES specifies whether text will be converted from either ASCII to EBCDIC or EBCDIC to ASCII, depending upon the copy direction.
- OFF | NO ensures that text conversion does not occur during file transfer.
- table-name is a 1-8 character name of a user-defined translation table. See the IBM Sterling Connect:Direct HP NonStop Administration Guide for further details on user-defined translation tables.
SET FORMAT
Indicates what file format is used when the file is created. The FORMAT parameter applies only to HP NonStop files, when a file is received and it is created as a new file on a HP NonStop computer. It is not used in a non-HP NonStop data set definition, when sending a file from HP NonStop, or when overwriting an existing file on a HP NonStop computer.
- 0 directs the Enscribe File System to set the format based on the space requested when the file is created. This is the default value.
- 1 requests that a Format 1 file be created. If the space requested is greater than the space supported by a Format 1 file, a file creation error occurs.
- 2 requests that a Format 2 file be created.