Optim - Test Data Management and Archiving

Expand all | Collapse all

Optim Archive Request Dynamic File Name

  • 1.  Optim Archive Request Dynamic File Name

    Posted Tue October 27, 2020 10:03 AM
    Hi , 

    I use PR0CMND command for triggering a Archive Request job from CMD.
    But I like to give a name to archive file someting like : ARCHIVE_<DATABASE_NAME>_<SYSDATE>.AF
    Is there any parameter to set archive file name ? 
    If there is not , what do you suggest for it? 

    Thank you ,

    ------------------------------
    Gunes INAL
    ------------------------------


  • 2.  RE: Optim Archive Request Dynamic File Name

    Posted Tue October 27, 2020 10:42 AM





  • 3.  RE: Optim Archive Request Dynamic File Name

    Posted Tue October 27, 2020 10:44 AM
    Also, you can achieve database parameter using shell scripting and for date parameter,  Optim had macros which can be used.

    Thanks and regards,
    Vishwas Balakrishna
    Estuate, Inc. Princeton, NJ

    On Oct 27, 2020, at 10:41, Vishwas Balakrishna <vishwas.balakrishna@estuate.com> wrote:


    This email contains confidential material prepared for the intended addressees only and it may contain intellectual property of Estuate, Inc, its affiliates or a third party. This material may not be suitable for, and we accept no responsibility for, use in any context or for any purpose other than for the intended context and purpose. If you are not the intended recipient or if we did not authorize your receipt of this material, any use, distribution or copying of this material is strictly prohibited and may be unlawful. If you have received this communication in error, please return it to the original sender with the subject heading "Received in error," then delete any copies.





  • 4.  RE: Optim Archive Request Dynamic File Name

    Posted Fri October 30, 2020 06:07 AM
    Hi Vishwas , 

    Thank you for your answer, I already checked theese links.
    I assume I need to use an OVERRIDE file , but I could not use OV parameter .


    My arcihve request  command ; 
    "C:\IBM\InfoSphere\Optim\rt\bin\PR0CMND /R TYPE=ARCHIVE REQUEST=DWH_T19C.ARC_MUST_V1 OUTPUT=D:\WORK\Process Reports\DWH_TEST_19C\Process_Report_ARC_DWH19C_TEST_MUSTERI_30-10-2020-50k_V1.txt Q- M+ OV=D:\DWH_TEST_19C_OV_FILE.txt"

    My OV file 
    "XFFILE D:\WORK\ARCHIVE\DWH_TEST19C_ARCHIVE\DWH_MUSTERI_ARCHIVE\ARC_DWH_TEST19C_DB_MUST_30-10-2020_50k_V1.AF"

    I also tried ; 
    "AFFILE D:\WORK\ARCHIVE\DWH_TEST19C_ARCHIVE\DWH_MUSTERI_ARCHIVE\ARC_DWH_TEST19C_DB_MUST_30-10-2020_50k_V1.AF"

    Can you tell me where did I make it wrong ?

    ------------------------------
    Gunes INAL
    ------------------------------



  • 5.  RE: Optim Archive Request Dynamic File Name

    Posted Fri October 30, 2020 09:16 AM
    Hi all , 

    I figured out where my problem is. There is a gap in the path that i used for output file.
    It is working that way ; 

    C:\IBM\InfoSphere\Optim\rt\bin\PR0CMND /R TYPE=ARCHIVE REQUEST=DWH_T19C.ARC_MUST_V1 OUTPUT=D:\WORK\Process_Reports\DWH_TEST_19C\Process_Report_ARC_DWH19C_TEST_MUSTERI_30-10-2020-50k_V3.txt OV=D:\DWH_TEST_19C_OV_FILE.txt Q- M+


    OV FILE ;

    AFFILE D:\WORK\ARCHIVE\DWH_TEST19C_ARCHIVE\DWH_MUSTERI_ARCHIVE\ARC_DWH_TEST19C_DB_MUST_30-10-2020_50k_V2.AF

    ------------------------------
    Gunes INAL
    ------------------------------