Scalable Database Server, HiRDB Version 8 Command Reference

[Contents][Index][Back][Next]

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 (0x0d0a).
  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)

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)
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
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

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
           :

[Contents][Back][Next]

[Trademarks]

All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.