HP G08 Reference Manual Download Page 51

Page: 51 / 326

FUP Overview

File Utility Program (FUP) Reference Manual—523323-014

1-27

Handling SQL/MX Files

indexes that depend on the table are loaded automatically. No SQL/MP commands
load indexes directly.



For compatibility with the FUP PURGE command, substitute the keyword PURGE
for DROP in the SQL/MP DROP utility.

Handling SQL/MX Files

SQL/MX is a relational database management system that promotes efficient online
access to large distributed databases.

Table 1-3. FUP Commands and SQL/MX Files

Applicable to SQL/MX File Type

FUP Command

Table

Index

Resource
Fork

Metadata
Tables

MXCI
Equivalent

ALLOCATE

ALTER

BUILDKEYRECORDS

CHECKSUM

Yes

COPY

CREATE

CREATE
TABLE

DEALLOCATE

DUP

FILES

Yes

FILENAMES

Yes

GIVE

INFO

Yes

MXCI
SHOWLABEL

LICENSE

LISTOPENS

Yes

LOAD

LOADALTFILE

PURGE

MXCI DROP
utility

PURGEDATA

RELOAD

Yes

RENAME

REVOKE

SECURE

SUBVOLS

Yes

Summary of Contents for G08

Page 1: ...n 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 Part Number Published 523323 014 August 2012 ...

Page 2: ...ersion 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 T6553 D45 G08 H01 and H02 August 2012 ...

Page 3: ...d Motif are trademarks of the Open Software Foundation Inc OSF MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THE OSF MATERIAL PROVIDED HEREIN INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE OSF shall not be liable for errors contained herein or for incidental consequential damages in connection with the furnishing performance or use of thi...

Page 4: ......

Page 5: ...w Starting a FUP Process 1 2 At the TACL Prompt 1 2 Interactively 1 3 From a Command File 1 3 Command Files 1 3 Run Options 1 4 Using FUP Custom Files 1 4 FUP Custom File Guidelines 1 4 FUP Custom File Example 1 5 Interrupting or Terminating a FUP Process 1 5 Entering a FUP Command 1 5 FUP Command Guideline 1 7 FUP Command Examples 1 7 Specifying Files 1 8 Listfile Parameter 1 8 Fileset list Param...

Page 6: ...4 Handling SQL MX Files 1 27 Handling SMF Files 1 28 2 FUP Commands 2 4 Guidelines 2 4 Examples 2 4 Commands Related to 2 5 2 5 Guidelines 2 5 Commands Related to 2 6 ALLOCATE 2 6 ALLOCATE Guidelines 2 6 ALLOCATE Examples 2 7 Commands Related to ALLOCATE 2 8 ALLOW 2 9 ALTER 2 9 ALTER Parameters for All File Types 2 10 ALTER Parameters for Files With Alternate Key Fields 2 13 ALTER Parameters for P...

Page 7: ...py Form 2 54 COPY Display Form 2 55 Copy Display Form Listing Format 2 56 Copy Display Form Examples 2 57 CREATE 2 58 CREATE Guidelines 2 58 CREATE Examples 2 59 Commands Related to CREATE 2 61 DEALLOCATE 2 61 DEALLOCATE Guidelines 2 61 DEALLOCATE Example 2 62 Commands Related to DEALLOCATE 2 62 DISPLAYBITS 2 62 DUP LICATE 2 62 DUP LICATE General Guidelines 2 67 DUP LICATE Guidelines for Safeguard...

Page 8: ...Format 2 85 INFO Listing Format Example 2 97 INFO DETAIL Listing Format 2 98 INFO DETAIL Listing Format Examples 2 105 INFO STATISTICS Listing Format 2 112 INFO STATISTICS Listing Format Examples 2 113 INFO EXTENTS Listing Format 2 115 INFO EXTENTS Listing Format Examples 2 115 Commands Related to INFO 2 116 LICENSE Super ID 2 116 LICENSE Super ID Guidelines 2 117 LICENSE Super ID Examples 2 117 C...

Page 9: ...GE Examples 2 143 Commands Related to PURGE 2 145 PURGEDATA 2 145 PURGEDATA Guidelines 2 146 PURGEDATA Example 2 146 Commands Related to PURGEDATA 2 146 RELOAD 2 147 RELOAD Guidelines 2 151 RELOAD Example 2 153 Commands Related to RELOAD 2 153 RELOCATE 2 153 RELOCATE Guidelines 2 154 RELOCATE Example 2 154 RENAME 2 154 RENAME Guidelines 2 155 RENAME Example 2 155 REPORTWIDTH 2 155 RESET 2 156 RESE...

Page 10: ...titioned Files 2 172 SET Parameters for Files With Alternate Key Fields 2 175 SET Parameters for Unstructured Files 2 177 SET Parameter for Files on SMF Virtual Disks 2 178 SET Guidelines 2 178 SET Examples 2 180 Commands Related to SET 2 181 SHOW 2 182 SHOW Guidelines 2 184 SHOW Examples 2 184 Commands Related to SHOW 2 185 STATUS 2 185 STATUS Guidelines 2 186 STATUS Examples 2 187 Commands Relat...

Page 11: ... 97 Example 2 4 Short INFO for SQL MX Table Using ANSI Names 2 97 Example 2 5 Short INFO for OSS Files With POSIX ACL 2 98 Example 2 6 DETAIL Format for SQL Tables and Indexes and for Enscribe and OSS Files 2 99 Example 2 7 DETAIL Format for SQL MP View 2 104 Example 2 8 INFO STATISTICS Listing Format 2 112 Example 2 9 INFO EXTENTS Listing Format 2 115 Example 2 10 FUP LISTLOCKS DETAIL Listing For...

Page 12: ... Extent Size Rounding 2 179 Table A 1 How FUP Input Options Work With TAPE DEFINEs A 1 Table A 2 How FUP Output Options Work With TAPE DEFINEs A 2 Table B 1 FUP Control Commands B 1 Table B 2 FUP Informational Commands B 2 Table B 3 FUP Security Management Commands B 2 Table B 4 FUP File Management Commands B 2 ...

Page 13: ...tions Document History New and Changed Information Changes to the 523323 014 manual Updated the table File Format Codes on page 1 23 Added a new section Unique Features of EKS Files on page 1 28 Updated the option NOPURGEUNTIL timestamp on page 2 12 Updated the section COPY Form on page 2 37 Added RELOCATE option to CONFIG command on page 2 26 Updated the section COPY Copy Form Examples on page 2 ...

Page 14: ...s on page B 2 Changes to the 523323 013 manual Updated these parameters for enhanced key sequenced files information ALTER Parameters on page 2 16 DUP LICATE Parameters on page 2 66 SET Parameters on page 2 178 SET Parameters for Files with Alternate Key Fields on page 2 181 Updated these guidelines for enhanced key sequenced files information ALLOCATE Guidelines on page 2 7 ALTER Guidelines on pa...

Page 15: ...RECLAIM information of the RELOAD command on 2 151 Added the SOURCEDATE option to the RELOCATE command on page 2 154 Updated the RESET command with the DISPLAYALLNUM environment option on page 2 159 Updated the SET Parameters for Unstructured Files information on page 2 183 Updated the SHOW command with the DISPLAYALLNUM environment option on page 2 188 Changes to the H06 08 Manual Added the open ...

Page 16: ...I names on page 1 1 Added a note on using two separate commands for ANSI names and Guardian names on page 1 1 Added missing file codes and the corresponding definitions in Table 2 2 on page 2 90 Added the TYPE variable and its description to the key column example on page 2 102 Added a note on page 2 102 that the key column TYPE and LENGHT is not displayed for SQL MX objects Updated these commands...

Page 17: ...What s New in This Manual File Utility Program FUP Reference Manual 523323 014 xiii Changes to the H06 05 Manual LISTOPENS command on page C 6 RELOAD command on page C 8 ...

Page 18: ...What s New in This Manual File Utility Program FUP Reference Manual 523323 014 xiv Changes to the H06 05 Manual ...

Page 19: ...The overview includes instructions for starting or interrupting FUP processes entering FUP commands and specifying files within FUP The section defines FUP concepts that are common to most of the FUP commands including file sets and list files This section also demonstrates how to use DEFINEs with FUP and how to handle HP NonStop SQL MP and HP NonStop SQL MX 2 FUP Commands Presents the syntax for ...

Page 20: ...in FUP commands File Utility Program FUP Management Programming Manual Explains how to execute commands from within an application program by using the Subsystem Programmatic Interface SPI Guardian Disk and Tape Utilities Reference Manual Explains tape handling procedures and describes the BACKCOPY BACKUP DCOM DSAP RESTORE and TAPECOM utilities Guardian Procedure Errors and Messages Manual Describ...

Page 21: ...ms not enclosed in brackets are required For example pathname Brackets Brackets enclose optional syntax items For example TERM system name terminal name INT ERRUPTS A group of items enclosed in brackets is a list from which you can choose one item or none The items in the list can be arranged either vertically with aligned brackets on each side of the list or horizontally enclosed in a pair of bra...

Page 22: ...nstant list Item Spacing Spaces shown between items are required unless one of the items is a punctuation symbol such as a parenthesis or a comma For example CALL STEPMOM process id If there is no space between two items spaces are not permitted In this example no spaces are permitted between the period and any other items process name su name Line Spacing If the syntax of a command is too long to...

Page 23: ... a pair of brackets and separated by vertical lines For example proc name trapped in SQL in SQL file system Braces A group of items enclosed in braces is a list of all possible items that can be displayed of which one is actually displayed The items in the list can be arranged either vertically with aligned braces on each side of the list or horizontally enclosed in a pair of braces and separated ...

Page 24: ...ates that the token or field is required For example ZCOM TKN OBJNAME token type ZSPI TYP STRING r o The o notation following a token or field name indicates that the token or field is optional For example ZSPI TKN MANAGER token type ZSPI TYP FNAME32 o Change Bar Notation Change bars are used to indicate substantive differences between this manual and its preceding version Change bars are vertical...

Page 25: ...or the commands LISTLOCKS LISTOPENS INFO and RELOAD The syntax for the ANSI names is same as mentioned in the Unified Syntax Proposal FUP reports information only about the named base table and not dependent objects FUP has a limitation that the command line cannot exceed 132 characters To use longer ANSI names FUP users need to 1 Use MXCI SHOWDDL or MXCI SHOWLABEL to get the Guardian names 2 Run ...

Page 26: ...t and press the RETURN key The FUP command INFO in this example instructs FUP to list the file information of each file in your current subvolume After FUP executes the command control of the terminal returns to TACL A separate FUP process starts and completes for each command you enter Topic Page Starting a FUP Process 1 2 Using FUP Custom Files 1 4 Interrupting or Terminating a FUP Process 1 5 E...

Page 27: ...es of FUP commands You can also process FUP commands within an interactive FUP session using the OBEY command Command Files To create a command file that contains FUP commands use a text editor such as TEDIT This example shows a command file ALLSUBS FUP commands for obtaining a list of all subvolumes in DISK1 DISK2 and DISK3 Last modified 5 17 01 SUBVOLS DISK1 Contains manufacturing files SUBVOLS ...

Page 28: ...LOCL file must be in the current system subvolume SYSTEM SYSnn or SYSTEM SYSTEM FUPLOCL lets you set a site standard FUP environment The FUPCSTM file must be in the user s logon subvolume FUPCSTM lets individual users set their own FUP environment Although FUP executes each command in the FUPLOCL and FUPCSTM files and can execute any FUP command custom files are most useful for setting environment...

Page 29: ...r descriptions of the syntax for each FUP command see Section 2 FUP Commands The basic command structure including run options is User Entry Results CTRL Y Terminates a FUP process from the FUP prompt or a PURGE command from the PURGE prompt and stops the execution of COPY and LOAD commands during input from the terminal BREAK Aborts any FUP commands that generate listings including the FILES INFO...

Page 30: ... else You must use a Guardian file name a SPOOL DEFINE or MAP DEFINE as the OUT list file to run FUP Any specified OUT disk file must be an EDIT file unstructured file or Enscribe structured file You cannot specify an SQL file as an OUT disk file You can use this option to specify output to a TACL variable If you omit this option FUP uses the OUT list file that is in effect for the current TACL pr...

Page 31: ...ds the input from ALLSUBS processes all of its commands sends the output to LIST1 and then returns to a new TACL prompt To start an interactive FUP process using the DUP command with the PURGE option to purge the contents of FILE2 before duplicating the contents of FILE1 into FILE2 the two files in this example FILE1 and FILE2 are from the default volume and subvolume TACL1 FUP DUP FILE1 FILE2 PUR...

Page 32: ...ax terms appear throughout the FUP commands Each of these terms provides a way to specify the file or files you want to affect with a FUP command The syntax terms are listfile fileset list fileset Listfile Parameter The listfile parameter refers to a nondisk device a process an existing disk file or a spooler file code 129 to which you direct the output of a FUP command It always appears with the ...

Page 33: ... contain up to ten different sets of files enclosed in parentheses The form for fileset list is Fileset list Examples To specify the files MYFILE MYSRC and MYOBJ in the current default subvolume on the current default volume MYFILE MYSRC MYOBJ To specify all files in the current default subvolume and all files in all the subvolumes on the volume VOL1 VOL1 To specify all files in all subvolumes on ...

Page 34: ... versions of FUP the subvolume name can be the default in most commands If the subvolume is omitted FUP uses the current default subvolume and issues a warning that this option might be deleted in future versions of FUP file id is the name of an Enscribe or SQL disk file It consists of alphanumeric characters wild card characters or or a combination of both Table 1 2 on page 1 25 shows the interac...

Page 35: ...e followed by one character and end with ILE on the current default volume and subvolume MY ILE To specify all the files in the subvolume MYSVOL on the current default volume MYSVOL To specify all the files in all the subvolumes on the volume VOL1 VOL1 To specify all the files in all the subvolumes on the current default volume To specify all the files in the subvolume MYTOWN on the volume BRDWAY ...

Page 36: ...qualifier is EXCLUDE fileset FROM CATALOG S catalog list START file id WHERE expression catalog list is node volume subvol subvol expression is expression expression AND expression expression OR expression NOT expression file attribute OWNER user id timestamp field time conditional time value FILECODE conditional number EOF conditional number ...

