File Utility Program (FUP) Reference Manual Abstract This manual describes the command syntax and error messages for the File Utility Program (FUP). Product Version T6553 D45, G08, H01, and H02. Supported Release Version Updates (RVUs) This publication supports J06.14 and all subsequent J-series RVUs, H06.25 and all subsequent H-series RVUs, G06.23 and all subsequent G-series RVUs, and D46.00 and all subsequent D-series RVUs, until otherwise indicated by its replacement publications.
Document History Part Number Product Version Published 523323-009 FUP D45, G08, and H01 July 2006 523323-010 FUP D45, G08, and H01 November 2006 523323-012 FUP D45, G08, and H01 October 2009 523323-013 FUP D45, G08, and H01 February 2011 523323-014 FUP D45, G08, and H01 August 2012 523323-015 T6553 D45, G08, H01, and H02 April 2014
Legal Notices Copyright 2006, 2014 Hewlett-Packard Development Company L.P. Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor's standard commercial license. The information contained herein is subject to change without notice.
File Utility Program (FUP) Reference Manual Glossary Index Examples Tables Legal Notices What’s New in This Manual ix Manual Information ix New and Changed Information ix About This Manual xv SPR Requirements for Increased Enscribe Limits for the H06.28/J06.17 Release xv Organization of This Manual xvi Additional Information xvii Notation Conventions xvii 1.
2.
2.
2.
2.
2.
3. FUP Messages Contents TRUST Guidelines 2-204 TRUST Examples 2-204 VOLS 2-205 VOLS Example 2-205 VOLUME 2-205 VOLUME Guidelines 2-206 VOLUME Examples 2-206 Commands Related to VOLUME 2-207 3. FUP Messages A. DEFINE Tables B. FUP Command Summary C. FUP Command Syntax Summary Glossary Index Examples Example 2-1. Example 2-2. Example 2-3. Example 2-4. Example 2-5. Example 2-6. Example 2-7. Example 2-8. Example 2-9. Example 2-10. Example 2-11.
Contents Table A-1. Table A-2. Table B-1. Table B-2. Table B-3. Table B-4.
What’s New in This Manual Manual Information File Utility Program (FUP) Reference Manual Abstract This manual describes the command syntax and error messages for the File Utility Program (FUP). Product Version T6553 D45, G08, H01, and H02. Supported Release Version Updates (RVUs) This publication supports J06.14 and all subsequent J-series RVUs, H06.25 and all subsequent H-series RVUs, G06.23 and all subsequent G-series RVUs, and D46.
What’s New in This Manual Changes to the 523323-015 manual: Updated the default value of primary extent and secondary extent in Unique features of Key-Sequenced File with Increased Limits on page 1-29.
What’s New in This Manual Changes to the 523323-014 manual: Added Aggregate EOF and FILE Label details for INFO DETAIL Listing Format on page 2-104. Updated INFO DETAIL Listing Format Examples on page 2-111. Updated Max num-records in key-seq-option on page 2-139. Udpated REVOKE (Super ID) Guidelines on page 2-170 and SECURE Guidelines on page 2-174. Updated block-length and record-length values in SET Parameters for All Structured Files on page 2-182.
What’s New in This Manual Changes to the 523323-013 manual: Changes to the 523323-013 manual: Updated these parameters for enhanced key-sequenced files information: ALTER Parameters on page 2-17. DUP[LICATE] Parameters on page 2-69. SET Parameters on page 2-184. SET Parameters for Files with Alternate-Key Fields on page 2-187. Updated these guidelines for enhanced key-sequenced files information: ALLOCATE Guidelines on page 2-7.
What’s New in This Manual Changes to the H06.08 Manual Updated the RECLAIM information of the RELOAD command on 2-157. Added the SOURCEDATE option to the RELOCATE command on page 2-161. Updated the RESET command with the DISPLAYALLNUM environment-option on page 2-165. Updated the SET Parameters for Unstructured Files information on page 2-189. Updated the SHOW command with the DISPLAYALLNUM environment-option on page 2-195. Changes to the H06.
What’s New in This Manual Changes to the H06.05 Manual Added missing file codes and the corresponding definitions in Table 2-2 on page 2-95. Added the TYPE variable and its description to the key column example on page 2-107. Added a note on page 2-107 that the key column TYPE and LENGHT is not displayed for SQL/MX objects .
About This Manual The File Utility Program (FUP) is a component of the standard RVU. This reference manual provides an overview of the FUP software and presents the detailed syntax for its commands. This manual will help you manage disk files, nondisk devices (printers, terminals, and tape drives), and processes (programs) running on an HP NonStop™ server. As a reader of this manual, you should be familiar with the Guardian file-system terminology.
Organization of This Manual About This Manual Products J-Series SPR H-Series SPR SQL/MP T9191J01^ACY T9191H01^ACX T9195J01^AES T9195H01^AER T9197J01^AEA T9197H01^ADZ TCP/IP FTP T9552H02^AET T9552H02^AET TNS/E COBOL Runtime Library T0357H01^AAO T0357H01^AAO Organization of This Manual Section or Appendix Title Description 1 FUP Overview Provides an overview of the FUP software.
Additional Information About This Manual Additional Information For more information about FUP and its associated components, see: Manual Description 5200 Optical Storage Facility (OSF) Reference Manual Describes the FUP commands that require special considerations when used with the 5200 OSF (for Dseries RVUs only) Enscribe Programmer’s Guide Provides descriptions of structured disk files and the file attributes specified in FUP commands.
General Syntax Notation About This Manual UPPERCASE LETTERS. Uppercase letters indicate keywords and reserved words. Type these items exactly as shown. Items not enclosed in brackets are required. For example: MAXATTACH lowercase italic letters. Lowercase italic letters indicate variable items that you supply. Items not enclosed in brackets are required. For example: file-name computer type. Computer type letters within text indicate C and Open System Services (OSS) keywords and reserved words.
Notation for Messages About This Manual … Ellipsis. An ellipsis immediately following a pair of brackets or braces indicates that you can repeat the enclosed sequence of syntax items any number of times. For example: M address [ , new-value ]… [ - ] {0|1|2|3|4|5|6|7|8|9}… An ellipsis immediately following a single syntax item indicates that you can repeat that syntax item any number of times. For example: "s-char…" Punctuation.
Notation for Messages About This Manual Nonitalic text. Nonitalic letters, numbers, and punctuation indicate text that is displayed or returned exactly as shown. For example: Backup Up. lowercase italic letters. Lowercase italic letters indicate variable items whose values are displayed or returned. For example: p-register process-name [ ] Brackets. Brackets enclose items that are sometimes, but not always, displayed.
Notation for Management Programming Interfaces About This Manual Notation for Management Programming Interfaces This list summarizes the notation conventions used in the boxed descriptions of programmatic commands, event messages, and error lists in this manual. UPPERCASE LETTERS. Uppercase letters indicate names from definition files. Type these names exactly as shown. For example: ZCOM-TKN-SUBJ-SERV lowercase letters.
About This Manual HP Encourages Your Comments File Utility Program (FUP) Reference Manual—523323-015 xxii
1 FUP Overview The File Utility Program (FUP) is a component of the standard RVU. FUP software is designed to help you manage disk files, nondisk devices (printers, terminals, and tape drives), and processes (running programs) on a NonStop system. You can use FUP to create, display, and duplicate files, load data into files, alter file characteristics, and purge files.
Starting a FUP Process FUP Overview Topic Page Starting a FUP Process 1-2 Using FUP Custom Files 1-4 Interrupting or Terminating a FUP Process 1-5 Entering a FUP Command 1-5 Specifying Files 1-8 Using DEFINEs With FUP 1-21 Handling Different Types of Files 1-22 Starting a FUP Process Access to FUP is available through the HP Tandem Advanced Command Language (TACL), the standard command interface in the Guardian environment.
Interactively FUP Overview Interactively Entering FUP commands within FUP (interactively) saves time if you are going to enter a series of commands.
Run Options FUP Overview Run Options The TACL environment includes a set of predefined commands—including the TACL RUN command. You must use a run option when you start a FUP process with a command file. The two run options that FUP uses most often are IN (for specifying an input file) and OUT (for an output file). Note. For more information about the TACL RUN command, see the TACL Reference Manual.
FUP Custom File Example FUP Overview By default, FUP does not echo the commands for either file. To start echoing, specify CONFIGURE ECHO OBEY in either file. If there are no existing custom files when FUP begins, default custom files are automatically created for your security. Custom files must be EDIT files. Errors encountered during the processing of a custom file could cause the FUP session to terminate.
Entering a FUP Command FUP Overview run-options are any of the available options for the TACL RUN command. They must be separated from each other by commas, and enclosed on the command line with slashes (/). Although each option is available when you run FUP from the TACL prompt, only one (the OUT run option) is also available within FUP. These run options are used most often with the FUP process: IN filename names a disk file, nondisk device, or process from which FUP reads commands.
FUP Command Guideline FUP Overview If you type FUP without command, you must terminate the FUP process using the EXIT command after you finish your FUP activity. FUP Command Guideline If you enter conflicting options, FUP scans the options and uses the last one entered: DUP A, B, OLD, NEW, SOURCEDATE, SAVEID The FUP process uses the NEW option (not the OLD option) and the SAVEID option (not the SOURCEDATE option).
Specifying Files FUP Overview Specifying Files FUP commands make it easy to: Create, display, and duplicate files Load data into files Alter file characteristics Purge files Before you use FUP to create or manage files, become familiar with the various file types and the methods used to specify them. Note. For more information on the different types of Enscribe-structured files, see the Enscribe Programmer’s Guide.
Fileset-list Parameter FUP Overview If a list file does not exist, FUP creates it as an EDIT file with a maximum record length of 132 characters. If a list file does exist, FUP appends output to it. If the list file is an unstructured disk file, each of its records is 132 characters long, and any partial lines are blank-filled to column 132. You can specify a SPOOL DEFINE for listfile. For a description of using a SPOOL DEFINE, see Using DEFINEs With FUP on page 1-21.
Wild-Card Option FUP Overview node is the name of a node in an Expand network. If you omit node, FUP uses the current default node: either the node that was in effect when you started FUP or the node you specified during the last FUP SYSTEM or VOLUME command. volume is the name of a volume (disk drive). If you omit volume, FUP uses the current default volume: either the volume that was in effect when you started FUP or the volume you specified during the last FUP VOLUME (or SYSTEM) command.
Qualified File Sets FUP Overview You cannot use more than eight characters (including wild-card characters) in any portion of the file name (volume, subvolume, or file identifier). The only valid use of the wild-card option in a destination file-set specification is a single asterisk (*) in the subvolume or file ID position. The DUP MYFILE, * command is valid, but the DUP MYFILE, MY* command is not.
Qualified File Sets FUP Overview The form for qualified-expr is: qualifier [ ,qualifier ] ... qualifier is: EXCLUDE fileset FROM CATALOG[S] catalog-list START file-id WHERE expression catalog-list is: [ \node.]$volume [.
Qualified File Sets FUP Overview file-attribute is: ALTKEY AUDITED BROKEN COLLATION CORRUPT CRASHOPEN ENSCRIBE ENTRYSEQUENCED FORMAT1|FORMAT2 INDEX [ SHORTHAND | PROTECTION ] VIEW KEYSEQUENCED LICENSED OPEN PROGID RELATIVE [ PRIMARY | SECONDARY ] PARTITION ROLLFORWARDNEEDED SAFEGUARD SQL SQLPROGRAM TABLE UNSTRUCTURED user-id is: group-name.user-name group-name.
Qualified File Sets FUP Overview time-value is: [ date ] time [ time ] date time is: hh:mm[:ss] date is: dd mmm yyyy mmm dd yyyy qualifier is qualifying criteria that you can specify to include files or objects in a file set. You can specify qualifiers in any order, but use each qualifier only once per file-set list. EXCLUDE fileset excludes the files you specify from a process. This specification is identical to the NOT option. You can include wild-card characters in this specification.
Qualified File Sets FUP Overview file-attribute is an additional parameter to the WHERE qualifier. You must use the complete parameter name in the command. Abbreviations are not permitted. ALTKEY adds, replaces, or alters an alternate-key specification. AUDITED specifies files that are audited by the HP NonStop Transaction Management Facility (TMF). BROKEN specifies files that are broken. The file needs media recovery because an I/O or consistency check failure occurred the last time it was open.
Qualified File Sets FUP Overview FORMAT2 describes files that are bigger than 2 GB minus 1 MB size limit. A Format 2 file can exceed the 2 GB minus 1 MB size limit. Note. The Format 1 files were created on systems running RVUs preceding D46.00 or G06.00. The Format 2 files were created on systems running D46.00, G06.00, or later RVUs. INDEX specifies SQL indexes. KEYSEQUENCED specifies key-sequenced files. LICENSED specifies LICENSED files.
Qualified File Sets FUP Overview SQLPROGRAM specifies SQL program files. TABLE specifies SQL tables. UNSTRUCTURED specifies unstructured disk files. [ SHORTHAND | PROTECTION ] VIEW specifies the shorthand SQL views, the protection SQL views, or all the SQL views (if neither shorthand nor protection are specified). OWNER = user-id specifies user identification for the form specified. timestamp-field helps select a file based on a specific time: CREATIONTIME selects a file based on when it was created.
Qualified File Sets FUP Overview time-value selects a file based on a specific time. The default is 00:00:00 (midnight) of the current date: [ date | time ] time | date time is: hh:mm[:ss] hh is the hour. mm is the minutes. ss is the seconds. date is: dd mmm yyyy mmm dd yyyy mmm is always the first three characters in the name of the month. yyyy must be four digits for the year.
Creating Files FUP Overview > (greater than) >= (greater than or equal to) <> (not equal to). Note. Keywords for qualified file sets must be specified completely. Abbreviations are not permitted. For example, use KEYSEQUENCED (not K), ENTRYSEQUENCED (not E), RELATIVE (not R), UNSTRUCTURED (not U), and FILECODE (not CODE). Note. Qualifiers appear immediately after the file set they are qualifying. This does not have to be the end of the FUP command.
Partitioning Files FUP Overview FUP -ALTER filename, PART (sec-partition-num, [\node.]$volume [ , pri-extent-size [ , sec-extent-size] ] To create a partitioned alternate-key sequenced file using the SET command: FUP -SET TYPE K -SET CODE 1001 -SET EXT (32,8) -SET REC 54 -SET BLOCK 4096 -SET KEYLEN 2 -SET ALTKEY ("LO", KEYOFF 42, KEYLEN 4) -SET ALTKEY ("VN", KEYOFF 46, KEYLEN 8) -SET ALTFILE (0,invalt) -SET PART (1, $ade001,5,5) -CREATE INV CREATED- $STORE1.SVOL1.INV CREATED- $STORE1.SVOL1.
Using DEFINEs With FUP FUP Overview 6. Load the new partitioned alternate-key sequence file: -LOADALTFILE 0, $VOL.subvol.partfilename Repeat these commands for each file you want to partition.
MAP DEFINEs FUP Overview SPOOL DEFINEs Example COPY ricecake,=MY_PRINTER MAP DEFINEs You can specify a MAP DEFINE wherever FUP permits a file name. It is sometimes easier to use a DEFINE name such as =CUSTOMERS than an actual file name such as \SF.$ACCNTS.CURRNT.CUSTNMES.
Moving Format 1 File Contents to Format 2 FUP Overview Table 1-1.
FUP Overview Inserting Partitions in Enscribe Key-Sequenced File You can create an equivalent Format 2 file for most Format 1 files. A Format 1 file with a record size within 56 bytes of the block size (48 if not key-sequenced) cannot have a Format 2 file with the same size created for it. You can use a larger block size for the Format 2 file unless the Format 1 file already has a 4096 byte blocksize.
Handling OSS Files FUP Overview 5. The file contains no more than 15 secondary partitions. Note. The primary partition can also be created with different extent sizes than the other partitions. Handling OSS Files FUP can only handle OSS files with the FUP INFO command. OSS files cannot be specified in any other FUP commands. Handling SQL/MP Files One of the relational database management systems that is used to define and manipulate industry-standard Structured Query Language (SQL) is SQL/MP.
Handling SQL/MP Files FUP Overview Table 1-2.
Handling SQL/MX Files FUP Overview Although most FUP commands apply only to the SQL/MP object program files, you can execute any of the commands directly from the SQL/MP Conversational Interface (SQLCI). If you use the FUP DUP command to duplicate an SQL/MP object program file, the SQL/MP SENSITIVE and SQL/MP VALID flags in the file label of the duplicate copy are turned off, and a warning message indicates that you must compile the file again with the SQL/MP compiler.
Handling SMF Files FUP Overview Table 1-3.
Unique Features of EKS Files FUP Overview Unique Features of EKS Files Enhanced Key-Sequenced Files (EKS) have the following unique features: The primary partition does not store user data but instead stores the file metadata. When creating an EKS file, the partial key of the first secondary partition must be explicitly set to all zeros.
FUP Overview Unique features of Key-Sequenced File with Increased Limits When creating a key-sequenced file with increased limits (EKS file with increased limits), the primary and secondary extent size of the primary partition must be greater than or equal to 140, otherwise, the default value of 140 is used.
2 FUP Commands This section describes each FUP command, including: A summary of the command function The command syntax, including its parameters and variables The format of the command output (if applicable) Guidelines for using the command Examples of using the command A list of related commands Before you use FUP commands, you should be familiar with the various Guardian file types and the different methods to specify them.
FUP Commands FUP Command Description Page (page 2 of 3) DISPLAYBITS Lets COPY, INFO, and SHOW display 8-bit characters 2-66 DUP[LICATE] Copies Enscribe disk files 2-67 EXIT Stops FUP and returns you to the command interpreter 2-75 FC Lets you modify and reexecute an existing command 2-76 FILENAMES Lists files that match specified wild-card options 2-78 FILES Lists all files associated with specified subvolumes 2-80 GIVE Changes the owner of a file 2-82 HELP Lists the syntax of all
FUP Commands FUP Command Description Page (page 3 of 3) RESET Restores file-creation attributes to the default settings 2-164 RESTART Restarts a RESTARTABLE DUP operation 2-166 REVOKE (Super ID) Revokes a license for a privileged program file or resets security attributes of files and programs 2-169 SECURE Sets or changes the security attributes of a file 2-172 SET Changes file-creation default attributes 2-177 SHOW Displays the current settings of the filecreation attributes 2-194 STA
! FUP Commands ! Executes an existing command again. ! [ -num | num | string | "quoted" ] -num executes a command that appears before the current command. For example, use !-3 to execute the third command prior to the current one. num is the number of a command line. For example, use !2 to execute the second command of the current FUP session. string is the first character or characters of a previous command. For example, use !DUP $ to execute the most recent DUP command that begins with a volume name.
Commands Related to ! FUP Commands Commands Related to ! COMMAND Function Page HISTORY Displays previous FUP commands 2-85 FC Modifies a previous command 2-76 ? Displays a previous FUP command 2-5 ? Displays a specific command. ? [ -num | num | string | "quoted" ] -num displays a command that appears before the current command. For example, use ?-3 to display the third command prior to the current one. num is the number of a command line.
Commands Related to ? FUP Commands Commands Related to ? COMMAND Function Page HISTORY Displays previous FUP commands 2-85 FC Modifies a previous FUP command 2-76 ! Reexecutes a previous FUP command 2-4 ALLOCATE Allocates file extents for a disk file. This command applies only to Enscribe files. ALLOCATE fileset-list , num-extents [ , PARTONLY ] fileset-list is a list of disk files for which extents are to be allocated. You can specify qualified-fileset for this fileset-list.
ALLOCATE Examples FUP Commands For nonpartitioned files and partitioned files that are not key sequenced, it is the total number of extents to be allocated to the file. An example is trying to allocate 12 additional extents to a nonpartitioned file that already has four extents allocated and trying to allocate 12 additional extents for the primary partition of a key-sequenced file that already has four extents allocated.
ALLOCATE Examples FUP Commands ENSCRIBE TYPE U FORMAT 1 EXT ( 2 PAGES, 2 PAGES ) MAXEXTENTS 16 BUFFERSIZE 4096 OWNER 8,44 SECURITY (RWEP): NUNU DATA MODIF: 14 April 2001, 08:59 CREATION DATE: 14 April 2001, 08:59 LAST OPEN: NEVER OPENED EOF 0 (0.0 % USED) FILE LABEL: 214 (5.2 % USED) EXTENTS ALLOCATED: 0 This display indicates it is a DP2 file because: The listing includes the MAXEXTENTS, BUFFERSIZE, CREATION DATE, and LAST OPEN attributes.
Commands Related to ALLOCATE FUP Commands Commands Related to ALLOCATE COMMAND Function Page DEALLOCATE Deallocates unused file extents 2-65 File Utility Program (FUP) Reference Manual—523323-015 2-9
ALLOW FUP Commands ALLOW Sets the number of errors and warnings that FUP allows before it stops executing FUP commands. If this number is exceeded, the current FUP command is aborted. If you reach the error or warning limit while entering FUP commands interactively, FUP terminates the current command, displays a warning message, displays its hyphen prompt, and continues to accept commands. If you reach the error or warning limit while FUP is executing commands from a command file, FUP stops executing.
ALTER Parameters for All File Types FUP Commands For files with alternate-key fields: ALTFILE ( key-file-number , filename ) ALTKEY ( key-specifier { , altkey-param }... ) DELALTFILE key-file-number DELALTKEY key-specifier For partitioned files: PART ( sec-partition-num , [ \node.
ALTER Parameters for All File Types FUP Commands CODE file-code alters the file code. Specify file-code as an integer from 0 through 65,535. The default file-code is zero. File codes 100 through 999 are reserved for use by HP. Note. For a list of reserved file codes, see Table 2-2, System File Code Definitions, on page 2-95. LOCKLENGTH generic-lock-key-length is the lock-key length. The generic lock-key length determines the grouping of records that share a single lock.
ALTER Parameters for All File Types FUP Commands NOPURGEUNTIL [ timestamp ] lets you change the expiration date of a file. timestamp is: [ date ] [ , ] [ time ] where date is specified as: { dd mmm yyyy | mmm dd yyyy } where dd (day) is an integer from 1 through 31, and mmm (month) is one of: JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC and yyyy (year) is a four-digit integer ranging from 1900 to 4000. If date is omitted, timestamp defaults to the current date.
ALTER Parameters for Files With Alternate-Key Fields FUP Commands [ NO ] SERIALWRITES sets the mode of writes to the mirror: serial or parallel. The default is NO SERIALWRITES. [ NO ] VERIFIEDWRITES sets the mode of file writes: verified or unverified. The default is NO VERIFIEDWRITES.
ALTER Parameters for Files With Alternate-Key Fields FUP Commands You can use any characters for key-specifier except zero. If you omit c1, then c1 is treated as a zero. Note. If you add a new key specifier that references an undefined key-file number, you must include the ALTFILE option to define the alternate-key file. altkey-param specifies attributes of the alternate-key file. FILE key-file-number sets the key-file number for key-specifier.
ALTER Parameters for Files With Alternate-Key Fields FUP Commands NO NULL | NULL null-value specifies whether to set a null value for key-specifier. If a value is specified, null-value must be an ASCII character in quotation marks (or an integer ranging from 0 through 255). The default is NO NULL. Note. For more information about null values, see the Enscribe Programmer’s Guide. [ NO ] UNIQUE specifies whether to set key-specifier as a unique key. The default is NO UNIQUE.
ALTER Parameters for Partitioned Files FUP Commands ALTER Parameters for Partitioned Files These alter-option parameters are available for partitioned files: PART ( sec-partition-num , [\node.]$volume [ , pri-extent-size [ , sec-extent-size ] ] ) PART alters secondary partition specifications for partitioned files. You can specify extent sizes if you are adding a new partition or if you are altering an existing partition of a key-sequenced file. You must specify each secondary partition separately.
ALTER Parameters for Partitioned Files FUP Commands do not specify a value, sec-extent-size defaults to the pri-extent-size value. You cannot define primary or secondary extents as zero pages when altering files. For partitioned unstructured files where one or more partitions reside on a 512 byte sector disk enclosure in an external disk enclosure 1, DP2 has additional restrictions. You must specify both the pri-extent-size and the secextent-size so that they can be explicitly divisible by 14.
ALTER Parameter for Unstructured Files FUP Commands The FUP process rounds the extent size up to the next full page. 0:maximum MEGABYTE[S] specifies extent sizes in million-byte units. Possible values are: Format 1 Format 2 0:134 MEGABYTE[S] 0:2147 MEGABYTE[S] The FUP process rounds the extent size up to the next full page. PARTONLY specifies that any changes you make with the ALTER command apply only to the indicated file partition.
ALTER Guidelines FUP Commands To alter a file, you must have both read and write access to it. Changing the AUDIT option for DP2 files also changes the default value of the BUFFERED attribute. If you specify NO AUDIT, the BUFFERED option and file label default is set to NO BUFFERED. If you specify AUDIT, the BUFFERED option is set ON. If you have explicitly set the BUFFERED attribute, that value remains unchanged.
ALTER Examples FUP Commands If the extent sizes of a secondary partition are altered, this warning message appears: USING SPECIFIED EXTENT SIZES: CONSISTENT PARTITIONS USER MUST ENSURE The ALTER command cannot handle SQL files that are not SQL object files. To do this, you must use SQLCI TABLE and SQLCI INDEX. The ALTER command returns error 197 (an SQL error has occurred) against SQL-compiled objects. All partitions of a file are created with the same format version.
Commands Related to ALTER FUP Commands To assign the alternate-key file MYFILE4 to MYFILE3 and give it key-file number two (ALTFILE 2 must already be a defined attribute of MYFILE3): -ALTER MYFILE3, ALTFILE (2 , MYFILE4) To delete the alternate key "ab" from MYFILE5: -ALTER MYFILE5, DELALTKEY "ab", DELALTFILE 0 Commands Related to ALTER COMMAND Function Page ALLOCATE Allocate extents for a file 2-6 GIVE Change ownership of a file 2-82 SECURE Change security, PROGID, or CLEARONPURGE attri
BUILDKEYRECORDS FUP Commands BUILDKEYRECORDS Generates the alternate-key records for specified key fields of a structured disk file and writes those records to a designated file. This command applies only to Enscribe files. Although the output of BUILDKEYRECORDS can be the actual destination alternatekey file, it is more efficient to use a LOADALTFILE command to load alternate-keys.
BUILDKEYRECORDS Guidelines FUP Commands If out-filename (the destination file) contains existing data, it is never overwritten during a BUILDKEYRECORDS operation. key-specifier-list names one or more alternate-key fields of the primary file whose corresponding alternate-key records are to be generated. key-specifier is a 2-byte value that identifies the alternate-key field.
BUILDKEYRECORDS Example FUP Commands BUILDKEYRECORDS honors any NULL specification defined for a key field. Alternate-key records are not generated for any fields that consist only of a null character. BUILDKEYRECORDS ignores NO UPDATE specifications. BUILDKEYRECORDS ignores UNIQUE specifications. Duplicate unique-key values are detected when the LOADALTFILE command loads the alternate-key file.
CHECKSUM FUP Commands CHECKSUM Recomputes the checksum value for blocks of data in disk files. Use this command when recovering from a software-detected checksum error. CHECKSUM fileset-list [ , PARTONLY ] fileset-list is a list of files whose checksum values are to be recomputed. fileset-list can include Enscribe files (structured or unstructured) and SQL files. You can specify qualified-fileset for fileset-list.
CHECKSUM Examples FUP Commands CHECKSUM Examples To recompute checksum values for all the files on volume $TEST1 (except secondary partitions of partitioned files): -CHECKSUM $TEST1.*.* If partitioned files exist on $TEST1, FUP skips the secondary partitions because the wild-card character (*) is specified for the files in fileset-list, and the PARTONLY option is not included in the command.
CONFIG[URE] FUP Commands CONFIG[URE] Customizes your FUP configuration information. You can use the CONFIG abbreviation for this command. The COPY, DUP[LICATE], LOAD, LOADALTFILE, and RELOAD configuration commands modify the defaults of their corresponding FUP commands. These modified defaults become applicable when the corresponding command is executed. The commands apply to other FUP commands as specified. CONFIG[URE] config-command [ config-params ]...
CONFIG[URE] FUP Commands DUP[LICATE] dup-option [, dup-option ]... specifies any of the DUP[LICATE] options (except SOURCE or TARGET file names); for example, PURGE, SOURCEDATE. By default, no DUP[LICATE] options are configured. For more information, see DUP[LICATE] on page 2-67. LOAD load-option [, load-option ]... specifies any LOAD option (except SOURCE or TARGET file names); for example, SLACK 20. By default, no LOAD options are configured. For more information, see LOAD on page 2-136.
CONFIG[URE] FUP Commands num SEVERE ERRORS sets both the severe and nonsevere error counts to num. num WARNINGS sets the number of warnings that FUP allows while executing FUP commands. ABENDS [ ON | OFF ] specifies whether FUP should terminate abnormally (ABEND) when it encounters an error and the allowed count for the error was exceeded. The default for ABENDS depends on: The default when FUP is not used interactively is ON.
CONFIG[URE] FUP Commands Table 2-1. Response to ALLOW ABENDS ON or OFF Type of Error ALLOW ABENDS OFF ALLOW ABENDS ON Severe error Severe error allow count is decremented. If allow count > 0, FUP continues with the current command on the next file in the file set. If allow count <= 0, the command fails. Severe error allow count is decremented. If allow count > 0, FUP continues with the current command on the next file in the file set. If allow count <= 0, FUP terminates abnormally.
CONFIG[URE] FUP Commands [ NO ] DISPLAYALLNUM specifies the way you want to display the key values. If DISPLAYALLNUM is not configured, the key values are displayed as characters if they are all printable, else they are displayed as a mixture of characters and numbers if there is any non-printable character. If DISPLAYALLNUM is configured, the key values are displayed as characters if they are all printable, else they are displayed as all numbers if there is any non-printable character.
CONFIG[URE] Guidelines FUP Commands the interval is 30 seconds for disk transfers and 10 seconds for optical transfers. The time you specify must be a positive number; 0 specifies the FUP defaults. Because each update to the RESTART file requires a synchronized update to the TARGET file, smaller values can slow down a DUP[LICATE] process. STATONLY suppresses the implicit INFO DETAIL display if INFO STAT is specified.
CONFIG[URE] Guidelines FUP Commands save configuration values, use the SHOW command. You can set configuration values from the FUPCSTM or FUPLOCL files or from a file with an OBEY command. FUP uses the current configuration options wherever applicable. You can set or change the configuration options in the FUPLOCL file or the FUPCSTM file or do so interactively with the CONFIGURE or RESET commands. If an option is specified more than once, FUP uses the last one specified.
CONFIG[URE] Examples FUP Commands than %177. When bitcount is 8, COPY displays the character for any byte with an octal value of %40 or greater. When bitcount is 7, the ALTKEY key specifier of INFO, DETAIL, and SHOW displays for any character with an octal value greater than %177. When bitcount is 8, the ALTKEY key specifier is displayed for all characters with an octal value greater than %40. You can switch between the 7-bit and 8-bit display modes during an interactive FUP session.
CONFIG[URE] Examples FUP Commands To explicitly override a configured option: -CONFIGURE DUP PURGE, SAVEID -DUP A, B, SOURCEDATE The SOURCEDATE option in the DUP[LICATE] command overrides the configured SAVEID option.
Commands Related to CONFIG[URE] FUP Commands To change the number of columns to 80: -CONFIGURE REPORTWIDTH 80 To declare a translation table name (my_encrypt) that is contained in the MYCRYPT.ENCRYPT file: -CONFIGURE XLATE my_encrypt TEXT IN mycrypt.encrypt The MYCRYPT.ENCRYPT file is expected to contain two translation tables (256 bytes each) in one record.
COPY: Copy Form FUP Commands COPY: Copy Form Makes a record-by-record copy from one file to another (the Copy Form of the COPY command) or displays the contents of a file (the Display Form). The COPY command functions apply to Enscribe files and SPOOLER files (code 129). Note. For information on displaying file contents with the COPY command, see COPY: Display Form on page 2-58.
COPY: Copy Form FUP Commands in-option is: BLOCKIN in-block-length [ NO ] COMPACT EBCDICIN RECIN in-record-length REELS num-reels [ NO ] REWINDIN SHARE SKIPIN num-eofs TRIM [ trim-character ] [ NO ] UNLOADIN VARIN out-option is: BLOCKOUT out-block-length DENSITYOUT density EBCDICOUT FOLD PAD [ pad-character ] RECOUT out-record-length [ NO ] REWINDOUT SKIPOUT num-eofs TAPEMODE mode [ NO ] UNLOADOUT VAROUT XLATE [ translation-table-name ] XLATEIN [ translation-table-name ] XLATEOUT [ translation-table-name
COPY: Copy Form FUP Commands out-filename is the name of the file that is the destination of the copy. This file can be a nondisk device, a process, an existing disk file, or a tape or spool DEFINE name. The file can also be any type of file that FUP handles, including structured files, EDIT files, or SPOOLER (file code 129) files. You cannot use wild-card characters in out-filename or specify a qualified-fileset for it. For EDIT files, the maximum number of output lines is 99,999,000.
COPY: Copy Form FUP Commands KEY { record-spec | key-value } specifies the primary-key value for the starting record of a disk file. FUP begins reading the input file at the record you name with KEY. Specify record-spec as an integer ranging from 0 through 4,294,967,295. For unstructured files, give the starting relative byte address for record-spec. For relative files, give the starting record number for record-spec. For entry-sequenced files, give the record address for record-spec.
COPY: Copy Form FUP Commands [ NO ] TITLE directs FUP to write a title line that includes the name of the file, the time of the COPY process, and the last modification time of the file. The title line is the first line of the OUT file, followed by a blank line. These two lines become part of the OUT file and are included in the RECORDS TRANSFERRED count. The default is NO TITLE. UNSTR[UCTURED] causes an unstructured open on a file.
COPY: Copy Form FUP Commands If BLOCKLEN does not match BLOCKIN, this error message appears: ERROR - TAPE DEFINE VALUE FOR BLOCKLEN CONFLICTS WITH BLOCKIN The value of in-block-length is set to the BLOCKLEN DEFINE value if you omit the BLOCKIN option and in-filename is a tape DEFINE with these attributes: LABELS set to labeled tape processing USE set to IN (or not specified) BLOCKLEN specified If these are not the attribute settings, FUP uses the in-record-length value for in-block-length and rea
COPY: Copy Form FUP Commands If you specify EBCDICIN and in-filename is a tape DEFINE, the EBCDIC attribute of the DEFINE must be ON or unspecified. FUP sets the EBCDIC attribute of the DEFINE to OFF for the life of the FUP command. If you specify EBCDICIN, FUP translates the data. If you omit EBCDICIN (but a tape DEFINE is set to request translation), labeled tape processing performs the translation. RECIN in-record-length specifies the maximum number of bytes in an input record.
COPY: Copy Form FUP Commands REELS num-reels indicates the use of multiple reels and sets the number of reels that make up in-filename (for unlabeled magnetic tape only). You cannot specify this option if in-filename is a tape DEFINE with LABELS set for labeled tape processing. You must use the appropriate tape DEFINE attributes to process multi-reel labeled tapes. Note. For D-series and G-series RVUs, see the Guardian User’s Guide for more information.
COPY: Copy Form FUP Commands SKIPIN num-eofs moves the tape past num-eofs end-of-file (EOF) marks before the data transfer begins (for magnetic tape only). You cannot specify this option if in-filename is a tape DEFINE with LABELS set for labeled tape processing. You must use the appropriate tape DEFINE attribute to skip files on a labeled tape. Note. For more information, see the Guardian User’s Guide .
COPY: Copy Form FUP Commands Each variable-length, blocked record begins with a word that contains the length of the record, and the read count equals the value of that length indicator. You cannot use the TRIM option with VARIN, and this option works only with tapes written by FUP. out-option controls the handling of the output file. out-option is not normally used with structured disk files. BLOCKOUT out-block-length sets the number of bytes in an output block.
COPY: Copy Form FUP Commands USE set to OUT (or not specified) BLOCKLEN specified If these are not the attribute settings, FUP uses the write-count value for out-block-length and writes each output record in a separate physical operation. Record blocking does not occur. DENSITYOUT density indicates the recording density for the output tape file. This option applies only to tape drives that support multiple densities.
COPY: Copy Form FUP Commands If you include the EBCDICOUT option, FUP performs the translation. If you omit the EBCDICOUT option and a tape DEFINE is set so that translation is requested, the translation is performed by labeled tape processing. Note. A warning occurs if you specify EBCDICOUT and an XLATE option (and FUP uses the XLATE option). For more information about the XLATE option, see CONFIG[URE] on page 2-28.
COPY: Copy Form FUP Commands If you specify the RECOUT option and out-filename is a tape DEFINE with these attributes, you must not specify the RECLEN attribute of the DEFINE, or RECLEN must match out-record-length: LABELS set for labeled tape processing USE set to OUT (or not specified) If the RECLEN attribute is unspecified, it is set to out-record-length for the life of the FUP command.
COPY: Copy Form FUP Commands If you include the SKIPOUT option (and out-filename is a tape DEFINE), FUP displays this error message: ERROR - SKIPOUT PARAMETER NOT ALLOWED FOR LABELED TAPES Specify num-eofs as an integer ranging from –255 through 255. If you specify a positive value, the tape is forwarded past num-eofs EOF marks and positioned immediately after the last EOF mark passed.
COPY: Copy Form FUP Commands The write count and the record-length word of a record are equal—even if the record is truncated. Truncation occurs if the record is either longer than RECOUT or longer than BLOCKOUT subtracted by two. (The record-length word requires two extra bytes.) If the next record with its record-length word does not fit in the current block, VAROUT terminates the current block and begins a new block because the blocks cannot be spanned.
COPY: Copy Form Guidelines FUP Commands table. Every character in the IN file is translated using the specified table before it is written to the OUT file. Note. A warning occurs if you specify EBCDICOUT and an XLATE option (and FUP uses the XLATE option). For more information on the XLATE option, see CONFIG[URE] on page 2-28. display-option specifies the display format of the file for the Display Form of the COPY command. Note.
COPY: Copy Form Guidelines FUP Commands A COBOL program can read multireel tape files created by FUP COPY. Note. For more information, see these manuals: COBOL85 for NonStop(TM) Himalaya Systems Manual (D-series RVUs) COBOL85 for NonStop Systems Manual (G-series RVUs) COBOL Manual for TNS/E Programs (H-series RVUs) COBOL Manual for TNS and TNS/R Programs (H-Series RVUs) FUP COPY uses sequential block buffering when accessing in-filename. All record locks are ignored. Note.
FUP Commands COPY: Copy Form Guidelines The [NO] COMPACT option affects copy operations for relative IN files only. If you specify NO COMPACT when you are copying another type of file, this message appears: WARNING - COMPACT OPTION IGNORED FOR NONRELATIVE FILES If the AUDIT option is set for out-filename, the copy request fails with filesystem error 75 (requesting process has no current process transaction identifier).
COPY: Copy Form Examples FUP Commands COPY command can include in-filename and destination-filename as an enhanced key-sequenced file or a legacy key-sequenced file. If the destination-filename is a legacy key-sequenced file and infilename is a legacy key-sequenced file, then the data contained in the source file starting from primary partition will be copied into the destination file starting from the primary partition.
Commands Related to Copy: Copy Form FUP Commands To copy a series of files onto magnetic tape, use a FUP COPY command for each file and include the NO REWINDOUT option in each command except the last one: -COPY FILE1, $TAPE, NO REWINDOUT -COPY FILE2, $TAPE, NO REWINDOUT -COPY FILE3, $TAPE To return the files copied in the previous example from tape to disk: -COPY $TAPE, NFILE1, NO REWINDIN -COPY $TAPE, NFILE2, NO REWINDIN -COPY $TAPE, NFILE3 To copy two records from the key-sequenced FILEX to F
COPY: Display Form FUP Commands COPY: Display Form Displays the contents of a file (the Display Form of the COPY command) or makes a record-by-record copy from one file to another (the Copy Form). The COPY command functions apply to Enscribe files and SPOOLER files (code 129). This subsection describes the Display Form. Note. For information about making a record-by-record copy from one file to another with the COPY command, see COPY: Copy Form on page 2-38.
Copy: Display Form Listing Format FUP Commands BYTE displays in byte and ASCII format. The two bytes of each word are converted separately. If you do not specify BYTE, a word is treated as a single value and converted accordingly. If you specify BYTE (but not OCTAL, DECIMAL, or HEX), the display is in byte-octal format. ASCII or A displays in ASCII format. This option is ignored when combined with any preceding display-option. NO HEAD omits the heading preceding each record displayed.
Copy: Display Form Examples FUP Commands mm/dd/yy is the current date (displayed for the first record only). hh:mm is the current time (displayed for the first record only). offset is the offset from the beginning of the word 0 record. word 0...word n is a block of n contiguous words of filename. If out-record-length is less than 100, n = 7. If out-record-length is ranging from 100 through 120, n = 9; otherwise, n = 11. ASCII-format is the ASCII representation of the line to the left.
CREATE FUP Commands CREATE Creates a disk file with the current file-creation attributes defined by the SET command. To override the current file-creation attributes defined by the SET command, include create-param in the CREATE command. CREATE filename [ , create-param ] ... filename is the name of the file to be created. A partial file name is expanded using the current default names for system, volume, and subvolume.
CREATE Guidelines FUP Commands If FUP terminates because an error occurs while CREATE is automatically creating alternate-key files, the primary-key file and any alternate-key files already created are not deleted. You must purge these files manually. CREATE cannot create SQL files that are not SQL object files. You must use SQLCI CREATE instead. To override the default SMF assignment on a CREATE command of a file on a logical volume, use the CREATE command with the PHYSVOL option.
CREATE Examples FUP Commands CREATE Examples To create a non-partitioned unstructured file on a disk drive in a disk drive enclosure: -SET TYPE U -SET EXT (2,20) -SET REC 80 -CREATE TEST Note. DP will round the extent sizes up to multiples of 14 so the actual extent information will be ext (14,28), not ext (2,20) as specified. To create a partitioned unstructured file where one or more partitions reside on a disk drive in a disk drive enclosure.
CREATE Examples FUP Commands 3. Add the partitioning specifics: -SET PART (1,$VOLnn, primary EXT, secondary EXT, "PR altkeyvalue1" -SET PART (2,$VOLnn, primary EXT, secondary EXT, "PR altkeyvalue2" 4. Purge the existing alternate key file: -PURGE $VOLnn.Subvol.first-alternate-keyfile 5. Create the new partitioned alternate key file: -CREATE $VOLnn.Subvol.partitioned-alternate-keyfile 6. Load the newly created partitioned alternate key file: -LOADALTFILE 0,$VOL.Subvol.
Commands Related to CREATE FUP Commands Commands Related to CREATE COMMAND Function Page ALTER Modifies attributes of a file 2-10 RESET Resets default file attributes or CONFIG[URE] options 2-164 SET Sets default file attributes 2-177 SHOW Displays default file attributes or CONFIG[URE] options 2-194 DEALLOCATE Deallocates any file extents beyond the one that includes the end-of-file (EOF) address of the specified disk files. This command applies only to Enscribe files.
DEALLOCATE Example FUP Commands To deallocate volume directory extents, you must use this file name syntax for fileset-list: $volume.SYS00.DIRECTRY For enhanced key-sequenced files, the DEALLOCATE command deallocates unused extents of secondary partitions but the extents of the primary partition remain unchanged.
DUP[LICATE] FUP Commands DUP[LICATE] Copies disk files. This command applies only to Enscribe files. You need to understand when to use the COPY, DUP[LICATE], and LOAD commands: COPY To change file attributes or copy files to or from nondisk devices DUP[LICATE] To create identical copies of disk files LOAD To create a structured disk file from scratch (much faster than COPY) DUP[LICATE] from-fileset-list , to-fileset [ , RESTARTABLE [ restart-filename ] ] [ , rename-option ] ...
DUP[LICATE] FUP Commands If you use a wild-card character or qualified-fileset option to specify the name of a file in from-fileset-list, you must specify the file name part of to-fileset with the (*) wild-card character. If you specify the file name part of to-fileset as an asterisk (*), each output file is given the disk file name of its corresponding input file.
DUP[LICATE] FUP Commands rename-option renames the secondary-partition volume and alternate-key files when they are duplicated. FUP creates the destination file with new names for the secondarypartition volumes and alternate-key files. If you do not specify rename-option, FUP creates alternate-key files and partitions with names specified by the primary partition. This option applies only when FUP creates the destination file. It does not apply if the OLD option is enabled.
DUP[LICATE] FUP Commands KEEP does not duplicate any files that exist in both to-fileset and from-fileset-list. If a file specified in to-fileset already exists, the corresponding file in from-fileset-list is not duplicated. FUP lists the names of the files that are not duplicated. Checking is by name only. No file attributes are checked. FUP uses only one of these options: KEEP, NEW, OLD, or PURGE. If more than one is specified, FUP uses the last one specified.
DUP[LICATE] FUP Commands If you omit PARTONLY and define a primary partition in from-fileset-list, FUP duplicates the entire partitioned file (all partitions). If PARTONLY is not specified, it is an error to specify a secondary partition in from-fileset. PHYSVOL [ physvol ] specifies the physical volume where a file should be created. This option overrides any SMF parameters after the CREATE command creates a file on the virtual disk.
DUP[LICATE] General Guidelines FUP Commands DUP[LICATE] General Guidelines The DUP command opens the file to be duplicated with read-only access and with protected exclusion mode. Note. For information about file access and exclusion modes, see the Enscribe Programmer’s Guide. The FUP DUP[LICATE] command cannot duplicate SQL files except for SQL object files. You must use SQLCI DUP instead.
DUP[LICATE] Guidelines for Safeguard Files FUP Commands Transfer the CLEARONPURGE attribute (for more information, see SECURE on page 2-172) to a local or remote target file. The target file does not need to be on the node where FUP is running. To restore the CLEARONPURGE attribute, use a SECURE command.
DUP[LICATE] Examples FUP Commands If you duplicate a Safeguard protected file, the new file is not Safeguard protected unless volume or subvolume protection exists on the target subvolume. To restore or set Safeguard protection, use the Safeguard command interpreter (SAFECOM).
Commands Related to DUP[LICATE] FUP Commands must include the PART option. To duplicate the secondary partitions, use these commands (on separate command lines): -DUP $VOL3.SUB1.PARTFILE, \TWO.$VOL2.*.*, PARTONLY -ALTER \TWO.$VOL1.SUB1.PARTFILE, PART (1, \TWO.$VOL2) The DUP command duplicates only the secondary partition of PARTFILE (to $VOL2 on node \TWO) because the PARTONLY option is specified.
EXIT Example FUP Commands The FUP process terminates when FUP reads the end-of-file (EOF) mark of the input file that you specified in your command to run FUP. You do not have to end a FUP command file with an EXIT command because of the EOF mark. Simultaneously pressing the CTRL and Y keys at the terminal is the same as an EOF.
FC Guidelines FUP Commands R replacement-string replaces characters in the command line (beginning with the character above the R) with replacement-string. replacement-string is terminated by // or Return. I insertion-string inserts insertion-string into the command line in front of the character above the I. insertion-string is terminated by // or Return. D deletes the character above the D. Repeat to delete more characters.
Commands Related to FC FUP Commands Spaces typed after the I or R subcommand are part of the text to insert or replace. To make more than one change per line by ending the text string with two slashes (//) and spacing over: -FC -DUP FILE1, FILE2 . i3// r14 -DUP FILE13, FILE14 .
Commands Related to FILENAMES FUP Commands $BASE.
FILES FUP Commands FILES Displays all file names associated with one or more subvolumes. The FILES command is similar to the FILENAMES command, which displays subsets of files within a subvolume. FILES [ / OUT listfile / ] [ subvolset ] subvolset: [[[ \node.]$volume.] subvolume | * ] OUT listfile names an existing file or device to receive the output of the FILES command. You can use either a standard file name or a spool DEFINE name as the OUT listfile for the FILES command.
FILES Guidelines FUP Commands FILES Guidelines If you request information for all the subvolumes on a volume, FUP displays the file names in each subvolume (by object name within the subvolume name). The FILES command applies to all types of Enscribe and SQL files. File names are displayed for unstructured and structured Enscribe files and for all types of SQL files (tables, indexes, views, catalog tables, the indexes on SQL catalog tables, and SQL object program files).
GIVE FUP Commands GIVE Changes the owner of a file. This command applies only to Enscribe files. Only the current owner of the file (or the super ID, (255,255)) can execute the GIVE command for a file. GIVE fileset-list , {groupnum , usernum | groupname.username } [ , PARTONLY ] fileset-list is a list of files whose ownership is to be given to another user. You can use wildcard characters, and you can specify qualified-fileset for fileset-list.
GIVE Examples FUP Commands User other than owner in the same group can alter the ownership of a Safeguard protected file if the OWNERSHIP (O) permission is given to the user while adding to safeguard protection using SAFECOM. FUP returns the error message "SAFEGUARD IS NOT LICENSED", if the safeguard object is not licensed.
HELP FUP Commands HELP Lists the syntax of the FUP commands. HELP [ / OUT listfile / ] [ command | ALL [, SYNTAX ] | NEWS ] OUT listfile names a file to receive the output of the HELP command. If you omit this option, the output is sent to the OUT listfile that is enabled for the current FUP session—usually your home terminal. You can use either a standard file name or a spool DEFINE name as the OUT listfile for the HELP command. If listfile is an existing file, FUP appends the output to the file. Note.
HELP Examples FUP Commands HELP Examples To display the names of all FUP commands, enter HELP ALL (or HELP): -HELP ALL To write the syntax for all the FUP commands to the file MYHELP: -HELP /OUT MYHELP/ ALL,SYNTAX To display the syntax of the FUP CREATE command: -HELP CREATE CREATE filename [ , create param ] ... create param -- see SET To display the syntax of the FUP PURGE command: -HELP PUR PURGE { [ ! ] fileset [, fileset ] ... [ ! ] } { [ ! ] ( fileset [, fileset ] ...
HISTORY Example FUP Commands The HISTORY command buffer can hold from 50 through 200 commands, depending on the size of the commands. After the buffer becomes full, the oldest command is discarded, as necessary, for each new command. Discarded commands are not available from the HISTORY command, the ! command, or the ? command.
INFO FUP Commands FUP long INFO for a TABLE or INDEX displays the information about a single partition as all the partitions contain the same information in the long form. INFO [ [ [ [ [ / , , , , OUT listfile / ] [ fileset-list / ansiname-list ] DETAIL ] EXTENTS ] STAT[ISTICS] [ , PARTONLY | PARTIAL num ] ] USER { groupnum , usernum } { groupname.
INFO FUP Commands and delimit each ansiname. The ANSI names syntax is in accordance with Unified Syntax Proposal.
INFO FUP Commands EXTENTS provides a listing of extent allocation by file (except SQL/MP and SQL/MX views). If specified, views are skipped. STAT[ISTICS] provides all the DETAIL information and statistical data on blocks and records for Enscribe-structured files, SQL/MP and SQL/MX tables, and indexes. Statistics information does not appear for unstructured Enscribe files, SQL/MP and SQL/MX program files, views, or shadow labels. Note.
INFO Guidelines FUP Commands AGGREGATE EOF aggregate eof(percent-used % USED) for the disk objects, aggregate eof is the end-of-file value of the file. For a partitioned file where the entire file has been opened, the end-of-file value of the entire file is returned. If all the extents were allocated, the percent-used parameter is the amount of file space currently used. When a file is created with PARTONLY option, the aggregate EOF displays the following warning: WARNING - $FC1.FUPILKS0.
INFO Guidelines FUP Commands FUP INFO shows SMF information about files only in the DETAIL option. If the file is on a virtual disk, FUP displays the physical volume name of the file in a DETAIL display. If you omit the DETAIL option, FUP displays the standard information for SMF files on virtual disks. FUP does not display SMF files by physical file name unless the file name explicitly includes one of the reserved SMF subvolume names ($physvol.ZYS*.* or $physvol.ZYT*.*).
INFO Listing Format FUP Commands FUP INFO command with DETAIL option displays aggregate EOF of all the partitions of Format 1 or Format 2 key-sequenced file. FUP INFO command with detail option does not display the locklength value when LOCKLENGTH is equal to KEYLEN. INFO Listing Format Example 2-2 shows the format that the FUP INFO command (with no options) uses to display file information. Example 2-2. INFO Listing Format CODE EOF LAST MODIF OWNER RWEP TYPE REC BL [\node.] $volume.
INFO Listing Format FUP Commands code is the file code. Software development has reserved file codes 100 through 999 for its own use. For a list of the file codes that are currently reserved, see Table 2-2, System File Code Definitions, on page 2-95. CODE 0 (zero) is the default code for user-created files. It appears as a blank in the CODE column of the FUP INFO listing. OSS designates OSS files. Letters and symbols that appear after the code indicate: A TMF audits the file. L The file is licensed.
INFO Listing Format FUP Commands Values for rwep are: **** Safeguard protected (file mode only) - Local super ID only O Owner only (local) G Member of owner's group (local) A Any user (local) U Member of owner's user class—owner only (local or remote) C Member of owner's community—member of owner's group (local or remote) N Any user (local or remote) *SQL SQL/MX object Note. For an OSS file, a 10-character OSS security vector appears in the RWEP column.
INFO Listing Format FUP Commands rec is the logical record length of the Enscribe file in bytes. For unstructured files, this field is blank. bl is the block length of the Enscribe file in kilobytes. For unstructured files, this field is blank. Software development has reserved file codes, 47 through 22222 for its own use. Table 2-2 lists these codes and their corresponding definitions. Table 2-2.
INFO Listing Format FUP Commands Table 2-2. System File Code Definitions (page 2 of 9) File Code Definition 134 TMF audit-trail file 141 Compressed dump file 142 CPU dump file 143 143 SIERRA cpu dump file 144 Processor dump file (up to and including G06.15) 145 Processor dump file using RCVDUMP (as of G06.16) 146 Processor dump file using TFDS (as of G06.
INFO Listing Format FUP Commands Table 2-2.
INFO Listing Format FUP Commands Table 2-2.
INFO Listing Format FUP Commands Table 2-2.
INFO Listing Format FUP Commands Table 2-2.
INFO Listing Format FUP Commands Table 2-2.
INFO Listing Format FUP Commands Table 2-2. System File Code Definitions (page 8 of 9) File Code Definition 882 SLSA Downloadable library file 888 Enform compiled query file 889 MMS Journal 890 ISDN Configuration File.
INFO Listing Format Example FUP Commands Table 2-2.
INFO DETAIL Listing Format FUP Commands The four asterisks in the RWEP field indicate that the file NEWFILE is Safeguard protected. Example 2-4. Short INFO for SQL/MX Table Using ANSI Names FUP INFO 'TABLE CAT_ANSINAME01.SCH_ANSINAME01.TAB1 PARTITION (PART1,PART2)' CODE EOF LAST MODIF OWNER RWEP TYPE REC BL $DATA05.ZSDHKPKT CGJC4500 550A+ 12288 27Oct2005 23:34 -1 *SQL PK Ta 12 4 $DATA1.ZSDHKPKT J1C73500 550A+ 12288 17Oct2005 7:32 -1 *SQL XPK Ta 12 4 Example 2-5.
FUP Commands INFO DETAIL Listing Format Example 2-6.
INFO DETAIL Listing Format FUP Commands 1718192021- AGGREGATE EOF aggregate eof(percent-used % USED) FILE LABEL: num-bytes(percent-used % USED) EXTENTS ALLOCATED: num-ext INDEX LEVELS: num-index-levels PARTITION ARRAY {EXTENDED | STANDARD | FORMAT2ENABLED} Note. If you do not have access privileges to a file and you issue the INFO DETAIL command, UNAVAILABLE is displayed as the pathname.
INFO DETAIL Listing Format FUP Commands 6. CODE is the file code. File codes are displayed for SQL tables and indexes and for Enscribe files. The default file code of 0 is not displayed. File codes ranging from 100 through 999 refer to specific types of files and are reserved by HP. For a description of these codes, see Table 2-2, System File Code Definitions, on page 2-95. Letters that follow the file code have specific meanings: A TMF audits the file. L The file is licensed by the super ID (255,255).
INFO DETAIL Listing Format FUP Commands LOCKLENGTH is the number of bytes of the primary key used for locking. DCOMPRESS indicates keys in data blocks of the file are compressed. ICOMPRESS indicates keys in index blocks are compressed. 10. Describes indexes of an SQL table or alternate-key files of an Enscribe file: The key-spec parameter is the key specifier stored in every index row. FILE indicates by number an Enscribe alternate-key file.
INFO DETAIL Listing Format FUP Commands (SUPPRESSED: rwep) indicates the underlying security of a file protected at the file level by Safeguard. This indicates the security the file would have if Safeguard security were removed. For more information, see the Safeguard Reference Manual. 14. SECONDARY PARTITION indicates the file is a secondary partition of an Enscribe file. 15. Lists dates and times of file activity.
INFO DETAIL Listing Format FUP Commands If all extents were allocated, the percent-used parameter is the amount of available file space currently used based on available space. 17. Aggregate EOF: For the disk objects, the end-of-file value of the file. For a partitioned file where the entire file has been opened, the end-of-file value of the entire file is returned. If all extents were allocated, the percent-used parameter is the amount of file space currently used based on available space. 18.
INFO DETAIL Listing Format Examples FUP Commands new-option displays the location of the resource fork for an ANSI table, index, or metadata table. The file format is always 2. The security vector is ‘*SQL.’ The DETAIL listing format for SQL/MX objects also contains: The ANSI name associated with the object. The location of system metadata tables associated with the object. Clustering key information for the objects. Partitioning information for objects that can be partitioned.
INFO DETAIL Listing Format Examples FUP Commands BLOCK 4096 IBLOCK 4096 KEYLEN 10 KEYOFF 0 ALTKEY ( "ab", FILE 0, KEYOFF 10, KEYLEN 10 ) ALTKEY ( "cd", FILE 1, KEYOFF 20, KEYLEN 10 ) ALTFILE ( 0, $VOL1.SVOL.AK1 ) ALTFILE ( 1, $VOL1.SVOL.AK2 ) PART ( 1, $VOL2, 1, 1, "AA" ) OWNER 8,1 SECURITY (RWEP): AAAA DATA MODIF: 11 May 1999, 11:20 CREATION DATE: 10 Apr 1997, 16:00 LAST OPEN: 14 Apr 2000, 18:00 EOF 3072 ( 9.4% USED) AGGREGATE EOF: 3072 (9.4% USED) FILE LABEL: 298 (7.
INFO DETAIL Listing Format Examples FUP Commands DATA MODIF: 3 Jul 2000, 16:48 CREATION DATE: 3 Jul 2000, 14:48 LAST OPEN: NEVER OPENED FILE LABEL: 314 (7.7% USED) EOF: 0 (0.0% USED) EXTENTS ALLOCATED: 0 To show the FUP INFO, DETAIL listing for a logical file by its physical name: -INFO $HEAT.ZYS00000.Z00057I0, DETAIL $HEAT.ZYS00000.A00057I0 3 Jul 2000, 16:50 ENSCRIBE VIRTUAL FILENAME: \SMSDEV.$BALL.CAROLS.
INFO DETAIL Listing Format Examples FUP Commands Next, issue a CREATE KEY command. (FUP responds by displaying information on the keys just created.) Then issue an INFO KEY, DETAIL command: -CREATE KEY CREATED - $DATAA.DCDTEST.KEY CREATED - $DATAA.DCDTEST.ALT0 -INFO KEY, DETAIL $DATAA.DCDTEST.KEY 17 Dec 2000, 16:45 ENSCRIBE TYPE K FORMAT 1 EXT (2 PAGES, 2 PAGES) REC 80 BLOCK 4096 IBLOCK 4096 KEYLEN 2 KEYOFF 0 ALTKEY ("AA",FILE 0,KEYOFF 0,KEYLEN 2,INSERTIONORDER) ALTFILE ( 0, $DATAA.DCDTEST.
INFO DETAIL Listing Format Examples FUP Commands CREATION DATE: 19 May 2003, 15:25 REDEFINITION DATE: 19 May 2003, 15:24 LAST OPEN: NEVER OPENED EOF: 0 (0.0% USED) EXTENTS ALLOCATED: 0 INDEX LEVELS: 0 PARTITION ARRAY FORMAT2ENABLED To request detailed information about ALT0: -INFO ALT0, DETAIL $DATAA.DCDTEST.
INFO DETAIL Listing Format Examples FUP Commands CODE 101 FORMAT 1 EXT ( 2 PAGES, 2 PAGES ) MAXEXTENTS 16 BUFFERSIZE 4096 OWNER 64,5 SECURITY (RWEP): AAAA DATA MODIF: 27 Jun 2000, 11:04 CREATION DATE: 27 Jun 1997, 11:03 LAST OPEN: 25 Jul 2000, 18:37 EOF 40 (0.1% USED) FILE LABEL: 214 (5.2 % USED) EXTENTS ALLOCATED: 1 $GUEST.ERNIE.
INFO DETAIL Listing Format Examples FUP Commands SECURITY (RWEP): *SQL DATA MODIF: 26 Aug 2003, 22:36 CREATION DATE: 26 Aug 2003, 22:36 REDEFINITION DATE: 26 Aug 2003, 22:36 LAST OPEN: 2 Sep 2003, 4:24 EOF: 0 (0.0% USED) EXTENTS ALLOCATED: 0 INDEX LEVELS: 0 PARTITION ARRAY FORMAT2ENABLED To request detailed information for a partitioned SQL/MX table using ANSI names: FUP INFO 'TABLE CAT_ANSINAME01.SCH_ANSINAME01.TAB1',DETAIL $DATA05.ZSDHKPKT.
INFO STATISTICS Listing Format FUP Commands $SYSTEM SYSTEM 2.. $OSS.ZYQ00001.Z0000010 11 May 2006, 13:59 OSS PATH: /aclutils/file1 OWNER -1 SECURITY: -rw-rw-rw-+ CREATION DATE: 11 May 2006, 13:48 ACCESS TIME: 11 May 2006, 13:48 EOF: 0 INFO STATISTICS Listing Format Example 2-8 shows the format that the FUP INFO command (with the STATISTICS option) uses to display file information. It reads the specified file to gather the statistics and requires more time to complete than the other INFO commands.
INFO STATISTICS Listing Format Examples FUP Commands a-slack is the average number of unused bytes for each block at the indicated level. a-%-slack is the average percentage of unused bytes for each block at the indicated level. name is shown only if the file has extra partitions. It is the volume name of the partition associated with the entry. FREE t-blocks is the total number of unused blocks in the file between the beginning of the file and the current EOF (for key-sequenced files).
FUP Commands INFO STATISTICS Listing Format Examples To display the FUP INFO, STATISTICS, PARTIAL listing for a key-sequenced, partitioned file with 48989 records and an EOF of 6983680: -INFO SPECIALK,STAT,PARTIAL 10 $GRAIN.CEREAL.SPECIALK 17 Feb 2001, 11:44 *****PARTIAL STATISTICS: 10% OF FILE***** AVG # AVG AVG % LEVEL BLOCKS RECS RECS SLACK SLACK 2 1 14 14.0 3760 92 1 1 75 75.0 2054 50 DATA 166 4840 29.
INFO EXTENTS Listing Format FUP Commands PART ( 3, \DRP42.$DATA3.ZSDHKPKT.L9G93500 ) PART ( 4, \DRP42.$DATA4.ZSDHKPKT.NQW83500 ) PART ( 5, \DRP42.$DATA05.ZSDHKPKT.P1G73500 ) PART ( 6, \DRP42.$DATA1.ZSDHKPKT.PJ183500 ) PART ( 7, \DRP42.$DATA2.ZSDHKPKT.Q6KB4500 ) PART ( 8, \DRP42.$DATA3.ZSDHKPKT.SVS83500 ) PART ( 9, \DRP42.$DATA4.ZSDHKPKT.
INFO EXTENTS Listing Format Examples FUP Commands INFO EXTENTS Listing Format Examples To show the FUP INFO, EXTENTS listing for PARTFILE (a key-sequenced, partitioned file): -INFO PARTFILE,EXTENTS $VOL1.SVOL.PARTFILE EXTENT # OF PAGES 0 1 1 1 0 1 1 1 2 1 3 1 4 1 11/03/99 14:45 STARTING PAGE PART 12246 $VOL1 12247 239 $VOL2 293 294 297 307 To show the FUP INFO, EXTENTS listing for a partitioned SQL/MX table: -INFO J4XL3T00, EXTENTS $D1103.ZSDL2BDF.
Commands Related to INFO FUP Commands Commands Related to INFO COMMAND Function Page FILES Displays the names of all files in a subvolume 2-80 FILENAMES Displays the names of files 2-78 CONFIG[URE] Sets default option for STAT and STATONLY 2-28 LICENSE (Super ID) Allows nonprivileged users to execute programs that contain privileged attributes (CALLABLE or PRIV attributes). Only a super ID (255,255) user can use this command. This command applies only to Enscribe files. Note.
Commands Related to LICENSE (Super ID) FUP Commands Commands Related to LICENSE (Super ID) COMMAND Function Page REVOKE Resets file security and other attributes of a file 2-169 LISTLOCKS Displays information on all locks (granted or waiting) for specified Guardian file sets or SQL/MX ANSI names. FUP converts each ANSI name to the corresponding list of Guardian file names, then performs LISTLOCKS on each of these files, and displays information of the locked files only. Note.
LISTLOCKS FUP Commands required to precede and delimit each ansiname. The ANSI names syntax is in accordance with Unified Syntax Proposal. The syntax is: ansiname :: = CATALOG [SYSTEM | USER ] { * | SQL-names } | SCHEMA [SYSTEM ] SQL-names | {TABLE | INDEX} base-mx-object-names SQL-names :: = SQL-name |( SQL-name [, SQL-name … ]...
LISTLOCKS Listing Format FUP Commands consecutive double quotes. A delimited module name in SQL/MX can contain the circumflex character (^). Note. The keywords, SYSTEM and USER, help distinguish user data from metadata. The SYSTEM keyword can be used together only with the keyword CATALOG or SCHEMA, to indicate the system metadata contained inside a catalog or schema. The USER keyword can only be used with the CATALOG keyword to indicate the user metadata contained inside a catalog.
LISTLOCKS Listing Format FUP Commands STATE is the state of the lock: G Granted I Internally generated intent lock W Waiting REQUESTER ID is either a named or unnamed process (or a transaction ID). KEY LEN is the key length. KEY/RECORD ADDRESS is a key value for each locked record according to the type of file: For key-sequenced files, the key value is displayed. This value can wrap around to the next line. For unstructured files, the relative byte address is displayed.
LISTLOCKS Guidelines FUP Commands LKDS Delete shared. This lock is a composite of LK^D and LK^S. It is a shared lock for the row and a delete of one or more of the rows that precede the locked row. LKSIX Shared, intent exclusive. This lock is acquired for a table when an LK^IX table lock exists and a user duration LK^S table lock is required for a scan. LK^UX Unique, exclusive. This lock is acquired to protect a single row (no range protection). LKDUX Delete, unique exclusive.
LISTLOCKS Example FUP Commands The user running FUP must have remote access to any system, which is implicitly referenced by the ANSI name used in the FUP command. For example, if the ANSI name is 'CATALOG*', the user must have access to any node on which any visible catalogs reside, and so on. If the ANSI name is 'TABLE C.S.T', the user must have access to any node on which partitions of table C.S.T reside, and so on.
LISTOPENS FUP Commands To display locks on SQL/MX index using ANSI names: FUP LISTLOCKS 'INDEX CAT_ANSINAME01.SCH_ANSINAME01.IND1 PARTITION (IPART1)',DETAIL $DATA05.ZSDHKPKT.DK8CK600 ANSI NAME CAT_ANSINAME01.SCH_ANSINAME01.IND1 LOCK REQUESTER KEY TYPE STATE ID F GI \DRP42(2).2.7784507 LOCK STATE = LK^IX R G \DRP42(2).2.
LISTOPENS Listing Format FUP Commands name is a device name made up of alphabetic characters, wild-card characters (* or ?), or a combination of both. number is a temporary file name made up of numbers, wild-card characters (* or ?), or a combination of both. If $device is not specified, it defaults to the current volume. ansiname-list ansiname-list = ‘ansiname’ [ , ‘ansiname’ ]...
LISTOPENS Listing Format FUP Commands a is the access mode: R Read R/W Read and Write E Execute -e is the exclusion mode: S Shared E Exclusive P Protected g,u is the group ID, user ID of the process accessor ID. sd is the sync or receive depth specified by the process when the file was opened. term is the name of the home terminal of the process: [\node.]$term prog-name is the program file name of the program that has the specified file open as it appears for a user process: $volume.subvolume.
LISTOPENS Guidelines FUP Commands 215,01,0079 R/W-S 001,249 $SYSTEM.SYSTEM.TESTPROC $GUEST.MYSVOL.RFILE PID MODE USERID NAME 215,01,0079 R/W-S 001,249 $SYSTEM.SYSTEM.TESTPROC $GUEST.MYSVOL.SAMPLE PID MODE USERID NAME 215,01,0039 R/W-E 001,249 $GUEST.FUPD00.FUP 00 \FOXII.$LAM1.#ZWN SD MYTERM 00 \FOXII.$LAM1.#ZWN SD MYTERM 01 \FOXII.$TC1.
LISTOPENS Examples FUP Commands If the device (controlling process) does not support a LISTOPENS request, FUP LISTOPENS displays: WARNING - dev name: WILL NOT RETURN OPEN INFORMATION: ERR 2 LISTOPENS does not show a file as open if it was opened and closed during a transaction (although the transaction itself is still open). This situation occurs because the file has no openers.
LISTOPENS Examples FUP Commands 042,02,0432 R -S $SYSTEM.SYSTEM.MXCI 255,255 15 $ZTNT.#PTUJKRM $DATA05.ZSDHKPKT.P1G73500 ANSI NAME CAT_ANSINAME01.SCH_ANSINAME01.TAB1 PID MODE USERID SD MYTERM PROGRAM FILE NAME 042,02,0432 R -S 255,255 15 $ZTNT.#PTUJKRM $SYSTEM.SYSTEM.MXCI $DATA1.ZSDHKPKT.J1C73500 ANSI NAME CAT_ANSINAME01.SCH_ANSINAME01.TAB1 PID MODE USERID SD MYTERM PROGRAM FILE NAME 042,02,0432 R -S 255,255 15 $ZTNT.#PTUJKRM $SYSTEM.SYSTEM.MXCI $DATA1.ZSDHKPKT.PJ183500 ANSI NAME CAT_ANSINAME01.
LOAD FUP Commands LOAD Loads data into a structured disk file without affecting any associated alternate-key files. Data in the file being loaded is overwritten. This command applies only to Enscribe files. To load any alternate-key files, use the command LOADALTFILE on page 2-144 after you complete a LOAD command. LOAD in-filename , destination-filename [ , load-option ] ...
LOAD FUP Commands You need to understand when to use the COPY, DUP[LICATE], and LOAD commands: COPY To change file attributes or copy files to or from nondisk devices DUP[LICATE] To create identical copies of disk files LOAD To create a structured disk file from scratch (much faster than COPY) in-filename names the file containing the records to be loaded. This file can be a disk file, a nondisk device, a process, a tape DEFINE name, an EDIT file, or a SPOOLER (code 129) file.
LOAD FUP Commands KEY { record-spec | key-value } specifies the primary-key value for the starting record of a disk file. FUP begins reading the input file at the record you name with KEY. Specify record-spec as an integer ranging from 0 through (512000000 * 2,048) -1. Give the starting relative byte address for record-spec (for unstructured files). Give the starting record number for record-spec (for relative files). Give ordinal-record-num for record-spec (for entry-sequenced files).
LOAD FUP Commands PAD [ pad-character ] specifies that records containing fewer than in-record-length bytes are padded with pad-character up to the record length specified in the file label. Specify pad-character as a single ASCII character inside quotation marks: "c" or as an integer ranging from 0 through 255, specifying a byte value: { 0:255 } Note. The pad-character default is an ASCII null character (binary 0). in-option specifies the format and control of in-filename.
LOAD FUP Commands If you specify SORTED, you can ignore this option. PARTOF $volume loads only the partition named in destination-filename. This option is for key-sequenced, partitioned files only. The $volume is the volume containing the primary partition of the destination file. Note. For more information about the PARTOF option, see LOAD Guidelines on page 2-141. SCRATCH scratch-filename names a file or volume to be used for temporary storage during the sorting phase.
LOAD Guidelines FUP Commands LOAD Guidelines The input records of key-sequenced files can be in sorted or unsorted order. If you do not specify SORTED, FUP invokes a SORT process to sort the records before loading the destination file. The FUP LOAD command reads the source file directly using large buffers unless you specify SHARE, in which case the Enscribe file system performs the reads. You can use a SORT DEFINE with the LOAD command. You must define it before starting FUP.
LOAD Guidelines FUP Commands An example of this situation occurs if you pad each record in a data file with zeros to a standard size in bytes and then store the records in another file. If you trim the trailing zeros when you execute a FUP LOAD or COPY of the stored records, any original data that ends with a zero is trimmed. To avoid this problem, use a value for pad-character or trim-character that is not contained in your data. The NO COMPACT option affects only relative files.
LOAD Examples FUP Commands LOAD command can accept in-filename and destination-filename as a key-sequence files with increased limits or an enhanced key-sequenced file or a legacy key sequenced file. If the destination-filename is a legacy key-sequenced file and infilename is a legacy key-sequenced file, then the data contained in the source file starting from primary partition will be loaded into the destination file starting from the primary partition.
Commands Related to LOAD FUP Commands Commands Related to LOAD COMMAND Function Page DUP[LICATE] Creates identical copies of disk files 2-67 COPY Creates a record-by-record copy of a file 2-38 LOADALTFILE Creates an alternate-key file from a primary file 2-144 BUILDKEYRECORDS Creates alternate-key file records 2-23 RELOAD Reorganizes an existing file online 2-154 CONFIG[URE] Sets default options for the LOAD command 2-28 LOADALTFILE Generates (from a primary file) the alternate-key re
LOADALTFILE Guidelines FUP Commands MAX num-records specifies the number of records to be read from primary-filename. The default is 10,000,000. Specify num-records as a whole number ranging from 0 through (512000000 * 2048) - 1. To determine the size of the scratch file that is used by the SORT process, FUP multiplies num-records by the number of alternate keys associated with key-file-number. The num-records value should be equal to or greater than the actual number of records in the primary file.
LOADALTFILE Example FUP Commands A duplicate key in an alternate-key file with the UNIQUE attribute causes LOADALTFILE to fail and display file-system error 71 (duplicate record). LOADALTFILE does not always generate alternate-key file records or display explanatory messages if either of these statements apply: The full length of the alternate-key field is not contained in a specific primary record. A null value was specified for the key, and the field contains only the null value.
OBEY Guidelines FUP Commands OBEY Guidelines Command files must contain ASCII text with valid FUP commands. Command files are usually EDIT files but can be any other file type that FUP reads. Command file processing terminates with EOF or a FUP EXIT command. A command file can call other command files. A maximum of four command files can be active simultaneously. FUP displays the commands in a command file only if the CONFIGURE ECHO OBEY option is enabled.
PURGE FUP Commands If you are running FUP interactively (entering FUP commands at the command interpreter or FUP prompt) and you omit !, FUP prompts you for permission to purge the fileset-list: If fileset-list is a single file (or a list of single files), the FUP INFO listing is displayed for each file and followed by the PURGE? prompt. Type Y or y to purge the file. If you type any other response, the file is not purged.
PURGE Guidelines FUP Commands [NO] LISTALL specifies whether to list the names of all files as they are purged. The listing is: $volume.subvolume.file-id PURGED. LISTALL is the default in interactive mode. The default for noninteractive mode is NO LISTALL. If you include this option, you must enclose fileset-list in parentheses even if the list contains only one file. If you omit the parentheses, FUP treats LISTALL or NO LISTALL as file names.
PURGE Examples FUP Commands In the LISTALL mode, PURGE lists each file name immediately after deleting it. If you press the BREAK key while FUP is running, the PURGE command terminates and does not delete any remaining files in fileset-list. PURGE command operates on key-sequenced file with increased limits. PURGE Examples To purge the file WKLYRPRT in the current default subvolume without prompting for permission: -PURGE WKLYRPRT ! $MYVOL.RECDS.WKLYRPRT PURGED.
PURGE Examples FUP Commands To display the FUP INFO listing for each file in the specified file set and prompt for permission to purge each file: -PURGE WKLYRPRT, MONTHEND, REQTOTAL CODE EOF LAST MODIF OWNER RWEP BLOCK $MYVOL.RECDS WKLYRPRT 2048 29MAR87 11:46 8,44 AOAO 1024 PURGE? Y $MYVOL.RECDS.WKLYRPRT PURGED. CODE EOF LAST MODIF OWNER RWEP BLOCK $MYVOL.RECDS MONTHEND 5120 29MAR87 11:44 8,44 AOAO 1024 PURGE? N CODE EOF LAST MODIF OWNER RWEP BLOCK $MYVOL.
Commands Related to PURGE FUP Commands If you type S (or press Return), the FUP INFO listing appears for each file in the file set, followed by the PURGE? prompt: ( Y[ES], N[ONE], S[ELECT], F[ILES] )? S CODE EOF $A.B FILE1 101 1646 PURGE? Y $A.B.FILE1 PURGED. FILE2 101 1646 PURGE? N FILE3 101 1646 PURGE? Y $A.B.FILE3 PURGED. 2 FILES PURGED LAST MODIF OWNER RWEP 5APR85 15:55 8,44 AO-- 4APR85 16:31 8,44 CUCU 3APR85 12:48 8,44 CUCU TYPE...
PURGEDATA Guidelines FUP Commands PARTONLY purges data in any primary or secondary extents of partitioned files that reside in fileset-list. If you omit PARTONLY, data is purged from all partitions of partitioned files—but only if the primary partitions of the files reside in fileset-list. PURGEDATA Guidelines To use PURGEDATA and purge data from a file, you must have write access to that file or be a super-group user (255, n).
RELOAD FUP Commands RELOAD Physically reorganizes a key-sequenced file or SQL object (table or index only) while allowing shared read and write access to the file or object. FUP RELOAD supports key-sequenced file reorganization of volume directories, TMFaudited files and SQL tables, and nonaudited files and SQL tables. A reload operation improves access time and use of space for a key-sequenced file or SQL object that has undergone many insertions, deletions, and updates with length changes.
RELOAD FUP Commands SQL-name is used to name base SQL base objects (such as tables or indexes) in addition to their SQL containers: catalogs and schemas. The names (called 3-part names) for SQL base objects such as tables, indexes, or modules are composed of three SQL identifiers separated by two dot characters (for example, CAT.SCH.T). SQL-identifier is a name used by SQL/MX to identify tables, views, columns, and other SQL entities.
RELOAD FUP Commands PARTOF $volume specifies the volume where the primary partition resides if filename is an Enscribe secondary partition. If you specify a secondary partition but do not specify the PARTOF option, the system returns an error message. The PARTOF option is not required for an SQL object. If you specify this option for an SQL object, FUP ignores it.
RELOAD FUP Commands By default, a RELOAD operation cannot be performed if the user initiating the operation does not have write access to a file whether the SHARE option is specified or not. If the user does not have write access, error 48 is returned. To perform a RELOAD operation, a user who does not have write access to the file can use the SHARE option by configuring ORSERV (online reload server): Note. These steps can be performed only on the ORSERV object, which has symbols information.
RELOAD Guidelines FUP Commands The RECLAIM option directs DP2 to mark data blocks vacated due to a DDL "move partition boundary" or "one-way split" operation as FREE blocks. The RECLAIM completes very quickly, but the EOF of the file may not be reduced after a RECLAIM. If the original goal of the partition split was to free space within the source partition for future data insertion, the RECLAIM option is sufficient.
RELOAD Guidelines FUP Commands To temporarily stop the reload, use the SUSPEND command. Access to filename by an application (during the reload) requires shared access. The reload operation on an audited file generates audit records that describe the movement of data within the file. The audit record total from a file can triple the file length (discounting free space). A reload operation can degrade system performance.
RELOAD Example FUP Commands The above explanation can be used to explain both an error 8551 from ANSI names or error 48 from the file system, depending on the command that was used. RELOAD supports SQL/MX objects, TABLE PARTITION, and INDEX PARTITION. For an audited file, ORSERV keeps the file open and does not terminate for five minutes after the reload operation completes. RELOAD command operates on a key-sequenced file with increased limits.
RELOCATE Guidelines FUP Commands SOURCEDATE allows the preservation of the original timestamp of the DATAMODIF attribute of a file. It works when the user is SUPER.SUPER or owner of the file. When relocating files on a virtual drive without the SOURCEDATE option, the original time stamps are not retained. Note. This option was added in the T6553H01^ACS SPR. RELOCATE Guidelines If multiple files are specified in the logical-set, FUP relocates them one at a time (waited).
RENAME Guidelines FUP Commands old-fileset-list specifies the files to be renamed. You can use wild-card characters and can specify qualified-fileset for fileset-list. For example, *SF finds all the files that end with SF. You can use ?SF to find all files that start with one character and are followed by SF. The files in old-fileset-list can reside on more than one subvolume. new-fileset specifies the new names of the files.
REPORTWIDTH FUP Commands REPORTWIDTH Sets the maximum length (in columns) for FUP to format its output. This command changes the normal (default) 132-character output format of these FUP commands to a smaller output format: COPY with a DUMP option FILES LISTLOCKS SUBVOLS The REPORTWIDTH command became an option of the CONFIG[URE] command with the D30 product version of FUP.
RESET FUP Commands RESET Restores one or more file-creation attributes to the default settings. For a list of filecreation attributes and their default values, see SET on page 2-177. RESET [ reset-opts | CONFIG[URE] config-simple-opts ] reset-opts is: create-spec [ , create-spec ] ...
RESET Guidelines FUP Commands config-simple-opts config-simple-option [ , config-simple-option ] config-simple-option is: ALLOW DISPLAYBITS DISPLAYALLNUM ECHO [CONFIG[URE] | OBEY IOTIMEOUT NETBLOCKSIZE PROMPT [ PURGE ] REPORTWIDTH RESTARTUPDATE STATONLY XLATE [ xlate-table-name ] XLATEIN [ xlate-table-name ] XLATEOUT [ xlate-table-name ] COPY [ copy-option ] DUP[LICATE] [ dup-option ] LOAD [ load-option ] LOADALTFILE [ loadaltfile-option ] RELOAD [ reload-option ] RESET Guidelines Each create-spe
Commands Related to RESET FUP Commands ALTKEY ("aa", FILE 0, KEYOFF 0, KEYLEN 5) ALTFILE (0, $COMPUTR.BOOKS.BLAISE) ALTCREATE MAXEXTENTS 16 Reset the record size file-creation attribute to the default value of 80 bytes: -RESET REC After you complete the reset, the FUP SHOW command includes this line in its display: REC 80 This example uses a single RESET command with no create-spec to restore all the defaults.
RESTART Guidelines FUP Commands If restart-filename is not specified, FUP searches your current subvolume for a file named ZZRSTART. RESTART Guidelines FUP (DUP) updates the restart file periodically. This causes a RESTART operation to start from the last update, which is not necessarily from the last record written. The RESTART operation fails if any of these conditions exist: The last modified time of the source file has changed.
Commands Related to RESTART FUP Commands Commands Related to RESTART COMMAND Function Page DUP[LICATE] Creates an identical copy of a disk file 2-67 File Utility Program (FUP) Reference Manual—523323-015 2-168
REVOKE (Super ID) FUP Commands REVOKE (Super ID) Revokes a license for a privileged program file, or resets the security attributes of files and programs that have standard security codes. REVOKE command privileges are determined by your user ID: If your user ID identifies you as the owner of a file, you can reset the CLEARONPURGE and PROGID security attributes of the file by including the file in fileset-list and specifying the attribute you want to reset.
REVOKE (Super ID) Guidelines FUP Commands PROGID sets the process accessor ID to the owner ID of the program file when the program file is run (for program files only). Including PROGID in a REVOKE command revokes the PROGID option for the file. The process accessor ID is set to the ID that corresponds to the creator of the process when the program is run.
REVOKE (Super ID) Examples FUP Commands REVOKE cannot work with SQL files other than SQL object files. FUP REVOKE with CLEARONPURGE and PROGID option returns the following warning messages for Safeguard protected object file with different disk file and protection record owners when: Disk file owner attempts the operation: Warning: DISKFILE FLAB OWNER IS CHANGED TO MATCH PROTECTION RECORD OWNER.
SECURE FUP Commands SECURE Sets or changes the standard security attributes of a file. To execute the SECURE command, you must be the owner of the file you want to secure, or you must log on as the super ID (255,255). SECURE fileset-list [ , [ security ] [ , secure-option ]... security is: [ " ] { security-string } [ " ] { security-num } secure-option is: CLEARONPURGE | PARTONLY | PROGID fileset-list is a list of files whose security attributes are to be set or changed.
SECURE FUP Commands You can use these characters in security-string: - Local super ID (255,255) only (use security-num to set in r position) O Owner only (local only) G Group member or owner (local only) A Any local user U Member of owner's user class (local or remote user with the same user ID as the owner of the file) C Member of owner's community (local or remote user with the same group ID as the owner of the file) N Any local or remote user ? No change Note.
SECURE Guidelines FUP Commands A standard user can secure a file (by using security-num) to allow only super ID (255,255) access (%7777). After doing this, the user does not have access to the file and must ask the super ID to change the security of the file. Note. The SECURE command does not change the file security if you omit security-string and security-num.
SECURE Guidelines FUP Commands 3. The new owner has ownership permission as per the underlying persistent protection record. User other than owner in the same group can set the PROGID and CLEARONPURGE security attributes of a Safeguard protected file if the OWNERSHIP (O) permission is given to the user while adding to safeguard protection using SAFECOM. FUP returns the error message "SAFEGUARD IS NOT LICENSED", if the safeguard object is not licensed.
SECURE Examples FUP Commands CLEARONPURGE option: Warning: DISKFILE FLAB OWNER IS CHANGED TO MATCH PROTECTION RECORD OWNER.
SET FUP Commands SET Changes one or more file-creation default attributes before you create files. You can specify parameter values explicitly or set them to match those of an existing file. To display the current file-creation attributes (the values for create-param), use the SHOW command. To restore create-param values to the default settings, use the RESET command. SET create-param [ , create-param ] ...
SET Parameters for All File Types FUP Commands create-param for files with alternate-key fields is: [ NO ] ALTCREATE ALTFILE ( key-file-number , filename ) ALTKEY ( key-specifier { , altkey-param }...
SET Parameters for All File Types FUP Commands specified with NO BUFFERED. The default is BUFFERED for audited files and NO BUFFERED for nonaudited files. Caution. If you use the buffered-cache option on a DP2 file that is not audited by TMF, a system failure or disk-process takeover can cause the loss of buffered updates to the file. An application program might not detect this loss (or handle the loss correctly) unless it is modified to do so. CODE file-code sets the file code.
SET Parameters for All File Types FUP Commands 0:maximum BYTE[S] specifies the extent size in bytes. Possible values of maximum are: Format 1 Format 2 0:134,215,680 BYTE[S] 0:2,147,483,647 BYTE[S] The FUP process rounds the extent size up to the next full page. If you specify 2,047 bytes, FUP allocates one page. If you specify 2,049 bytes, FUP allocates two pages.
SET Parameters for All File Types FUP Commands MAXEXTENTS maximum-extents sets the maximum number of extents to be allocated (for nonpartitioned files or key-sequenced partitioned files). Specify maximum-extents as an integer from 16 through n, where n is a maximum value determined by the amount of free space in the file label. The FUP process rounds any value you set (from 1 through 15) up to 16. The absolute maximum is 978 extents, and the default is 16.
SET Parameters for All Structured Files FUP Commands SET Parameters for All Structured Files The create-param available depends on the type of file you want to create. These options are available for all structured files: BLOCK data-block-length sets the data-block length. Specify data-block-length as an integer that is a power of 2 from 512 bytes through 4096 bytes (512, 1024, 2048, 4096). The default data-block-length is 4096 bytes. Blocks should not be larger than extents.
SET Parameters for Partitioned Files FUP Commands [ NO ] COMPRESS sets or clears the states of key compression in both index and data blocks. The default setting is NO COMPRESS. The key offset must be 0 for key compression in data blocks, and the maximum record size is reduced by one byte. [ NO ] DCOMPRESS sets or clears key compression for data blocks. The default setting is NO DCOMPRESS. The key offset must be 0 for key compression, and the maximum record size is reduced by one byte.
SET Parameters for Partitioned Files FUP Commands PART ( sec-partition-num , [\node.]$volume [ , pri-extent-size [ , [ sec-extent-size ] [ , partial-key-value ] ] ] ) PART sets secondary partition specifications for partitioned files. Specify each secondary partition separately. sec-partition-num , \node.$volume names the volume where this secondary partition is to reside. Specify sec-partition-num as an integer from 1 through 15 to designate the secondary partition.
SET Parameters for Partitioned Files FUP Commands 0:maximum [ PAGE[S] ] specifies the extent size in pages (2,048-byte units). Possible values are: Format 1 Format 2 0:65,535 [ PAGE[S] ] 0:512,000,000 [ PAGE[S] ] Because the minimum extent size is one page (2,048 bytes), one page is also allocated if you specify zero extents. 0:maximum BYTE[S] specifies the extent size in bytes.
SET Parameters for Files With Alternate-Key Fields FUP Commands A string of characters enclosed in quotation marks: "c1c2...cn" A list of single characters (with quotation marks around each character) separated by commas: "c" , "c" , "c" ... Integers representing byte values from 0 through 255 enclosed in brackets: [ 5, 8, 220 ] To specify partial-key-value correctly: If the partial-key values are a string of alphabetic characters, enclose them in quotation marks.
SET Parameters for Files With Alternate-Key Fields FUP Commands [ NO ] ALTCREATE sets or clears the automatic alternate-key file creation. The alternate-key files are created (if you specify ALTCREATE) when you create the primary file. The default setting is ALTCREATE. ALTFILE ( key-file-number, filename ) adds or replaces the file name of an alternate-key file. You must include this parameter for any undefined key file number that is referenced by an ALTKEY specification.
SET Parameters for Files With Alternate-Key Fields FUP Commands FILE key-file-number sets the key-file number for key-specifier. Specify key-file-number as an integer from 0 through 99. ALTFILE create-param relates this number to an actual file. The default is zero. [ NO ] INSERTIONORDER specifies whether or not insertion-ordered alternate-key sequencing is to be used. The default is NO INSERTIONORDER.
SET Parameters for Unstructured Files FUP Commands files, you might leave files unsynchronized in rare circumstances. For example, you could have two files pointing to the same alternate-key file but only want updates from one of the two written to it. The default is UPDATE. SET Parameters for Unstructured Files The create-param set available depends on the type of file you want to create.
SET Parameter for Files on SMF Virtual Disks FUP Commands For each 28 KB of data of unstructured files on 512 byte sector disks, one 4 KB check block with the checksum data is allocated. For extent management, check blocks are added to the file size and extents are aligned to include check blocks. For I/O management, all unstructured I/Os are in units of 32 KB (28 KB user data and 4 KB check block).
SET Guidelines FUP Commands Using SET command, you can create: 128 partitions Blocklength up to 32 KB Recordlength up to 27,648 Primary keylength up to 2048 Primary keyoffset up to 27,647 Alternate key value up to 2048 Alternate keyoffset up to 27,647 Locklength up to maximum primary keylength for Format 2 key-sequenced file SET PART command accepts secondary-partition-num up to 127. SET PART command accepts a non zero partial-key-value for first secondary partition.
SET Examples FUP Commands page.) Although you can specify different sizes for primary and secondary extents, equal sizes are displayed to simplify the table. Table 2-3.
Commands Related to SET FUP Commands The SHOW command indicates the buffer size is 512 bytes: -SHOW TYPE U FORMAT 1 EXT ( 1 PAGES, 1 PAGES ) MAXEXTENTS 16 BUFFERSIZE 512 To set file-creation attributes for a key-sequenced file with 50-byte records and a primary-key length of 36 bytes: -SET TYPE K, REC 50, KEYLEN 36 To create the file $L.SMS.BLUE on the physical volume $ABC, use the PHYSVOL option of the SET command (which subsequently resets the PHYSVOL option): -SET PHYSVOL $ABC CREATE $L.SMS.
SHOW FUP Commands SHOW Displays the current settings of the file-creation attributes. Use the FUP SET and FUP RESET commands to set and reset these attributes. SHOW [ / OUT listfile / ] [ show-opts ] [ configure-opts ] show-opts is: create-spec [ , create-spec ] ...
SHOW FUP Commands config-simple-opts config-simple-option [ , config-simple-option ] config-simple-option is: ALLOW DISPLAYBITS DISPLAYALLNUM ECHO [CONFIG[URE] | OBEY IOTIMEOUT NETBLOCKSIZE PROMPT [ PURGE ] REPORTWIDTH RESTARTUPDATE STATONLY XLATE [ xlate-table-name ] XLATEIN [ xlate-table-name ] XLATEOUT [ xlate-table-name ] COPY [ copy-option ] DUP[LICATE] [ dup-option ] LOAD [ load-option ] LOADALTFILE [ loadaltfile-option ] RELOAD [ reload-option ] OUT listfile names an existing disk file or a device
SHOW Guidelines FUP Commands SHOW Guidelines You cannot use show-opts and configure-opts in the same command. You must use separate SHOW commands. If you issue the SHOW command with a create-spec that is not currently set (or is not applicable to the current value of TYPE), FUP returns only a prompt. The SHOW display might list an EXT size that differs by one page from what might actually be created. This situation occurs because FUP rounds extent sizes up (if necessary). Note.
Commands Related to SHOW FUP Commands REC 80 BLOCK 4096 KEYLEN 2 KEYOFF 0 ALTKEY ( "aa", FILE 0, KEYOFF 0, KEYLEN 2, INSERTIONORDER) ALTFILE ( 0, $DATAA.DCDTEST.
STATUS Guidelines FUP Commands filename is the name of a key-sequenced file or SQL object reorganized by a reload operation. You cannot use wild-card characters in filename or specify qualified-fileset. Note. When using SPI interface, pass the filename in uppercase. DETAIL gives complete information on the status of the file you want listed. By default, STATUS displays information only for fields it determines are relevant to the current situation.
STATUS Examples FUP Commands STATUS Examples To display the status of a RELOAD process while it is in progress: -STATUS PAYFILE $BASE.FUPTESTL.PAYFILE RELOAD IN PROGRESS RELOAD INITIATED: 10 Aug 2000, 15:35 DSLACK: 20% ISLACK: 20% RATE: 10% PCT COMPLETED: 45% DEALLOCATE: YES To display the status of a RELOAD process after its completion: -STATUS PAYFILE, DETAIL $BASE.FUPTESTL.
SUBVOLS Examples FUP Commands listfile for the SUBVOLS command. If listfile is an existing file, FUP appends the output to that file. Note. For more information about listfile, see Specifying Files on page 1-8. subvolset is a pattern describing the subvolume names you want to see. The subvolset parameter defaults to the current volume. You can use wild-card characters in subvolset (including the volume name), but you cannot specify qualified-fileset.
SUSPEND Guidelines FUP Commands name as the OUT listfile for a SUSPEND command. If listfile is an existing file, FUP appends the output to that file. Note. For more information about listfile, see Specifying Files on page 1-8. filename is the name of a key-sequenced file or SQL object (table or index) being reorganized. You cannot use wild-card characters in filename or specify qualified-fileset Note. When using SPI interface, pass the filename in uppercase.
SYSTEM Guidelines FUP Commands volume names the new current default volume. subvolume names the new current default subvolume. SYSTEM Guidelines The initial SYSTEM setting is the node enabled when you start FUP. You can use the SYSTEM command only to reference nodes that have a name; for example, a node that is part of a network. Entering the SYSTEM command without node restores the default node name to the local node.
Commands Related to SYSTEM FUP Commands Commands Related to SYSTEM COMMAND Function Page VOLUME Changes the FUP default volume and subvolume 2-205 TRUST Changes the state of Trust flag to TRUST ME, TRUST SHARED or TRUST OFF. Only a super ID (255, 255) user can set the FLTTrustFlags flag to TRUST ME or TRUST SHARED. This flag controls whether direct I/O access to user buffers is permitted when this process is running.
TRUST Guidelines FUP Commands trust-flag is one of: OFF ME SHARED OFF resets Trust flag. ME sets Trust flag to TRUST ME state. SHARED sets Trust flags to TRUST SHARED state. TRUST Guidelines The code of the files must be 100 or 800. If a files has another file code, error 2 occurs. If a user who is not the super ID (255,255) attempts to change the Trust flags to TRUST ME or TRUST SHARED, FUP gives a warning of INSUFFICIENT CAPABILITY.
VOLS FUP Commands VOLS Displays information about volumes on a system. The VOLS command lists the names, capacities, and current usage for all specified volumes in a format that is similar to the Disk Space Analysis Program (DSAP) utility. VOLS [ / OUT listfile / ] [ volset ] volset is: [ \node.] $volume OUT listfile names an existing disk file or a device to receive the listing output from the VOLS command.
VOLUME Guidelines FUP Commands node sets the current default node for FUP. You can set the default node only in a named node; for example, a node that is part of a network. volume sets the current default volume name for FUP operations. subvol sets the current default subvolume name for FUP operations. VOLUME Guidelines Typing the VOLUME command without a parameter restores the defaults that were enabled when you started FUP, including the original node.
Commands Related to VOLUME FUP Commands Commands Related to VOLUME COMMAND Function Page SYSTEM Changes the FUP default node name 2-201 File Utility Program (FUP) Reference Manual—523323-015 2-207
FUP Commands Commands Related to VOLUME File Utility Program (FUP) Reference Manual—523323-015 2-208
3 FUP Messages This section describes the text messages that FUP might generate. Each description includes an explanation of what caused the message to be generated, explains the effect the erroneous activity has on the system process, and provides a suggested mode of recovery.
FUP Messages ALTERNATE KEY FILE CANNOT BE AN SQL OBJECT Cause. An ALTFILE option specified an SQL object as an alternate-key file. Effect. The operation terminates. Recovery. Retry the command by specifying a valid alternate-key file. AN ALTERNATE KEY FILE HAS NO CORRESPONDING ALTERNATE KEY Cause. An attempt to create or alter a file failed because an alternate-key file that had no corresponding alternate key was specified. Effect. The CREATE or ALTER command fails. Recovery.
FUP Messages Effect. The ASSUMEID attribute is not preserved. Recovery. Use the ALTER command to change the attribute. You might have to use remote logon. ATTEMPT TO RENAME A NONEXISTENT ALTFILE Cause. An attempt was made in DUP rename-options to rename a nonexistent alternate file. The source file does not have the specified alternate-key file. Effect. This is only a warning. Command execution proceeds, but the alternate-key file is not created. Recovery.
FUP Messages Recovery. Variable-length blocks must contain at least two bytes at the beginning of the block. BAD CASE NUMBER Cause. An error occurred in the program logic. Effect. FUP ends abnormally. Recovery. Call your service provider and describe the circumstances under which the error occurred. BAD PARTITION PARAMETERS Cause. The PART specification for CREATE or ALTER was wrong. For example, all partition numbers must be sequential, starting from 1. When this message appears after FUP LOAD... PARTOF..
FUP Messages Effect. The command is not performed on the file. Recovery. Turn off auditing if possible. This command cannot be performed on audited files. CAN'T OPEN TAPE FILE FOR READ ACCESS IF DEFINE VALUE FOR USE IS EXTEND Cause. A TAPE DEFINE was specified with USE set to EXTEND, but the DEFINE name was specified as an input file in either a FUP COPY or LOAD command. Effect. The command fails. Recovery. Modify the DEFINE or command parameters and retry the command.
FUP Messages Recovery. Informational message; no corrective action is needed. CONSISTENCY CHECK Cause. A check was made of some internal structures. Effect. The command might not finish. Recovery. This message should never appear. If it does, contact your service provider. COULD NOT FIND DEFINE. Cause. A logical style DEFINE name was specified for a DEFINE class, such as class SPOOL or class TAPE, that does not exist. Effect. The command fails. Recovery. Specify a correct name and retry the command.
FUP Messages Recovery. Informational message only; no corrective action is needed. DEFINE DOES NOT MATCH TAPE LABEL OR TAPE LABEL IS BAD Cause. An attempt to open a labeled-tape file failed with file-system error 196 (tape label record missing or incorrect). Effect. The command fails. Recovery. Verify that the specified DEFINE attributes match the label for the tape file. Correct, if necessary, and retry the command.
FUP Messages Recovery. Retry the LISTLOCKS operation. DRIVE DOES NOT SUPPORT TAPEMODE SELECTION Cause. The TAPEMODE parameter was used for a tape drive that does not support the setting. Effect. The COPY or BUILDKEYRECORDS command continues without trying to set the tape mode. Recovery. Informational message only; no corrective action is needed. DRIVE DOES NOT SUPPORT THIS DENSITY SELECTION OR CAN ONLY CHANGE DENSITY AT BOT Cause.
FUP Messages Effect. If the COMPACT option is selected in a COPY or LOAD command, this message indicates that the target file will have fewer records than the source file. The message is issued only when the first empty record is encountered. Recovery. If you want the target file to contain the same records as the source file, retry the COPY or LOAD command with the COMPACT option deselected. EMPTY SOURCE FILE Cause.
FUP Messages Recovery. Retry the command after correcting the errors. If the file was being updated concurrently, the error might be only a transient structure problem FUP encountered while reading large blocks. ERROR - filename: ERR nnn Cause. A file-system error occurred. filename indicates the name of the file that FUP was attempting to process. Effect. The operation fails. Recovery.
FUP Messages Recovery. You cannot use the OLD option for incompatible files. However, you can purge the old file and retry the DUP command. filename : FILE IS BROKEN Cause. An attempt was made to duplicate a broken file. Effect. The indicated file is duplicated, and the broken flag is set. Recovery. Informational message only; no corrective action is needed. filename : FILE IS CORRUPT Cause. An attempt was made to duplicate a corrupt file. Effect.
FUP Messages Recovery. Write down the complete description and contact your service provider. ILLEGAL CHARACTER Cause. An illegal character was used in the attempted command or ANSI Name is entered specifying an invalid SQL identifier character. Effect. The command fails. Recovery. Retry the command after correcting the illegal character. ILLEGAL EXTENT SIZE SPECIFIED Cause. The attempted command contained an illegal extent-size specification.
FUP Messages Cause. A syntax error occurred in the qualified file-set expression. The additional text should describe the specific error. Effect. The command fails. Recovery. Retry the command after correcting the syntax. ILLEGAL SYNTAX Cause. A syntax error occurred in the attempted command. Effect. The command fails. Recovery. Retry the command after correcting the syntax. ILLEGAL VALUE Cause. The attempted command specified an illegal value: for example, SET EXT -1. Effect. The command fails. Recovery.
FUP Messages Recovery. Note the internal load error indicated by nnn, and contact your service provider. INVALID SPI MESSAGE RETURNED BY SERVER Cause. A RELOAD, STATUS, or SUSPEND command received an invalid SPI message from the reload server process. Effect. The command fails. Recovery. This is an internal error. Contact your service provider. INVALID STATUS RETURNED BY SERVER Cause. The reload server process returned invalid status information to a STATUS command. Effect. The command fails. Recovery.
FUP Messages Cause. A BUILDKEYRECORDS command contained a key-specifier that is not defined for the file. Effect. The BUILDKEYRECORDS command fails. Recovery. Retry the command with key tags properly defined for the file. LABELED-TAPE SERVER IS NOT AVAILABLE Cause. An attempt to open a tape file failed with file-system error 195 (operation requires use of $ZSVR, but it is not running). The labeled-tape server, $ZSVR, is not running. Effect. The command fails. Recovery.
FUP Messages Effect. None. Recovery. Informational message only; no corrective action is needed. MISSING KEYWORD Cause. A syntax error occurred. FUP required a keyword but found nothing or something other than a keyword. Effect. The command fails. Recovery. Retype the command, correcting the syntax error. MISSING NUMBER Cause. FUP required a number but found nothing or an alphabetic value. For example, after the SET option PART, the partition number must be provided. Effect. The command fails. Recovery.
FUP Messages Cause. An attempt was made to duplicate a partition PARTONLY. FUP detected that the partition data would be reshuffled among the partitions. Effect. The command fails. Recovery. Reissue the command without the PARTONLY option, and convert the file as a whole. NO CHANGE TO ALT KEY FILES Cause. The OLD option of the DUP command was used. Effect. This is only a warning that any alternate-key files must be reloaded. Duplication of the primary file proceeds. Recovery.
FUP Messages Cause. The specified text for the HISTORY, !, or ? command was not found in the buffer. Effect. None. Recovery. Enter the correct text and try the command again. NO SUCH SYSTEM Cause. The attempted command specified a nonexistent node. Effect. None. Recovery. Reenter the command with a valid node name. NOT ALL ATTRIBUTES WERE TRANSFERRED Cause. The SAVEALL, SAVEID, or SOURCEDATE option of DUP was specified, and an error occurred while saving one or more of the relevant attributes. Effect.
FUP Messages Recovery. Retry the command after deleting the character that follows the continuation character. NOT ALLOWED IN BATCH MODE Cause. An operation was attempted in batch mode that can be performed only from a terminal. Effect. None. Recovery. Perform the operation in interactive mode from a terminal. NOT PRIMARY PARTITION Cause. A secondary partition was specified in a context where secondary partitions are not allowed. Effect. The command fails. Recovery.
FUP Messages filename : OPEN ERR : nnn Cause. A file-system error was encountered while attempting to open the indicated file. Effect. The command fails. Recovery. For corrective action for the file-system error number indicated by nnn, see the Guardian Procedure Errors and Messages Manual. OPERATION NOT ALLOWED ON SQL OBJECT Cause. An SQL object was specified in a command that cannot operate on these objects. Effect. The command fails. Recovery.
FUP Messages OVERFLOW OF TABLE Cause. FUP ran out of internal memory space while trying to execute the command. Effect. FUP ends abnormally. Recovery. Restart FUP, and retry the command. If the same error occurs, call your service provider. OWNER NOT PRESERVED AT DESTINATION Cause. The transfer of a file’s OWNER attribute failed during a duplicate operation with the SAVEALL or SAVEID option to a remote node. Effect. The OWNER attribute is not preserved. Recovery. Use the GIVE command to change the owner.
FUP Messages Cause. A DUP operation that did not specify PARTONLY was attempted on a partitioned file, and one of the partitions is an SQL object. Effect. None of the file is duplicated. The DUP operation continues executing on the next file in the file set. Recovery. If you intended to specify another type of file, retry the command after correcting the file specification. PRIMARY KEY TOO LONG FOR AN ALTERNATE KEY FILE Cause.
FUP Messages Recovery. If the error is not apparent, try using INFO on a file with a similar file set without using a qualified file set. QUALIFIED FILESETS NOT PERMITTED Cause. Qualified file set is either not permitted in this command, or it was used in an incorrect position. Effect. The command fails. Recovery. Use the qualified file set in the correct position, or retry the command without a qualified file set (if they are not permitted in this command).
FUP Messages Cause. An attempt was made to use the REELS parameter when in-file for the operation was a TAPE DEFINE name with LABELS set to label processing. Effect. The command fails. Recovery. Use the REELS and VOLUME TAPE DEFINE attributes with multiple labeled tapes. filename: RELOAD ABENDED WITH ERROR nnn Cause. A RELOAD command failed before completion. Effect. The STATUS command terminates. Recovery.
FUP Messages Effect. The RESTART operation terminates. Recovery. When you retry the operation, use a valid restart file that has file code 855 or perform an ordinary DUP operation. RESTART FILE NOT ALLOWED ON OPTICAL DISK Cause. For a RESTARTABLE DUP operation or a RESTART operation, the restart file was named explicitly or implicitly (that is, as a default) on an optical disk volume. Effect. The operation terminates. Recovery.
FUP Messages Recovery. Use the FILESEQ TAPE DEFINE attribute to skip files on a labeled tape. SKIPOUT PARAMETER NOT ALLOWED FOR LABELED TAPES Cause. An attempt was made to use the SKIPOUT parameter when the out-file for the operation was a TAPE DEFINE name with LABELS set to label processing. Effect. The command fails. Recovery. Use the FILESEQ TAPE DEFINE attribute to skip files on a labeled tape.
FUP Messages Recovery. This is an internal error. Note the error and contact your service provider. SQL RECOMPILATION REQUIRED Cause. A DUP command duplicated an SQL sensitive file. Effect. This is only a warning. The DUP operation proceeds. Recovery. The newly created file should be SQL compiled. TABLE OVERFLOW Cause. Certain internal tables of FUP overflowed. Effect. FUP ends abnormally. Recovery. If a second attempt of the operation (after restarting FUP) fails, contact your service provider.
FUP Messages Cause. The value of in-file was a TAPE DEFINE name, and the BLOCKLEN value in the DEFINE did not equal the value of the BLOCKOUT FUP parameter. Effect. The command fails. Recovery. Change the BLOCKLEN or BLOCKOUT value and retry the command. TAPE DEFINE VALUE FOR DENSITY CONFLICTS WITH DENSITYOUT Cause. The value of in-file was a TAPE DEFINE name, and the DENSITY value in the DEFINE did not equal the value of the DENSITYOUT FUP parameter. Effect. The command fails. Recovery.
FUP Messages Recovery. Change the RECLEN or RECOUT value and retry the command. TAPE DEFINE VALUE FOR TAPEMODE CONFLICTS WITH FUP PARAMETER Cause. The TAPE DEFINE attribute for TAPEMODE and the FUP parameter for TAPEMODE were both specified, and they conflict. Effect. The COPY or BUILDKEYRECORDS command terminates. Recovery. Modify one of the TAPEMODEs and retry the operation. TAPE DENSITY AND TAPE MODE CANNOT BOTH BE SET Cause. The TAPEMODE and DENSITYOUT parameters were both specified. Effect.
FUP Messages Recovery. Determine why the tape mount request was rejected, resolve the problem, and retry the command. For the corrective action for file-system error 194, see the Guardian Procedure Errors and Messages Manual. THERE IS NO SUCH ALTERNATE FILE Cause. The key-file-number parameter to LOADALTFILE was undefined for the specified primary file. Effect. The command fails. Recovery. Execute a FUP INFO with the DETAIL option to see what the alternate-key files are for a given file.
FUP Messages Recovery. Check the BLOCKIN, RECIN, or input record length values. If truncation is intended, ignore the warning. TRUNCATION OF LAST VARIABLE LENGTH RECORD IN BLOCK Cause. This is a warning message. The VARIN option was used with the COPY or LOAD command, and the last variable-length record in the block was truncated because the record, as indicated by the record length at the beginning of the record, extended beyond the end of the block. Effect.
FUP Messages Recovery. Check that what you are trying can be done using FUP. If it can, retry the command after correcting any errors in typing. UNIMPLEMENTED FUNCTION Cause. An attempt was made to use a function that is not available. Effect. The request is not executed. Recovery. This message should never appear. If it does, contact your service provider. UNTERMINATED STRING Cause. A quoted string was not terminated with a closing quote. Effect. The command fails. Recovery.
FUP Messages Recovery. For corrective action, see the Guardian Procedure Errors and Messages Manual. AN ANSI NAME KEYWORD IS EXPECTED LIKE CATALOG, SCHEMA, TABLE OR INDEX Cause. ANSI Name is entered without specifying an ANSI Name keyword. Effect. The command fails. Recovery. Retry the command after adding the required ANSI Name keyword. ANMS FAILED WITH PROCESS_CREATE_ CALL ERROR: Cause.
FUP Messages Recovery. Retry the command by entering the fully qualified ANSI Name. BAD SQL IDENTIFIER; IDENTIFIER MUST CONTAIN AT LEAST ONE CHARACTER Cause. ANSI Name is entered with a missing SQL identifier. Effect. The command fails. Recovery. Retry the command after adding the required SQL identifiers. BAD SQL IDENTIFIER; TOO LONG Cause. ANSI Name is entered with SQL identifier that is too long. Effect. The command fails. Recovery. Retry the command after correcting the SQL identifier.
FUP Messages Recovery. None. COMMAND ONLY SUPPORTS TABLE PARTITION and INDEX PARTITION Cause. ANSI Name is entered with TABLE or INDEX in the RELOAD command. Effect. The command fails. Recovery. None. DUPLICATE REQUEST, AN ANSP WAS ACTIVE Cause. Returned when FUP attempts to launch one more ANSI Name Server Process (ANSP) when it already has one active ANSP. Effect. The command fails. Recovery. This message should never appear. If it does, stop FUP and start it again and then issue the command.
FUP Messages Cause. ANSI Name is entered without specifying a required starting single quote or if guardian file name is entered after the first ANSI Name. Effect. The command fails. Recovery. Retry the command after adding the required missing single quote. If you have entered the Guardian name along with the ANSI Name in the same command, then retry the command by entering either the ANSI Name or the Guardian name. REQUIRED SINGLE QUOTE MISSING OR BAD ANSI NAME ENTERED Cause.
FUP Messages Recovery. Install the SQL/MX ANSI Names SPR on the system. VERSION MISMATCH BETWEEN SQL/MX MAPPING SOFTWARE AND FUP Cause. There is a version mismatch between FUP and the SQL/MX MAPPING SOFTWARE (SQL/MX ANSI Names mapping service - ANMS). Effect. The command fails. Recovery. Install the version of FUP and the SQL/MX MAPPING SOFTWARE (SQL/MX ANSI Names mapping service ANMS) that are compatible with each other. VERSION MISMATCH BETWEEN SQL/MX PARSER AND FUP Cause.
FUP Messages File Utility Program (FUP) Reference Manual—523323-015 3-38
A DEFINE Tables You can use SPOOL, TAPE, or MAP DEFINEs to specify information for a FUP process before you start it: Use SPOOL DEFINEs to send command output to a spooler. Use TAPE DEFINEs to send command output to a tape file or receive a tape file as input. Use MAP DEFINEs to substitute a logical name for an actual file name. Note. Do not use TAPE DEFINE attributes that conflict with your FUP command parameters. For more information about DEFINEs, see the Guardian User’s Guide .
DEFINE Tables Table A-2.
B FUP Command Summary For a description of the individual function and structure of each FUP command, see Section 2, FUP Commands. Each command fits into one of four distinct command groups: control, information, security, and file management. The FUP commands in this appendix are categorized according to their function. Table B-1 lists the commands you use to control FUP. Table B-2 lists the commands you use to obtain information. Table B-3 lists commands used for security management.
FUP Command Summary Table B-2. FUP Informational Commands Command Function FILENAMES Displays the names of files. FILES Displays the names of all files in a given subvolume or volume. INFO Displays the file characteristics of one or more files. LISTLOCKS Displays information on all locks (granted or waiting) for a specified file set. LISTOPENS Lists all processes that currently have one or more designated files open. STATUS Displays information about the progress of a RELOAD operation.
FUP Command Summary Table B-4. FUP File Management Commands (page 2 of 2) Command Function DEALLOCATE Deallocates any extents past the end-of-file extent for one or more disk files. DUP[LICATE] Makes a copy of one or more disk files. There are special considerations for duplicating Safeguard protected files. Refer to the syntax and guidelines for this command. LOAD Loads data into a structured disk file without affecting any associated alternate-key files.
FUP Command Summary File Utility Program (FUP) Reference Manual—523323-015 B-4
C FUP Command Syntax Summary To run FUP: FUP [ / run-options / ] [ command ] To specify files, you can use fileset or fileset-list. fileset is: [[[ \node.]$volume.]subvolume.| *.]{file-id | *} fileset-list is: { fileset | ( fileset [ , fileset ] ...
FUP Command Syntax Summary ALTER filename { , alter-option }... alter-option for all file types is: [ NO ] AUDIT [ NO ] AUDITCOMPRESS [ NO ] BUFFERED BUFFERSIZE unstructured-buffer-size CODE file-code LOCKLENGTH genric-lock-key-length MAXEXTENTS maximum-extents NOPURGEUNTIL timestamp [ NO ] REFRESH RESETBROKEN RESETCORRUPT [ NO ] SERIALWRITES [ NO ] VERIFIEDWRITES alter-option for files with alternate-key fields is: ALTFILE ( key-file-number , filename ) ALTKEY ( key-specifier { , altkey-param }...
FUP Command Syntax Summary BUILDKEYRECORDS primary-filename , out-filename , key-specifier-list [ , out-option ] ...key-specifier-list is: { key-specifier } { ( key-specifier [ , key-specifier ] ...
FUP Command Syntax Summary COPY in-filename [ ,[ out-filename ] [,copy-option ] ...
FUP Command Syntax Summary COPY continued ... display-option is: O[CTAL] D[ECIMAL] H[EX] BYTE A[SCII] NO HEAD [ NO ] TITLE CREATE filename [ , create-param ] ... (For a description of create-param, see the SET command.) DEALLOCATE fileset-list [ , PARTONLY ] DUP[LICATE] from-fileset-list , to-fileset [ , RESTARTABLE [ restart-filename ] } [ , rename-option ] ...
FUP Command Syntax Summary GIVE fileset-list , { groupnum , usernum | groupname.username } [ , PARTONLY ] HELP [ / OUT listfile / ] [ command | ALL [, SYNTAX ] | NEWS ] HISTORY [ / OUT listfile / ] [ num INFO [ / OUT listfile / ] [ fileset-list / ansiname-list ] [ [ [ [ [ , , , , DETAIL ] EXTENTS ] STAT[ISTICS] [ , PARTONLY ] [ , PARTIAL num ] ] USER { groupnum , usernum } ] { groupname.
FUP Command Syntax Summary LOAD in-filename , destination-filename [, load-option]...
FUP Command Syntax Summary RELOAD [ / OUT listfile / ] filename / ‘ansiname’ [ [ NO ] DEALLOCATE ] [ , NEW ] [ , PARTOF $volume ] [ , RATE percentage ] [ DSLACK percentage ] [ ISLACK percentage ] [ SLACK percentage ] [ RECLAIM ] RELOCATE logical-set [ ,physvol ] [ , [ NO ] MIRRORED ] [ , SOURCEDATE] RENAME old-fileset-list , new-fileset [ , PARTONLY ] REPORTWIDTH width RESET [ create-spec [ , create-spec ] ...
FUP Command Syntax Summary SET create-param [ , create-param ] ...
FUP Command Syntax Summary (continued from previous page) create-param for files with alternate-key fields is: [ NO ] ALTCREATE ALTFILE ( key-file-number , filename ) ALTKEY ( key-specifier { , altkey-param }...
FUP Command Syntax Summary (continued from previous page) show-opts is: ALTCREATE ALTFILE [ key-file-number ] ALTFILES ALTKEY [ key-specifier ] ALTKEYS AUDIT AUDITCOMPRESS BLOCK BUFFERED BUFFERSIZE CODE COMPRESS DCOMPRESS EXT FORMAT ICOMPRESS KEYLEN KEYOFF MAXEXTENTS ODDUNSTR PARTONLY PART [ partition-num ] PARTS REC REFRESH SERIALWRITES TYPE VERIFIEDWRITES STATUS [ / OUT listfile / ] filename [ , DETAIL ] SUBVOLS [ / OUT listfile / ] [ subvolset ] subvolset is: [ \node.] $volume [.
FUP Command Syntax Summary VOLUME [ [\node.]$volume [.subvol ] ] [ subvol ] FILESET LIST { fileset | ( fileset [ , fileset ] ... ) } FILESET filename [ qualexpr ] where filename can have wild-card characters. SUBVOLSET [ \node.] $volume [.subvol ] | subvol VOLSET [ \node.] $volume FILELIST filename [ , filename ] ... FILENAME [[[ \node.[ $volume.[ subvol. ] file-id VOLNAME [ \node.
FUP Command Syntax Summary ENTRYSEQUENCED FORMAT1|FORMAT2 INDEX [ SHORTHAND | PROTECTION ] VIEW KEYSEQUENCED LICENSED OPEN PROGID RELATIVE [ PRIMARY | SECONDARY ] PARTITION ROLLFORWARDNEEDED SAFEGUARD SQL SQLPROGRAM TABLE TRUSTED TRUSTME TRUSTSHARED UNSTRUCTURED user-id is: group-name.user-name group-name.
FUP Command Syntax Summary File Utility Program (FUP) Reference Manual—523323-015 C-14
Glossary abend. The abnormal end of a task or process, or an error condition that can result in the termination of a program. The FUP process terminates with an abend message if it encounters an error in a command. access mode. A specification that determines the different types of operations (read-write, read-only, or write-only) that a process can perform against a file. The mode is established when the file is opened. alternate key.
byte Glossary device to another, or (3) a temporary or dynamic storage facility. It carries both logical (use within a program) and physical connotations. byte. An 8-bit storage unit; the smallest addressable unit of memory representing one alphanumeric character. cache. A portion of memory that temporarily stores an entire directory, a set of names, or a set of files. catalog. A collection of files that maintains context for virtual disk processes, pools, or $ZSMS. checksum.
Disk Process 2 (DP2) Glossary Disk Process 2 (DP2). The portion of the operating system software that performs read, write, and lock operations on disk volumes. The disk process also implements Enscribe and SQL/MP file types; creates TMF audit-trail records; performs logical REDO operations for Remote Duplicate Database Facility (RDF); and manages disk space, disk controllers, and paths to the disks.
Format 1 file Glossary Format 1 file. A Format 1 file is a file created on RVUs preceding D46.00 or G06.00. Format 2 file. Beginning with the D46.00 and G06.00 RVUs, a Format 2 file can contain larger blocks and partitions than a Format 1 file. internal file name. The name by which a file is known to DP2. For a direct file, it is the same as the file name.
parameter Glossary parameter. A name specified in a prepared command for which the user substitutes a value when executing the command. partition. The portion of a partitioned table, index, or physical file that resides on a particular disk volume. physical disk process. A DP2 process. physical file name. The internal name by which a file is known to DP2. For a direct file, this name is the same as the file name.
relocate Glossary deleted, but not lengthened or shortened. In SQL/MP, records (rows) can be updated or deleted, and VARCHAR columns can be lengthened or shortened. relocate. To move a logically named file from one physical location on disk to another without changing its logical name. Offline relocation does not preserve opens. rollforward.
structured query language conversational interface (SQLCI) Glossary structured query language conversational interface (SQLCI). A line-oriented terminal interface that enables a user to enter SQL commands, format and run reports, and operate database utilities. structured query language (SQL) object program. The object file containing the set of executable machine language instructions produced from a host language source program with embedded SQL statements. Subsystem Programmatic Interface (SPI).
virtual volume process Glossary virtual volume process. The SMF process managing a logical volume. This is a process pair. Also known as virtual disk process. volume. A physical storage device (disk) for files on a NonStop system. Volume names always begin with a dollar sign ($). It is the part of the designation that identifies where users store a document. The volume (like a file cabinet) holds subvolumes (like file drawers) that contain files (like individual folders). $ZSMS.
Index A ALLOCATE command 2-6 ALLOW command 2-9 ALTCREATE option, FUP SET 2-175 ALTER command 2-9 Alternate-key files attributes not passed when you create the primary-key file 2-179 changing attributes with FUP ALTER 2-10 creating 2-59 effect of altering the UNIQUE attribute 2-19 file-creation errors 2-58 loading data FUP BUILDKEYRECORDS 2-21 FUP LOADALTFILE 2-137 FUP RELOAD 2-147 parameter for setting attributes 2-175 renaming, DUP ALTFILE 2-59, 2-64 resetting creation values 2-157 specifying key value FUP
C Index BYTE format in FUP COPY display 2-56 BYTE option, FUP ALTER 2-17, 2-169, 2-173 C Cache configuration (DP2 volumes), with BUFFERED option 2-167 CHECKSUM command 2-24 Checksum errors, recovering from 2-24 CLEARONPURGE option effect on FUP PURGE 2-142 effect on FUP PURGEDATA 2-146 FUP REVOKE 2-160 FUP SECURE 2-164 transferring with FUP DUP 2-68 CODE option FUP ALTER 2-11 FUP SET 2-168 Comments, entering 1-3 COMPACT option FUP COPY 2-41 FUP LOAD 2-133 COMPRESS option, FUP SET 2-171 CONFIG[URE] comman
E Index E EBCDICIN option FUP COPY 2-41 FUP LOAD 2-133 EBCDICOUT option FUP BUILDKEYRECORDS 2-22 FUP COPY 2-46 Empty records, copied with FUP COPY 2-41, 2-52 EMPTYOK option, FUP LOAD 2-131 EXIT command 2-71 EXT option FUP DUP 2-65 FUP SET 2-168 Extent sizes specifying FUP ALTER 2-16 FUP SET 2-168 upward rounding 2-178, 2-179 EXTENTS option, FUP INFO 2-83 F FC command 2-71 File alternate-key See Alternate-key files audited See Audited files creating with FUP CREATE 2-58/2-61 deleting with FUP PURGE 2-140
G Index Format 2 (files) description 1-22 example, INFO output 2-108 INFO DETAIL option 2-100 partitioned files 2-17 qualified file sets 1-15 SET option 2-168, 2-169 FUPCSTM 1-4 G GIVE command 2-77 GRANTED option, FUP LISTLOCKS 2-119 H HELP command 2-79 HEX format in FUP COPY display 2-55 HISTORY command 2-80 I ICOMPRESS option, FUP SET 2-172 INFO command description 2-81 DETAIL listing format 2-98, 2-104 EXTENTS listing format 2-115 list current file attributes 2-18 standard listing format 2-85 STATIS
N Index MEGABYTE option, FUP ALTER 2-17, 2-169, 2-174 Messages, FUP runtime 3-1 N NEW option FUP DUP 2-66 FUP RELOAD 2-148 NO HEAD format in FUP COPY display 2-56 NOPURGEUNTIL option, FUP ALTER 2-12 NULL attribute FUP ALTER 2-19 FUP BUILDKEYRECORDS 2-23 NULL option, FUP SET 2-14, 2-177 O OBEY command 2-139 OCTAL format in FUP COPY display 2-55 Odd unstructured files, changing from an even unstructured file 2-178 ODDUNSTR option FUP ALTER 2-18 FUP SET 2-178 OLD option, FUP DUP 2-66 OSIMAGE file, FUP LIST
Q Index Primary-key files (continued) specifying for LOADALTFILE 2-137 specifying key value, FUP COPY 2-39 specifying key value, FUP LOAD 2-132 Privileged programs licensed with FUP LICENSE 2-116 unlicensing 2-160, 2-161 Process interrupting a FUP process 1-5 starting a FUP process 1-2 PROGID attribute FUP DUP SAVEALL 2-68 FUP GIVE 2-78 PROGID option FUP REVOKE 2-161 FUP SECURE 2-164 PUP DOWN command (FUP CHECKSUM) 2-24 STOPOPENS command (FUP CHECKSUM) 2-24 PURGE command 2-140 PURGE option, FUP DUP 2-66 P
S Index S Safeguard-protected files changing ownership 2-77 duplicating with FUP DUP 2-69 licensing 2-116 revoking 2-161 SAVEALL option, FUP DUP 2-67 SAVEID option, FUP DUP 2-67 SCRATCH option FUP LOAD 2-134 FUP LOADALTFILE 2-138 SECURE command 2-162 SERIALWRITES option FUP ALTER 2-13 FUP SET 2-170 SET command 2-166 SHARE option FUP COPY 2-44 FUP LOAD 2-133 FUP STATUS 2-185 SHOW command 2-182 SKIPIN option FUP COPY 2-44 FUP LOAD 2-133 SKIPOUT option FUP BUILDKEYRECORDS 2-22 FUP COPY 2-48 SLACK option FUP
U Index TRIM option FUP COPY 2-44 cautions on use 2-53 with RECIN option 2-42 FUP LOAD 2-133 TYPE option, FUP SET 2-170 VOLUME command 2-193 Volume, changing current default 2-193 W Wild-card characters (*, ?) 1-10 X U UNIQUE option effect of altering 2-19 effect on FUP BUILDKEYRECORDS 2-23 UNIQUE option, FUP SET 2-177 UNIQUE parameter, FUP SET 2-15 UNLOADIN option FUP COPY 2-45 FUP LOAD 2-133 UNLOADOUT option FUP BUILDKEYRECORDS 2-22 FUP COPY 2-49 Unstructured files, changing from even to odd 2-178 U
