LIST.PHANTOMS

The LIST.PHANTOMS command shows a list of currently running phantom processes.

Format

LIST.PHANTOMS {USER username} {POOL poolname}

The LIST.PHANTOMS command displays a summary of currently active phantom processes. It is effectively a subset of the information shown by the LISTU command. For each phantom process, it shows the user number, operating system process id, login name, login time and account name. The login time is shown in the local time zone of the user executing the command.

The optional USER qualifier causes the command to show only phantoms for the specified user name. Except on Windows, the user name is case sensitive.

The optional POOL qualifier causes the command to show only phantoms for the specified connection pool name.

Phantom processes that are running as replication subscribers also show the name of the publisher system from which they are receiving data.

Example

LIST.PHANTOMS

User  Pid          Username              Login time    Account

  2  5001         root                  28 May 07:02  QMSYS

 34  5220         jenny                 28 May 11:24  SALES

LIST.PHANTOMS USER jenny

User  Pid          Username              Login time    Account

 34  5220         jenny                 28 May 11:24  SALES

See also:

CHILD(), PHANTOM, !PHLOG(), STATUS