SYSVIEW BATCH REPORT For parallelism
Article ID: 120596
Updated On:
Products
SYSVIEW Performance Management Option for DB2 for z/OS
Issue/Introduction
Is there a batch report I can run ? When parallelism is used and SMF records cut,
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.
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
Resolution
Start the Online Report QURYPARA.
Feedback
Yes
No
Powered by
