background image

For SQL backup strategies and options, including guidelines for performing daily and periodic
backups, and using the FROM CATALOG, PARTONLY, and INDEXES options, see the SQL/MP
Installation and Management Guide
.

CAUTION:

BACKUP is normally used as a secondary recovery method for SQL objects; TMF

recovery operations are used as the primary method. An SQL object recovered with RESTORE
might be inconsistent with the current catalog description of the object.

When a base table is backed up with PARTONLY OFF and INDEXES IMPLICIT:

Any SQL protection views defined on the table are backed up automatically. You should
not explicitly name protection views in the backup files.

Constraints and comments associated with the table are backed up automatically.

An SQL shorthand view is not backed up unless it is explicitly named in

backup-files.

You must use BACKUP to archive nonaudited SQL tables.

NOTE:

SQL tables can be backed up only if the program file from BACKUP is licensed.

Licensing occurs automatically if you use the DSM/SCM to install BACKUP. If you do not use
DSM/SCM, you can use the FUP LICENSE command to license the program file.

By default, BACKUP and RESTORE do not back up and restore SQL catalogs. Use the
SQLCATALOGS ON option to back up and restore catalogs. (An SQL catalog is a set of
tables containing the descriptions of SQL objects.)

Always use BACKUP to back up SQL objects, but only use the SQLCATALOGS ON option to
dump all SQL catalogs when reporting a problem to HP support.

BACKUP and RESTORE do not work with remote SQL tables if SQL is not installed on the local
node.

To provide a create-like function for multiple partition SQL objects, use the BACKUP
NOSQLDATA option followed by RESTORE MAP NAMES. The resulting SQL object is an
empty copy of the original.

In case of disk failure, use the VOLUMEMODE option of BACKUP and RESTORE to replace
any volumes containing SQL catalogs, if possible. Use this option to restore SQL files only if
the SQL objects have not changed since they were backed up.

CAUTION:

Under normal conditions, to ensure that BACKUP and RESTORE handle all related

objects together and avoid inconsistencies, use BACKUP with the default options PARTONLY OFF
and INDEXES IMPLICIT.

When necessary, use the PARTONLY and INDEXES EXPLICIT options to back up or restore individual
SQL components of a set of related objects (files), such as the individual partitions of a partitioned
table or indexes of SQL tables. Use these options carefully:

The consistency checking that BACKUP and RESTORE perform to validate the data during
these procedures does not ensure the data consistency of SQL objects.

If you use options from BACKUP and RESTORE incorrectly, you can cause the primary data
to be inconsistent with the alternate indexes. For example, a base table can be inconsistent
with its indexes and left invalid after a RESTORE process when PARTONLY ON or INDEXES
EXPLICIT is specified. Use these options with extreme care.

BACKUP Guidelines and Examples

75

Summary of Contents for BACKCOPY

Page 1: ...Utilities Reference Manual Abstract This publication describes the disk and tape utilities BACKCOPY BACKUP DCOM DSAP PAK UNPAK and RESTORE for the HP NonStop operating system HP Part Number 523325 017 Published February 2013 ...

Page 2: ...U S and other countries Open Software Foundation OSF the OSF logo OSF 1 OSF Motif and Motif are trademarks of the Open Software Foundation Inc OSF shall not be liable for errors contained herein or for incidental consequential damages in connection with the furnishing performance or use of this material 1990 1991 1992 1993 Open Software Foundation Inc This documentation and the software to which i...

Page 3: ...ng BACKCOPY BACKUP and RESTORE 28 Entering BACKUP and RESTORE Commands 29 Mounting a Tape 29 Exiting the Program 30 Dismounting a Tape 30 Disk Formats 30 Tape Formats 31 Tape Format History 31 Using BACKUP and RESTORE With DSM Tape Catalog 32 2 BACKCOPY 33 Security 33 BACKCOPY Syntax 33 Guidelines 36 Examples Different Ways to Use BACKCOPY 37 Completion Information 37 3 BACKUP 39 Security 39 BACKU...

Page 4: ...54 Examples 54 IGNORE 54 Guidelines 54 INDEXES 55 Examples 55 ISLACK 55 LISTALL 55 Guidelines 55 MSGONLOCK 57 Guidelines 57 MULTIDRIVE 58 Guideline 58 Example 58 NEEDBOTH 58 Guideline 58 Example 58 NOMYID 58 NOPROMPT 59 Example Mounting a Tape for a BACKUP using NOPROMPT 59 NOREWIND 59 NOSAFEGUARD 59 Guidelines 59 NOSQLDATA 60 Guidelines 60 NOT 60 Guideline 60 Example 60 NOUNLOAD 61 OPEN 61 Guidel...

Page 5: ...1 WHOLEDISC 71 Guidelines 71 Completion Information 71 BACKUP Guidelines and Examples 72 Basic Backup Procedures 72 Examples Basic Backup Commands 73 Backing Up Format 1 and Format 2 Files 73 Using Qualified File Set Lists 74 Backing Up SQL Files 74 Examples 76 Backing Up or Converting DP1 and DP2 Files 76 Backing Up With Labeled Tapes 77 Labeled Backup Tape Volume Labels 78 Using DEFINEs for Labe...

Page 6: ...ptional Condition Report 102 Space Distribution Reports 103 Report by Subvolume 105 Report by User 106 Detail Report 106 Short Report 108 Newformat Report 109 Tabular Report 109 Teraform Report 109 DSAP Examples 109 System Manager or System Operator Examples 110 Group Manager Example 110 User Examples 110 Format of the Permanent Work File 110 Changing the Default Work File Volume 111 Work File Gui...

Page 7: ...5 IGNORE 135 Guidelines 135 INDEXES 135 Guidelines 135 Examples 136 ISLACK 136 KEEP 136 Guidelines 136 LISTALL 136 Guideline 136 Example 137 LISTONLY 137 Guidelines 137 MAP NAMES 138 Guidelines 138 Examples 140 MULTIDRIVE 140 Guidelines 141 Example 141 MYID 141 Guideline 141 NOPROMPT 141 Guideline 141 NOPURGEUNTIL 142 Guideline 142 NOREWIND 142 NOSAFEGUARD 142 Guidelines 142 NOSQLDATA 142 Guidelin...

Page 8: ... 153 SQLTAPEPARTARRAY 154 Guidelines 154 START 154 Guidelines 154 Example 154 TAPEDATE 155 Examples 155 TARGET 155 Guidelines 156 TURNOFFAUDIT 156 VERIFY 156 Guideline 156 VERIFYTAPE 156 Guideline 156 VOL 156 Guidelines 157 VOLUMEMODE 157 Guidelines 157 Completion Information 157 RESTORE Guidelines and Examples 158 Viewing the Contents of a Tape 159 Restoring Enscribe Files 159 Examples 161 Restor...

Page 9: ...g the LABELS BYPASS DEFINE Attribute 176 Examples 177 Restoring in Volume Mode 179 Example 180 A BACKCOPY BACKUP and RESTORE Messages 182 49 182 1070 182 1500 182 2003 182 2012 182 2013 183 3nnn 183 6000 183 601 1 183 7000 183 7001 184 7002 184 7003 184 7004 184 7005 185 7006 185 7007 185 7008 185 7009 185 7010 185 701 1 186 7012 186 7013 186 7014 186 7015 187 7016 187 7017 187 7018 187 7019 188 7...

Page 10: ... 7048 193 7049 194 7050 194 7052 194 7053 194 7054 194 7055 195 7057 195 7058 195 7060 195 7061 195 7062 196 7063 196 7064 196 7066 196 7069 196 7073 197 7075 197 7077 197 7078 197 7079 197 7080 197 7081 198 7083 198 7088 198 7089 198 7090 198 7091 199 7092 199 7093 199 7094 199 7095 199 7103 199 7105 200 7109 200 7120 200 7121 200 7122 201 10 Contents ...

Page 11: ...7146 204 7147 204 7157 204 7158 204 7159 205 7251 205 7252 205 7253 205 7254 205 7255 206 7257 206 7258 206 7259 206 7260 206 7264 207 7266 207 7267 207 7268 207 7269 207 7270 208 7271 208 7274 208 7500 208 7501 208 7502 209 7503 209 7504 210 7505 210 7508 211 7509 211 7510 212 751 1 212 7512 213 7513 213 7514 214 7515 214 7516 214 7518 215 Contents 1 1 ...

Page 12: ... 7750 220 7751 220 7752 221 7753 221 7754 221 7755 221 7757 221 7758 221 7759 222 7760 222 7761 222 7762 222 7763 222 7764 222 7765 223 7766 223 7767 223 7768 223 7769 223 7770 224 7771 224 7772 224 7774 224 7775 224 7776 224 7777 225 7778 225 7779 225 7780 225 7781 225 7782 226 7783 226 7784 226 7785 226 7786 226 7787 226 7789 227 7790 227 12 Contents ...

Page 13: ... 7813 230 7814 230 7815 231 7816 231 7818 231 7819 231 7820 231 7824 231 7831 232 7832 232 7833 232 7834 232 7835 232 7836 233 7837 233 7900 233 8000 233 8001 233 8002 234 8003 234 8004 234 8005 234 8006 234 8007 235 8008 235 8009 235 8010 235 801 1 235 8012 236 8013 236 8014 236 8015 236 8016 236 8025 237 8026 237 8027 237 8028 238 8029 238 Contents 13 ...

Page 14: ... 247 8057 248 8058 248 8059 249 8060 249 8061 250 8062 250 8063 251 8064 251 8065 252 8066 252 8067 253 8068 253 8069 254 8070 254 8071 255 8072 255 8100 256 8101 256 8102 256 8103 256 8106 256 8107 257 8108 257 81 10 257 81 1 1 257 81 12 257 81 13 258 81 15 258 81 16 258 81 17 258 81 18 258 81 19 258 8120 259 8121 259 8122 259 8123 259 8126 259 14 Contents ...

Page 15: ...BACKUP Volume Mode Syntax 284 DCOM Syntax 284 DSAP Syntax 284 PAK UNPAK Syntax 285 RESTORE File Mode Syntax 285 RESTORE Volume Mode Syntax 287 E CLASS TAPE DEFINEs 288 TAPE DEFINE Attributes 288 TAPE DEFINE Consistency Checks 291 F Tape Label Formats 293 ANSI Standard Labels 293 ANSI VOL1 Label Format 293 ANSI HDR1 EOF EOV1 Label Format 293 ANSI HDR2 EOF2 EOV2 Label Format 294 IBM Standard Labels ...

Page 16: ...e of the Short Report 108 21 DDL Format of the Permanent Work File 112 Tables 1 Disk and Tape Utilities and Their Associated Tasks 24 2 DSAP Report Samples 26 3 Tape Formats 31 4 History and Attributes of Tape Formats 31 5 Default Tape Formats and Tape Format Options 32 6 Completion Codes Returned by BACKCOPY and the Operating System 37 7 File Attributes for the WHERE Expression 45 8 BACKUP and TM...

Page 17: ...y 2013 Utilities G06 523325 017 New and Changed Information Changes to the 523325 017 Manual The following revisions were done for the J06 15 and H06 26 RVUs Added a new option SHOWPATH under SHOWNAMEMAP page 92 Added the details of the new option SHOWPATH under SHOWNAMEMAP page 96 Added a new option SHOWPATH under SHOWNAMEMAP page 285 Changes to the 523325 016 Manual Added volume information page...

Page 18: ...l Removed the procedure for restoring EKS files to classic key sequenced files Changes to the 523325 013 Manual Added HP Encourages Your Comments page 23 Updated Restoring Enscribe Files page 159 Added Restoring SQL Files page 166 18 ...

Page 19: ...ackup tapes Chapter 2 BACKCOPY Describes BACKUP a utility that backs up disk files to tape Chapter 3 BACKUP Describes Disk Compression DCOM a utility that compresses disks by moving extents to save disk space Chapter 4 Disk Compression DCOM Describes the Disk Space Analysis Program DSAP a utility that analyzes how disk space is being used on a specific volume Chapter 5 Disk Space Analysis Program ...

Page 20: ... location described For example For examples of BACKUP commands that use qualified file set lists see Using Qualified File Set Lists page 74 General Syntax Notation This list summarizes the notation conventions for syntax presentation in this manual UPPERCASE LETTERS Uppercase letters indicate keywords and reserved words Type these items exactly as shown Items not enclosed in brackets are required...

Page 21: ...t previously described must be entered as shown For example error NEXTFILENAME file name LISTOPENS SU process name su name Quotation marks around a symbol such as a bracket or brace indicate that the symbol is a required character that you must enter as shown For example repetition constant list Item Spacing Spaces shown between items are required unless one of the items is a punctuation symbol su...

Page 22: ...isplayed For example Event number number Subject first subject value A group of items enclosed in brackets is a list of all possible items that can be displayed of which one or none might actually be displayed The items in the list might be arranged either vertically with aligned brackets on each side of the list or horizontally enclosed in a pair of brackets and separated by vertical lines For ex...

Page 23: ...Bar Notation Change bars are used to indicate substantive differences between this manual and its preceding edition Change bars are vertical rules placed in the right margin of changed portions of text figures tables examples and so on Change bars highlight new or revised information For example The message types specified in the REPORT clause are different in the COBOL environment and the Common ...

Page 24: ...n 2 GB minus 1 MB A format 2 file is either a large format file or a file that can contain larger partitions than a file created on RVUs preceding G06 00 or D46 00 A format 2 file can exceed the 2 GB minus 1 MB size limit of a format 1 file For more information about handling format 1 and format 2 files see the File Utility Program FUP Reference Manual Utility Descriptions Table 1 Disk and Tape Ut...

Page 25: ...ilities T9074 You must use the syntax documented in this manual for Enscribe and SQL MP files For Open System Services OSS and SQL MX files you must use the syntax documented in the Backup and Restore 2 0 Manual NOTE BRCOM does not support the same tape format as the Backup and Restore utilities T9074 You cannot mix Enscribe and SQL MP files on the same tape with OSS and SQL MX files BACKUP has tw...

Page 26: ...specify any DSAP options in the DSAPCSTM file DSAP options specified in the DSAPCSTM file are appended to the DSAP command that you enter at the TACL prompt For more information on these features see DSAPCSTM File page 115 You can receive DSAP output in several different report formats that analyze the disk differently Table 2 DSAP Report Samples Description Report Analyzes the space used by each ...

