WWR2 : Creating IBM Storage Fusion products : Configuring your IBM Storage Fusion HCI solution : Report tab
Report tab
The Report tab includes selectable spreadsheets that summarize details of the product’s configuration, licenses, parts, weight requirements, and operating environment.
The following reports are displayed in the Report tab.
▪Summary: The Summary tab shows the total quantity of Compute, GPU, and AFM servers per rack and in total. It also displays the raw and effective capacity configured in various units.
▪Compute and Storage: The Compute and Storage spreadsheet shows two tables.
 – The upper table shows the calculation of the available CPU cores and memory after all the overhead is considered.
 – The lower table shows the resulting effective capacity in six units, after all the overhead is subtracted from the various components.
▪Licenses: The Licenses spreadsheet contains three sections.
 – The first section shows the number of virtual processor core (VPC) entitlements that are needed for the IBM Storage Fusion HCI Appliance Software.
 – The middle section shows the IBM Storage Fusion HCI Primary Storage and IBM Storage Fusion HCI Backup Storage information.
 – The last section shows the core-based OpenShift Container Platform licenses that are needed for this configuration. The information displayed depends on the selection in the Include Red Hat OCP license field in the Solution tab.
▪Parts List: The Parts List spreadsheet shows a detailed list of all machine type models (MTMs), product identifiers (PIDs), Feature Codes, and descriptions of products that are configured in Storage Modeller. This list shows what will be included in the CFR file that is then imported into e-config. If the CFR gets rejected, refer to “What to do if your pre-sales CFR file is rejected” on page 196 for help.
▪Weight Requirements: The Weight Requirements tab shows a table that contains the weight, in pounds (lbs) and kilograms (kgs), of the physical components in the solution in a per-rack and total basis. Be aware that the sum of the weight of each rack may not match the total when Spine Switches exist in the solution.
▪Operating Environment: The Operating Environment tab shows a table that contains the energy consumption (kW) and the cooling (BTU/hr) of the components in the solution in a per-rack and total basis. Be aware that the sum of the power consumption and cooling of each rack may not match the total when Spine Switches exist in the solution.
What to do if your pre-sales CFR file is rejected
During the Pre-sale review, neither the IMPACT package, nor the configuration in StorM can be edited. They are marked as Read Only.
If the review revealed significant problems with the configuration, it will be sent back to the requester with the status Failed - Needs more work. In that case, both the IMPACT package and the product's configuration in StorM are editable again. All CFR files previously uploaded to Question 1 are removed from it, but will stay in the Attachments section as a rejected configuration for documentation purposes.
Please correct the configuration based on the reviewer's feedback and upload a new set of completed CFR files to Question 1 of the Pre-sale checklist, before you submit the review request.
For certain products, the StorM-generated CFR files have to be imported into e-config first. All validation warnings have to be addressed to make the configuration complete.
Creating a DB2 Warehouse configuration
IBM Storage Fusion HCI System configurations for Db2 Warehouse is part of IBM's next generation of on-premises analytics solutions and a follow-on to the IBM PureData System for Operational Analytics (PDOA) and the IBM Integrated Analytics System (IIAS) appliances based on IBM Db2 Warehouse software. It comes preconfigured and ready to go with everything clients need to optimize the total cost of ownership (TCO) of their environment.
The solution, which is offered in four configuration sizes, combines an optimized stack of IBM hardware and IBM software to simplify the deployment of warehouse and analytical environments.
The base configuration includes:
▪ One IBM Storage Fusion HCI System rack (9155-R42)
▪ Two 100 GbE NVIDIA/Mellanox storage switches (9155-S01)
▪ Two 1 GbE NVIDIA/Mellanox management switches (9155-S02)
▪ Three Storage Fusion HCI System x86 control nodes (9155-C01)
▪ From 4 to 13 Storage Fusion HCI System x86 worker nodes (9155-C05)
▪ One KVM Console (9155-TF5)
▪ Storage Fusion container-native OpenShift data services (5771-PP7)
Overview
Data explosion is producing 15+ ZB of new data every year and creating new business opportunities for IT solutions--from edge devices to multiple clouds--to glean new insights in real time. With increasing volume, velocity, and variety of data, it is now more challenging than ever for organizations running mission-critical operations to access data to gain insights in real time. To support real-time insights across all your data, you need a trusted, scalable, and highly performant data warehouse solution that can handle complex workloads.
To help meet this need, IBM launched IBM Db2 Warehouse, an award-winning environment for cloud and container-enabled data warehouses. It supports deployment on-premises, in private clouds, or in public clouds. This high-performance capability leverages in-memory processing of data warehouse workloads and allows for the querying of compressed data.
With IBM Storage Fusion HCI System configurations for Db2 Warehouse, IBM offers clients an integrated analytics system that provides a complete solution for modern, high-performance data warehouse workloads. IBM Storage Fusion HCI System for Db2 Warehouse bundles software, servers, services, and support to enable clients to get a modern warehouse up and running quickly and efficiently.
Starting with a base rack, the Fusion HCI System architecture can scale up and out to multi-rack solutions as your data capacity and performance requirements grow.
Storage Fusion HCI System base racks are available in four configurations optimized for Db2 Warehouse: HCI-07, HCI-10, HCI-13, and HCI-16. Clients can start with an HCI-07 configuration and grow to HCI-10, HCI-13, and HCI-16 configurations to handle increasing workloads. Up to 3 base racks can be clustered together to grow data warehousing capabilities and workloads in a linear, predictable manner.
HCI System Configurations
Storage Fusion HCI Systems feature a dedicated 100 GbE storage network with redundant switches and server connectivity to enable workloads to stay up in the event of switch or NIC failure. NVMe drives in the storage rich servers are virtualized with container-native 4+2p Erasure Coding accessed with industry standard CSI drivers.
Storage Fusion container-native data services (5771-PP7) include:
▪ Support for RWO and RWX PVs with a scale-out high-performance parallel file system
▪ Declarative policy driven backup and restore services that support both crash consistent and application backup and restore
▪ Several methods for achieving cluster high availability
▪ Data catalog to index and tag data for data science applications
The following Fusion HCI System configurations have been validated as optimal for use with Db2 Warehouse:
HCI-07 - 7-node configuration (Small).
Component
Quantity
Configuration Notes
9155-C01 (32c)
3
Control nodes
· Ten (10) 7.68 TB NVMe drives per node
· 256 GB memory per node
9155-C05 (64c)
3
Active worker nodes
· Ten (10) 7.68 TB NVMe drives per node
· 1024 GB memory per node
9155-C05 (64c)
1
Stand-by worker node
· Ten (10) 7.68 TB NVMe drives per node
· 1024 GB memory per node
9155-R42
1
42u rack with PDUs
9155-S01
2
100 GbE High Speed dedicated storage network switches
9155-S02
2
1 GbE management switches
9155-TF5
1
KVM console
5771-PP7
256 VPC
Storage Fusion software (64 VPC per worker node)
 
