THREAD_ID

This global variable contains the thread ID of the current thread.

This global variable has the following characteristics:

It is read-only, with values maintained by system.
The type is BIGINT.
The schema is QSYS2.
The scope of this global variable is session.

Example

Capture the thread scoped record locks over the SALES table which are held by the current thread..

SELECT * FROM QSYS2.RECORD_LOCK_INFO L
  WHERE L.TABLE_NAME = 'SALES' AND 
        L.JOB_NAME = QSYS2.JOB_NAME AND
        L.THREAD_ID = QSYS2.THREAD_ID