Page 37: ...YSEQUENCED 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 group number user number group number timestamp field is CREATIONTIME EXPIRATIONTIME LASTOPENTIME MODTIME time conditional is AFTER BEFORE ...

Page 38: ...le containing descriptions of the SQL objects tables indexes views or SQL programs START file id specifies a starting position within a file set or file set list The process starts on the first file after the file ID you specify Although the wild card option is not valid for this specification the file ID does not have to correspond to an existing file This option is useful for restarting a proces...

Page 39: ...P during DUP or LOAD operations If the DUP or LOAD operation is completed abnormally the CORRUPT flag remains set for the file A good example of its use is WHERE NOT CORRUPT CRASHOPEN specifies files not closed normally by the disk process A good example of its use is WHERE NOT CRASHOPEN ENSCRIBE specifies Enscribe files ENTRYSEQUENCED specifies entry sequenced files FORMAT1 describes files that a...

Page 40: ...itioned files the secondary partition of partitioned files or all partitions of partitioned files if neither primary nor secondary is specified PROGID specifies files that have the PROGID flag set RELATIVE specifies relative files ROLLFORWARDNEEDED specifies any files that need an HP Transaction Management Facility TMF rollforward process A good example is WHERE NOT ROLLFORWARDNEEDED SAFEGUARD spe...

Page 41: ...REATIONTIME selects a file based on when it was created EXPIRATIONTIME selects a file based on when it expires and can be purged You must use this option to select dates set with the NOPURGEUNTIL timestamp in FUP ALTER LASTOPENTIME selects a file based on when it was last opened MODTIME selects a file based on when it was last modified time conditional selects a file based on a specific time AFTER...

Page 42: ...e code conditional number represents a file code such as 101 and is preceded by one of these symbols EOF conditional number selects a file based on the number of bytes it contains conditional number represents the number of bytes you provide and is preceded by one of these symbols less than less than or equal to equal to greater than greater than or equal to not equal to less than less than or equ...

Page 43: ...within a subvolume DUP WHERE FILECODE 101 ANYWHERE To obtain information about all files in the current subvolume beginning with the letters M through Z INFO START M To obtain information about all files in the current subvolume that are not owned by user 1 86 INFO WHERE NOT OWNER 1 86 Creating Files You can create files using FUP commands Examples of Creating Files To use the FUP ALTER command to...

Page 44: ... existing alternate key sequenced file 1 Ensure the file is closed using the LISTOPENS command LISTOPENS file0214 2 Set the file creation attributes to match the existing file using the SET command SET LIKE USA texas austin 3 Set secondary partition specifications for the partitioned file using the SET command SET PART 1 ASIA primary EXT secondary EXT PRaltkeyvalue1 SET PART 2 VOLnn primary EXT se...

Page 45: ... to the spooler location specified with the LOC attribute in the DEFINE If this location is a printer FUP command output is queued and then printed Otherwise the output remains in the spooler where you can use PERUSE to view redirect or delete it SPOOL DEFINEs Example COPY ricecake MY_PRINTER COMMAND Function CREATE Creates a file using the current file creation parameter values that have been def...

Page 46: ...iles Handling File Formats A new disk file format Format 2 for describing large format files big files is available starting with the G06 00 and D46 00 RVUs At the time of creation you can specify the file format as Table 1 1 shows Note Do not use TAPE DEFINE attributes that conflict with your FUP command parameters For more information about how FUP input and output options work with TAPE DEFINEs...

Page 47: ...he Format 1 file during such a LOAD operation and all access must be shut down to switch to the new 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...

Page 48: ...oad the data into the new partition from the Format 1 partition 3 Change the file partition information to point to the new Format 2 partition instead of the Format 1 partition If Format 2 files are created on a system running D46 00 G06 00 or subsequent RVUs fallback to an RVU prior to D46 00 or G06 00 precludes access to the contents of those files Access to Format 2 files in an Expand network f...

Page 49: ...o No No ALTER TABLE ALTER INDEX BUILDKEYRECORDS No No No No No CREATE TABLE CHECKSUM Yes No Yes Yes No COPY No No No No No COPY utility CREATE No No No No No CREATE TABLE CREATE INDEX DEALLOCATE No No No No No ALTER TABLE ALTER INDEX DUP No No No No No DUP utility FILES Yes Yes Yes Yes Yes FILENAMES Yes Yes Yes Yes Yes GIVE No No No No No ALTER command SECURE utility INFO Yes Yes Yes Yes Yes FILEI...

Page 50: ...icates that you must compile the file again with the SQL MP compiler The only way to SQL MP license an SQL MP object program file is to apply the FUP LICENSE command to the file Although you can use the FUP CHECKSUM command to handle SQL MP tables and indexes it does not apply to SQL MP views protection and shorthand SQL MP views are skipped and a warning message appears during a FUP CHECKSUM proc...

Page 51: ... Commands and SQL MX Files Applicable to SQL MX File Type FUP Command Table Index Resource Fork Metadata Tables MXCI Equivalent ALLOCATE No No No No ALTER No No No No BUILDKEYRECORDS No No No No CHECKSUM Yes Yes Yes Yes COPY No No No No CREATE No No No No CREATE TABLE DEALLOCATE No No No No DUP No No No No FILES Yes Yes Yes Yes FILENAMES Yes Yes Yes Yes GIVE No No No No INFO Yes Yes Yes Yes MXCI S...

Page 52: ...pabilities for Guardian files FUP supports SMF commands by displaying information about files on virtual disks and lets you specify physical volumes 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 parti...

Page 53: ... these command groups see Appendix B FUP Command Summary FUP Command Description Page page 1 of 3 Executes an existing command again 2 4 Displays a specific command 2 5 ALLOCATE Allocates file extents for an Enscribe disk file 2 6 ALLOW Sets the number of errors and warnings before FUP stops 2 9 ALTER Changes characteristics of a disk file 2 9 BUILDKEYRECORDS Generates alternate key records for sp...

Page 54: ...execute privileged programs 2 117 LISTLOCKS Displays information on all locks for a specified file set 2 118 LISTOPENS Lists processes that have any of the specified files open 2 124 LOAD Loads data into a structured disk file without affecting associated alternate key files 2 131 LOADALTFILE Generates alternate key records for a designated alternate key file and then loads the records into the fi...

Page 55: ...ty attributes of a file 2 166 SET Changes file creation default attributes 2 171 SHOW Displays the current settings of the file creation attributes 2 187 STATUS Reports the status of a reload operation 2 190 SUBVOLS Displays the names of all subvolumes on a volume 2 192 SUSPEND Stops a reload operation 2 193 SYSTEM Sets the default node 2 194 TRUST Sets or resets the Trust flag 2 196 VOLS Displays...

Page 56: ...nclosed in either single or double quotation marks FUP searches every character in the command buffer not just the first characters until it finds the string For example use MAUI to execute the most recent command that referenced the system MAUI Guidelines If you use the command without a number or text string FUP executes the last command you entered again FUP displays the specified command befor...

Page 57: ...o display the most recent DUP command that begins with a volume name quoted is a string enclosed in either single or double quotation marks FUP searches every character in the command buffer not just the first characters until it finds the string For example use MAUI to display the most recent command that referenced the system MAUI Guidelines To display the last command you entered use the comman...

Page 58: ... a value from 1 through 16 multiplied by the number of partitions Each partition is allocated 16 extents beginning with the start of the file until the total num extents are allocated PARTONLY allocates extents to any primary and secondary partitions of partitioned files in fileset list If a primary partition name is referenced the extents are allocated only to the primary partition If you omit PA...

Page 59: ...ist you must use this file name syntax volume SYS00 DIRECTRY For an enhanced key sequenced file the ALLOCATE command assigns specified extents for secondary partitions but the extents of the primary partition remain unchanged ALLOCATE command with PART ONLY option and fileset list as primary partition of an enhanced key sequenced file is executed but the extents of the primary partition remain unc...

Page 60: ...nstructured files or of the BLOCK size for structured files To create an unstructured DP2 file with one page extents you must specify a BUFFERSIZE of 2048 bytes with either the FUP SET or FUP CREATE command 3 To allocate 10 file extents for YRFILE ALLOCATE YRFILE 10 4 Use the FUP INFO YRFILE DETAIL command to see that the extents are now allocated BOOKS1 COMLANG YRFILE 14 April 2001 09 05 ENSCRIBE...

Page 61: ...0 continue to recognize the ALLOW option as command syntax For more information see CONFIG URE on page 2 26 ALTER Changes some characteristics of an Enscribe disk file s label This command affects only the file label It does not create or purge files and does not insert delete or move records It applies only to Enscribe files filename is the name of the file that you want to alter FUP expands a pa...

Page 62: ...le as a nonaudited file To use the AUDIT option you must have read and write access to a file or be the super ID 255 255 NO AUDITCOMPRESS sets the mode of producing audit checkpoint messages using compressed or entire messages for audited files The default is NO AUDITCOMPRESS NO BUFFERED sets the mode of handling write requests to the file using buffered or write through cache BUFFERED specifies a...

Page 63: ... in the file label If there are alternate keys or partitions the maximum number of extents allowed is fewer than 978 If you specify MAXEXTENTS and the file is Format 1 you must consider the primary and secondary extent sizes to avoid exceeding the maximum file size for a Format 1 file When the primary and secondary extent size with the specified MAXEXTENT size is larger than two gigabytes the ALTE...

Page 64: ... day 0 00 00 or midnight If seconds ss is omitted timestamp defaults to zero If both date and time are omitted timestamp returns to the parameter default setting at the time the file was created If timestamp contains a date prior to Jan 1 1900 or after Dec 31 4000 FUP displays BAD TIMESTAMP and no date in the INFO DETAIL response screen NO REFRESH causes the file label to be copied to disk wheneve...

Page 65: ... 255 The FUP process expands a partial file name by adding the current default names for node volume and subvolume If you add a new ALTFILE number your ALTER command must also include an ALTKEY option that specifies the alternate key file If you define a new alternate key file you must create the file in a separate operation either before or after using ALTER ALTFILE If you delete the last alterna...

Page 66: ...lternate key file with other keys of different lengths or with other keys that are not insertion ordered All the nonunique alternate keys of a file must have the same duplicate key ordering attribute A file with this specification must not have both insertion ordered alternate keys and standard duplicate ordering by primary key nonunique alternate keys KEYLEN key length sets the key length for key...

Page 67: ...key file but does not purge the file The alternate key file must not be referenced by any existing key specifier After you execute an ALTER command with this option the remaining key file numbers and references to them are adjusted The numbers begin with zero and are contiguous 0 1 2 and so on DELALTKEY key specifier deletes an alternate key specification You cannot access the file through key spe...

Page 68: ...integer from 1 through 63 to designate the secondary partition Specify node and volume as the names of the node and volume to contain the partition The file name and the subvolume of the primary partition are specified when the file is created Although FUP lets you specify any number in the range 1 through 15 for sec partition num FUP changes it to a standard DP2 number that starts at zero when th...

Page 69: ...2 049 bytes FUP allocates two pages 0 maximum REC S specifies the extent size based on the current settings for record length REC data block length BLOCK index block length IBLOCK key field lengths and compression settings Possible values are 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 The FUP...

Page 70: ...ctured Enscribe files can be even or odd FUP rounds up any odd byte count that you give to an even unstructured file for reading writing or positioning This is the default for unstructured files FUP does not round odd unstructured files up You always read write or position at the byte count you give To change an odd unstructured file to an even unstructured file copy the odd file into a new file t...

Page 71: ... application does not require complete consistency you might not need to reload the alternate key file Altering the UNIQUE attribute of an alternate key for a file makes the file description inconsistent with its alternate key files Subsequent attempts to open the file cause file system error 4 failure to open an alternate key file To use the file after the UNIQUE attribute for an alternate key is...

Page 72: ...1 CODE 10 To cause the file label for MYFILE2 to be updated whenever the file control block FCB changes ALTER MYFILE2 REFRESH 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 ...

Page 73: ...imary file whose alternate key records are to be generated You must have previously defined alternate key fields for the primary file You cannot use wild card characters or specify qualified fileset for primary filename out filename names an existing file where the alternate key records generated by this command are to be written out filename can be an existing disk file a nondisk device a process...

Page 74: ...fies the format and control of out filename out option is any one of BLOCKOUT out block length DENSITYOUT density EBCDICOUT PAD pad character RECOUT out record length NO REWINDOUT SKIPOUT num eofs TAPEMODE mode NO UNLOADOUT XLATE xlate table name XLATEIN xlate table name XLATEOUT xlate table name BUILDKEYRECORDS Guidelines BUILDKEYRECORDS causes the primary file to be read sequentially according t...

Page 75: ...records are not built because the full alternate key does not exist within the primary record this message appears nnn RECORDS CONTAIN INCOMPLETE ALTERNATE KEY FIELDS ALTERNATE KEY RECORDS NOT GENERATED BUILDKEYRECORDS cannot handle SQL files BUILDKEYRECORDS Example To generate the alternate key records for MYFILE using key specifications ab and cd and write the alternate key records to TAPE BUILD...

Page 76: ...M Guidelines Although CHECKSUM reads each block of data from each file specified by fileset list and recomputes a checksum value for each one it rewrites only blocks whose checksum values are incorrect Checksum errors usually indicate a potential data integrity problem CHECKSUM recomputes the checksum value for blocks of data but does not fix any data that might have changed If a Peripheral Utilit...

Page 77: ...is example assume that a checksum error for DATA appears on the operator console and that DATA contains these SQL and Enscribe files An SQL table named KSTABLE An index on KSTABLE named KSTABLEI An SQL protection view named PVIEW that depends on table KSTABLE An SQL shorthand view named SVIEW that also depends on KSTABLE An SQL program file named OFILE A structured Enscribe file named SFILE An uns...

Page 78: ... any of the COPY options except SOURCE or TARGET file names for example EBCDICIN BLOCKIN 4096 By default no COPY options are configured For more information see COPY Copy Form on page 2 36 CONFIG URE config command config params config command is command option environment option command option is COPY copy option copy option DUP LICATE dup option dup option LOAD load option load option LOADALTFIL...

