Example 1
The SHIPPING database is saved online using HSMS. To make this possible, AFIM logging must have been activated and the BMEND statement ENABLE-ONLINE-COPY issued. (Note: In addition to the online backup given in the example, the appropriate ALOG files are required to recover the database.)
/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL,
VERSION=02.9B00
/START-UDS-BMEND
***** START BMEND (UDS/SQL V2.9 1801 ) 2019-01-29 09:27:26
//ALLOCATE-BUFFER-POOL BUFFER-SIZE=*STD
//OPEN-DATABASE DATABASE-NAME=SHIPPING
***** 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 09:27:26
ALOG FILE CREATED ACCORDING TO DEFAULT-SUPPORT
***** NORMAL END FUNCTION START LOGGING AT 09:27:26
***** BEGIN FUNCTION ENABLE ONLINE COPY AT 09:27:26
***** ONLINE COPY FOR DATABASE $XXXXXXXX.SHIPPING ALLOWED
***** NORMAL END FUNCTION ENABLE ONLINE COPY AT 09:27:26
***** 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 1801 ) 2019-01-29 09:27:26
/START-HSMS
//BACKUP-FILES FILE-NAMES=( -
// SHIPPING.COSSD -
// , SHIPPING.DBCOM -
// , SHIPPING.DBDIR -
// , SHIPPING.HASHLIB -
// , SHIPPING.ARTICLE-RLM -
// , SHIPPING.CUSTOMER-ORDER-RLM -
// , SHIPPING.PURCHASE-ORDER-RLM -
// , SHIPPING.HOUSEHOLD-GOODS -
// , SHIPPING.CLOTHING -
// , SHIPPING.FOOD -
// , SHIPPING.STATIONERY -
// , SHIPPING.LEISURE -
// , SHIPPING.SPORTS-ARTICLES -
// ), -
// 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#4TKB REQUEST-DATE=2019-01-29 09:27:29 USER-ID=XXXXXXXX REQUEST-STATE=COMPLETED WITHOUT ERROR
STATEMENT LISTING:
BACKUP-FILES FILE-NAMES = ( SHIPPING.COSSD , SHIPPING.DBCOM , SHIPPING.DBDIR , SHIPPING.HASHLIB , SHIPPING.ARTICLE-RLM , SHIPPING.CUSTOMER-ORDER-RLM , SHIPPING.PURCHASE-ORDER-RLM , SHIPPING.HOUSEHOLD-GOODS , SHIPPING.CLOTHING , SHIPPING.FOOD , SHIPPING.STATIONERY , SHIPPING.LEISURE , SHIPPING.SPORTS-ARTICLES ),
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 V11.0 FULL REPORT *** 2019-01-29 09:27:37 PAGE 2
REQUEST-ENVIRONMENT=SF
REQUEST-NAME=BCF#4TKB REQUEST-DATE=2019-01-29 09:27:29 USER-ID=SYSHSMS REQUEST-STATE=COMPLETED WITHOUT ERROR
% ARC0002 STATEMENT ACCEPTED. ARCHIVE SEQUENCE NUMBER 'A.190129.092730', VERSION '11.0A04'
% ARC0033 ARCHIVE SUBTASK TSN '4TKL' GENERATED
% ARC0825 SUBTASK '0' HAS TRANSFERRED '1478' PAM PAGES FOR '13' FILES AND '0' JVS WITH 256K-BLOCKING IN '1' SECONDS
SAVE FILE IDENTIFIER - S.190129.092730 SAVE-VERSION-DATE=2019-01-29 SAVE-VERSION-TIME=09:27:30
SUBSAVE
NUMBER VSNS
0 FI0994
SAVE FILE IDENTIFIER - S.190129.092730 SAVE-VERSION-DATE=2019-01-29 SAVE-VERSION-TIME=09:27:30
*** CATALOG - IUDS USER - XXXXXXXX ***
FILE/JOB VARIABLE NAME LASTPG/ SAVE INPUT DEV SUB OUTPUT
VERS SIZE TYPE VSN TYP SAVE VSN(S)
SHIPPING.ARTICLE-RLM 1 124 FULL IUDS.2 D 0 FI0994
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
SHIPPING.CLOTHING 1 108 FULL IUDS.2 D 0 FI0994
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
SHIPPING.COSSD 1 12 FULL IUDS.2 D 0 FI0994
SHIPPING.CUSTOMER-ORDER-RLM 1 72 FULL IUDS.2 D 0 FI0994
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
SHIPPING.DBCOM 1 500 FULL IUDS.2 D 0 FI0994
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
SHIPPING.DBDIR 1 200 FULL IUDS.2 D 0 FI0994
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
SHIPPING.FOOD 1 36 FULL IUDS.2 D 0 FI0994
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
SHIPPING.HASHLIB 1 9 FULL IUDS.6 D 0 FI0994
SHIPPING.HOUSEHOLD-GOODS 1 48 FULL IUDS.2 D 0 FI0994
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
SHIPPING.LEISURE 1 88 FULL IUDS.2 D 0 FI0994
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
SHIPPING.PURCHASE-ORDER-RLM 1 120 FULL IUDS.2 D 0 FI0994
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
SHIPPING.SPORTS-ARTICLES 1 88 FULL IUDS.2 D 0 FI0994
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
SHIPPING.STATIONERY 1 48 FULL IUDS.2 D 0 FI0994
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
NUMBER OF FILES= 13 GLOBAL SIZE= 1453 START= 2019-01-29 09:27:29 END= 2019-01-29 09:27:37
*** E N D O F HSMS V11.0 FULL REPORT *** 2019-01-29 09:27:37 ***
Example 2
The online backup of the SHIPPING database is read in using HSMS. The status of the backup (consistency, log interval) is queried using BMEND.
The database is then updated to the last possible consistency point with BMEND.
/START-HSMS
//RESTORE-FILES -
// FILE-NAMES=(SHIPPING.),-
// 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#4TTF REQUEST-DATE=2019-01-29 09:27:44 USER-ID=SYSHSMS REQUEST-STATE=COMPLETED WITHOUT
ERROR
STATEMENT LISTING:
RESTORE-FILES FILE-NAMES=(SHIPPING.), 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.190129.092744', VERSION '11.0A04'
% ARC0033 ARCHIVE SUBTASK TSN '4TK4' GENERATED
% ARC0815 SUBTASK '0' HAS TRANSFERRED '1478' PAM PAGES FOR '13' FILES AND '0' JVS IN '0' SECONDS
SAVE FILE IDENTIFIER - S.190129.092730
SUBSAVE
NUMBER VSNS
0 FI0994
*** CATALOG - IUDS USER - XXXXXXXX ***
FILE/JOB VARIABLE NAME LASTPG/ SAVE VERSION SAVE INPUT SUB OUTPUT
VERS SIZE IDENTIFIER TYPE VSN SAVE DISK(S)
SHIPPING.ARTICLE-RLM 1 124 190129.092730 FULL FI0994 0 IUDS.2
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
SHIPPING.CLOTHING 1 108 190129.092730 FULL FI0994 0 IUDS.2
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
SHIPPING.COSSD 1 12 190129.092730 FULL FI0994 0 IUDS.2
SHIPPING.CUSTOMER-ORDER-RLM 1 72 190129.092730 FULL FI0994 0 IUDS.2
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
SHIPPING.DBCOM 1 500 190129.092730 FULL FI0994 0 IUDS.2
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
SHIPPING.DBDIR 1 200 190129.092730 FULL FI0994 0 IUDS.2
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
SHIPPING.FOOD 1 36 190129.092730 FULL FI0994 0 IUDS.2
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
SHIPPING.HASHLIB 1 9 190129.092730 FULL FI0994 0 IUDS.6
SHIPPING.HOUSEHOLD-GOODS 1 48 190129.092730 FULL FI0994 0 IUDS.2
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
SHIPPING.LEISURE 1 88 190129.092730 FULL FI0994 0 IUDS.2
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
SHIPPING.PURCHASE-ORDER-RLM 1 120 190129.092730 FULL FI0994 0 IUDS.2
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
SHIPPING.SPORTS-ARTICLES 1 88 190129.092730 FULL FI0994 0 IUDS.2
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
SHIPPING.STATIONERY 1 48 190129.092730 FULL FI0994 0 IUDS.2
% ARC0059 FILE HAS BEEN SAVED 'ON LINE'
*** E N D O F HSMS V11.0 FULL REPORT *** 2019-01-29 09:27:37 ***
/ADD-FILE-LINK LINK-NAME=DATABASE,FILE-NAME=SHIPPING.DBDIR
/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL, VERSION=02.9B00
/START-UDS-BMEND
***** START BMEND (UDS/SQL V2.9 1801 ) 2019-01-29 09:27:46
//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 09:27:49
***** LOG INFORMATION FOR DATABASE $XXXXXXXX.SHIPPING
***** LOG INTERVAL OF SPECIFIED REALMS
! ALOG SEQ NR ! !
REALM-NAME ! BEGIN ! END ! CONSISTENT !
-----------------------------+----------+----------+------------+
DATABASE-DIRECTORY ! 2 ! 2 ! NO !
DATABASE-COMPILER-REALM ! 1 ! 1 ! YES !
CUSTOMER-ORDER-RLM ! 1 ! 1 ! YES !
PURCHASE-ORDER-RLM ! 2 ! 2 ! NO !
CLOTHING ! 1 ! 1 ! YES !
HOUSEHOLD-GOODS ! 1 ! 1 ! YES !
SPORTS-ARTICLES ! 1 ! 1 ! YES !
FOOD ! 2 ! 2 ! NO !
LEISURE ! 1 ! 1 ! YES !
STATIONERY ! 1 ! 1 ! YES !
ARTICLE-RLM ! 2 ! 2 ! NO !
***** 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 !20190129092738!20190129092739! * ! ! ? !
3 !20190129092737!20190129092738! * ! ! !
2 !20190129092727!20190129092737! * ! ! !
1 !20190129092725!20190129092727! * ! ! !
***** ONLINE COPIES BY ARCHIVE ARE NOT ALLOWED
***** NORMAL END FUNCTION SHOW LOG INFORMATION AT 11:41:01
***** DIAGNOSTIC SUMMARY OF BMEND
NO WARNINGS
NO ERRORS
NO SYSTEM-ERRORS
***** END OF DIAGNOSTIC SUMMARY
***** NR OF DATABASE ACCESSES : 51
***** NORMAL END BMEND (UDS/SQL V2.9 1801 ) 2019-01-29 09:27:49
/ADD-FILE-LINK LINK-NAME=DATABASE,FILE-NAME=SHIPPING.DBDIR
/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL,
VERSION=02.9B00
/START-UDS-BMEND
...
***** START BMEND (UDS/SQL V2.9 1801 ) 2019-01-29 09:27:49
//OPEN-DATABASE DATABASE-NAME=SHIPPING
//UPDATE-DATABASE REALM-NAME=*ALL,DEADLINE=*STD
SYSTEM_BREAK OCCURRED IN REALM DATABASE-DIRECTORY
***** INCONSISTENT DATABASE DIRECTORY
SYSTEM_BREAK OCCURRED IN REALM PURCHASE-ORDER-RLM
SYSTEM_BREAK OCCURRED IN REALM FOOD
SYSTEM_BREAK OCCURRED IN REALM ARTICLE-RLM
***** 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:49
***** MENDING WITH ALOG FILE '$XXXXXXXX.SHIPPING.A.000000002' STARTED
***** MENDING WITH ALOG FILE '$XXXXXXXX.SHIPPING.A.000000002' FINISHED
***** MENDING WITH ALOG FILE '$XXXXXXXX.SHIPPING.A.000000003' STARTED
***** MENDING WITH ALOG FILE '$XXXXXXXX.SHIPPING.A.000000003' FINISHED
***** MENDING WITH ALOG FILE '$XXXXXXXX.SHIPPING.A.000000004' STARTED
***** MENDING WITH ALOG FILE '$XXXXXXXX.SHIPPING.A.000000004' FINISHED
***** ALOG FILE '$XXXXXXXX.SHIPPING.A.000000005' NOT USED FOR MENDING
***** NORMAL END FUNCTION UPDATE DATABASE AT 09:27:49
***** 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 1801 ) 2019-01-29 09:27:49
Example 3
A shadow database CUSTOMER.COPY is generated from the CUSTOMER database.
768 :IUDS:$XXXXXXXX.CUSTOMER.A.000000001
192 :IUDS:$XXXXXXXX.CUSTOMER.A.000000002
120 :IUDS:$XXXXXXXX.CUSTOMER.COSSD
252 :IUDS:$XXXXXXXX.CUSTOMER.CUSTOMER-RLM
501 :IUDS:$XXXXXXXX.CUSTOMER.DBCOM
201 :IUDS:$XXXXXXXX.CUSTOMER.DBDIR
24 :IUDS:$XXXXXXXX.CUSTOMER.DBSTAT
24 :IUDS:$XXXXXXXX.CUSTOMER.DBSTAT.SAVE
252 :IUDS:$XXXXXXXX.CUSTOMER.FINANCE-RLM
12 :IUDS:$XXXXXXXX.CUSTOMER.HASHLIB
24 :IUDS:$XXXXXXXX.CUSTOMER.SLF
IUDS PUBLIC: 11 FILES RES= 2370 FRE= 351 REL= 339 PAGES
120 :IUDS:$XXXXXXXX.CUSTOMER.COSSD.COPY
252 :IUDS:$XXXXXXXX.CUSTOMER.CUSTOMER-RLM.COPY
501 :IUDS:$XXXXXXXX.CUSTOMER.DBCOM.COPY
201 :IUDS:$XXXXXXXX.CUSTOMER.DBDIR.COPY
252 :IUDS:$XXXXXXXX.CUSTOMER.FINANCE-RLM.COPY
12 :IUDS:$XXXXXXXX.CUSTOMER.HASHLIB.COPY
:IUDS: PUBLIC: 6 FILES RES= 1338 FRE= 119 REL= 117 PAGES
|
Example 4
The defective realm CUSTOMER.CUSTOMER-RLM is replaced by the realm backup CUSTOMER.CUSTOMER-REALM.COPY. The status (consistency, log interval) of the realm is queried using BMEND. The realm is then updated to the last possible consistency point with BMEND.
***** START BMEND (UDS/SQL V2.9 1801 ) 2019-01-29 09:26:43
DIFFERENCE OF BACKUP DATA BETWEEN REALM FINANCE-RLM AND CONSISTENCY RECORD
***** INCONSISTENT DATABASE DIRECTORY
FUNCTION START NOT AVAILABLE
FUNCTION STOP NOT AVAILABLE
//SHOW-LOG-INFORMATION REALM-NAME=*ALL,OUTPUT=*SYSLST ***** BEGIN FUNCTION SHOW LOG INFORMATION AT 09:26:43
***** LOG INFORMATION FOR DATABASE $XXXXXXXX.CUSTOMER
***** LOG INTERVAL OF SPECIFIED REALMS
! ALOG SEQ NR ! !
REALM-NAME ! BEGIN ! END ! CONSISTENT !
--------------------------+-----------+----------+------------+
DATABASE-DIRECTORY ! 3 ! 3 ! YES !
DATABASE-COMPILER-REALM ! 2 ! 2 ! YES !
CUSTOMER-RLM ! 2 ! 2 ! YES !
FINANCE-RLM ! 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 20190129092640 TO LOG INTERVAL END
20190129092642
***** 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 !20190129092642!20190129092642! * ! ! !
2 !20190129092640!20190129092642! * ! ! !
1 !20190129092639!20190129092640! * ! ! !
***** ONLINE COPIES BY ARCHIVE ARE NOT ALLOWED
***** NORMAL END FUNCTION SHOW LOG INFORMATION AT 09:26:43
***** 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 1801 ) 2019-01-29 09:26:42
***** START BMEND (UDS/SQL V2.9 1801 ) 2019-01-29 09:26:43 //OPEN-DATABASE DATABASE-NAME=CUSTOMER DIFFERENCE OF BACKUP DATA BETWEEN REALM FINANCE-RLM AND CONSISTENCY RECORD
***** INCONSISTENT DATABASE DIRECTORY
FUNCTION START NOT AVAILABLE
FUNCTION STOP NOT AVAILABLE
***** BEGIN FUNCTION UPDATE DATABASE AT 09:26:43
***** ALOG FILE '$XXXXXXXX.CUSTOMER.A.000000001' NOT USED FOR MENDING
***** MENDING WITH ALOG FILE '$XXXXXXXX.CUSTOMER.A.000000002' STARTED
***** MENDING WITH ALOG FILE '$XXXXXXXX.CUSTOMER.A.000000002' FINISHED
***** ALOG FILE '$XXXXXXXX.CUSTOMER.A.000000003' NOT USED FOR MENDING
***** NORMAL END FUNCTION UPDATE DATABASE AT 09:26:43
***** 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 1801 ) 2019-01-29 09:26:43
|
Example 5
The shadow database CUSTOMER.COPY is to be updated. Its status (consistency, log interval) compared to the original database is queried using BMEND. The shadow database is then updated to the last possible consistency point with BMEND.
***** START BMEND (UDS/SQL V2.9 1801 ) 2019-01-29 09:26:44 //OPEN-DATABASE DATABASE-NAME=CUSTOMER,COPY-NAME=COPY ***** PROCESSING OF DATABASE COPY
FUNCTION START NOT AVAILABLE
FUNCTION STOP NOT AVAILABLE
FUNCTION KILL NOT AVAILABLE
***** CONSISTENT DATABASE DIRECTORY
***** BEGIN FUNCTION SHOW LOG INFORMATION AT 09:26:44
***** LOG INFORMATION FOR DATABASE $XXXXXXXX.CUSTOMER.COPY
***** LOG INTERVAL OF SPECIFIED REALMS
! ALOG SEQ NR ! !
REALM-NAME ! BEGIN ! END ! CONSISTENT !
-----------------------------+-----------+----------+------------+
DATABASE-DIRECTORY ! 2 ! 2 ! YES !
DATABASE-COMPILER-REALM ! 1 ! 1 ! YES !
CUSTOMER-RLM ! 1 ! 1 ! YES !
FINANCE-RLM ! 1 ! 1 ! YES !
***** INFORMATION ABOUT LOG HISTORY :
ALOG SEQ NR! LOG INTERVAL ! AFIM !BACKOUT! LOGGING !
*--------------*--------------* ! ! !
! BEGIN ! END ! ! BFIM ! GAP !
-----------*-------------*--------------*------*-------*---------*
2 !20190129092640!20190129092640! * ! ! ? !
1 !20190129092639!20190129092640! * ! ! !
***** 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 1801 ) 2019-01-29 09:26:40
***** START BMEND (UDS/SQL V2.9 1801 ) 2019-01-29 09:26:43 ***** CONSISTENT DATABASE DIRECTORY
FUNCTION KILL NOT AVAILABLE
***** BEGIN FUNCTION SHOW LOG INFORMATION AT 09:26:43
***** LOG INFORMATION FOR DATABASE $XXXXXXXX.CUSTOMER
***** LOG INTERVAL OF SPECIFIED REALMS
! ALOG SEQ NR ! !
REALM-NAME ! BEGIN ! END ! CONSISTENT !
----------------------------+-----------+----------+------------+
DATABASE-DIRECTORY ! 3 ! 3 ! YES !
DATABASE-COMPILER-REALM ! 2 ! 2 ! YES !
CUSTOMER-RLM ! 2 ! 2 ! YES !
FINANCE-RLM ! 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 !20190129092642!20190129092642! * ! ! !
2 !20190129092640!20190129092642! * ! ! !
1 !20190129092639!20190129092640! * ! ! !
***** ONLINE COPIES BY ARCHIVE ARE NOT ALLOWED
***** NORMAL END FUNCTION SHOW LOG INFORMATION AT 09:26:43
***** NR OF DATABASE ACCESSES : 20
***** NORMAL END BMEND (UDS/SQL V2.9 1801 ) 2019-01-29 09:26:43
***** START BMEND (UDS/SQL V2.9 1801 ) 2019-01-29 09:26:43
***** PROCESSING OF DATABASE COPY
FUNCTION START NOT AVAILABLE
FUNCTION STOP NOT AVAILABLE
FUNCTION KILL NOT AVAILABLE
***** CONSISTENT DATABASE DIRECTORY
***** BEGIN FUNCTION UPDATE DATABASE AT 09:26:43
***** MENDING WITH ALOG FILE '$XXXXXXXX.CUSTOMER.A.000000002' STARTED
***** MENDING WITH ALOG FILE '$XXXXXXXX.CUSTOMER.A.000000002' FINISHED
***** ALOG FILE '$XXXXXXXX.CUSTOMER.A.000000003' NOT USED FOR MENDING
***** NORMAL END FUNCTION UPDATE DATABASE AT 09:26:43
***** 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 1801 ) 2019-01-29 09:26:43
|