SFP_TRANSCEIVER_INFO view
The SFP_TRANSCEIVER_INFO view returns Small Formfactor Pluggable (SFP) optical transceiver information for natively attached Fibre Channel (FC) adapters. Information is returned for the adapter port and for the attached port.
This function is supported only on Broadcom adapters implementing the SLI (Service Level Interface) 4 interface and the Marvell QLogic adapters. This function is not supported on Broadcom adapters implementing the SLI 3 interface or virtual Fibre Channel adapters.
To protect I/O performance, the collection of this information is only performed if at least eight hours have elapsed since the previous collection. If the service is called within eight hours of the previous collection, cached data from the previous collection is returned.
Authorization: The caller must have *IOSYSCFG special authority or be authorized to the QIBM_IOSYSCFG_VIEW function usage identifier.
The following table describes the columns in the view. The system name is SFP_INFO. The schema is QSYS2.
| Column Name | System Column Name | Data type | Description |
|---|---|---|---|
| RESOURCE_NAME | RESOURCE | VARCHAR(10) | The unique system-assigned name of the adapter. |
| RESOURCE_TYPE | TYPE | VARCHAR(4) | Adapter device type. |
| SERIAL_NUMBER | SERIAL | VARCHAR(15) | Adapter serial number. |
| PORT_NUMBER | PORT_NBR | INTEGER | Adapter port number. |
| PORT_ADDRESS | PORT_ADDR | CHAR(6) | A string of hexadecimal characters representing the adapter port’s address within the switched fabric. |
| WWPN | WWPN | CHAR(16) Nullable
|
A string of hexadecimal characters representing the adapter port’s world-wide
port name. Contains the null value if no world-wide port name is available for this adapter port. |
| DATA_CAPTURE_TIMESTAMP | CAPTURED | TIMESTAMP(0) | The timestamp, in local time, when the information returned for this row was collected. A new set of values is only generated after eight hours has elapsed since the prior data capture time. |
| TEMPERATURE | TEMP | DECIMAL(6,3) | Adapter port transceiver temperature, in degrees Celsius. |
| VOLTAGE | VOLTAGE | DECIMAL(3,2) | Adapter port transceiver supply voltage, in volts. |
| TX_BIAS | TX_BIAS | DECIMAL(6,3) | Adapter port transceiver TX bias current, in milliampere (mA). |
| TX_POWER | TX_POWER | DECIMAL(5,4) | Adapter port transceiver TX output power, in milliwatts (mW). |
| RX_POWER | RX_POWER | DECIMAL(5,4) | Adapter port transceiver RX received optical power, in milliwatts (mW). |
| TEMPERATURE_HIGH_ALARM | TEMP_HA | DECIMAL(6,3) | Adapter port transceiver temperature high alarm, in degrees Celsius. |
| TEMPERATURE_LOW_ALARM | TEMP_LA | DECIMAL(6,3) | Adapter port transceiver temperature low alarm, in degrees Celsius. |
| TEMPERATURE_HIGH_WARNING | TEMP_HW | DECIMAL(6,3) | Adapter port transceiver temperature high warning, in degrees Celsius. |
| TEMPERATURE_LOW_WARNING | TEMP_LW | DECIMAL(6,3) | Adapter port transceiver temperature low warning, in degrees Celsius. |
| VOLTAGE_HIGH_ALARM | VOLT_HA | DECIMAL(3,2) | Adapter port transceiver supply voltage high alarm, in volts. |
| VOLTAGE_LOW_ALARM | VOLT_LA | DECIMAL(3,2) | Adapter port transceiver supply voltage low alarm, in volts. |
| VOLTAGE_HIGH_WARNING | VOLT_HW | DECIMAL(3,2) | Adapter port transceiver supply voltage high warning, in volts. |
| VOLTAGE_LOW_WARNING | VOLT_LW | DECIMAL(3,2) | Adapter port transceiver supply voltage low warning, in volts. |
| TX_BIAS_HIGH_ALARM | TXB_HA | DECIMAL(6,3) | Adapter port transceiver TX bias current high alarm, in milliampere (mA). |
| TX_BIAS_LOW_ALARM | TXB_LA | DECIMAL(6,3) | Adapter port transceiver TX bias current low alarm, in milliampere (mA). |
| TX_BIAS_HIGH_WARNING | TXB_HW | DECIMAL(6,3) | Adapter port transceiver TX bias current high warning, in milliampere (mA). |
| TX_BIAS_LOW_WARNING | TXB_LW | DECIMAL(6,3) | Adapter port transceiver TX bias current low warning, in milliampere (mA). |
| TX_POWER_HIGH_ALARM | TXPOW_HA | DECIMAL(5,4) | Adapter port transceiver TX output power high alarm, in milliwatts (mW). |
| TX_POWER_LOW_ALARM | TXPOW_LA | DECIMAL(5,4) | Adapter port transceiver TX output power low alarm, in milliwatts (mW). |
| TX_POWER_HIGH_WARNING | TXPOW_HW | DECIMAL(5,4) | Adapter port transceiver TX output power high warning, in milliwatts (mW). |
| TX_POWER_LOW_WARNING | TXPOW_LW | DECIMAL(5,4) | Adapter port transceiver TX output power low warning, in milliwatts (mW). |
| RX_POWER_HIGH_ALARM | RXPOW_HA | DECIMAL(5,4) | Adapter port transceiver RX received optical power high alarm, in milliwatts (mW). |
| RX_POWER_LOW_ALARM | RXPOW_LA | DECIMAL(5,4) | Adapter port transceiver RX received optical power low alarm, in milliwatts (mW). |
| RX_POWER_HIGH_WARNING | RXPOW_HW | DECIMAL(5,4) | Adapter port transceiver RX received optical power high warning, in milliwatts (mW). |
| RX_POWER_LOW_WARNING | RXPOW_LW | DECIMAL(5,4) | Adapter port transceiver RX received optical power low warning, in milliwatts (mW). |
| VENDOR_NAME | VENDOR | VARCHAR(16) | Adapter port transceiver vendor name |
| VENDOR_PART_NUMBER | VEND_PN | VARCHAR(16) | Adapter port transceiver vendor part number. |
| VENDOR_SERIAL_NUMBER | VEND_SN | VARCHAR(16) | Adapter port transceiver vendor serial number. |
| ATTACHED_PORT_ADDRESS | A_PORTADDR | CHAR(6) Nullable
|
A string of hexadecimal characters representing the address of the port attached
to the adapter within the switched fabric. Contains the null value if there is no attached side. |
| ATTACHED_WWPN | A_WWPN | CHAR(16) Nullable
|
A string of hexadecimal characters representing the attached port’s world-wide
port name. Contains the null value if no world-wide port name is available for this adapter port or there is no attached side. |
| ATTACHED_TEMPERATURE | A_TEMP | DECIMAL(6,3) Nullable
|
Attached port transceiver temperature, in degrees Celsius. Contains the null value if there is no attached side. |
| ATTACHED_VOLTAGE | A_VOLTAGE | DECIMAL(3,2) Nullable
|
Attached port transceiver supply voltage, in volts. Contains the null value if there is no attached side. |
| ATTACHED_TX_BIAS | A_TX_BIAS | DECIMAL(6,3) Nullable
|
Attached port transceiver TX bias current, in milliampere (mA). Contains the null value if there is no attached side. |
| ATTACHED_TX_POWER | A_TX_POWER | DECIMAL(5,4) Nullable
|
Attached port transceiver TX output power, in milliwatts (mW). Contains the null value if there is no attached side. |
| ATTACHED_RX_POWER | A_RX_POWER | DECIMAL(5,4) Nullable
|
Attached port transceiver RX received optical power, in milliwatts
(mW). Contains the null value if there is no attached side. |
| ATTACHED_TEMPERATURE_HIGH_ALARM | A_TEMP_HA | DECIMAL(6,3) Nullable
|
Attached port transceiver temperature high alarm, in degrees Celsius. Contains the null value if there is no attached side. |
| ATTACHED_TEMPERATURE_LOW_ALARM | A_TEMP_LA | DECIMAL(6,3) Nullable
|
Attached port transceiver temperature low alarm, in degrees Celsius. Contains the null value if there is no attached side. |
| ATTACHED_TEMPERATURE_HIGH_WARNING | A_TEMP_HW | DECIMAL(6,3) Nullable
|
Attached port transceiver temperature high warning, in degrees
Celsius. Contains the null value if there is no attached side. |
| ATTACHED_TEMPERATURE_LOW_WARNING | A_TEMP_LW | DECIMAL(6,3) Nullable
|
Attached port transceiver temperature low warning, in degrees
Celsius. Contains the null value if there is no attached side. |
| ATTACHED_VOLTAGE_HIGH_ALARM | A_VOLT_HA | DECIMAL(3,2) Nullable
|
Attached port transceiver supply voltage high alarm, in volts. Contains the null value if there is no attached side. |
| ATTACHED_VOLTAGE_LOW_ALARM | A_VOLT_LA | DECIMAL(3,2) Nullable
|
Attached port transceiver supply voltage low alarm, in volts. Contains the null value if there is no attached side. |
| ATTACHED_VOLTAGE_HIGH_WARNING | A_VOLT_HW | DECIMAL(3,2) Nullable
|
Attached port transceiver supply voltage high warning, in volts. Contains the null value if there is no attached side. |
| ATTACHED_VOLTAGE_LOW_WARNING | A_VOLT_LW | DECIMAL(3,2) Nullable
|
Attached port transceiver supply voltage low warning, in volts. Contains the null value if there is no attached side. |
| ATTACHED_TX_BIAS_HIGH_ALARM | A_TXB_HA | DECIMAL(6,3) Nullable
|
Attached port transceiver TX bias current high alarm, in milliampere (mA).
Contains the null value if there is no attached side. |
| ATTACHED_TX_BIAS_LOW_ALARM | A_TXB_LA | DECIMAL(6,3) Nullable
|
Attached port transceiver TX bias current low alarm, in milliampere (mA).
Contains the null value if there is no attached side. |
| ATTACHED_TX_BIAS_HIGH_WARNING | A_TXB_HW | DECIMAL(6,3) Nullable
|
Attached port transceiver TX bias current high warning, in milliampere (mA).
Contains the null value if there is no attached side. |
| ATTACHED_TX_BIAS_LOW_WARNING | A_TXB_LW | DECIMAL(6,3) Nullable
|
Attached port transceiver TX bias current low warning, in milliampere (mA).
Contains the null value if there is no attached side. |
| ATTACHED_TX_POWER_HIGH_ALARM | A_TXPOW_HA | DECIMAL(5,4) Nullable
|
Attached port transceiver TX output power high alarm, in milliwatts (mW).
Contains the null value if there is no attached side. |
| ATTACHED_TX_POWER_LOW_ALARM | A_TXPOW_LA | DECIMAL(5,4) Nullable
|
Attached port transceiver TX output power low alarm, in milliwatts (mW).
Contains the null value if there is no attached side. |
| ATTACHED_TX_POWER_HIGH_WARNING | A_TXPOW_HW | DECIMAL(5,4) Nullable
|
Attached port transceiver TX output power high warning, in milliwatts (mW).
Contains the null value if there is no attached side. |
| ATTACHED_TX_POWER_LOW_WARNING | A_TXPOW_LW | DECIMAL(5,4) Nullable
|
Attached port transceiver TX output power low warning, in milliwatts
(mW). Contains the null value if there is no attached side. |
| ATTACHED_RX_POWER_HIGH_ALARM | A_RXPOW_HA | DECIMAL(5,4) Nullable
|
Attached port transceiver RX received optical power high alarm, in milliwatts
(mW). Contains the null value if there is no attached side. |
| ATTACHED_RX_POWER_LOW_ALARM | A_RXPOW_LA | DECIMAL(5,4) Nullable
|
Attached port transceiver RX received optical power low alarm, in milliwatts
(MW). Contains the null value if there is no attached side. |
| ATTACHED_RX_POWER_HIGH_WARNING | A_RXPOW_HW | DECIMAL(5,4) Nullable
|
Attached port transceiver RX received optical power high warning, in milliwatts
(mW). Contains the null value if there is no attached side. |
| ATTACHED_RX_POWER_LOW_WARNING | A_RXPOW_LW | DECIMAL(5,4) Nullable
|
Attached port transceiver RX received optical power low warning, in milliwatts
(mW). Contains the null value if there is no attached side. |
| ATTACHED_VENDOR_NAME | A_VENDOR | VARCHAR(16) Nullable
|
Attached port transceiver vendor name. Contains the null value if there is no attached side. |
| ATTACHED_VENDOR_PART_NUMBER | A_VEND_PN | VARCHAR(16) Nullable
|
Attached port transceiver vendor part number. Contains the null value if there is no attached side. |
| ATTACHED_VENDOR_SERIAL_NUMBER | A_VEND_SN | VARCHAR(16) Nullable
|
Attached port transceiver vendor serial number. Contains the null value if there is no attached side. |
Example
SELECT * FROM QSYS2.SFP_TRANSCEIVER_INFO;