Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Performance of a batch job (cobol db2)
- Thread starter krishrad
- Start date
fredericofonseca
IS-IT--Management
whenever asking this type of questions, it is necessary to state OS used (and version) and also DB2 version.
As you stated on your other post that it its on a Mainframe, then there are lots of ways to do it, although some not very easy to use.
As a first step, see if your shop has DB2-Insight.
This will tell you which packages run, what was the IO performed (e.g. number of pages read, updates/fetches/selects) and some other useful information. You have to then look at it and see which packages took longer to run.
The history information is normally held for a few days in many shops, so it should still be available.
As Marc said, you also need to look at the plan table of the packages involved, and look out of lack of index access(or poor index usage), merge scans, hybrid joins and such.
Depending on your version of DB2, you may also be able to avail of IBM Performance Expert. See IBM.com for information on the available IBM tools, and also read the manuals available at here you will find all the information you need about your version of DB2, along with IBM tools to help you.
Regards
Frederico Fonseca
SysSoft Integrated Ltd
As you stated on your other post that it its on a Mainframe, then there are lots of ways to do it, although some not very easy to use.
As a first step, see if your shop has DB2-Insight.
This will tell you which packages run, what was the IO performed (e.g. number of pages read, updates/fetches/selects) and some other useful information. You have to then look at it and see which packages took longer to run.
The history information is normally held for a few days in many shops, so it should still be available.
As Marc said, you also need to look at the plan table of the packages involved, and look out of lack of index access(or poor index usage), merge scans, hybrid joins and such.
Depending on your version of DB2, you may also be able to avail of IBM Performance Expert. See IBM.com for information on the available IBM tools, and also read the manuals available at here you will find all the information you need about your version of DB2, along with IBM tools to help you.
Regards
Frederico Fonseca
SysSoft Integrated Ltd
- Thread starter
- #5
- Status