Page 79: ... see LOADALTFILE on page 2 138 RELOAD reload option reload option specifies any of the RELOAD options except filename for example NEW DSLACK 60 By default no RELOAD options are configured For more information see RELOAD on page 2 148 RELOCATE SOURCEDATE By default no RELOCATE options are configured For more information see RELOCATE on page 2 154 ALLOW allow option allow option specifies the number...

Page 80: ...h the FUP process cannot recover always cause FUP to terminate abnormally Note Table 2 1 shows FUP responses to warnings and error types when ALLOW ABENDS is ON or OFF Table 2 1 Response to ALLOW ABENDS ON or OFF Type of Error ALLOW ABENDS OFF ALLOW ABENDS ON Warning Warning allow count is decremented If allow count 0 the command continues If allow count 0 the command fails Warning allow count is ...

Page 81: ...citly overridden on the command ECHO OBEY specifies that FUP should display the FUP commands that are executed in a command file to the home terminal or list file If you specify the ECHO OBEY option in a command file including the FUPCSTM or FUPLOCL files it causes an echo to start on the next command in the file You can specify CONFIGURE and OBEY on the same command The ECHO option without any pa...

Page 82: ... currently running The size is expressed in units of 1024 bytes You must specify the size using numbers from 4 through 28 For example 28 specifies 28 KB block transfers FUP rounds numbers down to the nearest 4KB units By default FUP uses 28 KB transfers when the files are not local and 56 KB transfers for local files NO PROMPT PURGE specifies if you want to be prompted prior to any PURGE processes...

Page 83: ...n the CHARMAP file CHARMAP is the default TEXT specifies a user created translation table If you specify TEXT you must also specify filename FUP expects the translation table to be the first 512 bytes of an unstructured file from the first record of a structured file If the record is either longer or shorter than 512 bytes FUP issues a warning message Because FUP does not read filename until neede...

Page 84: ... option in a DUP A B SOURCEDATE command can override a SAVEALL option used in a CONFIGURE DUP SAVEALL command SOURCEDATE and SAVEALL are in the same family of options and the explicit option in the DUP command overrides the option in the CONFIGURE command Because CONFIGURE remembers options that contain file or volume names such as DUP ALTFILE filename or LOAD PARTOF volume you must be careful The...

Page 85: ...to fit the file or device record length The output format for all other FUP commands that output information is 80 columns regardless of the value specified for REPORTWIDTH You can specify translation table defaults for COPY LOAD and BUILDKEYRECORDS commands If you use the XLATE option but an XLATE table was not specified in the CONFIGURE command an error occurs If you specify PAD or TRIM characte...

Page 86: ... options from the previous example to demonstrate the ECHO CONFIGURE option CONFIGURE ECHO CONFIGURE DUP A B SAVEALL CONFIG PURGE SAVEID FILES DUPLICATED 1 The CONFIGURE options that FUP reads PURGE and SAVEID are displayed In this example the SAVEALL option overrides the SAVEID option To use and reset CONFIGURE options that do not have named defaults CONFIGURE COPY UNSTRUCTURED COPY PART1 MOOSE P...

Page 87: ...hat is contained in the standard CHARMAPS translation tables and use it to translate a file from TAPE CONFIGURE XLATE belgianswiss CHARMAP COPY TAPE FILEB XLATEOUT belgianswiss You do not have to specify the name belgianswiss if it was the last or only XLATE table declared However it must be defined in SYSTEM SYSTEM ZCHARMAP To customize your options for your FUP RELOAD commands NO DEALLOCATE RATE...

Page 88: ...y records in a file optionally in different formats Use the DUP LICATE command to create identical copies of disk files Use the LOAD command to create a structured disk file from scratch It is much faster than the COPY command Use the Copy Form of the COPY command to make a record by record copy from one file to another Note For information on displaying file contents with the COPY command see COP...

Page 89: ...rs when you use FUP interactively causing the home terminal to be the IN file 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 TAPEMOD...

Page 90: ...epends on the file type specified for the destination file control option controls the method used for copying COUNT num records is the number of records to copy If you omit COUNT and do not use the FIRST option FUP copies all records from the first record through the end of file EOF If you omit COUNT and use FIRST FUP copies all records from the file indicated by FIRST through the EOF FIRST ordin...

Page 91: ...ings and integers if specified in square brackets For example specify a key value as the ASCII string T905 followed by a word containing the integer value zero and a word containing the integer value nine T905 0 0 0 9 KEY64 record spec specifies the 64 bit key value for the starting record of an entry sequenced file FUP begins reading the input file at the record you name as KEY64 key specifier is...

Page 92: ... normally used with structured disk files BLOCKIN in block length specifies the number of bytes in an input block This number can be a value in the range 1 through 32 767 indicating the actual number of bytes requested in a single physical read operation Input records are blocked if in block length exceeds in record length Records of the specified length are extracted from the input block until th...

Page 93: ...only to any IN relative files The default is COMPACT empty records are ignored and records that follow an empty record in the OUT file are renumbered If you specify NO COMPACT COPY transfers empty records from the IN relative files If you select the COMPACT option and the source is a relative file that contains empty records this message appears source file EMPTY RECORD FOUND AND NOT TRANSFERRED T...

Page 94: ...xactly in record length bytes the last record of the file might be less The read count is the number of bytes actually read for all other files If you specify the TRIM option every trailing trim character is deleted from the input record The read count includes only the significant characters those not trimmed If you omit the RECIN option FUP determines the in record length value If in filename is...

Page 95: ...r FUP to distinguish between the end of an intermediate volume and the EOF the value of num reels must be correct If you include the REELS option in the COPY command and in filename is a tape DEFINE FUP displays this error message ERROR REELS PARAMETER NOT ALLOWED FOR LABELED TAPES If you omit REELS in filename data transfer terminates when FUP encounters a single EOF mark Labeled tape handling fo...

Page 96: ...s EOF marks 1 multiplied by num eofs and then moved forward and positioned immediately ahead of the last EOF mark passed If you specify a value of zero the SKIPIN option is ignored If you omit the SKIPIN option the tape remains at its current position and the data transfer begins with the next physical record on tape TRIM trim character deletes any trailing characters matching trim character Speci...

Page 97: ... is filled with out record length records until it contains out block length bytes or the last output record is encountered If out block length is not a multiple of out record length the last record in a full block is truncated If the write count for a record is less than out record length the output record is padded in the output block with trailing nulls The actual number of bytes written in a p...

Page 98: ...E must either be unspecified or must match density If the DENSITY attribute is unspecified it is set to density for the life of the FUP command EBCDICOUT specifies that output characters be translated to their EBCDIC equivalents If you omit EBCDICOUT FUP does not translate output All characters converted between ASCII and EBCDIC retain their own image with these exceptions If you specify EBCDICOUT...

Page 99: ... ASCII character inside quotation marks c An integer in the range 0 through 255 that specifies a byte value 0 255 RECOUT out record length sets the maximum number of bytes in an output record If you specify the RECOUT option the actual number of bytes written for each output record the write count depends on whether you also specify the PAD option If you do not specify PAD the write count is eithe...

Page 100: ...If you specify an out block length greater than 4096 the value of out record length is 4096 If you do not specify out block length and out filename is an unstructured disk file or a process out record length is 132 If you do not specify out block length with the FUP BLOCKOUT option or the BLOCKLEN attribute of a tape DEFINE and out filename is a structured disk file or a nondisk device FUP uses th...

Page 101: ...PEMODE mode indicates the mode in which the tape is written for streaming drives only The mode can be either STARTSTOP or STREAM If you do not specify TAPEMODE the default STARTSTOP mode is used for the tape operation STARTSTOP selects the start stop mode for the tape operation STARTSTOP is the default STREAM selects the streaming mode for the tape COPY operation You must also specify the largest ...

Page 102: ... has three records MYSELF COMPUTERS and INC and uses a BLOCKOUT length of 30 to illustrate VAROUT 000006 Record length word for record 1 M Y S E Record 1 L F 000011 Record length word for record 2 C O M P U T Record 2 E R S 177777 Record length word for end of block p p Padding The third record INC could not be written in the sample block because its record length word requires six bytes beginning...

Page 103: ...pended to the end of the file Existing data is not overwritten If the destination of the copy is a key sequenced file COPY places the records in the appropriate location instead of appending them to the end of the file If in filename is in the EDIT file format each text line is treated as a logical record with a count read attribute Unstructured files are different Each physical read except possib...

Page 104: ...f bytes read Although you can specify a block size of as many as 32 767 bytes for the BLOCKIN and BLOCKOUT options some peripheral devices have smaller maximum block sizes that must not be exceeded when you use the COPY command If you copy a file that contains data records and zero length records empty records to a relative output file all the records are written including the zero length records ...

Page 105: ...minal of the FUP process WARNING filename DRIVE DOES NOT SUPPORT DENSITY SELECTION If you enter the TAPEMODE parameter to a tape drive that does not support the setting this warning message appears on your terminal and the COPY operation continues without trying to set the tape mode WARNING filename DRIVE DOES NOT SUPPORT TAPEMODE SELECTION The COPY command cannot copy SQL files that are not SQL o...

Page 106: ...e 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 FILEZ with a primary key value specifying the starting record for FI...

Page 107: ...ASE SAMPLE FILEZ 12MAY01 DATA MODIF 26APR2001 14 19 This is a sample file to show how the TITLE option within FUP COPY works 4 RECORDS TRANSFERRED Commands Related to Copy Copy Form COMMAND Function Page DUP LICATE Creates identical copies of disk files 2 64 LOAD Creates a structured file from scratch 2 131 CONFIG URE Sets options for the COPY command 2 26 ...

Page 108: ...scribes only display option syntax For a complete COPY syntax description see COPY Copy Form on page 2 36 display option specifies the display format for the file If you omit display option no formatting or conversion occurs and each record is displayed as it appears in in filename OCTAL or O displays in octal and ASCII format DECIMAL or D displays in decimal and ASCII format HEX or H displays in ...

Page 109: ...PY process and the last modification time of the file Copy Display Form Listing Format Example 2 1 shows the format FUP COPY uses to display files The headers and variables in Example 2 1 are Example 2 1 COPY Command Listing Format filename RECORD rec num KEY xx yy LEN length value mm dd yy hh mm offset word 0 word 1 word n ASCII format filename is the name of the file being displayed RECORD rec n...

Page 110: ...9 otherwise n 11 ASCII format is the ASCII representation of the line to the left Nonprintable characters are represented by a period If you specify only ASCII or A the display is in ASCII format and offset is given in decimal representation COPY MARYHAD FIRST 20 COUNT 6 RECIN 20 OCTAL BASE FUPDOC MARYHAD RECORD 20 KEY 2048 4000 LEN 20 0 046541 071171 020150 060544 020141 020154 Mary had a l 6 064...

Page 111: ... page 2 173 During the file creation process DP2 rounds up the extent size to 2 pages or 4 096 bytes because the extent size of DP2 files must always be an integral multiple of the BUFFERSIZE for unstructured files or of the BLOCK size for structured files To create an unstructured DP2 file with one page extents you must specify a BUFFERSIZE of 2048 bytes with either the FUP SET or FUP CREATE comm...

Page 112: ...mmand accepts a non zero partial key value for the first secondary partition However a subsequent CREATE command by the user fails and the error FEINVKEY is returned 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 To create a partitioned unstructured file where one or more partitions reside on a ...

Page 113: ...ting file SET LIKE VOLnn Subvol first alternate keyfile 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 n...

Page 114: ...et list PARTONLY specifies the deallocation of any unused extents for all the primary or secondary partitions of partitioned files in fileset list If you reference a primary partition name only the extents are deallocated from the primary partition If you omit PARTONLY extents are deallocated only for entire partitioned files the primary partition must be specified in fileset list and it is an err...

Page 115: ...ary partitions but the extents of the primary partition remain unchanged DEALLOCATE command with PART ONLY option and fileset list as primary partition of an enhanced key sequenced file is executed but the extents of the primary partition remain unchanged DEALLOCATE Example To deallocate the unused extents past the EOF of MYFILE DEALLOCATE MYFILE Commands Related to DEALLOCATE DISPLAYBITS Lets the...

Page 116: ...he name of a file in from fileset list you must specify the file name part of to fileset with the wild card character To duplicate a Safeguard protected file you must have read access to the file to fileset is a file set specifying the destination of the duplication You cannot specify qualified fileset for to fileset COPY To change file attributes or copy files to or from nondisk devices DUP LICAT...

Page 117: ...ile FUP creates for the RESTARTABLE DUP operation The name must not be the same as any file name in the specified subvolume the source file name or the destination file name If you specify only the file name part for restart filename the name is expanded using the current default names for volume and subvolume The restart file is not created until after the destination file is successfully created...

Page 118: ...r key file number in a SET or CREATE command is invalid if FUP changed it to a standard DP2 number PART sec partition number node volume pri extent size sec extent size specifies a new name for a secondary partition of a partitioned file If you specify PART the name of the partition indicated by sec partition number is replaced by the new partition name you specify The indicated sec partition numb...

Page 119: ... fileset list in these areas if applicable file type record size data block size data and index compression mode and key length and key offset The extent size of the files in to fileset might differ The files you specify for to fileset must be large enough to contain the from fileset data Existing data in to fileset is overwritten FUP uses only one of these options KEEP NEW OLD or PURGE If more th...

Page 120: ...the timestamp to the time the DUP LICATE process completes The SAVEALL option is equivalent to the SAVEID and SOURCEDATE options FUP uses only one of these options SAVEALL SAVEID or SOURCEDATE If more than one is specified FUP uses the last one specified SAVEID transfers the owner ID and security of the files named in from fileset list to to fileset with no changes If you omit SAVEID and SAVEALL F...

Page 121: ...ES If you use the DUP command to duplicate a file that is audited by TMF the new file is not an audited file To restore audited status to a file use an ALTER AUDIT command If you use the OLD parameter you can use the DUP LICATE command and change the extent sizes Before you use the DUP LICATE command you must create the OLD file with the new extent sizes The SAVEID and SAVEALL options Preserve the...