Page 27: ...starts BACKUP and UNPAK starts RESTORE To run PAK or UNPAK the BACKUP and RESTORE programs must be available that is they must exist and be secured so you can execute them Because PAK and UNPAK use BACKUP and RESTORE you need to be familiar with these utilities RESTORE The RESTORE utility copies files from a backup tape to disk and displays tape file information This utility is essential for compl...

Page 28: ...hare a common procedure for mounting tapes on the tape drive The utilities can use the CLASS TAPE DEFINE to trigger ZSVR to process a labeled tape request NOTE BACKUP and RESTORE can also use the CLASS TAPECATALOG DEFINE to trigger ZSVR to process a labeled tape request For information about the CLASS TAPECATALOG DEFINE see the DSM Tape Catalog User s Guide The appendable tape feature is only avai...

Page 29: ...of the command but the disk and tape utilities do not Mounting a Tape To mount an unlabeled tape for a BACKCOPY BACKUP or RESTORE process 1 Check the input and output media write settings For a BACKUP or BACKCOPY process ensure the output tape media is write enabled For tape reels be sure the write ring is inserted For a RESTORE or BACKCOPY ensure the input tape media is not write enabled For tape...

Page 30: ... these situations ZSVR issues the status message after a new tape is mounted or the tape drive is opened If you manually dismount an unlabeled tape and mount another unlabeled tape on the same drive ZSVR does not detect a tape dismount and does not issue the status message The volume ID printed in the status message vid is incorrect if the dismount is caused by any of these commands CLOSE command ...

Page 31: ...P2 files or file sets with both DP2 and DP1 files 2 C00 or later ARCHIVEFORMAT Archive tape format for parallel copies labeled tapes SQL objects and DP2 files 3 Tape Format History The history of the various tape formats and their associated attributes are summarized in Table 4 which identifies the NonStop software version in which these attributes were introduced Table 4 History and Attributes of...

Page 32: ...option is specified Default Tape format 2 B00 rules c and d still apply B40 Tape format 3 introduced Conditional default C00 C3x Dxx a Default Tape format 2 if no tape format 3 attributes are present and no tape formatting parameter is specified b Default Tape format 3 if labeled tapes are used parallel copies are specified or system is configured with SQL c Override Tape format 1 if DP1FORMAT BAC...

Page 33: ...ss to a subset of users by either setting file security attributes or using a Safeguard access control list Give the super group user 255 n EXECUTE access to a PROGID copy of the BACKCOPY program with PROGID set to the super ID 255 255 Check the security policy established by your organization to set the appropriate level of access to BACKCOPY and all system programs For a complete discussion on s...

Page 34: ...tic tape unit such as TAPE1 ldev is the device number of the magnetic tape unit such as 17 define name specifies a DEFINE name of CLASS TAPE for copying a labeled backup tape For a list of all the CLASS TAPE DEFINE attributes see Appendix E CLASS TAPE DEFINEs dest tape is the name of the tape drive or drives to which duplicate tapes are written You can use a DEFINE of CLASS TAPE with the attribute...

Page 35: ... end of tape This option is available starting with the G06 version of BACKUP NOREWINDOUT directs the BACKUP utility to leave the last written tape positioned at its current location and leave it online when the BACKUP process is completed This option lets the tape be labeled for the next BACKUP without having to search for the end of tape This option is available starting with the G06 version of ...

Page 36: ...STORE can read tapes generated in tape format 3 archive format BACKCOPY supports labeled tape processing in the same way as BACKUP For more information see Backing Up With Labeled Tapes page 77 A duplicate tape generated with BACKCOPY is not the same as parallel tape copies generated with BACKUP When parallel copies are made with BACKUP both copies contain exactly the same amount of information on...

Page 37: ...ol Completion Information BACKCOPY returns a completion code to the process that started it The completion code indicates how successfully BACKCOPY ran Its primary purpose is to support batch processing by allowing conditional execution of subsequent processes based on the success of the BACKCOPY operation If TACL started BACKCOPY the completion code is stored in a TACL variable _COMPLETION where ...

Page 38: ...ith fatal errors BACKCOPY terminated because of a fatal error or an invalid user command and the copy generated might not be complete 3 BACKCOPY never started This completion code is generated by the TACL process executing BACKCOPY The terminationinfo field holds the error code returned by the process creation procedure 4 38 BACKCOPY ...

Page 39: ... disk space by archiving files that are used infrequently Use labeled tapes Move files from one system to another Convert files from one type of disk process to another from DP1 to DP2 NOTE Updated operating system software uses the DP2 standard and does not always support the DP1 standard A conversion might be a one time maintenance operation or an infrequent necessity when an old backup tape is ...

Page 40: ...he tape is restored After creating a backup you cannot view all the options you used when you ran BACKUP so note the options you use each time you run BACKUP BACKUP and RESTORE have two modes of operation File mode in which BACKUP copies one file at a time to create a tape that is a sequence of individual files Volume mode in which BACKUP transfers an entire disk volume to tape Only the super ID 2...

Page 41: ...command see the TACL Reference Manual tape device name is the name of a tape drive to use for an unlabeled tape BACKUP operation or a DEFINE name for a labeled tape BACKUP operation To create a single backup tape specify one tape device name To create two identical backup tapes on two separate drives specify two names enclosed in parentheses and separated by a comma For unlabeled tape operations t...

Page 42: ...d Card Characters in a File Set A file set can contain these wild card characters in the volume subvolume and file id fields Matches from 0 through 8 characters in the position where it appears asterisk Matches one character in the position where it appears question mark For example the volume name SB matches all four character volume names that begin with SB The file name CH matches all file name...

Page 43: ... list START filename WHERE expression Each qualifier can be specified only once for a given fileset list You can specify qualifiers in any order An example of a list element of a qualified fileset list is DATA PAYROLL X WHERE ENSCRIBE AND INDEX File Set List Qualifiers For examples of BACKUP commands that use qualified file set lists see Using Qualified File Set Lists page 74 EXCLUDE fileset list ...

Page 44: ... AND OR Possible expressions are OWNER user id timestamp field conditional time value FILECODE conditional number EOF conditional number file attribute OWNER user id specifies a NonStop user ID in one of these forms group name user name group name group number user number group number timestamp field conditional time value selects a file based on when it was created last modified or last opened or...

Page 45: ... as some BACKUP options you can use additional qualifiers NOT AND and OR with the file attributes for the WHERE expression If you specify a file attribute and a similar BACKUP option the result is identical For example you get the same result when you specify the EXCLUDE attribute or the NOT option or when you specify both For descriptions of each BACKUP option see BACKUP Options page 47 Table 7 F...

Page 46: ...ID flag is set PROGID Relative files RELATIVE Files that require a TMF rollforward operation A likely use is WHERE NOT ROLLFORWARDNEEDED ROLLFORWARDNEEDED Files protected by the Safeguard product SAFEGUARD Shorthand SQL views or protection SQL views Without this attribute all SQL views are backed up SHORTHAND PROTECTION VIEW All types of SQL files but not SQL program files SQL SQL object program f...

Page 47: ...t a backup for P ZYS BACKUP responds indicating zero files were backed up Volume Mode BACKUP Options These BACKUP options are available in volume mode TAPEMODE NEEDBOTH BLOCKSIZE VERIFYTAPE NOPROMPT DENSITY VOLUMEMODE NOREWIND LISTALL WHOLEDISC NOUNLOAD MULTIDRIVE NOTE Any volume mode BACKUP RESTORE request to a SMF virtual disk results in the following error message Volume Mode BACKUP RESTORE is ...

Page 48: ...delines BACKUP automatically uses tape format 3 unless DP1FORMAT or DP2FORMAT is specified For more information see Tape Formats page 31 Example To back up files in the archive format 1 BACKUP TAPE OLD1 OLD2 LISTALL ARCHIVEFORMAT This command produces these results All disk files on volumes OLD1 and OLD2 are backed up on the tape that is mounted to the device TAPE The terminal displays the names o...

Page 49: ... What BACKUP Does State of File BACKUP Options Used File is not written to tape Message Audited File Skipped is sent to output file Open or closed No AUDITED option File is written to tape Closed or open for shared or protected read AUDITED File is not written to tape Message Error 12 File Aborted is sent to output file Open for write or open exclusive AUDITED File is written to tape Open for shar...

Page 50: ...ED option is omitted in the RESTORE command so that only the nonaudited files are restored After the RESTORE operation the audited files are recovered using the TMFCOM utility For more information on backing up open files see OPEN page 61 BLOCKSIZE The BLOCKSIZE option specifies the size of each tape record block written to the backup tape BLOCKSIZE data record size data record size is the number ...

Page 51: ...he enhancement installed Check your EXPAND environment for BLOCKSIZE support CATALOGFILES The CATALOGFILES option enables you to catalog information about disk files CATALOGFILES every n files every n files is the number of disk files in the range of 1 through 20000 The default value is 20000 After every n files is processed the disk file entries will be made for each disk file written on to the t...

Page 52: ...meis a CLASS TAPE DEFINE name the DENSITY attribute of the DEFINE must either be unspecified or must match density The default density is the physical setting of the tape drive DP1FORMAT The DP1FORMAT option directs the BACKUP utility to write all files to tape in DP1 format tape format 1 DP1FORMAT Guidelines Any DP2 files encountered are converted on disk into temporary DP1 files and then written...

Page 53: ... the file If BACKUP converts a primary DP1 entry sequenced file to DP2 format the program displays a warning instructing you to perform a FUP LOADALTFILE operation on all the alternate key files of this primary file For instructions on using the FUP LOADALTFILE command see the File Utility Program FUP Reference Manual Although you can specify the PARTONLY option BACKUP backs up entire partitioned ...

Page 54: ...ases in converted key sequenced files If BACKUP returns error 45 for a key sequenced and partitioned file because the default extent size of the temporary disk file used by BACKUP is too small use the EXT option to specify larger extent sizes Examples To convert DP1 files to DP2 format and set primary and secondary extent sizes to two and three pages respectively for the files in DP1 CONV 1 BACKUP...

Page 55: ...clusively on the volume FIN 1 BACKUP TAPE1 FIN INDEXES IMPLICIT AUDITED For SQL tables that are backed up all indexes are also backed up no matter what volume the indexes are on Indexes on FIN that are defined for base tables that are not on FIN are not backed up To back up all files and SQL tables except those that are open on the volume FIN 2 BACKUP TAPE1 FIN INDEXES EXPLICIT AUDITED For SQL tab...

Page 56: ... number of the magnetic tape reel or tape cartridge where the file was written Reel n Volume and subvolume of files vol subvol Files backed up If the letter C follows the file ID the file is corrupt If B follows the file ID the file is broken and needs media recovery filename File code of the listed file If the letter A follows the code the file is audited by TMF If L follows the code the file is ...

Page 57: ...n Warnings related to the tape device appears only if relevant to the specific backup operation Tape related warnings n NOTE The FLTrustFlags attribute is supported only on systems running H series RVUs or J series RVUs MSGONLOCK The MSGONLOCK option lets you back up or skip a file that is locked by responding to a message MSGONLOCK Guidelines When MSGONLOCK is specified BACKUP displays this messa...

Page 58: ...ives until the tape set is finished In this example BACKUP is set to write to tape 1 on TAPE1 tape 2 on TAPE2 tape 3 on TAPE1 and tape 4 on TAPE2 NEEDBOTH The NEEDBOTH option lets you terminate a parallel BACKUP if an error occurs on one of the tapes NEEDBOTH Guideline Without the NEEDBOTH option you cannot stop a parallel BACKUP if one of the tape operations fails The parallel BACKUP continues wi...

Page 59: ...e process is complete NOREWIND The NOREWIND option directs the BACKUP utility to leave the tape positioned at its current location and leave it online when the BACKUP process is completed This option lets the tape be labeled for the next BACKUP without having to search for the end of tape This option is only available starting with the G06 version of BACKUP NOREWIND NOREWIND is mutually exclusive ...

Page 60: ...tions This provides a create like function for multiple partition objects Since a NOSQLDATA BACKUP contains no sensitive customer data it is more manageable for development debugging of DDL and file label problems than a full data tape This option cannot be used in the same BACKUP command as the SQLCATALOGS option When you use this option this warning message is displayed at BACKUP time WARNING 71...

Page 61: ... as the WHERE expression qualifier Using this qualifier results in the BACKUP process skipping the files that are currently open and an error is not received For more information about the WHERE NOT OPEN qualifier refer to File Attributes page 45 OPEN CAUTION If you restore a file that was modified or open for write access while being backed up file system error 59 file is bad can occur and data c...

Page 62: ... new node or volume name or both for a secondary partition of a partitioned file This option causes the secondary partition name to be inserted in the file label of the primary partition and it applies only to Enscribe files PART sec partition num node volume pri extent size sec extent size sec partition num is an integer in the range 1 through 15 inclusive that designates the secondary partition ...

Page 63: ...the destination partition extent sizes when converting files from one disk process type to another You cannot specify extent sizes with the PART option if your BACKUP command also contains the PARTONLY ON option If you include the PART and PARTONLY ON options BACKUP changes the name of the secondary partition in the file label of the primary partition If you include the PART option without PARTONL...

Page 64: ...tape the file label for each file that is not backed up That is in addition to the files modified since the partial dump date a partial backup tape contains file label information for files that have not been modified Use the WHERE MODTIME and CREATION TIME qualifiers instead of the PARTIAL option to create a tape that contains only the files created or modified after a specific date For syntax in...

Page 65: ...partitioned file is backed up even though the secondary partitions are not named in the backup files If you name a secondary partition of a file in backup files but not the primary partition PARTONLY OFF specifies that the secondary partition is not backed up When converting files from one disk process type to the other using BACKUP with the PARTONLY ON option skips all relative files and any DP1 ...

Page 66: ...er specified as 2 4 8 12 16 20 24 28 32 36 40 44 48 or 52 Guidelines REMOTEIOSIZE values above four 4096 bytes cause RESTORE to use BulkIO logic The default SQL remote I O transfer size on the NonStop operating system is 4 KB 4096 bytes Local I O transfer size for SQL objects is 28 KB Use of the BLOCKSIZE option when creating the BACKUP limits the available REMOTEIOSIZE values For example specifyi...

