An IDUG presentation by Adrian Collett (EU16A03):
https://www.idug.org/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=3ae8c332-954f-4df2-a225-8764e777d794&forceDialog=0
James Campbell
On 22 Mar 2022 at 6:00, Roy Boxwell via International DB2 Users G wrote:
> Here's some slides all about Work file usage that I put together as a "single place to find all the info"
>
> If anyone has any other info I will be more than happy to update and add stuff!
>
> I especially like the graphic on the last page from IBMer Peter Hartmann that visually shows the huge differences between PBG and non-PBG work file assignment.
>
> These were extracted from my "Are you happy or are you still deprecated?" by the way
>
> ------------------------------
> Roy Boxwell
> Software Engineering GmbH
> ------------------------------
> -------------------------------------------
> Original Message:
> Sent: Mar 21, 2022 10:37 AM
> From: Philip Sevetson
> Subject: [Db2 z/OS] How Db2 uses workfile tablespaces for a query
>
> Does anyone know where I should be looking, for a deep dive on how Db2 handles externalizing sort and data pages in the bufferpools (and how it reports such things - SMF 101?)?
>
> One of our SQL operations failed, last week, when it encountered an SMS "Unable to extend tablespace" message. Db2 reported that the temp workfile was "full," and rolled back the SQL.
>
> I cannot, from the message, tell whether _all_ of the tablespaces backing BP4K01 were full, or whether only one was full. I'm hoping there's a discussion about what DB2 does (and hopefully how to look at the numbers; what processes are locking how many pages, and maybe _where_ they are locking pages (what workdatabase tablespaces!).
>
>
>
>
> Philip Sevetson
Original Message:
Sent: 3/22/2022 2:00:00 AM
From: Roy Boxwell
Subject: RE: [Db2 z/OS] How Db2 uses workfile tablespaces for a query
Here's some slides all about Work file usage that I put together as a "single place to find all the info"
If anyone has any other info I will be more than happy to update and add stuff!
I especially like the graphic on the last page from IBMer Peter Hartmann that visually shows the huge differences between PBG and non-PBG work file assignment.
These were extracted from my "Are you happy or are you still deprecated?" by the way
------------------------------
Roy Boxwell
Software Engineering GmbH
------------------------------
Original Message:
Sent: Mar 21, 2022 10:37 AM
From: Philip Sevetson
Subject: [Db2 z/OS] How Db2 uses workfile tablespaces for a query
Does anyone know where I should be looking, for a deep dive on how Db2 handles externalizing sort and data pages in the bufferpools (and how it reports such things – SMF 101?)?
One of our SQL operations failed, last week, when it encountered an SMS "Unable to extend tablespace" message. Db2 reported that the temp workfile was "full," and rolled back the SQL.
I cannot, from the message, tell whether _all_ of the tablespaces backing BP4K01 were full, or whether only one was full. I'm hoping there's a discussion about what DB2 does (and hopefully how to look at the numbers; what processes are locking how many pages, and maybe _where_ they are locking pages (what workdatabase tablespaces!).
Philip Sevetson
Computer Systems Manager
FISA-OPA
5 Manhattan West
New York, NY 10001
psevetson@fisa-opa.nyc.gov
917-991-7052 m
212-857-1659 f
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**