SYSVIEW BATCH REPORT For parallelism

Document ID : KB000120596
Last Modified Date : 08/11/2018
Show Technical Document Details
Introduction:
Is there a batch report I can run ? When parallelism is used and SMF records cut,
Question:
Is there a batch report I can run ?
When parallelism is used and SMF records cut, 1 for parent task and then 1 for child tasks.
I need to know the elapsed time for each child task. IBM recommended Use the record of the child tasks, divide the ElapsedTime by the parallel degree to get some idea how much each parallel task used. If you reduce the degree you will have to divide the time of the tasks you cut across the remaining tasks(degree). For more accurate data you can use IFCID 221 222 231 (parallel execution). That provides a more detailed view of how much ElapsedTtime each parallel task used as some parts of the query may run sequential, or use different parallel degrees.
 
Environment:
z/os DB2
Answer:
Start the Online Report QURYPARA.