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

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.

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

Thank you Charlie and Tom, your suggestions are good enough to start.

Regards.

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

I’m preparing for future access, thank you Tom.

Now I’m reading your suggestions.

Regards.

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 http://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

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.

Here is a very, very, very good link to stuff regarding System i:
https://www.ibm.com/developerworks/wikis/display/WikiPtype/IBM+i

DanF