InfoSphere Optim

 View Only

  • 1.  Optim Archive Issue Debug help

    Posted Fri July 19, 2019 11:15 AM
    We have an archive job that is not deleting the rows as expected after the archive file is created.  There are numerous tables in the job and the archive identifies the rows that are to be archived.  Those counts look correct.  There are only eligible rows in the first 3 tables.  All other tables have 0 rows.  During the delete step, all rows are erroring on the delete.  The control file status column says 'Not all columns in row match'.  Everything we look at matches.  column names, data type, size etc.  our research has included running the sql in sql server management studio and the deletes work fine there.

    Can anyone help?

    Thanks,

    Phil

    ------------------------------
    [Phil] [Neff]
    [Sr. Data Architect]
    [J.B. Hunt]
    [Lowell] [AR]
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: Optim Archive Issue Debug help

    Posted Mon July 22, 2019 07:03 AM
    Are you perhaps using  VIEWs instead of TABLEs in your access definition?

    ------------------------------
    Fred Booker
    ------------------------------

    Original Message


  • 3.  RE: Optim Archive Issue Debug help

    Posted Mon July 22, 2019 08:23 AM
    Fred,

    We are accessing the tables directly.

    ------------------------------
    [Phil] [Neff]
    [Sr. Data Architect]
    [J.B. Hunt]
    [Lowell] [AR]
    ------------------------------

    Original Message


  • 4.  RE: Optim Archive Issue Debug help

    Posted Mon July 22, 2019 03:12 PM
    Edited by System Fri January 20, 2023 04:41 PM
    Are you using the option to compare row contents before deletion? If so, try turning that off unless there is any risk you are updating these rows slated for deletion. 

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

    Original Message