11.4 pdreclaim processing results

If the return code from execution of pdreclaim is 0 or 4, the pdreclaim processing results are output to the standard output.

Organization of this section
(1) Processing results of pdreclaim (-j and -a omitted) (releasing used free pages in a table)
(2) Processing results of pdreclaim (-j or -a specified) (releasing used free segments in a table)
(3) Processing results of pdreclaim (-j and -a omitted) (releasing used free pages in indexes)
(4) Processing results of pdreclaim (-j or -a specified) (releasing used free segments in indexes)
(5) Notes on the processing results

(1) Processing results of pdreclaim (-j and -a omitted) (releasing used free pages in a table)

pdreclaim VV-RR   *** DB RECLAIM ***   YYYY-MM-DD hh:mm:ss [1]

TABLE NAME : USERA.TBL01 [2]
[3]     [4]             [5]          [6]            [7]
No.  RDAREA NAME    PAGE COUNT  SEGMENT COUNT   ACCESS COUNT
 1  USER01             11,832            250         51,051
 2  USER02             10,452            242         51,051

18244 11:02:08 un01  KFPL00739-I Pdreclaim terminated, return code=0

Explanation:
  1. Header for the processing results
    VV-RR: Version, revision number
    YYYY-MM-DD hh:mm:ss: pdreclaim start date and time
  2. Name of the table that was processed
    If the processing was in units of schemas, the information beginning with this item is repeated.
  3. Sequence numbers
  4. Names of the table storage RDAREAs
  5. Numbers of pages released
  6. Numbers of segments that can be released
    Each RDAREA's number of segments that can be released includes not only segments that can be changed to unused segments by releasing used free pages by pdreclaim, but also segments that can be changed to unused segments by the DELETE statement for a table on which the LOCK statement was executed (executing the DELETE statement in the no-log mode automatically places the segments in LOCK-executed status).
  7. Number of pages accessed using the global buffer
    This value includes not only the number of released pages but also the number of actual pages accessed in the extension of release processing. Note that because some management pages that are not subject to release processing might be accessed, the displayed value could be greater than the number of pages containing the corresponding resources.

(2) Processing results of pdreclaim (-j or -a specified) (releasing used free segments in a table)

pdreclaim VV-RR  *** DB RECLAIM ***  YYYY-MM-DD hh:mm:ss [1]

TABLE NAME : USERA.TBL01 [2]
[3]      [4]            [5]            [6]            [7]
No.  RDAREA NAME     PAGE COUNT  SEGMENT COUNT   ACCESS COUNT
 1  USER01                   -            250         17,017
 2  USER02                   -            242         17,017

18250 11:03:20 un01  KFPL00739-I Pdreclaim terminated, return code=0

Explanation:
  1. Header for the processing results
    VV-RR: Version, revision number
    YYYY-MM-DD hh:mm:ss: pdreclaim start date and time
  2. Name of the table that was processed
    If the processing was in units of schemas, the information beginning with this item is repeated.
  3. Sequence numbers
  4. Names of the table storage RDAREAs
  5. Always - when the -j option was specified; number of released pages when the -a option was specified
  6. Numbers of segments released
  7. Number of pages accessed using the global buffer
    This value includes not only the number of released pages but also the number of actual pages accessed in the extension of release processing. Note that because some management pages that are not subject to release processing might be accessed, the displayed value could be greater than the number of pages containing the corresponding resources.

(3) Processing results of pdreclaim (-j and -a omitted) (releasing used free pages in indexes)

pdreclaim VV-RR  *** DB RECLAIM ***  YYYY-MM-DD hh:mm:ss [1]

INDEX NAME : USERA.(PRIMARY0000131193)  [2]
[3]      [4]        [5]      [6]        [7]            [8]
No. RDAREA NAME  PAGE COUNT SEGMENT COUNT ACCESS COUNT COMPACTION
 1 USER01               32             0          227         58
 3 USER02               32             0          227         58

