Db2 12 for z/OS workfile blocks

Daniel Luksetich

Db2 12 for z/OS workfile blocks
I am looking at some performance information in Omegamon. Fields
QWAC_WORKFILE_MAX and QWAC_WORKFILE_CURR. These represent the maximum and
current workfile blocks is use. What is a "block"? So far, I have only found
references to RID blocks, which are 32KB.

Thanks,

Dan



+--------------------------------------+------------------------------------
-----------------------+

| Daniel L Luksetich | IBM Certified Advanced Database
Administrator - |

| IBM GOLD Consultant | Db2 10.1 for Linux UNIX and
Windows |

| IDUG Content Committee Past-Chairman | IBM Certified Database Adminstrator
- Db2 11 DBA for z/OS |

| IDUG DB2-L Administrator | IBM Certified System Administrator
- Db2 11 for z/OS |

| URL: https://db2expert.com https://db2expert.com | IBM
Certified Application Developer - Db2 11 for z/OS |

+--------------------------------------+------------------------------------
-----------------------+





Attachments

  • image001.png (18.4k)
  • image002.png (16.2k)
  • image003.png (20k)
  • image004.png (21.4k)
  • image005.png (17.8k)
  • image006.png (17.4k)

Daniel Luksetich

Db2 12 for z/OS workfile blocks
(in response to Daniel Luksetich)
OK, best guess at this point is that a workfile "block" is 1K. At least
that's how it appears to be displayed in Omegamon classic interface.



Anyone got another guess?



Thanks,

Dan



+--------------------------------------+------------------------------------
-----------------------+

| Daniel L Luksetich | IBM Certified Advanced Database
Administrator - |

| IBM GOLD Consultant | Db2 10.1 for Linux UNIX and
Windows |

| IDUG Content Committee Past-Chairman | IBM Certified Database Adminstrator
- Db2 11 DBA for z/OS |

| IDUG DB2-L Administrator | IBM Certified System Administrator
- Db2 11 for z/OS |

| URL: https://db2expert.com https://db2expert.com | IBM
Certified Application Developer - Db2 11 for z/OS |

+--------------------------------------+------------------------------------
-----------------------+





From: Daniel L Luksetich <[login to unmask email]>
Sent: Monday, August 12, 2019 10:28 AM
To: [login to unmask email]
Subject: [DB2-L] - Db2 12 for z/OS workfile blocks



I am looking at some performance information in Omegamon. Fields
QWAC_WORKFILE_MAX and QWAC_WORKFILE_CURR. These represent the maximum and
current workfile blocks is use. What is a "block"? So far, I have only found
references to RID blocks, which are 32KB.

Thanks,

Dan



+--------------------------------------+------------------------------------
-----------------------+

| Daniel L Luksetich | IBM Certified Advanced Database
Administrator - |

| IBM GOLD Consultant | Db2 10.1 for Linux UNIX and
Windows |

| IDUG Content Committee Past-Chairman | IBM Certified Database Adminstrator
- Db2 11 DBA for z/OS |

| IDUG DB2-L Administrator | IBM Certified System Administrator
- Db2 11 for z/OS |

| URL: https://db2expert.com https://db2expert.com | IBM
Certified Application Developer - Db2 11 for z/OS |

+--------------------------------------+------------------------------------
-----------------------+







-----End Original Message-----

Attachments

  • image001.png (18.4k)
  • image002.png (16.2k)
  • image003.png (20k)
  • image004.png (21.4k)
  • image005.png (17.8k)
  • image006.png (17.4k)