ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

V5R3 to V5R4

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    V5R3 to V5R4

    Hi All,

    We are planning to upgrade our production machine from V5R3 to V5R4. So I just wanted to know if anyone has already done it out there and have any suggestions or any know issues that could come up during this upgrade.

    Thanks in advance.
    Regards,
    KR
    Tags: None
  • #2
    Re: V5R3 to V5R4

    We did it over a year ago. Seems the only problem we had was that SQL performance tanked badly. Did some performance tuning, adjusted QAQQINI file, and now runs faster than it ever did with V5R3.

    Make sure you do the pre-req PTF's first.

    Comment

    • #3
      Re: V5R3 to V5R4

      What adjustments did you make to the QAQQINI file to speed it up? I'm curious...

      Comment

      • #4
        Re: V5R3 to V5R4

        1. We changed the IGNORE_DERIVED_INDEX value to *YES. We have hundreds of logicals over most of our most important files, so virtually every large query was being forced to CQE.

        2. Setup a seperate memory pool for QUSRWRK (where most of the larger queries run, and FIXED the size so performance adjust wouldn't take any away.

        3. Took some of the longest running queries and made MQT's instead.

        Comment

        Previous template Next
        Working...
        X