Page 67: ...EN option causes files to be backed up with shared read access instead of protected read access This gives other processes read write access to the backup files during BACKUP procedures SHAREOPEN CAUTION If you restore a file that was modified while being backed up file system error 59 file is bad can occur and data can be lost File inconsistencies are not detected during BACKUP or RESTORE but mig...

Page 68: ...with a file code of 0 Changes made in a SQL catalog after it is backed up are not preserved if the catalog on the BACKUP tape is restored to the same catalog name This option cannot be used in the same BACKUP command as the NOSQLDATA option For more information see Backing Up SQL Files page 74 and SQLCATALOGS page 153 START The START option specifies where in backup files the BACKUP procedure is t...

Page 69: ...t a time Guidelines You cannot specify the TAPEMODE and DENSITY options in the same BACKUP command The default recording mode is the physical setting of the tape drive if you do not specify the TAPEMODE option VERIFYREEL The VERIFYREEL option for use in file mode only directs BACKUP to examine each reel for data integrity after the tape is written VERIFYREEL Guidelines Using the VERIFYREEL option ...

Page 70: ... the VOL option all the files you are backing up must reside on the same volume If you specify a new subvolume name with the VOL option all the files you are backing up must reside on the same subvolume The new volume or subvolume you specify with the VOL option must be on the node you are backing up You cannot use wild card characters with this option VOLUMEMODE The VOLUMEMODE option directs BACK...

Page 71: ...tact Restore the tape to a nonproduction system and use the SCF CONTROL DISK REBUILDDFS command to repair the corrupt FST Completion Information The BACKUP utility returns a completion code to the process that started it The completion code indicates if the BACKUP procedure ran successfully Its primary purpose is to support batch processing by allowing conditional execution of subsequent processes...

Page 72: ...specify two nodes in the BACKUP command BACKUP records the names of the files in the QFS in local internal format without a node identifier volume subvol file id Although the files in the QFS all originate from one node they might have implicit relationships with files on other nodes For example a file might be partitioned over several nodes or a base table might reside on one node while its index...

Page 73: ...as the system subvolumes SYSTEM SYSTEM and SYSTEM SYSnn UP matches all of the files that have names ending with UP such as BACKUP and FUP MON matches all of the files that have four letter names ending with MON such as IMON and DMON but not NETMON COBOL matches all files that have six letter names that begin with COBOL such as COBOL1 COBOL2 but not COBOL or COBOLLIB Backing Up Format 1 and Format ...

Page 74: ...from all subvolumes whose names match the form T9 D46 on volume SPECIAL 1 BACKUP TAPE SPECIAL T9 D46 1 WHERE FILECODE 100 LISTALL To back up all files in the system that are licensed and not owned by the super ID 255 255 except those in the SYSTEM SYSTEM subvolume or any subvolume of the form SYSTEM SYS 1 BACKUP TAPE 1 EXCLUDE SYSTEM SYSTEM SYSTEM SYS 1 WHERE LICENSED AND NOT OWNER 255 255 LISTALL...

Page 75: ...only use the SQLCATALOGS ON option to dump all SQL catalogs when reporting a problem to HP support BACKUP and RESTORE do not work with remote SQL tables if SQL is not installed on the local node To provide a create like function for multiple partition SQL objects use the BACKUP NOSQLDATA option followed by RESTORE MAP NAMES The resulting SQL object is an empty copy of the original In case of disk ...

Page 76: ...ny DP1 entry sequenced files that do not have DP2 block sizes For example blocks of 1536 2560 3072 or 3584 bytes are not compatible with DP2 An error message gives the names of the skipped files You must back up these files without the PARTONLY option If you specify the PARTONLY ON option BACKUP backs up entire partitioned files that have some secondary partitions on remote nodes if you include th...

Page 77: ... and the MEDIACOM console if one exists For more information see Backing Up or Converting DP1 and DP2 Files page 76 For a description of MEDIACOM see the DSM Tape Catalog Operator Interface MEDIACOM Manual Three types of labeled tapes can be used with BACKUP BACKCOPY and RESTORE ANSI IBM and BACKUP BACKUP can write to scratch ANSI scratch IBM and BACKUP labeled tapes RESTORE can accept only IBM an...

Page 78: ...ommand to use a labeled backup tape You create the DEFINE in the same way you create DEFINEs for ANSI and IBM labeled tapes If you are not familiar with labeled tape processing on NonStop systems or with DEFINEs see the Guardian User s Guide It gives instructions on using different DEFINEs including CLASS TAPE DEFINEs for labeled tape processing The two differences between using TAPE DEFINEs for b...

Page 79: ... Scratch Tapes You can use expired BACKUP IBM or ANSI labeled tapes for labeled tape BACKUP procedures If no expired tapes exist you can create an ANSI or IBM labeled scratch tape using MEDIACOM NOTE Scratch ANSI or BACKUP tapes can be used with LABELS BACKUP Only scratch IBM tapes can be used for LABELS IBMBACKUP If you want to use specific scratch tapes specify the volume IDs in the VOLUME attri...

Page 80: ...p in Volume Mode In volume mode BACKUP transfers an entire disk volume to tape Only the super ID 255 255 can use the volume mode backup procedure When performing a volume mode backup The volume being backed up must be in the DOWN disk state If only one mirror of a mirrored pair is being backed up only that mirror needs to be in the DOWN state the other mirror can be UP If you are backing up only o...

Page 81: ... STOP DISK commands for both paths to the mirrored half being copied STOP DISK DATA M STOP DISK DATA MB 7 Verify that all paths to the removed half of the mirrored volume are DOWN and then exit SCF INFO DISK DATA DETAIL EXIT In this example DATA M was just removed so SCF should show the paths DATA M and DATA MB to be DOWN 8 Enter the volume mode BACKUP command In this example the mirrored half of ...

Page 82: ...ould have been left in the special S state If this happens use the SCF STOP DISK command to bring down the paths before proceeding 10 After the backup finishes bring up the mirrored volume so that both halves of the mirrored volume match START DISK DATA EXIT 82 BACKUP ...

Page 83: ... page 86 Guidelines page 88 Examples of Compression Output page 89 Changing the Default Work File Volume Security DCOM is privileged and each customer must determine which users are allowed to run it To control access to DCOM Do not license DCOM s program file for general use Without licensing only the super ID 255 255 can run DCOM License DCOM s program file and limit access to a subset of users ...

Page 84: ...le is a text file that contains the remainder of the command line including parameters and options For a complete list of run options see the description of the TACL RUN command in the TACL Reference Manual volume specifies the disk volume where the compression is to be performed The volume specified must reside on the node where DCOM will run The volume can contain Enscribe SQL Kernel Managed Swa...

Page 85: ...tual disks Running DCOM P is permitted DCOM performs on a single physical volume basis It will not move extents from one volume to another even if the two physical volumes are part of the same SMF storage pool Some SMF files must be accessible to SMF at all times Because DCOM opens files exclusively during a move it will not attempt to move these SMF file types DCOM identifies these SMF files with...

Page 86: ...ion but a disk error or an internal error prevented full compression DCOM includes this termination information with the completion code 2 Text Terminationinfo Disk structure anomalies or I O errors 1 Internal program error 2 An abnormal voluntary termination with fatal errors DCOM did not compress the disk because of severe disk errors severe structural errors a fatal program error or an invalid ...

Page 87: ...is not available DCOM abends and displays DIRECTORY WORKFILE CREATION OPEN MAPPING ERROR 43 TRY AGAIN WITH 1024MB WORKSPACE If the system crashes while DCOM is running temporary files could be left on the disk being compressed The files are then owned by the super ID 255 255 and secured N These files have the CLEARONPURGE option set if they have been used to move the extents of the files set for C...

Page 88: ...moves any extents it sends messages to the event message collector 0 Figure 8 Format of DCOM Operator Messages Before the Move While DCOM Moves File Extents DCOM sends a report to the current output device denoting each file extent it moves and which files were directly affected For example in Move Num 5 displayed in Figure 9 DCOM moves extent 1 1 of the file XRAYENF QCACHE from page 52181 on the ...

Page 89: ... 16 example the volume name for the DCOM work file is set to TEMP The characters for the volume name must be specified by twos within quotation marks TEMP is specified T EM P for a total of eight characters 1 VOLUME SYSTEM SYSTEM 2 BIND FILE DCOM ADD MODIFY CODE SELECT WORK VOLUME ASCII 0 T EM P BUILD DCOM EXIT 3 FUP LICENSE DCOM The FUP LICENSE command is optional depending on what kind of file s...

Page 90: ... pages 4 K contain the checksums Therefore the unused pages are shown as 14 pages The Dealloc pages column of the DSAP report considers the check blocks Page Topic page 90 Security page 91 DSAP Syntax page 93 Reporting SMF Files page 93 Exiting DSAP page 93 Stopping DSAP page 93 DSAP Options page 98 Completion Information page 99 Guidelines Running DSAP page 101 Report Formats page 109 DSAP Exampl...

Page 91: ...re TACL is running usually the node where your terminal is connected run option is any option for the command interpreter RUN command The two most common run options are IN filename OUT listfile The IN option specifies input files and the OUT option specifies output files These files usually override the home terminal as the input or output device An IN file is a text file that contains the remain...

Page 92: ...rs can follow volume specification in any order Using commas to separate options is optional If no options are specified with volume specification the DSAP utility only produces the summary report The summary report is printed with each report except the SHORT report report options ANALYSIS BYSUBVOL BYUSER DETAIL FILESIZE FILESPACE FREESPACE NEWFORMAT G series only SHORT SPACE SUMMARY TERAFORM G s...

Page 93: ...Y report does not produce the Space Allocation Consistency Analysis or the Media Failure Analysis on a virtual volume A message is printed indicating that this is a virtual volume instead of a message indicating the size of the disk All percentages that compare space use with the size of the disk are displayed as 0 0 which affects the SUMMARY FREESPACE and FILESPACE reports Wild card characters in...

Page 94: ... Such a file was open at the time of a total system crash or when the disk on which it is located became unavailable The crash opened state is cleared when the file is opened successfully DEALLOC number causes the DETAIL report to include all the files in the file set with number or more pages of deallocatable extents The number is an integer in the range 0 through 2 147 483 647 2 See Figure 19 Sa...

Page 95: ...rates the file extent size distribution report an analysis of the distribution of allocated extent sizes The presence of a virtual volume causes all percentages that compare space use with the size of the disk to be displayed as 0 0 percent See Figure 15 Sample File Extent Size Distribution Report FILESPACE page 104 FREESPACE generates the free space distribution report an analysis of the distribu...

Page 96: ...t If the disk specified is a physical disk then the column header displays Virtual Name and the virtual name of the file if one exists otherwise the column header displays Physical Name and the physical name of the file This option is not part of the selection criteria and it applies only when a DETAIL option is also specified SHOWPATH displays the OSS path information when used with any of the DE...

Page 97: ... date NOPURGEUNTIL that is later than the current date UNUSED number causes the DETAIL report to include all of the files in the file set with number or more pages of unused space The number is an integer in the range 0 through 2 147 483 647 2GB USER instructs DSAP to analyze only the files owned by a single user or by a single group of users If you omit the USER option DSAP analyzes all of the fi...

Page 98: ...BJECT TYPE Differentiates between ANSI and materialized views in SQL VIEW TYPE Completion Information DSAP returns completion information to the process that started it The completion code indicates how successful DSAP ran Its primary purpose is to support batch processing by allowing conditional execution of subsequent processes based on the success of the DSAP process If TACL started the DSAP pr...

Page 99: ...never started so the completion code is generated by the TACL process that is executing DSAP The terminationinfo field holds an error code from the process creation procedure 4 DSAP ended abnormally and returned 0 in the terminationinfo field 5 Guidelines Running DSAP DSAP has no internal security restrictions except that it requires licensing The system manager controls access to DSAP by using th...

Page 100: ...nce Manual for the Storage Subsystem The simplest method for recovering lost free space is to use REBUILDDFS because it does not need tapes Because DSAP creates reports about the contents of disk volumes you can also use it on virtual volumes DSAP L but some of the report options are ignored such as any reports that deal with free disk space This is similar to DSAP interaction with the USER option...

Page 101: ...t SHORT File names and types based on detail selection options used but with increased column width Must use this option for disks larger than 36 GB User Detail NEWFORMAT File names and types based on detail selection options used in tabular format User Detail TABULAR Reports based on selection options used but with increased column width You must use this option for disks larger than 72 GB Use wi...

Page 102: ...ost free space and extent overlaps see Guidelines Running DSAP page 99 The summary of space allocation anomalies which divides the space allocation consistency analysis into disk free space table inconsistencies doubly allocated pages and lost free space pages The media failure analysis which reports if the disk primary or mirror is DOWN or has unspared defective sectors If the disk has any unspar...

Page 103: ... transactions use the SQLCI CLEANUP command to remove this entry For more information see the SQL MP Installation and Management Guide Space Distribution Reports DSAP performs space distribution analysis for these types of space Report Option Type of Space FREESPACE Free space extents FILESPACE Allocated file extents SPACE Both free and allocated extents FILESIZE Entire files All report types firs...

Page 104: ... displays information in the same manner as the free space distribution report Figure 15 Sample File Extent Size Distribution Report FILESPACE To produce a file size distribution report 1 DSAP volume FILESIZE This report displays information in the same manner as the free space distribution report 104 Disk Space Analysis Program DSAP ...

Page 105: ...port portion always list the number of free space pages available followed by the number of pages devoted to the disk directory The next entry is for any temporary files that exist The rest of the report is an alphabetically lists subvolumes with this information for each Number of files Total pages allocated Total pages of unused space Pages of unused space in deallocatable extents Pages in the l...

Page 106: ...to the system which occurs if users are deleted from the system but the files they owned are not deleted The sample user summary report displays this information for each user ID Number of files Total pages allocated Pages of unused space Pages in deallocatable extents Pages in the largest file Age information two columns including the number of days since a file was modified MOD and opened OPN 1K...

Page 107: ...s invalid SQL protection or SQL shorthand views the file is corrupt Enscribe files C 3 Key sequenced file structure base and index tables K 4 Entry sequenced file structure base and index tables E Relative file structure base and index tables R Unstructured file blank The file is a primary partition base and index tables P 5 The file is a secondary partition Enscribe files only X NOTE Only Enscrib...

