Topic
  • 1 reply
  • Latest Post - ‏2014-09-08T12:50:10Z by alexandre180
andrewmcl
andrewmcl
119 Posts

Pinned topic Threading degree per core

‏2014-08-25T01:03:01Z | degree threading

DB2 10.5 FP1 on Linux VM (SUSE) - Intel 64 bit

What determines the threading degree per core as per below? Also, I understand that BLU Acceleration uses SIMD enabled h/w but does standard (non-BLU) DB2 utilise SIMD?

Where I'm going with this is that I'm trying to determine whether the h/w or the Linux VM is limiting the scope of DB2 

2014-07-18-14.25.05.669243+600 I1E1655               LEVEL: Event
PID     : 1220                 TID : 139684942042912 PROC : db2diag
INSTANCE: db2prdi1             NODE : 000
HOSTNAME: collins
FUNCTION: DB2 UDB, RAS/PD component, pdLogInternal, probe:120
START   : New Diagnostic Log file
DATA #1 : Build Level, 232 bytes
Instance "db2prdi1" uses "64" bits and DB2 code release "SQL10051"
with level identifier "0602010E".
Informational tokens are "DB2 v10.5.0.1", "s130816", "IP23526", Fix Pack "1".
DATA #2 : System Info, 664 bytes
System: Linux collins 0 3 x86_64
CPU: total:8 online:8 Cores per socket:4 Threading degree per core:1 SIMD:N
CPU binding: not in use
Physical Memory(MB): total:32242 free:17279
Virtual  Memory(MB): total:40434 free:25454
Swap     Memory(MB): total:8192 free:8175
Kernel   Params: msgMaxMessageSize:65536 msgMsgMap:65536 msgMaxQueueIDs:31744
                 msgNumberOfHeaders:65536 msgMaxQueueSize:65536
                 msgMaxSegmentSize:16 shmMax:33807601664 shmMin:1 shmIDs:7936
                 shmSegments:7936 semMap:256000 semIDs:7936 semNum:256000
                 semUndo:256000 semNumPerID:250 semOps:100 semUndoSize:20
                 semMaxVal:32767 semAdjustOnExit:32767
Cur cpu time limit (seconds)  = 0xFFFFFFFFFFFFFFFF
Cur file size limit (bytes) = 0xFFFFFFFFFFFFFFFF
Cur data size (bytes)  = 0xFFFFFFFFFFFFFFFF
Cur stack size (bytes)  = 0x0000000000800000
Cur core size (bytes)  = 0x0000000000000000
Cur memory size (bytes) = 0x00000007E5AA4000
nofiles (descriptors)  = 0x0000000000000400

 

  • alexandre180
    alexandre180
    21 Posts

    Re: Threading degree per core

    ‏2014-09-08T12:50:10Z  

    As far as I understand, non BLU DB2 doesn't use SIMD. For the limit, you should first check that your Intel processor uses Hyper Threading. I'm not a system expert but I understand that hyper threading will multiply by 2 the number of processors so it's like a threading degree is 2. But the better is to ask to the system guys.

    Regards,

    Alexandre