If you execute the facility for predicting reorganization time with the predict statement specified, you can output the prediction results to a file in CSV format.
The table below describes the execution results items of the facility for predicting reorganization time that are output in CSV format.
Table 15-9 Execution results items of the facility for predicting reorganization time (output in CSV format)
Title | Output item | Output format | Max. length (bytes) | Output information | ||
---|---|---|---|---|---|---|
Scheduled database maintenance date | Maintenance method | Information by analysis item | ||||
kind | Output type: p: Information about scheduled database maintenance date m: Information about maintenance method d: Information by analysis item | Character string | 8 | Y | Y | Y |
No | Analysis result number | Numeric value | 10 | Y | Y | Y |
Date | Scheduled database maintenance date | YYYY/MM/DD | 10 | Y | Y | Y |
Type | Target type: T: Table I: Index L: LOB RDAREA R: Data dictionary RDAREA, user RDAREA, or registry RDAREA | Character string | 1 | Y | Y | Y |
* | Asterisk identifies a resource whose maintenance has been determined to be necessary. These are the resources the user must maintain. | Character | 1 | Space | Y | Space |
AuthID | Authorization identifier For a data dictionary table, (Data dictionary) is displayed. | Character string | 30 | N | Y# | Y# |
Name | Name of the table or index | Character string | 30 | N | Y# | Y# |
Rdarea | RDAREA name | Character string | 30 | Y | Y | Y |
Method | Maintenance method: 0: Maintenance is not necessary 1: Reclaim S (release used free segments) 2: Reclaim P (release used free pages) 3: Reorganize (reorganize) 4: Expand (expand RDAREA) 5: Extend (extend RDAREA automatically (maintenance not necessary)) 6: Reinit (Re-initialize RDAREA) 7: ReclaimPx (specify the -x option to release used free pages in the index) For details about the maintenance method, see 15.4.1 Output format of the execution results. | Numeric value | 5 | N | Y | Y |
NextExec | Recommended time for the next execution of the condition analysis result accumulation facility | YYYY/MM/DD | 10 | N | N | N |
StateDate | Analysis information acquisition date and time. This is the date and time the most recent information was acquired among all analysis information that was used for the analysis. | YYYY/MM/DD hh:mm:ss | 19 | Y | N | Y |
InfoNo | Number of the analysis item type: 1: Empty Page Ratio 2: Unused Page Ratio 3: Number of Branch Row 8: Used Segment for LOB Columns 10: Used Segment for Cluster 11: Unused Page Differ From PCTFREE 12: Delete row ID ratio 13: Used Segment Ratio | Numeric value | 5 | Y | N | Y |
Value | Analysis value for the analysis item type | Numeric value | 5 | Y | N | Y |
PredictBase | Standard value used for the analysis item type | Numeric value | 5 | Y | N | Y |
Count | Number of accumulated data items | Numeric value | 5 | N | N | N |
Segment | Number of segments released | Numeric value | 10 | N | Y | N |
Reclaim | Predicted number of released segments in releasing used free segments | Numeric value | 10 | N | Y# | N |
Reorganize | Predicted number of released segments in reorganization | Numeric value | 10 | N | Y# | N |
ItemMethod | Number of the maintenance method for each analysis item | Numeric value | 5 | N | Y | Y |
CheckNo | Number of standard values for checking | Numeric value | 5 | Y | N | Y |
Check1 | Standard value for checking by analysis item type used for analysis | Numeric value | 5 | Y | N | Y |
Check2 | Standard value for checking by analysis item type used for analysis | Numeric value | 5 | Y | N | Y |
The following shows an output example in the CSV format:
Kind,No,Date,Type,*,AuthID,Name,Rdarea,Method,NextExec,StateDate,InfoNo,Value, |
Kind,No,Date,Type,*,AuthID,Name,Rdarea,Method,NextExec,StateDate,InfoNo,Value, |
Kind,No,Date,Type,*,AuthID,Name,Rdarea,Method,NextExec,StateDate,InfoNo,Value, |