Loading...
Select Version
&pagelevel(3)&pagelevel
Example 1
The realm CLOTHING in the SHIPPING database is to be reduced by 12 database pages.
/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL, VERSION=02.8A00 /START-UDS-BREORG ***** START BREORG (UDS/SQL V2.8 0000 ) 2015-06-28 11:40:58 //OPEN-DATABASE DATABASE-NAME=SHIPPING,SCHEMA-NAME=MAIL-ORDERS //MODIFY-REALM-SIZE REALM-NAME=CLOTHING,REALM-SIZE=*RELATIVE(DIFFERENCE=-12) //END ***** BEGIN OF REALM-SIZE-MODIFICATION AT 11:40:58 ***** RESULTS OF FPA-REORGANIZATION OF AREA CLOTHING NEW FPA FIRST PAGE : NOT CHANGED NEW FPA LAST PAGE : NOT CHANGED NEW FPA SIZE : NOT CHANGED NEW NR OF PAGES : 42 ***** END OF REALM-SIZE-MODIFICATION AT 11:40:58 ***** DIAGNOSTIC SUMMARY OF BREORG NO WARNINGS NO ERRORS NO SYSTEM-ERRORS ***** END OF DIAGNOSTIC SUMMARY ***** NR OF DATABASE ACCESSES : 149 ***** NORMAL END BREORG (UDS/SQL V2.8 0000 ) 2015-06-28 11:40:58
Example 2
The realm ARTICLE-RLM is increased so much that the FPA base is not large enough any more. Exactly 1 FPA extent will be the result.
/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL, VERSION=02.8A00 /START-UDS-BREORG ***** START BREORG (UDS/SQL V2.8 0000 ) 2015-06-28 11:40:58 //OPEN-DATABASE DATABASE-NAME=SHIPPING,SCHEMA-NAME=MAIL-ORDERS //MODIFY-REALM-SIZE REALM-NAME=ARTICLE-RLM, REALM-SIZE=*RELATIVE(DIFFERENCE=2000) //END ***** BEGIN OF REALM-SIZE-MODIFICATION AT 11:40:59 ***** RESULTS OF FPA-REORGANIZATION OF AREA ARTICLE-RLM NEW FPA FIRST PAGE : NOT CHANGED NEW FPA LAST PAGE : 11- 78 NEW NR OF EXTENTS : 1 NEW FPA SIZE : 33 NEW NR OF PAGES : 2062 ***** END OF REALM-SIZE-MODIFICATION AT 11:40:59 ***** DIAGNOSTIC SUMMARY OF BREORG NO WARNINGS NO ERRORS NO SYSTEM-ERRORS ***** END OF DIAGNOSTIC SUMMARY ***** NR OF DATABASE ACCESSES : 108 ***** NORMAL END BREORG (UDS/SQL V2.8 0000 ) 2015-06-28 11:40:59
Example 3
The CALC areas of the ARTICLE record type in the SHIPPING database are to be reorganized.
The SEARCH KEY USING CALC areas that belong to the ARTICLE record type are not reorganized.
/SELECT-PRODUCT-VERSION PRODUCT-NAME=UDS-SQL, VERSION=02.8A00 /START-UDS-BREORG ***** START BREORG (UDS/SQL V2.8 0000 ) 2015-06-28 11:40:59 //OPEN-DATABASE DATABASE-NAME=SHIPPING,SCHEMA-NAME=MAIL-ORDERS //REORGANIZE-CALC RECORD-NAME=ARTICLE,CALC-RECORD=*WITHIN-POPULATION(POPULATION=200), - // CALC-SEARCHKEY=NONE //END ***** BEGIN OF CALC-REORGANIZATION AT 11:41:00 ***** RESULTS OF CALC-REORGANIZATION OF RECORD ARTICLE NEW CALC BEGIN : 5- 5 NEW NR OF PRIMARY BUCKETS : 2 NEW NR OF OVERFLOW BUCKETS: 0 ***** RESULTS OF CALC-REORGANIZATION OF RECORD ARTICLE NEW CALC BEGIN : 6- 7 NEW NR OF PRIMARY BUCKETS : 2 NEW NR OF OVERFLOW BUCKETS: 0 ***** RESULTS OF CALC-REORGANIZATION OF RECORD ARTICLE NEW CALC BEGIN : 7- 5 NEW NR OF PRIMARY BUCKETS : 2 NEW NR OF OVERFLOW BUCKETS: 0 ***** RESULTS OF CALC-REORGANIZATION OF RECORD ARTICLE NEW CALC BEGIN : 8- 9 NEW NR OF PRIMARY BUCKETS : 2 NEW NR OF OVERFLOW BUCKETS: 0 ***** RESULTS OF CALC-REORGANIZATION OF RECORD ARTICLE NEW CALC BEGIN : 9- 5 NEW NR OF PRIMARY BUCKETS : 2 NEW NR OF OVERFLOW BUCKETS: 0 ***** RESULTS OF CALC-REORGANIZATION OF RECORD ARTICLE NEW CALC BEGIN : 10- 4 NEW NR OF PRIMARY BUCKETS : 2 NEW NR OF OVERFLOW BUCKETS: 0 ***** END OF CALC-REORGANIZATION AT 11:41:00 ***** DIAGNOSTIC SUMMARY OF BREORG NO WARNINGS NO ERRORS NO SYSTEM-ERRORS ***** END OF DIAGNOSTIC SUMMARY ***** NR OF DATABASE ACCESSES : 149 ***** NORMAL END BREORG (UDS/SQL V2.8 0000 ) 2015-06-28 11:41:00