Db2 Tools

Expand all | Collapse all

log analyzer

Jump to Best Answer
  • 1.  log analyzer

    Posted 12-03-2018 07:07 AM
    We are starting a Project of Big Data. For this, we need pass a lot of modified datas to ETL.
    Run log analyzer with TYPE(IMAGECOPY) result very expensive in elapsed and CPU. 

    ETL only needs extract the data just as the DB2 registers it in the log, without expand to totality of record.

    Can Log Analyzer realize this extract without fase ICOPY?. TYPE (DETAIL) acts more or less like that, but it does not know how to solve compressed logs.

     



  • 2.  Re: log analyzer

    Posted 12-03-2018 10:32 AM

    HI Miquel in answer to your question:

    "Can Log Analyzer realize this extract without fase ICOPY?. TYPE (DETAIL) acts more or less like that, but it does not know how to solve compressed logs."

     

    It depends on the compressed data. If you run Log Analyzer with KEEPDICTIONARY (Y), (in your PLA member of CDBAPARM), then you can run Log Analyzer with  DMLREPT  = (LEVEL    (DETAIL).  Log Analyzer will need IMAGCOPY level of detail if PLA can't decompress the table from the Tablespace Compression Dictionary, that's when you'll have to run PLA with IMAGCOPY level of Detail.  If you have any problems, open a Log Analyzer case for review. 

     

    Robert Lee 



  • 3.  Re: log analyzer

    Posted 12-04-2018 11:18 AM

    Hi Robert,

     

    I had changed KEEPDICTIONARY to Y, but the result is not positive. Almost all updates has been discarted.   

     

    Neither JOB (dynamic allocation) nor Insight trace does'nt shows any access to tablespace in order to read dictionary pages. How I can prove what PLA has try to read this pages?.  Has PLA any debugger o verbose statement? 

     

    Atentament.

     

    M.A. Bernet Triadó

    T-Systems Iberia

    Production (ICTO - POSS)

    C/Marina 347-349 08025 Barcelona

    Tel.: +34 93 300 22 96 (ext.- 46955)

    Mòbil: +34 667 484.912

    E-mail: miquelangel.bernet@t-systems.es

    Internet: www.t-systems.es

    This e-mail and any attachments may contain confidential or privileged information. Any unauthorized copying, use or distribution of this information is strictly prohibited.



  • 4.  Re: log analyzer
    Best Answer

    Posted 12-04-2018 11:25 AM

    Hello Miquel Angel, 

      

    My name is Josep Raull and I work with CA DB2 Tools support in 'CA Technologies A Broadcom Company' in Barcelona office. I will call you to open a Case in CA Support and follow up your questions. 

     

    Thanks. 

     

    Josep Raull

    CA DB2 Tools L1 Support



  • 5.  Re: log analyzer

    Posted 12-04-2018 11:28 AM

    Hi Miquel, in answer to your question

    "How I can prove what PLA has try to read this pages?.  Has PLA any debugger o verbose statement?"

     

    Answer: 

    Currently there is no debugger for Log Analyzer to prove it read the pages. If PLA discards the rows, it may be due to not having Data Capture Changes. The complete row is not in the DB2 Logs, You'll have to use Image Copy Level of Detail to get the complete row.

     

    Robert Lee