Page 122: ...he restart file created by H01 version of FUP cannot be used with H02 version of FUP and vice versa DUP LICATE Guidelines for Safeguard Files To duplicate a Safeguard protected file you must have read access to the input file from fileset list and create access to the destination volume and subvolume to fileset Unless you have create access using Safeguard to it the target file is not created succ...

Page 123: ...ternate key file file 0 of the destination file VOL2 RECD ALTFILE DUP VOL1 RECD DATA VOL2 ALTFILE 0 VOL2 RECD ALTFILE To duplicate a partitioned file in a different node and rename the secondary partition of the destination file TWO VOL2 SUB1 PARTFILE DUP VOL1 SUB1 PARTFILE TWO VOL1 PART 1 TWO VOL2 When you duplicate a partitioned file in a different node or volume to duplicate a secondary partiti...

Page 124: ...terpreter EXIT Guidelines To run the EXIT command you can enter E or EXIT 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 If you press CTRL Y at the...

Page 125: ... FC DUP quoted is a string enclosed in either single or double quotation marks FUP searches every character in the command buffer not just the first characters until it finds the string For example to display the most recent command that referenced the system KAUAI enter FC KAUAI To edit the command use the space bar and the backspace key to position the cursor under the text that you want to chan...

Page 126: ...ing subcommand R is assumed The subcommand begins its operation at the character positioned directly above it FC displays the modified line and prompts for another subcommand Specify more than one subcommand per line by separating the subcommands with a double slash To abort the FC command and not execute the modified command press the BREAK key or the CTRL and Y keys or enter a double slash in co...

Page 127: ...rameter can use the wild card option in both the subvolume name and the file name If fileset is not specified it defaults to all files in the subvolume You can specify qualified fileset for fileset FILENAMES Example To display the names of all the files containing OLT in all the subvolumes of the current volumes that start with FUPKIR FILENAMES FUPKIR OLT BASE FUPKIR NOLT NOLTE OLTR ROLT XOLT XOLT...

Page 128: ...lume You can use a wild card character for subvolume but you cannot specify qualified fileset for subvolset To specify qualified fileset use the FILENAMES command If you omit node FUP lists the designated file names on the current default node If you omit volume FUP lists the designated file names on the current default volume If you include volume you must also include subvolume or an asterisk If...

Page 129: ... FILES To list the names of the files in each subvolume of the current default volume FILES To list the names of all the files in each subvolume on the volume VOL2 FILES VOL2 To list the names of all files in the subvolume JIMMY of the volume ACES on the node TENNIS FILES TENNIS ACES JIMMY This example assumes that the current default node is SYS1 the current default volume is VOL1 and the current...

Page 130: ...If you omit PARTONLY only entire partitioned files whose primary partitions reside in fileset list are given PARTONLY has no effect on nonpartitioned files GIVE Guidelines A Super Super user is allowed to change the ownership of a Safeguard protected file if the underlying persistent protection record does not explicitly DENY ownership permission to Super Super A non Super Super user is allowed to...

Page 131: ...ess that has it open are not affected If you give a program file whose PROGID bit is set the GIVE command clears that bit To set the PROGID bit use the FUP SECURE command If the bit is set the accessor ID is set to the ID of the program file when the program is run Files that you give to another user remain in their original subvolume To move a copy of a file to another subvolume use FUP DUP After...

Page 132: ...FUP displays help for the first command that matches the characters entered ALL lists the names of all FUP commands The default is ALL ALL SYNTAX lists the syntax for all the FUP commands NEWS provides a one line description for each significant new FUP feature in the last several RVUs This informal information source does not describe syntax and does not necessarily include every new feature The ...

Page 133: ... output to the file num is the number of previous commands to display HISTORY Guidelines If you omit num FUP displays the last 10 commands If num is greater than the number of commands in the history buffer FUP displays all the commands in the buffer The HISTORY command display shows line numbers for each command You can use line numbers in the FC or commands Line numbers are not displayed anywher...

Page 134: ...ular table or index FUP short INFO for a TABLE PARTITION or INDEX PARTITION displays the information about the partition of the table or the index 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 OUT listfile names an existing disk file or device to receive the listing output of the FUP INFO com...

Page 135: ... other characters For example to display information for all temporary files that end in 1 INFO 1 The command INFO does not display temporary files ansiname list ansiname list ansiname ansiname identifies SQL MX ANSI name tables indexes partitions of tables and indexes and any combination of these objects A single quote is required to precede and delimit each ansiname The ANSI names syntax is in a...

Page 136: ...tion on file characteristics including SMF information Use the DISPLAYBITS option from the CONFIGURE command with INFO DETAIL when the file contains alternate keys containing 8 bit characters 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...

Page 137: ...at you own INFO Guidelines If a transaction is still open INFO specifies files that were opened and closed during the transaction as open The files still have outstanding locks against them The LISTOPENS command does not specify these files as open because the files do not have any openers When a listed file is purged during the execution of the INFO command INFO displays Error 11 File not in dire...

Page 138: ...isplays the logical file name in the DETAIL display If the DETAIL option is omitted FUP displays its standard output for files in ZYS and ZYT subvolumes FUP might append G in the INFO listing or GMT in the INFO DETAIL listing to the last modification date and time for Enscribe files or to any timestamp for SQL MP and SQL MX files These letters indicate the displayed time is in Greenwich mean time ...

Page 139: ...OSS files Example 2 2 INFO Listing Format CODE EOF LAST MODIF OWNER RWEP TYPE REC BL node volume subvolume name open code eof mod owner sec type rec bl state null The file is not open failed or broken C The file is corrupt A corrupt file is a file whose contents are in question DUP and LOAD mark the destination file as corrupt while these operations are performed If the operation does not complete...

Page 140: ...e entry for which FUP cannot read the last modification time owner is the identification number of the file owner group num user num The super ID 255 255 is given as 1 sec is the security level assigned to the file rwep Values for rwep are A TMF audits the file L The file is licensed For more information see LICENSE Super ID on page 2 117 P The PROGID attribute of the file is on For more informati...

Page 141: ...cter OSS security vector appears in the RWEP column The vector extends into the TYPE column For more information see the Open System Services User s Guide Note If an OSS file has a POSIX ACL protection FUP INFO displays a plus sign after the permissions However if FUP INFO is executed remotely from a system without ACL support will not be printed for files with optional ACL entries This feature is...

Page 142: ...file 103 trace data file 105 TAL GLOBAL file 106 TAL Error log 107 Runtime data unit file 110 EDIT VS recovery file 111 EDIT VS stack dump file data area image 115 TEDIT TEDPROFL file 120 126 Spooler control files 127 Spooler data file 128 Spooler control file 129 Spooler job file 130 Inspect save file 131 INSPECT file 133 TMF control file 134 TMF audit trail file 141 Compressed dump file 142 CPU ...

Page 143: ...ct build list file 205 DDL record definition file 206 DDL key definition file 207 DDL constant definition file 208 DDL object usage file 209 DDL token file 210 Pathmaker INSTALLS file 223 Enable log file 230 232 ADA data file 249 TRANSFER remote open control file 250 Transfer profile file 251 Transfer session file 252 Transfer item descriptor file 253 Transfer recipient file 254 Transfer folder fi...

Page 144: ...base monitor sample file 282 Transfer System Management Monitor queue monitor sample file 283 290 Transfer file 291 TRANSFER P1 message id file 292 TRANSFER P2 message id file 293 TRANSFER P2 ITEMID file 294 TRANSFER alternate name file file 295 TRANSFER remote name file file 296 TRANSFER directory services data file 297 TRANSFER R Justify file file 298 VIEWPOINT help text file or a TRANSFER Depot...

Page 145: ...nted save file 431 TMF online dump file 432 BACKUP Dump files 440 TACL saved variable segment file 444 OSS file system mapping files 448 FATTY Memory Tool file 450 C00 file server and ViewPoint status display configuration file 451 Event display configuration file 460 462 SMS catalog files 470 Wire wrap list output file 480 SRL Registry Catalogue 481 SRL entry vector initial instance data SRLINIT ...

Page 146: ...database 549 Encrypted file 550 565 SQL MX files 566 568 SQL MP file 569 SQL scratch file 571 NonStop SQL catalog file 572 NonStop SQL base tables file 573 NonStop SQL columns file 574 NonStop SQL comments file 575 NonStop SQL constraints file 576 NonStop SQL files file 577 NonStop SQL indexes file 578 NonStop SQL keys file 579 NonStop SQL partions file 580 NonStop SQL programs file 581 NonStop SQ...

Page 147: ...ION hard db file 652 ENVISION map db file 653 ENVISION tmf db file 654 ENVISION model db file 660 Encore capture file 661 664 Encore file 665 NETTACL TRACE file 666 NETTACL MOVIE file 667 ESCORT SYSDB 668 ESCORT MAPDB 669 Encore file 675 ES FASTCONNECT log file 700 TNS R native object file 701 PTAL GLOBAL file 703 pTAL file 706 pTAL file 710 CSS load module 711 PCSLAM manuals data file 720 723 RDF...

Page 148: ... database file 851 SNAX5 configuration file 852 NonStop CLX shutdown file 853 854 Optical disk file 855 FUP restart file 858 ORSERV status file 859 ODBC Catalog table 860 NSR millicode file 861 T16 only runnable object 862 Liberty only runnable object 863 SysHealth event alternate key file 870 Himalaya millicode file 880 RISC millicode file 881 NSK Disk and Tape Boots 882 SLSA Downloadable library...

Page 149: ...r an SCOMPRES archive file 990 Chameleon II Dump File 991 Not yet determined 992 NETMASTER help file 1000 SAFETNET key control file 1001 PRS TPR file 1002 Security card initialisation file 1003 PRS TPR file 1004 PRS TPR file 1012 PRS TPR file 1053 1057 PNA file 1100 SAFETNET key control file 1666 Transfer UOWTEST data file 1729 TNSC PAK UNPAK file 2000 SAFETNET key control file or a DOCUSYS saved ...

Page 150: ...e 5305 TTSI ERAD detail text file 5306 TTSI ERAD log file 5307 TTSI ERAD repair procedure file 7878 TTSI Help file 9613 CRUNCH sysgen save file 9614 CPU dump file 11111 SEEVIEW trace file 19789 NSS Log file 22222 TTSI TSMS file Example 2 3 INFO Listing Format INFO FILE CODE EOF LAST MODIF OWNER RWEP TYPE REC BL VOL1 SVOL PARTFILE 3072 14AUG2000 14 55 8 1 AO PKA 80 1 MYFILE 5120 22JAN2001 11 44 8 4...

Page 151: ...6 on page 2 100 One for SQL views The information that appears depends on whether you are inquiring about a table index or file and whether or not the organization is key sequenced Information is not shown if it is irrelevant or is not set for the specific file Example 2 5 Short INFO for OSS Files With POSIX ACL SYSTEM SYSTEM 1 fup info OCTOPUS OSS ZYQ00001 Z0000010 CODE EOF LAST MODIF OWNER RWEP ...

Page 152: ...d length RECLENGTH max record length BLOCK block length 9 IBLOCK block length KEY key descriptor SYSKEY LOCKLENGTH lock length DCOMPRESS ICOMPRESS 10 INDEX key spec FILE alt fnum file name ALTKEY key descriptor UNIQUE NO UNIQUE UPDATE NO UPDATE NULL null value 11 PART part num volume pri ext PAGES sec ext PAGES MAXEXTENTS max ext firstkey value 12 ODDUNSTR REFRESH AUDIT BUFFERSIZE BUFFERED AUDITCO...

Page 153: ... MX Database and Application Migration Guide If the file is an index BASE TABLE is the underlying table 3 PHYSICAL FILENAME indicates a logical file by its logical name VIRTUAL FILENAME indicates a logical file by its physical name 4 TYPE indicates the file organization 5 FORMAT is the new file s format designator which can have these values If you omit the FORMAT option the system decides the fil...

Page 154: ...e or more sets of these items the number of sets is determined by the number of columns in the key COLUMN col num OFFSET key offset TYPE col type LENGTH key length ASC DESC COLUMN number indicates the position of the key column in the row If the row contains a system defined primary key the primary key is column 0 Otherwise the first column defined for the table is column 0 OFFSET indicates the ze...

Page 155: ...ed without the partition key The partition key information for SQL MX objects is available from MXCI SHOWDDL 12 Describes file attributes 13 OWNER is the user ID of the file s owner This section also displays the security string of the file which indicates whether the PROGID TRUST and CLEARONPURGE attributes are set whether the LICENSE attribute is set and when you can purge the file TRUST trust f...

Page 156: ...sed parameter is the amount of available file space currently used based on available space BLANK The file is not open failed or broken BROKEN The file is open but received an I O or consistency check failure and needs media recovery CORRUPT The file is corrupt The contents of the file are in question DUP and LOAD mark the destination files as corrupt while these operations are being performed If ...

Page 157: ...ITION DATE fields also appear for protection views only If the partition is on the current node the node name does not appear The LABEL QUESTIONABLE and DEFINITION INVALID fields are open states The DETAIL listing format for SQL MX objects contains the same type of information as for SQL MP objects except object type differentiates between different SQL MX objects including ANSI tables ANSI indexe...

Page 158: ...SCRIBE TYPE E FORMAT 1 EXT 1 PAGES 1 PAGES REC 80 BLOCK 4096 MAXEXTENTS 16 OWNER 1 40 SECURITY RWEP CUCU DATA MODIF 14 Apr 2001 16 59 CREATION DATE 10 Apr 1997 16 00 LAST OPEN 14 Apr 2001 18 00 EOF 0 0 0 USED FILE LABEL 214 5 2 USED EXTENTS ALLOCATED 0 To show the FUP INFO DETAIL listing for PARTFILE a key sequenced partitioned file with alternate keys INFO PARTFILE DETAIL VOL1 SVOL PARTFILE 11 No...

Page 159: ...EXT 228 PAGES 64 PAGES ODDUNSTR MAXEXTENTS 978 BUFFERSIZE 4096 OWNER 1 SECURITY RWEP NONO LICENSED DATA MODIF 29 Apr 2000 16 43 OPEN CREATION DATE 2 Jul 1997 14 10 LAST OPEN 3 Jul 2000 16 48 FILE LABEL 342 8 4 USED EOF 4909056 3 8 USED EXTENTS ALLOCATED 35 To show the FUP INFO DETAIL listing for a logical file by its logical name INFO BALL CAROLS FILE DETAIL BALL CAROLS FILE 3 Jul 2000 16 49 ENSCR...

