InfoSphere Optim

InfoSphere Optim

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  Stability of Optim 11.3 FP6 & FP7

    Posted Tue April 02, 2019 03:43 PM
    At Discover we recently upgraded to Optim 11.3 FP7 and encountered couple issues with respect to Linux loader and Date of Birth masking. IBM has provided fixes and we are in the process of retesting. We are now concerned with FP7 upgrade as we are not sure how stable FP7 is at this point of time. 

    We are now thinking of downgrading to FP6 where many of masking functionalities were working at this point of time. Please let us know if there are any open items which needs to be taken care in FP6?

    Please keep us posted.

    ------------------------------
    Vivek Giridharan
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: Stability of Optim 11.3 FP6 & FP7

    Posted Wed April 03, 2019 12:13 PM

    Hi Vivek,

     

    We implemented Optim FP7 a few months back.  We went through months of extensive "formal testing" for off-the-shelf functionality, due to our heavy compliance requirements. We only experienced a couple of issues that required Optim Support intervention. Other than those few things, we've been without issue for a while now. We're only using Optim for data growth/archiving though.  

     

    Thanks,

    image002.png@01D08979.D80A5BB0

    Danny L. Lankford | Advanced IT Specialist
    IT Quality, Information Technology
    3M Center, 224-4N-4C15 | St. Paul, MN 55144 | United States
    Office: +1 651 733 8489

    dllankford@mmm.com

     

    image002.png@01D12E97.53CFC600image003.png@01D12E97.53CFC600image004.png@01D12E97.53CFC600image005.png@01D12E97.53CFC600image006.gif@01D12E97.53CFC600image007.png@01D12E97.53CFC600

     






  • 3.  RE: Stability of Optim 11.3 FP6 & FP7

    Posted Wed April 03, 2019 12:25 PM
    Hello Danny,

    Thank You for the response!

    1. About the issues mentioned - Whether that was pertaining to any specific sensitive fields? 
    2. Are those issue addressed or still open with IBM?
    3. Linux is our server and issues experienced mostly with loader jobs. IBM provided with fixes last week and we are in the process of retesting. Did you experience any specific issues with respect to Linux? 

    Please keep us posted.

    ------------------------------
    Thanks
    Vivek Giridharan
    ------------------------------



  • 4.  RE: Stability of Optim 11.3 FP6 & FP7

    Posted Wed April 03, 2019 12:31 PM

    Vivek,

     

    No Linux issues. We only experienced an Optim Connect Server issue and a few security config issues. All the other prior issues were addressed in the FixList for FP7. When I built our new environment I shifted us away from Linux and DB2 to Windows and MSSQL for the Optim application OS and Database. New build. Not an upgrade. So our F7 build may not be a good frame of reference for you.

     

    image002.png@01D08979.D80A5BB0

    Danny L. Lankford | Advanced IT Specialist
    IT Quality, Information Technology
    3M Center, 224-4N-4C15 | St. Paul, MN 55144 | United States
    Office: +1 651 733 8489

    dllankford@mmm.com

     

    image002.png@01D12E97.53CFC600image003.png@01D12E97.53CFC600image004.png@01D12E97.53CFC600image005.png@01D12E97.53CFC600image006.gif@01D12E97.53CFC600image007.png@01D12E97.53CFC600

     






  • 5.  RE: Stability of Optim 11.3 FP6 & FP7

    Posted Wed April 03, 2019 12:47 PM
    Thanks Danny for the response !

    ------------------------------
    Vivek Giridharan
    ------------------------------



  • 6.  RE: Stability of Optim 11.3 FP6 & FP7

    Posted Mon April 15, 2019 09:25 AM
    One point worth mentioning - FP07 is not backwards compatible with older versions.
    We experienced issues registering archive file created with FP07 software into environment running 11.3.0.4 DropIn 215.
    So plan your upgrade carefully.

    ------------------------------
    Jan Bartok
    ------------------------------



  • 7.  RE: Stability of Optim 11.3 FP6 & FP7

    Posted Mon April 15, 2019 10:40 AM
    Edited by System Admin Fri January 20, 2023 04:10 PM
    Jan, 

    I've migrated all of our archives and objects from an FP4 environment to the new FP7 environment and all of our formal testing has passed. 

    We are required to formally test off the shelf functionality before we can productively use a software product. See the attached list of requirements and tests. Download it if you can't see the embedded jpg. 

    Take a look at our test results and see if you're having issues with any of the following areas? 

    Component Requirement Name Risk Level Linked Test Name Last Run Exec Status Last Run WF Status Last Run Exec Date
    Requirements\DAAR Requirements\Archive Data The system must show that the test source data and Optim archive data are the same High Verify Archived Data Passed Approved 2018/06/20
    Requirements\DAAR Requirements\Archive Data System must create Immutable archive file. High Verify that data in an archive file cannot be changed from the Optim client Passed Approved 2018/12/19
    Requirements\DAAR Requirements\Archive Data System must create Immutable archive file. High Verify that an archive file is not browsable once it has been modified Passed Approved 2018/12/19
    Requirements\DAAR Requirements\Archive Data System must create Immutable archive file. High Verify that archive data is not modified if the archive XML file is modified Passed Approved 2018/12/19
    Requirements\DAAR Requirements\Archive Data System must show that the source data and Optim archive data are the same. Medium Verify that source data and archived data are same Passed Approved 2018/12/19
    Requirements\DAAR Requirements\Archive Data Ability to move archive files from old system to new system. High Migrate archive files from a legacy DAAR server to a new DAAR server Passed Approved 2019/01/17
    Requirements\DAAR Requirements\Archive Data Ability to archive Native data source. Low Archive data using a native Optim connection Passed Approved 2018/12/19
    Requirements\DAAR Requirements\Archive Data Ability to archive Native data source. Low Create an access definition Passed Approved 2018/12/19
    Requirements\DAAR Requirements\Archive Data Ability to archive Native data source. Low Create an archive request Passed Approved 2018/12/19
    Requirements\DAAR Requirements\Archive Data System must log archiving activities. Medium Confirm that archiving activities are logged by the Optim application Passed Approved 2019/01/17
    Requirements\DAAR Requirements\Archive Data Ability to run simultaneous archiving jobs. Low Run multiple archiving jobs simultaneously Passed Approved 2019/01/17
    Requirements\DAAR Requirements\Archive Data Ability to run archive jobs using the Optim job scheduler. Low Run archive job using the Optim job scheduler Passed Approved 2018/12/20
    Requirements\DAAR Requirements\Archive Data System must be able to link multiple archive files together with an Optim file collection. Low Create an archive file collection Passed Approved 2018/12/19
    Requirements\DAAR Requirements\Archive Data System must produce an Archive report. Medium Verify that an archive process report is produced at the completion of an archive job Passed Approved 2018/12/21
    Requirements\DAAR Requirements\Archive Data System must produce an Archive report. Medium Manually generate an archive process report Passed Approved 2018/12/21
    Requirements\DAAR Requirements\Archive Data Ability to define a delete date for an archive file. High Add a delete date to an archive file Passed Approved 2018/12/19
    Requirements\DAAR Requirements\Archive Data Ability to define a delete date for an archive file. High Change the retention date of an archive file Passed Approved 2018/12/19
    Requirements\DAAR Requirements\Archive Data Ability to report on the scheduled delete dates for archive files. High Generate a delete date archive file report Passed Approved 2018/12/19
    Requirements\DAAR Requirements\Delete Archived Data Ability to delete an archive file. High Manually delete an archive file Passed Approved 2018/12/21
    Requirements\DAAR Requirements\Retrieve Archived Data Ability to search for keyword values in the archive file using the Optim client. Low Search an archive file using keyword search values Passed Approved 2018/12/20
    Requirements\DAAR Requirements\Retrieve Archived Data Ability to restore archive data to a database. High Restore archive data to a SQL database. Passed Approved 2018/12/04
    Requirements\DAAR Requirements\Retrieve Archived Data Ability to browse Archived data. Medium Browse archive data with the Optim client Passed Approved 2018/12/20
    Requirements\DAAR Requirements\Secure Data System must be able to encrypt archive data. High Verify that the ARCHIVES directory is guarded by the Vormetric encryption software Passed Approved 2018/11/28
    Requirements\DAAR Requirements\Secure Data System must be able to encrypt archive data. High Verify that the ARCHIVES directory is encrypted Passed Approved 2018/12/18
    Requirements\DAAR Requirements\Secure Data System must be able to decrypt archive data. High Verify that a file in the ARCHIVES directory can be decrypted Passed Approved 2018/12/18
    Requirements\DAAR Requirements\Secure Data Ability to control the access to archive files. High Verify that the ARCHIVES directory is guarded by the Vormetric encryption software Passed Approved 2018/11/28
    Requirements\DAAR Requirements\Secure Data System shall log archive file access. High Verify that the ARCHIVES directory is guarded by the Vormetric encryption software Passed Approved 2018/11/28
    Requirements\DAAR Requirements\Secure Data System shall log  archive deletions. High Verify that the ARCHIVES directory is guarded by the Vormetric encryption software Passed Approved 2018/11/28
    Requirements\DAAR Requirements\Archive Data Ability to archive Optim test data source Medium Archive Optim Test Data Passed Approved 2018/06/19
    Requirements\DAAR Requirements\Archive Data Ability to archive Non Native data source. Low Archive CSV files Passed Approved 2018/11/30
    Requirements\DAAR Requirements\Delete Archived Data Ability to suspend the "Auto Deletion" archive feature in Optim. High Suspend the auto deletion archive feature in Optim Passed Approved 2018/12/21
    Requirements\DAAR Requirements\Manage Archived Data System must be able to verify the integrity of the archive files. High Verify integrity of the archive files with the FMF file validation tool Passed Approved 2019/01/17


    ------------------------------
    Danny Lankford
    Advanced IT Specialist
    3M
    St Paul MN
    ------------------------------