Tunning and Testing DB2 and Cobol

Anbudan · New User Joined: 07 Sep 2005 Posts: 26 Location: Germany

Hi

Regarding Tunning, I need some info:
1)what are the tools are available?
2)without tools, how we can do DB2 Testing and Tunning? Also cobol pgm

P.S: Don't post a message that

Search in the forum.

Because I search in the forum and get

www.ibmmainframes.com/forum/search.php?mode=results

But, I need more information

If anyone give me a answer more practically, I will be happy.

Regards
Anbudan

paulstephen · New User Joined: 20 Oct 2005 Posts: 20 Location: Chennai

Hi,
Here are some tips for tunning ur cobol + db2 program
1) In the sql's used check out if the column names in where clauses have indexes, if not check out if an index can be created.
2) Try to avoid joins, if not able to avoid try to have them on keys.
3) Sort the i/p data accordingly that for the same i/p u dont hit the database again and again.
4) Thru DB2MON check if a particular querry is taking extra ordinarilly more time.
These are some of the means...
As far as testing u can use expeditor.

Anbudan · New User Joined: 07 Sep 2005 Posts: 26 Location: Germany

Thank you paulstephen
for your reply.

Btw,

Anyone know the book link for Tmap?

Regards
Jesu