Page 160: ... 0 File attributes are set using the SET command in this example The SHOW command displays the results of the attributes assigned by the previous SET commands SET TYPE K SET KEYLEN 2 SET ALTKEY AA FILE 0 KEYLEN 2 KEYOFF 0 INSERTIONORDER SET ALTFILE 0 ALT0 SHOW TYPE K FORMAT 1 EXT 1 PAGES 1 PAGES REC 80 BLOCK 4096 IBLOCK 4096 KEYLEN 2 KEYOFF 0 ALTKEY AA FILE 0 KEYOFF 0 KEYLEN 2 INSERTIONORDER ALTFI...

Page 161: ...ble INFO T2 DETAIL DATA00 TEST T2 19 May 2003 17 08 SQL BASE TABLE CATALOG DATA00 TEST VERSION 350 TYPE K FORMAT 1 EXT 16 PAGES 64 PAGES MAXEXTENTS 160 REC 46 PACKED REC 46 BLOCK 4096 KEY COLUMN 0 OFFSET 0 LENGTH 4 ASC PART 0 DATA00 16 PAGES 64 PAGES MAXEXTENTS 160 FORMAT 1 2147483648 PART 1 D72GB1 16 PAGES 64 PAGES MAXEXTENTS 160 FORMAT 1 40 AUDIT BUFFERED AUDITCOMPRESS OWNER 1 SECURITY RWEP NUNU...

Page 162: ...information about all subvolumes that begin with ER INFO ER DETAIL GUEST ERIC TACLCSTM 13 Aug 2000 14 04 ENSCRIBE TYPE U CODE 101 FORMAT 1 EXT 4 PAGES 16 PAGES MAXEXTENTS 16 BUFFERSIZE 4096 OWNER 96 27 SECURITY RWEP NUNU DATA MODIF 22 Jun 1999 10 25 CREATION DATE 22 Jun 1997 10 25 LAST OPEN 7 May 2000 15 32 EOF 80 0 0 USED FILE LABEL 214 5 2 USED EXTENTS ALLOCATED 1 GUEST ERD A 13 Aug 2000 14 04 E...

Page 163: ...rmation for a partitioned SQL MX table INFO IIP3BN00 DETAIL DATA04 ZSD4897J IIP3BN00 2 Sep 2003 4 36 SQL ANSI TABLE ANSI NAME CAT SCH SACHIN_JOHN RESOURCE FORK APACHE DATA04 ZSD4897J IIP3BN01 SYSTEM METADATA APACHE DATA04 ZSD0JUL VERSION 1200 TYPE K FORMAT 2 CODE 550 EXT 16 PAGES 64 PAGES MAXEXTENTS 160 PACKED REC 8 BLOCK 4096 KEY COLUMN 0 TYPE 0 LENGTH 0 ASC PART 0 APACHE DATA04 ZSD4897J IIP3BN00...

Page 164: ...PART 2 DRP42 DATA2 ZSDHKPKT KD973500 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 WTK93500 AUDIT BUFFERED AUDITCOMPRESS OWNER 1 SECURITY RWEP SQL DATA MODIF 27 Oct 2005 23 34 CREATION DATE 16 Oc...

Page 165: ... t recs is the total number of records at the indicated level At the DATA level t recs is the total number of data records in the file a recs is the average number of records for each block at the indicated level 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 Example 2 8 INF...

Page 166: ...ng for a key sequenced partitioned file INFO PARTFILE STATISTICS DETAIL option listing displays first followed by this TOTAL TOTAL AVG AVG AVG LEVEL BLOCKS RECS RECS SLACK SLACK PART 1 1 1 1 0 996 97 VOL1 DATA 1 12 12 0 338 33 FREE 1 1 1 7 7 0 938 92 VOL2 DATA 7 117 16 7 77 8 FREE 1 To display the FUP INFO STATISTICS listing for a key sequenced partitioned file with 48989 records and an EOF of 698...

Page 167: ...S PARTONLY listing for a partitioned SQL MX table using ANSI name INFO TABLE CAT_ANSINAME01 SCH_ANSINAME01 TAB1 STAT PARTONLY DATA05 ZSDHKPKT CGJC4500 16 Nov 2005 0 38 SQL ANSI TABLE ANSI NAME CAT_ANSINAME01 SCH_ANSINAME01 TAB1 RESOURCE FORK DRP42 DATA05 ZSDHKPKT CGJC4501 SYSTEM METADATA DRP42 DATA05 ZSD0 VERSION 1200 TYPE K FORMAT 2 CODE 550 EXT 16 PAGES 64 PAGES MAXEXTENTS 160 PACKED REC 12 BLOC...

Page 168: ...INFO EXTENTS listing for PARTFILE a key sequenced partitioned file INFO PARTFILE EXTENTS VOL1 SVOL PARTFILE 11 03 99 14 45 EXTENT OF PAGES STARTING PAGE PART 0 1 12246 VOL1 1 1 12247 Example 2 9 INFO EXTENTS Listing Format filename date and time EXTENT OF PAGES STARTING PAGE PART extent num num pages start page name filename Is the name of the file being listed by FUP INFO date and time Indicates ...

Page 169: ...DRP42 DATA3 ZSDHKPKT L9G93500 0 16 2356668 DRP42 DATA4 ZSDHKPKT NQW83500 0 16 2020401 DRP42 DATA05 ZSDHKPKT P1G73500 0 16 5728736 DRP42 DATA1 ZSDHKPKT PJ183500 0 16 364775 DRP42 DATA2 ZSDHKPKT Q6KB4500 0 16 15263928 DRP42 DATA3 ZSDHKPKT SVS83500 0 16 2356636 DRP42 DATA4 ZSDHKPKT WTK93500 Commands Related to INFO LICENSE Super ID Allows nonprivileged users to execute programs that contain privilege...

Page 170: ...CENSE Super ID Examples To let nonprivileged users run the privileged program stored in the disk file MYPROG if the SUPER ID enters the command LICENSE MYPROG To let nonprivileged users run any of the privileged programs stored in the current subvolume with a file code of 100 if the super ID enters the command LICENSE WHERE FILECODE 100 Commands Related to LICENSE Super ID LISTLOCKS Displays infor...

Page 171: ...es indexes partitions of tables and indexes and any combination of these objects A single quote is required to precede and delimit each ansiname The ANSI names syntax is in accordance with Unified Syntax Proposal The syntax is SQL name is used to name 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 objec...

Page 172: ...ifies to list only currently granted locks Locks in a waiting state are not shown DETAIL specifies that the internal LOCK STATE is displayed PARTONLY specifies to list only the locks against the specified partition LISTLOCKS Listing Format Example 2 10 shows the format the FUP LISTLOCKS command uses to display file information The first line lists the file name specified in the LISTLOCKS command N...

Page 173: ... is displayed This value can wrap around to the next line For unstructured files the relative byte address is displayed For entry sequenced files the record address is displayed For relative record files the record number is displayed The key field cannot be longer than the generic lock length for generic key locks Example 2 10 FUP LISTLOCKS DETAIL Listing Format node volume subvolume file id LOCK...

Page 174: ...cked row and the row that precedes it LK D Delete This lock is acquired for the row after a deleted row Use it to prevent scans from skipping uncommitted deletes LKDUS Delete This lock is acquired for the row after a deleted row Use it to prevent scans from skipping uncommitted deletes 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 ...

Page 175: ...rk Execute the LISTLOCKS command from a copy of FUP running on the remote node If you specify the primary partition of an Enscribe partitioned file LISTLOCKS displays lock information if any for all the partitions of the file 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...

Page 176: ...plays it in unsorted order 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 LEN KEY RECORD ADDRESS F GI DRP42 2 2 7784507 LOCK STATE LK IX R G DRP42 2 2 7784507 8 0 0 0 12 0 0 0 11 LOCK STATE LK UX LISTOPENS Lists the...

Page 177: ...th 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 identifies SQL MX ANSI Name catalogs schemas tables indexes partitions of tables and indexes and any combination of these objects A single quote is required to precede and delimit each ansin...

Page 178: ...r backup process respectively of a process pair a is the access mode e is the exclusion mode 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 Example 2 11 FUP LISTOPENS Listing Format node volume subvolume file id PID MODE USERID SD MYTERM PROGRAM F...

Page 179: ...TERM PROGRAM FILE NAME 215 01 0039 R W E 001 249 01 FOXII TC1 C13 GUEST FUPD00 FUP LISTOPENS Guidelines To get information on temporary files you must explicitly specify temporary file names using the character When you apply LISTOPENS to an SQL MP protection view it displays the processes that opened the view and the processes that opened the table view depends on You cannot apply LISTOPENS to an...

Page 180: ...isplays 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 The INFO command does show as open files that have been opened and closed during a transaction if the transaction itself is still open This situatio...

Page 181: ... SD MYTERM PROGRAM FILE NAME 042 02 0432 R S 255 255 15 ZTNT PTUJKRM SYSTEM SYSTEM MXCI 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...

Page 182: ...XCI DATA3 ZSDHKPKT SVS83500 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 DATA4 ZSDHKPKT NQW83500 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 DATA4 ZSDHKPKT WTK93500 ANSI NAME CAT_ANSINAME01 SCH...

Page 183: ...ilename destination filename load option load option is EMPTYOK FIRST ordinal record num KEY record spec key value key specifier ALTKEY key value PAD pad character in option key seq option 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 XLATE translation table name XLATEIN transl...

Page 184: ...mpty and you do not include the EMPTYOK option the LOAD command terminates and this message appears ERROR EMPTY SOURCE FILE If you include EMPTYOK and LOAD encounters an empty IN file this message appears RECORDS LOADED 0 FIRST ordinal record num KEY record spec key value key specifier ALTKEY key value names the starting record of the input file for the copy If you omit FIRST the copy starts with ...

Page 185: ...n marks or integers representing byte values in the range 0 through 255 You must enclose the list of strings and integers if specified in square brackets For example specify a key value as the ASCII string T905 followed by a word containing the integer value zero and a word containing the integer value nine T905 0 0 0 9 key specifier is a one character or two character string specified inside quot...

Page 186: ...KIPIN num eofs TRIM trim character NO UNLOADIN VARIN XLATE translation table name XLATEIN translation table name XLATEOUT translation table name key seq option is an option for specifying the loading of key sequenced files MAX num records is the number of records in in filename Specify num records as a whole number in the range 0 through 512000000 2048 1 This value does not need to be exact but it...

Page 187: ...nimum percentage of space required by index blocks and in data blocks for future insertions If space is not available when an insertion is made a block split occurs DSLACK percentage sets the minimum percentage of slack space in data blocks Specify percentage as a value in the range 0 through 99 If you omit this option FUP uses the SLACK percentage value ISLACK percentage sets the minimum percenta...

Page 188: ...e PARTOF option you receive an error message The FUP process loads all partitions if you do not specify PARTOF and destination filename is the primary partition To load a secondary partition specify the name of the secondary partition as destination filename and specify the name of the volume where the primary partition resides for the PARTOF option To load only the primary partition specify the n...

Page 189: ...n in relative files When alternate key records are not built because the full alternate key does not exist within the primary record this message appears nnn RECORDS CONTAIN INCOMPLETE ALTERNATE KEY FIELDS ALTERNATE KEY RECORDS NOT GENERATED LOAD cannot load SQL files You must use SQLCI LOAD instead You cannot use the FUP LOAD command on queue files Using the LOAD command can cause significant pro...

Page 190: ...LATE my_encrypt Commands Related to LOAD LOADALTFILE Generates from a primary file the alternate key records for a designated alternate key file and then loads the records into the file You can also specify the amount of slack space reserved for future insertions This command applies only to Enscribe files The LOAD command does not work on alternate key files COMMAND Function Page DUP LICATE Creat...

Page 191: ...rom primary filename The default is 10 000 000 Specify num records as a whole number in the range 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 SCR...

Page 192: ...nt record length key offset not zero or not a key sequenced file LOADALTFILE fails and displays ERROR ALT FILE IS INCOMPATIBLE WITH ALT KEYS 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 ...

Page 193: ...ommand 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 This option puts commands from a command file into the HISTORY buffer only if this option is enabled By default ECHO OBEY is enabled Any errors encountered during the execution of a command file are listed at the home terminal or li...

Page 194: ...owed by the PURGE prompt Type Y or y to purge the file If you type any other response the file is not purged If fileset list includes an entire volume or subvolume or if you use the wild card option to specify the subvolume or file ID you are prompted for permission to purge each file set as it is encountered in fileset list Type your answer from the four choices displayed and press RETURN If you ...

Page 195: ...f the list contains only one file If you omit the parentheses FUP treats LISTALL or NO LISTALL as file names If you omit the parentheses and specify NO LISTALL FUP returns a required delimiter is missing error message If you omit the parentheses and specify LISTALL FUP searches for a LISTALL file in the current default subvolume If no file with that name exists it returns file system error 11 file...

Page 196: ...the disk overwrites it with blank data and then deletes the file name from the directory 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 Examples To purge the file WKLYRPRT in the current default subvolume without prompting for perm...

Page 197: ...ire file set is purged If you type N no files are purged PURGE WKLYRPRT MONTHEND REQTOTAL CODE EOF LAST MODIF OWNER RWEP TYPE REC BLOCK MYVOL RECDS WKLYRPRT 2048 29MAR87 11 46 8 44 AOAO R 11 1024 PURGE Y MYVOL RECDS WKLYRPRT PURGED CODE EOF LAST MODIF OWNER RWEP TYPE REC BLOCK MYVOL RECDS MONTHEND 5120 29MAR87 11 44 8 44 AOAO R 10 1024 PURGE N CODE EOF LAST MODIF OWNER RWEP TYPE REC BLOCK MYVOL RE...

Page 198: ...mmand and the extents remain allocated until you issue a DEALLOCATE command for the file fileset list is a list of files from which data is to be purged Partial file names are expanded using the current default node volume and subvolume if necessary You can use wild card characters and can specify qualified fileset for fileset list Y ES N ONE S ELECT F ILES S CODE EOF LAST MODIF OWNER RWEP TYPE A ...

