CA Datacom

Expand all | Collapse all

Programs not using keys, monitor the creation of temporary indexes

Jump to Best Answer
  • 1.  Programs not using keys, monitor the creation of temporary indexes

    Posted 06-21-2016 10:00 AM

    As part of a proposed review I would like to carry out an investigation to see if the correct usage of Datacom keys is being adhered to in our CA IDEAL software. We suspect that there may be cases where keys are not being used correctly and/or temporary indexes are being created. How can I monitor this issue in real time and after the fact in order to build a business case for a request for a maintenance project?



  • 2.  Re: Programs not using keys, monitor the creation of temporary indexes
    Best Answer

    Posted 06-21-2016 10:27 AM

    David,

    look at the Accounting tables, specifically the CBSOR reasons, if you are on R14, page in Admin guide is page 960 on interpreting the temporary index reasons.

    I have defined this for each IDEAL site I have worked on.  Ideal support can also help how to interpret the CBSOR field.  you will probably want to mainly run this all the time in your testing environments and only turn it on, when you suspect a problem in production.  The accounting tables can be turned on or off, dynamically, once the table is defined to your multi-user start up parms.



  • 3.  Re: Programs not using keys, monitor the creation of temporary indexes

    Posted 06-21-2016 11:26 AM

    Thanks Bob, appreciate the information!



  • 4.  Re: Programs not using keys, monitor the creation of temporary indexes

    Posted 05-15-2017 08:13 AM

    TEC1175232 created from this question.