|
 |
| Slide 1:
Front
|
|
 |
| Slide 2:
Agenda
|
|
 |
| Slide 3:
Why Reorg
|
|
 |
| Slide 4:
Reorg Motivation
|
|
 |
| Slide 5:
Logical File structure
|
|
 |
| Slide 6:
Why 6184
|
|
 |
| Slide 7:
File Control Table
|
|
 |
| Slide 8:
Table A
|
|
 |
| Slide 9:
Table B logical
|
|
 |
| Slide 10:
Table B Page
|
|
 |
| Slide 11:
Table B record
|
|
 |
| Slide 12:
Extension Records
|
|
 |
| Slide 13:
Preventing Extensions
|
|
 |
| Slide 14:
Table B Parms
|
|
 |
| Slide 15:
BAVAIL Parameter
|
|
 |
| Slide 16:
Table C
|
|
 |
| Slide 17:
Table C
|
|
 |
| Slide 18:
Table D
|
|
 |
| Slide 19:
Lists and bitmaps
|
|
 |
| Slide 20:
Scattered D Lists
|
|
 |
| Slide 21:
Existence Bitmap
|
|
 |
| Slide 22:
Ordered Index
|
|
 |
| Slide 23:
Ordered Index Splits
|
|
 |
| Slide 24:
Procedure Dictionary
|
|
 |
| Slide 25:
PAI Reload
|
|
 |
| Slide 26:
Structured Reload
|
|
 |
| Slide 27:
Best of Both
|
|
 |
| Slide 28:
Fast/Unload (FUEL)2
|
|
 |
| Slide 29:
Fast/Reload (FLOD)
|
|
 |
| Slide 30:
Fast/Reorg
|
|
 |
| Slide 31:
Fast/Reorg
|
|
 |
| Slide 32:
UAI FUNOUT
|
|
 |
| Slide 33:
UAI OINDEX
|
|
 |
| Slide 34:
Fast/Unload (FUEL)
|
|
 |
| Slide 35:
Fast/Reorg Tuning
|
|
 |
| Slide 36:
Fast/Unload Tuning
|
|
 |
| Slide 37:
Fast/Unload Report
|
|
 |
| Slide 38:
Fast/Unload Report
|
|
 |
| Slide 39:
Reducing CPU Time
|
|
 |
| Slide 40:
Waiting for CPU
|
|
 |
| Slide 41:
Open Wait
|
|
 |
| Slide 42:
Output Buffer Wait
|
|
 |
| Slide 43:
Base Buffer Wait
|
|
 |
| Slide 44:
Extension Buffer Wait
|
|
 |
| Slide 45:
Extension Buffer Wait
|
|
 |
| Slide 46:
Fast/Reload Tuning
|
|
 |
| Slide 47:
Fast/Reload CPU
|
|
 |
| Slide 48:
Fast/Reload Disk I/O
|
|
