Topic
  • 2 replies
  • Latest Post - ‏2012-10-22T11:03:38Z by SystemAdmin
SystemAdmin
SystemAdmin
304 Posts

Pinned topic How to remove rows from an archived file (Optim 7.2.2)

‏2012-10-18T17:01:33Z |
We are using Optim 7.2.2 as our archive solution, and I'm trying to use the command line interface (PR0CMND /AFMF
) to selectively remove rows from a registered Archive File.

The process is working fine, excepted for the tables defined as "Reference Tables" in the Access Definition:

Here is the command line used, and the command file:

// command line
PR0CMND /AFMF OUTPUT=report_test.txt @test.txt

// command file
PSTDIR OPTIMDIR
AF (local) 'D:\Softwares\IBM Optim\data\AARSRVREQ_Jan152011-0011-Copy.AF'
SELCRIT OPTIMDB.SIEBEL.S_SRV_REQ ROW_ID='1-17LS'
RUN REMOVEROWS

If you open the log attached, you will see that the tables S_BU and S_USER (defined as Reference Tables in our Access Definition) are blank in the New Archive File, and we need to keep these tables for the other customers.

Is this the normal behavior ? is there another way to selectively remove rows from a registered Archive File?

Thanks, Mauricio
Updated on 2012-10-22T11:03:38Z at 2012-10-22T11:03:38Z by SystemAdmin
  • TulasiDas
    TulasiDas
    62 Posts

    Re: How to remove rows from an archived file (Optim 7.2.2)

    ‏2012-10-22T00:33:34Z  
    Hi,

    Unfortunately this is a defect on this release and it is fixed in 7.3.1 release. Could you please submit a PMR to get it fixed on Optim 7.2.2 release? Once it is fixed, you will receive an IFIX and that should solve your problem.

    Thanks,
    Tulasi
  • SystemAdmin
    SystemAdmin
    304 Posts

    Re: How to remove rows from an archived file (Optim 7.2.2)

    ‏2012-10-22T11:03:38Z  
    • TulasiDas
    • ‏2012-10-22T00:33:34Z
    Hi,

    Unfortunately this is a defect on this release and it is fixed in 7.3.1 release. Could you please submit a PMR to get it fixed on Optim 7.2.2 release? Once it is fixed, you will receive an IFIX and that should solve your problem.

    Thanks,
    Tulasi
    Hi Tulasi,

    Thanks for your response. I will submit the PMR.

    Thanks,
    Mauricio