HCI-10 - 10-node configuration (Medium)
Component
Quantity
Configuration Notes
9155-C01 (32c)
3
Control nodes
· Ten (10) 7.68 TB NVMe drives per node
· 256 GB memory per node
9155-C05 (64c)
6
Active worker nodes
· Ten (10) 7.68 TB NVMe drives per node
· 1024 GB memory per node
9155-C05 (64c)
1
Stand-by worker node
· Ten (10) 7.68 TB NVMe drives per node
· 1024 GB memory per node
9155-R42
1
42u rack with PDUs
9155-S01
2
100 GbE High Speed dedicated storage network switches
9155-S02
2
1 GbE management switches
9155-TF5
1
KVM console
5771-PP7
448 VPC
Storage Fusion software (64 VPC per worker node)
HCI-13 - 13-node configuration (Large)
Component
Quantity
Configuration Notes
9155-C01 (32c)
3
Control nodes
· Ten (10) 7.68 TB NVMe drives per node
· 256b GB memory per node
9155-C05 (64c)
9
Active worker nodes
· Ten (10) 7.68 TB NVMe drives per node
· 1024 GB memory per node
9155-C05 (64c)
1
Stand-by worker node
· Ten (10) 7.68 TB NVMe drives per node
· 1024 GB memory per node
9155-R42
1
42u rack with PDUs
9155-S01
2
100 GbE High Speed dedicated storage network switches
9155-S02
2
1 GbE management switches
9155-TF5
1
KVM console
5771-PP7
640 VPC
Storage Fusion software (64 VPC per worker node)
 
HCI-16 - 16-node configuration (Extra Large)
Component
Quantity
Configuration Notes
9155-C01 (32c)
3
Control nodes
· Ten (10) 7.68 TB NVMe drives per node
· 256b GB memory per node
9155-C05 (64c)
12
Active worker nodes
· Ten (10) 7.68 TB NVMe drives per node
· 1024 GB memory per node
9155-C05 (64c)
1
Stand-by worker node
· Ten (10) 7.68 TB NVMe drives per node
· 1024 GB memory per node
9155-R42
1
42u rack with PDUs
9155-S01
2
100 GbE High Speed dedicated storage network switches
9155-S02
2
1 GbE management switches
9155-TF5
1
KVM console
5771-PP7
832 VPC
Storage Fusion software (64 VPC per worker node)

