Chapter 25 Task List (tsklist) - Teradata Database

Task List utility, tsklist, displays information about PDE processes and their tasks. This is useful for identifying which programs and tasks are running.

Scenarios Runs From

Task List runs from the Linux command line.

For general information on starting the utilities from different interfaces, see Appendix B: “Starting the Utilities”

Scenarios Syntax

Syntax element	Description
-a	Includes all programs, including PDE system programs, which are those in the node vproc and in partition 0. By default, only TPA programs are shown.
-b	Shows only busy tasks. As a diagnostic aid, the database identifies tasks that are doing work with a flag indicating that they are busy. Usually only busy tasks are of interest when debugging database tasks. Generally, idle tasks are waiting to receive a message giving them work to do. By default, all selected programs and tasks are listed, whether or not they are busy.
-i	Disables the resolving of task addresses to their corresponding function names. By default, tsklist resolves tasks addresses.
-l	Shows traces in long form, with nearly all available fields for each program and task being displayed on multiple lines. The default is to show a one-line display of the most important fields.
-p partition	Shows only programs in the specified partition number. The default is to show programs in all partitions.
-r relvpr	Shows only programs in the specified node-relative vproc number. The node vproc is always relvpr 0; other vprocs running on the node have ascending numbers in the order in which they were started. Although -r and -v are not mutually exclusive in a strict sense, only programs that match all criteria specified are selected. So if -r and -v specify different vprocs, no programs will be selected.
-s	Shows only a summary of the programs that are running, without any details on the tasks they contain. The default is to show all tasks in the programs selected in addition to the program-level information.
-S	Shows Priority Scheduler information for each task.
-v vprid	Shows only programs in the specified vproc. Although -r and -v are not mutually exclusive in a strict sense, only programs that match all criteria specified are selected. So if -r and -v specify different vprocs, no programs will be selected.
prgname	Shows only program(s) where the program name starts with the provided characters. For example, if prgname is pde, then pdemain and pdevproc information would display. The comparison is case insensitive. The -a option is implied.

Scenarios Examples

The following examples are from a test system with two AMPS and one PE.

Example  

Task List running in summary mode to show only non-PDE process information.

     > tsklist -s

     Part:  7  ProcessID: 3edd  VprocID(RelVpr): 0(1)      Flags: 4100  scpstart

     Part:  8  ProcessID: 3edf  VprocID(RelVpr): 0(1)      Flags: 4100  utadvtsk

     Part:  9  ProcessID: 3ecf  VprocID(RelVpr): 0(1)      Flags: 4100  fsustart

     Part: 11  ProcessID: 3ed7  VprocID(RelVpr): 0(1)      Flags: 4100  actmain

     Part: 15  ProcessID: 3ec4  VprocID(RelVpr): 0(1)      Flags: 4100  sssmain

     Part: 17  ProcessID: 3ecb  VprocID(RelVpr): 0(1)      Flags: 4100  sssrss

     Part:  7  ProcessID: 3ede  VprocID(RelVpr): 1(2)      Flags: 4100  scpstart

     Part:  8  ProcessID: 3ee0  VprocID(RelVpr): 1(2)      Flags: 4100  utadvtsk

     Part:  9  ProcessID: 3ed5  VprocID(RelVpr): 1(2)      Flags: 4100  fsustart

     Part: 11  ProcessID: 3ed8  VprocID(RelVpr): 1(2)      Flags: 4100  actmain

     Part:  7  ProcessID: 3ee1  VprocID(RelVpr): 16383(3)  Flags: 4100  scpstart

     Part:  8  ProcessID: 3ee4  VprocID(RelVpr): 16383(3)  Flags: 4100  rtsmain

     Part: 12  ProcessID: 3ee3  VprocID(RelVpr): 16383(3)  Flags: 4100  sestsk

     Part: 13  ProcessID: 3ee2  VprocID(RelVpr): 16383(3)  Flags: 4100  disstart

     Part: 10  ProcessID: 3ebf  VprocID(RelVpr): 8192(4)   Flags: 4100  gtwgateway

Example  

