Beispiel 1
Die Datenbank VERSAND wird mit HSMS online gesichert. Voraussetzung für eine Online-Sicherung ist, dass das AFIM-Logging eingeschaltet ist und die Datenbank mit der BMEND-Anweisung ENABLE-ONLINE-COPY online-sicherungsfähig gemacht wurde. (Hinweis: Zusätzlich zur im Beispiel gezeigten Online-Sicherung sind zur Wiederherstellung einer Datenbank die passenden ALOG-Dateien erforderlich.)
/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL,
VERSION=02.9A00
/START-UDS-BMEND
***** START BMEND (UDS/SQL V2.9 0000 ) 2017-06-28 11:26:28
//ALLOCATE-BUFFER-POOL BUFFER-SIZE=*STD
//OPEN-DATABASE DATABASE-NAME=VERSAND
***** DATABASE ORIGINAL WITHOUT AFIM LOGGING
FUNCTION ENABLE NOT AVAILABLE
FUNCTION KILL NOT AVAILABLE
***** CONSISTENT DATABASE DIRECTORY
//START-LOG DEFAULT-SUPPORT=*PUBLIC(CATID=*OWN),RESERVE-SUPPORT=*PUBLIC(CATID=ABN2),SPACE=*STD,RESET-LOG-POOL=*NO
***** LOGGING WILL BE ACTIVATED
FUNCTION ENABLE AVAILABLE FROM NOW ON
//ENABLE-ONLINE-COPY
//END
***** BEGIN FUNCTION START LOGGING AT 11:26:29
ALOG FILE CREATED ACCORDING TO DEFAULT-SUPPORT
***** NORMAL END FUNCTION START LOGGING AT 11:26:29
***** BEGIN FUNCTION ENABLE ONLINE COPY AT 11:26:29
***** ONLINE COPY FOR DATABASE $XXXXXXXX.VERSAND ALLOWED
***** NORMAL END FUNCTION ENABLE ONLINE COPY AT 11:26:29
***** DIAGNOSTIC SUMMARY OF BMEND
NO WARNINGS
NO ERRORS
NO SYSTEM-ERRORS
***** END OF DIAGNOSTIC SUMMARY
***** NR OF DATABASE ACCESSES : 147
***** NORMAL END BMEND (UDS/SQL V2.9 0000 ) 2017-06-28 11:26:29
/START-HSMS
//BACKUP-FILES
FILE-NAMES=( -
//
VERSAND.COSSD -
// ,
VERSAND.DBCOM -
// ,
VERSAND.DBDIR -
// ,
VERSAND.HASHLIB -
// ,
VERSAND.ARTIKELRLM -
// ,
VERSAND.AUFTRAGSRLM -
// ,
VERSAND.BESTELLRLM -
// ,
VERSAND.HAUSHALT -
// ,
VERSAND.KLEIDUNG -
// ,
VERSAND.LEBENSMITTEL -
// ,
VERSAND.SCHREIBWAREN -
// ,
VERSAND.SPIELE-HOBBY -
// ,
VERSAND.SPORT -
// ), -
//
SAVE-OPTIONS=*PAR(SAVE-ONLINE-FILES=*YES),
-
//
ARCHIVE-NAME=UDS.ARC, -
//
OPERATION-CONT=*PAR(OUT=UDS.ARC.SYSLST.BACKUP, -
//
REPORT=*FULL,WAIT-FOR-COMPLETION=*YES)
//END
REQUEST-ENVIRONMENT=SF
REQUEST-NAME=BCF#4TS0 REQUEST-DATE=2017-06-28 09:27:32 USER-ID=SYSHSMS REQUEST-STATE=COMPLETED WITHOUT
ERROR
STATEMENT LISTING:
BACKUP-FILES FILE-NAMES=( VERSAND.COSSD , VERSAND.DBCOM , VERSAND.DBDIR , VERSAND.HASHLIB ,
VERSAND.ARTIKELRLM , VERSAND.AUFTRAGSRLM , VERSAND.BESTELLRLM ,VERSAND.HAUSHALT , VERSAND.KLEIDUNG ,
VERSAND.LEBENSMITTEL , VERSAND.SCHREIBWAREN , VERSAND.SPIELE-HOBBY , VERSAND.SPORT ),
SAVE-OPTIONS= *PAR(SAVE-ONLINE-FILES=*YES), ARCHIVE-NAME=UDS.ARC,
OPERATION-CONT=*PAR(OUT=UDS.ARC.SYSLST.BACKUP, REPORT=*FULL,WAIT-FOR-COMPLETION=*YES)
ENVIRONMENT : SF
ARCHIVE-NAME : $XXXXXXXX.UDS.ARC
SAVE-FILE ATTRIBUTES : NEW
TO-STORAGE : S2-STORAGE-LEVEL
DEVICE-TYPE : TAPE-C4
RETENTION-PERIOD : 30
SAVE-VERSION ATTRIBUTES
SAVE-VERSION-NAME :
SELECT-FILES PARAMETER
MODIFIED-FILES PARTIAL-FILE-SAVE : NO
MAX-BACKUP-CLASS : STD
*** BACKUP - FILES HSMS V09.0 FULL REPORT *** 2017-06-28 09:27:41 PAGE 2
REQUEST-ENVIRONMENT=SF
REQUEST-NAME=BCF#4TS0 REQUEST-DATE=2017-06-28 09:27:32 USER-ID=XXXXXXXX REQUEST-STATE=COMPLETED WITHOUT
ERROR
% ARC0002 STATEMENT ACCEPTED. ARCHIVE SEQUENCE NUMBER 'A.150628.092733', VERSION '09.0A09'
% ARC0033 ARCHIVE SUBTASK TSN '4TS1' GENERATED
% ARC0825 SUBTASK '0' HAS TRANSFERRED '1475' PAM PAGES FOR '13' FILES AND '0' JVS WITH 256K-BLOCKING IN '0'
SECONDS
SAVE FILE IDENTIFIER - S.150628.092733 SAVE-VERSION-DATE=15-06-28 SAVE-VERSION-TIME=09:27:33
SUBSAVE
NUMBER VSNS
0 QE0146
SAVE FILE IDENTIFIER - S.150628.092733 SAVE-VERSION-DATE=15-06-28 SAVE-VERSION-TIME=09:27:33
*** CATALOG - SQL2 USER - XXXXXXXX ***
FILE/JOB VARIABLE NAME LASTPG/ SAVE INPUT DEV SUB OUTPUT
VERS SIZE TYPE VSN TYP SAVE VSN(S)
VERSAND.ARTIKELRLM 1 124 FULL SQL2.3 D 0 QE0146
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
VERSAND.AUFTRAGSRLM 1 76 FULL SQL2.3 D 0 QE0146
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
VERSAND.BESTELLRLM 1 120 FULL SQL2.3 D 0 QE0146
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
VERSAND.COSSD 1 12 FULL SQL2.3 D 0 QE0146
VERSAND.DBCOM 1 500 FULL SQL2.4 D 0 QE0146
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
VERSAND.DBDIR 1 200 FULL SQL2.4 D 0 QE0146
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
VERSAND.HASHLIB 1 9 FULL SQL2.6 D 0 QE0146
VERSAND.HAUSHALT 1 48 FULL SQL2.3 D 0 QE0146
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
VERSAND.KLEIDUNG 1 108 FULL SQL2.3 D 0 QE0146
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
VERSAND.LEBENSMITTEL 1 36 FULL SQL2.3 D 0 QE0146
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
VERSAND.SCHREIBWAREN 1 48 FULL SQL2.3 D 0 QE0146
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
VERSAND.SPIELE-HOBBY 1 88 FULL SQL2.3 D 0 QE0146
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
VERSAND.SPORT 1 92 FULL SQL2.3 D 0 QE0146
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
NUMBER OF FILES= 13 GLOBAL SIZE= 1461 START= 2017-06-28 09:27:32 END= 2017-06-28 09:27:41
*** E N D O F HSMS V09.0 FULL REPORT *** 2017-06-28 09:27:41 ***
Beispiel 2
Die Online-Sicherung der Datenbank VERSAND wird von HSMS eingespielt. Der Zustand der Sicherung (Konsistenz, Log-Intervall) wird mit BMEND abgefragt. Die Datenbank wird anschließend unter Verwendung der passenden ALOG-Dateien bis zum letztmöglichen Konsistenzpunkt mit BMEND nachgefahren.
/START-HSMS
//RESTORE-FILES -
//
FILE-NAMES=(VERSAND.),-
//
ARCHIVE-NAME=UDS.ARC, -
//
REPLACE-FILES=YES, -
//
SELECT-SAVE-VERSIONS=*LATEST, -
//
OPERATION-CONT=*PAR(OUT=UDS.ARC.SYSLST.RESTORE, -
//
REPORT=*FULL,WAIT-FOR-COMPLETION=*YES)
//STEP
//END
REQUEST-ENVIRONMENT=SF
REQUEST-NAME=RSF#4TSZ REQUEST-DATE=2017-06-28 09:27:49 USER-ID=SYSHSMS REQUEST-STATE=COMPLETED WITHOUT
ERROR
STATEMENT LISTING:
RESTORE-FILES FILE-NAMES=(VERSAND.), ARCHIVE-NAME=UDS.ARC, REPLACE-FILES=YES, SELECT-SAVE-
VERSIONS=*LATEST,
OPERATION-CONT=*PAR(OUT=UDS.ARC.SYSLST.RESTORE, REPORT=*FULL,WAIT-FOR-COMPLETION=*YES)
% ARC0002 STATEMENT ACCEPTED. ARCHIVE SEQUENCE NUMBER 'A.150628.092749', VERSION '09.0A09'
% ARC0033 ARCHIVE SUBTASK TSN '4TS2' GENERATED
% ARC0815 SUBTASK '0' HAS TRANSFERRED '1475' PAM PAGES FOR '13' FILES AND '0' JVS IN '0' SECONDS
SAVE FILE IDENTIFIER - S.150628.092733
SUBSAVE
NUMBER VSNS
0 QE0146
*** CATALOG - SQL2 USER - XXXXXXXX ***
FILE/JOB VARIABLE NAME LASTPG/ SAVE VERSION SAVE INPUT SUB OUTPUT
VERS SIZE IDENTIFIER TYPE VSN SAVE DISK(S)
VERSAND.ARTIKELRLM 1 124 150628.092733 FULL QE0146 0 SQL2.3
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
VERSAND.AUFTRAGSRLM 1 76 150628.092733 FULL QE0146 0 SQL2.4
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
VERSAND.BESTELLRLM 1 120 150628.092733 FULL QE0146 0 SQL2.4
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
VERSAND.COSSD 1 12 150628.092733 FULL QE0146 0 SQL2.4
VERSAND.DBCOM 1 500 150628.092733 FULL QE0146 0 SQL2.4
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
VERSAND.DBDIR 1 200 150628.092733 FULL QE0146 0 SQL2.4
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
VERSAND.HASHLIB 1 9 150628.092733 FULL QE0146 0 SQL2.6
VERSAND.HAUSHALT 1 48 150628.092733 FULL QE0146 0 SQL2.4
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
VERSAND.KLEIDUNG 1 108 150628.092733 FULL QE0146 0 SQL2.4
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
VERSAND.LEBENSMITTEL 1 36 150628.092733 FULL QE0146 0 SQL2.4
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
VERSAND.SCHREIBWAREN 1 48 150628.092733 FULL QE0146 0 SQL2.4
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
VERSAND.SPIELE-HOBBY 1 88 150628.092733 FULL QE0146 0 SQL2.4
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
VERSAND.SPORT 1 92 150628.092733 FULL QE0146 0 SQL2.4
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
*** E N D O F HSMS V09.0 FULL REPORT *** 2017-06-28 09:27:53 ***
/ADD-FILE-LINK LINK-NAME=DATABASE,FILE-NAME=VERSAND.DBDIR
/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL,
VERSION=02.9A00
/START-UDS-BMEND
***** START BMEND (UDS/SQL V2.9 0000 ) 2017-06-28 11:26:35
//SHOW-LOG-INFORMATION REALM-NAME=*ALL,LOG-FILE=4,OUTPUT=*SYSOUT
***** DATABASE ORIGINAL WITHOUT AFIM LOGGING
FUNCTION ENABLE NOT AVAILABLE
FUNCTION KILL NOT AVAILABLE
***** CONSISTENT DATABASE DIRECTORY
//END
***** BEGIN FUNCTION SHOW LOG INFORMATION AT 11:26:35
***** LOG INFORMATION FOR DATABASE $XXXXXXXX.VERSAND
***** LOG INTERVAL OF SPECIFIED REALMS
! ALOG SEQ NR ! !
REALM-NAME ! BEGIN ! END ! CONSISTENT !
------------------------------+-----------+-----------+------------+
DATABASE-DIRECTORY ! 5 ! 5 ! YES !
DATABASE-COMPILER-REALM ! 5 ! 5 ! YES !
AUFTRAGSRLM ! 5 ! 5 ! YES !
BESTELLRLM ! 5 ! 5 ! YES !
KLEIDUNG ! 5 ! 5 ! YES !
HAUSHALT ! 5 ! 5 ! YES !
SPORT ! 5 ! 5 ! YES !
LEBENSMITTEL ! 5 ! 5 ! YES !
SPIELE-HOBBY ! 5 ! 5 ! YES !
SCHREIBWAREN ! 5 ! 5 ! YES !
ARTIKELRLM ! 5 ! 5 ! YES !
***** LOG MODE : NO LOGGING
***** SUPPORTS OF ACTUAL LOG FILE :
***** INFORMATION ABOUT LOG HISTORY :
ALOG SEQ NR! LOG INTERVAL ! AFIM !BACKOUT! LOGGING !
*--------------*--------------* ! ! !
! BEGIN ! END ! ! BFIM ! GAP !
-----------*--------------*--------------*------*-------*---------*
4 !20170628112638!20170628112639! * ! ! ? !
3 !20170628112637!20170628112638! * ! ! !
2 !20170628112636!20170628112637! * ! ! !
1 !20170628112635!20170628112636! * ! ! !
***** ONLINE COPIES BY ARCHIVE ARE NOT ALLOWED
***** NORMAL END FUNCTION SHOW LOG INFORMATION AT 11:26:35
***** DIAGNOSTIC SUMMARY OF BMEND
NO WARNINGS
NO ERRORS
NO SYSTEM-ERRORS
***** END OF DIAGNOSTIC SUMMARY
***** NR OF DATABASE ACCESSES : 49
***** NORMAL END BMEND (UDS/SQL V2.9 0000 ) 2017-06-28 11:26:35
/ADD-FILE-LINK LINK-NAME=DATABASE,FILE-NAME=VERSAND.DBDIR
/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL,
VERSION=02.9A00
/START-UDS-BMEND
...
***** START BMEND (UDS/SQL V2.9 0000 ) 2017-06-28 11:26:35
//OPEN-DATABASE DATABASE-NAME=VERSAND
//UPDATE-DATABASE REALM-NAME=*ALL,DEADLINE=STD
SYSTEM_BREAK OCCURRED IN REALM DATABASE-DIRECTORY
***** INCONSISTENT DATABASE DIRECTORY
SYSTEM_BREAK OCCURRED IN REALM BESTELLRLM
SYSTEM_BREAK OCCURRED IN REALM LEBENSMITTEL
SYSTEM_BREAK OCCURRED IN REALM ARTIKELRLM
***** INCONSISTENT DATABASE DIRECTORY
FUNCTION ADD NOT AVAILABLE
FUNCTION REMOVE NOT AVAILABLE
FUNCTION START NOT AVAILABLE
FUNCTION STOP NOT AVAILABLE
***** STD UPDATE FOR ALL REALMS SPECIFIED
FUNCTION ADD AVAILABLE FROM NOW ON
FUNCTION REMOVE AVAILABLE FROM NOW ON
FUNCTION START AVAILABLE FROM NOW ON
FUNCTION STOP AVAILABLE FROM NOW ON
FUNCTION KILL NOT AVAILABLE
//END
***** BEGIN FUNCTION UPDATE DATABASE AT 09:27:54
***** MENDING WITH ALOG FILE '$XXXXXXXX.VERSAND.A.000000002' STARTED
***** MENDING WITH ALOG FILE '$XXXXXXXX.VERSAND.A.000000002' FINISHED
***** MENDING WITH ALOG FILE '$XXXXXXXX.VERSAND.A.000000003' STARTED
***** MENDING WITH ALOG FILE '$XXXXXXXX.VERSAND.A.000000003' FINISHED
***** MENDING WITH ALOG FILE '$XXXXXXXX.VERSAND.A.000000004' STARTED
***** MENDING WITH ALOG FILE '$XXXXXXXX.VERSAND.A.000000004' FINISHED
***** ALOG FILE '$XXXXXXXX.VERSAND.A.000000005' NOT USED FOR MENDING
***** NORMAL END FUNCTION UPDATE DATABASE AT 09:27:55
***** DIAGNOSTIC SUMMARY OF BMEND
NO WARNINGS
NO ERRORS
NO SYSTEM-ERRORS
***** END OF DIAGNOSTIC SUMMARY
***** NR OF DATABASE ACCESSES : 306
***** NORMAL END BMEND (UDS/SQL V2.9 0000 ) 2017-06-28 11:26:35
Beispiel 3
Von der Datenbank KUNDEN wird eine Schattendatenbank KUNDEN.KOP erzeugt.
/SHOW-FILE-ATTRIBUTES FILE-NAME=KUNDEN.
768 :SQL2:$XXXXXXXX.KUNDEN.A.000000001
192 :SQL2:$XXXXXXXX.KUNDEN.A.000000002
120 :SQL2:$XXXXXXXX.KUNDEN.COSSD
501 :SQL2:$XXXXXXXX.KUNDEN.DBCOM
201 :SQL2:$XXXXXXXX.KUNDEN.DBDIR
24 :SQL2:$XXXXXXXX.KUNDEN.DBSTAT
24 :SQL2:$XXXXXXXX.KUNDEN.DBSTAT.SAVE
252 :SQL2:$XXXXXXXX.KUNDEN.FINANZRLM
12 :SQL2:$XXXXXXXX.KUNDEN.HASHLIB
252 :SQL2:$XXXXXXXX.KUNDEN.KUNDENRLM
24 :SQL2:$XXXXXXXX.KUNDEN.SLF
SUM PUBLIC: 11 FILES RES= 2370 FRE= 351 REL= 339 PAGES
/COPY-FILE FROM-FILE=:SQL2:KUNDEN.COSSD,
TO-FILE=KUNDEN.COSSD.KOP
/COPY-FILE FROM-FILE=:SQL2:KUNDEN.DBCOM, TO-FILE=KUNDEN.DBCOM.KOP
/COPY-FILE FROM-FILE=:SQL2:KUNDEN.DBDIR,
TO-FILE=KUNDEN.DBDIR.KOP
/COPY-FILE FROM-FILE=:SQL2:KUNDEN.HASHLIB, TO-FILE=KUNDEN.HASHLIB.KOP
/COPY-FILE FROM-FILE=:SQL2:KUNDEN.KUNDENRLM, TO-FILE=KUNDEN.KUNDENRLM.KOP
/COPY-FILE FROM-FILE=:SQL2:KUNDEN.FINANZRLM, TO-FILE=KUNDEN.FINANZRLM.KOP
/SHOW-FILE-ATTRIBUTES FILE-NAME=KUNDEN.*.KOP
120 :SQL2:$XXXXXXXX.KUNDEN.COSSD.KOP
501 :SQL2:$XXXXXXXX.KUNDEN.DBCOM.KOP
201 :SQL2:$XXXXXXXX.KUNDEN.DBDIR.KOP
252 :SQL2:$XXXXXXXX.KUNDEN.FINANZRLM.KOP
12 :SQL2:$XXXXXXXX.KUNDEN.HASHLIB.KOP
252 :SQL2:$XXXXXXXX.KUNDEN.KUNDENRLM.KOP
:SQL2: PUBLIC: 6 FILES RES= 1338 FRE= 119 REL= 117 PAGES
Beispiel 4
Der defekte Realm KUNDEN.FINANZRLM wird durch die Realm-Sicherung KUNDEN.FINANZRLM.KOP ersetzt. Der Zustand (Konsistenz, Log-Intervall) des Realms wird mit BMEND abgefragt. Anschließend wird der Realm bis zum letztmöglichen Konsistenzpunkt mit BMEND nachgefahren.
/DELETE-FILE :SQL2:KUNDEN.FINANZRLM
/COPY-FILE FROM-FILE=KUNDEN.FINANZRLM.KOP
,TO-FILE=:SQL2:KUNDEN.FINANZRLM
/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL,
VERSION=02.9A00
/START-UDS-BMEND
...
***** START BMEND (UDS/SQL V2.9 0000 ) 2017-06-28 09:26:39
//OPEN-DATABASE DATABASE-NAME=KUNDEN
DIFFERENCE OF BACKUP DATA BETWEEN REALM FINANZRLM AND CONSISTENCY RECORD
***** INCONSISTENT DATABASE DIRECTORY
FUNCTION START NOT AVAILABLE
FUNCTION STOP NOT AVAILABLE
//SHOW-LOG-INFORMATION REALM-NAME=*ALL,OUTPUT=SYSLST
//END
***** BEGIN FUNCTION SHOW LOG INFORMATION AT 09:26:40
***** LOG INFORMATION FOR DATABASE $XXXXXXXX.KUNDEN
***** LOG INTERVAL OF SPECIFIED REALMS
! ALOG SEQ NR ! !
REALM-NAME ! BEGIN ! END ! CONSISTENT !
------------------------------+-----------+-----------+------------+
DATABASE-DIRECTORY ! 3 ! 3 ! YES !
DATABASE-COMPILER-REALM ! 2 ! 2 ! YES !
KUNDENRLM ! 2 ! 2 ! YES !
FINANZRLM ! 1 ! 1 ! YES !
***** TO MAKE THE SPECIFIED REALMS CONSISTENT, THE FOLLOWING LOG FILES ARE
NECESSARY :
FROM ALOG SEQ NR 1 TO ALOG SEQ NR 3
OR FROM LOG INTERVAL BEGIN 20170628092636 TO LOG INTERVAL END
20170628092639
***** LOG MODE : AFIM LOGGING
***** SUPPORTS OF ACTUAL LOG FILE :
DEFAULT SUPPORT :PVS ID = DEFAULT PVS
RESERVE SUPPORT :PVS ID = DEFAULT PVS
***** INFORMATION ABOUT LOG HISTORY :
ALOG SEQ NR! LOG INTERVAL ! AFIM !BACKOUT! LOGGING !
*--------------*--------------* ! ! !
! BEGIN ! END ! ! BFIM ! GAP !
-----------*--------------*--------------*------*-------*---------*
3 !20170628092639!20170628092639! * ! ! !
2 !20170628092636!20170628092639! * ! ! !
1 !20170628092635!20170628092636! * ! ! !
***** ONLINE COPIES BY ARCHIVE ARE NOT ALLOWED
***** NORMAL END FUNCTION SHOW LOG INFORMATION AT 09:26:40
***** DIAGNOSTIC SUMMARY OF BMEND
NO WARNINGS
NO ERRORS
NO SYSTEM-ERRORS
***** END OF DIAGNOSTIC SUMMARY
***** NR OF DATABASE ACCESSES : 20
***** NORMAL END BMEND (UDS/SQL V2.9 0000 ) 2017-06-28 09:26:40
/START-UDS-BMEND
...
***** START
BMEND
(UDS/SQL
V2.9
0000 )
2017-06-28
09:26:40
//OPEN-DATABASE DATABASE-NAME=KUNDEN
DIFFERENCE OF BACKUP DATA BETWEEN REALM FINANZRLM AND CONSISTENCY RECORD
***** INCONSISTENT DATABASE DIRECTORY
FUNCTION START NOT AVAILABLE
FUNCTION STOP NOT AVAILABLE
//UPDATE-DATABASE REALM-NAME=FINANZRLM,DEADLINE=*STD
//END
***** BEGIN
FUNCTION UPDATE DATABASE AT 09:26:40
***** ALOG FILE '$XXXXXXXX.KUNDEN.A.000000001' NOT USED FOR MENDING
***** MENDING WITH ALOG FILE '$XXXXXXXX.KUNDEN.A.000000002' STARTED
***** MENDING WITH ALOG FILE '$XXXXXXXX.KUNDEN.A.000000002' FINISHED
***** ALOG FILE '$XXXXXXXX.KUNDEN.A.000000003' NOT USED FOR MENDING
***** NORMAL
END FUNCTION UPDATE DATABASE AT 09:26:40
***** DIAGNOSTIC SUMMARY OF BMEND
NO WARNINGS
NO ERRORS
NO SYSTEM-ERRORS
***** END OF DIAGNOSTIC SUMMARY
***** NR OF DATABASE ACCESSES
:
41
***** NORMAL END
BMEND
(UDS/SQL
V2.9
0000 )
2017-06-28
09:26:40
Beispiel 5
Die Schattendatenbank KUNDEN.KOP soll aktualisiert werden. Der Zustand der Schattendatenbank (Konsistenz, Log-Intervall) im Vergleich zur Originaldatenbank wird mit BMEND abgefragt. Anschließend wird die Schattendatenbank bis zum letztmöglichen Konsistenzpunkt mit BMEND nachgefahren.
/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL,
VERSION=02.9A00
/START-UDS-BMEND
...
***** START
BMEND
(UDS/SQL
V2.9
0000 )
2017-06-28
09:26:40
//OPEN-DATABASE DATABASE-NAME=KUNDEN,COPY-NAME=KOP
***** PROCESSING OF DATABASE COPY
FUNCTION START NOT AVAILABLE
FUNCTION STOP NOT AVAILABLE
FUNCTION KILL NOT AVAILABLE
***** CONSISTENT
DATABASE DIRECTORY
//SHOW-LOG-INFORMATION REALM-NAME=*ALL,OUTPUT=*SYSLST
//END
***** BEGIN FUNCTION SHOW LOG INFORMATION AT 09:26:40
***** LOG INFORMATION FOR DATABASE $XXXXXXXX.KUNDEN.KOP
***** LOG INTERVAL OF SPECIFIED REALMS
! ALOG SEQ NR ! !
REALM-NAME ! BEGIN ! END ! CONSISTENT !
------------------------------+-----------+-----------+------------+
DATABASE-DIRECTORY ! 2 ! 2 ! YES !
DATABASE-COMPILER-REALM ! 1 ! 1 ! YES !
KUNDENRLM ! 1 ! 1 ! YES !
FINANZRLM ! 1 ! 1 ! YES !
***** INFORMATION ABOUT LOG HISTORY :
ALOG SEQ NR! LOG INTERVAL ! AFIM !BACKOUT! LOGGING !
*--------------*--------------* ! ! !
! BEGIN ! END ! ! BFIM ! GAP !
-----------*--------------*--------------*------*-------*---------*
2 !20170628092636!20170628092639! * ! ! ? !
1 !20170628092635!20170628092636! * ! ! !
***** ONLINE COPIES BY ARCHIVE ARE NOT ALLOWED
***** NORMAL END FUNCTION SHOW LOG INFORMATION AT 09:26:40
***** DIAGNOSTIC SUMMARY OF BMEND
NO WARNINGS
NO ERRORS
NO SYSTEM-ERRORS
***** END OF DIAGNOSTIC SUMMARY
***** NR OF DATABASE ACCESSES : 20
***** NORMAL END BMEND (UDS/SQL V2.9 0000 ) 2017-06-28 09:26:40
/START-UDS-BMEND
...
***** START BMEND (UDS/SQL V2.9 0000 ) 2017-06-28 09:26:40
//OPEN-DATABASE DATABASE-NAME=KUNDEN
***** CONSISTENT DATABASE DIRECTORY
FUNCTION KILL NOT AVAILABLE
//SHOW-LOG-INFORMATION REALM-NAME=*ALL,OUTPUT=*SYSLST
//END
***** BEGIN FUNCTION SHOW LOG INFORMATION AT 09:26:40
***** LOG INFORMATION FOR DATABASE $XXXXXXXX.KUNDEN
***** LOG INTERVAL OF SPECIFIED REALMS
! ALOG SEQ NR ! !
REALM-NAME ! BEGIN ! END ! CONSISTENT !
------------------------------+-----------+-----------+------------+
DATABASE-DIRECTORY ! 3 ! 3 ! YES !
DATABASE-COMPILER-REALM ! 2 ! 2 ! YES !
KUNDENRLM ! 2 ! 2 ! YES !
FINANZRLM ! 2 ! 2 ! YES !
***** LOG MODE : AFIM LOGGING
***** SUPPORTS OF ACTUAL LOG FILE :
DEFAULT SUPPORT :PVS ID = DEFAULT PVS
RESERVE SUPPORT :PVS ID = DEFAULT PVS
***** INFORMATION ABOUT LOG HISTORY :
ALOG SEQ NR! LOG INTERVAL ! AFIM !BACKOUT! LOGGING !
*--------------*--------------* ! ! !
! BEGIN ! END ! ! BFIM ! GAP !
-----------*--------------*--------------*------*-------*---------*
3 !20170628092639!20170628092639! * ! ! !
2 !20170628092636!20170628092639! * ! ! !
1 !20170628092635!20170628092636! * ! ! !
***** ONLINE COPIES BY ARCHIVE ARE NOT ALLOWED
***** NORMAL END FUNCTION SHOW LOG INFORMATION AT 09:26:40
***** NR OF DATABASE ACCESSES : 20
***** NORMAL END BMEND (UDS/SQL V2.9 0000 ) 2017-06-28 09:26:40
/START-UDS-BMEND
...
***** START
BMEND
(UDS/SQL
V2.9
0000 )
2017-06-28
09:26:40
//OPEN-DATABASE DATABASE-NAME=KUNDEN,COPY-NAME=KOP
***** PROCESSING OF DATABASE COPY
FUNCTION START NOT AVAILABLE
FUNCTION STOP NOT AVAILABLE
FUNCTION KILL NOT AVAILABLE
***** CONSISTENT
DATABASE DIRECTORY
//UPDATE-DATABASE REALM-NAME=*ALL,DEADLINE=*STD
//END
***** BEGIN
FUNCTION UPDATE DATABASE AT 09:26:40
***** MENDING WITH ALOG FILE '$XXXXXXXX.KUNDEN.A.000000002' STARTED
***** MENDING WITH ALOG FILE '$XXXXXXXX.KUNDEN.A.000000002' FINISHED
***** ALOG FILE '$XXXXXXXX.KUNDEN.A.000000003' NOT USED FOR MENDING
***** NORMAL
END FUNCTION UPDATE DATABASE AT 09:26:41
***** DIAGNOSTIC SUMMARY OF BMEND
NO WARNINGS
NO ERRORS
NO SYSTEM-ERRORS
***** END OF DIAGNOSTIC SUMMARY
***** NR OF DATABASE ACCESSES
:
147
***** NORMAL END
BMEND
(UDS/SQL
V2.9
0000 )
2017-06-28
09:26:41