Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2007
    Posts
    84

    Unanswered: Bytes of Temp Tablespace

    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

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    db2pd -d <db name> -tcb | grep Temp

  3. #3
    Join Date
    Feb 2007
    Posts
    84

    Bytes of Temp Tablespace

    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
    Last edited by rockycj; 10-19-10 at 12:54. Reason: I found what DataSize represents.

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by rockycj View Post
    I was wondering what the Address was exactly?
    Address in memory. DB2 support/development can use this info when debugging some problems.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •