Instances - DB2 DPF - How To

Topics | How To | Related Topics


Modify an Instance

Delete an Instance

Create Backup Sets/Migration Sets

Select a Storage Policy for Third Party User Commands

Configure Third-party Command Line Operations for Encryption

Change the Home Directory

Change Account for Accessing Databases/Applications (DB2 on Windows)

Add a Client/Database Partition to the Instance

Associate a Database Partition with a Different Client


Modify an Instance

Required Capability: See Capabilities and Required Actions

To modify an Instance

  1. From the CommCell Browser, right-click the instance you want to modify, and then click Properties from the shortcut menu.
  2. Click the General tab of the Instance properties box to change the required access information for this instance.
  3. If your agent uses the Accounts tab, use this tab to specify the Windows account used by the system. For MySQL iDataAgent, use this tab to specify the MySQL Server user account.
  4. If your agent uses the Restore View Names tab, use this tab to enter or modify a list of text patterns for the view through which the system displays a database's data documents when you browse.
  5. If your agent has the Security tab, you can view CommCell resource associations to enable or disable user groups that can perform system operations on associated resources.
  6. For an Oracle instance, click the Details tab to change the database connect string and other optional parameters.
  7. For an Oracle RAC instance, go to the next step. Otherwise, go to Step 12.
  8. Click the Details tab, and type or select values for the fields at the bottom of the dialog box as appropriate. For the DB2 DPF instance, to associate a database partition with a different client, click the affected partition in the DB2 Partition Clients field, click Modify, and click from the list in the Edit Directory Share Name Pair dialog box the name of the new client for the partition. Then click OK.
  9. Click the Oracle instance (Client/Instance/Status) that you want to modify. Then click Modify.
  10. In the Update Instance dialog box, update the desired field values by typing or browsing as appropriate. Then click OK.
  11. Repeat the previous two steps for each Oracle instance that you want to modify.
  12. From the Storage Device tab(s), select storage policy copies to be used for, as applicable, data backups, command line data backups and log backups. Within these tabs you can click Data Paths to display the details of the data paths associated with the primary storage policy copy of the selected storage policy.

    For the MySQL iDataAgent, select the storage policy for the log backups from the Log Backups tab.

  13. If your agent uses the Software Compression tab, and you want to enable software compression for the selected backups, click the tab and select the appropriate option.
  14. If you want to enable data encryption, from the Encryption tab select encryption settings for third-party or RMAN command line backups.
  15. Click OK to save the configuration changes.
  16. A message advises you to schedule backups for your new instance. It is recommended you elect to set a schedule now. If you click No, this procedure is now complete. If you click Yes, a dialog box prompts you to back up all subclients of this instance.
  17. Click Yes. The Backup Options dialog box appears, which allows you to create the necessary schedules.
  18. From the Backup Options dialog box, select the type of backup that you want to schedule.
  19. If you want to access Advanced Backup Options, click Advanced.
  20. After selecting the backup type and any advanced options, click OK. The Schedule Details dialog box appears.
  21. From the Schedule Details tab of the Schedule Details dialog box, select the scheduling options that you want to apply, then click OK.

Delete an Instance

Before You Begin

Required Capability: See Capabilities and Required Actions

To delete an instance positioned in the level below the corresponding agent or pseudo-client

  1. From the CommCell Browser, right-click the instance that you want to delete, click All Tasks and then click Delete.
  2. Click Yes to confirm the deletion. (Clicking No cancels the deletion and retains the node.)
  3. Type the requested phrase in the Enter Confirmation Text dialog box and click OK. This should delete the instance.

To delete an Oracle iDataAgent instance included within an Oracle RAC instance (node)

  1. Right-click the Oracle RAC instance, click Properties, and click Details.
  2. Click the instance that you want to delete within Client/Instance/Status and click Delete.
  3. Repeat the previous step for each Oracle iDataAgent instance (except the last one remaining) within the Oracle RAC instance that you want to delete.
  4. Click OK. This should delete the Oracle iDataAgent instance(s).