Page 108: ...f DSAP reports that a file has doubly allocated extents and the message SQL Shadow appears after the file name the file is an SQL table that has been dropped but the drop is not yet committed Such a file is invisible but its extents are still allocated until the drop is committed If there are no outstanding drop transactions use the SQLCI CLEANUP command to remove this entry For more information s...

Page 109: ... varies based on the disk size The column width is the same as in the NEWFORMAT report for disks of 72 GB or smaller Otherwise the column width is the same as in the TERAFORM report If you enter any of the NEWFORMAT or TERAFORM options with the TABULAR option the TABULAR report is displayed Teraform Report You must use the TERAFORM option in DSAP command for disks of 72 GB or larger When you run D...

Page 110: ... DSAP DATA USER SALES JANET DETAIL To create only the summary report on the volume DATA for the current user 1 DSAP DATA USER To create a detail report for the files on volume DATA that are Enscribe files or SQL object program files 1 DSAP DATA DETAIL ENSCRIBE To create a detail report for the files on volume DATA that are SQL files 1 DSAP DATA DETAIL SQL To create a DETAIL report limited to SQL f...

Page 111: ...ith Binder as described in Changing the Default Work File Volume page 111 If you do not specify a WORKFILE option the work file from DSAP is allocated by default on the volume where the program swap file resides To alter this default permanently use Binder Any errors that occur when DSAP creates or allocates the work file space are reported in the output file and cause DSAP to terminate Always use...

Page 112: ...played in Figure 21 NOTE An SQL sensitive object file program is not considered an SQL file The file kind field in the Workfile Report displays SQL sensitive object files programs as ENS for Enscribe Figure 21 DDL Format of the Permanent Work File 1 12 Disk Space Analysis Program DSAP ...

Page 113: ...Format of the Permanent Work File 1 13 ...

Page 114: ...1 14 Disk Space Analysis Program DSAP ...

Page 115: ...eates a list of all the EDIT files including the corresponding end of file markers 1 Create an EDIT file for the Enform product to use as a source The file should contain DICTIONARY ASSIGN Directory Record TO workfile name OPEN Directory Record LIST File EOF WHERE FileCode 101 AND Owning Group 1 AND Owning User 100 CLOSE Directory Record 2 Run ENFORM 1 ENFORM IN edit file OUT outfile Alternatively...

Page 116: ...xists in the DEFAULT VOL SUBVOL of the user running DSAP DSAP creates the DSAPCSTM file in your DEFAULT VOL SUBVOL the first time you run DSAP or when the file has been purged If the DSAPCSTM is already in your DEFAULT VOL SUBVOL DSAP reads information from this file DSAP closes the custom file after reading it For usage guidelines see Guidelines Running DSAP page 99 1 16 Disk Space Analysis Progr...

Page 117: ... BACKUP options UNPAK uses RESTORE to decompress files from the archive file PAK starts BACKUP and UNPAK starts RESTORE To run PAK or UNPAK the BACKUP and RESTORE programs must be available that is they must exist and be secured so you can execute them Because PAK and UNPAK use BACKUP and RESTORE you need to be familiar with these utilities PAK Command Options The syntax to run PAK is PAK run opti...

Page 118: ...porary file with the name given by C function tmpname and writes the file names and backup options to that file which is then used as the BACKUP infile The temporary file is purged when PAK stops unless it is stopped prematurely In this case purge the temporary file CTMPnnnn explicitly You can also use the infile syntax can with UNPAK and self extracting files PAK Run Options Table 15 PAK Run Opti...

Page 119: ...ask the user for information The command is executed as 1 PAK creates a temporary file named CTMPnnnn and writes the command to that file 2 A TACL process is started using this file as the IN file and PAK s OUT file as the OUT file usually the terminal 3 The temporary file is purged after the TACL process completes If the command needs any input from the user it must be programmed as a TACL macro ...

Page 120: ...mment text to the archive UNPAK automatically displays the comment To enter a line break in a comment enter n For example comment First line nSecond line pri nnn specifies the priority with which the PAK command must run The pri option can have a value in the range of 2 through 199 The default value is 2 In the following example the priority is set to 100 pri 100 UNPAK Command Options UNPAK decomp...

Page 121: ...axextents must be less than 2 097 000 Otherwise when PAK tries to open the file it returns error 580 If you also use the split option the maximum size of a single archive file is 2 GB 2 147 483 647 bytes PAK cannot compress OPEN files if the files are opened exclusively To PAK files opened for write you can use the SHARE option but the resulting PAK file might be corrupted For example you cannot u...

Page 122: ...ts limit cannot write in Output file further In this case PAK or UNPAK does not create any archive file or unpax all files To PAK or UNPAK files that required more than 99 999 lines for logging records run the PAK or UNPAK operation without the OUT option 122 PAK UNPAK ...

Page 123: ...aintenance operation or an infrequent necessity when an old backup tape is restored NOTE BRCOM does not support the same tape format as the Backup and Restore utilities T9074 You cannot mix Enscribe and SQL MP files on the same tape with OSS and SQL MX files Use labeled tapes Move files from one system to another NOTE Do not run RESTORE under a user ID with Safeguard default protection because all...

Page 124: ...nd Examples page 158 RESTORE and BACKUP have two modes of operation File mode in which RESTORE transfers individual files from tape to system disk Volume mode in which RESTORE transfers the contents of a whole tape to a whole disk volume Only the super ID 255 255 can use volume mode NOTE Disks with a capacity greater than 2 GB cannot be restored to a version of the operating system prior to D30 wh...

Page 125: ... device node ldev define name NOTE The current node in a RESTORE process is where RESTORE is running When you restore backed up files run RESTORE on the same node where the TACL process is running and where the files to be restored were backed up device is the logical name of the magnetic tape unit such as TAPE1 ldev is the device number of the magnetic tape unit such as 17 define name specifies a...

Page 126: ...Y NOUNLOAD LISTONLY VERIFYTAPE OPEN MAP NAMES VOL PAGELENGTH MULTIDRIVE File conversion RESTORE options to convert files from one tape format to another ISLACK DSLACK SCRATCHVOL EXT Enscribe RESTORE options to restore Enscribe files PARTOF NOPURGEUNTIL ALTFILE REBUILD PART SQL RESTORE options to restore SQL files SQLTAPEPARTARRAY REGISTERONLY INDEXES AUTOCREATECATALOG SQLCATALOGS MAP NAMES CATALOG...

Page 127: ... primary key file If you specify the ALTFILE option you cannot specify the MAP NAMES option The MAP NAMES option is recommended instead of the ALTFILE option because it provides a complete mechanism for changing file names in the RESTORE utility For more information see MAP NAMES page 138 Example This command changes the name of an alternate key file in the file label of the primary key file AFILE...

Page 128: ...ine dump TMF cannot perform media recovery for the file For more information on managing files audited by TMF see the TMF Planning and Configuration Guide TMF has its own recovery mechanisms for audited files However you might want to use BACKUP and RESTORE to Transport audited files to another system Archive files and retrieve files that are used infrequently Keep old versions of files TMF must b...

Page 129: ... option in the RESTORE command Restored files are not audited even if TMF is running when you run RESTORE The message WARNING Audit Turned Off is sent to the output file for each file that was audited but not open when it was backed up The message WARNING OPEN AUDIT Turned Off is issued for each file that was both open and audited when it was backed up When you restore a file that exists on disk R...

Page 130: ...s omitting the AUTOCREATECATALOG option from the RESTORE command Guidelines When you use AUTOCREATECATALOG ON an SQL catalog is created and RESTORE inserts appropriate entries with the first instance of an SQL object If you provide a user ID MYID specify the AUTOCREATECATALOG ON option and run RESTORE you become the catalog owner and its security This ensures that the entire SQL object is restored...

Page 131: ...the KEEP option You might use these options together with MAP NAMES to move SQL partitions between production and development systems when data volume exceeds practical tape set limitations or for migration operations This does not necessitate any purges on the target system If you omit the CATALOGS option or if there are some SQL objects to restore for which you do not specify a catalog RESTORE f...

Page 132: ...old2 osubvol to new2 nsubvol COLLATION new1 nsubvol collation_1 for new1 nsubvol new2 nsubvol collation_1 for new2 nsubvol LISTALL AUDITED RESTORE TAPE CATALOG new1 nsubvol for new1 nsubvol MAP NAMES old1 osubvol to new1 nsubvol COLLATION new1 nsubvol collation_1 for new1 nsubvol new1 nsubvol collation_2 for new1 nsubvol LISTALL AUDITED DETAIL The DETAIL option provides information about the file ...

Page 133: ... LAST OPEN 1 Jul 2005 14 53 EOF 340 0 0 USED EXTENTS ALLOCATED 1 Summary Information NOTE This RESTORE example is supported only on systems running H series RVUs or J series RVUs DSLACK The DSLACK option specifies the minimum percentage of slack space for data blocks It is used only to convert key sequenced Enscribe files from the DP1 to DP2 format DSLACK percentage percentage is an integer in the...

Page 134: ...red files It is used only to convert Enscribe files from the DP1 to DP2 format EXT extent size pri extent size sec extent size NOTE The use of extent sizes over 65535 requires format 2 You can specify these values for extent size pri extent size primary extent size and sec extent size secondary extent size 0 512 000 000 PAGE S specifies the extent size in pages 2048 byte units The minimum extent s...

Page 135: ...the corrupt or incomplete file from disk and begins to restore the next file INDEXES The INDEXES option specifies whether the indexes defined for SQL tables are to be automatically restored when the tables are restored INDEXES IMPLICIT EXPLICIT IMPLICIT specifies that the indexes defined for a table are restored automatically when the table is restored This is the default when you specify INDEXES ...

Page 136: ...mat ISLACK percentage percentage is an integer in the range 0 through 99 The default value is 0 KEEP The KEEP option specifies that a file on tape is restored only if it does not have the same name as an existing disk file KEEP Guidelines If you omit the KEEP option the file on disk is purged when a file of the same name is restored from tape However if the file on tape is an Enscribe file and the...

Page 137: ... VCTRN ENSCRIBE TYPE E CODE 0 EXT 1 PAGES 1 PAGES MAXEXTENTS 16 REC 80 BLOCK 1024 OWNER 1 1 SECURITY RWEP CUCU MODIF 2Oct1997 9 57 CREATION DATE 30 Aug 1997 10 51 EOF 0 0 0 USED EXTENTS ALLOCATED 0 Summary Information Files restored 2 Files not restored 0 LISTONLY The LISTONLY option causes RESTORE to run without restoring any files This option generates a listing of the files that are specified i...

Page 138: ... you also specify the KEEP option You might use these options together to move SQL partitions between production and development systems when data volume exceeds practical tape set limitations or for migration operations This does not necessitate any purges on the target system CAUTION It is critical that the CATALOGS and MAP NAMES mapping lists are complete even when recovering an individual part...

Page 139: ...r The new fileset list parameter cannot include the question mark wild card character but can include the asterisk When more than one renaming pattern is specified in the MAP NAMES option the first applicable pattern is used if there is a conflict Use the RESTORE AUTOCREATECATALOG and CATALOGS options with the MAP NAMES option to move SQL files to another node In addition to these options use the ...

Page 140: ...D B B D B B To restore these SQL objects to different volumes on node A RESTORE TAPE WHERE SQL MAP NAMES B TO F C C TO F1 D D TO F2 D TO F3 AUDITED The file names for secondary partitions C C B B and D D B B are stored in remote format so that is how they must be identified in the MAP NAMES option With the MAP NAMES option instead of restoring these partitions to their source nodes they are restor...

Page 141: ... it is given the default security of the current user MYID Guideline If the NOMYID option was used during the BACKUP process the MYID option of RESTORE is disallowed For more information see NOMYID page 58 CAUTION The MYID option does not actually decrease tape security The security of BACKUP tapes is always based on physical possession of the tape Each customer site should have procedures to cont...

Page 142: ...he default is to unload the tape If NOREWIND is specified for an unlabeled tape and an attempt is made to read or write to the tape without first manually repositioning the tape the utility abends with Error 8103 NOSAFEGUARD The NOSAFEGUARD option excludes Safeguard information from a RESTORE process This option applies only to Enscribe files NOSAFEGUARD Guidelines If you use the NOSAFEGUARD optio...

Page 143: ... fileset fileset Guidelines The not fileset list parameter must be completely contained in restore files The NOT option is equivalent to the EXCLUDE qualifier in qualified file set syntax Example To restore all files from volume SYSTEM except those from SYSTEM SYSTEM 1 RESTORE TAPE1 SYSTEM NOT SYSTEM SYSTEM NOUNLOAD The NOUNLOAD option causes the final tape to remain rewound and left online after ...

Page 144: ...put from RESTORE is sent to a printer a form feed or page eject is generated after the number of lines specified in the PAGELENGTH option If the PAGELENGTH option is not specified RESTORE defaults to 60 lines per page Example To direct output from RESTORE to a printer and generates 50 lines per page 1 RESTORE OUT S BOOK TAPE MYVOL PAGELENGTH 50 PART The PART option specifies a new node or volume n...

Page 145: ... The MAP NAMES option provides a complete mechanism for changing file names the PART option has limitations You cannot specify extent sizes with the PART option if your RESTORE command also contains the PARTOF or PARTONLY option When you specify the PART option the original name of the partition indicated by sec partition num is replaced by the new partition name you specify The sec partition num ...

Page 146: ... partition resides on that volume and that are defined by restore files Volume names used with the PARTOF option can include wild card characters and asterisk matches from 0 through 8 characters in the position where it appears question mark matches one character in the position where it appears For example the volume name SB matches all four character volume names that begin with SB The file name...

Page 147: ...titions to recover in subsequent RESTORE operations All logically related SQL MP objects are left offline in a non functional state at the end of this RESTORE session To successfully place table and index partitions online link all indexes and perform verification you must perform a final RESTORE PARTONLY ON session If the BACKUP tape contains partitioned or multiple indexes for a single table HP ...

Page 148: ...ption Consider that the source table TABLE1 and target table TABLE2 have three partitions each SQLCAT TABLE1 CATALOG USER0 SQLCAT KEY COLUMN 0 OFFSET 0 LENGTH 2 ASC PART 0 USER0 16 PAGES 64 PAGES MAXEXTENTS 160 FORMAT 1 0 PART 1 USER1 16 PAGES 64 PAGES MAXEXTENTS 160 FORMAT 1 10 PART 2 USER2 16 PAGES 64 PAGES MAXEXTENTS 160 FORMAT 1 20 SQLCAT TABLE2 CATALOG USER1 SQLCAT KEY COLUMN 0 OFFSET 0 LENGT...