Task List running in summary mode to show all processes.

     > tsklist -as

     Part:  0  ProcessID: 3e85  VprocID(RelVpr): 16384(0)  Flags:  880  pdemain

     Part:  0  ProcessID: 3eb5  VprocID(RelVpr): 16384(0)  Flags: 4184  segmain

     Part:  0  ProcessID: 3eb6  VprocID(RelVpr): 16384(0)  Flags: 4184  cfgmain

     Part:  0  ProcessID: 3ec1  VprocID(RelVpr): 16384(0)  Flags: 4184  dmp

     Part:  0  ProcessID: 3ec0  VprocID(RelVpr): 16384(0)  Flags: 4104  dbgsrvr

     Part:  0  ProcessID: 3ec2  VprocID(RelVpr): 16384(0)  Flags: 4104  csp

     Part:  0  ProcessID: 3ed9  VprocID(RelVpr): 16384(0)  Flags: 4104  udfsrvtsk

     Part:  0  ProcessID: 3eda  VprocID(RelVpr): 16384(0)  Flags: 4104  udfsrvtsk

     Part:  0  ProcessID: 3edb  VprocID(RelVpr): 16384(0)  Flags: 4104  udfsrvtsk

     Part:  0  ProcessID: 3edc  VprocID(RelVpr): 16384(0)  Flags: 4104  udfsrvtsk

     Part:  2  ProcessID: 3ebd  VprocID(RelVpr): 16384(0)  Flags: 4100  cnscim

     Part:  7  ProcessID: 3ec3  VprocID(RelVpr): 16384(0)  Flags: 4100  cspslave

     Part:  0  ProcessID: 3ebb  VprocID(RelVpr): 0(1)      Flags: 4000  pdevproc

     Part:  7  ProcessID: 3edd  VprocID(RelVpr): 0(1)      Flags: 4100  scpstart

     Part:  8  ProcessID: 3edf  VprocID(RelVpr): 0(1)      Flags: 4100  utadvtsk

     Part:  9  ProcessID: 3ecf  VprocID(RelVpr): 0(1)      Flags: 4100  fsustart

     Part: 11  ProcessID: 3ed7  VprocID(RelVpr): 0(1)      Flags: 4100  actmain

     Part: 15  ProcessID: 3ec4  VprocID(RelVpr): 0(1)      Flags: 4100  sssmain

     Part: 17  ProcessID: 3ecb  VprocID(RelVpr): 0(1)      Flags: 4100  sssrss

     Part:  0  ProcessID: 3ebc  VprocID(RelVpr): 1(2)      Flags: 4000  pdevproc

     Part:  7  ProcessID: 3ede  VprocID(RelVpr): 1(2)      Flags: 4100  scpstart

     Part:  8  ProcessID: 3ee0  VprocID(RelVpr): 1(2)      Flags: 4100  utadvtsk

     Part:  9  ProcessID: 3ed5  VprocID(RelVpr): 1(2)      Flags: 4100  fsustart

     Part: 11  ProcessID: 3ed8  VprocID(RelVpr): 1(2)      Flags: 4100  actmain

     Part:  7  ProcessID: 3ee1  VprocID(RelVpr): 16383(3)  Flags: 4100  scpstart

     Part:  8  ProcessID: 3ee4  VprocID(RelVpr): 16383(3)  Flags: 4100  rtsmain

     Part: 12  ProcessID: 3ee3  VprocID(RelVpr): 16383(3)  Flags: 4100  sestsk

     Part: 13  ProcessID: 3ee2  VprocID(RelVpr): 16383(3)  Flags: 4100  disstart

     Part: 10  ProcessID: 3ebf  VprocID(RelVpr): 8192(4)   Flags: 4100  gtwgateway

Example  

Task List running to show task information on programs running in partition 15.

     > tsklist -p 15

     Part: 15  ProcessID: 3ec4  VprocID(RelVpr): 0(1)  Flags: 4100  sssmain

      Pid: 01000490  TaskID: 0001  Flags: 1000  main is paused

      Pid: 01000610  TaskID: 0002  Flags: 0     (admin) is in adminwait

      Pid: 01007210  TaskID: 0006  Flags: 0     sssacctg is in msgwait

