![Start of change](./delta.gif)
FIRMWARE_CURRENCY view
The FIRMWARE_CURRENCY view implements a live comparison of the firmware fix level installed on the partition against the level available through a feed from the Fix Level Recommendation Tool (FLRT).
When queried, the view uses Display Hardware Resources (DSPHDWRSC) and Display Firmware Status (DSPFMWSTS) commands and the JSON_TABLE and HTTPGETCLOB functions to consume a live JSON feed from the Fix Level Recommendation Tool. When querying this view, the job CCSID cannot be 65535 or the query will fail.
The result of the query shows the firmware fix level installed on the partition and the firmware latest fix levels made available by IBM®. It also returns the general information
shown by the DSPFMWSTS command.
Authorization: See Note below.
The following table describes the columns in the view. The system name is FWCUR. The schema is SYSTOOLS.
Column name | System column name | Data type | Description |
---|---|---|---|
FW_CURRENCY | FW_CRNCY | VARCHAR(28) | A description of the firmware status. Values returned are:
|
FW_CURRENT_FIXPACK | FW_FIXPACK | VARCHAR(20) | The current fix level on the partition. |
FW_RELEASE_DATE | FW_GA | DATE | The general availability date of the firmware on the partition. |
FW_MACHINE_TYPE_MODEL | FW_MTM | VARCHAR(20) | The machine type model of the partition. |
FW_RECOMMENDED_UPDATE | FW_RUPD | VARCHAR(20) Nullable
|
The update fix level of the firmware. Contains the null value if no update version is available. |
FW_RECOMMENDED_UPGRADE | FW_RUPG | VARCHAR(20) Nullable
|
The upgrade fix level of the firmware. Contains the null value if no upgrade version is available. |
![]() FW_UPDATE_ACCESS_KEY_
EXPIRATION ![]() |
![]() ![]() |
![]() Nullable
![]() |
![]() Contains the null value if the update access key expiration date is not available. ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]()
![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]()
![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]()
![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]()
![]() |
![]() ![]() |
![]() ![]() |
![]() Nullable
![]() |
![]() Contains the null value if no product ID exists for the active server firmware. ![]() |
![]() ![]() |
![]() ![]() |
![]() Nullable
![]() |
![]() Contains the null value if no product ID exists for the active server firmware. ![]() |
Notes
-
The view requires the system to have access to the internet with the ability to access the FLRT website. The FLRT website is:
https://www14.software.ibm.com/support/customercare/flrt/liteTable?prodKey=fw&format=json
- If the FLRT website is relocated, this view can be updated by the user. Use the Insert Generated SQL feature in ACS to extract the source for the SYSTOOLS.FLRT_FW_INFO table function. Update the link and recreate the table function.
- If any of the CL commands or SQL functions used by the view encounter an error, an error will be returned to indicate the failure. The job log can be examined to determine the root cause of the problem.
- This view is provided in the SYSTOOLS schema as an example of how to retrieve live data using an SQL view and table function. Similar to other Db2® for i provided tools within SYSTOOLS, the SQL source can be extracted and used as a model for building similar interfaces, or to create a customized version within a user-specified schema.
Services provided in SYSTOOLS have authorization requirements that are determined by the interfaces used to implement the service. To understand the authority requirements, extract the SQL for the service and examine the implementation.
Example
Examine the firmware fix level information for the partition.
SELECT * FROM SYSTOOLS.FIRMWARE_CURRENCY;
![End of change](./deltaend.gif)