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.
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.
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?
M.A. Bernet Triadó
Production (ICTO - POSS)
C/Marina 347-349 08025 Barcelona
Tel.: +34 93 300 22 96 (ext.- 46955)
Mòbil: +34 667 484.912
This e-mail and any attachments may contain confidential or privileged information. Any unauthorized copying, use or distribution of this information is strictly prohibited.
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.
CA DB2 Tools L1 Support
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?"
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.