HP NonStop Shadowbase Command Reference Manual Abstract The HP NonStop ShadowbaseTM Command Reference explains the command syntax required to configure, operate, and manage the HP NonStop Shadowbase Process environment. Product Version HP Shadowbase Version 6.101\T1122H06^AAA Supported Release Version Updates (RVUs) This manual supports all J-series RVUs and all H-series RVUs (H06.21 and later and J06.10 and later), until otherwise indicated in a replacement publication.
Document History Part Number Product Version Published 785421-002 785421-00 6.101\T1122H06^AAA 6.
Legal Notices © Copyright 2014 Hewlett-Packard Development Company, L.P. Legal Notice Confidential Computer Software. Valid license from HP required for possession, use or copying. Consistent with FAR12.211 AND 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor’s standard commercial license. The information contained herein is subject to change without notice.
HP NonStop Shadowbase Command Reference Legal Notices ....................................................................................................... iii What’s New In This Manual .................................................................................. v Notation Conventions........................................................................................... vi Introduction ...........................................................................................................
PULSESTATS Command.............................................................. 22 RESET AUD Command ................................................................ 28 RUN Command ............................................................................. 28 SET AUD Command ..................................................................... 29 SHOW AUD Command ................................................................. 38 SHUTDOWN Command .........................................................
SHOW CONS Command ............................................................ 177 SOLVSTATS Command .............................................................. 179 START CONS Command ............................................................ 179 STATS CONS Command ............................................................ 180 STATUS CONS Command ......................................................... 192 STOP CONS Command ..............................................................
SET SOLVMGR Command ......................................................... 318 SHOW SOLVMGR Command ..................................................... 330 START SOLVMGR Command .................................................... 331 STATS SOLVMGR Command (Alternative) ................................ 332 STATUS SOLVMGR Command .................................................. 332 STOP SOLVMGR Command ...................................................... 334 UNDO Command Descriptions ...............
What’s New In This Manual o 6.101\T1122H06^AAA o Updated SHOW SOLVMGR Command syntax example Globally added File Chaser reference to SOLVMGR verbiage Amended PURGE DDL verbiage under SET DBS Command section 6.
Notation Conventions Hypertext Links Blue underline is used to indicate a hypertext link within text. By clicking a passage of text with a blue underline, you are taken to the location described. For example: To preserve the modification timestamp, see….on page ___. General Syntax Notation The following list summarizes the conventions for syntax notation and presentation in the HP Shadowbase manual collection. UPPERCASE LETTERS.
Quotation marks around a symbol such as a bracket or brace indicate the symbol is a required character that you must type as shown. For example: “{“ repetition-constant-list “}” Item Spacing. Spaces shown between items are required unless one of the items is a punctuation symbol such as a parenthesis or a comma. For example: CALL STEPMOM ( process-id ) ; If there is no space between two items, spaces are not permitted.
Introduction Overview This manual provides the detail definitions for all commands used to configure, operate, and manage HP Shadowbase. Command definitions are categorized as described in the next section. AUDCOM Command Punctuation An AUDCOM command line spans input records if the last non-blank character is an ampersand (&). Multiple commands, separated by semicolons, can appear on the same line. For example, command-1; command-2; command-3; command-4; & command-5; command-6...
Monitor control commands Commands associated with the AUDMON configuration. Collector process commands Commands associated with the definition and control of Collectors. Consumer process commands Commands associated with the definition and control of Consumers. Database specification commands Commands associated with the definition and control of database specifications related to source and target files/tables being replicated. This includes those tables/files that are being included or excluded.
HP NonStop Shadowbase Command Definitions Basic Command Descriptions HP NonStop Shadowbase Command Definitions Basic Command Descriptions Basic commands are associated with setting context within an AUDCOM session. Once set, they remain in effect for that AUDCOM session only. The basic commands are described below: These commands are session-oriented. Their values are reset to their defaults each time AUDCOM is exited. All VOL commands in the above list, default to the current volume.
HP NonStop Shadowbase Command Definitions Basic Command Descriptions The CMDVOL command sets the default volume and subvolume for expansion of any file names with the exception of the defaults set by the ADTVOL, TARGETVOL, HISTVOL, SOURCEVOL, and TIDVOL commands. The syntax is: CMDVOL [\system.] [$volume.] subvolume DICTVOL Command The DICTVOL command sets the default volume and subvolume for expansion of the SOURCEDICT and TARGETDICT DBS parameters. The syntax is: DICTVOL [\system.] [$volume.
HP NonStop Shadowbase Command Definitions Basic Command Descriptions EXIT Command The EXIT command terminates the current command file input stream and AUDCOM. The syntax is: EXIT Note: The CTRL Y key combination will also work to exit AUDCOM. FC Command The FC command provides the ability to edit or to repeat a command line from the history buffer.
HP NonStop Shadowbase Command Definitions Basic Command Descriptions After editing the line, FC redisplays the command line and prompts for another subcommand. FC terminates when it receives only a carriage return. The corrected line then executes. The FC command can be terminated without execution by pressing BREAK, pressing CTRL/Y, or entering a double slash (//) in columns 1 and 2, immediately followed by a carriage return.
HP NonStop Shadowbase Command Definitions Basic Command Descriptions HELP [ /OUT / ] { { { { { [ALL] [HELP] [*] } command } } } } command Is one of the following HP Shadowbase commands: Issuing a HELP command for the various SET
HP NonStop Shadowbase Command Definitions Basic Command Descriptions HISTORY [ ] HISTVOL Command The HISTVOL command sets the default volume and subvolume for the location of the AUDHST file/table used to record historical statistics about processing. The syntax is: HISTVOL [\system.] [$volume.] subvolume LICENSE Command HP Shadowbase is a licensed software product. You need to have a HP Shadowbase license to run it on any system where you install it. As of HP Shadowbase version v3.
HP NonStop Shadowbase Command Definitions Basic Command Descriptions LICENSE must be the first command issued after opening AUDMON (via AUDCOM). You can change the HP Shadowbase password file and dynamically issue a new LICENSE command to pick up the new license information while HP Shadowbase is running (e.g., to get a new license expiration date). However, be careful to place the new password file in the appropriate location where any of your OBEY files used for HP Shadowbase startup can get to it.
HP NonStop Shadowbase Command Definitions Basic Command Descriptions { OBEY } { O } filename filename Is the name of the edit file containing commands to read. It can be fully qualified with the volume and subvolume names. AUDCOM reads and executes commands from the named file until it encounters an EXIT command or end of file. At that point, AUDCOM closes the OBEY file and command input reverts to the file from which the OBEY command was read.
HP NonStop Shadowbase Command Definitions Basic Command Descriptions The OPEN command specifies the name of the AUDMON process to which subsequent commands are directed. This command is useful when more than one HP Shadowbase system is running on the same HP NonStop system; commands can be directed to any AUDMON from a single AUDCOM session. Additionally, multiple users can OPEN the same AUDMON, however only one will be able to change the status of the objects in the environment.
HP NonStop Shadowbase Command Definitions Basic Command Descriptions SOURCEVOL Command The SOURCEVOL command sets the default volume and subvolume for expansion of source DBS file names. The syntax is: SOURCEVOL [\system.] [$volume.] subvolume SPAN Command The SPAN command establishes a list of AUDMON process names that will receive the subsequent AUDCOM commands. These commands are generally “read-only” in nature, and not command and control in nature.
HP NonStop Shadowbase Command Definitions Basic Command Descriptions SPANOFF TARGETVOL Command The TARGETVOL command sets the default volume and subvolume for expansion of destination DBS file names. The syntax is: TARGETVOL [\system.] [$volume.] subvolume TIDVOL Command The TIDVOL command sets the default volume and subvolume for expansion of the Consumer transaction status file name. The syntax is: TIDVOL [\system.] [$volume.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions Monitor Command Descriptions Monitor commands are associated with the definition and control of the HP Shadowbase AUD Object. Commands are available to start and stop a monitor, set limitations on the number of descriptions that can be entered, specify logging requirements, and display configuration status. These configuration control commands are described below.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions See SET AUD Command description, below, for details of the various aud_parameters. ASSUME Command The ASSUME command establishes the object type associated with subsequent commands. It keeps the object type from having to be entered for each command.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions [,CONSNAME ] [,COLLNAME ] } [,MATRIX] [,SERVERS] Displays extended resource usage and system performance statistics. ----------------------------------------------------------------- RESET, INTERVAL, COLLNAME, SERVERS options – These options function identically to the corresponding options for the STATS AUD command.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions ADTWARNRATE 900 . . . TRACEFILE ? TACL PARAM SETTINGS (AUDMON \H2.$JMZM1): SAMECPU = 1 SBCOLLFLUSHFACT = 5 SBCOLLTRANSIDTIMER = 5 SBCONSREPOUTPUT = 1 If no TACL params were set, the output will be as follows: +INFO AUD SHADOWBASE VERSION INFO - V4092 - (17JAN11) AUD OBJECT SETTINGS (AUDMON \H2.$JMZM1): ADTWARNRATE 900 . . . TRACEFILE ? NO TACL PARAMS DETECTED (AUDMON \H2.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions LOG Command The LOG command specifies the name of an optional file used for reporting changes in status. The syntax is: LOG [ filename ] filename Is the name of a file to receive reports. When specifying a disk file, the file must be an existing unstructured file. See the HP NonStop Shadowbase Installation and Planning Manual for information on pre-creating the log file.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions SET AUD SET AUD SET AUD SET AUD SET AUD SET AUD SET AUD SET AUD [LICENSE SET AUD SET AUD SET AUD SET AUD SET AUD SET AUD SET AUD SET AUD SET AUD SET AUD SET AUD SET AUD SET AUD [SET AUD SET AUD [SET AUD ADTWARNRATE 900 ADTWARNTDIFF 900 AUTORESTART ON AUTOSTOP OFF BACKUPCPU 0 CONFIRMCONTROL OFF CONFIRMSHUTDOWN OFF HISTORYRATE 3600 DATE 2014-08-01 ] MAXCOLL 1 MAXCONS 5 MAXPULSESTATS 2 MAXQMGR 0 MAXQUERYDUR 60 MONITORRATE 300 NORUNTIMEOUT
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions PULSE Command The PULSE command enables the operator to send a special data packet, known as a ‘PULSE’ through the replication stream. When completed, the PULSE will provide a series of timings based upon how long it takes the message to transverse the replication stream and return to the source component. These PULSe timing values can then be read by issuing the PULSESTATS command.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions The ! (now) option can be used to expedite a pulse. Expedited pulses are not inserted into the TMF audit trail like normal pulses; instead, they are sent directly to the COLL and injected into the replication stream immediately. Upon successful completion of the PULSE command, a message will be displayed to list the CONS objects that will receive the pulse event.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions PULSESVRCLOCKADJ parameters (see the respective section for each of these parameters). If a clock drift exists and the drift is not accounted for by the PULSECLOCKADJ and PULSESVRCLOCKADJ parameters, it is possible that the target clock has drifted either ahead of or behind the source’s clock, potentially leading to negative numbers being reported for the time differences in the PULSESTATS output.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions TOTAL DISPLAYED 2 TIMED OUT 0 ACTIVE (INCOMPLETE) 0 INCOMPLETE 0 IN BAND 2 OUT OF BAND 0 ============================================================================= The following defines the content for each pulse record displayed. Note: That the data content displayed is based upon what is made available by the target environment, e.g., a HP NonStop or HP Shadowbase Other Servers target (the example above is for a HP NonStop target).
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions STATE – This is the state of the pulse event. Possible values are: INCOMPLETE (in progress or never completed), ACTIVE (incomplete but CONS did a pulse file target I/O), TIMED OUT, COMPLETE (“in band”), i.e.,i.e., it completed within the PULSEMAXRESPONSE, and COMPLETE-OOB (“out of band”), i.e.,i.e., it completed by not within the PULSEMAXRESPONSE.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions SV RECV TS - For a HP NonStop Consumer server or HP Shadowbase Other Servers, this is the time when the server received the pulse event. Setting of this time by the Consumer can be disabled by entering the SBCONSPULSERECV TACL PARAM with the value set to zero before starting AUDMON. See the HP NonStop Shadowbase Operations Manual for details on the SBCONSPULSERECV TACL parameter.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions DIRWR USRX DUR – This is the run-time duration (wall clock time) for the calls counted in DIRWR USRX CALLS. DOCWR USRX CALLS – For an open DOC Writer, this is the number of user exit calls made since startup or since the last pulse event acknowledgement. DOCWR USRX DUR - This is the run-time duration (wall clock time) for the calls counted in DOCWR USRX CALLS.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions Note: The total does not include the number that have timed out because a pulse can subsequently complete even though it has timed out. As with the AUDCOM STATS command, the PULSESTATS command supports the INTERVAL parameter. This is used to repeat the PULSESTATS request at intervals. It is subsequently terminated by hitting the break key.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions RUN [ ! ] ! Means ignore any configuration errors. SET AUD Command The SET AUD command configures AUDMON. Enter this command before issuing a START AUD command. In each description, there is a version box. This box contains information, as in the samples below. Initial Version 2.000 Changed Version 2.603 Initial Version 2.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions Is the rate, in seconds, at which warning messages are sent to EMS. These messages warn that a Collector is falling behind in audit reading based upon ADTWARNTDIFF. The default is 900 seconds (15 minutes); warnings are enabled. The minimum allowable value is 1 second. However, 0 can be entered to disable warnings. Note: Use caution in reducing this parameter.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions 2.700 OFF OFF ON Yes Enables or disables AUDMON from automatically restarting Collectors and Consumers in the event a process fails. Restart behavior is affected by the BACKUPCPU, FAILMAX, FAILRETRYDELAY, and FAILSPAN Collector parameters and by the BACKUPCPU Consumer parameter. The default is OFF. AUTOSTOP Initial Version 2.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions When set to ON, the user will be asked to enter Y or N to confirm that the indicated control command (ALTER
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions default is 1. The maximum value is 255. Depending upon your implementation strategy, setting this parameter may not be necessary. MAXCONS number Initial Version 1.000 Changed Version Values Default 1 Minimum 1 Maximum 255 Alter No Is the maximum number of Consumer processes that can be described in the HP Shadowbase configuration. At least 1 must be configured and the default is 1. The maximum is 255.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions MAXQMGR number Initial Version 4.090 Changed Version Values Default 0 Minimum 0 Maximum 255 Alter No Is the maximum number of Queue Managers which can be configured within this AUDMON instance. The Queue Manager is an optional component of HP Shadowbase: default value is 0, no Queue Managers are configured within AUDMON.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions or “suspended” state (not running)”. Note again that the timing of the message is not precise and is based from the MONITORRATE period. It could take several MONITORRATE cycles to result in a message if MONITORRATE is set less than NORUNTIMEOUT. Or, it could take a MONITORRATE cycle to result in a message if MONITORRATE is set greater than NORUNTIMEOUT. The default for NORUNTIMEOUT is 900 seconds..
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions STATICTMFSERVE Initial Version 2.000 Changed Version { ON } { OFF } Values Default OFF Minimum OFF Maximum ON Alter Yes Tells AUDMON whether to use a static TMFSERVE process (when set to ON) or a dynamic TMFSERVE process (when set to OFF) to get information about the TM/MP environment. It defaults to OFF. STATSRESET Initial Version 4.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions If DAY (DAILY) is entered, the reset will occur every day in the specified months at the specified time. You can also enter the days of the month which the reset are to occur. Enter up to ten numbers separated by commas. For example, enter SET AUD STATSRESET DAY (1,16), HOUR (12:00) to reset statistics at noon on the first and sixteenth day of every month (the default).
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions Note: Tracing generates a lot of additional overhead, and will significantly affect performance. Tracing should never be enabled except under direction from HP Shadowbase Support. TRACEFILE filename Initial Version 2.000 Changed Version Values Default Value Specifications None Valid file name Include NODE Alter Yes When tracing is enabled, this identifies the file name where the results are to be output.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions This directs listing the output to a named file. If this option is omitted, listing output is directed to the AUDCOM list file; this is typically the home terminal.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions Note: It is highly recommended that you review the Stopping HP Shadowbase section in the HP NonStop Shadowbase Operations Manual before issuing a SHUTDOWN command. START AUD Command The START AUD command starts the HP Shadowbase system.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions STATS [/OUT /] {[AUD] [,DETAIL] [,RESET] [,INTERVAL {HRS} {MINS} {SECS}] [,{ {COLLNAME } {SERVERS]} }] DETAIL – This option requests that the file and/or DBS level statistics be displayed. Note that the COLL and CONS EXTENDEDSTATS parameter definition will determine what will be provided.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions ------------------ COLL/QMGR/CONS AS OF 08-26 10:04:47.495191 ----------------NAME CPU PNAME ADT POSITION LE TIME DIFF (CUR) ------------------ --- ------ -------------------- -------------- ------------SYSTEM: \GRAVIC1 COLL-PCOLL 1 $PCOLL AA000372/01772863261 08-26 10:04:34 00:00:13.183 SYSTEM: \GRAVIC1 CONS-OPN-PCON1 0 $PCON1 000000/00000000000 ??-?? ??:??:?? 00:00:00.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions of events applied as an INS/CRT, UPD/ALT, or DEL/PRG. The Totals of original events are summed on the right-most column, and the totals of the final (applied) events are totaled in the bottom row. The sample display indicates that the original DO UPDATE event was tried, the record on the target could not be found, and since DBS INSERTNOTFOUND ON, it was changed to an insert and applied as an INS/CRT final event.
HP NonStop Shadowbase Command Definitions Monitor Command Descriptions TRACE CLOSED HISTORY ON \GRAVIC1.$QA.QAOPEN.AUDHST COLLECTOR/QMGR/CONSUMER/SOLVMGR STATES: NAME PROCESS TYPE STATE ---------------- ---------------- ---- --------COLL-PCOLL \GRAVIC1.$PCOLL COLL RUNNING LTS (LAST EVENT): CONS-OPN-PCON1 \GRAVIC1.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions Collector Command Descriptions Collector commands are associated with the definition and control of Collector processes in a HP Shadowbase system. A Collector process gathers, or collects, changes from the audit trails and passes information about those changes to the Consumer process(es).
HP NonStop Shadowbase Command Definitions Collector Command Descriptions Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment will be used. ADD COLL Command The ADD COLL command enters a description of a Collector into the HP Shadowbase configuration. This command is entered after the appropriate SET commands for the Collector have been issued.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions Version 3.700 Version Values Default None Valid subvolume Alter No The syntax is: ALTER [ COLL ] [.] { , coll_param } [ ,coll_param ]... audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment will be used.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions The TRANSID entered is the original audit trail transaction identifier that was captured by the COLL, not the CONS’s replication transaction identifier for the TMF transaction it starts. The syntax for CLEARTX is as follows. The is the name of the COLL object that is tracking the transaction.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions state of that transaction when it was active and terminated inside your system. This command is not permitted for transactions that are still active in TMF. IT IS HIGHLY RECOMMENDED THAT YOU NOT USE THIS COMMAND UNLESS INSTRUCTED TO DO SO BY HP SHADOWBASE SUPPORT, AND YOU ARE COMPLETELY CERTAIN OF THE OUTCOME.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions DUMPTX COLL Command DUMPTX COLL can be used to request a listing of transactions being tracked by a COLL. The command syntax for the DUMPTX command is as follows: DUMPTX /OUT / [COLL] [.]{{ } { *}} [,LISTCOUNT][,RESET] audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions The following is a sample of the DUMPTX output for a COLL process. COLL DUMPTX TRANSACTION TRACKING DETAIL AT 2011-02-01:11:18:28 : ========================================================================= ==== NAME: COLL01 PROCESS: \S1.$GSCL1 AUDMON: \S1.$GESM1 TRANS BUSY: 1 CUR MAT: $AUDIT.ZTMFAT.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions This directs listing the output to a named file. If this option is omitted, listing output is directed to the AUDCOM list file; this is typically the home terminal. audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment will be used. coll_name Is the logical name of a previously defined Collector.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions ARCHIVEACCESS OFF ARMAXIGNORECNT 1000 ARRETURNNDCRECS OFF BACKUPCPU ? CHKPTDELAY 500 CHKPTTIME 300 CHKPTWARNRATE 900 CHKPTWARNTDIFF 8100 CHKPTWARNTDIFFB 8100 CPU 1 CPULIST ( ? ) DEBUG OFF EXPANDRECOVERY ON EXTENDEDSTATS ALL FAILMAX 2 FAILRETRYDELAY 60 FAILSPAN 900 FASTSAMPLE OFF FASTTRACK ON GETRECADDRERROK OFF KEYEDCACHEDEPTH 0 KEYEDONLY OFF LABELCACHEDEPTH 10 LATENCYTHRESHOLD 0 LATENCYWARNRATE 3600 LOGAGECLEAR ON LOGAGECLEARBID OFF M
HP NonStop Shadowbase Command Definitions Collector Command Descriptions audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment will be used. INFOTX can be requested for a specific COLL object by specifying its name. The OUT file is where the output will be displayed and is optional.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions NEXTDOC [ COLL ] [[.] ] audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment will be used. coll_name Is the logical name of a previously defined Collector.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions SET [SET [SET [SET [SET [SET [SET [SET [SET [SET [SET [SET [SET [SET [SET [SET [SET SET [SET [SET [SET [SET SET [SET [SET [SET [SET SET SET SET SET SET SET SET [SET SET SET SET SET SET SET [SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL
HP NonStop Shadowbase Command Definitions Collector Command Descriptions SET SET SET SET SET SET SET SET SET [SET SET SET ADD COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL COLL NEXTDOCTRIGGER OFF PRI 99 PROCESS \H2.$KUCL1 PROGRAM \H2.$KGU.KGU5000E.AUDCOLLN PULSECLOCKADJ 0 RESERVEDBUFFERS 10 RESTARTFILE \H2.$KGU.CONFIGS.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions RESUME [ COLL ] [.]{ coll_name } { * } audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment will be used. coll_name This resumes execution of the named Collector. * This resumes execution of all suspended Collectors in the HP Shadowbase system.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions SET COLL Command The SET COLL command establishes values for the attributes of a Collector. In each description, there is a version box. This box contains information, as in the samples below. Initial Version 1.000 Changed Version 2.700 Initial Version 2.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions 2.000 ON OFF ON Yes Enables or disables automatic stopping of the Collector process if it falls behind in audit trail reading. This is an optional parameter. The default is ON. When set to ON, it will ensure that the Collector does not negatively affect the functioning of TM/MP on your system. Before AUDMON stops the Collector(s), EMS warning messages will be issued indicating that a potential problem may be developing.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions ADTEOFDELAY Initial Version 4.000D Changed Version Values Default 0 Minimum 1 Maximum 32767 Alter Yes This defines a minimum wait time duration that a Collector will wait (back off) before a (re)”poll” of the TMF master audit trail following all nonrollover end-of-file conditions for the master audit trail, regardless of the activity occurring in the Collector (i.e.,i.e.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions Initial Version 2.000 Changed Version Values Default None Value Specifications Valid subvolume Alter No Specifies the default volume and subvolume to which audit trails are restored when HP Shadowbase reads them from tape to disk. Audit trails must reside on a disk on the local system. Therefore, if \systemname is included in this definition it will be ignored.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions AUDMON. See the HP NonStop Shadowbase Operations Manual for details on the SBCOLLNOSCRPURGE TACL parameter. • With TMFARLB2 support for TMF format 2 audit trails, HP no longer allows HP Shadowbase to restore audit trails to the HP Shadowbase audit scratch subvolumes (i.e.,i.e.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions Note: This parameter will be ignored if the file indicated by the RESTARTFILE parameter exists. ADTSTARTNAME Initial Version 2.000 Changed Version { adt_filename } { adt_filename_prefix } { -1 } Values Default None Value Specifications Alter Valid MAT full filename No Partial file name up to the AA prefix –1 to reset Is the name of the audit trail file where the Collector begins reading.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions Note: This parameter will be ignored if the parameter ADTSTARTEOF is set to ON. Note: Effective with the 3.970 release of HP Shadowbase, in support of format 2 TMF audit trails, the limit for the parameter has been increased to 1,099,510,579,200 (i.e.,i.e., the current maximum audit trail size). ADTSTARTSEQLO Initial Version 2.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions this audit trail first. If the ADTSTARTTIME indicated is lower than the earliest time in the first audit trail read, the Collector will search the TM/MP catalog for the audit trails that contain the desired time. This is an optional parameter. This parameter cannot be used to position the collector for starting in a bi-directional replication environment.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions Initial Version 2.000 Changed Version Values Default Value Specifications None -1 reset only MAT filename Alter Yes Is the name of the last audit trail file to be processed. Enter the filename only, not the \systemname, volume or subvolume. HP Shadowbase determines the volume and subvolume from the starting volume and subvolume. This is an optional parameter. Entering -1 will clear the field’s value. ADTSTOPRBA Initial Version 2.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions Is the audit trail event time at which the Collector will stop reading from the audit trail files. Reading will stop when this time is reached. Stop_date is optional. If not entered, the current date is assumed. If stop_date is entered it must be in the format MMM DD YYYY, where MMM are the first three characters of the month name (e.g.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions generally true for application waits on COMMITs to complete). If this is the reason, you may be able to mitigate the LTMF wait state by adding Collector throttling to your configuration. ADTXEOFREPEATS num Initial Version 3.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions override this by setting the COLL parameter ARMAXIGNORECNT from 0 to 2147483647. When set to 0, TMFARLB2 will not return a “current audit trail position” event. It will continue reading until it has an event to return to HP Shadowbase for processing (i.e., setting the parameter to 0 mimics the AUDCOLL ARLIB1 behavior). Note that ARMAXIGNORECNT can be altered after the Collector has been started. ARRETURNNDCRECS Initial Version 3.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions Specifies the number of the CPU to be used as a backup for the Collector process (which means the Collector process will run as a persistent process). The CPU for the value entered must exist on the system. If the AUD object AUTORESTART parameter is set to ON and the Collector process fails due to a CPU failure, AUDMON will restart the Collector process in the BACKUPCPU.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions This defines the time that the Collector is to wait before outputting an EMS message to indicate that the Collector restart position is lagging behind. The valid range is 0 through 32767 seconds. The default is 900 (15 minutes). If the Collector lags behind and an EMS message is issued and then it catches back up and then lags behind again shortly thereafter, it won't issue another behind EMS until CHKPTWARNRATE time has passed by.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions lagging behind if the difference between the time of last read audit trail record and the time of the current audit trail restart position is equal to or greater than CHKPTWARNTDIFFB. In release v3.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions indicate which processor is used. The CPULIST can be altered. However, it can’t be altered to disabled (-1). DEBUG Initial Version 2.000 { OFF } { ONSTART } { ONERROR } Changed Version Values Default OFF Value Specifications ONSTART ONERROR Alter No Specifies whether a Collector enters debug mode and under what condition. This should only be set when HP Shadowbase instructs you to do so for diagnosing problems.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions INCLUDE statistics are for those file/table partitions selected for replication. The default value is ALL. The parameter can be altered anytime. FAILMAX Initial Version 2.700 num Changed Version Values Default Minimum 0 indefinite 0 Maximum 128 Alter Yes This specifies the maximum number of failures of a Collector and its related Consumers allowable within the FAILSPAN period.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions Initial Version 2.700 Changed Version Values Default OFF Minimum OFF Maximum ON Alter Yes When set to ON, it indicates that the units entered for ADTSAMPLEDELAY and TURBOWAITTIME are in hundredths of seconds rather the whole seconds. Default value is OFF. FASTTRACK Initial Version 3.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions KEYEDCACHEDEPTH Initial Version 2.300 Changed Version num Values Default 128 Minimum 0 disable Maximum 512 Alter No This sets the cache size to be maintained by audit reading for key sequenced source files/tables. It defaults to 128. The maximum is 512. Setting to 0 turns parameter off, but requires that the KEYEDONLY parameter be set to ON (see below). KEYEDONLY Initial Version 2.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions NOTES: For the non-native HP Shadowbase AUDCOLL program, the LABELCACHEDEPTH parameter specifies the number of SQL/MP table label information blocks that the HP TMFARLIB maintains in memory (the TMFARLIB is the audit trail reading library provided by HP). The minimum value specified for this should be 10 and the maximum possible value is 2000. The default value is 10.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions LIKE coll_name Initial Version 2.000 Changed Version Values Default None Value Specifications Collector Name Alter No Sets the attributes of the current Collector to those of the one named in coll_name. MAXCONS number Initial Version 1.000 Changed Version Values Default 1 Minimum 1 Maximum 255 Alter No Is the maximum number of Consumer processes with which the Collector can communicate. The number must be at least 1.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions to ON, this indicates to log the “age clear” messages to EMS. The default is OFF to disable logging. MAXCONSWRITES number Initial Version 2.000 Changed Version Values Default 1 Minimum 1 Maximum 15 Alter No Is the maximum number of simultaneous interprocess messages I/Os that can be outstanding to a Consumer (Guardian “nowaited” I/O). This number can be from 1 to 15 (15 is the largest Guardian nowaited I/O depth).
HP NonStop Shadowbase Command Definitions Collector Command Descriptions 2.000 OFF OFF ON Yes Enables or disables the gathering of Measure statistics in the Collector. The default value is OFF. In order for this parameter to take effect, a Measure session must be started first from TACL. A sample Measure session exists in the file MEASINEX that comes with the product. See the HP NonStop Shadowbase Operations Manual for more information on using the Measure feature.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions If WKDAY (WEEKDAY) is entered, the DOC will roll every weekday (not weekends) during the specified months at the specified times. You can also specify the days of the week on which the DOC is to roll. Enter up to seven numbers separated by commas to indicate the days of the week (1 = Monday... 7 = Sunday). For example, enter SET COLL NEXTDOCTIME WKDAY (1,5), HOUR (HOURLY)to roll the DOC every hour on every Monday and Friday.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions PRI number Initial Version 1.000 Changed Version Values Default None Minimum 1 Maximum 199 Alter No Is the priority at which the Collector runs. The number can be from 1 to 199. If this parameter is omitted, the default is a priority of 20 less than the priority of AUDMON. PROCESS Initial Version 1.000 [\system.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions When PULSEAUTOADJ is enabled this parameter is configured automatically. PULSECLOCKADJ is specified in microseconds (i.e.,i.e., 1/1,000,000th second intervals). The default value is 0, meaning no time adjustments are made. The valid range is -2147483647 to 2147483647, i.e.,i.e., about 2147 seconds in either direction. Note that a plus sign should not be specified for positive numbers. This parameter can be altered at any time.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions Version 2.000 Version Values Default ON Minimum OFF Maximum ON Alter Yes This specifies whether resource usage and system performance statistics are to be gathered for later display with the STATS COLL command. The default is ON. See STATS COLL command for more information. TRACE Initial Version 2.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions When set to ON, the Collector will block multiple events (e.g., I/O operations) into each message before sending that message to the Consumer; otherwise, the IPMBLOCKING parameter determines if event blocking is used. This may enhance performance. When TURBOMODE is ON, the Collector waits for a message buffer to fill, TURBOWAITTIME to pass by, or TURBOMAXEVENTS to be processed, and then sends the message to a Consumer.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions An example of the results of doing an SHOW COLL command is shown below: COLL OBJECT SETTINGS: ADTAUTOSTOP OFF ADTAUXMASK 111111111111111 ADTEOFDELAY 0 ADTSAMPLEDELAY 10 ADTSCRATCHVOL ? ADTSCRATCHXVOL01 ? ADTSCRATCHXVOL02 ? ADTSCRATCHXVOL03 ? ADTSCRATCHXVOL04 ? ADTSCRATCHXVOL05 ? ADTSCRATCHXVOL06 ? ADTSCRATCHXVOL07 ? ADTSCRATCHXVOL08 ? ADTSCRATCHXVOL09 ? ADTSCRATCHXVOL10 ? ADTSCRATCHXVOL11 ? ADTSCRATCHXVOL12 ? ADTSCRATCHXVOL13 ? ADTSCR
HP NonStop Shadowbase Command Definitions Collector Command Descriptions KEYEDONLY OFF LABELCACHEDEPTH 10 LATENCYTHRESHOLD 0 LATENCYWARNRATE 3600 LOGAGECLEAR ON LOGAGECLEARBID OFF MAXCONS 5 MAXCONSWRITES 15 MAXQMGR 1 MEASURE OFF NEXTDOCTIME MONTH(ALL),DAY(DAILY),HOUR(00:00) NEXTDOCTRIGGER OFF PRI 99 PROCESS \H2.$KUCL1 PROGRAM \H2.$KGU.KGU5000E.AUDCOLLN PULSECLOCKADJ 0 RESERVEDBUFFERS 10 RESTARTFILE \H2.$KGU.CONFIGS.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions STATS COLL Command The STATS COLL command displays resource usage and system performance statistics for a Collector. In order to gather statistics, the COLL STATS parameter must be set to ON. The syntax is: STATS [/OUT /] {[COLL] [.]{} {* }} [,DETAIL] [,LAG] [,SUPPRESS] [,RESET] [,INTERVAL {HRS} {MINS} {SECS}] OUT list_file This directs listing the output to a named file.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions The STAT COLL command will now show the HP NonStop Shadowbase product T-Number, and release version. Example of the STATS COLL command: SHADOWBASE - T1122 - V6100J06 - (08AUG14) COLL STATS AT 2014-08-26:10:05:27 : NAME: COLL-PCOLL PROCESS: \GRAVIC1.$PCOLL SINCE: 2014-08-26:10:04:34 AUDMON: \GRAVIC1.$PAUDM DURATION: 00:00:52.393 LATENCY WARNING STATUS: DISABLED ETS: 08-26 10:05:21.564 DIFF (CUR): 00:00:00.000 LTS: 08-26 10:05:21.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions ETS: 08-26 10:05:31.592 DIFF (CUR): 00:00:00.000 LTS: 08-26 10:05:31.592 LAG (CUR): 00:00:00.000 AUDITTRAIL PROCESSING SUMMARY: SEQ: AA000372 RBA: 0001772863829 EOF(S): 0000017 WAIT: 00:01:02.189 RESTART INFO (MAT POSITION): SEQ RBA TIME LAG (CUR) DIFF LTS ------ ------------- -------------- ------------ -----------000372 1772863828 08-26 10:05:31 00:00:07.006 00:00:00.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions shows the AUDMON process controlling the Collector. DURATION shows the time duration for the statistics. Either from the initial startup of the COLL or from the last RESET. AUDMON Notes: If the lag is greater than 100 hours, it will be displayed as “>100 HOURS”. If the Collector/Consumer is caught up, zeros will be shown. If there are no messages busy or queued for a Consumer, the lag times will be blank.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions shows what the lag time is from the Collector’s current audit trail read position (where the Collector is currently reading from) to the current wall clock time (this is the current replication latency). This lag time show how far behind the Collector is in audit trail processing. Note that even when the Collector is caught up, the LTS lag may show that the Collector is behind by up to ADTSAMPLEDELAY seconds (see below).
HP NonStop Shadowbase Command Definitions Collector Command Descriptions AUDITTRAIL PROCESSING SUMMARY – This section of the output displays current audit trail position information for any audit trails being read. SEQ shows the Sequence number of the audit trail currently being processed. RBA shows the current position within the audit trail expressed as the relative byte address. EOF shows the number of times it encountered the end of the audit trail file.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions information. This section is only displayed for bi-directional replication environments. SEQ shows the current audit trail Sequence number saved in the bidirectional RESTARTFILE. RBA shows the bi-directional restart position within the audit trail expressed as the relative byte address. TIME shows the bi-directional restart point timestamp. LAG (CUR) shows the difference between current time and the restart point timestamp.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions NUM ABORTING tracked. shows the number of aborted transactions currently being shows whether the ABORT TIMER is on or off for the aborted transactions currently being tracked. (The ABORT TIMER helps resolve certain specific TMF recovery scenarios such as when a TMF failure/restart has occurred). NUM PEER TRANS NO AUDIT shows the number of the peer-CONS’s pre-started transactions that have not yet yielded audit events.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions Subvolume Prescreening cannot be used (e.g. because there are too many distinct subvolumes being replicated or where wildcards are in use), the Collector now tracks all files appearing in an audit trail (that either “pass” the prescreened subvolumes as described above or all files appearing in the audit trail otherwise in a searchable “tree” of file names.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions number of completed inter-process messages sent to CONS and QMGR processes and responded to (i.e.,i.e., the ACK received). Note that this does not necessarily indicate that this number of messages that have been fully processed. This is because when RESOLVELOCKSQ is enabled, messages become completed before they have been fully processed (i.e.,i.e., the CONS responds almost immediately after the message has been received).
HP NonStop Shadowbase Command Definitions Collector Command Descriptions DOC ROLL STATUS INFO (PREVIOUS) – This section is only displayed after the first DOC roll completes. SCHEDULE shows the scheduled time of the last completed roll preceded by the type of roll schedule used: ADT – Audit trail based. TOD – Time of day based. CMD – User command based. LAST AUDITTRAIL REC shows the timestamp of the last audit trail record processed before the DOC roll began.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions end. It only means that the CONS has accepted it, and sent an “early ACK” response back to the Collector. When RESOLVELOCKSQ is OFF, a CONS reply indicates that the message has been fully processed. The LAG option has been added to the STATS COLL command to obtain Collector and Consumer lag information. The Consumer information will be displayed if the DETAIL option is entered.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions This directs listing the output to a named file. If omitted, listing output goes to the AUDCOM list file; this is typically the home terminal. audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment will be used. coll_name Is the name of the Collector. * This indicates to include all Collectors.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions The UNDOMODE indicator signifies that the status command was executed during an UNDO processing sequence, effective release v5.001. The STATUS COLL command will now show the HP NonStop Shadowbase product T-Number, and release version. An example of the results of doing an STATUS COLL command is shown below: SHADOWBASE - T1122 - V6100J06 - (08AUG14) COLL STATUS AT 2014-08-26:09:41:57 : AUDMON: \GRAVIC1.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment will be used. coll_name Is the name of the Collector. * Indicates include all Collectors. ! If the ! (now) option is used, the CONFIRMSHUTDOWN parameter will not be considered, and the command will be run without additional confirmation.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions Is the name of the Collector. * This indicates to suspend all Collectors. SUSPENDUPD COLL Command The SUSPENDUPD COLL command suspends audit data processing by entering a specific token into the end of the audit trail; when that event arrives at the target Collector(s), all Consumers attached to them stop processing audit trail events until a RESUMEUPD command is entered. The syntax is: SUSPENDUPD {[COLL] {[.
HP NonStop Shadowbase Command Definitions Collector Command Descriptions or which file should be executed should the AUDMON be on a different node. Note: The IN and OUT files in the SYSCALL must be set to $NULL unless a command input file and outfile are assigned. It is also very important that NOWAIT be used for any SYSCALL invoking AUDCOM. Otherwise, AUDMON will block. If this is accidently done, locate the related running AUDCOM and stop it. Example with SYSCALL: SUSPENDUPD COLL *,SYSCALL (RUN $DATA1.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions The columns are defined as follows: - - - TABLE_VERSION: The version of the logical table, currently set to 4092. TRANSID: The transaction id the command was issued under. The id isthe same for all recipients of this command. This field allows the target side to group all of the suspend or resume events received down the various threads by the “unique” TRANSID number.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions appropriate SET commands for the Consumer and after adding the Collector. The syntax is: ADD [ CONS ] [.] audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment will be used.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment will be used. cons_name Is the logical name of a previously defined Consumer. cons_parameter Is an attribute to change. It consists of a keyword and a value or set of values for that parameter.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions Note that you will be prompted to confirm this command. If the transaction is still active in TMF, you will be prompted two times. CLEARTX [ CONS ] [.], TRANSID audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment will be used.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions DUMPTX CONS Command DUMPTX can be used to request a listing of transactions being tracked by a COLL or CONS. The command syntax for the DUMPTX command is as follows: DUMPTX /OUT / [CONS] [.]{{ } { * }} [,LISTCOUNT][,RESET] audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions CONS DUMPTX TRANSACTION TRACKING DETAIL AT 2011-02-01:11:20:23 : ============================================================================= NAME: CONS01 PROCESS: \S1.$GSCSX AUDMON: \S1.$GESM1 TRANS BUSY: 1 --------------------------------------------------------------------------TRANS 1 OF 1: ADT TRANSID: \S1(2).0.1983901 / 216172912130719746 CONS TRANSID: \S1(2).0.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions +info cons * SHADOWBASE VERSION INFO - V5002CH06 - (31MAY13) CONS CONS-OPN-WGHC1 OBJECT SETTINGS (AUDMON \H2.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions *NETPORT 19555 *NETPROCESS \H2.$ZB03B NETRETRYDELAY 15 NETSENDMINWAIT 0 NETSWAPCONNECT OFF NETSWITCHONERROR ON NETTIMEOUT 300 NETUSERNAME SHADUSER NETUSERPASSWORD SHADPASS NETWINDOWSIZE 245000 NOEXPAND OFF NUMTRANSPRESTART 12 OVFLQFILE ? OVFLQFILEEXTENT ( 1000, 1000, 500 ) OVFLQFILEINDEX ? PRI 120 PROCESS \H2.$WGHC1 PROGRAM \H2.$QA.QA5002C.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions TIDFILEINDEX ? TIDFILEPURGE OFF TMFTRANS ON TRACE 3 TRACEFILE \H2.$QA2.LGNSKTCP.BILLTRCE TRACKTXAUDITED ON TRACKTXFILE ? TRANSLOG ? TURBOMAXEVENTS 0 TYPE BASIC USEREXITCOLCHECK ON USERTRACE OFF WARNINGS OFF + INFOTX CONS Command INFOTX can be used to request a listing of a specific transaction that is currently being tracked by a CONS.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions CONS INFOTX TRANSACTION TRACKING DETAIL AT 2008-03-12:13:51:10 : ============================================================================= NAME: CONS00 PROCESS: \S1.$GSCS0 TRANS INFO: ADT TRANSID: \S1.0.2759400 / 216172962953822208 CONS TRANSID: \S1.0.2759401 / 216172962953887744 BEGIN ADT EVENT INFO: ADT TS (EVENT): 2008-03-12 13:43:56.673667 DIFF: 00:07:13.531556 CONS TS: 2008-03-12 13:44:01.693752 DIFF: 00:07:08.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions [SET SET SET [SET SET [SET [SET SET SET SET [SET [SET SET SET [SET SET SET SET SET SET SET SET SET SET SET SET SET SET [SET SET [SET [SET SET [SET SET [SET SET [SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET [SET SET CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS C
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions [SET SET SET SET SET SET SET SET SET SET SET SET [SET [SET SET SET SET SET SET SET SET SET SET SET SET [SET SET [SET [SET SET SET SET [SET SET SET SET SET SET SET SET SET SET SET SET [SET [SET [SET SET SET [SET SET SET SET SET SET [SET [SET SET SET SET SET SET ADD CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS CONS
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions RESET CONS Command The RESET CONS command resets a Consumer parameter from the currently set value to the default system value. The syntax is: RESET [ CONS ] [ cons_parameter [ , cons_parameter ] ... ] cons_parameter - If omitted, all cons_parameter values are reset. Cons_parameters appear in detail in the SET CONS command description. RESUME CONS Command The RESUME CONS command continues execution of a suspended Consumer.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions { * } } {[ CONSGROUP ] [.]{ consgroup_name } { * } } audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment will be used. cons_name This resumes execution of all Consumers attached to the named Collector. * This resumes execution on all SUSPUPD Consumers in the HP Shadowbase system.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions The last row of the version box is used for “client” Consumer, “server” Consumer “extended” Consumer, and “open target” server. An ‘X’ in the check box means that the parameter is used for this type of Consumer. The syntax is: SET CONS cons_parameter [ , cons_parameter ] ... cons_parameter is one of the following: ABORTTRANS Initial Version 2.100 { ON } { OFF } Changed Version Values Default 3.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions Version 2.700 Version Values Default None Client Server Value Specifications Valid CPU number Extended Open Target Alter Yes This specifies the number of the CPU to be used as a backup CPU for the Consumer process (i.e.,i.e., the Consumer runs as a persistent process). The CPU value entered must exist on the system.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions assigned via an ADD CONS command, to which this extended Consumer is attached. This is a required parameter for an extended Consumer. It has no meaning for a basic Consumer. Note: Basic and extended Consumer support was added to HP Shadowbase to resolve the Guardian O/S’s limit of 100 simultaneous transactions per process (the “TFILE” limit).
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions The CHECKTARGETS log file will also identify disk volumes that are down or inaccessible as found during the Consumer startup, if set to ON. COLLNAME coll_name Initial Version 1.000 Changed Version Values Default None Client Server Value Specifications Valid COLL OBJECT Name Extended Open Target Alter No Is the name of the Collector to which this Consumer is attached. This is a required parameter.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions Set this parameter to the same “name” value for all CONS objects you want to belong to the same group. The value specified must be from 1 to 16 alphanumeric or hyphen characters and must start with a letter. This parameter can be altered at any time. CONTROLFILE Initial Version 4.060 Changed Version Values Default 4.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions CONTROLFILEEXT Initial Version 4.060 Changed Version Values Default 16,64,128 Client Server Value Specifications 2,2,16 - 65535,65535,959 Extended Open Target Alter No This parameter defines the extent size that will be used by AUDMON to create a CONS CONTROLFILE. The default extent size is (16,64,128).
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions CPU cpu_number Initial Version 1.000 Changed Version Values Default None Client Server Value Specifications Valid CPU number Extended Open Target Alter Yes Specifies the processor where the Consumer runs. This is a required parameter. Note: That the CPU can be altered at any time. If altered, the new value will be used in the event a restart is performed. DEBUG Initial Version 2.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions ENTSEQCHKPTFILE Initial Version 5.002 Changed Version Values Default Not defined Value Specification Valid Guardian filename Alter No ENTSEQCHKPTFILE is optionally used for ENTRYSEQEXACT replication. When specified, it causes a CONS to checkpoint event audit position information for the last event processed for replication (when it flushes a block to disk).
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions This specifies the maximum number of failures of a Consumer allowable within the FAILSPAN period. If the AUD parameter AUTORESTART is set to ON and FAILMAX is set to 0, the restart attempts will continue indefinitely. Otherwise, AUDMON will attempt to restart FAILMAX number of times within the FAILSPAN. Valid values are 0 through 128. A value of 1 disables the restart capability.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions This parameter is used to enable the faster Consumer process startup method for auto restarts. When ON and whenever the CONS is started due to an auto restart, it will use the faster method of startup introduced with the CONS FASTSTART parameter. This takes precedence over the CONS FASTSTART parameter and the DBS DOIFNOAUDATSTART, DOIFNOSRCATSTART, and DOIFNOTRGATSTART parameters for auto restart of the CONS by AUDMON.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions closing the file and removing it from its internal “fetch source” tracking list. Note that the CONS will only evaluate this approximately every five minutes. Should a source file show up again in a subsequent event, the CONS will reopen the source and add it back to its list. Setting FETCHSRCCLNUPTM to 0 disables the cleanup. FETCHSRCMAXSTMT {number} Initial Version 5.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions This parameter is used to define the message level (how much detail) that will be used for error conditions for file maintenance operations for Enscribe target files. The default is 0 and the valid range is 0 to 2. It can be altered while the Consumer is running. All file related errors will be logged at message levels 0, 1 and 2. Level 1 is reserved for future use.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions This parameter is used to enable the FUPSERVER CONS to log the commands and responses of the FUP processes used to execute the replicated commands on the target system. There is no default value. FUPPRI Initial Version 4.092 number Changed Version Values Default Minimum -1 (CONS pri) 1 Client Server Extended Maximum 199 Open Target Alter No This parameter is not yet implemented and will be available in a future release.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions Initial Version 4.092 Changed Version Values Default OFF Client Server Minimum OFF Extended Maximum ON Open Target Alter No This parameter is not yet implemented and will be available in a future release. This parameter is used to enable the CONS to process FUP commands generated by a special customized NonStop FUP program feeding HP Shadowbase as a FEP process (“front end”). Set FUPSERVER to ON to enable FUP replication.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions require exclusive access to the file and table objects being manipulated by FUP). The number of FUP processes running is determined by the number of simultaneous source system FUP sessions – each session on the source system results in a process on the target system. IGNOREERROR Initial Version 2.000 ( NonStop_error_number [ , NonStop_error_number ] ...
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions The IOTRACE parameter can be altered while the Consumer is running. Regardless of the IOTRACE setting, unless replicating to Oracle using the OCI server, statements are always outputted as text (hexadecimal is not output). IOTRACEFILE filename Initial Version 3.962 Changed Version Values Default Value Specifications None Valid File Name Include NODE Client Server Extended Open Target Alter Yes Enter a valid HP NonStop file name.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions Where is one or more of the alphabetic characters A (for all operations), S (for SQL operations), E (for Enscribe operations), and T (for transaction commit and abort operations). For example: SET CONS IOTRACEFILTER A Means trace all operations. SET CONS IOTRACEFILTER ST Means to trace SQL operations as well as the commit and abort operations.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions When TURBOMODE is OFF and IPMBLOCKING is ON, the Collector will block when it has time (waiting on CONS messages to complete). LATENCYCLOCKADJ hundredths Initial Version 2.603 Changed Version Values Default 0 Client Server Minimum -2147483647 Extended Maximum 2147483647 Open Target Alter Yes Defines a + or - differential to be used for calculating latency when the source and target system clocks are not synchronized.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions LIKE cons_name Initial Version 2.000 Changed Version Values Default None Client Server Value Specifications Consumer Name Extended Open Target Alter No This sets the Consumer parameter values to those of the existing Consumer indicated by cons_name. MAXDBSSPEC Initial Version 1.000 number Changed Version Values Default 3.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions Initial Version 1.101 Changed Version Values Default 30000 Client Server Minimum 128 Extended Maximum 30000 Open Target Alter No This specifies the maximum TCP/IP send buffer size from the HP Shadowbase Consumer to the HP Shadowbase Other Servers. The send buffer size includes the STP information attached to the message as well as the change data. If a given statement is larger than MAXSEND, it sends several smaller messages.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions This is the network IP address (e.g., 34.35.0.132) or DNS name of the backup server. In combination with the NETBACKUPPORT value, below, it identifies a specific TCP/IP socket that receives the data. If a DNS name is used, and the DNS entry has multiple IP addresses associated with it, a message is output to EMS and the first address returned is used. NETBACKUPPORT portnumber Initial Version 3.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions asynchronous communication and the Consumer will continue to send messages to the target process up to the NETBUFFERS value even if acknowledgements are outstanding. If you set NETBUFFERS greater than 1, it is recommended that you set the Collector parameter, MAXCONSWRITES, to a similar value. When replicating over TCP/IP to a cached target, it is recommended that NETBUFFERS be set to 2x MAXCONSWRITES.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions Version 3.910 Version Values Default OFF Client Server Minimum OFF Extended Maximum ON Open Target Alter No Enables or disables encryption. Valid values are ON or OFF. Any combination of NETCOMPRESS and NETENCRYPT can be used. For performance reasons, it is recommended that if NETENCRYPT is ON that NETCOMPRESS be set ON also. The Consumer compresses the message content first and then encrypts the compressed content.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions object is configured to set the NETBACKUPPROCESS, NETBACKUPADDRESS, and NETBACKUPPORT parameters. Once a listen has been posted, an STP server will wait for a connection for NETLISTENTIMEOUT period of time and then re-cycle the “listen” on that path (i.e.,i.e., it will tear down the current socket(s) and re-establish another listen to the primary and/or backup path if defined).
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions maximum value is 65535. The NETADDRESS/NETPORT combination must be unique for each Consumer. It must match the NETWORK PORT parameter entered in the HP Shadowbase Other Servers configuration. NETPROCESS Initial Version 1.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions Client Server Extended Open Target The default behavior is for the NonStop Consumer to start and issue the connect to the target HP Shadowbase Other Servers when NETSWAPCONNECT OFF. Set NETSWAPCONNECT ON (and a corresponding non-zero value in the target HP Shadowbase Other Servers shadparm.ini file for parameter SHAD_NETSWAP_CONNECT) in order for the CONS to start and wait for a connect request from the Open Target.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions connection process between two Consumers when operating in a HP NonStop-to-NonStop over TCP/IP mode as well as for a “standalone” Consumer used for an Open-to-NonStop replication environment. NETUSERNAME can be up to 31 bytes long and contain any alphanumeric string character except semicolon (;). NETUSERPASSWORD Initial Version 3.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions For more information on this subject, see the setsockopt usage related to SO_SNDBUF and SO_RCVBUF in the NonStop TCP/IP and IPX/SPX Programming Manual. NOEXPAND {ON} {OFF} Initial Version 4.092 Changed Version Values Default OFF Client Server Minimum OFF Extended Maximum ON Open Target Alter NO This parameter is used to enable or disable Consumer features which require expand access.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions OVFLQFILEEXTENT Initial Version 3.950 (, , ) Changed Version Values Default Minimum (1000, 1000, 500) (2, 2, 16) Client Server Extended Maximum Alter (65545,65535,959) Yes Open Target The OVFLQFILEEXTENT parameter defines the extent size to be used for creation of the OVFLQFILE and OVFLQFILEINDEX.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions Is the priority at which the Consumer runs. The number can be from 1 to 199. If omitted, the default is a priority of 10 less than the priority of AUDMON. PROCESS Initial Version 1.000 [ \systemname. ] $cons_name Changed Version Values Default Value Specifications None Valid process name (include NODE) Client Server Extended Open Target Alter No This required parameter is the process name of the Consumer on start-up.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions adjustment (positive or negative) will be added to each of the pulse timestamps the Consumer is responsible for setting. When PULSEAUTOADJ is enabled this parameter is configured automatically. The value for the PULSECLOCKADJ parameter is specified in microseconds (i.e.,i.e., 1/1,000,000th second intervals). The default value is 0, meaning no time adjustments are made. The valid range is -2147483647 to 2147483647, i.e.,i.e.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions When a pulse is acknowledged (i.e., AUDMON receives a pulse acknowledgment message), if the difference between the target I/O completion time and the time the pulse was created/inserted into the source pulse file is greater than PULSEMAXREPSONSE, AUDMON will output an EMS message to identify that the pulse is “out of band” (i.e.,i.e., replication latency is not within PULSEMAXRESPONSE).
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions have purged a Collector’s RESTART file. For this reason, you may want to start HP Shadowbase with the pulse feature disabled (i.e.,i.e., PULSERATE 0) and then alter the Consumer to enable them after successful startup. When enabled (i.e.,i.e., PULSERATE is > 0), the first pulse is not sent until the PULSERATE interval expires.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions This parameter was added for situations when the clocks differ (i.e., have drifted) between a Consumer client and its Consumer server running on another HP NonStop node, or when the clocks differ (i.e.,i.e., have drifted) between a source Consumer and an HP Shadowbase Other Servers, PULSESVRCLOCKADJ can be used to adjust the server timestamps recorded by the client Consumer process for its server.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions PULSEWAITREPEATS Initial Version 3.990 Changed Version Values Default 0 Client Server Minimum 0 Extended Maximum 16 Open Target Alter Yes This parameter is the number of PULSEWAIT iterations permitted before AUDMON forgets about tracking a particular pulse. Even though the pulse has timed out, it does not prevent the pulse from completing when (and if) the acknowledgement comes back later.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions QMGRNAME Initial Version 4.090 Name qmgr_name Changed Version Values Default Value Specifications Alter None(disabled) Valid QMGR OBJECT No Client Server Extended Open Target Is the name of the Queue Manager to which this Consumer is attached. If this is not specified (which is the default), the Queue Manager facility will not be used for this Consumer. REJECTFILE Initial Version 3.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions This parameter defines the extent size to be used for creation of each REJECTFILE. Where x is between 2 and 65535 to define the number of pages for the primary extent, and y is between 2 and 65535 to define the number of pages for the secondary extent, and z is between 16 and 959 to define the maximum number of extents to be allocated. The default is (1000, 1000, 500). REJECTFILEEXISTS Initial Version 3.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions Note: That it is up to the user exit code to determine what the outcome will be. RESOLVELOCKS { ON } { OFF } Initial Version 3.700 Changed Version Values Default 3.980C OFF Client Server Minimum OFF Extended Maximum ON Open Target Alter No At times Guardian file error 40 (timeout) and error 73 (record/row locked) can occur in a Consumer, for example when the DBS CONTROLTABLELOCK parameter is set ON.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions be set on the client side Consumer, when they are enabled on the server side Consumer. RESOLVELOCKSQ {ON} {OFF} Initial Version 3.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions RESOLVELOCKSQMAX specifies the number of events to store in memory. The default is 1000000. The valid range is 0 through 2,147,483,647, although this maximum far exceeds the maximum flat segment size allowed today. Note: A value of 0 for RESOLVELOCKSQMAX will result in the overflow disk queue file being engaged immediately. RESOLVELOCKSQMEM Initial Version 3.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions Notes: Effective with release v3.970, the CONS RESOLVELOCKS and RESOLVETRANS parameters can now be set to OFF for unstructured Enscribe files. User errors 1338 and 1340 are obsolete. See HP NonStop Shadowbase Messages Manual for more information about the error message. A Consumer object TIDFILE must be configured if RESOLVELOCKS or RESOLVETRANS is set to ON.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions repeatable before adding the Consumer. Entering -1 will clear any previously set values. See the HP NonStop Shadowbase Operations Manual for list of default retryable error numbers. SBCMDFILENAME fully e Initial Version 3.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions master/slave bi-directional replication environment. The default for SBCMDKREPLOG is OFF. SBCMDLOADLOG { ON } { OFF } Initial Version 3.963 Changed Version Values Default OFF Client Server Minimum OFF Extended Maximum ON Open Target Alter No The CONS SBCMDLOADLOG is used to enable special logic associated with LOADER events in the master/slave bi-directional replication environment. The default for SBCMDLOADLOG is OFF.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions This defines the maximum message size used to transmit load data for all SOLV processes that may attach to the related CONS object. The default is 29964 bytes (30k minus a small HP Shadowbase header). The minimum value is 5000 and the maximum is 29964. This value will be passed to the SOLV process when it attaches to a Consumer process and will be used as its maximum message size.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions set to its default. Otherwise, you will need to shut down to configure the parameters since SOLVMKRFILEPRE can’t be altered at this time once the CONS has been started. Note that SOLVMAXSESSIONS can’t be altered once the Consumer has been initialized for SOLV processing. SOLVMAXWRITES Initial Version 4.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions appends the character “A” (for active audited), “U” (for active unaudited), and “H” (for history) to the end of the files it creates. Note that the \system.$volume.subvolume will be resolved from the HP Shadowbase CMDVOL assignment if not specified. However, it is recommended that you fully qualify the filename to avoid any confusion. When not set explicitly, SOLVMKRFILEPRE defaults to the CMDVOL subvolume and the file name “SOLVMKR”.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions The SOLVMKRHSTEXTENT parameter can’t be altered once the Consumer has been initialized for SOLV processing (i.e.,i.e., when SOLVMAXSESSIONS is greater than 0 and a “marker file” is defined with SOLVMKRFILEPRE). SOLVMKRRETENTION Initial Version 4.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions Initial Version 1.00 Changed Version Values Default 3.963 ON Client Server Minimum OFF Extended Maximum ON Open Target Alter No This specifies whether resource usage and system performance statistics are to be gathered. The parameter is used in conjunction with the STATS command that displays the statistics. The default is ON. STOPERROR Initial Version 2.000 ( NonStop_error_number [ , NonStop_error_number ] ...
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions ORACLE: Use the ORACLE TARGETTYPE when replicating to an Open DOC (sbocons) in Oracle format, a nonstatement caching Oracle Direct Writer (sborapre), or an Open VMS Direct Writer (sboracle). SQL92: Use the SQL92 TARGETTYPE when replicating to a statement caching Direct Writer (sboracle, sbsybase) or a DB2 Direct Writer (sbdb2400sc or sbdb2400pe).
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions existing TIDFILE to prevent the replay of transactions that have already been processed by a consumer. See the CONS TRACKTXFILE description for additional information. Notes: Do not use TIDFILE when replicating to an open environment. If you specify a TIDFILE, you must specify a TIDFILEINDEX. If a TIDFILE is used, TIDFILECONSTANT must be set to ON for configurations that use extended Consumer objects.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions TIDFILEEXTENT can be used to specify the extent definition to be used for the TIDFILE and TIDFILEINDEX creation. The following values are accepted for x, y, and z. x: Set x between 2 and 65535 to define the number of pages for the primary extent. y: Set y between 2 and 65535 to define the number of pages for the secondary extent. z: Set z between 16 and 959 to define the maximum number of extents to be allocated.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions WARNING: The TIDFILEPURGE parameter is no longer relevant and its value is disregarded by HP Shadowbase, as of Version 3.940. HP Shadowbase will not purge a TIDFILE if this parameter is set ON (it is ignored). A TIDFILE and the related index or alternate key file must be purged manually. Note that the AUTORESTART capability requires that this feature be disabled.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions Version 2.000 Version Values Default Value Specifications None Valid file name Include NODE Client Server Extended Open Target Alter Yes When tracing is enabled, this identifies the file name where the results are to be output. The filename can be fully qualified with volume and subvolume names. The file can be an edit-type disk file, spooler file or the home terminal.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions Initial Version 4.091 Changed Version Values Default ON Client Server Value Specifications ON,OFF Extended Open Target Alter No This parameter controls whether or not the TRACKTXFILE specified is to be audited or not. As of version 5.000, the TRACKTXFILE must be audited, so this parameter must be set to ON. TRANSLOG filename Initial Version 2.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions has generally been replaced by the use of the RESOLVETRANS parameter. Extended Consumers should not be used unless directed by HP Shadowbase Support. Specifies whether Consumer is a basic or an extended type. BASIC Consumers are the main Consumer processes for which DBS Specifications are added (see Section 0 - Database Specification Command Descriptions for more information).
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions can further reduce the Consumer CPU utilization by disabling this automatic processing. This parameter was added to eliminate the up-shifting and hyphen replacement logic associated with user exit processing. Note that you should not disable this unless your user exit is coded correctly (i.e., all column names are upper case with underscore characters).
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions Note: The Consumer parameter USERTRACE and the Database Specification parameter USERTRACE must also be set in order to enable the user exit tracing facility. Note: This parameter is obsolete as of version 4.040C. The CONS parameter IOTRACE and IOTRACEFILE now handles user exit tracing; that is, it is advisable to set IOTRACE and USERTRACE at the same time. See the CONS parameters IOTRACE and IOTRACEFILE for more information.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions SHOW CONS Command The SHOW CONS command displays the current values set for the Consumer attributes. The syntax is: SHOW [ / OUT list_file / ] CONS OUT list_file This directs listing the output to a named file. If this option is omitted, listing output is directed to the AUDCOM list file; this is typically the home terminal.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions IGNOREERROR ( ? ) IOTRACE OFF IOTRACEFILE ? IOTRACEFILEEXT ( 16, 64, 160 ) IOTRACEFILTER ? IPMBLOCKING ON LATENCYCLOCKADJ 0 LATENCYTHRESHOLD 0 LATENCYWARNRATE 0 MAXFILEOPENS 16 MAXRETRIES 3 MAXSEND 30000 MEASURE OFF NETADDRESS ? NETBACKUPADDRESS ? NETBACKUPPORT ? NETBACKUPPROCESS $ZTC0 NETBUFFERS 2 NETCOMPRESS OFF NETCONNTIMEOUT 180 NETENCRYPT OFF NETERRORSPAN 900 NETLISTENTIMEOUT 0 NETMAXERRORS 1 NETPORT ? NETPROCESS $ZTC0 NETRETRYDELA
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions RETRYERROR ( ? ) SBCMDFILEEXTENT ( 100, 1000, 500 ) SBCMDFILENAME ? SBCMDKREPCONF ? SBCMDKREPLOG OFF SBCMDLOADLOG OFF SCHEMAPERCENT 100 SOLVHSTRETENTION ? SOLVMAXIPCLENGTH 29964 SOLVMAXIPCS 250 SOLVMAXSESSIONS 5 SOLVMAXWRITES 15 SOLVMKREXTENT ( 16, 64, 160 ) SOLVMKRFILEPRE \H2.$QA2.LGNSKTCP.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions START [ CONS ] [.]{cons_name } { * } audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment will be used. cons_name Is the name of the Consumer to be started. * This indicates to start all Consumers.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions OUT list_file This directs listing output to a named file. If this option is omitted, listing output is directed to the AUDCOM list file; this is typically the home terminal. audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment will be used. cons_name Is the name of the Consumer.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions UPDATES 0 -----------TOTALS 0 SOLV SUMMARY INFO (LOADS): 0 -----------0 0.0 -----0.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions -----------TOTALS 0 SOLV SUMMARY INFO (LOADS): -----------0 -----0.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions CAUGHT UP – Latency is within the latency threshold. These last two states will only appear if the LATENCYTHRESHOLD parameter is set greater than 0. In those cases, it also indicates the time it entered that state. 1. AUDITTRAIL/ARCHIVE PROCESSING SUMMARY – This section shows the sequence number of the audit trail currently being processed (SEQ).
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions shows the number of the corresponding type of audit trail records that have been processed. % USED shows the percentage of the corresponding type of audit trail record that have been processed. NUM USED Notes: The NUM RCVD counters include all insert, update and delete events, including undo events. Undo events are included even if the DBS INSERTS, DBS UPDATES, or DBS DELETES parameters are set to OFF.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions allocated when both SOLV sessions are active. These buffers are retained once they have been allocated (once the load completes, they are returned to the free “pool” and are made available for another loading session). SOLV ACTIVITY INFO – This section shows the currently active SOLV process names and the SOLV session start time. This section is only displayed when a SOLV job is in progress.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions shows the percentage of time that the CONS is waiting on an AWAITIO to complete and a read is posted on $receive (RECV MWAIT time divided by total time in the statistics interval). BYTES RCVD shows the total number of bytes received from the collector. BPS RCVD shows the average number of bytes per second received from the collector. %RECV MWAIT SCHEMA INFO – This section shows information related to the schema.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions quite busy or is inefficient (e.g., too many index levels in the table or index). %I/O shows the percentage of time the CONS has spent executing SQL statements against the target tables (for inserts, updates, and deletes) during this statistics interval. AVG I/O shows the average SQL I/O time computed by dividing the TARG I/O counter into the I/O TIME.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions is the average amount of time the Consumer was waiting on a lock (before SQL returns an error). RETRY WAIT is the total amount of time the Consumer was delaying between I/O retries as a result of the CONS RETRYDELAY parameter setting. %TWAIT is the percentage of the stats duration that the CONS is waiting on locks and delaying before retrying.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions STP MESSAGE INFO (CLIENT) – This section shows information about the messages sent to or received from a server on another system. SENDS shows the total number of messages sent. LAST MESSAGE TIME is the date and time the last message was sent. CUR BUSY is the current number of messages that have been sent to the server and not yet acknowledged.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions available to the CONS for it to be performing other work. If tcp/ip is inefficient, make sure the NETWINDOWSIZE is set as large as it can be. ACKD BYTES shows the number of STP message bytes that have been acknowledged by an STP server process (accepted and “safe stored” by the server). NUM ACKD shows the number of STP messages that have been acknowledged by an STP server process (accepted and “safe stored”).
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions shows the total number of messages received. LAST MESSAGE TIME shows the date and time the last message was received. MIN SIZE shows the size, in bytes, of the smallest message sent. MAX SIZE shows the size of the largest message. AVG SIZE shows the average size of the messages. RECV POSTED shows the amount of time that a recv_nw is posted on the STP TCP/IP socket by the CONS (i.e.,i.e.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions OUT list_file This directs listing output to a named file. If this option is omitted, listing output is directed to the AUDCOM list file; this is typically the home terminal. audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment will be used. cons_name Is the name of the Consumer.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions \S1.$DATA1.MYSUBVOL.TAB2 / \S1.$DATA2.MYSUBVOL.TABT2 (TARG2) SOURCE/TARGET REPORT FILE FOR \S1.$SBCS1 CLOSED AT
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions TMF-TFILE TRACE TRACKTXFILE TRANSLOG STP (CLIENT) CLOSED CLOSED CLOSED CLOSED CONNECTED (P) <-> DOC WRITER SERVER STOP CONS Command The STOP CONS command stops a Consumer. Before stopping a Consumer, you should stop its Collector process.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions suspend a Consumer in order to free up CPU cycles for another process. The syntax is: SUSPEND [ CONS ] [.]{ coll_name } { * } audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment will be used. cons_name Is the logical name of the Consumer to be suspended.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions Is the name of the Consumer. * This indicates to suspendupd all Consumers. To support the SUSPENDUPD command, a control file is necessary to place the trigger event in the audit trail. The CONS CONTROLFILE and CONTROLFILEEXT parameters should be set appropriately. The SYSCALL option accepts either a filename containing TACL commands or a single TACL command within a set of parenthesis ().
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions functionality must be enabled by setting the SBALLOWPASSTHRUOPEN TACL parameter.
HP NonStop Shadowbase Command Definitions Consumer Command Descriptions SWITCHNET CONS Command The SWITCHNET CONS command enables the user to switch between primary and backup TCP/IP paths declared with CONS parameters NETBACKUPADDRESS and NETBACKUPPORT. The Consumers and Collectors affected by this command are stopped and restarted. The syntax is: SWITCHNET [CONS] [.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions Database Specification Command Descriptions Database specification (DBS) commands define the source table(s)/file(s) and associated target table(s)/file(s) that are to be evaluated and processed by the HP Shadowbase system. Commands are available to add and delete specifications, set and modify attributes, and display information.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions ALTER [ DBS ] [.] { , dbs_parameter } [ , dbs_parameter ]... audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment will be used. dbs_name Is the logical name of a previously defined database specification.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions The CHECK DBS command is used to initiate the “check targets” verification processing for DBS objects by an AUDMON and the related CONS objects. The command can be run at any time. However, this feature is primarily intended to be used prior to the deployment of a new HP Shadowbase configuration. Depending on the number of disks and files involved, the overhead associated with “check targets” is greater than in the pre-4.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions BRIEF – By default, there are two sections of reporting. The detailed part will show the source/target file list and any potential issues associated with the mapping between them. At the end, there is a summary list which shows different categories of issues and other count information about files selected and found, etc. The BRIEF option will only show the summary lines.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions The following are several “check targets” report examples. Take note that there is information pertaining to the command that was used to generate the report. Example 1 – A CHECK DBS *, VERIFYSCHEMA command was used. There were no discrepancies found. Take notice of the detail and summary sections.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions Example 3 – A CHECK DBS *, VERIFYSCHEMA command was used. A number of discrepancies are reported. Take note of the *’s used to highlight the items needing special attention. Also note the item reporting that a DBS object was not captured.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions DELETE DBS Command The DELETE DBS command removes a database specification from the HP Shadowbase system. In order to DELETE a DBS you must first stop the Consumer and RELEASE the DBS. The syntax is: DELETE [ DBS ] [.] audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions COLLNAME – The COLLNAME option allows for displaying only statistics for DBSs of CONS fed from the specified COLL. MATRIX – If the MATRIX option is specified, the statistics are output in the more detailed matrix format used by the STATS AUD, DETAIL and ESTATS AUD commands for the CONS FILE STATS and CONS DBS STATS sections. By default, the new simpler format is used.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions DBS STATS is the section of statistics displayed for each DBS. FILE STATS is the section of statistics displayed on a file by file basis. The following is an explanation of the columns and rows in the ESTATS DBS output (as long as the MATRIX option is not specified, see the documentation of the STATS AUD, DETAIL command for information on that output style): EVENT TYPE is the type of event listed for that row.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions This directs listing output to a named file. If this option is omitted, listing output is directed to the AUDCOM list file; this is typically the home terminal. audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment is used.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions FIXUPDECIMAL ABEND HADWLOGEVENTS OFF HADWLOGREJECT OFF HADWLOGSAME OFF HADWSKIPSAME OFF IGNOREDDLERROR ( ? ) IGNOREERROR ( ? ) INCLUDESBDATA OFF INSERTNOTFOUND OFF INSERTS ON KEEPLONGERRECORD OFF KEEPOPEN OFF KEYSPECIFIER ? LOGREJECTIGNORE OFF LOGREJECTSTOP OFF MAPFROMSOURCE OFF MAPTOFILE \S1.$DATA.ENS.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions OBEYFORM DBS Command The OBEYFORM DBS command displays the parameter values in the SET command format for the DBS object. The syntax is: OBEYFORM [/OUT/] [DBS] {CONSNAME [.]} { [.] } } listfile Is the name of a file to receive the output. listfile can be an edit file that can subsequently be edited for use.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions SET DBS DOIFNOSRCATRUN WARN1ST SET DBS DOIFNOSRCATSTART CONTINUE SET DBS DOIFNOTRGATRUN WARN1ST SET DBS DOIFNOTRGATSTART CONTINUE SET DBS DTSEPARATORVAL " " SET DBS DTSOURCEFORMAT OFF SET DBS ENTRYSEQEXACT (OFF) SET DBS EXTENDINSERT OFF SET DBS EXTENDUPDATE OFF SET DBS FETCHSOURCE OFF [SET DBS FILEDDLDELAY ?] SET DBS FILEDDLRETRIES 3 SET DBS FIXUPDECIMAL ABEND SET DBS HADWLOGEVENTS OFF SET DBS HADWLOGREJECT OFF SET DBS HAD
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions [SET [SET [SET [SET SET SET [SET SET SET SET SET SET SET SET SET SET ADD DBS DBS DBS DBS DBS DBS DBS DBS DBS DBS DBS DBS DBS DBS DBS DBS DBS STOPDDLERROR ( ? )] STOPERROR ( ? )] TARGETCAT ?] TARGETDICT ?] TARGETFILE ? TARGETFILEEXTENT ( 100, 100, 160 ) TARGETREC ?] TRACKTX ON UPDATEDUPLICATE ON UPDATES ON USEREXITID 0 USEREXITPREREAD OFF USEREXITPREREADI OFF USERGETSINORDER OFF USERTRACE OFF VERIFYSCHEMA ON DBS-01 RELEA
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions RESET [ DBS ] [ dbs_parameter [ , dbs_parameter ] ... ] dbs_parameter options can be found if the SET DBS section. If dbs_parameter is omitted, values for all parameters are reset. SET DBS Command The SET DBS command establishes values for the attributes of a database specification. In each description, there is a version box. This box contains information, as in the samples below. Initial Version 3.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions Version 3.960 Version Values Default OFF Minimum OFF Maximum ON Alter No The parameter ABENDONMISMATCH was added to perform a series of checks and tests for those sites that are performing like-to-like replication (e.g., a disaster recovery scenario). The default value is OFF. This parameter can be used when AUDITCOMPRESS is on for the source file or table.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions Initial Version 3.950 Changed Version Values Default OFF Minimum OFF Maximum ON Alter No The ACTIVETARGET parameter is used for "live-live" bi-directional replication environments only. Valid settings for ACTIVETARGET are ON and OFF. The default is OFF.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions Special processing is likely in order to replicate Enscribe QUQUE files. By default, the Consumer will abend if it receives an event associated with a queuefile. ALLOWQUEUEFILE can be set to ON to allow the Consumer to process the event. If you need to process a queuefile, special user exit logic may be (and often is) required.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions need to be configured on the other node to pick up and replicate the distributed partitions. Note: If you plan to utilize the SOLV loader for a related DBS object that has ALLPARTITIONS set ON, you should set the SOLV TARGETFNAME parameter to the subvol of the primary partition of the DBS SOURCEFILE value.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions specifying NODDLCOORDINATION, the Consumers will not be “drained”. The ALTER event will be sent to the related Consumer in the same manner as insert, update, and delete events. Note that the coordination is controlled by the related Collector process. It “drains” all of its Consumers before sending a DDL event. ALTERS Initial Version 5.001 {ON} {OFF} {(ON [, alter-option]...
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions will use filegetinfolist() calls to access certain source and target file/table attributes). This means that an Expand connection must exist from the target node to the source node for HP Shadowbase’s target Consumer to retrieve the source file’s or table’s attributes (if it does not, HP Shadowbase will not replicate FUP and SQL/MP ALTER operations).
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions information when using this handler. Note that the Consumer settings for RETRYDELAY is used to timeout file IO opeations.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions UPDATEs to all other records in the source (i.e., updates to any other record than the first record in the file) are applied to the target using the alternate key specifier provided in DBS parameter KEYSPECIFIER. The alternate key indicated by KEYSPECIFIER does not have to be unique. The UPDATE will only be applied to the first occurrence of an alternate key match along the specified path.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions first record read that matches both the length of the target record and the contents of the before image (if DBS BEFOREVALUES is ON) will be updated. All other records will be ignored. If DBS BEFOREVALUES is disabled, only the record lengths are checked. If no records are found along the alternate key path that matches the criteria, a message is logged (depending on the level of messages).
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions 2.000 OFF OFF ON No Determines whether Collector sends before images to the Consumer (when value set to ON) or not (value set to OFF). Default value is OFF. The value of this parameter set to ON may be needed by some user exit routines. See the HP Shadowbase Programming Manual for more details about user exits. COLLISIONHANDLER Initial Version 2.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions See the CONTROL TABLE statement in the NonStop SQL manual for all possible control statement options. SET DBS CONTROLTABLEEXT () Note: This parameter should not be used to specify the tablelock clause, as it is already handled based upon the setting of the CONTROLTABLELOCK parameter. CONTROLTABLEEXT Initial Version 4.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions When set to OFF (the default), the CONTROLTABLELOCK DBS object parameter will prevent row locks from being escalated to a table lock on SQL targets. When set to ON, SQL may escalate locked rows to a table lock at it's discretion.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions same volume as the target file/table. The table below shows some examples of the mapping. Source File Source AltFile Target File Target AltFile w/ Mapping Target AltFile w/o Mapping $vol.data. file $vol.data. file1 $vol.data.file $vol.data.file1 $vol.data.file1 $vol.data.file $vol.data.file $vol.data.file1 $vol.data.file1 $vol.tgt.file1 $vol1.data.file1 $vol.data.file1 $vol.data.file1 $vol.data.file $vol.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions ALTFILEMAPPING – The target alternate key files or indexes are created using the mapping algorithm described above. This is the default if no altkey file/index mapping options are specified. NOALTFILEMAPPING – The target alternate key files or indexes are created with the exact same name as the source alternate key files or indexes on the target node.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions DELETES Initial Version 2.000 { ON } { OFF } Changed Version Values Default ON Minimum OFF Maximum ON Alter No This indicates whether the source database deletes are to be applied to the target. The default is ON. Note: When the DELETES parameter is set to OFF, deletes are not applied to the target, but insert undo events are applied. DELUIDXDUP Initial Version 3.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions source and the target databases would continue to diverge (not synchronize).
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions {WARN} Initial Version 4.091 Changed Version 4.092 Values Default CONTINUE Value Specification Valid Action Alter No This parameter is used to enable startup-time checking in the CONS to ensure that the source files/tables for the DBS are audited. When set to CONTINUE, the CONS does not perform this check. When set to STOP or WARN, the CONS will perform the check and report the condition to EMS.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions This parameter is used to enable startup-time checking in the CONS to ensure that the target files/tables exist for the DBS. When set to CONTINUE, the CONS will not perform this check. When set to STOP or WARN, the CONS performs the check and report the condition to EMS. If STOP is set and the CONS does not find any target files/tables, it also returns a user error and does not start.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions CONS CHECKFORMISSING parameter is set to ON. When DOIFNOTRGATRUN is set to CONTINUE, the CONS does not perform this check for the DBS associated with the current audit trail event. When set to STOP, WARN, or WARN1ST the CONS does perform the check and report the condition to EMS. WARN causes the CONS to report the condition for every event.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions STOPONMISSING] Initial Version 5.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions NOSTOPONMISSING or STOPONMISSING – If the CONS detects that blocks (records) are missing from a target during replication, STOPONMISSING will result in the CONS abending with an appropriate EMS message to indicated the condition. It will not abend if NOSTOPONMISSING is configured. BUFFERED or WRITETHRUCACHE – WRITETHRUCACHE causes the CONS to set this mode of I/O for the file in the file system.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions CONS for this mode of entry-sequenced file replication is not under TMF transaction control (unaudited). EXTENDINSERT Initial Version 3.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions EXTENDUPDATE { OFF } Initial Version 3.980B Changed Version Values Default OFF Minimum 0 Maximum 255 Alter No The Consumer can now be configured to pad an Enscribe TARGETFILE record in the event an update audit trail event record length is shorter than the target record length as defined when the file was created (i.e.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions FETCHSOURCE options: SHORTRECWARN SHORTRECNOWARN (default) or one of the following short record behavior options: Initial Version 5.001 {ON} {OFF} { ( ON [, fetchsource-option] ...
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions Further image usage options include ALWAYSUSEAUDIT, (default) uses the data value found in audit. Optionally, the user may specify ALWAYSUSESOURCE and have the value retrieved from the source record or row applied to the target. In either case, the final image of the target after replication has caught up will always be identical to the source. As of 5.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions This determines the data format generated by the HP Shadowbase Consumer for transmission. Each option for FIXUPDECIMAL is described below: ABEND The Consumer will abend with an appropriate EMS message reported. SETSQLNULL The Consumer will send a NULL. SETUNCHANGED The Consumer will send the raw data value. Note that this could cause the HP Shadowbase Other Servers to fail due to incorrect data.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions FILEDDLRETRIES = 0: No retries. FILEDDLRETRIES > 0: The number of times to retry the operation after the initial failure. The default value is -1: use the value set for the CONS. Note that this parameter can’t be altered at this time. HADWLOGEVENTS Initial Version 3.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions Initial Version 3.964 Changed Version Values Default OFF Minimum OFF Maximum ON Alter No Determines whether an incoming event is applied against the target database when the target event matches the incoming event exactly (e.g., if an SQL UPDATE arrives that sets the row’s columns to the same values as are already in the target row, the UPDATE is discarded if the target row already matches the incoming values).
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions that -1 means undefined: the DBS specific list of errors to be ignored is reset. Also, note that this parameter can’t be altered at this time. Notes: 1) HP Shadowbase has built in error processing which causes a number of errors to be ignored or retried as documented in the HP NonStop Shadowbase Operations Manual. This list modifies the list of ignored errors, it does not replace it.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions Notes: The PURGEIFEXISTS parameter overrides the IGNOREDDLERROR parameter for error 10. If PURGEIFEXISTS is ON and an error 10 is encountered while trying to create a file, the existing file will be purged regardless of the setting of IGNOREDDLERROR. If you want to keep the existing file when a file create is replicated, you must turn PURGEIFEXISTS off and include error 10 on the IGNOREDDLERROR list.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions KEEPLONGERRECORD { ON } { OFF } Initial Version 3.961 Changed Version Values Default OFF Minimum OFF Maximum ON Alter No This parameter has been added for like-to-like Enscribe replication.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions Initial Version 4.070 Changed Version Values Default OFF Minimum OFF Maximum ON Alter No This parameter is used to indicate if an ignored error condition, detected as a part of the extended error handling, is to be logged to the Reject File. To log errors to the reject file, set the parameter to ON. The default value is OFF. Note that this parameter can’t be altered at this time. MAPFROMSOURCE Initial Version 3.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions This parameter indicates the name of a dummy file or table to be used for mapping schema/DDL Records from all of the sourcefile partitions, even when the partitions do not exist at the start of replication. The Dummy_fname must exist at start, and must be of identical schema/DDL Record representation as SOURCEFILE. MAPTOTEMPLATE Initial Version 4.070 Changed Version 5.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions MXPARTNAMES ( partition-ansiname [,partition-ansiname] ... ) Initial Version 5.000 Changed Version Values Default None Value Specifications partition-ansiname, .. Alter No Specifies a list of one or more partitions of a SQL/MX table to be included or excluded. If not specified, all partitions are selected for inclusion or exclusion when an MXSOURCETABLE is specified for a DBS object.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions where the numeric field is delimited by “” characters. MXTARGETTABLE fully-qualified-table-ansiname Initial Version 5.000 Changed Version Values Default None Value Specifications fully-qual-table-ansiname Alter No This parameter specifies the fully qualified ansiname of the destination SQL/MX table. Fully qualified table names include the catalog, schema, and table.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions This optional parameter is used under the following conditions: In a HP NonStop to HP Shadowbase Other Servers environment, PATHNAME contains the target filename for the open system. PATHNAME accommodates filenames that are not typical HP NonStop format. Version 4.092 introduced case-sensitive PATHNAMEs (i.e., “Table_Name”). In an Open to NonStop environment, PATHNAME contains the source table name.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions If MAPFROMSOURCE is ON and there is a PATHNAME with a ^ character, then the tablename will be set to the DBS PATHNAME, replacing the ^ with the original SOURCEFILE (8 byte portion read from the audit trail). If MAPFROMSOURCE is OFF and there is a PATHNAME with a ^ and there is a TARGETFILE, then the tablename will be set to the DBS PATHNAME, replacing the ^ with the TARGETFILE (8 byte portion).
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions replicating to an HP Shadowbase Other Servers. However, like with other open targets, you may need to set the DBS PATHNAME parameter. See the 3.990 open softdoc for more information about configuring a pulse file. The PULSEFILE parameter can’t be altered for the DBS object. PULSEFILEPURGE Initial Version 3.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions processes are “drained” of events first, and then the DDL event is sent to the appropriate Consumer to be processed. After the DDL event has been processed, non-DDL replication can resume. This coordination is necessary so that events are processed synchronously in the correct sequence across multiple Consumer threads.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions When a program purges the contents of a file (e.g., a CONTROL(20) call, or a COBOL OPEN OUTPUT option), or when a command purges the contents of a file or table (e.g., FUP PURGEDATA or SQLCI PURGEDATA), the command may or may not specify a specific partition (e.g.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions order of the events being processed. By specifying NODDLCOORDINATION, the Consumers will not be “drained”. The PURGEDATA event will be sent to the related Consumer in the same manner as insert, update, and delete events. Note that the coordination is controlled by the related Collector process. It “drains” all of its Consumers before sending a DDL event.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions KEEPALTFILES – Existing alternate key files on the target are kept (not purged). This only applies to Enscribe files. PURGEALTFILES – Existing alternate key files for the target file is purged if the target file is a primary partition (or a single partition file).
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions Version 3.943 Version 5.002 Values Default OFF Minimum OFF Maximum ON Alter No This parameter is used to define if Enscribe file and SQL/MP table purge events are to be replicated to the target. By default, this parameter is set to OFF. Set it to ON to enable the feature.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions 2. 3. 4. 5. 6. 7. 8. 9. Call the user exit SBSETDDLALLPTNS API function. For an Enscribe target, alter the audit attribute to off on the target file. Call the user exit SBBEGINDDL API function. Call the user exit SBSUSPENDTRANSACTION API function (sets transaction nil state). Perform your custom DDL related logic. Call the user exit SBRESUMETRANSACTION API function (resumes the SB transaction).
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions This parameter specifies the number of seconds to wait before retrying an SQL or Enscribe I/O following an error identified for retry. If set to -1 (the default), the value specified for the associated CONS object is used. The valid range is -1 to 32767. Note that this parameter can’t be altered at this time. RETRYERROR Initial Version 4.070 Changed Version {error-number[, error-number, ...
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions b. Next, if the error is found in a CONS specific list, the appropriate action for that list is taken. c. Next, if the error is found in one of the default lists, the appropriate action is taken. d. Finally, if the error is not on any list, it is treated as a STOPERROR. 4) Errors 10 (record exists) and 11 (record does not exist) are treated as special cases.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions When ON and there are no other DBS extended error handling definitions, the CONS will behave as if all errors can be retried: the CONS will log an appropriate EMS message and use the DBS RETRYDELAY or FILEDDLDELAY parameter for the delay interval. It will then retry the operation up to DBS MAXRETRIES or FILEDDLRETRIES times. If the operation is ever successful, the CONS will continue with the next event.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions Note: The root partition is required when using the HP audit reading routines to access ENTRY SEQUENCED, RELATIVE, and UNSTRUCTURED Enscribe files events, but NOT for SQL Tables if supplied it is not used (the reason it is not needed for SQL tables is because the file label always includes a link back to the primary partition).
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions not allowed (an underscore will be added automatically between the prefix and the rest of the column name). SCREENTRANS Initial Version 2.700 Changed Version { ON } { OFF } Values Default OFF Minimum OFF Maximum ON Alter No For bi-directional replication when set to ON, indicates that the SOURCEFILE in this DBS is a TRANSLOG file used for ping-pong elimination. The SPECTYPE of this DBS should be set to EXCLUDE.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions Version 4.070 Version Values Default OFF Minimum OFF Maximum ON Alter No This parameter defines what the CONS should do if it is unable to complete an I/O operation. When OFF, the CONS will log an appropriate error message and STOP. When ON, the CONS will log an appropriate error message and continue. Note that this parameter can’t be altered at this time. SKIPFATALDDLERR Initial Version 4.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions For Enscribe source files, this identifies the volume.subvolume containing the data dictionary where record descriptions will be extracted based on the SOURCEREC parameter. If omitted, the volume.subvolume specified with the DICTVOL command will be used. If the DICTVOL command has not been entered, the default volume and subvolume are used. This is required if the SOURCEREC parameter is specified.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions will cause alternate keys to be maintained automatically. Duplicate errors may result if you try to replicate alternate keys. SOURCEFILEEXTENT Initial Version 3.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions 2.000 * Enscribe Files and SQL Tables ENSFIL - Enscribe Files SQLTAB - SQL tables No This defines the source file type as either an Enscribe file or SQL table. Entering * means all Enscribe files and SQL tables in the SOURCEVOL. The default is *. SPECTYPE Initial Version 2.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions Version 4.070 Version Values Default -1 Minimum Maximum Alter No This parameter is related to SQL and Enscribe I/O, the STOPERROR parameter identifies HP NonStop errors that will cause the CONS to stop when detected. An appropriate EMS message will be logged before the CONS stops. In some cases, SQL errors translate to HP NonStop errors that can be specified.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions specified with the DICTVOL command will be used. If the DICTVOL command has not been entered, the default volume and subvolume are used. This is only needed if the TARGETREC parameter is specified. TARGETFILE filename Initial Version 3.900 Values Default Value Specifications None Valid target file name Include NODE Changed Version 4.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions A check was added to the Consumer to make sure that a TARGETFILE is set to the primary partition of an Enscribe file during startup or if a new DBS object is added. Previously, when the TARGETFILE pointed to a secondary partition of a partitioned Enscribe file, the file system returned an error to HP Shadowbase when it tried to apply an I/O directly against the secondary partition. Release v4.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions TRACKTX Initial Version 4.091 { ON } { OFF } Changed Version Values Default ON Minimum OFF Maximum ON Alter No This parameter is used to identify which files/tables will cause the TRACKTXFILE to be updated (if TRACKTXFILE parameter is configured with a valid filename).
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions USEREXITPREREAD { ON } { OFF } Initial Version 3.940 Changed Version Values Default OFF Minimum OFF Maximum ON Alter No Set this to ON to make the target record available to the user exit. When set to ON, HP Shadowbase will read and lock the target record when UPDATES and DELETES are being replicated.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions CONS use the old lookup mechanism, as it may be more efficient than the new binary lookup method. USERTRACE Initial Version 3.930 Changed Version { ON } { OFF } Values Default OFF Minimum OFF Maximum ON Alter No Enables or disables the user exit tracing facility. Set this parameter to ON to enable the user exit tracing facility. Set this parameter to OFF to disable the user exit tracing facility. The default is OFF.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions VIEWNAME specifies the SQL/MP replication view name used to define the target table structure and column mapping from source to target when replicating to Open systems. It is set to the fully-qualified view name.
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions DOIFNOAUDATSTART CONTINUE DOIFNOSRCATRUN WARN1ST DOIFNOSRCATSTART CONTINUE DOIFNOTRGATRUN WARN1ST DOIFNOTRGATSTART CONTINUE DTSEPARATORVAL " " DTSOURCEFORMAT OFF ENTRYSEQEXACT (OFF) EXTENDINSERT OFF EXTENDUPDATE OFF FETCHSOURCE (OFF) FILEDDLDELAY ? FILEDDLRETRIES 3 FIXUPDECIMAL ABEND HADWLOGEVENTS OFF HADWLOGREJECT OFF HADWLOGSAME OFF HADWSKIPSAME OFF IGNOREDDLERROR ( ? ) IGNOREERROR ( ? ) INCLUDESBDATA OFF INSERTNOTFOUND
HP NonStop Shadowbase Command Definitions Database Specification Command Descriptions SOURCETYPE * SPECTYPE INCLUDE STOPDDLERROR ( ? ) STOPERROR ( ? ) TARGETCAT ? TARGETDICT ? TARGETFILE ? TARGETFILEEXTENT ( 100, 100, 160 ) TARGETREC ? TRACKTX ON UPDATEDUPLICATE OFF UPDATES ON USEREXITID 0 USEREXITPREREAD OFF USEREXITPREREADI OFF USERGETSINORDER OFF USERTRACE OFF VERIFYSCHEMA ON VIEWNAME ? HP NonStop Shadowbase Command Reference Manual—785421-002 276
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions Queue Manager Command Descriptions Queue Manager commands are associated with the definition and control of Queue Managers in a HP Shadowbase system. A Queue Manager is an optional component of a HP Shadowbase replication system that buffers and stores messages from the Collector to a Consumer on disk in a First In – First Out (FIFO) queue.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the QMGR will be added to the currently opened audmon process. qmgr_name Is the logical name of the Queue Manager; the name can have from one to 16 alphanumeric or hyphen characters. It must start with a letter and must be unique within the HP Shadowbase system.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions DELETE QMGR Command The DELETE QMGR command removes a Queue Manager from the HP Shadowbase system. A Queue Manager must be stopped before it can be deleted. The syntax is: DELETE [ QMGR ] [.]qmgr_name audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the QMGR will be deleted from the currently opened audmon process.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions When the STOP option is specified while the QMGR is draining its queue, the QMGR and CONS stops draining and shuts down immediately. DUMPTX QMGR Command DUMPTX QMGR can be used to request a listing of transactions being tracked by a QMGR.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions +dumptx qmgr * QMGR DUMPTX TRANSACTION TRACKING DETAIL AT 03/02/2010 12:40:31 : ========================================================================= NAME: QMGR01 PROCESS: \H1.$JHQM1 AUDMON: \H1.$JHMON TRANS BUSY: 2 CUR MAT: AA000680 CONS: CONS01 RBA: 69890336 ------------------------------------------------------------------------TRANS 1 OF 2 ***RESTART POINT TRANSACTION*** ADT TRANSID: \H1(3).0.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions This directs listing the output to a named file. If this option is omitted, listing output is directed to the AUDCOM list file; this is typically the home terminal. audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment will be used.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions QPREALLOCATE OFF QREADAHEAD 4 QSUBVOLUME JHQFILES QVOLUMES ($DATA2,$DATA1) QWRITEQUEDEPTH 2 RESTARTFILE \H1.$JRH.RESTART.AUDQMGR TRACE OFF TRACEFILE \H1.$JRH.LOG.QMTRAC INFOTX QMGR Command INFOTX QMGR can be used to request a listing of a specific transaction that is currently being tracked by a QMGR. The command syntax for the INFOTX command is as follows: INFOTX [ /OUT / ] [ QMGR ] {[.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions EVENT TS: 03/02/2010 12:52:47,348395 DIFF: 00:03:14.882450 RECEIVED TS: 03/02/2010 12:52:49,507857 DIFF: 00:03:12.722988 SENT TS: 03/02/2010 12:52:59,780058 DIFF: 00:03:02.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions SET SET SET SET SET SET SET SET [SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET SET ADD QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR QMGR ABNORMALSHUTDOWN DRAINSTOP BACKUPCPU 0 CHKPTDELAY 500 CHKPTTIME 300 CHKPTWARNRATE 900 CHKPTWARNTDIFF 7200 COLLNAME C
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions qmgr_parameter options can be found if the SET QMGR section. If qmgr_parameter is omitted, values for all parameters are reset. This command is typically issued between groups of SET/ADD QMGR descriptions. The command does not affect any Queue Manager definition already established with an ADD QMGR command. Some parameters are required and have no default values.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions Initial Version 2.000 Changed Version Values Default None Value Specifications Alter Valid MAT full filename No Partial file name up to the AA prefix –1 to reset To know if your version of HP Shadowbase can use the parameter, the first column titled ‘Initial Version’, is for when the parameter was first introduced. The next column is for if and when the parameter was last changed.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions Initial Version 4.090 Changed Version Values Default None Value Specifications Valid CPU number Alter No Specifies the number of the CPU to be used as a backup for the Queue Manager (which means the Queue Manager will run as a persistent process). The CPU for the value entered must exist on the system.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions Initial Version 4.090 Changed Version Values Default None Value Specifications Valid COLL OBJECT Name Alter No Is the name of the Collector to which this Queue Manager is attached. This is a required parameter when a QMGR is configured, and must contain a valid logical (ie add COLL ) COLLector name CPU cpu_number Initial Version 4.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions OFF ONSTART ONERROR the Queue Manager does not enter debug mode. the Queue Manager enters debug mode on start-up. the Queue Manager enters debug mode on an abnormal event. If omitted, the default is OFF. FAILMAX Initial Version 4.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions Is the maximum number of simultaneous interprocess messages I/Os that can be outstanding to a Consumer (using Guardian “nowaited” I/O). This number can be from 1 to 15 (15 is the largest Guardian nowaited I/O depth). The default is 15, which means that up to 15 messages can be sent to the Consumer before receiving a reply.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions This parameter specifies whether buffered I/O is used when writing to the queue files. If set ON, the writes are buffered in the disk cache. If set off, the write-thru-cache option is used to write the data to the disk. Tests have shown that higher throughput is attained using buffered I/O, however, since the QMGR is continuously writing at the end of the file, each write requires new disk cache.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions QSUBVOLUME parameter), the file prefix (this parameter), and a 6 digit number. For example, assume the following settings: QFILESPERVOLUME 2 QFILEPREFIX ZZ QSUBVOLUME QFILES QVOLUMES ($DATA1, $DATA2) The initial queue file names would be: $DATA1.QFILES.ZZ000001 $DATA2.QFILES.ZZ000002 $DATA1.QFILES.ZZ000003 $DATA2.QFILES.ZZ000004 QFILESECURITY security_string Initial Version 4.090 Changed Version 4.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions Initial Version 4.090 Changed Version Values Default 40 Minimum 0 Maximum 32767 Alter No This is the number of messages the Queue Manager can receive from the Collector prior to flushing data to disk and saving the restart file information. If QFLUSHLIMIT is set to 0, message-counted flushing is disabled. Note that there are other events which may cause the data to be flushed to disk and the restart file written.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions The space for the queue files will be pre-allocated if this parameter is on. Otherwise, it will be allocated as the queue fills, and will be deallocated as the queue empties. Setting this parameter to ON guarantees that Queue Manager will not run out of space on the disk while it is running and is recommended for production configurations.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions having the writes impact your application. If the disks cannot be dedicated, consider setting the QBUFFEREDIO parameter to off. QWRITEQUEDEPTH Initial Version 4.090 Changed Version Values Default 3 Minimum 2 Maximum 100 Alter No This is the number of56Kbyte write buffers the process will maintain for writing to the disk.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions Initial Version 4.090 Changed Version Values Default Value Specifications None Valid file name Include NODE Alter No When tracing is enabled, this identifies the file name where the results are to be output. The filename can be fully qualified with volume and subvolume names, however, the file name portion may only be 7 bytes.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions FAILSPAN 900 MAXCONSWRITES 15 MEASURE OFF PRI 133 PROCESS ? PROGRAM \H2.$DATA.SHADOW.AUDQMGR QBUFFEREDIO OFF QFILEEXTENT ( 4000, 4000, 128 ) QFILEPREFIX QF QFILESECURITY UUUU QFILESPERVOLUME 3 QFLUSHDELAY 300 QFLUSHLIMIT 40 QMSGCACHESIZE 500 QPREALLOCATE ON QREADAHEAD 3 QSUBVOLUME ? QVOLUMES ? QWRITEQUEDEPTH 3 RESTARTFILE ? TRACE OFF TRACEFILE ? START QMGR Command The START QMGR command enables execution of a Queue Manager.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions * This indicates to start all Queue Managers. STATS QMGR Command The STATS QMGR command displays resource usage and system performance statistics for a Collector. The syntax is: STATS {[QMGR] {[.]} {[.]* } [,DETAIL] [,RESET] [,INTERVAL {HRS} {MINS} {SECS} ] } OUT list_file This directs listing the output to a named file.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions SHADOWBASE - V5002H06 - (26OCT12) QMGR STATS AT 2010-03-05:13:19:58 (UNDOMODE): NAME: QMGR01 PROCESS: \H1.$JHQM1 SINCE: 2010-03-04:17:41:50 AUDMON: \H1.$JHMON DURATION: 19:38:07.797 LATENCY WARNING STATUS: DISABLED COLL: 03-05 13:19:55.281 LAG (CUR): 00:00:03.364 CONS ETS: 03-05 13:19:55.281 LAG (CUR): 00:00:03.364 CONS LTS: 03-05 13:19:55.281 LAG (CUR): 00:00:03.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions QUEUE SUMMARY NAME: $.JHQFILES.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions shown in the SINCE field of the header, the duration is show in the DURATION field. 1. HEADING: Displays basic information about the process. QMGR STATS AT
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions o o – the average number of events per message. / RECEIVED – the total bytes received from the EVENTS / AVG BYTE TOTALS Collector. BYTE TOTALS / REPLIED – the total bytes sent in response to the Collector. PENDING REPLY shows the number of messages received from the Collector that have not yet been replied to.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions o BYTES REPLIED is the total number of bytes in the replies from the Consumer. NUM WRTRDS is the number of writereads to the Consumer that have completed. o WRTRD TIME is the total time in seconds it took for the writeread operation to complete – the interval between when the writeread was issued and the replied received.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions duration of the measurement period. 6. QUEUE SUMMARY: The queue summary section provides information about the disk queue used by the Queue Manager. The first part of the section provides basic configuration and about the files in the queue; the remaining subsections are discussed further below.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions this is the ADT information for the last event sent to the Consumer. o COLL RESTART: this is the ADT information for the Collector restart point as determined by the Queue Manager.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions 10. QUEUE SUMMARY / SAFESTORE QUEUE I/O INFO: This sub-section contains statistics accumulated over the measure period for I/Os performed against the queue files. The time for an operation is calculated from when the operation is initiated until it completes with in a call to AWAITIOX. The columns for this section are: OPERATION: identifies what is being timed in the row: o WRITE – writes to the queue file.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions from when the SETMODE is called until the operation completes in a call to AWAITIOX. This line only measures the time in the SETMODE call. It will be 0 if write-thru cache is used (QUSEBUFFEREDIO set to OFF). 12. QUEUE SUMMARY / IPC IN-MEMORY QUEUE: This sub-section shows the usage for the in-memory queue.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment will be used. qmgr_name Is the name of the Queue Manager. * This indicates to include all Queue Managers. DETAIL If specified, more detail may be produced. In Version 4.090, the DETAIL option has no effect.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions o RUNNING: The Queue Manager is processing data. o SUSPENDED: The flow of data from the Collector to the Queue Manager has been suspended via a SUSPEND QMGR command. Note that queued data will continue to flow to the Consumer until the queue is drained. o STARTED: The Queue Manager was started via the START command, but has not received the RUN command yet.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions FAILED: the Consumer stopped unexpectedly. IDLE: The Consumer has been added, but has not been started. RUNNING: The Queue Manager is processing data. SUSPENDED: The flow of data from the Queue Manager to the Consumer has been suspended via a SUSPEND CONS command. Note that ADT data will continue to flow to the Queue Manager from the Collector until the queue is completely full.
HP NonStop Shadowbase Command Definitions Queue Manager Command Descriptions Indicates to stop all Queue Managers. ! Indicates to ignore errors, and disregard the CONFIRMSHUTDOWN parameter. Note: The Consumer may abend when the Queue Manager is stopped if there is work in progress (active transactions) at the Consumer.I Note: The Queue Manager will refresh the restart file restart point prior to stopping if this command is issued.
HP NonStop Shadowbase Command Definitions SOLV Manager (File Chaser) Command Descriptions SOLV Manager (File Chaser) Command Descriptions Effective with release of NSB6.100 of HP NonStop Shadowbase, the SOLV Manager is now referenced as the HP Shadowbase File Chaser utility. SOLV Manager commands are associated with the definition and control of SOLV Managers in a HP Shadowbase system.
HP NonStop Shadowbase Command Definitions SOLV Manager (File Chaser) Command Descriptions audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the SOLVMGR will be added to the currently opened audmon process. solvmgr_name Is the logical name of the SOLV Manager; the name can have from one to 16 alphanumeric or hyphen characters. It must start with a letter and must be unique within the HP Shadowbase system.
HP NonStop Shadowbase Command Definitions SOLV Manager (File Chaser) Command Descriptions This directs listing the output to a named file. If this option is omitted, listing output is directed to the AUDCOM list file; this is typically the home terminal. audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment will be used.
HP NonStop Shadowbase Command Definitions SOLV Manager (File Chaser) Command Descriptions SOLVPROGRAM \H2.$GPJ.S5000.SOLV SOLVPURGEDATAONSTART OFF SOLVRECDELAY 0 SOLVRETRYDELAY 30 SOLVTRANSDELAY 0 STARTFILE ? STARTTIME ? STOPFILE ? STOPTIME ? TRACE 0 TRACEFILE ? OBEYFORM SOLVMGR Command The OBEYFORM SOLVMGR command displays the parameter values in the SET command format for the SOLVMGR object. The syntax is: OBEYFORM [/OUT /] { [SOLVMGR] [.
HP NonStop Shadowbase Command Definitions SOLV Manager (File Chaser) Command Descriptions +obeyform solvmgr * [BEGIN OBEYFORM OUTPUT AT 2011-09-01:14:13:16] [SHADOWBASE VERSION INFO - V5000 - (19SEP11)] [SOLVMGR SMGR1 OBJECT SETTINGS (AUDMON \H2.
HP NonStop Shadowbase Command Definitions SOLV Manager (File Chaser) Command Descriptions RESET SOLVMGR Command The RESET SOLVMGR command resets a SOLV Manager parameter from the currently set value to the default value. The syntax is: RESET [ SOLVMGR ] [ solvmgr_parameter [ , solvmgr_parameter ] ] solvmgr_parameter options can be found if the SET SOLVMGR section. If solvmgr_parameter is omitted, values for all parameters are reset.
HP NonStop Shadowbase Command Definitions SOLV Manager (File Chaser) Command Descriptions running. If the value under ‘Alter’ is ‘No’ then these parameters cannot be altered once the SOLV Manager is started. The syntax is: SET [ SOLVMGR ] solvmgr_parameter [ , solvmgr_parameter ] ... solvmgr_parameter is one of the following: ACTIVITYDELAY num Initial Version 5.
HP NonStop Shadowbase Command Definitions SOLV Manager (File Chaser) Command Descriptions Version 5.000 Version Values Default -1 Value Specifications Valid CPU number Alter Yes This parameter specifies a list of processors to be used for starting the SOLV Manager. Up to 16 can be specified (0 through 15). The order of usage is based on the order specified in the list. If a processor is not available, the next in the list will be tried.
HP NonStop Shadowbase Command Definitions SOLV Manager (File Chaser) Command Descriptions Initial Version 5.000 Changed Version Values Default 15 Minimum 1 Maximum 3600 Alter No Specifies the number of seconds AUDMON will delay between restart attempts when the AUDMON AUTORESTART parameter is set to ON and FAILMAX is set to 0 or greater than 1. The default is 15 seconds. Valid values are 1 through 3600. FAILSPAN Initial Version 5.
HP NonStop Shadowbase Command Definitions SOLV Manager (File Chaser) Command Descriptions LOADBEHAVIOR specifies the sequencing and some of the default parameters used by SOLV Manager as it is running. APPEND RELOAD COPY RESYNC SOLV manager monitors source files for modifications and controls when the SOLV load needs to stop and the next file or table load can be started. PURGEDATAONSTART is not enabled. Same as APPEND except PURGEDATAONSTART is enabled. Will load each file in file set and stop.
HP NonStop Shadowbase Command Definitions SOLV Manager (File Chaser) Command Descriptions If this parameter is altered the PRI will not be in effect until the next time SOLVMGR needs to be restarted. PROCESS Initial Version 5.000 [\system. ] $solvmgr_name Changed Version Values Default Value Specifications None Valid process name (include NODE) Alter No This required parameter is the process name of the SOLV Manager. PROGRAM [ \system.$volume.subvolume ] filename Initial Version 5.
HP NonStop Shadowbase Command Definitions SOLV Manager (File Chaser) Command Descriptions three characters of the month name (e.g., JUN), DD are the day digits and YYYY is the four digit year; YYYY is optional and if omitted the current year is assumed (e.g., JUN 01 2011). If entered, start_time must be in the format of HH:MM:SS.t.t. If it is omitted 00:00:00.0.0 is assumed. Entering -1 will clear the value previously set for the parameter.
HP NonStop Shadowbase Command Definitions SOLV Manager (File Chaser) Command Descriptions omitted the current year is assumed (e.g., JUN 01 2011). If entered, stop_time must be in the format of HH:MM:SS.t.t. If it is omitted 00:00:00.0.0 is assumed. Entering -1 will clear the value previously set for the parameter. This is an example of setting this parameter: SET SOLVMGR STOPTIME (SEP 26 2011,09:13:00.0.0) Only one of STOPTIME or STOPFNAME can be specified.
HP NonStop Shadowbase Command Definitions SOLV Manager (File Chaser) Command Descriptions When tracing is enabled, this identifies the file name where the results are to be output. The filename can be fully qualified with volume and subvolume names, however, the file name portion may only be 7 bytes. The SOLV Manager will create up to 36 trace files, each will hold approximately 10MByte of data, extent sizes (14, 42) with maxextents = 746. Each file will have 0-9, A-Z appended to it.
HP NonStop Shadowbase Command Definitions SOLV Manager (File Chaser) Command Descriptions Version 5.000 Version Values Default SOLVMGR Value Specifications Alter Yes This is the section name within the configuration file to use for alternate parameter names and their values. This setting is used with SOLVCONFIGFNAME. SOLVCREATETARGETONSTART Initial Version 5.
HP NonStop Shadowbase Command Definitions SOLV Manager (File Chaser) Command Descriptions SOLVDEBUG Initial Version 5.000 Changed Version { OFF } { ONSTART } Values Default OFF Value Specifications ONSTART Alter Yes Specifies whether SOLV enters debug mode and under what condition. Generally, this should only be set when HP Shadowbase instructs you to do so for diagnosing problems. OFF ONSTART the SOLV Manager does not enter debug mode. the SOLV Manager enters debug mode on start-up.
HP NonStop Shadowbase Command Definitions SOLV Manager (File Chaser) Command Descriptions If this parameter is altered the PRI will not be in effect until the next time SOLV needs to be restarted. SOLVPROCESS [\system. ] $solv_name Initial Version 5.000 Values Default Value Specifications None Valid process name (include NODE) Changed Version Alter No This required parameter is the process name of SOLV. SOLVPROGRAM [ \system.$volume.subvolume ] filename Initial Version 5.
HP NonStop Shadowbase Command Definitions SOLV Manager (File Chaser) Command Descriptions Initial Version 5.000 Changed Version Values Default 0 Minimum 0 Maximum 32767 Alter Yes This option is used to throttle the reading of source records or rows. A delay in .01 seconds is performed between every read. The default is zero thus there is no throttling between reads. SOLVRETRYDELAY num Initial Version 5.
HP NonStop Shadowbase Command Definitions SOLV Manager (File Chaser) Command Descriptions An example of the results of doing an SHOW SOLVMGR command is shown below: +show solvmgr SOLVMGR OBJECT SETTINGS: ACTIVITYDELAY 60 CHECKSAMEFILEATTR OFF CPULIST ( ? ) DEBUG OFF FAILMAX 0 FAILRETRYDELAY 15 FAILSPAN 900 INACTIVITYDELAY 60 LOADBEHAVIOR APPEND LOADSEQUENCING BYMODIFIEDTIME PRI 120 PROCESS ? PROGRAM \GRAVIC1.$GPJ.SMGRUNST.SOLVMGR SOLVAUDITTYPE INSERT SOLVCONFIGFNAME \GRAVIC1.$GPJ.SMGRUNST.
HP NonStop Shadowbase Command Definitions SOLV Manager (File Chaser) Command Descriptions actually start the SOLV process and begin sending data to the Consumer. Enter this command after the associated Consumer is started. The syntax is: START [ SOLVMGR] { [.]solvmgr_name } { [ SOLVMGR ] [.]* } audmon_name Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment.
HP NonStop Shadowbase Command Definitions SOLV Manager (File Chaser) Command Descriptions Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment will be used. solvmgr_name Is the name of the SOLV Manager. * This indicates to include all SOLV Managers. The STATUS SOLVMGR command will now show the HP NonStop Shadowbase product T-Number, and release version.
HP NonStop Shadowbase Command Definitions SOLV Manager (File Chaser) Command Descriptions STARTED: The SOLV Manager was started via the START command, but has not received the RUN command yet. UNKNOWN: The SOLV Manager did not respond within AUDMON’s timeout limit and AUDMON could not determine its current state. Check the EMS log for messages with more information on the state of the SOLV Manager. 4.
HP NonStop Shadowbase Command Definitions UNDO Command Descriptions Optionally specifies the Guardian process name for the HP Shadowbase monitor process controlling the replication environment. If omitted, the currently opened replication environment will be used. solvmgr_name Is the name of the SOLV Manager. * Indicates to stop all SOLV Managers. ! Indicates to ignore errors.
HP NonStop Shadowbase Command Definitions UNDO Command Descriptions The following is an example of what can be output by the command: SHADOWBASE - V5002H06 - (26OCT12) UNDO STATUS AT 2012-04-18:13:42:47 : AUDMON \H2.$JZMON - STATE = RUNNING COLLECTOR/QMGR/CONSUMER STATES: NAME PROCESS TYPE STATE ---------------- ---------------- ---- --------COLL-JZCOL \H2.$JZCOL COLL COMPLETE LTS (LAST EVENT): QMGR-SRC-JZQM \H2.$JZQM QMGR RDYTOSEND CONS-DIR-JZCN1 \H2.
HP NonStop Shadowbase Command Definitions UNDO Command Descriptions The UNDO command initiates the apply phase when running in UNDOMODE and the extract phase of the UNDO has previously completed. The syntax is: UNDO [QMGR] {[.] [ {, {, {[.]* [ {, {, COMMIT } ABORT } ] } COMMIT } ABORT } ] } COMMIT This option, if specified, indicates that any dangling transactions present in the data that was read for the UNDO are to be committed.
