15.00 - Chapter 25 Task List (tsklist) - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

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