With the exceptions noted above, you can no longer access the corresponding backup data for restore purposes.

Create Backup Sets/Archive Sets

Required Capability: See Capabilities and Permitted Actions

wedge.gif (136 bytes)To create backup sets/archive sets for the client computer:

  1. From the CommCell Browser, locate the correct client computer node, right-click the iDataAgent, Agent or instance node (depending on your agent's functionality) for which you want the backup set/archive set created, select All Tasks and then click Create New Backup Set or Create New Archive Set.
  2. For most agents, from the Create New Backup Set or Create New Archive Set dialog box, enter a New Backup Set Name or New Archive Set Name (up to 32 characters) of the backup set/archive set that you want to create. For the DB2 or DB2 DPF iDataAgent, from the same dialog box, click the desired database (backup set) name under Available DB Names and move this name under Selection.

    NOTES

  3. Where applicable, if you want to designate this backup set/archive set as the default backup set/archive set, select Make this the Default backup set or Make this the Default Archive Set; otherwise, leave the check box cleared.
  4. For most agents, verify that the storage policy copy associated with the default subclient is the storage policy that you want. If you want to select a different storage policy, click the storage policy box and select the one you want from the list. If the agent supports a system-state subclient, repeat this step for that subclient. For the DB2 or DB2 DPF iDataAgent, to establish a storage policy for all the log files, click the storage policy in the list provided.
  5. Where applicable, if you want to create additional subclients within this backup set/archive set:

    The new backup set/archive set is displayed in the CommCell Browser.

A content example for NetWare File System is SYS:\public, and an example for NDS content is OU=prospects.O=engineering.[Root].

Select a Storage Policy for Third-Party User Commands

Required Capability: See Capabilities and Required Actions

When backing up data through third-party command line functions rather than the CommCell Console, the specific storage policy for the backups of the affected non-Oracle RAC agents is established and maintained through the Creating New Instance screen for the appropriate iDataAgent. For the Oracle RAC iDataAgent, the storage policy is established when you create the associated pseudo-client or when you modify the pseudo-client instance.

To select a storage policy for third-party user commands for non-Oracle RAC agents:

  1. From the CommCell Browser, right-click the supported server/instance icon, click All Tasks, and then click New Instance.
  2. Within the Creating New Instance dialog box, click the Storage Device tab on server/instance properties.
  3. From the Command Line Backup tab, select from the list of existing storage policies
  4. Click OK to save your settings.

To select a storage policy for third-party user commands for the Oracle RAC iDataAgent:

  1. From the CommCell Browser, if you are creating a RAC pseudo-client, right-click Client Computers, click New Client, click RAC Client in the Add New Client dialog box, and then click OK. If you are modifying the pseudo-client instance, right-click the instance and then click Properties.
  2. Click Storage Device.
  3. From the Command Line Backup tab, select from the list of existing storage policies.
  4. Use the other tabs as appropriate to configure the subclient and then click OK to save your settings.

Configure Third-party Command Line Operations for Encryption

Encryption settings made at the instance level for third-party Command Line operations are not related in any way to settings made at the subclient level. Subclient encryption settings are only for data protection and recovery operations run from the CommCell Console.

See Data Encryption - Support for a list of supported products.

Before You Begin

Encryption must be enabled at the client level prior to configuring any instances residing on that client. See Configure the Client for Data Encryption.

Required Capability: Capabilities and Permitted Actions

To configure the instance for encryption of third-party command line operations:

  1. From the CommCell Console, right-click the instance and click Properties.
  2. From the respective Encryption tab, select an option based on the criteria described in the Encryption tab help.
  3. Click OK to save your settings and close the properties dialog box.
For third-party Command Line data recovery operations to succeed when using pass-phrase security, you must export the pass-phrase to the destination client.

 


Change the Home Directory

Required Capability: See Capabilities and Required Actions

To change the Home Directory:

  1. From the CommCell Browser, right-click the icon for any supported instance and then click Properties.
  2. For agents other than Oracle RAC, from the General tab of the Properties dialog box, type the path in the Home or Dir (Directory) box or use Browse to locate the path. Then go to Step 6.
  3. For the MySQL iDataAgent, from the General tab of the Properties dialog box, type the path in the Binary Directory box or use Browse to locate the path. Also, type the path to the MySQL data directory in the Data Directory box or use Browse to locate the path. Then go to Step 6.
  4. For Oracle RAC, from the Details tab of the Properties dialog box, click the appropriate client/instance/status and then click Modify.
  5. In the Update Instance dialog box, enter the path in the Home box or use Browse to locate the path.
  6. Click OK to save your settings.
  7. Continue to make additional settings as desired.

Change Account for Accessing Databases/Applications

Required Capability: See Capabilities and Permitted Actions

To change a user account for accessing DB2 databases:

  1. From the CommCell Browser, expand the tree if necessary to view the desired level icon.
  2. Use the Creating New Instance dialog box to create and configure the instance. Thereafter, from the General tab, click the Change button associated with the User Account information. Then go to Step 5.
  3. From the General tab of the Instance Properties dialog box, click the Change button associated with the User Account information. Then go to Step 5.
  4. From the General tab of the Backup Set Properties dialog box, ensure that the Connect as a Different User option is selected. Then click the Change button associated with the User Account information.
  5. Enter the required information in the Set DB2 User Account dialog box.
  6. Click OK to save the settings.

To change a user account for accessing Oracle or SAP for Oracle applications on Windows not associated with QR Agent:

  1. From the CommCell Browser, expand the tree if necessary to view the desired level icon.
  2. From the General tab, click the Change button associated with the User Account information.
  3. Enter the required information in the Impersonate NT User dialog box.
  4. Click OK to save the settings.

To change a user account for accessing Oracle applications for QR Agent:

  1. From the CommCell Browser, expand the tree if necessary to view the QR agent icon. Then right-click the icon and click Properties.
  2. From the Authentication tab, click the Oracle sub-tab.
  3. From the Oracle sub-tab, either click Add Instance or select an Oracle instance to edit and then click Edit Instance.
  4. From the Add Oracle Instance to QR Agent dialog box, click Change.
  5. Enter the required information in the Impersonate NT User dialog box.
  6. Click OK to save the settings.

To change a user account for accessing Informix, Oracle, or SAP for Oracle applications on Unix:

  1. From the CommCell Browser, expand the tree if necessary to view the desired level icon. From the agent level, right-click the agent icon, click All Tasks from the short-cut menu, click New Instance, and go to the next step. From the instance level, right-click the instance icon, click Properties from the short-cut menu, and go to Step 3.
  2. Use the New Instance dialog box to create and configure the instance.
  3. From the General tab of the Instance Properties dialog box, do one of the following, as appropriate.
  4. Click OK to save the settings.

Add a Client/Database Partition to the Instance

Required Capability: See Capabilities and Required Actions

To add a client/database partition to the DB2 DPF instance:

  1. From the CommCell Browser, right-click the appropriate DB2 DPF instance and then click Properties from the shortcut menu.
  2. Click the Details tab.
  3. In the Add Clients/Client space, click the name of the client that you want to add to the DB2 DPF instance. Then click Add/Refresh. The name of the client and its corresponding database partition(s) should be displayed in the DB2 Partition Clients space.
  4. Repeat this procedure for each client and corresponding partition(s) that you want to include in the DB2 DPF instance.
  5. Click OK to apply the changes.

Associate a Database Partition with a Different Client

Required Capability: See Capabilities and Required Actions

To associate a DB2 DPF database partition with a different client:

  1. From the CommCell Browser, right-click the appropriate DB2 DPF instance and then click Properties from the shortcut menu.
  2. Click the Details tab.
  3. In the DB2 Partition Clients space, click the partition/client pair for the database partition whose client association you want to change and then click Modify.
  4. From the list in the Edit Directory Share Name Pair dialog box, click the name of the new client for the partition. Then click OK.
  5. Repeat this procedure for each partition/client association you want to modify.
  6. Click OK to apply the changes.

Back to Top