viveksharan

[Fusion HCI issue.docx](https://github.com/ibm-mas/ansible-devops/files/11824421/Fusion.HCI.issue.docx)

TS013628780 https://www.ibm.com/mysupport/s/case/5003p00002ocHP5AAM/db2warehouse-not-getting-installed-on-fusion-hci-red-hat-open-shift-cluster?openCase=true&language=en_US I am CSM for IBM. I am working with the Fusion HCI team to install DB2 Warehouse on a Fusion HCI Cluster. Refer Attached Files for more info...

apiVersion: db2u.databases.ibm.com/v1 kind: Db2uCluster metadata: annotations: db2u/certs-api-cert: '[secure]' db2u/certs-api-key: '[secure]' db2u/certs-wv-rest: '[secure]' db2u/license: '[secure]' db2u/sshkeys-db2instusr: '[secure]' db2u/sshkeys-db2uadm: '[secure]' db2u/sshkeys-db2uhausr: '[secure]' kubectl.kubernetes.io/last-applied-configuration: '{"apiVersion":"db2u.databases.ibm.com/v1","kind":"Db2uCluster","metadata":{"name":"db2w-shared","namespace":"db2u"},"spec":{"account":{"imagePullSecrets":["ibm-registry"],"privileged":true},"addOns":{"graph":{"enabled":false},"rest":{"enabled":false}},"environment":{"database":{"dbConfig":{"APPLHEAPSZ":"8192 AUTOMATIC"},"name":"BLUDB","settings":{"dftTableOrg":"ROW"},"ssl":{"certLabel":"CN=db2u","secretName":"db2u-certificate"}},"dbType":"db2wh","instance":{"dbmConfig":{"INSTANCE_MEMORY":"AUTOMATIC"},"registry":{"DB2AUTH":"OSAUTHDB,ALLOW_LOCAL_FALLBACK,PLUGIN_AUTO_RELOAD","DB2_4K_DEVICE_SUPPORT":"ON","DB2_FMP_RUN_AS_CONNECTED_USER":"NO","DB2_WORKLOAD":"ANALYTICS"}},"mln":{"total":1}},"license":{"accept":true},"podConfig":{"db2u":{"resource":{"db2u":{"limits":{"cpu":"3000m","memory":"12Gi"},"requests":{"cpu":"3000m","memory":"12Gi"}}}}},"size":1,"storage":[{"name":"meta","spec":{"accessModes":["ReadWriteMany"],"resources":{"requests":{"storage":"20Gi"}},"storageClassName":"ibm-spectrum-scale-sc"},"type":"create"},{"name":"data","spec":{"accessModes":["ReadWriteOnce"],"resources":{"requests":{"storage":"100Gi"}},"storageClassName":"ibm-spectrum-scale-sc"},"type":"template"},{"name":"backup","spec":{"accessModes":["ReadWriteMany"],"resources":{"requests":{"storage":"100Gi"}},"storageClassName":"ibm-spectrum-scale-sc"},"type":"create"},{"name":"activelogs","spec":{"accessModes":["ReadWriteOnce"],"resources":{"requests":{"storage":"100Gi"}},"storageClassName":"ibm-spectrum-scale-sc"},"type":"template"},{"name":"tempts","spec":{"accessModes":["ReadWriteOnce"],"resources":{"requests":{"storage":"100Gi"}},"storageClassName":"ibm-spectrum-scale-sc"},"type":"template"}],"version":"s11.5.8.0"}}' creationTimestamp: "2023-06-13T21:48:23Z" generation: 25 labels: formation_id: db2w-shared...

SHMALL limits the total amount of virtual shared memory that can be allocated on a system, in your system you have: db2supp_system.zip_unpack/OSCONFIG/sysctl_a.out:kernel.shmall = 8388608 It should be set to 2...

I am fine waiting for the new release and see if setting that parameter resolves the issue. Just one highlight is that when I talked to the DB2 Team they...