view contents of tmp dbspaces?

Posted in 2005

Dave Thacker — Fri, 28 Jan 2005 21:21:04 — source: IIUG Forums & Mailing Lists

We've just had a process consume most of the tmpdbspaces we have set up. We're not sure what app was causing this. Is there a way to take a snapshot and see what temporary tables are in existence? DT -- Dave Thacker Senior Systems Administrator Omni Hotels Reservation Center V:402-952-6535 F:402-334-8013 M: 402-981-4613 (24/7)

↪ replying to Dave Thacker

Floyd Wellershaus — Fri, 28 Jan 2005 23:04:03 — source: IIUG Forums & Mailing Lists

Dave, I wonder, if the temp tables are being stored in your temp dbspaces, assuming you have DBSPACETEMP populated with tempdbs's, maybe an oncheck -pe, which shows tables and objects listed, by dbspace. Then just hunt for the temp dbspace name in the output of the oncheck -pe. Dave Thacker <dthacker@omnihotels.com> wrote: We've just had a process consume most of the tmpdbspaces we have set up. We're not sure what app was causing this. Is there a way to take a snapshot and see what temporary tables are in existence? DT -- Dave Thacker Senior Systems Administrator Omni Hotels Reservation Center V:402-952-6535 F:402-334-8013 M: 402-981-4613 (24/7)

↪ replying to Dave Thacker

Dave Thacker — Fri, 28 Jan 2005 23:32:05 — source: IIUG Forums & Mailing Lists

On Friday 28 January 2005 16:58, you wrote: > Dave, > I wonder, if the temp tables are being stored in your temp dbspaces, > assuming you have DBSPACETEMP populated with tempdbs's, maybe an oncheck > -pe, which shows tables and objects listed, by dbspace. Then just hunt for > the temp dbspace name in the output of the oncheck -pe. That works well. Thanks! DT

Glossary

dbspace