Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Cached access path not available

Hi,

i'm confused about one of my systems.

The tac db2 / Installations Parameters shows

EDM DBD cache size (MB) 0

EDM DSC cache size (MB) 0

But the TIJUZ runs with

EDMDBDC=127378

EDMSTMTC=300000

And in db2 / Statement Cache Statistics shows for every statement the message "Cached access path not available".

What's wrong with this system ?

This system is a copy of a production system with the same parameters but only a third of RAM on the lpar.

tia

Kay

Not what you were looking for? View more on this topic or Ask a question