15.4.2 Output format in CSV format

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.

Organization of this subsection
(1) Rules for output data
(2) Prediction results output items
(3) Output example

(1) Rules for output data

  1. The items are separated by the comma (,).
  2. Each line of data ends with the linefeed character (0x0a).
  3. If there is no information to be output for an item, only the comma is output (or the linefeed character in the case of the last item).
  4. A title line is output as the first line.

(2) Prediction results output items

Table 15-6 describes the execution results items of the facility for predicting reorganization time that are output in the CSV format.

Table 15-6 Execution results items of the facility for predicting reorganization time (output in CSV format)

TitleOutput itemOutput formatMax. length
(bytes)
Output information
Scheduled database maintenance dateMaintenance methodInformation by analysis item
kindOutput type:
p: Information about scheduled database maintenance date
m: Information about maintenance method
d: Information by analysis item
Character string8YYY
NoAnalysis result numberNumeric value10YYY
DateScheduled database maintenance dateYYYY/MM/DD10YYY
TypeTarget type:
T: Table
I: Index
L: LOB RDAREA
R: Data dictionary RDAREA, user RDAREA, or registry RDAREA
Character string1YYY
*Asterisk identifies a resource whose maintenance has been determined to be necessary.
These are the resources the user must maintain.
Character1SpaceYSpace
AuthIDAuthorization identifier
For a data dictionary table, (Data dictionary) is displayed.
Character string30NY*Y*
NameName of the table or indexCharacter string30NY*Y*
RdareaRDAREA nameCharacter string30YYY
MethodMaintenance 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)
For details about the maintenance method, see 15.4.1 Output format of the execution results.
Numeric value5NYY
NextExecRecommended time for the next execution of the condition analysis result accumulation facilityYYYY/MM/DD10NNN
StateDateAnalysis 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:ss19YNY
InfoNoNumber 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
13: Used Segment Ratio
Numeric value5YNY
ValueAnalysis value for the analysis item typeNumeric value5YNY
PredictBaseStandard value used for the analysis item typeNumeric value5YNY
CountNumber of accumulated data itemsNumeric value5NNN
SegmentNumber of segments releasedNumeric value10NYN
ReclaimPredicted number of released segments in releasing used free segmentsNumeric value10NY*N
ReorganizePredicted number of released segments in reorganizationNumeric value10NY*N
ItemMethodNumber of the maintenance method for each analysis itemNumeric value5NYY
CheckNoNumber of standard values for checkingNumeric value5YNY
Check1Standard value for checking by analysis item type used for analysisNumeric value5YNY
Check2Standard value for checking by analysis item type used for analysisNumeric value5YNY
Legend:
Y: Output
N: Not output
blank: 1 space character is output
Note
An item is enclosed in double quotation marks (") if its output format is character string. The maximum length does not include these quotation marks.
* This information is not output when the target type is R.

(3) Output example

The following shows an output example in the CSV format:

(a) When the -e 1 option is specified and the -m option is omitted

Kind,No,Date,Type,*,AuthID,Name,Rdarea,Method,NextExec,StateDate,InfoNo,Value,PredictBase,
Count,Segment,Reclaim,Reorganize,ItemMethod,CheckNo,Check1,Check2
"p",1,2005/01/26,"R"," ",,,"RDUSER12",,,2004/12/27 15:58:08,13,50,80,,,,,,2,0,0
"p",1,2005/01/30,"R"," ",,,"rd0002",,,2004/12/27 15:58:08,13,60,80,,,,,,2,0,0
"p",1,2005/01/11,"R"," ",,,"lobrdarea701",,,2004/12/27 15:58:08,13,70,80,,,,,,2,0,0
"p",1,2005/01/15,"R"," ",,,"RDUSER02",,,2004/12/27 15:58:08,13,65,80,,,,,,2,0,0

(b) When the -e 1 and -m options are both specified

Kind,No,Date,Type,*,AuthID,Name,Rdarea,Method,NextExec,StateDate,InfoNo,Value,PredictBase,
Count,Segment,Reclaim,Reorganize,ItemMethod,CheckNo,Check1,Check2
"p",1,2005/01/26,"R"," ",,,"RDUSER01",,,2004/12/27 15:58:08,13,50,80,,,,,,2,0,0
"m",1,2005/01/26,"R"," ",,,"RDUSER01",0,,,,,,,2,0,0,0,,,
"m",1,2005/01/26,"I"," ","k1234567​","index01","RDUSER01",0,,,,,,,2,0,1,0,,,
"m",1,2005/01/26,"T","*","k1234567​","table01","RDUSER01",3,,,,,,,2,0,4,3,,,
          :
"p",1,2005/01/30,"R"," ",,,"RDUSER02",,,2004/12/27 15:58:08,13,50,80,,,,,,2,0,0
"m",1,2005/01/30,"R"," ",,,"RDUSER02",0,,,,,,,0,0,0,0,,,
"m",1,2005/01/30,"T"," ","k1234567​","table03","RDUSER02",0,,,,,,,0,0,0,0,,,
          :
"p",1,2005/01/21,"R"," ",,,"RDUSER02",,,2004/12/27 15:58:08,13,50,80,,,,,,2,0,0
"m",1,2005/01/21,"R","*",,,"RDUSER02",4,,,,,,,6,0,0,4,,,
"m",1,2005/01/21,"I"," ","k1234567​","index03","RDUSER02",0,,,,,,,6,0,1,0,,,
"m",1,2005/01/21,"T"," ","k1234567​","table03","RDUSER02",0,,,,,,,6,0,4,0,,,
          :

(c) When the -e 2 option is specified

Kind,No,Date,Type,*,AuthID,Name,Rdarea,Method,NextExec,StateDate,InfoNo,Value,PredictBase,CheckNo,Check1,Check2
"p",1,2005/05/31,"R",,,,"RDUSER01",,2005/05/28,2005/04/12 17:30:12:42,13,78,80,2,0,10
"m",1,2005/05/31,"T","*","k1234567​","table01","RDUSER01",1,,,,,,0,,
"m",1,2005/05/31,"T",,"k1234567​","table02","RDUSER01",2,,,,,,0,,
"m",1,2005/05/31,"I","*","k1234567​","index01","RDUSER01",2,,,,,,0,,
"m",1,2005/05/31,"T","*","k1234567​","table10","RDUSER01",2,,,,,,0,,
"d",1,2005/05/31,"T",,"k1234567​","table01","RDUSER01",1,2005/05/28,2005/04/12 17:30:12:42,1,40,50,0,,
"d",1,2005/08/10,"T","*","k1234567​","table10","RDUSER01",1,2005/07/31,2005/04/12 17:30:12:42,1,25,50,0,,
"d",1,2005/06/01,"T","*","k1234567​","table10","RDUSER01",2,2005/05/29,2005/04/12 17:30:12:42,2,25,30,1,50,
"p",2,2005/06/01,"R",,,,"RDUSER12",,2005/05/29,2005/04/12 17:30:12:42,13,78,80,2,0,10
"m",2,2005/06/01,"T","*","k1234567​","table01","RDUSER12",2,,,,,,0,,
"m",2,2005/06/01,"T","*","k1234567​","table03","RDUSER12",2,,,,,,0,,
"m",2,2005/06/01,"I","*","k1234567​","index01","RDUSER12",1,,,,,,0,,
"m",2,2005/06/01,"T","*","k1234567​","table11","RDUSER12",1,,,,,,0,,
"p",3,2005/06/03,"R",,,,"rd0002",,2005/05/30,2005/04/12 17:30:12:42,13,78,80,2,0,10
"m",3,2005/06/03,"R",,,,"rd0002",3,,,,,,0,,
"d",3,2005/06/03,"R",,,,"rd0002",3,2005/05/30,2005/04/12 17:30:12:42,13,78,80,2,0,10
          :