$helper.renderConfluenceMacro('{bmc-global-announcement:$space.key}')
 
 

Space announcement

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

BMC AMI Command Center for Db2 12.1 ... Using Managing Backup and Recovery Estimating backup or recovery time

Estimating recovery time

BMC AMI Command Center lets you run a Recovery Time Estimation report for an object set. The report shows which recovery strategies are applicable and shows recovery time estimations for (if applicable) backout, forward, and backout auto. The report also shows whether the recovery time estimations fall within the Recovery Time Objective (RTO) that you defined.

To view a Recovery Time Estimation report

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

    Field

    Description

    Report Name

    Enter a name for the report.

    RTO Target

    Accept the default value or enter the maximum acceptable Recovery 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 Recovery.
  5. In the Recovery section, accept the default values or enter new values:

    Field

    Description

    Recovery point

    Accept the current date and time, or enter values.

    Number of Jobs

    Specify the number of jobs in the recovery run. Valid values are 1 (the default) though 99.

    Number of IO Paths (SPE2010)

    If MAXLSORT (tasks) is multiplied by the number of jobs and exceeds the number of IO paths, MAXLSORT is set to the number of IO paths for the calculation.

    Valid values are 1 through 99. The default is 20.

    MAXLSORT

    Specify the maximum number of log sorts that can run concurrently. Valid values are 1 (the default) through 32.

    Include IndexesSelect to include indexes in the backup estimation if they are not already in the object set.

    Rebuild Indexes

    Select to rebuild indexes in the recovery estimation.

    Scope Changed

    (SPE2010)

    		Select to include only objects that were changed since the specified recovery point.

    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 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 recovery 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 recovery estimation based on an increase in the size of the data sets. Valid values are 0 through 32767.

  8. Click Generate Report .

    The Time Estimation report tab is displayed.

    Recovery Time Estimation report

    #

    Description

    Details

    1

    Run button

    Executes the report.

    2

    Tabs

    Categorizes the information as follows:

    • Definition (see Step 3)

    • Recovery Estimation

    • Details

    3

    Actual data

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

    4

    Projected data

    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

    View Details button

    List the objects.

    7

    Backout recovery time estimate

    Shows either the time estimate for the backout recovery strategy or a message indicating why this strategy cannot be executed.

    You can click View Details to view the list of problematic objects.

    8

    Forward

    Shows either the time estimate for the forward recovery strategy or a message indicating why this strategy cannot be executed.

    9Backout AutoEstimates the time needed for the backout auto recovery strategy

    10

    RTO indicator

    Indicates whether the recovery time estimation falls within the Recovery Time Objective (RTO) that you have defined for this report:

    indicates that the time is within your defined RTO.

    indicates that the time exceeds your RTO.

    Note: No indicator is displayed if the strategy cannot be executed.

    Legend
 Classic console
  1. In the Recovery Management perspective, click Add View  and select Time Estimation report from the list.

    The Generate Time Estimation wizard opens.

  2. On the wizard's Step1 - General page, complete the following fields, and click Next.

    Field

    Description

    Name

    Enter a name for the report.

    Estimate Recovery Time

    Select Estimate Recovery Time.

    RTO Target

    Accept the default value or enter the maximum acceptable Recovery 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 Step 2 - Recovery page, accept the default values or enter new values and click Next:

    Field

    Description

    Recovery point

    Accept the current date and time, or enter values.

    Number of Jobs

    Specify the number of jobs in the recovery run. Valid values are 1 (the default) though 99.

    MAXLSORT

    Specify the maximum number of log sorts that can run concurrently. Valid values are 1 (the default) through 32.

    Rebuild Indexes

    Select to rebuild indexes in the recovery estimation.

    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 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 recovery 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 recovery estimation based on an increase in the size of the data sets. Valid values are 0 through 32767.

  5. Click Finish.

    The General, Recovery, and Growth tabs are populated with your input, and the Time Estimation report tab is displayed.

    Recovery Time Estimation report

    #

    Description

    Details

    1

    Run button

    Executes the report.

    2

    Tabs

    Categorizes the information as follows:

    3

    Actual data

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

    4

    Projected data

    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

    View Details button

    List the objects.

    7

    Backout recovery time estimate

    Shows either the time estimate for the backout recovery strategy or a message indicating why this strategy cannot be executed.

    You can click View Details to view the list of problematic objects.

    8

    Forward

    Shows either the time estimate for the forward recovery strategy or a message indicating why this strategy cannot be executed.

    9Backout AutoEstimates the time needed for the backout auto recovery strategy

    10

    RTO indicator

    Indicates whether the recovery time estimation falls within the Recovery Time Objective (RTO) that you have defined for this report:

    indicates that the time is within your defined RTO.

    indicates that the time exceeds your RTO.

    Note: No indicator is displayed if the strategy cannot be executed.

    Legend


Was this page helpful? Yes No Submitting... Thank you
Last modified by Sarig Scudder on Oct 07, 2020
gud_121_spe1 using task ptf_bqu1804 spe2010

Comments

Estimating backup time
Setting Recovery Management options
© Copyright 2013 - 2020 BMC Software, Inc.
Legal notices

Powered by Atlassian Confluence and Scroll Viewport

© Copyright 2005-2020 BMC Software, Inc. Use of this site signifies your acceptance of BMC’s Terms of Use . BMC, the BMC logo, and other BMC marks are assets of BMC Software, Inc. These trademarks are registered and may be registered in the U.S. and in other countries.