Page 199: ...r a PURGEDATA operation the FUP process tries to open the specified file with exclusive access If the file cannot be opened with exclusive access the PURGEDATA command fails for example if the file is already open The CLEARONPURGE option set with the FUP SECURE command has no effect on PURGEDATA After the PURGEDATA command is executed the data is physically present on the disk but inaccessible unt...

Page 200: ...mand You can use either a standard file name or a spool DEFINE name as the OUT listfile If listfile is an existing file FUP appends output to that file filename is the name of the key sequenced file or SQL object table or index only to be reorganized It can also be a secondary partition of a partitioned file For more information see PARTOF volume on page 2 150 You cannot use wild card characters o...

Page 201: ...is enclosed in double quotes Delimited identifiers are character strings that appear within double quote characters and consist of alphanumeric characters and other characters except for character and To include a double quote character in a delimited identifier use two consecutive double quotes A delimited module name in SQL MX can contain the circumflex character NO DEALLOCATE the default DEALLO...

Page 202: ...9 If you omit this option FUP uses the SLACK percentage value ISLACK percentage sets the minimum percentage of slack space in index blocks Specify percentage as a value in the range 0 through 99 If you omit this option FUP uses the SLACK percentage value SLACK percentage sets the minimum percentage of slack space in both index and data blocks Specify percentage as a value in the range 0 through 99...

Page 203: ...nded it still has the SHARE attribute when it is restarted If RELOAD is performed with the SHARE value and the requisite DP2 is not present error 49 is returned RECLAIM The RECLAIM option does not perform a RELOAD or re organize the file It reclaims the unclaimed free space for a SQL object caused by a Data Definition Language DDL move partition boundary or one way split operation This option work...

Page 204: ...CT specifies that the file is compacted to reclaim free space and reduce file size However using this option may take longer to reload a file RELOAD Guidelines RELOAD must be used with a C30 or later product version of TMF Using RELOAD with earlier product versions of TMF might produce new information in the file that is unrecoverable RELOAD does not require files to be audited If reload a volume ...

Page 205: ... the only one specified in the RELOAD command it is the only partition that is reloaded An online file reload can generate a large amount of audit trail information in a short amount of time for TMF audited files or tables The amount of audit information generated increases if you concurrently run multiple reloads The reload operation creates and maintains the file ZZRELOAD ZZRELOAD which contains...

Page 206: ... command is available only to the file owner or a super group user 255 n logical set specifies a set of logical files where relocation is to occur You can use wild card characters or specify a qualified file set The logical set can also include SQL files physvol specifies the name of a physical volume nnn specifies the priority of a job 1 through 199 Changing this option lets you run RELOCATE at a...

Page 207: ...lso moved The protection views do not have to be in the file set list If a file in the file set list is an SQL MP protection view it is not moved unless the base table it is defined on is also moved If the PHYSVOL option is not specified SMF chooses the best volume on the virtual disks RELOCATE Example To relocate the files starting with BLUE from L SMS to the physical volume ABC RENAME Changes th...

Page 208: ... files If you omit PARTONLY FUP renames all the partitions for partitioned files if their primary partitions reside in old fileset list PARTONLY has no effect on files that are not partitioned RENAME Guidelines If you try to rename a file whose AUDIT attribute is set for auditing by TMF the rename request fails and you receive file system error 80 invalid operation on audited file or nonaudited di...

Page 209: ...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 However for compatibility FUP product versions starting at D30 continue to recognize the REPORTWIDTH option as command syntax For more information see CONFIG URE on page 2 ...

Page 210: ...es see SET on page 2 171 RESET reset opts CONFIG URE config simple opts reset opts is create spec create spec create spec 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 PART partition num PARTONLY PARTSREC PHYSVOL QUEUEFILE REFRESH SERIALWRITES TY...

Page 211: ...UTR BOOKS PASCAL which is not displayed in this example with a record size of 10 bytes and an alternate key file named COMPUTR BOOKS BLAISE The SHOW command displays SET LIKe COMPUTR BOOKS BLAISE TYPE R EXT 1 PAGES 1 PAGES FORMAT 1 REC 10 BLOCK 1024 ALTKEY aa FILE 0 KEYOFF 0 KEYLEN 5 ALTFILE 0 COMPUTR BOOKS BLAISE config simple opts config simple option config simple option config simple option is...

Page 212: ...ptions for the CONFIG URE command RESET CONFIGURE DUP Commands Related to RESET RESTART Restarts a RESTARTABLE DUP operation at the point where it failed The operation continues from near the point where it failed restart filename is the name of an unstructured disk file created by a previous DUP operation with the RESTARTABLE option specified The file contains information describing the progress ...

Page 213: ... can continue from the point where the failed operation stopped The RESTART file is purged when the DUP LICATE process finishes The restart file created by H01 version of FUP cannot be used with H02 version of FUP and vice versa RESTART Examples This example assumes that the DUP operation from the first command fails The RESTART command restarts the DUP operation DUP FILE1 FILE2 RESTARTABLE RESTAR...

Page 214: ...P Commands File Utility Program FUP Reference Manual 523323 014 2 162 Commands Related to RESTART Commands Related to RESTART COMMAND Function Page DUP LICATE Creates an identical copy of a disk file 2 64 ...

Page 215: ...t default node volume and subvolume if necessary You can use wild card characters and specify qualified fileset for fileset list secure option is one of three options that can be set by a program or by a SECURE command For more information see SECURE on page 2 166 CLEARONPURGE physically deletes all data within fileset list from the disk by overwriting the file space with blank data when the file ...

Page 216: ...f the file as recorded in the disk label 2 The READ R permission must be provided to the user while adding to safeguard protection using Safeguard command interpreter SAFECOM otherwise user receives FileSystem Error 48 Security Violation 3 The new owner has ownership permission as per the underlying persistent protection record User other than owner in the same group can reset the PROGID and CLEAR...

Page 217: ... primary partition only you must own the partitioned file PARTFILE in the current default volume and subvolume REVOKE PARTFILE PARTONLY CLEARONPURGE For the super ID 255 255 to revoke the license of MYPROG in subvolume SYSTEM SYSTEM REVOKE SYSTEM SYSTEM MYPROG Commands Related to REVOKE Super ID COMMAND Function Page LICENSE Sets licensed attribute of a file 2 117 SECURE Sets file security and oth...

Page 218: ...ild card characters and specify qualified fileset for fileset list security string sets new Guardian file security for the files in fileset list You can also enclose security string with quotation marks Specify security string as a literal four character string You can include the character but you must always supply all four rwep security characters rwep The four characters in security string ass...

Page 219: ...ite execute and purge respectively k can be any of 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 loc...

Page 220: ...r every partition of the file is affected if the primary partition of the file is included in fileset list If the primary partition is not included in fileset list only the referenced file partitions are affected PROGID is the program ID for program files only When the program is run the PROGID option sets the process accessor ID to the ID of the owner of the program file This option is not valid ...

Page 221: ...or 48 security violation You cannot secure a file that is open with exclusive access If a process has a file open when you secure it the access rights of the process are not affected until the process closes the file FUP SECURE changes the security of existing files When you create a new file its security is defined by your default Guardian file security To change it use the DEFAULT command at the...

Page 222: ...bit so the owner ID of MYPROG is used as the process accessor ID when the program is run SECURE MYPROG OOAO PROGID To set the network security for the file OFFICE BILLS PAPER so any local or remote user can read the file only the local group members can execute the file and only the local owner can write or purge the file SECURE OFFICE BILLS PAPER NOGO To resecure all the files owned by WRITE KIRK...

Page 223: ...ram create param create param for all file types is NO AUDIT CODE file code EXT extent size pri extent size sec extent size FORMAT formatcode LIKE filename NO REFRESH TYPE file type create param for all structured files is BLOCK data block length REC record length create param for key sequenced files is NO AUDITCOMPRESS NO BUFFERED NO COMPRESS NO DCOMPRESS NO ICOMPRESS KEYLEN key length KEYOFF key...

Page 224: ...e messages for audited files The default is NO AUDITCOMPRESS NO BUFFERED sets the mode of handling write requests to the file using buffered or write through cache A buffered cache is specified with BUFFERED A write through cache is create param for files with alternate key fields is NO ALTCREATE ALTFILE key file number filename ALTKEY key specifier altkey param where altkey param is FILE key file...

Page 225: ...efaults to the pri extent size value When creating files you cannot define primary or secondary extents as zero pages For unstructured files on a disk drive in a disk drive enclosure the pri extent size and the sec extent size must both be divisible by 14 DP2 automatically rounds the size up if the file is non partitioned You can specify these values for extent size pri extent size and sec extent ...

Page 226: ...tor for the new file The designator can have these values If the FORMAT option is omitted it defaults to 0 LIKE filename sets file creation attributes to match those of an existing file FUP expands a partial file name using the current default values for node volume and subvolume if necessary If you specify a secondary partition of a partitioned file in filename FUP automatically sets the PARTONLY...

Page 227: ...ENTS you must also consider the primary and secondary extent sizes to avoid exceeding the maximum file size When the primary and secondary extent size plus the specified MAXEXTENT size is larger than two gigabytes a CREATE operation rejects the request with file system error 21 illegal count specified NO REFRESH causes the file label to be copied to disk whenever the file control block is marked a...

Page 228: ...onfiguration if there is significant use of the default block size 4096 bytes During the file creation process DP2 rounds up the extent size to 2 pages or 4 096 bytes because the extent size of DP2 files must always be an integral multiple of the BUFFERSIZE for unstructured files or of the BLOCK size for structured files REC record length sets the record length Specify record length as an integer ...

Page 229: ...cial type of key sequenced file with timestamps automatically added by DP2 Processes can queue and dequeue records in a queue file Queue files contain variable length records that are accessed by values in designated key fields Unlike other key sequenced files queue files have primary keys but cannot have alternate keys The primary key for a queue file includes an 8 byte timestamp You can optional...

Page 230: ...m FUP changes it to a standard DP2 number that starts at zero when the file is created pri extent size sec extent size sets the primary and secondary extent sizes The default value for pri extent size is one page 2 048 bytes If you specify a value of zero or do not specify a value sec extent size defaults to the pri extent size value When altering files you cannot define primary or secondary exten...

Page 231: ...alues are 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 The FUP process rounds the extent size up to the next full page partial key value specifies the lowest key value that can reside in this partition for key sequenced files only You must include partial key value for each partition of a key s...

Page 232: ...rs Each item in the string must be separated by a comma For example enter a string consisting of A 22 and C as A 22 C NO PARTONLY specifies whether subsequent file creations create all partitions of a partitioned file NO PARTONLY or a single partition PARTONLY The default setting is NO PARTONLY If you specify PARTONLY while a PART specification is enabled any file you create is designated as a pri...

Page 233: ...lete the corresponding alternate file specification in the same SET command If you are deleting the last alternate file specification you must also delete the corresponding alternate key specification in the same SET command ALTKEY key specifier altkey param sets an alternate key specification You must specify each alternate key separately key specifier is a 2 byte value that identifies this alter...

Page 234: ... key sequenced file or the creation attempt fails KEYOFF key offset sets the key offset for key specifier The default setting for key offset is zero NO NULL NULL null value specifies whether or not a null value is set for key specifier If a value is specified null value must be an ASCII character in quotation marks or an integer in the range 0 through 255 The default is NO NULL NO UNIQUE specifies...

Page 235: ...structured file Unstructured Enscribe files can be even or odd The FUP process rounds up any odd byte count that you give to an even unstructured file for reading writing or positioning This is the default for unstructured files FUP does not round up odd unstructured files You always read write or position at the byte count you give To change an odd unstructured file to an even unstructured file c...

Page 236: ... a separate operation If you use the PHYSVOL option with the SET command it applies to each subsequent CREATE command until it is reset An error occurs during a CREATE command if the PHYSVOL specified does not belong to the volume specified in the CREATE command For an enhanced key sequenced file the SET EXT command accepts both pri extent size and sec extent size but if the primary extent size is...

Page 237: ...U Table 2 3 Extent Size Rounding Type of File EXT Parameter Value Extent Size Created DP2 Files Unstructured File With BUFFERSIZE 4096 With BUFFERSIZE 4096 With BUFFERSIZE 4096 With BUFFERSIZE 4096 Any N N N Even N N N Odd N N 1 N 1 Default 2 2 Structured File With BLOCK 4096 With BLOCK 4096 With BLOCK 4096 With BLOCK 4096 Default 1 1 Any N N N Even N N N Odd N N 1 N 1 Note DP rounds the extent si...

Page 238: ...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 BLUE RESET PHYSVOL Commands Related to SET COMMAND Function Page CREATE Creates a file using default file attributes 2 59 RESET Resets default file attributes or CONFIG URE options 2 158 SHO...

Page 239: ...le show opts configure opts show opts is create spec create spec create spec is TYPE CODE FORMAT EXT REC BLOCK COMPRESS DCOMPRESS ICOMPRESS KEYLEN KEYOFF ALTKEY key specifier ALTKEYS ALTFILE key file number ALTFILES ALTCREATE ODDUNSTR REFRESH AUDIT PART partition num PARTS PARTONLY PHYSVOL MAXEXTENTS BUFFERSIZE BUFFERED AUDITCOMPRESS VERIFIEDWRITES SERIALWRITES QUEUEFILE configure opts is CONFIG U...

Page 240: ... option is present it can only occur immediately after the CONFIG URE keyword and you must specify both words If this display is written to a file you can use it to reestablish CONFIG URE options from a command file or FUPCSTM file config simple opts config simple option config simple option config simple option is ALLOW DISPLAYBITS DISPLAYALLNUM ECHO CONFIG URE OBEY IOTIMEOUT NETBLOCKSIZE PROMPT ...

Page 241: ...ITS option see CONFIG URE on page 2 26 You can set the extent size as the number of records in each extent SHOW displays the extent size in that form For example suppose you enter SET EXT 100 RECS 10 The SHOW display then includes EXT 100 RECS 10 PAGES Use the SHOW command with the PHYSVOL option to display any SMF settings for the file creation attributes SHOW Examples This example assumes you en...