Page 149: ...es the secondary partition name in the primary partition file label and also changes the actual file name of the secondary partition After finishing the restores to verify that the index values in both responses point to the primary partition use the FILEINFO TAB DETAIL command on both the primary and secondary volumes Examples To restore all of the files on the volume BOOKS from both the primary ...

Page 150: ...f related tape sets are defined by the file directories on the first tape set This option only applies to Enscribe files it has no effect on SQL files Any SQL files named in the restore files are restored as they would have been without the REBUILD option REBUILD Guidelines Use the REBUILD option to restore tapes that were created using the PARTIAL BACKUP option The tape sets that are used with th...

Page 151: ...s needed mainly for SQL files where the small default remote I O transfer size can cause a performance problem REMOTEIOSIZE data block size data block size is the maximum number of 1024 byte increments blocks in each remote I O transfer specified as 2 4 8 12 16 20 24 28 32 36 40 44 48 or 52 Guidelines REMOTEIOSIZE values above four 4096 bytes cause RESTORE to use BulkIO logic The default SQL remot...

Page 152: ...sk volume replacing the volume name that existed during the BACKUP process volume mode only RENAME volume volume is a valid volume name that is not being used for any other device or process in the system Guidelines For target volumes that are not removable the RENAME option is ignored and the disk retains its permanent name SQL objects can be dependent on files in multiple volumes Before renaming...

Page 153: ...The SQLCATALOGS ON option should be used only to recover catalog data when TMF recovery is not possible To restore SQL catalogs using RESTORE consult your service provider For more information see the SQL MP Installation and Management Guide SQLCOMPILE The SQLCOMPILE option specifies whether an SQL object program file is recompiled automatically during a RESTORE process SQLCOMPILE ON OFF ON specif...

Page 154: ...ons where the object s DDL has changed since the backup was made This effort was referred to as Label Fixup In rare cases users have corrupted the SQL partition array on disk and needed to recover using a backup tape with the correct DDL This option turns off the Label Fixup modifications and uses the partition array from tape START The START option indicates where in the restore files the RESTORE...

Page 155: ...3 CREATION DATE 12 Oct 2001 16 10 LAST OPEN 10 Sep 2001 13 13 To display the timestamps for a file restored on October 12 2001 with the TAPEDATE OFF option BOOKS1 SHARONF NOVEL DATA MODIF 12 Oct 2001 16 10 CREATION DATE 12 Oct 2001 16 10 LAST OPEN 12 Oct 2001 16 10 The creation date for the file is changed to the restore date whether or not the TAPEDATE option is used TARGET The TARGET option spec...

Page 156: ...for data1 RENAME data1 TURNOFFAUDIT The TURNOFFAUDIT option specifies that files audited by TMF when they were backed up are not to be audited when they are restored You must use the AUDITED option with the TURNOFFAUDIT option TURNOFFAUDIT For more information about restoring audited files see AUDITED page 127 VERIFY The VERIFY option verifies the data integrity of the files on disk VERIFY Guideli...

Page 157: ...me that is to be restored from tape When specified volume must match the disk volume name that is on the tape specifies that any disk volume on the tape is to be restored The asterisk matches any disk volume name on the tape Guidelines The disk volume you specify to be restored must be on the current node system That is you cannot do a remote volume mode restore Any volume mode BACKUP RESTORE requ...

Page 158: ...se of errors on the tape or disk RESTORE skips the files that cannot be restored 2 A premature voluntary termination with fatal errors RESTORE terminated itself because of a fatal error or an invalid user command The files might not all be restored 3 The RESTORE process never got started This completion code is generated by the TACL process executing RESTORE TACL returns a process creation error i...

Page 159: ... 18 27 8 12 CUUU SEC6 101 55418 19Nov1998 9 55 8 12 CUUU SEC7 101 75420 19Nov1998 18 34 8 12 CUUU SEC8 101 54444 18Nov1998 16 44 8 12 CUUU SYNTAX 101 7790 05Nov1998 18 38 8 12 CUUU TITLE 101 3348 19Nov1998 15 06 8 12 CUUU Summary Information Files restored 16 Files not restored 0 For a description of the fields in the LISTONLY output see LISTALL page 55 To list the files at the home terminal in vo...

Page 160: ...n the RESTORE command must match those used in the original BACKUP command These options are particularly significant The PARTONLY option must be the same for a BACKUP and RESTORE process if you are restoring partitioned files That is if the PARTONLY ON option does not appear in the listing you cannot include the PARTONLY ON option in your RESTORE command The AUDITED and OPEN BACKUP options indica...

Page 161: ... output file or device To have RESTORE begin restoring files when it encounters the file DATA MYFILE without restoring files that precede MYFILE in subvolume DATA and leaving the tape loaded and online after the RESTORE operation 1 RESTORE TAPE3 START DATA MYFILE LISTALL 1 NOUNLOAD Subvolumes that precede DATA are not restored but subvolumes that follow DATA are restored To restore the files using...

Page 162: ...its primary partition on temp volume 2 and a secondary partition on temp volume 3 such that its attributes match those of the restored partition on temp volume 1 b Alter the temporary key sequenced file so that the restored partition now becomes its secondary partition and copy the data records from that secondary partition to the target key sequenced file c Alter the temporary key sequenced file ...

Page 163: ...put 3 Create the target file with partitions and the appropriate keys output 4 The number of secondary partitions in the archive output 5 The list of volumes where the source files in archive existed output You ll have an option to manually enter them or list them in a file output 6 The primary and secondary extents of the file in archive output output This tool is meant to convert one E64 file in...

Page 164: ...ns are there in archive if parts 64 AND parts 0 then set done 1 else output Invalid number of partitions output set done 0 loop while done 0 do set pext input What are the primary extents pages for the source file if pext 0 then set done 1 else output Bad PExt value output set done 0 loop while done 0 do set sext input What are the secondary extents pages for the source file if sext 0 then set don...

Page 165: ...hive file name as subvol file if charfind partfile 1 0 AND charfind partfile 1 0 then set done 1 else output Bad input output set done1 0 loop while done1 0 do output How do you want give the source vol names set inp input Manually Through File M F case inp m M set count 0 loop while count parts do set myarr vol_part count input Provide source vol name for part count set count compute count 1 set ...

Page 166: ...np partfile partonly listall vol temploc nounload set like temploc tfile set part 1 work_vol2 pext sext 0 0 0 0 reset partonly create work_vol1 partfile alter work_vol1 partfile part 1 tloc copy work_vol1 partfile tgt_file alter work_vol1 partfile part 1 work_vol2 exit set count compute count 1 output output Activity Completed Performing cleanup output fup purge temploc tfile fup purge work_vol1 p...

Page 167: ...s critical that the CATALOGS and MAP NAMES mapping lists are complete even when recovering an individual partition If the CATALOGS option is specified every associated catalog must be mapped If the MAP NAMES option is specified every partition must be mapped If the maps are incomplete or incorrect severe catalog inconsistencies for the object will result These inconsistencies are quite difficult t...

Page 168: ...to validate objects towards the end of the operation the restored objects are left invalid In these situations you might have to fix inconsistencies in SQL tables All of the components were not restored The security or owner ID is mismatched The components partitions of a base table must have the same security and owner Partitions are inconsistent with the indexes Indexes are inconsistent with the...

Page 169: ... option is OFF an SQL DROP INDEX command is applied to the index which causes all partitions of the index to be dropped Any SQL program that depends on the index is marked invalid If the existing disk file is an SQL view definition an SQL DROP VIEW command is applied to the view whether the PARTONLY option is ON or OFF For more information about the effects of the SQL DROP TABLE DROP INDEX and DRO...

Page 170: ...es A and B can contain both Enscribe and SQL files 4 RESTORE TAPE A B 4 CATALOGS A CAT FOR A 4 B CAT FOR B AUDITED LISTALL This command has these results The tape files are copied to disk if they have the volume name A or B All partitions protection views and indexes associated with files that have volume name A or B are restored The newly copied disk files are given the same names as the ones on ...

Page 171: ...s on the file type and the options that you specify in your RESTORE command If you specify the KEEP option the file that exists on disk is preserved and the file on tape is not restored If you specify the PARTONLY ON option only the existing disk files with the same names as the files explicitly named in the restore files parameter of the RESTORE command are purged Specifying the PARTONLY OFF opti...

Page 172: ... on the same network you do not need to be concerned about the file names or destination for remote files RESTORE restores the remote files back to their original locations Because the local files do not contain the file node information the local files will be restored on the system that is running RESTORE Restoring Files to a Different Network If you run RESTORE on a system that is not connected...

Page 173: ...mple if you have a tape with a remote file set from B the QFS will not be restored because the QFS of VOL designates a file set that is local to the RESTORE system RESTORE TAPE You receive this message A Files not found Error 2013 If this situation occurs use with an appropriate MAP NAMES option to restore all of the files to the local node RESTORE TAPE MAP NAMES TO NEW SUB A NEW SUB Table1 TInd1 ...

Page 174: ... that has secondary partitions on C C B B and D D B B and A D B B is another SQL object unrelated to A B B B The file names are stored on tape in the form B B B C C B B D D B B D B B To restore these SQL objects to different volumes on node A the command might be RESTORE TAPE WHERE SQL MAP NAMES B TO F C C TO F1 D D TO F2 D TO F3 AUDITED The file names for secondary partitions C C B B and D D B B ...

Page 175: ...passes messages about labeled tape operations to the operator console 0 and the MEDIACOM console if one exists Create the DEFINE the same way you create DEFINEs for ANSI and IBM labeled tapes For information on DEFINEs or labeled tape processing on NonStop systems including instructions on using DEFINEs and how to use the CLASS TAPE DEFINE for labeled tape processing see the Guardian User s Guide ...

Page 176: ...STORE processes Using the LABELS BYPASS DEFINE Attribute Use the LABELS BYPASS DEFINE attribute only with NonStop BACKUP or IBM labeled backup tapes You cannot read ANSI labeled tapes using the LABELS BYPASS DEFINE attribute The LABELS BYPASS attribute lets you Restore files even after you have received a parity error using NonStop BACKUP or IBM labeled tapes If a parity error occurs when RESTORE ...

Page 177: ...es a B in the Label Standard Version field To restore a labeled tape without using automatic volume recognition AVR 1 ADD DEFINE LAZY CLASS TAPE LABELS BYPASS 1 DEVICE TAPE1 2 RESTORE LAZY LISTALL TAPEDATE ZSVR the labeled tape server process sends a message to the operator console and the MEDIACOM console if one exists to request the release of the tape drive for use in LABELS BYPASS mode The ope...

Page 178: ...pen FALSE Broken FALSE RF Needed FALSE Corrupt FALSE Audited FALSE File Code 963 File Type ENSCRIBE EOF 8192 Last Mod Time 14 Jul 2000 9 53 21 Volume Catalog CAUNI3 SILO1_VOLCAT Pool Name WEEKLY_APPENDABLE Tape Name 005907 Volume Index 1 Tape Set ID 005907 File Catalog CAUNI3 SILO1_FILECAT Tape File W00007 Generation 2 Version 0 Time Archived 19 Dec 2000 8 07 20 Physical Copy 1 Logical Copy 1 Disk...

Page 179: ...he effect is similar to using SCF to bring up an old version of a volume Therefore the same considerations for the SCF START command apply For more information see the SCF Reference Manual for the Storage Subsystem When restoring to a mirrored disk neither mirror should be up during the process If only one mirror is being restored the other mirror should be in the DOWN or HARD DOWN state When rest...

Page 180: ...wise error 66 is returned when an SCF START command is issued to the restored disk By using the RENAME option you can prevent the problem RESTORE tape VOLUMEMODE TARGET lev for data1 RENAME data1 Any volume mode BACKUP RESTORE request to an SMF virtual disk results in the error message Volume Mode BACKUP RESTORE is incompatible with SMF virtual disks use File Mode If you attempt a volume mode back...

Page 181: ... before continuing 3 Bring down all paths of the disk to be restored RESTORE requires that both halves of a mirrored volume be in the DOWN state to perform a volume mode RESTORE STOP DISK 9 4 Ensure that all paths of the disk volume are DOWN INFO DISK DATA DETAIL 5 Exit SCF 6 Issue the volume mode RESTORE command 3 RESTORE TAPE4 VOLUMEMODE TARGET 9 M 7 Check the state of the disk after the RESTORE...

Page 182: ...re a file Effect The utility terminates due to an error in procedure Recovery For corrective action for the error indicated by nnn and rerun the utility see the Guardian Procedure Errors and Messages Manual 2003 Syntax error Invalid file name Cause An invalid format was used for the name of the tape drive A device name begins with a dollar sign followed by one through seven alphanumeric characters...

Page 183: ...cated by nnn and rerun the utility see the Guardian Procedure Errors and Messages Manual 6000 Syntax error Invalid fileset Cause An invalid format was used for the file set name The proper file set format is node volume subvolume file id Effect The utility terminates Recovery Reenter the command using a valid file set 601 1 Syntax error Invalid filename mapping fileset must be restricted i e in pl...

Page 184: ...y a larger BLOCKSIZE and retry the process on the file 7002 Cannot use the PARTOF option on a tape recorded with the PARTONLY option Cause An attempt was made to restore a tape that was created using the PARTONLY ON option The PARTOF and PARTONLY parameters are incompatible Effect RESTORE terminates and no files are restored Recovery Reissue the command specifying a valid option mix 7003 PARTONLY ...

Page 185: ...ified Effect An audited file on tape was restored as a nonaudited file Recovery Informational message only no corrective action is needed 7007 Privileged license turned off Cause The privileged license was turned off Effect None Recovery Informational message only no corrective action is needed 7008 PROGID turned off Cause The program ID PROGID option was turned off Effect None Recovery Informatio...

Page 186: ...ent Service EMS logs trace files and a processor dump if applicable If your local operation procedures require contacting the GCSC supply your system number and the numbers and versions of all related products as well 7013 Data lost Error n Address b Length l Cause BACKUP encountered an error when trying to read data The IGNORE option was specified Effect None of the data could be read Because the...

