MIGRATION_NETWORK_BANDWIDTH table function
The MIGRATION_NETWORK_BANDWIDTH table function measures bandwidth between the source and copy nodes for IBM® i Migrate While Active.
This table function creates sample objects and uses save and restore technology to send data to the copy node. The transmission performance details are captured and used to calculate the speed of the available bandwidth. The result values can be different each time the function is invoked.
The results are saved in a table named SYSIBMADM.NETWORK_BANDWIDTH_RESULTS, with a system name of NET_BAND. It contains the same columns that this function returns. The table contains a single row. When the table function is invoked, the row is replaced. The default public authority for the table is *EXCLUDE.
Authorization: The caller must have *ALLOBJ special authority.
- iteration-count
- An integer that indicates the number of times the data is sent to the copy node. A higher number generally results in a somewhat more accurate bandwidth measurement. The default is 3.
| Column Name | Data Type | Description |
|---|---|---|
| CAPTURE_TIME | TIMESTAMP | The timestamp when this row was generated. |
| ITERATION_COUNT | INTEGER | The value of the ITERATION_COUNT parameter. |
| NETWORK_BANDWIDTH | DECIMAL(15,2) | The rate at which data is sent between the source and copy nodes, in megabits per second (Mbps). |
| SAVE_RESTORE_OVERHEAD | DECIMAL(15,2) | The time required to perform a save and restore operation for a single integrated file system (IFS) file, in milliseconds. |
 SAVE_RESTORE_OVERHEAD_LIB |
DECIMAL(15,2) |
The time required to perform a save and restore operation for a
single library-based object, in milliseconds. |
Example
- Check the bandwidth to the copy node. Take the measurement 5 times for calculating the
values.
SELECT * FROM TABLE(QSYS2.MIGRATION_NETWORK_BANDWIDTH(5));