Login:
  • Home
  • →
  • Desktops
  • →
  • Free manual HP   HP Integrity NonStop H-Series
Votes - 0, Average rating: 0 ( )

User manual HP, model HP Integrity NonStop H-Series

Manafacture: HP
File size: 2.02 mb
File name:
Language of manual:enfr
Free link for this manual available at the bottom of the page



Other manuals for this model:

manual abstract


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.

***********************************************************************************************************************************************************
CHECKTARGETS LOG OPENED BY AUDMON \S1.$GESM1 AT 2010-02-05:13:10:32 :

*** DBS INCLUDE OBJECT DBS-6 IS NOT CAPTURED FOR CONS CONS01. POTENTIAL FOR TARGET DATA LOSS. ***

CHECKTARGETS LOG CLOSED BY AUDMON \S1.$GESM1 AT 2010-02-05:13:10:32 :

CHECKTARGETS LOG \S1.$GES.T4090.GSCS1CHK OPENED BY CONS CONS01(\S1.$GSCS1) FOR 'CHECK DBS *, VERIFYSCHEMA' USER REQUEST AT 2010-02-05:13:10:32 :

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-2 \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 *** SRC IS NOT AUDITED ***

DBS-3 \S1.$DATA*.GESDEV.KEYFILE NONE OFF OFF ON ON ON OFF OFF OFF OFF OFF OFF NONE
\S1.$DATA5.GESDEVTG.KEYFILE NONE
SOURCEDICT=\S1.$DATA5.GESDEV, SOURCEREC=KEYREC1 / TARGETDICT=\S1.$DATA5.GESDEV, TARGETREC=KEYREC1
SRC/TRG: \S1.$DATA5.GESDEV.KEYFILE TO \S1.$DATA5.GESDEVTG.KEYFILE -> ENS-TO-ENS

DBS-4 \S1.$DATA5.GESDEV.JULFILE NONE OFF OFF ON ON ON OFF OFF OFF OFF OFF OFF NONE
\S1.$DATA5.GESDEVTG.JULFILE NONE
SOURCEDICT=\S1.$DATA5.GESDEV, SOURCEREC=JULREC / TARGETDICT=\S1.$DATA5.GESDEV, TARGETREC=JULRECT
*SRC/TRG: \S1.$DATA5.GESDEV.JULFILE TO \S1.$DATA5.GESDEVTG.JULFILE -> ENS-TO-ENS *** TARGET COLUMN F01 DATATYPE IS DIFFERENT THAN SOURCE ***
* *** TARGET COLUMN F03 DATATYPE IS DIFFERENT THAN SOURCE ***

DBS-5 \S1.$DATA5.GESDEV.KEYFILE3 NONE OFF OFF ON ON ON OFF OFF OFF OFF OFF OFF NONE
\S1.$DATA5.GESDEVTG.KEYFILE3 NONE
SOURCEDICT=\S1.$DATA5.GESDEV, SOURCEREC=JULREC / TARGETDICT=\S1.$DATA5.GESDEV, TARGETREC=JULRECT
*SRC/TRG: \S1.$DATA5.GESDEV.KEYFILE3 TO \S1.$DATA5.GESDEVTG.KEYFILE3 -> ENS-TO-ENS *** TARGET COLUMN F01 DATATYPE IS DIFFERENT THAN SOURCE ***
* *** TARGET COLUMN F03 DATATYPE IS DIFFERENT THAN SOURCE ***

CONS CHECKTARGETS SUMMARY:
NUMBER OF CAPTURED DBS INCLUDE OBJECTS: 5
NUMBER OF CAPTURED DBS INCLUDE OBJECTS YIELDING NO SRC'S: 0
NUMBER OF SRC'S FOUND: 11
NUMBER OF SRC'S/TRG'S WITHOUT NOTES AND MESSAGES: 8
* NUMBER OF SRC'S/TRG'S NEEDING DETAIL REVIEW: 3
NUMBER OF TRG'S FOR SRC'S FOUND: 11
NUMBER OF MISSING TRG'S: 0
NUMBER OF ENS-TO-ENS: 3
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: 3
NUMBER OF DBS'S WITH TRG DDL SPECIFIED: 3
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 NOT AUDITED: 1
* NUMBER OF SRC'S/TRG'S WITH COLUMN DATA TYPE MISMATCHS (NO USER EXIT): 2
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:13:10:32 :
***********************************************************************************************************************************************************


Example 4 – This example is the same as example 3 but using the BRIEF
option.

***********************************************************************************************************************************************************
CHECKTARGETS LOG OPENED BY AUDMON \S1.$GESM1 AT 2010-02-05:13:14:33 :

*** DBS INCLUDE OBJECT DBS-6 IS NOT CAPTURED FOR CONS CONS01. POTENTIAL FOR TARGET DATA LOSS. ***

CHECKTARGETS LOG CLOSED BY AUDMON \S1.$GESM1 AT 2010-02-05:13:14:33 :

CHECKTARGETS LOG \S1.$GES.T4090.GSCS1CHK OPENED BY CONS CONS01(\S1.$GSCS1) FOR 'CHECK DBS *, BRIEF, VERIFYSCHEMA' USER REQUEST AT 2010-02-05:13:14:33 :

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: 5
NUMBER OF CAPTURED DBS INCLUDE OBJECTS YIELDING NO SRC'S: 0
NUMBER OF SRC'S FOUND: 11
NUMBER OF SRC'S/TRG'S WITHOUT NOTES AND MESSAGES: 8
* NUMBER OF SRC'S/TRG'S NEEDING DETAIL REVIEW: 3
NUMBER OF TRG'S FOR SRC'S FOUND: 11
NUMBER OF MISSING TRG'S: 0
NUMBER OF ENS-TO-ENS: 3
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 NOT AUDITED: 1
* NUMBER OF SRC'S/TRG'S WITH COLUMN DATA TYPE MISMATCHS (NO USER EXIT): 2
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:13:14:33 :
***********************************************************************************************************************************************************


HP NonStop Shadowbase Command Reference Manual—785421-003
205

...


Reviews



Your review
Your name:
Please, enter two numbers from picture:
capcha





Category