Page 187: ...ot be updated actively while BACKUP is running 7016 Premature end of file Cause The end of file changed during the backup Effect BACKUP skips the file and proceeds to the next file Recovery Contact your service provider and provide all relevant information The information in this message Description of the problem and accompanying symptoms Supporting documentation such as Event Management Service ...

Page 188: ... version of RESTORE Cause An attempt was made to restore a tape that was created using a newer version of BACKUP Effect RESTORE terminates Recovery Use a newer version of RESTORE 7022 Command line is empty and the in file was not specified Cause The command line was empty and no input file was specified Effect The utility terminates Recovery Reenter the command and specify the parameters 7023 EXT ...

Page 189: ... the file does not have a secondary partition Effect BACKUP or RESTORE skips the file and proceeds to the next file Recovery Informational message only no corrective action is needed 7027 No files written on tape Cause BACKUP was unable to write any files to tape because of previous errors Effect BACKUP terminates Recovery Create a new BACKUP tape after correcting any errors 7028 File aborted Erro...

Page 190: ... information in this message Description of the problem and accompanying symptoms Supporting documentation such as Event Management Service EMS logs trace files and a processor dump if applicable If your local operation procedures require contacting the GCSC supply your system number and the numbers and versions of all related products as well 7031 Volume aborted Cannot convert files when PARTIAL ...

Page 191: ...ng to RESTORE a file This error occurs only when the DP2 file on tape is being converted to a DP1 file on disk Effect RESTORE skips the file and proceeds to the next file Recovery The DP2 file must be repaired before it can be converted Either the file must be restored to a DP2 volume and repaired or the original DP2 file must be repaired and backed up again 7037 File skipped File open for write d...

Page 192: ...d Not all the partitions of this entire file have the same volume type DP1 DP2 Cause The disk process type of one or more partitions was not the same Effect BACKUP or RESTORE skips the file and proceeds to the next file Recovery Move the partitions so that the disk process types are the same 7042 File aborted Bad structured file on tape Cause RESTORE encountered an invalid structured file while tr...

Page 193: ...Effect RESTORE skips the offending file and continues processing the rest of the file set Recovery For corrective action for the error number indicated see the Guardian Procedure Errors and Messages Manual then rerun RESTORE 7046 Secondary partition not found Cause BACKUP of a partitioned file whose secondary partition volume is down Effect BACKUP of the file fails Recovery Bring up the volume on ...

Page 194: ...nate key files has a different volume type Effect The files are restored Recovery To make the primary key file usable use the FUP ALTER command to change the alternate key file names so they reference volumes files that have the same disk process type 7053 At least one alternate key file name references a volume that does not exist Cause A reference was made to a nonexistent volume by one or more ...

Page 195: ...e DP2 structured file data was put in a DP1 file Effect RESTORE skips the file and proceeds to the next file Recovery Investigate the cause of the invalid file and eliminate the possibility of its recurrence 7060 File skipped Record length of DP2 key sequenced source file is too large for a DP1 file Cause The record length of the DP2 source file was too long for conversion to a DP1 file Effect BAC...

Page 196: ...vert files when REBUILD is specified Cause An attempt was made to convert files using the REBUILD option Effect No more files from the volume are processed and RESTORE proceeds to the next volume Recovery Reenter the command without specifying REBUILD 7066 Tape checksum error encountered in the data block Cause Checksum error encountered reading the tape Effect Warning message only Recovery Inform...

Page 197: ...rally is not recoverable 7077 File is corrupt Cause The specified file was marked corrupt Effect The corrupt file is backed up but the corrupt flag remains set Recovery Informational message only no corrective action is needed 7078 File is marked broken Cause BACKUP of a broken file with the IGNORE option Effect BACKUP file is marked broken Recovery None 7079 Original source file was corrupt Cause...

Page 198: ...e backed up but the Safeguard information is not included with the files Recovery Do not use the OLDFORMAT or DP1FORMAT options if you want Safeguard information to be backed up 7089 Safeguard information for this file cannot be backed up because the Safeguard Monitor is inaccessible Cause The specified file is protected by the Safeguard product but the Safeguard monitor was not accessible Effect ...

Page 199: ...eguard server error nnn Cause The specified file on tape was protected by the Safeguard product but file system error nnn occurred Effect The file is restored but the Safeguard protection is ignored Recovery For error nnn corrective action see the Guardian Procedure Errors and Messages Manual 7094 The tape block size has been rounded down to nn Cause BACKUP rounded down the tape block size Effect ...

Page 200: ...does not exceed 5000 If this does not help contact your service provider and provide all relevant information The information in this message Description of the problem and accompanying symptoms Supporting documentation such as Event Management Service EMS logs trace files and a processor dump if applicable If your local operation procedures require contacting the GCSC supply your system number an...

Page 201: ...n invalid file attribute Effect The entire partitioned file is skipped Recovery Informational message only no corrective action is needed 7125 File not contained on tape due to partial backup Cause The BACKUP PARTIAL option is in use Effect Files that have not been modified since the date specified with the PARTIAL option are not backed up Recovery Informational message only no corrective action i...

Page 202: ...Effect A new catalog is created Recovery Informational message only no corrective action is needed 7130 This tape can only be restored with TNS II RESTORE C00 or later Cause The tape was created by BACKUP2 Effect BACKUP execution continues Recovery Use C00 or a later version of RESTORE 7131 This tape cannot be restored using the MYID option of RESTORE Cause The MYID option cannot be used because t...

Page 203: ...formational message only no corrective action is needed 7141 Unable to obtain MYPIN and processor information Cause An EXCEED MYPINERROR has occurred Effect BACKUP or RESTORE continues Recovery Informational message only no corrective action is needed 7142 CATALOGFILES option was used in the Backup command while CATALOG OFF was specified in the DEFINE The files will not be cataloged in the DSM TC ...

Page 204: ...t uses a smaller BLOCKSIZE Recovery Informational message only no corrective action is needed 7147 Files created and stored via OSS and SQL MX objects are not supported Cause An attempt was made to back up a file that is not a Guardian file Effect All files in ZYQ subvolumes are skipped Recovery Informational message only no corrective action is needed 7157 The NOSQLDATA option is active No SQL da...

Page 205: ...7252 Not a volume mode BACKUP tape Cause An attempt was made to RESTORE a tape that was not a volume mode BACKUP tape Effect RESTORE terminates Recovery Mount the correct tape and retry the operation 7253 The capacity of the target disk must be greater than or equal to the size of the disk image on tape Cause An attempt was made to perform a RESTORE but the capacity of the target disk was insuffic...

Page 206: ...es are not identical The valid primary or mirror volume must be determined and specified Cause BACKUP encountered a mirrored disk pair but the primary and mirror volumes were not identical Effect BACKUP terminates Recovery Determine and specify the valid primary or mirror volume and retry the operation 7259 Bad disk format or disk has been partially formatted Cause BACKUP or RESTORE encountered a ...

Page 207: ...e A RESTORE was performed but the 3106 microcode section was not restored Effect RESTORE continues Recovery Use the PUP REPLACEBOOT command or the SCF CONTROL DISK REPLACE BOOT command to replace the microcode section 7268 The disk Free Space Table is broken an invalid entry was detected Cause An invalid entry was detected in the disk free space table Effect BACKUP terminates Recovery If necessary...

Page 208: ...ages Manual 7274 Trust flag turned off Cause The state of FLTrustFlags for the file being restored is set to OFF Effect None Recovery Informational message only no corrective action is needed NOTE Message 7274 appears only on systems running H series RVUs or J series RVUs 7500 Not positioned to the beginning of the tape Cause An attempt was made to run BACKUP or RESTORE before positioning the tape...

Page 209: ...e GCSC supply your system number and the numbers and versions of all related products as well 7503 Bad tape format Bad section length in DP2 tape file label Cause An attempt was made to restore a tape but a BACKUP tape in the proper format could not be found There are three possible reasons BACKUP was stopped in the middle of a backup operation resulting in an incomplete BACKUP tape The Bad Tape F...

Page 210: ...r and the numbers and versions of all related products as well 7505 Bad tape format End of file encountered where file label or ending volume label expected Cause An attempt was made to restore a tape but a BACKUP tape in the proper format could not be found There are three possible reasons BACKUP was stopped in the middle of a backup operation resulting in an incomplete BACKUP tape The Bad Tape F...

Page 211: ...g the GCSC supply your system number and the numbers and versions of all related products as well 7509 Bad tape format Ending volume label does not match beginning volume label Cause An attempt was made to restore a tape but a BACKUP tape in the proper format could not be found There are three possible reasons BACKUP was stopped in the middle of a backup operation resulting in an incomplete BACKUP...

Page 212: ...r and the numbers and versions of all related products as well 751 1 Bad tape format Bad continuation indicator for ending volume label Cause An attempt was made to restore a tape but a BACKUP tape in the proper format could not be found There are three possible reasons BACKUP was stopped in the middle of a backup operation resulting in an incomplete BACKUP tape The Bad Tape Format was detected wh...

Page 213: ...the GCSC supply your system number and the numbers and versions of all related products as well 7513 Bad tape format End of file encountered where a data block was expected Cause An attempt was made to restore a tape but a BACKUP tape in the proper format could not be found There are three possible reasons BACKUP was stopped in the middle of a backup operation resulting in an incomplete BACKUP tap...

Page 214: ...les cannot be restored If you suspect the problem is a result of the third cause contact your service provider and provide all relevant information The information in this message Description of the problem and accompanying symptoms Supporting documentation such as Event Management Service EMS logs trace files and a processor dump if applicable If your local operation procedures require contacting...

Page 215: ... applicable If your local operation procedures require contacting the GCSC supply your system number and the numbers and versions of all related products as well 7520 Tape verify encountered ending volume label where a file label was expected Cause Either the VERIFYTAPE or VERIFYREEL option was used with BACKUP or RESTORE LISTONLY The ending volume label was encountered where a file label was expe...

Page 216: ...th BACKUP or RESTORE LISTONLY A problem was encountered with the data block Effect BACKUP or RESTORE terminates Recovery Have the tape drive serviced 7526 Tape verify found beginning volume label doesn t match what was supposed to have been written Cause Either the VERIFYTAPE or VERIFYREEL option was used with BACKUP or RESTORE LISTONLY The beginning volume label did not match what was expected Ef...

Page 217: ...ape set was mounted Effect BACKUP waits for the operator response RESTORE prompts again for the next reel Recovery For BACKUP mount the correct tape and press Return To terminate the backup operation type STOP and press Return For RESTORE mount the correct reel and press Return or check the tape density 7532 Bad tape sequence number value Expected sequence number e Actual sequence number a Cause B...

Page 218: ...tion point on the tape The BACKUP tape was corrupted in some way Either BACKUP produced an invalid tape or BACKUP or RESTORE is not checking correctly due to a software error Effect BACKUP or RESTORE terminates Recovery If the invalid format is a result of one of the first two causes the files cannot be restored If you suspect the problem is a result of the third cause contact your service provide...

Page 219: ... and versions of all related products as well 7536 Bad tape format Data block too long for file Cause An attempt was made to restore a tape but a BACKUP tape in the proper format could not be found Three possible reasons are BACKUP was stopped in the middle of a backup operation resulting in an incomplete BACKUP tape The Bad Tape Format was detected when unwanted or meaningless information was enc...

Page 220: ...processor dump if applicable If your local operation procedures require contacting the GCSC supply your system number and the numbers and versions of all related products as well 7542 Unable to turn on tape buffering due to insufficient I O buffer space file system error 33 Cause The tape process reported it was unable to allocate space for buffered mode Effect BACKUP or RESTORE processing continu...

Page 221: ...eter Cause The command did not contain a required parameter Effect BACKUP BACKCOPY or RESTORE terminates Recovery Check the syntax and reenter the command with the required parameter 7755 Comma expected Cause The command line was missing an expected comma Effect BACKUP BACKCOPY or RESTORE terminates Recovery Reenter the command with the required comma 7757 Keyword expected Cause A required keyword...

Page 222: ... to indicate the START file set by using the wild card symbol in the node name Effect BACKUP terminates Recovery Use the wild card symbol only in the subvolume or name field 7762 Start file set not in the main file set list Cause An attempt was made to run RESTORE but the START file set was not in the main fileset list specified to RESTORE Effect RESTORE terminates Recovery Reissue the command spe...

Page 223: ...the parameters that BACKUP requires for this operation probably because incompatible versions of SYSGEN and BACKUP are being used Effect BACKUP terminates without writing a system image tape Recovery Run SYSGEN again either directly or through Install after ensuring that the SYSGEN phase of the installation process starts a compatible version of BACKUP 7768 Not allowed to specify PARTOF and PARTON...

Page 224: ...L parameter Effect BACKUP terminates Recovery Restrict the BACKUP to one subvolume 7774 Not allowed to specify BLOCKSIZE or REMOTEIOSIZE with OLDFORMAT Cause An attempt was made to use BLOCKSIZE or REMOTEIOSIZE with the OLDFORMAT option Effect BACKUP terminates Recovery Reenter the command without specifying the BLOCKSIZE or REMOTEIOSIZE option 7775 Not allowed to specify VERIFYTAPE VERIFYREEL wit...

Page 225: ... list and the files on tape are listed out In this mode VERIFYTAPE can be specified to cause all on tape data blocks to be read and verified In the second mode you can specify a file set list without VERIFYTAPE and all files are then restored and verification is performed 7779 expected Cause An opening parenthesis was expected Effect BACKUP BACKCOPY or RESTORE terminates Recovery Insert the requir...

Page 226: ... BACKUP or RESTORE terminates Recovery Reenter the command with only one PART parameter 7785 ALTFILE parameter specified more than once for this alternate key file Cause The ALTFILE parameter was specified more than once with the same alternate file number Effect BACKUP terminates Recovery Each ALTFILE parameter must be for a different alternate file 7786 Volume name has already been specified wit...

Page 227: ...after the current date and time Cause The partial dump date parameter of the PARTIAL parameter was not before the current date and time Effect BACKUP terminates Recovery Correct the partial date and time and reenter the command 7791 Must be a disk file name Cause A name other than a disk file name was used Effect BACKUP BACKCOPY or RESTORE terminates Recovery Reenter the command with a disk file n...

