QZDASOINIT, iSeries ODBC weird behavior

Posted on 2012-09-17
Last Modified: 2012-09-19
We have recently updates our OS from 5.4 to 6.1, and I have found that when the users run an ODBC  program using Microsoft EXCEL , these jobs  QZDASOINIT take too much CPU utilization and seems to do anything, so I need to cancel those.

I wonder if something has changed from one version to the newer one.
Question by:Apolo Victores
    LVL 34

    Accepted Solution

    I've seen queries that perform worse (sometimes much worse) under V6R1 than they did under V5R4, so it is certainly possible.  

    IF you haven't already, I suggest you take a look at the V6R1 Memo To Users, and check out the various database-related changes that occurred in V6R1 that could have an impact.  There were a significant number of SQL-related changes, and some of them could have a performance impact.  "Database Changes' start on page 20.

    A few notes:

    1) The V6R1 SQL Query Engine seems to rely on database statistics more than V5R4 SQE did.  Make sure statistics collection is enabled if the query uses the SQE, and if specific statistics collection is advised after this query runs, then make manual requests to gather the required stats.

    2) I've seen cases where new indexes were advised after the V6R1 upgrade.  Take a look at the Index Advisor, or run a SQL Performance Monitor when the problem queries are running and see if indexes are advised.  If so, test them to determine if building them is warranted.

    3) Make sure that you are up to date on database group PTF's

    The following documents explain how to view statistics and index advice, enable statistics collection, manually request specific statistics, view the SQL Plan Cache, run an SQL Performance Monitor, etc.

    This redbook was written for V5R3, but still contains a lot of good information about diagnosing DB2 for IBM i performance issues:

    This is the DB2 for IBM i V6R1Database Performance and Query Optimization guide:

    If you want help with a specific query, post an SQL Performance Monitor file extract or an SQL Plan Cache snapshot extract.  Let me know if you need instructions for tathering that information.

    - Gary Patterson
    LVL 26

    Expert Comment

    Is there any indication that the same queries run differently after the second or third submission? You might delete any old SQL packages for Excel queries to force them to be recreated.

    What hardware model is your system? How much memory? Can you paste the text copied from a DSPSYSSTS screen?


    Author Closing Comment

    by:Apolo Victores
    THANK YOU!!!  it is really helpful!!!

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    Outlook Free & Paid Tools
    Digital marketing agencies have encountered both the opportunities and difficulties that emerge from working with a wide-ranging organizations.
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now