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!).
Computer Systems Manager
5 Manhattan West
New York, NY 10001
I just stumbled across the messed-up copy at the IDUG files myself, resulting from a Google search. TYVM for that fixed version.
UPS6756, #1544403 Oleander Drive, Suite CWilmington, NC 28403 Phone: (910) 660-8649Fax: (910) 523-5504