Page 228: ...han once in the BACKUP or RESTORE command Effect BACKUP or RESTORE fails and terminates Recovery Specify a file set list for the NOT option that does not conflict with a file set specified in another option and reissue the command 7797 Only allowed to restore a single volume when PARTOF is specified and a new volume is specified with VOL Cause When the VOL option is used with the PARTOF option in ...

Page 229: ...CKUP fails and terminates Recovery Specify the DENSITY option only once and reissue the command 7807 Expecting either ON or OFF or nothing the default is ON Cause An incorrect parameter was specified for a RESTORE command option Effect RESTORE fails and terminates Recovery Specify either ON OFF or no parameter for the option and reissue the RESTORE command Specifying no parameter is the same as sp...

Page 230: ...eissue the command without the offending option 7812 Not allowed to specify PARTONLY ON and INDEXES IMPLICIT together Cause The PARTONLY ON and INDEXES IMPLICIT options cannot be used in a single RESTORE command Effect RESTORE fails and terminates Recovery Reissue the command without the offending option 7813 USE CATALOG has already been specified Cause The CATALOG option was specified more than o...

Page 231: ... SYSGEN should invoke BACKUP from a SYSnn subvolume Effect BACKUP fails and terminates Recovery Restart the SYSGEN phase with a SYSnn subvolume specified 7819 Not allowed to specify TAPEMODE more than once Cause The TAPEMODE option was specified more than once in a RESTORE command Effect RESTORE fails and terminates Recovery Specify TAPEMODE only once and reissue the command 7820 Not allowed to sp...

Page 232: ...r RESTORE command was issued including both the NOSQLDATA and SQLCATALOGS option which cannot be used in the same command Effect BACKUP or RESTORE fails and terminates Recovery Reissue the BACKUP or RESTORE command using only one of these options 7834 The NOUNLOAD and NOREWIND parameters are mutually exclusive Cause This error could be caused by The NOUNLOAD and NOREWIND options were both specifie...

Page 233: ...than seven characters including Volume names that have more than seven characters including are not supported Effect RESTORE fails and terminates Recovery Ensure the remote system volume name is less than 7 characters including before reissuing the command 7900 Target must be specified by a logical device number Cause In a volume mode RESTORE operation the parameter specified with the TARGET optio...

Page 234: ...her copy Effect BACKUP terminates Recovery Specify two tape drives to make an unlabeled parallel backup or two labeled tape DEFINEs to make a labeled parallel backup 8005 The SYSTEM attribute of the tape DEFINE define specifies a system node that either does not exist or is inaccessible because all paths to it are down Cause A node was specified with a DEFINE that either does not exist or is unava...

Page 235: ...NE define specifies a system node that does not have labeled tape support configured Cause A node was specified with a DEFINE that does not have labeled tape support configured Effect BACKUP or RESTORE terminates Recovery Specify a node that was configured with labeled tape support 8010 The DEVICE attribute of the tape DEFINE define specifies a drive drive whose system does not have labeled tape s...

Page 236: ...use A DEFINE attribute was specified that is not allowed Effect BACKUP or RESTORE terminates Recovery Specify a DEFINE that has attributes from this list DENSITY EXPIRATION LABELS MOUNTMSG OWNER RETENTION SYSTEM TAPEMODE and VOLUME 8015 VOLUME SCRATCH specified for input in the tape DEFINE define Cause SCRATCH was specified instead of a list of volume IDs Effect RESTORE terminates Recovery Specify...

Page 237: ...r system number and the numbers and versions of all related products as well 8026 Tape record length is not even Length rec len Cause This error could be caused by Corruption of the tape media Dirty tape drive heads Faulty tape drives A BACKUP being stopped in the middle resulting in an incomplete tape A software problem in BACKUP or RESTORE Effect BACKUP or RESTORE terminates Recovery Investigate...

Page 238: ... This error could be caused by Corruption of the tape media Dirty tape drive heads Faulty tape drives A BACKUP being stopped in the middle resulting in an incomplete tape A software problem in BACKUP or RESTORE Effect BACKUP or RESTORE terminates Recovery Investigate whether a corrupt tape or the tape drive is causing the problem If you suspect that the error is due to a software problem contact y...

Page 239: ...e tape media Dirty tape drive heads Faulty tape drives A BACKUP being stopped in the middle resulting in an incomplete tape A software problem in BACKUP or RESTORE Effect BACKUP or RESTORE terminates Recovery Investigate whether a corrupt tape or the tape drive is causing the problem If you suspect that the error is due to a software problem contact your service provider and provide all relevant i...

Page 240: ...ACKUP or RESTORE Effect BACKUP or RESTORE terminates Recovery Investigate whether a corrupt tape or the tape drive is causing the problem If you suspect that the error is due to a software problem contact your service provider and provide all relevant information The information in this message Description of the problem and accompanying symptoms Supporting documentation such as Event Management S...

Page 241: ...e media Dirty tape drive heads Faulty tape drives A BACKUP being stopped in the middle resulting in an incomplete tape A software problem in BACKUP or RESTORE Effect BACKUP or RESTORE terminates Recovery Investigate whether a corrupt tape or the tape drive is causing the problem If you suspect that the error is due to a software problem contact your service provider and provide all relevant inform...

Page 242: ...P being stopped in the middle resulting in an incomplete tape Effect BACKUP or RESTORE terminates Recovery Investigate whether a corrupt tape or the tape drive is causing the problem If not identify the problem file If the problem exists on another tape containing the identical file it is probably a software problem If you suspect that the error is due to a software problem contact your service pr...

Page 243: ...y Corruption of the tape media Dirty tape drive heads Faulty tape drives A BACKUP being stopped in the middle resulting in an incomplete tape Effect BACKUP or RESTORE terminates Recovery Investigate whether a corrupt tape or the tape drive is causing the problem If not identify the problem file If the problem exists on another tape containing the identical file it is probably a software problem If...

Page 244: ...y a software problem in BACKUP or RESTORE but could also be caused by Corruption of the tape media Dirty tape drive heads Faulty tape drives A BACKUP being stopped in the middle resulting in an incomplete tape Effect BACKUP or RESTORE terminates Recovery Investigate whether a corrupt tape or the tape drive is causing the problem If not identify the problem file If the problem exists on another tap...

Page 245: ...1 Tape format is bad File encountered is not from the same tape set Cause This error could be caused by Corruption of the tape media Dirty tape drive heads Faulty tape drives A BACKUP being stopped in the middle resulting in an incomplete tape A software problem in BACKUP or RESTORE Effect BACKUP or RESTORE terminates Recovery Investigate whether a corrupt tape or the tape drive is causing the pro...

Page 246: ...was found in a fixed length file Cause This error could be caused by Corruption of the tape media Dirty tape drive heads Faulty tape drives A BACKUP being stopped in the middle resulting in an incomplete tape A software problem in BACKUP or RESTORE Effect BACKUP or RESTORE terminates Recovery Investigate whether a corrupt tape or the tape drive is causing the problem If you suspect that the error ...

Page 247: ...e media Dirty tape drive heads Faulty tape drives A BACKUP being stopped in the middle resulting in an incomplete tape A software problem in BACKUP or RESTORE Effect BACKUP or RESTORE terminates Recovery Investigate whether a corrupt tape or the tape drive is causing the problem If you suspect that the error is due to a software problem contact your service provider and provide all relevant inform...

Page 248: ...A BACKUP being stopped in the middle resulting in an incomplete tape A software problem in BACKUP or RESTORE Effect BACKUP or RESTORE terminates Recovery Investigate whether a corrupt tape or the tape drive is causing the problem If you suspect that the error is due to a software problem contact your service provider and provide all relevant information The information in this message Description ...

Page 249: ...KUP or RESTORE Effect BACKUP or RESTORE terminates Recovery Investigate whether a corrupt tape or the tape drive is causing the problem If you suspect that the error is due to a software problem contact your service provider and provide all relevant information The information in this message Description of the problem and accompanying symptoms Supporting documentation such as Event Management Ser...

Page 250: ...pe A software problem in BACKUP or RESTORE Effect BACKUP or RESTORE terminates Recovery Investigate whether a corrupt tape or the tape drive is causing the problem If you suspect that the error is due to a software problem contact your service provider and provide all relevant information The information in this message Description of the problem and accompanying symptoms Supporting documentation ...

Page 251: ...omplete tape A software problem in BACKUP or RESTORE Effect BACKUP or RESTORE terminates Recovery Investigate whether a corrupt tape or the tape drive is causing the problem If you suspect that the error is due to a software problem contact your service provider and provide all relevant information The information in this message Description of the problem and accompanying symptoms Supporting docu...

Page 252: ...plete tape A software problem in BACKUP or RESTORE Effect BACKUP or RESTORE terminates Recovery Investigate whether a corrupt tape or the tape drive is causing the problem If you suspect that the error is due to a software problem contact your service provider and provide all relevant information The information in this message Description of the problem and accompanying symptoms Supporting docume...

Page 253: ... the middle resulting in an incomplete tape A software problem in BACKUP or RESTORE Effect BACKUP or RESTORE terminates Recovery Investigate whether a corrupt tape or the tape drive is causing the problem If you suspect that the error is due to a software problem contact your service provider and provide all relevant information The information in this message Description of the problem and accomp...

Page 254: ...A software problem in BACKUP or RESTORE Effect BACKUP or RESTORE terminates Recovery Investigate whether a corrupt tape or the tape drive is causing the problem If you suspect that the error is due to a software problem contact your service provider and provide all relevant information The information in this message Description of the problem and accompanying symptoms Supporting documentation suc...

Page 255: ... an incomplete tape A software problem in BACKUP or RESTORE Effect BACKUP or RESTORE terminates Recovery Investigate whether a corrupt tape or the tape drive is causing the problem If you suspect that the error is due to a software problem contact your service provider and provide all relevant information The information in this message Description of the problem and accompanying symptoms Supporti...

Page 256: ...nd where an Archive volume label was expected Cause An invalid tape format was discovered Effect RESTORE rewinds and unloads the tape and prompts for a tape Recovery Check the tape and remount it If the problem persists see the cause and recovery for error 8025 page 237 8102 Both Archive begin volume label sets were bad Cause Duplicate volume label sets were both bad due to parity or checksum erro...

Page 257: ... Found a pre C00 TMF tape Cause A TMF tape with a version prior to C00 00 was mounted when a tape produced by BACKUP was expected Effect RESTORE rewinds and unloads the tape and prompts for the correct tape Recovery Mount the correct tape 81 10 Tape is not an Archive tape Cause An Archive tape was expected but not found Effect RESTORE rewinds and unloads the tape and prompts for the correct tape R...

Page 258: ... rewinds and unloads the tape and prompts for the correct tape Recovery Check the tape and remount it If the problem persists see the cause and recovery for error 8025 page 237 81 17 Standard tape header label not found Cause An invalid tape format was discovered Effect RESTORE rewinds and unloads the tape and prompts for the correct tape Recovery Check the tape and remount it If the problem persi...

Page 259: ...set to the correct density and try again If the problem persists see the cause and recovery for error 8025 page 237 8122 Tape parity error s and or tape record checksum error s occurred on the beginning volume labels Error recovery was able to recognize the tape Cause Parity or checksum errors occurred on some of the beginning volume labels Parity and checksum errors might result because the begin...

Page 260: ...service provider and provide The information in this message Description of the problem and accompanying symptoms Supporting documentation such as Event Management Service EMS logs trace files and a processor dump if applicable If your operation procedures require contacting the GCSC add your system number and the numbers and versions of all related products 8151 Premature end of tape Cause The en...

Page 261: ...larly vulnerable to parity errors For example tapes with reflective strips cause a bump in the tape sudden stopping at the end causes tape stretching and so on The tape format has duplicate end volume labels in hope that at least one of them will be readable Effect RESTORE proceeds Recovery After the restore is finished the tape and tape drive should be investigated 8157 A parity error occurred on...

Page 262: ...d the previous tape specified and mount it 8163 A bad Archive standard labeled tape volume label was found Cause Tape verification by BACKUP detected that the Archive standard labeled tape volume label contained an error Effect BACKUP terminates Recovery See the cause and recovery sections of error 8025 page 237 8164 A bad Archive tape volume label was found Cause Tape verification by BACKUP detec...

Page 263: ...ecovery Restart BACKUP or investigate why DSM TC is unavailable 8168 Unable to start TMF Transaction for Media Catalog Cause DSM TC was unable to start a TMF transaction Effect BACKUP aborts Recovery Investigate why TMF is unable to start the transaction 8169 File Catalog specified does not exist Cause DSM TC was unable to access the file catalog Effect BACKUP aborts Recovery Investigate why the D...

Page 264: ...ed to perform a CREATE on the file name but encountered an error Effect DCOM continues its compression activities It ignores this file working around it until it reaches the maximum number of extent moves specified Recovery For corrective action for the error number indicated by nnn see the Guardian Procedure Errors and Messages Manual PRIMARY DISK HAS nn UNSPARED SECTORS MIRROR Cause DSAP or DCOM...

Page 265: ...ecovery For corrective action for the error number indicated by nnn see the Guardian Procedure Errors and Messages Manual DIRECTORY WORKFILE CLOSE UNMAPPING ERROR nnn Cause DSAP or DCOM tried to close or unmap the work file Effect DSAP or DCOM stops Recovery For corrective action for the error number indicated by nnn see the Guardian Procedure Errors and Messages Manual DIRECTORY WORKFILE CREATION...

Page 266: ...ps Recovery For corrective action for the error number indicated by nnn see the Guardian Procedure Errors and Messages Manual FREE SPACE CHANGED DURING DIRECTORY COPY SPACE ALLOCATIONS ARE TOO FREQUENT EXTENT CHECK CANNOT BE PERFORMED Cause DSAP tried to copy the disk directory but due to high disk activity it could not get a copy without intervening changes by other users Effect DSAP terminates t...

Page 267: ...oblem and accompanying symptoms Supporting documentation such as Event Management Service EMS logs trace files and a processor dump if applicable If your local operation procedures require contacting the GCSC supply your system number and the numbers and versions of all related products as well Do not attempt to access filename with DSAP After the service provider investigates FUP DUP filename to ...

