Ansicht
Dokumentation

04928 - ABAP SELECT Inner Joins + V4R5M0 - Update

04928 - ABAP SELECT Inner Joins + V4R5M0 - Update

BAL_S_LOG - Application Log: Log header data   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.
SAP E-Book

ABAP SELECT Inner Joins + V4R5M0 - Update

Hello Brian!

I hope you have made a SAV22 before the IBMers installed any
test PTFs and "such things".
Removing this stuff should be done by "reinstalling the operating system".
We did this one one of our machines some time ago. Very easy!
Restoring a SAV22ed OS+PTF image can be the only safe
way to get rid of real test PTFs.

Fingers crossed (and BTW recovered from flu)
Rudi

-----Ursprüngliche Nachricht-----
Von: Brian Zugel [mailto:Brian_ZugelZc...]
Gesendet: Montag, 4. Februar 2002 19:28
An: sap400Zm...
Betreff: ABAP SELECT Inner Joins + V4R5M0 - Update



All,

As several people wanted me to post any progress on this issue, here it is:

We opened a PMR # with IBM, which prompted this issue to go straight to
development. The DB2 developers gained access to our systems while we
executed the offending ABAP code. As we originally thought this was an
issue with a SELECT...INNER JOIN, we executed an SQL Trace while the IBMers
collected this information they needed from the SQL Optimizer. They quickly
determined that it wasn't an issue with a SELECT ... INNER JOIN, but with
very large ABAP statements in general; the developers stated that, in our
example, we were exceeding the maximum size of a single SQL statement at the
DB2 level (this was a SELECT FROM x INNER JOIN y FOR ALL ENTRIES IN <itab>).

Over the course of a few days, they provided us with the following list of
PTFs:

5769SS1
SF66593
SF66374
SF65817
SF62621
SF66848
5869999
MF24711
MF27278

I believe the last 2 required us to bounce the system to be applied.

The odd bit was that at some point an IBM developer created several objects
on our system manually. They are putting together 1 last (we hope) PTF to
replace these objects (which, I suspect, are table indexes). I will post
just what that PTF is when we receive, install, and test it. IBM will
remove these objects just before we install this PTF. We were then told by
IBM that this "solved our problem".

We have our fingers crossed! I hope this helps some of you - if so, please
let me know!

Brian Zugel
SAP America



[Non-text portions of this message have been removed]


Durban Tours - Südafrika Safari

BAL_S_LOG - Application Log: Log header data   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

Length: 2985 Date: 20240623 Time: 200413     sap01-206 ( 3 ms )