Page 242: ...ted to SHOW STATUS Reports the status of a reload operation OUT listfile names an existing disk file or a device to receive the listing output from the STATUS command You can use either a standard file name or a spool DEFINE name as the OUT listfile for a STATUS command If listfile is an existing file FUP appends the output to the file COMMAND Function Page CONFIG URE Sets some of the attributes d...

Page 243: ...plete FUP displays vol name subvol name filename RELOAD COMPLETED date time of completion If the reload operation is suspended by the SUSPEND command FUP displays vol name subvol name filename RELOAD INITIATED date time of initiation SUSPENDED date time of suspension DSLACK percentage ISLACK percentage RATE percentage PCT COMPLETED percentage DEALLOCATE YES NO SHARE YES NO RECLAIM YES NO If the re...

Page 244: ... DETAIL BASE FUPTESTL PAYFILE RELOAD INITIATED 10 Aug 2000 15 37 RELOAD COMPLETED 10 Aug 2000 15 39 DSLACK 0 ISLACK 0 RATE 100 PCT COMPLETED 100 DEALLOCATE YES Commands Related to STATUS SUBVOLS Displays the names of all the subvolumes on a particular volume OUT listfile names an existing file or device to receive the output of the SUBVOLS command You can use either a standard file name or a spool...

Page 245: ...volumes SUSPEND Stops a reload operation A subsequent RELOAD command can resume the reload operation from the point where it was suspended For more information see RELOAD on page 2 148 OUT listfile names an existing disk file or a device to receive the listing output from the SUSPEND command You can use either a standard file name or a spool DEFINE Note For more information about listfile see Spec...

Page 246: ... the second ORSERV process an error message appears If a reload operation is not in progress for filename or if the ORSERV process cannot be stopped FUP displays an error message If the reload operation has already been suspended FUP ignores the SUSPEND command and does not display a message SUSPEND Example SUSPEND MYFILE Commands Related to SUSPEND SYSTEM Sets the default node You can also set th...

Page 247: ...es the network form for file name expansion Using the network form causes only volume or device names with six characters or fewer to be accessible The volume and subvolume parameters are optional If you omit these parameters FUP uses their current default values If node is an invalid node name FUP displays an error message and does not change the node However FUP does not issue an error if volume...

Page 248: ...r 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 fileset list is a list of disk files whose state of Trust flag is to be changed COMMAND Function Page VOLUME Changes the FUP default volume and subvolume 2 198 TRUST fileset list trust flag ...

Page 249: ...lines 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 TRUST Examples To set TRUST flag of file MYPROG to TRUST ME TRUST MYPROG ME To set TRUST flag of file MYPROG to TRUSTSHARED TRUST MYPROG SHARED To rest T...

Page 250: ...he name of a volume or a wild card and it can include a system name If you specify a volume name it must begin with a dollar sign The default is all volumes on the current system VOLS Example To show information on all volumes of the current system that begin with the letter M VOLS M Capacity Mb Free Extents Volume M Total Free Free Count Biggest MCAT Y 895 346 62 38 12 332 24 MOLD Y 415 50 04 12 ...

Page 251: ...t default volume name that has more than six characters after the dollar sign on a remote node node and subvolume are optional If you omit these parameters FUP uses their current default values If node is an invalid node name FUP displays an error message and does not change the node However FUP does not issue an error if volume or its default value does not exist on the new system FUP and the com...

Page 252: ...FUP Commands File Utility Program FUP Reference Manual 523323 014 2 200 Commands Related to VOLUME Commands Related to VOLUME COMMAND Function Page SYSTEM Changes the FUP default node name 2 194 ...

Page 253: ...n or alternate key file was placed on a nonexistent volume Effect A warning is issued and the command execution proceeds Recovery Place all alternate key files and secondary partitions on the primary volume or on existing volumes Cause A FUP CREATE or SET command was used to specify a partition for a non key sequenced file that had a different file format than an existing partition Effect The comm...

Page 254: ...TKEY or ALTKEY definition Cause An attempt to create or alter a file failed An alternate key was specified for a file but an alternate key file was not specified for the alternate key Effect The CREATE or ALTER command fails Recovery Retry the command after correcting the ALTKEY or ALTFILE definition Cause When entering the CREATE or ALTER command you either omitted the KEYLEN parameter from an AL...

Page 255: ...d specify valid partition file names Retry the DUP operation if information was lost Cause The ALTKEY or the ALTFILE specifications for a CREATE or ALTER command were not correct This situation can also occur if an existing file had invalid alternate key parameters and an attempt was made to load one of its alternate key files using LOADALTFILE Effect The command fails Recovery Reenter the command...

Page 256: ...e maximum partition number In the second case correct either the destination file name or the PARTOF volume name Cause An attempt to load or copy a file failed because the record length specified for a variable length record was not valid For example the record length was a negative number This error can occur if the file to be loaded or copied was filled without specifying the VAROUT option of th...

Page 257: ...EFINE was specified with USE set to IN but the DEFINE name was specified as an output file in either a FUP COPY or BUILDKEYRECORDS command Effect The command fails Recovery Modify the DEFINE or command parameters and retry the command Cause An optical disk file was specified in a command that cannot operate on optical disk files Effect The command fails Recovery If you intended to specify another ...

Page 258: ...PEN flag is on filename was partitioned Effect The command is not executed Recovery Reissue the FUP ALTER command for each partition Cause A file system error occurred while you tried a CREATE command with 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 Cause A file na...

Page 259: ...ot corrupt which implies that the previous attempt to use DUP was successful Effect The RESTART operation terminates Recovery If you need to run DUP perform an ordinary DUP operation Cause The DP2 lock tables changed during the current LISTLOCK operation Effect All lock information already displayed for filename is invalid FUP automatically starts over retrieving and displaying current lock inform...

Page 260: ...sity Recovery Informational message only no corrective action is needed if the tape drive was at the correct density Cause The same volume was specified for more than one partition of a partitioned file Effect The CREATE ALTER or DUP command fails Recovery Each partition of a partitioned file must reside on a separate disk volume Cause An error occurred while the system was reading an EDIT file RE...

Page 261: ...ffect In interactive mode the LOAD command terminates by returning to the FUP prompt In noninteractive mode the LOAD command terminates by abnormally ending Recovery Check that you entered the command as intended If the source file is empty to achieve the effect of loading the destination with an empty file use the EMPTYOK option Cause A Guardian file system error was encountered on the indicated ...

Page 262: ...ttempted when FUP expected a disk device name Effect The command fails Recovery Correct the name of the LISTOPENS object and retry the command Cause A LISTOPENS command that specified a disk device name was attempted when FUP expected a nondisk device name Effect The LISTOPENS command terminates Recovery Correct the name of the LISTOPENS object and retry the command Cause Corrupted data was encoun...

Page 263: ...system error was encountered during execution of the command 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 Cause CHECKSUM executed successfully The number of files processed is indicated Effect None Recovery Informational message only no corrective action is needed Cause nnn indicates ...

Page 264: ...large greater than 64 KB this error is returned Effect The command fails Recovery Retry the command after correcting the extent size values Cause The file name specified in the command was not valid Effect The command fails Recovery Retry the command after correcting the file name Cause The attempted command specified an invalid key value For example the FIRST option of the COPY command specified ...

Page 265: ...An attempt was made to create a DP2 key sequenced file with the index block size and data block size set to different values Effect The CREATE command finishes but the IBLOCK value for the file is set to its BLOCK value Recovery If the modified IBLOCK value is not the value required reset the BLOCK and IBLOCK values and retry the command The index block size must equal the data block size for DP2 ...

Page 266: ...ndicated by filename was not duplicated Effect None Recovery Informational message only indicating successful completion for all or some of the specified files Cause An attempt to create a file failed because the key length specified for the primary key was not specified or was specified as zero Effect The CREATE or ALTER command fails Recovery Retry the command with a legal KEYLEN value Cause An ...

Page 267: ...e Effect The LICENSE attribute is not preserved Recovery Use the LICENSE command to license the file Remote logon might be required Cause An internal program error occurred Effect The command fails Recovery Note the load error indicated by nnn and call your service provider Cause The file system LOCKINFO procedure which provides FUP with all lock information returned the error errnum This message ...

Page 268: ...id not find one For example for key sequenced files the PART specification must include the partial key value which is a string Effect The command fails Recovery Retry the command after including the required string specification Cause This is not an error FUP was reading from a tape file for example COPY LOAD from tape and no more records remained in the current reel but there are more reels to r...

Page 269: ...PEND command issued against filename found no RELOAD operation for filename Effect The command fails Recovery Check that you spelled filename correctly or that filename exists before retrying SUSPEND Cause A Safeguard protected file was duplicated but the new file is not Safeguard protected Effect The file is duplicated this is only a warning Recovery Use the Safeguard command interpreter to estab...

Page 270: ... Check which attributes did not transfer and transfer manually if necessary Cause The attempted command was not allowed for partitioned files For example an attempt was made to duplicate a partitioned file specifying the OLD option without the PARTONLY option Effect The command fails Recovery Check which commands are allowed with partitioned files Cause The source file of a BUILDKEYRECORDS command...

Page 271: ...option was specified No changes to the file were specified Effect None Recovery Retry the command specifying the required changes Cause An attempt was made to duplicate a file using the OLD option with either the PART ALTFILE or EXT option These options are mutually exclusive Effect Only the OLD option is used and the others are ignored This is only a warning Recovery To change something using PAR...

Page 272: ...ecified an SQL view Effect The operation is not performed on the view but will be performed on the next object or file in the specified file set Recovery If you intended to specify another type of file retry the command after correcting the file specification Cause An SQL object was specified as a list file Effect The command operation terminates Recovery Retry the command specifying a valid list ...

Page 273: ... the partitions Effect The command fails Recovery Retry the command after correcting the numbering of the partial key values or the partitions Cause The file attributes of the individual partitions of a partitioned file were inconsistent with one another Effect The command fails Recovery Check the partitions and ensure consistency by executing the necessary FUP ALTER commands For all partitions ch...

Page 274: ...d the allowed 255 byte total Effect The command fails Recovery Retry the command specifying values within the specified byte limits Cause A RELOAD STATUS or SUSPEND command attempted to create a reload server but the server could not be created Effect The command fails Recovery Ask the system manager to install ORSERV on SYSTEM SYSTEM If this does not correct the problem an internal error exists I...

Page 275: ...he records with partial alternate keys This is only a warning Recovery Retry the command after padding the records in the primary file so that alternate keys are always completely contained in the records Cause A FUP command was entered that attempted to assign a record size inappropriate for the file format of the file Effect The command fails Recovery Reenter the command with an appropriate reco...

Page 276: ...ry Informational message only no corrective action is needed Cause A file system error was encountered while attempting to rename 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 Cause FUP was expecting a delimiter but did not find it or an ANSI Name is entered without ...

Page 277: ...inary DUP operation Cause The transfer of a file s SECURITY attribute failed during a duplicate operation with the SAVEALL or SAVEID option to a remote node Effect The SECURITY attribute is not preserved Recovery Use the SECURE command to change the security Remote logon might be required Cause A file system error was encountered while attempting a SETMODE command Effect The requested command fail...

Page 278: ... the process creation error number n and additional process creation error information nn INTERNAL ERR is a SORT internal error Correct the error and retry the command Cause A RESTART operation was attempted but the source file was modified since the previous attempt to use DUP Effect The RESTART operation terminates Recovery Perform an ordinary DUP operation Cause An internal error occurred in th...

Page 279: ... the largest block size that FUP can accommodate Effect The command fails Recovery If possible change the BLOCKLEN value to a size that FUP can accommodate Cause The value of in file was a TAPE DEFINE name and the RECLEN value was greater than 4096 Effect The command fails Recovery If possible change the RECLEN value to a size that FUP can accommodate Cause The value of in file was a TAPE DEFINE n...

Page 280: ...DEFINE or omit EBCDICIN and retry the command Cause The value of in file was a TAPE DEFINE name the EBCDIC value in the DEFINE was OFF and the EBCDICOUT FUP parameter was specified Effect The command fails Recovery Change the EBCDIC value in the DEFINE or omit EBCDICOUT and retry the command Cause The value of in file was a TAPE DEFINE name and the RECLEN value in the DEFINE did not equal the valu...

Page 281: ... This is not an error FUP was writing to a tape file and reached the end of the current reel Effect FUP waits for the next reel to be mounted Recovery Mount the next reel Cause A write request was made but the write ring was missing Effect The write request to the tape fails Recovery Unmount the tape insert a write ring and remount the tape Press RETURN to restart the operation Cause An attempt to...

Page 282: ...fter correcting the string length Cause Too many objects were specified for the attempted command For example more than 10 file sets were specified in a file set list for FUP or too many key tags were specified for the BUILDKEYRECORDS command Effect The command fails Recovery Retry the command with an acceptable number of specified objects Cause Too many more than 1000 volumes were specified for t...

Page 283: ...at have subdevices Effect You receive an error message instead of the information you requested Recovery You need to execute LISTOPENS for specific terminals An example is LISTOPENS TC1 C13 Cause A SUSPEND command was issued but the RELOAD command could not be stopped Effect The command fails Recovery Check that you have proper security access to stop the reload server process and then retry the c...

Page 284: ...es or to alter the extent sizes of a secondary partition in the file label of the primary partition of a DP2 key sequenced file Effect The ALTER finishes this is only a warning Recovery Check that the extent sizes in the file label of the primary partition reflect the actual extent sizes of the secondary partitions Cause The device specified in a LISTOPENS command does not return open information ...

Page 285: ...UP when ANSI Name is entered and some miscellaneous SQL error occurs Effect The command fails Recovery For corrective actions contact the SQL MX ANSI Names developers Cause The SQL MX ANSI Names mapping service ANMS is unable to perform the mapping due to a file system error Effect The command fails Recovery For corrective actions contact the SQL MX ANSI Names developers Cause ANSI Name entered is...

Page 286: ...quote Effect The command fails Recovery Retry the command after adding the missing double quote Cause ANSI Name is entered with the SQL MX MODULE keyword Effect The command fails Recovery None Cause ANSI Name is entered with the SQL MX SCHEMA USER keyword Effect The command fails Recovery None Cause ANSI Name is entered with CATALOG or SCHEMA in the INFO or RELOAD command Effect The command fails ...

