Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Command Center for Db2 13.2

Estimating backup time


BMC AMI Command Center

 lets you run a Backup Time Estimation report for an object set. This report shows which backup strategies are estimated to fall within the Backup Time Objective (BTO) that you defined. You can create What-If backup time estimations by hypothetically increasing the size or number of objects in the data set and running the report.

To view a Backup Time Estimation report

New console
  1. In the Recovery Management perspective, click the Add View NW_plus_circle_o.png menu arrow, and then select Time Estimation report.
  2. Select Backup Estimation.
  3. In the General section, complete the following fields:

     

    Field

    Description

    Report Name

    Enter a name for the report.

    BTO Target

    Accept the default value or enter the maximum acceptable Backup Time Objective (hh:mm) for this report.

    To define the default value, see Setting-Recovery-Management-options.

    DB2 Connection

    Select a Db2 connection from your list of favorites. If necessary, you can add a connection. See Connecting-to-Db2-subsystems.

    Object Set

    Navigate to and select an object set.

  4. Click Backup.
  5. In the Backup section, accept the default values or enter new values:

     

    Field

    Description

    Outsize

    Specify the size threshold for making copies to an alternate DD or output descriptor.

    Valid values are:

    • 0 through 4294967295 KB
    • 0 through 4194303 MB
    • 0 through 4095 GB

    Note

    If you enter an Outsize value greater than 0, the hybrid elapsed time is the combined time of two estimates.

    Index Size Threshold

    Specify the threshold size at which indexes are backed up rather than rebuilt.

    Valid values are:

    • 0 through 4294967295 KB
    • 0 through 4194303 MB
    • 0 through 4095 GB

    MAXTASKS

    Define the default number of multitasking subtasks that can be performed in parallel when you are making copies. Valid values are 1 through 32.

    Include Indexes

    Select to include indexes in the backup estimation, if they are not already in the object set.

    Select one of the IO factor options

    Select an option:

    • Use a Specific IO Factor: Enter a valid value or accept the displayed value. Valid values are 1 through 10000, and the default is 100. A factor of 0 will calculate a new factor estimate.
    • Calculate IO Factor: Enter the name of a DASD unit, or let the system use SYSALLDA as the default DASD unit. BMC AMI Command Center calculates and uses an IO value based on this DASD unit.

  6. Click Growth.
  7. In the Growth section, accept the default values or enter new values:

     

    Field

    Description

    Number of data sets increased by

    Enter a percentage or number increase to generate a What-If backup estimation based on an increase in the number of data sets. Valid values are 0 through 32767.

    Size of data sets increased by

    Enter a percentage or number increase to generate a What-If backup estimation based on an increase in the size of the data sets. Valid values are 0 through 32767.

  8. Click Generate Report NW_run.png.

    The Time Estimation Report tab is displayed.

     

    RecoveryReportEstimation_bqu1804.png

     

    #

    Description

    Details

    1

    Run button

    Executes the report.

    2

    Tabs

    Categorizes the information as follows:

    • Definition
    • Backup Estimation

    3

    Details about the actual objects

    Indicates the actual number of objects in your selected group, their actual size, and the applicable I/O factor

    4

    Details about the projected objects

    Projects what the number and size of objects would be, based on the What-If percentage or number changes that you entered in the Growth section (see Step 7)

    5

    Recovery Manager options

    Displays the Recovery Manager options

    See Setting-Recovery-Management-options.

    6

    Elapsed time

    Estimates the elapsed time needed for each displayed backup strategy

    Note

    If you enter an Outsize value greater than 0, the hybrid elapsed time is the combined time of two estimates.

    7

    Backup strategy

    Estimates values for multiple backup strategies

    8

    BTO indicator

    Indicates whether the backup time estimation falls within your Backup Time Objective (BTO):

    NW_check_circle_green.png indicates that the time is within your defined BTO.

    NW_exclamation_triangle_orange.png indicates that the time exceeds your BTO.

Classic console
  1. In the Recovery Management perspective, click Add View Add-16.png and select Time Estimation report from the list.The Generate Time Estimation wizard opens.
  2. On the wizard's Step 1 - General page, complete the following fields and click Next:

     

    Field

    Description

    Name

    Enter a name for the report.

    Estimate Backup Time

    Select Estimate Backup Time.

    BTO Target

    Accept the default value or enter the maximum acceptable Backup Time Objective (hh:mm) for this report.

    To define the default value, see Setting-Recovery-Management-options.

    DB2 Connection

    Select a Db2 connection from your list of favorites. If necessary, you can add a connection. See Connecting-to-Db2-subsystems.

    Object Set

    Navigate to and select an object set.

  3. On the wizard's Step2 - Backup page, accept the default values or enter new values and click Next:

     

    Field

    Description

    Outsize

    Specify the size threshold for making copies to an alternate DD or output descriptor.

    Valid values are:

    • 0 through 4294967295 KB
    • 0 through 4194303 MB
    • 0 through 4095 GB

    Note

    If you enter an Outsize value greater than 0, the hybrid elapsed time is the combined time of two estimates.

    Index Size Threshold

    Specify the threshold size at which indexes are backed up rather than rebuilt.

    Valid values are:

    • 0 through 4294967295 KB
    • 0 through 4194303 MB
    • 0 through 4095 GB

    MAXTASKS

    Define the default number of multitasking subtasks that can be performed in parallel when you are making copies. Valid values are 1 through 32.

    Include Indexes

    Select to include indexes in the backup estimation, if they are not already in the object set.

    Use a specific IO Factor

    Enter a value. Valid values are 1 through 10000, and the default is 100. A factor of 0 will calculate a new factor estimate.

    Select one of the IO factor options

    Select an option:

    • Use a Specific IO Factor: Enter a valid value or accept the displayed value. Valid values are 1 through 10000, and the default is 100. A factor of 0 will calculate a new factor estimate.
    • Calculate IO Factor: Enter the name of a DASD unit, or let the system use SYSALLDA as the default DASD unit. BMC AMI Command Center calculates and uses an IO value based on this DASD unit.

  4. On the wizard's Step 3 - Growth page, accept the default values or enter new values:

     

    Field

    Description

    Number of data sets increased by

    Enter a percentage or number increase to generate a What-If backup estimation based on an increase in the number of data sets. Valid values are 0 through 32767.

    Size of data sets increased by

    Enter a percentage or number increase to generate a What-If backup estimation based on an increase in the size of the data sets. Valid values are 0 through 32767.

  5. Click Finish.

    The General, Backup, and Growth tabs are populated and the Time Estimation Report tab is displayed.

     

    RecoveryReport Estimation_high.png

     

    #

    Description

    Details

    1

    Run button

    Executes the report.

    2

    Tabs

    Categorizes the information as follows:

    3

    Details about the actual objects

    Indicates the actual number of objects in your selected group, their actual size, and the applicable I/O factor

    4

    Details about the projected objects

    Projects what the number and size of objects would be, based on the What-If percentage or number changes that you entered in the Growth tab (see Step 4)

    5

    Recovery Manager options

    Displays the Recovery Manager options

    See Setting-Recovery-Management-options.

    6

    Elapsed time

    Estimates the elapsed time needed for each displayed backup strategy

    Note

    If you enter an Outsize value greater than 0, the hybrid elapsed time is the combined time of two estimates.

    7

    Backup strategy

    Estimates values for multiple backup strategies

    8

    BTO indicator

    Indicates whether the backup time estimation falls within your Backup Time Objective (BTO):

    g_gud_Check_16.png indicates that the time is within your defined BTO.

    status_warning.png indicates that the time exceeds your BTO.



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*