Example  

Task List running to show task information on programs running in partition 15 in long format.

> tsklist -l -p 15

      Part: 15  ProcessID: 3ec4  VprocID(RelVpr): 0(1)  Flags: 4100  sssmain

          KPart: e0000001173c8bc0  Seq: 0  Tasks: 3

          Admin: KTCB: e000000114a67600  ReqKTCB: e000000114a66058  Args:

       Pid: 01000490  TaskID: 0001  Flags: 1000  main is paused

          KTCB: e000000114a67398  Handle: 0000000000007d98  Dbg: 0  Prio: 0

          WakeReason: 0  WakeCode: 10193  WorkType: 254  WorkEst: 0

          FSG: nios=0  preios=0  logios=2  nsegs=0   SEG: nsegs=2

       Pid: 01000610  TaskID: 0002  Flags: 0  (admin) is in adminwait

          KTCB: e000000114a67600  Handle: 0000000000007da6  Dbg: 0  Prio: 0

          WakeReason: 0  WakeCode: 10193  WorkType: 254  WorkEst: 0

          FSG: nios=0  preios=0  logios=0  nsegs=0   SEG: nsegs=0

       Pid: 01007210  TaskID: 0006  Flags: 0  sssacctg is in msgwait

          KTCB: e0000001162a5920  Handle: 0000000000007f26  Dbg: 0  Prio: 0

          WakeReason: 0  WakeCode: 10193  WorkType: 254  WorkEst: 0

          FSG: nios=0  preios=0  logios=0  nsegs=0   SEG: nsegs=0

Example  

Task List running in summary mode to show only programs, the names of which start with pde. This shows that a case-insensitive comparison is performed.

     > tsklist -s pDe

     Part:  0  ProcessID: 3e85  VprocID(RelVpr): 16384(0)  Flags: 880   pdemain

     Part:  0  ProcessID: 3ebb  VprocID(RelVpr): 0(1)      Flags: 4000  pdevproc

     Part:  0  ProcessID: 3ebc  VprocID(RelVpr): 1(2)      Flags: 4000  pdevproc

Example  

Task List running to show only pdemain task information.

     > tsklist pdemain

     Part:  0  ProcessID: 3e85  VprocID(RelVpr): 16384(0)  Flags: 880  pdemain

       Pid: 00000190  TaskID: 0001  Flags: 0  main is busy running

       Pid: 00000310  TaskID: 0002  Flags: 0  logd is busy in syscall

       Pid: 00000610  TaskID: 0006  Flags: 0  tparesetd is busy in tdnio

       Pid: 00001210  TaskID: 0007  Flags: 0  msgkevd_start is busy in msgevd

       Pid: 00001390  TaskID: 0008  Flags: 0  msgkmsg_main is busy in msgwait

       Pid: 00001810  TaskID: 000b  Flags: 0  trad_mainloop is busy in traread

       Pid: 00003790  TaskID: 0010  Flags: 0  rssd is busy in syswait

Example  

Task List running to show only pdemain task information.
The -i option is used here to disable the resolving of task addresses to their corresponding names.

tsklist -i pdemain

     Part:  0  ProcessID: 3e85  VprocID(RelVpr): 16384(0)  Flags: 880  pdemain

       Pid: 00000190  TaskID: 0001  Flags: 0  main is busy running

       Pid: 00000310  TaskID: 0002  Flags: 0  0x40000000000a0fa0 is busy in syscall

       Pid: 00000610  TaskID: 0006  Flags: 0  0x400000000004e750 is busy in tdnio

       Pid: 00001210  TaskID: 0007  Flags: 0  0xc000000000e154d0 is busy in msgevd

       Pid: 00001390  TaskID: 0008  Flags: 0  0x400000000009b3f0 is busy in msgwait

       Pid: 00001810  TaskID: 000b  Flags: 0  0x400000000002f260 is busy in traread

       Pid: 00003790  TaskID: 0010  Flags: 0  0x400000000007e000 is busy in syswait