Page 268: ...an Procedure Errors and Messages Manual filename SETMODE ERROR nnn Cause DCOM tried to perform a SETMODE on the filename but encountered an error Effect DCOM continues its compression activities It ignores this file working around it until it reaches the maximum number of extent moves specified Recovery For corrective action for the error number indicated by nnn see the Guardian Procedure Errors a...

Page 269: ...ual option UNRECOGNIZED OPTION Cause The specified option was incorrect for the DSAP or DCOM command entered Effect DSAP or DCOM stops Recovery Check the syntax of the command and reenter it correctly USER DETAIL REPORT ERROR nnn Cause An error was encountered when DSAP tried to produce the user detail report Effect DSAP stops Recovery For corrective action for the error number indicated by nnn se...

Page 270: ... ignores this file working around it until it reaches the maximum number of extent moves specified Recovery For corrective action for the error number indicated by nnn see the Guardian Procedure Errors and Messages Manual ERROR To display disks 72 GB use the TERAFORM option Cause The TERAFORM option is not specified Effect DSAP returns an error Recovery Rerun the command with the correct syntax 27...

Page 271: ...try again Archive file is too small specify a larger extent Cause PAK reaches the maximum file size while writing to the archive Effect The program stops with completion code 2 The created archive file is purged Recovery Resubmit the command with larger extent size ext option larger maxextents max or multifile option split or reduce the number or size of files to be compressed Archive version num ...

Page 272: ...is the number of bytes to be uncompressed Effect The program stops with completion code 2 The archive extraction is interrupted Recovery This probably indicates an invalid or corrupted archive file Ensure that the archive has been created successfully with PAK and transferred without problems Decryption failed code error Cause The CBCDESDECODE function returned error code error Effect The program ...

Page 273: ...e file filename Not enough disk space is available Effect The program stops with completion code 2 The created archive file is purged Recovery Select another disk for the archive file free some disk space on this disk or use a smaller extent size ext option Error error purging file filename Cause PAK cannot purge the temporary file because of file system error error If error is 580 the extent size...

Page 274: ...me or re create the archive File purge failed Error error Filename filename Cause The purge option was used and file system error error was encountered when trying to purge the archive file filename Effect The program stops with completion code 2 If the split option was used any archive files already created are purged Recovery For an explanation and possible recovery use ERROR command or see the ...

Page 275: ...e needed TACL process could not be opened because of a FILE_OPEN_ error open error Effect The program abends Possibly a saveabend file is created No archive is created and no files are extracted Recovery This is an internal error Report it to your service provider FILE_PURGE_ of archive failed Error error Cause The PAK option purge was specified but PAK could not purge the archive file error is th...

Page 276: ...ecovery Correct the syntax and try again Invalid extent size Cause The extent size given in the ext option or the maxextents value given in the max option is larger than 2147483647 Effect The program stops with completion code 2 No archive is created Recovery Use a smaller extent size and try again Invalid filename filename Cause The file name specified in the backup or restore option is invalid E...

Page 277: ...SS_CREATE_ failed pc err detail err program progname Cause The needed BACKUP or RESTORE process could not start because of a PROCESS_CREATE_ error pc err detail err is the detailed error code progname is the program filename Effect The program stops with completion code 2 No archive is created and no files are extracted Recovery If appropriate specify a correct backup or restore option and resubmi...

Page 278: ...tion code 2 No files are extracted Recovery Supply the correct password and try again This is a multi file archive filesize filesize totalbytes totalsize Cause UNPAK read the header of an archive file and determined that this is a multi file archive The maximum size of each file is filesize bytes The total size of all files is totalsize bytes Effect The program continues Recovery Informational mes...

Page 279: ...am stops with completion code 2 No archive is created and no files are extracted Recovery If the error code is 4002 the specified file does not exist Correct the name and resubmit the command For explanation and possible recovery for other errors use the ERROR command or see the Guardian Procedure Errors and Messages Manual Unknown CONTROL num Cause The BACKUP or RESTORE process sent an unexpected...

Page 280: ...reated or the file was otherwise truncated Effect The program continues but might fail later Recovery None if the operation succeeds Otherwise re create the archive WRITEX failed error Cause The call to WRITEX failed while sending the startup message to the BACKUP or RESTORE process error is the file system error retrieved with FILE_GETINFO_ Effect The program abends Possibly a saveabend file is c...

Page 281: ...kup files ALTFILE key file num volume subvolume file id ARCHIVEFORMAT AUDITED BLOCKSIZE data record size CATALOGFILES every n files DENSITY density TAPEMODE tapemode DP1FORMAT DP2FORMAT DSLACK percentage EXT extent size pri extent size sec extent size IGNORE INDEXES IMPLICIT EXPLICIT ISLACK percentage LISTALL MSGONLOCK MULTIDRIVE NEEDBOTH NOMYID NOPROMPT NOPURGEUNTIL NOREWIND NOUNLOAD NOSAFEGUARD ...

Page 282: ...EXCLUDE fileset list FROM CATALOG S catalog list START filename WHERE expression catalog list is catalog name catalog name catalog name expression is one or more of the following expression NOT expression expression AND expression expression OR expression Possible expressions are OWNER user id timestamp field conditional time value FILECODE conditional number EOF conditional number file attribute ...

Page 283: ...hh mm ss where hh hour is an integer from 0 through 23 mm minute and ss second are 2 digit integers from 00 through 59 The default time is 0 00 00 that is midnight FILECODE conditional number conditional is not equal to EOF conditional number conditional is not equal to file attribute is one of AUDITED BROKEN CORRUPT CRASHOPEN ENSCRIBE ENTRYSEQUENCED INDEX KEYSEQUENCED LICENSED OPEN PRIMARY SECOND...

Page 284: ...NOUNLOAD TAPEMODE tapemode VERIFYTAPE WHOLEDISC DCOM Syntax run node DCOM run options volume HELP options IGNOREBADSECTORS MAXMOVES n VERIFY WORKFILE volume DSAP Syntax node DSAP run options run option volume specification HELP options volume specification volume specification takes the form volume for reports on a single volume volume1 volume2 for reports on a list of volumes for reports on all v...

Page 285: ...ame group number user number 1 group name group number PAK UNPAK Syntax PAK run option archive volumemode fileset list backup option or PAK run option archive volumemode infile backup option run option i s c params after commmand ext nn max nn purge backup backup program password password split nnn nocompress comment text UNPAK archive fileset restore options or RUN archive fileset restore options...

Page 286: ...MYID NOPROMPT NOREWIND NOUNLOAD NOSAFEGUARD NOSQLDATA NOT not fileset list OPEN PAGELENGTH number PART sec partition num node volume pri extent size sec extent size PARTOF volume spec PARTONLY ON OFF PARTIAL PHYSVOL REBUILD REGISTERONLY ON OFF REMOTEIOSIZE SCRATCHVOL volume SQLCATALOGS ON OFF SQLCOMPILE ON OFF SQLTAPEPARTARRAY START volume subvolume file id TAPEDATE ON OFF TURNOFFAUDIT VERIFY VERI...

Page 287: ...un option run option tape device name tape device name1 tape device name2 VOLUMEMODE volume volume mode restore option LISTONLY MULTIDRIVE NOPROMPT NOREWIND NOUNLOAD RENAME volume TARGET ldev P M VERIFYTAPE RESTORE Volume Mode Syntax 287 ...

Page 288: ... the operator The default is the current setting of the tape drive For guidelines on setting tape density see the SCF Reference Manual for the Storage Subsystem DENSITY is not supported by Backup and Restore 2 0 DEVICE device remote node device specifies the name of the tape device where the tapes are mounted If you specify a tape unit on a remote node the remote node must be a node on your system...

Page 289: ... tape labels conform to IBM MVS XA release 1 2 standard The system is to perform IBM MVS standard label processing on the file LP mode OMITTED there are no tape labels The system does not do label processing except to check that the tape is not a standard labeled tape NL mode If you specify LABELS OMITTED you must also include the DEVICE attribute BYPASS the system does not perform label processin...

Page 290: ... RECLEN is 0 and BLOCKLEN is as configured for the device If you specify BLOCKLEN RECFORM and RECLEN for a labeled tape output file label fields are generated with those values RECFORM is valid but ignored by Backup and Restore 2 0 The record format used internally will always be FIXED RECLEN record length specifies the record length of the tape file For ANSI standard tapes with fixed length recor...

Page 291: ... in parentheses and separate them with commas If you specify VOLUME you must also specify LABELS ANSI LABELS IBM LABELS BACKUP or LABELS IBMBACKUP If you specify VOLUME SCRATCH you cannot specify USE IN or USE EXTEND If you specify USE IN you must include volume id with the VOLUME attribute otherwise VOLUME defaults to SCRATCH These attributes have corresponding fields in the tape system labels BL...

Page 292: ...S RETENTION SYSTEM USE VERSION and VOLUME 7 If you specify VOLUME SCRATCH then USE IN or USE EXTEND is not allowed 8 If you specify LABELS IBM or LABELS IBM BACKUP you must also specify FILEID and RECFORM 9 If you specify RECLEN but not BLOCKLEN you must specify a RECLEN value greater than zero 10 If you specify LABELS IBMBACKUP the DEVICE or SYSTEM attribute must specify a system running version ...

Page 293: ...wner of this tape volume 14 Owner Identifier 38 51 Spaces 28 Reserved for Future Standardization 52 79 3 1 Label Standard Version 80 ANSI HDR1 EOF EOV1 Label Format Content Length in Bytes Field Name Character Position in the Label Record HDR or EOF or EOV 3 Label Identifier 1 3 1 1 Label Number 4 Tape file name 17 File Identifier 5 21 File set name to which this volume belongs 6 Fileset Identifie...

Page 294: ...f bytes per record 5 Record Length 1 1 15 Spaces 35 Reserved for System Software Use 16 50 00 2 Buffer Offset Length 51 52 Spaces 28 Reserved for Future Standardization 53 80 IBM Standard Labels IBM VOL1 Label Format Content Length in Bytes Field Name Character Position in the Label Record VOL 3 Label Identifier 1 3 1 1 Label Number 4 Name of this tape volume 6 Volume Serial Number 5 10 Space 1 Re...

Page 295: ... scratched or overwritten 6 Expiration Date 48 53 0 1 Data Set Security 54 Number of blocks written in this volume sequence 6 Block Count 55 60 Spaces 13 System Code 61 73 Spaces 7 Reserved for Future Standardization 74 80 IBM HDR2 EOF2 EOV2 Label Format Content Length in Bytes Field Name Character Position in the Label Record HDR or EOF or EOV 3 Label Identifier 1 3 2 1 Label Number 4 F Fixed len...

Page 296: ...tandardization 40 42 NNNN Unit s serial number in hexadecimal 4 Serial Number 5180 Tape Drive only 43 46 Spaces device other than 5180 0 5180 device 1 Device Address 5180 Tape Drive only 47 Space device other than 5180 Space 1 Checkpoint Data Set Identifier 48 Spaces 32 Reserved for Future Standardization 49 80 296 Tape Label Formats ...

Page 297: ...57 61 partitioned files 62 63 65 66 75 SQL objects catalogs 43 68 74 75 files 43 74 75 76 indexes 43 55 74 75 object program files 74 75 views 43 74 75 BACKUP command entry file set list qualifiers 43 interactive and noninteractive entry 29 syntax 40 46 281 284 wild card characters 42 examples basic operations 73 labeled tape 79 qualified file set lists 74 SQL files 76 TMFCOM 50 129 volume mode 80...

Page 298: ...bel tapes 77 175 176 DEFINE CLASS TAPECATALOG 32 DENSITY attribute 288 option BACKCOPY 35 option BACKUP 51 Density setting with BACKCOPY 35 with BACKUP 51 DETAIL option DSAP 94 RESTORE 132 Detail report DSAP attributes 93 97 106 108 options for 92 DEVICE attribute 288 Disks analyzing use of space on see DSAP compressing files on see DCOM target for restore 155 terminology 24 verifying data 156 Dis...

Page 299: ...d 40 options 46 RESTORE command syntax 124 285 286 options 126 File sets 42 File set lists format 42 43 qualified 43 46 File system error 45 avoiding 175 FILEID attribute 289 Files backing up audited 48 corrupt 54 open 57 61 partitioned 62 63 65 66 76 compressing see DCOM converting see File conversion renaming ALTFILE option see BACKUP see RESTORE PART option see BACKUP see RESTORE VOL option see...

Page 300: ...rator Interface Manual MEDIACOM Messages BACKCOPY 182 263 BACKUP 182 263 RESTORE 182 263 Mounting tapes 29 59 141 MOUNTMSG attribute 289 MSGONLOCK option BACKUP 57 MULTIDRIVE option BACKUP 58 RESTORE 140 Multireel operations backup 58 restore 140 MYID option RESTORE 141 N Name mapping 138 140 171 172 NEEDBOTH 58 Newformat option DSAP 95 NOMYID option BACKUP 58 NonStop operating system compatibilit...

Page 301: ...tribute 290 REGISTERONLY option RESTORE 151 Remote BACKUP operation 42 Remote RESTORE operation 157 REMOTEIOSIZE option BACKUP 66 RESTORE 151 RENAME option RESTORE 152 Renaming Enscribe files with ALTFILE 47 127 with MAP NAMES 138 140 171 172 with PART 62 144 146 with VOL 70 156 restored disk volumes 151 152 SQL files with MAP NAMES 138 140 Reports 24 see also Output DCOM 88 DSAP options for 92 93...

Page 302: ...08 SIZE option DSAP 96 Skipping open files during BACKUP 57 Slack space 53 55 133 136 Space compression reports 88 Space distribution reports 103 SPACE option DSAP 96 SQL catalogs backing up 68 creating with RESTORE 130 registering objects with RESTORE 130 131 restoring 130 153 SQL files 24 see also SQL catalogs and SQL indexes backing up examples 76 guidelines 74 75 including in DSAP reports 96 r...

Page 303: ...ser summary report DSAP 106 V VERIFY option DCOM 85 RESTORE 156 Verifying data integrity during backup 69 during RESTORE 156 VERIFYREEL option BACKCOPY 36 BACKUP 69 VERIFYTAPE option BACKUP 69 RESTORE 156 VERSION attribute 291 Viewing tape contents 159 VOL option BACKUP 70 RESTORE 156 VOLUME attribute 291 Volume labels on backup tapes 78 Volume mode BACKUP command syntax 40 284 example 80 guidelin...

Reviews: