InfoSphere Optim

 View Only

  • 1.  Subset an Archive File into another .AF on Windows

    Posted Tue September 11, 2018 04:48 PM
    ​I have a need to subset a large Optim archive file on Windows into a smaller archive file (and retain the original .AF). I have done this on z/OS with no issue in the past. However, on Windows, it appears the functionality exists (at least per the documentation), yet there is no syntax provided to execute this function.

    I pasted a screen shot showing the Optim v11.3 manual and it says you can create archive subsets. But nowhere under the File Maintenance Utility commands does it explain how this is done.

    I did try the 'Remove Row' option because it had instructions and syntax. I just provided the criteria that would result in the rows I cared about in the resulting subset .AF (while also retaining the original .AF). However, that process errors saying PR0MIGR can't load some proc. Having never used this feature before, I'm unaware if this is a known issue or not.

    So to the user community: Has anyone been able to subset an archive file into a smaller .AF using Optim Data Growth LUW? The subset must be an .AF; an extract file (.XF) will not work for me.  

    We're running Optim Data Growth LUW v11.3 FP05 on Windows Server 2012 R2 

    I appreciate the help!



    ------------------------------
    Keith Tidball
    Progressive Insurance
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: Subset an Archive File into another .AF on Windows

    IBM Champion
    Posted Tue September 11, 2018 04:51 PM
    Edited by System Fri January 20, 2023 04:32 PM
    Hello Keith,

    Review below link,

    https://www.ibm.com/support/knowledgecenter/en/SSMLNW_11.3.0/com.ibm.nex.optimd.dg.doc/13cmdline-maint/oparcuse-r-file_maintenance_split.html

    [OPTIMDIR optimdirectory]

    AF {arcservername | (local)} arcfilename

    SPLITAF filename [ SPLITAFX filename]

    DELTAAF filename [ DELTAAFX filename]

    AD adname | { [ SQL dbalias.cid.tblname sql] [VAR variablename value] [ PNS pnsfile] }

    {REGISTER {split | delta}{ (optimdirectory | * ) [GROUP groupidentifier][ DESC description]| NO}

                 | DELETE }

    [COLLECTIONS {split | delta} collection1,...,collectionn]

    RUN ARCHIVESPLIT



    ------------------------------
    Vishwas Balakrishna
    ------------------------------

    Original Message


  • 3.  RE: Subset an Archive File into another .AF on Windows

    IBM Champion
    Posted Tue September 11, 2018 05:02 PM
    Hello Keith,

    Use the Archive split process, we have used this at multiple customer sites.

    https://www.ibm.com/support/knowledgecenter/en/SSMLNW_11.3.0/com.ibm.nex.optimd.dg.doc/13cmdline-maint/oparcuse-r-file_maintenance_split.html

    Command file syntax for the Archive Split process is:

    [OPTIMDIR optimdirectory]

    AF {arcservername | (local)} arcfilename

    SPLITAF filename [ SPLITAFX filename]

    DELTAAF filename [ DELTAAFX filename]

    AD adname | { [ SQL dbalias.cid.tblname sql] [VAR variablename value] [ PNS pnsfile] }

    {REGISTER {split | delta}{ (optimdirectory | * ) [GROUP groupidentifier][ DESC description]| NO}

                 | DELETE }

    [COLLECTIONS {split | delta} collection1,...,collectionn]

    RUN ARCHIVESPLIT



    ------------------------------
    Vishwas Balakrishna
    ------------------------------

    Original Message


  • 4.  RE: Subset an Archive File into another .AF on Windows

    Posted Wed September 12, 2018 07:47 AM

    I have used the process to split an archive for one application, it does perform the split. I found I needed to do it twice, once with a positive selection to get the records into an af and once with a negative selection to get the other records into an af file. That left the original af file, and the two subset af files.

     

    I found that the selection criteria was the most difficult thing to get correct, supplying the SQL to select or not select the records.

    We have plans to use this further in support of event based retention, when an event happens we split the af file and apply a storage profile to the 'evented' records.

    I had examples from 2014 when we did this but my primary group was deleted (so my user home was gone) and the scripts could not be restored. All I can find from that is a parm file with PNS options:

    // SPLIT create a PNS driven subset split

    OPTIMDIR OPTDIR

    AF SERVER1 file2015-05-01_7_05.af

    SPLITAF file2015-05-01_7_05_SPLIT.af

    DELTAAF file2015-05-01_7_05_DELTA.af

    PNS splitIDs.pns

    REGISTER SPLIT * GROUP AAA DESC "SPLIT Test PNS"

    REGISTER DELTA * GROUP AAA DESC "SPLIT Test PNS"

    COLLECTIONS AAA.ALL

    RUN ARCHIVESPLIT

     

     

     

    Thanks,

    Ed Lipson

    Managing Director

    BNY Mellon | 2 Hanson Pl AIM 111-0800 | Brooklyn NY 11217

    Information Lifecycle Management and Database Administration

    T 718.315.4763 |  F 724.540.6622 | C 917.859.5180 | ed.lipson@bnymellon.com

     


    The information contained in this e-mail, and any attachment, is confidential and is intended solely for the use of the intended recipient. Access, copying or re-use of the e-mail or any attachment, or any information contained therein, by any other person is not authorized. If you are not the intended recipient please return the e-mail to the sender and delete it from your computer. Although we attempt to sweep e-mail and attachments for viruses, we do not guarantee that either are virus-free and accept no liability for any damage sustained as a result of viruses.

    Please refer to https://disclaimer.bnymellon.com/eu.htm for certain disclosures relating to European legal entities. We take our data protection and privacy responsibilities seriously and our privacy notice explains how we collect, use and share personal information in the course of our business activities. It can be accessed at the privacy section of www.bnymellon.com.



    Original Message