I'm using DB2 v9.1 Fix Pak 4 LUW. If I run "db2 list applications". The Applications currently running, I would like to know how much temporary tablespace each App Handle (if any) it's using in bytes or pages.

Is there an SQL or View that I could run to find this information?

Thank you.

CC

db2pd -d <db name> -tcb | grep Temp

db2girl,
I ran the command to find tempspace on the current jobs running. Is the DataSize in bytes or how is it measured? Okay I see this is measured in Pages. I need to convert that to bytes.

Also, I was wondering what the Address was exactly?


db2pd -d psftprod -tcb | grep Temp

Address TbspaceID TableID PartID MasterTbs MasterTab TableName SchemaNm ObjClass DataSize LfSize LobSize XMLSize
0x078000005A566078 37 2 n/a 37 2 TEMP (00037,00002) <815><E1 Temp 4222 0 0 0
0x0780000023CB8078 37 3 n/a 37 3 TEMP (00037,00003) <876><E1 Temp 3 0 0 0
0x0780000023B199F8 37 4 n/a 37 4 TEMP (00037,00004) <121><E1 Temp 453 0 0 0
0x07800000213E31F8 37 5 n/a 37 5 TEMP (00037,00005) <1813><E Temp 6 0 0 0
0x07800003F382A878 37 6 n/a 37 6 TEMP (00037,00006) <815><E1 Temp 228 0 0 0
0x078000005A59DCF8 37 8 n/a 37 8 TEMP (00037,00008) <882><E1 Temp 630 0 0 0


Thank you.

CC

Address in memory. DB2 support/development can use this info when debugging some problems.