The following reports are generated when no REPORT parameters are specified as in the first example.
Report 1: Messages Phase I
IDMSDBAN - DATA BASE ANALYSIS REPORT 1: MESSAGES DATE TIME PAGE mm/dd/yy 20234050 1 PARAMETER CARD: PROCESS SUBSCHEMA EMPSS01 DBNAME EMPDEMO UNLOCKED PARAMETER CARD: AREA EMP-DEMO-REGION IDMSDBAN - DATA BASE ANALYSIS REPORT 1: MESSAGES DATE TIME PAGE mm/dd/yy 20234050 2
Report 2: Area
598601 - AREA PROCESSING BEGINNING: EMPDEMO.EMP-DEMO-REGION IDMSDBAN - DATA BASE ANALYSIS REPORT 2: AREA DATA DATE TIME PAGE mm/dd/yy 20234050 1 AREA: EMPDEMO.EMP-DEMO-REGION SUBSCHEMA: EMPSS01 AREA PAGE RANGE - START PAGE: 75,001 END PAGE: 75,100 PAGES ALLOCATED FOR AREA: 100 PAGE RANGE ANALYZED - START PAGE: 75,001 END PAGE: 75,100 PAGES PROCESSED FOR AREA IN THIS RUN: 100 NUMBER OF SMP WITHIN PAGES PROCESSED: 1 PAGE SIZE IN BYTES: 4,276 MAXIMUM RECORDS ALLOWED PER PAGE: 255 BYTES USED IN PAGES PROCESSED: 29,204 BYTES AVAILABLE IN PAGES PROCESSED: 394,120 NUMBER OF LOGICALLY FULL PAGES: 0 BYTES AVAILABLE ON LOGICALLY FULL PAGES: 0 NUMBER OF DATA RECORDS IN PAGES PROCESSED: 346 NUMBER OF PAGES WITH EMPTY CALC CHAINS: 58 NUMBER OF RELOCATED RECORDS: 0 NUMBER OF LOGICALLY DELETED RECORDS: 0 NUMBER OF VLR FRAGMENTS: 0 NUMBER OF LINE INDEXES FOR PHYSICALLY DELETED RECORDS: 0 SPACE AVAILABILITY HISTOGRAM PERCENT OF BYTES PAGES TOTAL PERCENT OF GRAPH AVAILABLE ON PAGE BYTES (000) TOTAL PAGES ...10...20...30...40...50...60...70...80...90..100 100 57 242 58 XXXXXXXXXXXXXXXXXXXXXXXXXXXXX 90 - 99 22 86 22 XXXXXXXXXXX 80 - 89 14 51 14 XXXXXXX 70 - 79 2 7 2 X 60 - 69 2 5 2 X 50 - 59 0 0 0 40 - 49 1 2 1 / 30 - 39 1 1 1 / 20 - 29 0 0 0 10 - 19 0 0 0 1 - 9 0 0 0 LESS THAN 1 0 0 0 AVERAGE BYTES AVAILABLE PER PAGE (ALL PAGES) 3,981 AVERAGE BYTES AVAILABLE PER PAGE (NON-EMPTY PAGES) 3,624
Report 2: Area
IDMSDBAN - DATA BASE ANALYSIS REPORT 2: AREA DATA DATE TIME PAGE mm/dd/yy 20234050 2 0 AREA: EMPDEMO.EMP-DEMO-REGION (CONTINUED) SUBSCHEMA: EMPSS01 DATA RECORDS PER PAGE HISTOGRAM DATA RECORDS PAGES PERCENT OF GRAPH PER PAGE TOTAL PAGES ...10...20...30...40...50...60...70...80...90..100 0 57 58 XXXXXXXXXXXXXXXXXXXXXXXXXXXXX 1 - 25 40 40 XXXXXXXXXXXXXXXXXXXX 26 - 51 2 2 X 52 - 76 0 0 77 -102 0 0 103 -127 0 0 128 -152 0 0 153 -178 0 0 179 -203 0 0 204 -229 0 0 230 -254 0 0 255 0 0 AVERAGE DATA RECORDS PER PAGE (ALL PAGES) 3 AVERAGE DATA RECORDS PER PAGE (NON-EMPTY PAGES) 8
Report 3: Set Statistics
IDMSDBAN - DATA BASE ANALYSIS REPORT 3: SET STATISTICS DATE TIME PAGE mm/dd/yy 20234050 1 0 SET: EMP-EMPOSITION MODE: CHAIN ORDER: FIRST SUBSCHEMA: EMPSS01 NAME SET MEMBERSHIP NUMBER OF EMPTY SETS UNCONNECTED LOCATION MODE TYPE RECORDS MEMBERS OWNER: EMPLOYEE 56 0 CALC MEMBERS: EMPOSITION MA 68 0 VIA EMP-EMPOSITION _________ ___________ 68 MEMBER RECORDS 0 UNCONNECTED MEMBERS AVERAGE MEMBERS PER SET FOR NON-EMPTY SETS 1
Report 4: Record Data
IDMSDBAN - DATA BASE ANALYSIS REPORT 4: RECORD DATA DATE TIME PAGE mm/dd/yy 20234050 1 0 RECORD: EMPLOYEE RECORD ID: 415 LOCATION MODE: CALC SUBSCHEMA: EMPSS01 AREA: EMPDEMO.EMP-DEMO-REGION FLR/VLR: FLR DATA LENGTH: 116 RECORD LENGTH (DATA AND PREFIX): 188 PAGE RANGE FOR RECORD IN AREA - START PAGE: 75,003 END PAGE: 75,100 PAGES ALLOCATED FOR RECORD IN AREA: 98 PAGE RANGE ANALYZED - START PAGE: 75,003 END PAGE: 75,100 PAGES PROCESSED FOR RECORD IN AREA IN THIS RUN: 98 NUMBER OF SMP WITHIN PAGES PROCESSED: 0 PAGE SIZE IN BYTES: 4,276 BYTES USED FOR THIS RECORD TYPE IN PAGES PROCESSED: 10,976 BYTES AVAILABLE IN PAGES PROCESSED: 392,736 NUMBER OF RECORDS OF THIS TYPE IN PAGES PROCESSED: 56 NUMBER OF RELOCATED RECORDS: 0 NUMBER OF LOGICALLY DELETED RECORDS: 0 DATA RECORDS PER PAGE HISTOGRAM DATA RECORDS PAGES PERCENT OF GRAPH PER PAGE TOTAL PAGES ...10...20...30...40...50...60...70...80...90..100 0 57 58 XXXXXXXXXXXXXXXXXXXXXXXXXXXXX 1 - 25 41 42 XXXXXXXXXXXXXXXXXXXXX 26 - 51 0 0 52 - 76 0 0 77 -102 0 0 103 -127 0 0 128 -152 0 0 153 -178 0 0 179 -203 0 0 204 -229 0 0 230 -254 0 0 255 0 0 AVERAGE DATA RECORDS PER PAGE (ALL PAGES) 0 AVERAGE DATA RECORDS PER PAGE (PAGES WITH THIS RECORD TYPE) 1
Report 1A: Messages Phase II
IDMSDBAN PHASE II - SET ANALYSIS REPORT 1A: MESSAGES DATE TIME PAGE mm/dd/yy 20240900 1 599001 - PHASE II PROCESSING BEGUN 599803 - END PASS 0 599801 - FROM-RECORDS WRITTEN TO SORT 630 599802 - TO-RECORDS WRITTEN TO SORT 630 599806 - INDEX SR8 DESCRIPTORS WRITTEN 4 599807 - INDEX DOWN DESCRIPTORS WRITTEN 58 599808 - INDEX UP DESCRIPTORS WRITTEN 58 599809 - INDEX NO-UP MEM DESCRIPTORS WRITTEN 0 599810 - INDEX NO-UP DOWN DESCRIPTORS WRITTEN 0 599803 - END PASS 1 599801 - FROM-RECORDS WRITTEN TO SORT 0 599802 - TO-RECORDS WRITTEN TO SORT 0 599805 - INDEX PATHS WRITTEN TO SORT 0 599806 - INDEX SR8 DESCRIPTORS WRITTEN 1 599807 - INDEX DOWN DESCRIPTORS WRITTEN 19 599808 - INDEX UP DESCRIPTORS WRITTEN 19 599803 - END PASS 2 599801 - FROM-RECORDS WRITTEN TO SORT 0 599802 - TO-RECORDS WRITTEN TO SORT 0 599805 - INDEX PATHS WRITTEN TO SORT 0 599806 - INDEX SR8 DESCRIPTORS WRITTEN 0 599807 - INDEX DOWN DESCRIPTORS WRITTEN 0 599808 - INDEX UP DESCRIPTORS WRITTEN 0
Report 5: Set Analysis
IDMSDBAN PHASE II - SET ANALYSIS REPORT 5: SET ANALYSIS DATA DATE TIME PAGE mm/dd/yy 20240900 1 SET: EMP-EMPOSITION MODE: CHAIN ORDER: FIRST SUBSCHEMA: EMPSS01 OWNER: EMPLOYEE MEMBERS: EMPOSITION CHAIN LENGTH HISTOGRAM CHAIN LENGTH NUMBER OF SETS PERCENT OF GRAPH TOTAL SETS ...10...20...30...40...50...60...70...80...90..100 0 0 0 2 47 84 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 3 6 11 XXXXX/ 4 3 5 XX/ 5 - 8 0 0 9 - 16 0 0 17 - 32 0 0 33 - 64 0 0 65 - 128 0 0 129 - 256 0 0 257 - 512 0 0 OVER 512 0 0 AVERAGE CHAIN LENGTH (ALL SETS): 2 AVERAGE CHAIN LENGTH (NON-EMPTY SETS): 2 MAXIMUM CHAIN LENGTH: 4
|
Copyright © 2014 CA.
All rights reserved.
|
|