HP Integrity NonStop H-Series Betriebsanweisung Seite 213

  • Herunterladen
  • Zu meinen Handbüchern hinzufügen
  • Drucken
  • Seite
    / 346
  • Inhaltsverzeichnis
  • LESEZEICHEN
  • Bewertet. / 5. Basierend auf Kundenbewertungen
Seitenansicht 212
HP NonStop Shadowbase Command Definitions
Database Specification Command Descriptions
HP NonStop Shadowbase Command Reference Manual—785421-002
204
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.
***********************************************************************************************************************************************************
CHECKTARGETS LOG OPENED BY AUDMON \S1.$GESM1 AT 2010-02-05:10:55:01 :
[[[ NOTE: ALL 3 DBS INCLUDE AND EXCLUDE OBJECTS HAVE BEEN CAPTURED FOR CONS CONS01 ]]]
CHECKTARGETS LOG CLOSED BY AUDMON \S1.$GESM1 AT 2010-02-05:10:55:02 :
CHECKTARGETS LOG \S1.$GES.T4090.GSCS1CHK OPENED BY CONS CONS01(\S1.$GSCS1) FOR 'CHECK DBS *, VERIFYSCHEMA' USER REQUEST AT 2010-02-05:10:55:02 :
HEADING LEGEND: MAPFRSRC=MAPFROMSOURCE,MAPTOTPL=MAPTOTEMPLATE,INS=INSERTS,UPD=UPDATES,DEL=DELETES,ALT=ALTERS,PRG=PURGES,PGD=PURGEDATAS,
INF=INSERTNOTFOUND,UDP=UPDATEDUPLICATE,USRXID=USEREXITID
DBS INCLUDE SOURCEFILE/TARGETFILE/DDL MAPTOFILE/PATHNAME MAPFRSRC MAPTOTPL INS UPD DEL ALT CRT PRG PGD INF UDP USRXID
----------- ------------------------- ------------------ -------- -------- --- --- --- --- --- --- --- --- --- ------
DBS-1 \S1.$DATA*.GESDEV.KEYTABL NONE OFF OFF ON ON ON OFF OFF OFF OFF OFF OFF NONE
\S1.$DATA5.GESDEVTG.KEYTABL NONE
SRC/TRG: \S1.$DATA7.GESDEV.KEYTABL TO \S1.$DATA5.GESDEVTG.KEYTABL -> SQL-TO-SQL
\S1.$DATA5.GESDEV.KEYTABL TO \S1.$DATA5.GESDEVTG.KEYTABL -> SQL-TO-SQL
\S1.$DATA4.GESDEV.KEYTABL TO \S1.$DATA5.GESDEVTG.KEYTABL -> SQL-TO-SQL
\S1.$DATA3.GESDEV.KEYTABL TO \S1.$DATA5.GESDEVTG.KEYTABL -> SQL-TO-SQL
\S1.$DATA2.GESDEV.KEYTABL TO \S1.$DATA5.GESDEVTG.KEYTABL -> SQL-TO-SQL
\S1.$DATA1.GESDEV.KEYTABL TO \S1.$DATA5.GESDEVTG.KEYTABL -> SQL-TO-SQL
\S1.$DATA02.GESDEV.KEYTABL TO \S1.$DATA5.GESDEVTG.KEYTABL -> SQL-TO-SQL
DBS-RELTABL \S1.$DATA5.GESDEV.RELTABL NONE OFF OFF ON ON ON OFF OFF OFF OFF OFF OFF NONE
\S1.$DATA5.GESDEVTG.RELTABL NONE
SRC/TRG: \S1.$DATA5.GESDEV.RELTABL TO \S1.$DATA5.GESDEVTG.RELTABL -> SQL-TO-SQL
DBS-2 \S1.$DATA5.GESDEV.KEYFILE1 NONE OFF OFF ON ON ON OFF OFF OFF OFF OFF OFF NONE
\S1.$DATA5.GESDEVTG.KEYFILE1 NONE
SOURCEDICT=\S1.$DATA5.GESDEV, SOURCEREC=KEYREC1 / TARGETDICT=\S1.$DATA5.GESDEV, TARGETREC=KEYREC1
SRC/TRG: \S1.$DATA5.GESDEV.KEYFILE1 TO \S1.$DATA5.GESDEVTG.KEYFILE1 -> ENS-TO-ENS
CONS CHECKTARGETS SUMMARY:
NUMBER OF CAPTURED DBS INCLUDE OBJECTS: 3
NUMBER OF CAPTURED DBS INCLUDE OBJECTS YIELDING NO SRC'S: 0
NUMBER OF SRC'S FOUND: 9
NUMBER OF SRC'S/TRG'S WITHOUT NOTES AND MESSAGES: 9
NUMBER OF SRC'S/TRG'S NEEDING DETAIL REVIEW: 0
NUMBER OF TRG'S FOR SRC'S FOUND: 9
NUMBER OF MISSING TRG'S: 0
NUMBER OF ENS-TO-ENS: 1
NUMBER OF ENS-TO-SQL: 0
NUMBER OF SQL-TO-SQL: 8
NUMBER OF SQL-TO-ENS: 0
NUMBER OF DBS'S WITH SRC DDL SPECIFIED: 1
NUMBER OF DBS'S WITH TRG DDL SPECIFIED: 1
NUMBER OF SRC'S SKIPPED (DO NOT MATCH DBS SOURCETYPE): 0
NUMBER OF SRC'S SKIPPED (MATCHES EXCLUDE DBS OBJECT): 0
NUMBER OF SRC'S/TRG'S WITH COLUMN DATA TYPE MISMATCHS (NO USER EXIT): 0
NUMBER OF SRC'S/TRG'S WITH COLUMN DATA TYPE MISMATCHS (WITH A USER EXIT): 0
CHECKTARGETS LOG \S1.$GES.T4090.GSCS1CHK CLOSED BY CONS CONS01(\S1.$GSCS1) AT 2010-02-05:10:55:02 :
***********************************************************************************************************************************************************
Example 2 – A CHECK DBS *, BRIEF, VERIFYSCHEMA command was
used. There were no discrepancies found. Take notice that only a
summary section is included.
***********************************************************************************************************************************************************
CHECKTARGETS LOG OPENED BY AUDMON \S1.$GESM1 AT 2010-02-05:11:10:00 :
[[[ NOTE: ALL 3 DBS INCLUDE AND EXCLUDE OBJECTS HAVE BEEN CAPTURED FOR CONS CONS01 ]]]
CHECKTARGETS LOG CLOSED BY AUDMON \S1.$GESM1 AT 2010-02-05:11:10:01 :
CHECKTARGETS LOG \S1.$GES.T4090.GSCS1CHK OPENED BY CONS CONS01(\S1.$GSCS1) FOR 'CHECK DBS *, BRIEF, VERIFYSCHEMA' USER REQUEST AT 2010-02-05:11:10:01 :
HEADING LEGEND: MAPFRSRC=MAPFROMSOURCE,MAPTOTPL=MAPTOTEMPLATE,INS=INSERTS,UPD=UPDATES,DEL=DELETES,ALT=ALTERS,PRG=PURGES,PGD=PURGEDATAS,
INF=INSERTNOTFOUND,UDP=UPDATEDUPLICATE,USRXID=USEREXITID
CONS CHECKTARGETS SUMMARY:
NUMBER OF CAPTURED DBS INCLUDE OBJECTS: 3
NUMBER OF CAPTURED DBS INCLUDE OBJECTS YIELDING NO SRC'S: 0
NUMBER OF SRC'S FOUND: 9
NUMBER OF SRC'S/TRG'S WITHOUT NOTES AND MESSAGES: 9
NUMBER OF SRC'S/TRG'S NEEDING DETAIL REVIEW: 0
NUMBER OF TRG'S FOR SRC'S FOUND: 9
NUMBER OF MISSING TRG'S: 0
NUMBER OF ENS-TO-ENS: 1
NUMBER OF ENS-TO-SQL: 0
NUMBER OF SQL-TO-SQL: 8
NUMBER OF SQL-TO-ENS: 0
NUMBER OF SRC'S SKIPPED (DO NOT MATCH DBS SOURCETYPE): 0
NUMBER OF SRC'S SKIPPED (MATCHES EXCLUDE DBS OBJECT): 0
NUMBER OF SRC'S/TRG'S WITH COLUMN DATA TYPE MISMATCHS (NO USER EXIT): 0
NUMBER OF SRC'S/TRG'S WITH COLUMN DATA TYPE MISMATCHS (WITH A USER EXIT): 0
CHECKTARGETS LOG \S1.$GES.T4090.GSCS1CHK CLOSED BY CONS CONS01(\S1.$GSCS1) AT 2010-02-05:11:10:01 :
***********************************************************************************************************************************************************
Seitenansicht 212
1 2 ... 208 209 210 211 212 213 214 215 216 217 218 ... 345 346

Kommentare zu diesen Handbüchern

Keine Kommentare