System Sizing's and Capabilities
Component
HCI-07
HCI-10
HCI-13
HCI-16
Active Worker Nodes
3
6
9
12
Stand-by Worker Nodes (1)
1
1
1
1
Active Worker Cores
192
384
576
768
Total Usable Capacity (TB)
329
471
612
754
Active memory (TB)
3
6
9
12
User Tier 1 Data Capacity (TB)
230
329
428
527
 
Available Options
Option
Notes
Double memory of 9155-C05
From 1 TB per node to 2 TB per node
 
This will double the active memory of each of the HCI configurations. There is no need to double memory of the three (3) 9155-C01 control nodes.
AFM Communication Nodes (9155-F01)
Add two 9155-F01 nodes to accommodate access to Tier 2 data or for Regional DR (when announced)
Premium Expert Care
Select able term from 1 to 5-years
 
Configuration Experience
Step 1: Storage Modeller (StorM)
To begin the configuration experience, use the IBM Storage Modeller (StorM) tool link.
StorM will present the following fast path configuration for Storage Fusion HCI System configurations for Db2 Warehouse.
Use of these fast path configuration options will simplify the sales motion and reduce the possibility of building an HCI System configuration which has not been validated as optional for use with Db2 Warehouse.
While in StorM, the following options will be presented to modify the fast path configurations:
▪Double memory (from 1 TB per 9155-C05 server to 2 TB per 9155-C05 server)
▪Select the term, 1 to 5 years of Premium Expert Care
▪Add a pair of 9155-F01 AFM communication servers
DB2 Warehouse already includes OpenShift subscriptions, so additional OpenShift subscriptions are not needed, so will not be available to select.
 
Note: DO NOT FINALIZE THE CONFIGURATION IN STORM until ALL HCI System configurations have been fully validated in the pre-sale TDA process and the client has approved the price and configuration. If you Finalize a configuration in Storm, there is no way to change it. If you need to change a /DB2 Warehouse finalized configuration, you must start a new StorM experience and discard your prior work.
 
Step 2: in eConfig Add PDUs, Power whips, network cables, and transceivers
After the CFR is imported into eConfig, you must complete the system configuration by adding:
▪ PDUs (single or three phase)
▪ Country specific power cords
▪ Four (4) Ethernet network cables (selectable length) to connect the Fusion HCI System high speed switches into the client datacenter network
▪ Four (4) Transceivers if needed to convert the 100 GbE signal out of Fusion HCI System to the speed of the client network/ If the client network is also 100 GbE, then transceivers are not needed.
Step 3: Import validated CFR from eConfig into ePricer to generate a quote
 
Footnote 1: Stand-by Worker Nodes
The stand-by worker node must be configured into the Fusion HCI Storage cluster when the system is installed. It will be powered on and storage will be available. The node must be tainted to prevent DB2 workloads from being scheduled on the node. In the event of a node failure, the stand-by worker can be un-tainted to allow DB2 workloads to be scheduled on the node. Active Worker Core count does not include cores in the Stand-by worker nodes. Capacity (TB) does not include capacity in the Stand-by worker, even though that capacity is actually available to workloads.
Report tab
The Report tab includes selectable spreadsheets that summarize details of the product’s configuration, licenses, parts, weight requirements, and operating environment.
The following reports are displayed in the Report tab.
▪Summary: The Summary tab shows the total quantity of Compute, GPU, and AFM servers per rack and in total. It also displays the raw and effective capacity configured in various units.
▪Compute and Storage: The Compute and Storage spreadsheet shows two tables.
 – The upper table shows the calculation of the available CPU cores and memory after all the overhead is considered.
 – The lower table shows the resulting effective capacity in six units, after all the overhead is subtracted from the various components.
▪Licenses: The Licenses spreadsheet contains three sections.
 – The first section shows the number of virtual processor core (VPC) entitlements that are needed for the IBM Storage Fusion HCI Appliance Software.
 – The middle section shows the IBM Storage Fusion HCI Primary Storage and IBM Storage Fusion HCI Backup Storage information.
 – The last section shows the core-based OpenShift Container Platform licenses that are needed for this configuration. The information displayed depends on the selection in the Include Red Hat OCP license field in the Solution tab.
▪Parts List: The Parts List spreadsheet shows a detailed list of all machine type models (MTMs), product identifiers (PIDs), Feature Codes, and descriptions of products that are configured in Storage Modeller. This list shows what will be included in the CFR file that is then imported into e-config.
▪Weight Requirements: The Weight Requirements tab shows a table that contains the weight, in pounds (lbs) and kilograms (kgs), of the physical components in the solution in a per-rack and total basis. Be aware that the sum of the weight of each rack may not match the total when Spine Switches exist in the solution.
▪Operating Environment: The Operating Environment tab shows a table that contains the energy consumption (kW) and the cooling (BTU/hr.) of the components in the solution in a per-rack and total basis. Be aware that the sum of the power consumption and cooling of each rack may not match the total when Spine Switches exist in the solution.