Rocket iCluster

 View Only

iCluster DMACTOBJ: Activating one member at a time

  • 1.  iCluster DMACTOBJ: Activating one member at a time

    ROCKETEER
    Posted 01-29-2021 17:14
    Edited by Bill Shubin 01-29-2021 19:51

    Did you know that you can now activate single member at a time? If your file that was suspended was extremely large with multiple members, and only one member had an issue, this could use up a lot of bandwidth for no reason at all. It was sometimes better to save the entire file to a savefile, and then FTP that file across to the backup node. Now DMACTOBJ allows you to specify a single member name if the RFSH parameter is set to *YES.

    Here is more information in regards to the Refresh object and Physical file refresh method parameters of the command:


    Refresh object (RFSH)
    Indicates whether you want to refresh the object to the backup node when the object is activated.
    This option allows you to activate an object without having to save and restore the object.

    The possible values are:

    *NO - Does not refresh the object on the backup node when the object is activated. In this case, you are responsible for refreshing the object and ensuring that it is synchronized at the time the activation is performed.

    *YES - Refreshes the object on the backup node when the object is activated. This is the default.

    *FIXREC - Refreshes only physical file records that have failed to replicate because of record-level errors that occurred during the backup apply process. Only files that are suspended with the RLE reason code and whose "Max. record level errors" parameter


    Physical file refresh method (PFRFSHMTD)
    Specifies the method of physical file refresh when the object is activated. This parameter is ignored if the RFSH parameter value is not set to *YES.

    The possible values are:

    *RBR - Record by record refresh. This is the default.

    *SAVRST - Refresh by save/restore. The file will be saved with the data and restored on the backup node.
    When the *SAVRST method is used to refresh files, the "Created by user" attribute of a file is retained on the backup node.

    *OBJ - Refresh by the method specified for the object, as determined by the object's specifier, group and the product system values. 

    In our example, we are going to refresh (RFSH=*YES) the USA member in CUSTOMER/PAYROLL file and choose to refresh by a save/restore (PFRFSHMTD=*SAVRST).

    DMACTOBJ


    Note: The DMACTOBJ no longer supports OBJTYPE for *SQLPROC and *SQLFUNC, nor does it support OBJTYPE for *SQLGVAR and *SQLSEQ.


    An extension of this command with the use of generic or *ALL selection for an object name, would also allow you to activate all objects in a specific library.  Even if you have many libraries selected in your replication group, the DMACTOBJ command with the use of the object and library name specification can activate your specific object selection and avoid activating everything in a group and request that action with a single invocation of the command.

    Note: An object does not need to be suspended to be ‘Activated’.  The command will activate all the objects selected with the specified ‘Refresh option’ regardless if they are currently suspended or not.  If the command is submitted with Refresh object = *YES, they will be REFRESHED.  









    ------------------------------
    William Shubin
    Rocket Software
    ------------------------------