> # THREADPOOL Component (THPL) Commands

> ### DISPLAY

> Shows a summary of the threadpool settings.

> Parameters

> SHOW=STAT

> Shows a summary of the threadpool settings and a detailed overview of the threadpool statistics.

> Example

> `THPL,DISPLAY` displays a summary of the Service settings and the DataSource settings for each data source, as shown:

>     ServiceMinThreads(xxx),ServiceMaxThreads(yyy),
>     ServiceThreadLockThreshold
>     ServiceDB2MaxThreads(uuu),ServiceDB2MinThreads(ttt)
>     DataSourceThreadMaxRpc(nnn),
>     DataSourceThreadRpcTimeOut(nnn)

> `THPL,DISPLAY,SHOW=STAT` displays an overview of the threadpool statistics, as shown:

>     Threads    NrOfRPC              NrRPC            CPU            %CPU
>     =======    =======              ========         ===            =====
>     TWORK003   number of RPC's      % of total RPC   CPU seconds    %of total CPU
>     TWORK004   handled by this
>                workerthread
>     ...
>     TWORKnnn   ...

> ### LIST

> Lists the status of all sessions. The maximum number of lines of output for a single invocation of this operator command is 100. The ADDRESS and USERID arguments will further limit the requested output.

> Parameters

> ADDRESS=client Ipaddress

> Identifies the client IP address.

> USERID=userid

> Identifies a userid.

> Both the optional client Ipaddress and the userid parameters can be specified generically.

> Example

> `THPL LIST` lists the status of all sessions, up to a maximum of 100 sessions.

> `THPL LIST USERID=MFI*` lists the status of the sessions with a userid prefixed with MFI.

> `THPL LIST ADDRESS=10.131.*` lists the status of all sessions for which the client IP address begins with 10.131.

> `THPL LIST USERID=MFI*,ADDRESS=10.131.40.59` lists the status of all sessions for userids prefixed with MFI and that have a client IP address of 10.131.40.59.

> ### KILL

> Kills a session.

> Parameters

> ID=session_ID

> Identifies the session that must be stopped. The SessionId can be obtained from the LIST command.

> NOTE: This parameter is required.

> Example

> `THPL KILL ID=2` stops session 2.