DB2 Tuning link or manual for AS400

2790 pts.
Tags:
AS/400
AS/400 DB2
IBM DB2
Hi, In the company I work for we have a requeriment for tuning DB2 in as400. We still don't know the server release, but I wanted to start searching for any documentation about that. I will appreciate any link or suggestions. Thank you. Regards.

Software/Hardware used:
db2, as400

Answer Wiki

Thanks. We'll let you know when a new response is added.

For SQL use
System i Navigator’s Run SQL Scripts
This will give you estimates on how long a SQL will take to run and will also make suggestions as to indexes to build.

Discuss This Question: 11  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • CharlieBrowne
    Are you asking about overall system performance. Then you can look at the IBM perrformace tools, or one of the many packages availale by different vendors. If you are asking about good DB design for your tables, then the answer is to look into using SQL to build and maintain tables and indexes. Your file design should be in 3rd normal form. That's my opinion
    41,380 pointsBadges:
    report
  • Mariodlg
    Thank you Charlie. Maybe sql queries performance is the most important in this moment. Later we need to apply any techniques adquired in DB2 for other platforms, like AIX or Windows. I don't know if the performance tools you said are for any platform or just as400. Can you recommend one ? Thanks.
    2,790 pointsBadges:
    report
  • TomLiotta
    I suggest that you start with the Performance and query optimization topic in the V5R4 Information Center. Then review the items listed under Database Related information. Some RedBooks/RedPieces and web sites listed there should help. For example, the IBM DB2 for i page has a variety of links, especially under the Getting Started and the Support tabs. Tom
    125,585 pointsBadges:
    report
  • Mariodlg
    Thank you Charlie and Tom, your suggestions are good enough to start. Regards.
    2,790 pointsBadges:
    report
  • TomLiotta
    We still don't know the server release... Sometimes the easiest thing to do is to look at the upper left corner of a spooled joblog. The OS product ID comes first, e.g., 5722SS1. And version comes immediately after that, e.g., V5R4M0. Of course, if you don't have access to spooled files, that won't help much. What types of access do you have? Or are you preparing for future access? Tom
    125,585 pointsBadges:
    report
  • Mariodlg
    I'm preparing for future access, thank you Tom. Now I'm reading your suggestions. Regards.
    2,790 pointsBadges:
    report
  • DanTheDane
    1. to find releaselevel: GO LICPGM + opt 10 + F11. 2. to tune a system it is top-relevant to get an overveiw of bottlenecks in the running system including your applications. Look at www.giapa.com where you can read about the GiAPA program, which can help you in finding the pieces that will give you the most +performance if adjusted/modified. Start out with their free X-Ray offering. DanF
    2,555 pointsBadges:
    report
  • Mariodlg
    [...] DB2 Tuning link or manual for AS400 [...]
    0 pointsBadges:
    report
  • Mariodlg
    [...] Have any links or resources for DB2 tuning for AS/400 to add to those offered by CharlieBrowne, TomLiotta, and [...]
    0 pointsBadges:
    report
  • Meandyou
    IBM would be the place I would start researching ... IBM Information Center has the most-up-to-date info: http://www.ibm.com/support/publications/us/library/ search for tuning guide or admin guide or ... for your OS & DB2 version When I started working with DB2 (back in the dark ages) the absolute most beneficial resource was the User Groups - the closest one was 100 miles South of here but it was worth attending. Then I started attending a User Group 200 miles North of here and it too was worth it. Then a few of us started our own user group in this local and we drew people from 60 miles in all directions. So look around for a User Group in your area or maybe contact a few other DB2 shops and start your own.
    5,220 pointsBadges:
    report
  • DanTheDane
    Here is a very, very, very good link to stuff regarding System i: https://www.ibm.com/developerworks/wikis/display/WikiPtype/IBM+i DanF
    2,555 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following