Page 287: ...ot and then retry the command with the correct ANSI Name Cause ANSI Name is encountered after the Guardian name in any command supporting ANSI Names or in any command that does not support ANSI Names Effect The command fails Recovery Retry the command by entering either the ANSI Name or the Guardian name Cause Returned by FUP when an internal error occurs in the ANSI Name Server Process ANSP due t...

Page 288: ...ter adding the required missing single quote or by correcting the ANSI Name Effect ANSI Name is entered with space character missing between the ANSI Name keyword and the SQL identifier Effect The command fails Recovery Retry the command after adding the required space character Cause ANSI Name is entered without specifying a required SQL identifier Effect The command fails Recovery Retry the comm...

Page 289: ...ct 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 Cause There is a version mismatch between FUP and the SQL MX parser Effect The command fails Recovery Install the version of FUP and SQL MX parser that are compatible with each other VERSION MISMATCH BETWEEN SQL MX MAPPING SOFTWARE AND ...

Page 290: ...FUP Messages File Utility Program FUP Reference Manual 523323 014 3 38 ...

Page 291: ...e Guardian User s Guide Table A 1 How FUP Input Options Work With TAPE DEFINEs FUP Parameter FUP Parameter Only FUP Parameter and DEFINE DEFINE Only DEFINE BLOCKIN BLOCKIN is the size of the buffer used by FUP FUP quits with an error if values conflict BLOCKIN is set to BLOCKLEN BLOCKLEN EBCDICIN or XLATE FUP performs translation FUP performs translation and sets DEFINE OFF or an error occurs if v...

Page 292: ...ets density or an error occurs if values conflict FUP ignores the DEFINE DENSITY EBCDICOUT or XLATE FUP performs translation FUP performs translation and sets DEFINE OFF or an error occurs if values conflict FUP lets label processing do the translation EBCDIC RECOUT RECLEN is set to RECOUT and is used by FUP for blocking FUP quits with an error if values conflict RECOUT is set to RECLEN and it is ...

Page 293: ...uard security codes Note For information on SAFECOM commands and their syntax see the Safeguard Reference Manual Table B 1 FUP Control Commands Command Function Reexecutes the specified command Displays the specified command ALLOW Sets the number of errors and warnings allowed during the execution of FUP commands CONFIG URE Customizes your FUP configuration information DISPLAYBITS Sets the display...

Page 294: ... must perform this function through SAFECOM REVOKE Super ID command Revokes the license of one or more program files to execute with privileged procedures When the CLEARONPURGE or PROGID option is included in the REVOKE command the appropriate attribute CLEARONPURGE or PROGID is revoked SECURE Sets file security attributes for one or more disk files Table B 4 FUP File Management Commands page 1 of...

Page 295: ...e LOADALTFILE Loads an alternate key file with the alternate key records of a specified structured disk file You can specify slack space for future insertions PURGE Purges one or more disk files PURGEDATA Purges data from one or more disk files RELOAD Reorganizes a key sequenced file while permitting full access to it RELOCATE Moves files on SMF virtual disks from one physical volume to another wi...

Page 296: ...FUP Command Summary File Utility Program FUP Reference Manual 523323 014 B 4 ...

Page 297: ... Syntax Summary To run FUP To specify files you can use fileset or fileset list FUP run options command fileset is node volume subvolume file id fileset list is fileset fileset fileset num num string quoted num num string quoted ALLOCATE fileset list num extents PARTONLY ...

Page 298: ... 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 DELALTFILE key file number DELALTKEY key specifier alter option for partitioned files is PART sec partition num node volume pri extent size sec extent si...

Page 299: ...TEIN translation table name XLATEOUT translation table name CHECKSUM fileset list PARTONLY CONFIG URE config command config params config command is command option environment option command option is COPY copy option copy option DUP LICATE dup option dup option LOAD load option load option LOADALTFILE loadaltfile option loadaltfile option RELOAD reload option reload option environment option is A...

Page 300: ...y specifier ALTKEY key value UNSTRUCTURED UPSHIFT 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 X...

Page 301: ...leset list PARTONLY DUP LICATE from fileset list to fileset RESTARTABLE restart filename rename option EXT extent size pri extent size sec extent size KEEP NEW OLD PURGE PARTONLY SAVALL SAVEID SOURCEDATE PHYSVOL physvol rename option is ALTFILE key file number filename PART sec partition number node volume pri extent size sec extent size EXIT FC num num string quoted FILENAMES OUT listfile fileset...

Page 302: ...stfile 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 username LICENSE fileset list LISTLOCKS OUT listfile fileset list ansiname list GRANTED DETAIL PARTONLY LISTOPENS OUT listfile fileset list ansiname list SCRATCH scratch filename ...

Page 303: ...IPIN num eofs TRIM trim character NO UNLOADIN VARIN XLATE translation table name XLATEIN translation table name XLATEOUT translation table name key seq option is MAX num records PARTOF volume SCRATCH scratch filename SORTED DSLACK percentage ISLACK percentage SLACK percentage LOADALTFILE key file number primary filename key seq option key seq option is MAX num records SCRATCH scratch filename DSLA...

Page 304: ... fileset list new fileset PARTONLY REPORTWIDTH width RESET create spec create spec RESET reset opts CONFIG URE config simple opts For a description of reset opts create spec see the SET command For a description of config simple opts see the CONFIG URE command RESTART restart filename REVOKE fileset list secure option secure option is CLEARONPURGE PARTONLY PROGID SECURE fileset list security secur...

Page 305: ... sec extent size FORMAT formatcode LIKE filename NO REFRESH TYPE file type create param for all structured files is BLOCK data block length REC record length create param for key sequenced files is NO COMPRESS NO DCOMPRESS NO ICOMPRESS KEYLEN key length KEYOFF key offset create param for partitioned files is PART sec partition num node volume pri extent size sec extent size partial key value NO PA...

Page 306: ...RTIONORDER KEYLEN key length KEYOFF key offset NO NULL NULL null value NO UNIQUE NO UPDATE create param for DP2 files is NO AUDITCOMPRESS NO BUFFERED MAXEXTENTS maximum extents QUEUEFILE NO SERIALWRITES NO VERIFIEDWRITES create param for odd unstructured files is BUFFERSIZE unstructured buffer size ODDUNSTR create param for files on SMF virtual disks is PHYSVOL physvol SHOW OUT listfile show opts ...

Page 307: ...UDITCOMPRESS 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 subvol subvol SUSPEND OUT listfile filename SYSTEM node volume subvolume VOLS OUT listfile volset volset is nod...

Page 308: ...name FILENAME node volume subvol file id VOLNAME node volume QUALEXPR qualifier qualifier is EXCLUDE fileset list FROM CATALOG S catalog list START file id WHERE expression catalog list is node volume subvol subvol expression is expression expression AND expression expression OR expression NOT expression file attribute OWNER userid timestamp field time conditional time value FILECODE conditional n...

Page 309: ...TIVE PRIMARY SECONDARY PARTITION ROLLFORWARDNEEDED SAFEGUARD SQL SQLPROGRAM TABLE TRUSTED TRUSTME TRUSTSHARED UNSTRUCTURED user id is group name user name group name group number user number group number timestamp field is CREATIONTIME EXPIRATIONTIME LASTOPENTIME MODTIME time conditional is AFTER BEFORE time value is date time time date time is hh mm ss date is dd mmm yyyy mmm dd yyyy ...

Page 310: ...FUP Command Syntax Summary File Utility Program FUP Reference Manual 523323 014 C 14 ...

Page 311: ...ted and proposed standards include transmission code and protocol ASCII media tape and diskette and languages FORTRAN and COBOL American Standard Code for Information Interchange ASCII A method of coding data that consists of seven bits for each character plus a parity bit Designed for synchronous or asynchronous use the code has 128 standard characters It can also be an 8 bit code representing ch...

Page 312: ... DEFINE A named set of attributes and associated values A user can specify information that jobs communicate to processes they start Default DEFINEs hold the standard default values of a process such as the default volume Spool DEFINEs pass information to the spooler collector process The attributes of a spool DEFINE specify parameters such as the spooler location and batch name SQL catalog DEFINE...

Page 313: ...itions An enhanced key sequenced file may only be a format 2 file Enscribe The database file management software provided as part of the Guardian file system The Enscribe software provides access to and manipulation of records in a database on a NonStop system Files on a Guardian system can be either Enscribe files or SQL MP tables entry sequenced file A file in which each new record is stored at ...

Page 314: ...quenced file may be format 1 file or format 2 file LIN See location independent naming LIN location independent naming LIN The naming of files so that their names do not determine their physical location logical file name A file name whose volume component is an SMF virtual disk See also external name logical temporary file A temporary file the file name beginning with created on a logical volume ...

Page 315: ...to a process for identification purposes qualified file set list A list of file sets qualified by a clause optionally that selects objects based on characteristics of the file To determine which qualifiers are permitted refer to the syntax record A basic unit of storage in a file or database pertaining to a particular item A record is the smallest logical unit of data that can be read from or writ...

Page 316: ...el security tool that provides users of NonStop systems and distributed networks with a set of services for protecting the components of the system or network from unauthorized use Safeguard services include authentication authorization and auditing Safeguard command interpreter SAFECOM The user interface to Safeguard SAFECOM commands are used to establish and maintain object authorization records...

Page 317: ...lume is purged A subvolume name consists of one to eight alphanumeric characters the first of which must be alphabetic super ID A privileged user who can read write execute and purge all files on the system The super ID is usually a member of a system supervisor group The super ID has the user ID 255 255 timestamp An identifier that indicates when a file was created or modified HP NonStop Transact...

Page 318: ...so 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 The overall SMF management process a process pair ...

Page 319: ...n FUP ALTER 2 13 2 176 FUP COPY 2 40 2 132 FUP CREATE 2 59 FUP SET 2 176 American National Standards Institute ANSI 2 43 American Standard Code for Information Interchange ASCII 2 41 ASCII format in FUP COPY display 2 56 Asterisk wild card character 1 10 AUDIT attribute restrictions on renaming file 2 155 AUDIT option FUP ALTER all file types 2 10 unstructured files 2 18 FUP COPY 2 53 FUP CREATE r...

Page 320: ... SET 2 172 DEALLOCATE command 2 61 DECIMAL format in FUP COPY display 2 55 Defaults setting with VOLUME 2 193 system changing 2 189 DEFINE attribute 1 21 BLOCKIN option FUP COPY 2 41 DELALTFILE option FUP ALTER 2 15 DELALTKEY option FUP ALTER 2 15 DENSITYOUT option FUP BUILDKEYRECORDS 2 22 FUP COPY 2 46 DETAIL option FUP INFO 2 83 2 98 2 104 DISPLAYBITS command 2 62 DP2 files allocating extents FU...

Page 321: ...ced files licensed See Licensed files loading data FUP BUILDKEYRECORDS 2 21 File continued FUP LOAD 2 130 FUP RELOAD 2 147 loading empty 2 131 partitioned See Partitioned files relative See Relative file Safeguard protected See Safeguard protected files structured See Structured files unstructured See Unstructured files File codes 2 86 File extents allocating FUP ALLOCATE 2 6 specifying with FUP A...

Page 322: ...FUP RELOAD 2 149 K KEEP option FUP DUP 2 65 KEY option FUP COPY 2 39 2 132 KEYLEN option FUP SET 2 14 2 172 2 177 KEYOFF option FUP SET 2 14 2 172 2 177 Key sequenced files changing extent sizes 2 16 loading data LOAD example 2 136 LOAD option 2 133 reorganizing data 2 147 specifying slack values LOAD 2 134 RELOAD 2 149 syntax description for setting attributes 2 171 syntax for setting attributes ...

Page 323: ... COPY 2 47 cautions on use 2 53 with RECOUT option 2 47 FUP LOAD 2 133 PAGE option FUP ALTER 2 17 2 168 2 173 Parallel mirror writes 2 170 PART option FUP DUP 2 65 2 70 FUP SET 2 172 PARTIAL option FUP INFO 2 84 Partitioned files allocating extents FUP ALLOCATE 2 6 attributes resetting 2 157 setting 2 166 2 172 defining keys 2 172 FUP INFO information 2 84 loading restrictions 2 135 renaming 2 155...

Page 324: ...n FUP ALTER 2 17 2 169 2 174 FUP SET 2 171 RECIN option FUP COPY 2 42 FUP LOAD 2 133 RECLAIM option FUP RELOAD 2 150 FUP STATUS 2 185 Record lock FUP LISTLOCKS display 2 120 Records loading empty 2 131 RECOUT option FUP BUILDKEYRECORDS 2 22 FUP COPY copy form 2 47 display form 2 57 REELS option FUP COPY 2 43 FUP LOAD 2 133 REFRESH option FUP ALTER 2 12 FUP SET 2 170 Relative files copying empty re...

Page 325: ...ng with LOADALTFILE 2 138 SORTED option FUP LOAD 2 134 SOURCEDATE option FUP DUP 2 67 SQL MP files handling 1 24 SQL MX files handling 1 27 Standard listing for INFO 2 85 STATISTICS option FUP INFO 2 83 2 112 STATUS command 2 185 Structured files adding alternate keys 2 19 deleting alternate keys 2 19 setting attributes syntax 2 166 syntax description 2 171 SUBVOLS command 2 187 Subvolume changing...

Page 326: ...ER 2 19 UPDATE option FUP SET 2 15 2 177 UPSHIFT option FUP COPY 2 40 USER option FUP INFO 2 84 V Variable length blocked records with FUP COPY 2 45 2 49 VARIN option FUP COPY 2 45 FUP LOAD 2 133 VAROUT option FUP COPY 2 49 VERIFIEDWRITES option FUP ALTER 2 13 FUP SET 2 170 VOLS command 2 193 VOLUME command 2 193 Volume changing current default 2 193 W Wild card characters 1 10 X XLATE option FUP ...

Search results

Summary of Contents for G08

Reviews:

Brands by name

Popular brands

HP G08, Reference Manual

Search results

Summary of Contents for G08

Reviews:

Brands by name

Popular brands