INDEX NAME : USERA.IDX01
No. RDAREA NAME PAGE COUNT SEGMENT COUNT ACCESS COUNT COMPACTION
 1 USER01             891            16        6,259      1,595
 3 USER02             891            16        6,259      1,595

INDEX NAME : USERA.IDX02
No. RDAREA NAME PAGE COUNT SEGMENT COUNT ACCESS COUNT COMPACTION
 1 USER01              97            14          682        174

18246 11:04:10 un01  KFPL00739-I Pdreclaim terminated, return code=0

Explanation:
  1. Header for the processing result
    VV-RR: Version, revision number
    YYYY-MM-DD hh:mm:ss: pdreclaim start date and time
  2. Name of the index that was processed
    If multiple indexes were processed, the information beginning with this item is repeated.
  3. Sequence numbers
  4. Names of the index storage RDAREAs
  5. Numbers of pages released
  6. Numbers of segments that can be released
    Each RDAREA's number of segments that can be released includes not only segments that can be changed to unused segments by releasing used free pages by pdreclaim, but also segments that can be changed to unused segments by the DELETE statement for a table on which the LOCK statement was executed (executing the DELETE statement in the no-log mode automatically places the segments in LOCK-executed status).
  7. Number of pages accessed using the global buffer
    This value includes not only the number of released pages but also the number of actual pages accessed in the extension of release processing. Note that because some management pages that are not subject to release processing might be accessed and release processing might be performed in the upper level pages, the displayed value could be greater than the number of pages containing the corresponding resources.
  8. Number of pages storing the corresponding resources on which page compaction was performed
    Only pages containing remaining entries are subject to page compaction.

(4) Processing results of pdreclaim (-j or -a specified) (releasing used free segments in indexes)

pdreclaim VV-RR  *** DB RECLAIM *** YYYY-MM-DD hh:mm:ss [1]

INDEX NAME : USERA.(PRIMARY0000131193)  [2]
[3]   [4]            [5]        [6]        [7]          [8]
No.  RDAREA NAME PAGE COUNT SEGMENT COUNT ACCESS COUNT COMPACTION
 1  USER01               -             0           44          -
 3  USER02               -             0           44          -

INDEX NAME : USERA.IDX01
No.  RDAREA NAME PAGE COUNT SEGMENT COUNT ACCESS COUNT COMPACTION
 1  USER01               -            16        1,204          -
 3  USER02               -            16        1,204          -

INDEX NAME : USERA.IDX02
No.  RDAREA NAME PAGE COUNT SEGMENT COUNT ACCESS COUNT COMPACTION
 1  USER01               -            14          131          -

18252 11:05:25 un01  KFPL00739-I Pdreclaim terminated, return code=0

Explanation:
  1. Header for the processing results
    VV-RR: Version, revision number
    YYYY-MM-DD hh:mm:ss: pdreclaim start date and time
  2. Name of the index that was processed
    If multiple indexes were processed, the information beginning with this item is repeated.
  3. Sequence numbers
  4. Names of the index storage RDAREAs
  5. Always - when the -j option was specified; number of released pages when the -a option was specified
  6. Numbers of segments released
  7. Number of pages accessed using the global buffer
    This value includes not only the number of released pages but also the number of actual pages accessed in the extension of release processing. Note that because some management pages that are not subject to release processing might be accessed and release processing might be performed in the upper level pages, the displayed value could be greater than the number of pages containing the corresponding resources.
  8. Always - when the -j option was specified

(5) Notes on the processing results

The processing results are output in the order that processing of the resources was completed.

When the -j or -a option is specified, the number of pages released as displayed by pdreclaim may not match the number of pages that can be released (Collect Prearranged Page) that is displayed as the analysis result of pddbst. Also, the number of segments that can be released (processing result of pdreclaim without the -j or -a option specified) may not match the number of segments released (processing result of pdreclaim with the -j or -a option specified). The reasons are explained below.

(a) When a page is expected to be releasable, but pdreclaim is unable to release it
(b) When a page is expected to be nonreleasable, but pdreclaim can release it