Using the Global Channel Info dialog box

The Global Channel Info dialog box contains information about the current global channel process within Microsoft SQL Server, the operating system process id of the osql command used by this global channel, and the PATROL specific information about the global channel. This menu command uses the get_chan_info() function, and it returns PATROL specific channel information in a string with the following format:
name status details type scope read_pid read_name write_pid write_name

The following table provides descriptions and examples for the items in this string:

Item

Description

Name

Name of the channel

Status

PIPE

Details

The process id of the external operating system process to which the channel is attached or -1 if the process has terminated

Type

PIPE

Scope

SHARED

read_pid

One of the following values:

  • Process id of the PSL process waiting to read from the channel
  • -1 if no process is waiting to read from channel

read_name

One of the following values:

  • Name of the process waiting to read from the channel
  • NONE if no process is waiting
  • UNAVAILABLE if there is an unnamed process waiting to read from channel

write_pid

One of the following values:

  • Process id of the PSL process waiting to write to the channel
  • -1 if no process is waiting

write_name

One of the following values:

  • Name of the process waiting to write to the channel
  • NONE if no process is waiting
  • UNAVAILABLE if there is a process waiting to write to the channel, but the name of the process is unavailable

 

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*