News
Abstract
IASP vary on performance as been improved.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Performance Enhancements > IASP vary on performance is improved
Improvement in IBM i 7.3 and IBM i 7.4:
The Database cross-reference processing is improved to only rebuild SQL based database catalogs when needed.
Improvement only in IBM i 7.4:
A portion of the Database cross-reference processing is processed asynchronously to the VARY ON, yielding a much faster vary ON.
You can review Database IASP vary on before and after timing via this query:
select v.*
from qsys2.asp_vary_info v
where operation_type = 'VARY ON' and step like '%Database%'
order by duration desc;
Was this topic helpful?
Document Information
Modified date:
21 January 2020
UID
ibm11116567