Name	Name	Last commit message	Last commit date
parent directory ..
README.md	README.md
b2bi-override.yaml	b2bi-override.yaml
b2bi-pv.yaml	b2bi-pv.yaml
b2bi-secrets.yaml	b2bi-secrets.yaml
db2-deploy.yaml	db2-deploy.yaml
mq-override.yaml	mq-override.yaml
mq-secret.yaml	mq-secret.yaml
toolkit-deploy.yaml	toolkit-deploy.yaml
toolkit-pv-pvc.yaml	toolkit-pv-pvc.yaml

Deploying Sterling B2Bi on Openshift using the IBM Cloud

Steps required to install Sterling B2Bi on OpenShift on the IBM Cloud

Download the following file from Advantage Passport:

IBM Sterling B2B Integrator Certified Container V6.1 (PartNumber: CC7W7ML) or
IBM Sterling File Gateway V6.1.0.0 Certified Container (PartNumber: CC7W8ML)

Perform the correct Sizing of your environment, I had problems installing it due to lack of resources. It worked when my works had:

vCPUs: 8
Memory: 32G

Create a new project on OpenShift for B2Bi

Create a new project on OpenShift for B2Bi

oc new-project sterling-b2bi-app

Deploy DB2 on OpenShift

Deploy Container

Create a new project on OpenShift for DB2

oc new-project sterling-b2bi-db2

define service and access accounts.

oc create serviceaccount sterling-b2bi-db2-sa

oc adm policy add-scc-to-user privileged -n sterling-b2bi-db2 -z sterling-b2bi-db2-sa

Perform the deploy

oc create -f db2-deploy.yaml

Check for Running status .

oc get pods

  NAME    READY   STATUS    RESTARTS   AGE
  db2-0   1/1     Running   0          31m

Wait until you see this line as the last entry in the log. Ctrl + C to stop the logs.

oc logs -f db2-0
  
  ...
  /database/config/db2inst1/sqllib/ctrl/db2strst.lck

Create Database

Connect to the pod.

oc rsh pod/db2-0

Creating the database

su - db2inst1

cat <<EOF >> create_b2bi_db.sql
CREATE DATABASE B2BIDB AUTOMATIC STORAGE YES USING CODESET UTF-8 TERRITORY DEFAULT COLLATE USING SYSTEM PAGESIZE 32768;
CONNECT TO B2BIDB;
UPDATE DATABASE CONFIG FOR B2BIDB USING LOGFILSIZ 65536;
UPDATE DATABASE CONFIG FOR B2BIDB USING LOGPRIMARY 40;
UPDATE DATABASE CONFIG FOR B2BIDB USING NUM_LOG_SPAN 32;
UPDATE DATABASE CONFIG FOR B2BIDB USING AUTO_MAINT ON;
UPDATE DATABASE CONFIG FOR B2BIDB USING AUTO_TBL_MAINT ON;
UPDATE DATABASE CONFIG FOR B2BIDB USING AUTO_RUNSTATS ON;
UPDATE DATABASE CONFIG FOR B2BIDB USING AUTO_REORG ON;
UPDATE DATABASE CONFIG FOR B2BIDB USING AUTO_DB_BACKUP ON;
CREATE USER TEMPORARY TABLESPACE B2BUSERTEMP PAGESIZE 32K BUFFERPOOL IBMDEFAULTBP;
CREATE BUFFERPOOL B2BIDB_04KBP IMMEDIATE SIZE 1000 PAGESIZE 4K;
CREATE REGULAR TABLESPACE TS_REG04_B2BIDB PAGESIZE 4K BUFFERPOOL B2BIDB_04KBP;
CREATE BUFFERPOOL B2BIDB_08KBP IMMEDIATE SIZE 1000 PAGESIZE 8K;
CREATE REGULAR TABLESPACE TS_REG08_B2BIDB PAGESIZE 8K BUFFERPOOL B2BIDB_08KBP;
CREATE BUFFERPOOL B2BIDB_16KBP IMMEDIATE SIZE 1000 PAGESIZE 16K;
CREATE REGULAR TABLESPACE TS_REG16_B2BIDB PAGESIZE 16K BUFFERPOOL B2BIDB_16KBP;
CONNECT RESET;
EOF

db2 -stvf create_b2bi_db.sql

db2 list database directory

exit

exit

Test db2 connectivity from the outside.

Your can test connectivity from the outside using DBEaver or another SQL Tool. Identify the LoadBalancer IP address (port 50000). EXTERNAL-IP parameter

oc get svc

  NAME                  TYPE           CLUSTER-IP      EXTERNAL-IP        PORT(S)           AGE
  sterling-b2bi-db2-svc-lb  LoadBalancer   172.xx.xx.250   169.xx.xx.83   50000:30707/TCP   43m

Copy JDBC Files from Container

oc cp db2-0:/opt/ibm/db2/V11.5/java/db2jcc4.jar db2jcc4.jar
oc cp db2-0:/opt/ibm/db2/V11.5/java/db2jcc_license_cu.jar db2jcc_license_cu.jar
oc cp db2-0:/opt/ibm/db2/V11.5/java/jdk64/jre/lib/security/policy/unlimited/local_policy.jar local_policy.jar

Deploy MQ on OpenShift

Deploy Container

Create a new project on OpenShift for MQ

oc new-project sterling-b2bi-mq

Create Secrets

oc create -f mq-secret.yaml

Install IBM MQ from the IBM Github repository.

Clone the IBM MQ charts from the Github repository using the command below.

git clone https://github.com/IBM/charts.git

This will create a directory called "charts". Go to the "charts/stable/ibm-mqadvanced-server-dev" folder and copy mq-override.yaml

cd charts/stable/ibm-mqadvanced-server-dev

cp ../../../mq-override.yaml override.yaml

Install the helm chart with the following command , assuming that the file "override.yaml" is placed in the same folder.

helm install sterling-b2bi-mq --namespace sterling-b2bi-mq --timeout 90m0s -f override.yaml .

Test connectivity from the outside.

oc get svc

  NAME                              TYPE        CLUSTER-IP      EXTERNAL-IP   PORT(S)             AGE
  sterling-b2bi-mq-ibm-mq           ClusterIP   172.xx.6.39     <none>        9443/TCP,1414/TCP   92s
  sterling-b2bi-mq-ibm-mq-metrics   ClusterIP   172.xx.60.239   <none>        9157/TCP            92s

and return to default directory

cd ../../..

Setup Container Images on Registry

Setup RH OpenShift Image Registry

Upload images to Registry

Get and export variable

oc get route image-registry -n openshift-image-registry

export MY_IMG_REGISTRY=image-registry-openshift-image-registry....us-south.containers.appdomain.cloud

Change to B2Bi Project and export project

oc project sterling-b2bi-app

export MY_SB2BI_PROJECT=sterling-b2bi-app

Browse to the location where you have downloaded the B2Bi container image.
Login to Registry. Load/tag/push and check.

docker login -u $(oc whoami) -p $(oc whoami -t) $MY_IMG_REGISTRY

docker load -i b2bi-6.1.0.0.tar
docker load -i ps-6.1.0.0.tar
docker load -i purge-6.1.0.0.tar

docker tag b2bi:6.1.0.0 $MY_IMG_REGISTRY/$MY_SB2BI_PROJECT/b2bi:6.1.0.0
docker tag ps:6.1.0.0 $MY_IMG_REGISTRY/$MY_SB2BI_PROJECT/ps:6.1.0.0
docker tag purge:6.1.0.0 $MY_IMG_REGISTRY/$MY_SB2BI_PROJECT/purge:6.1.0.0

docker push $MY_IMG_REGISTRY/$MY_SB2BI_PROJECT/b2bi:6.1.0.0
docker push $MY_IMG_REGISTRY/$MY_SB2BI_PROJECT/ps:6.1.0.0
docker push $MY_IMG_REGISTRY/$MY_SB2BI_PROJECT/purge:6.1.0.0

Check result

oc get imagestream

Deploy Sterling Toolkit on OpenShift

Configure Storage for Tookit

Create a new project on OpenShift for Tookit

oc new-project sterling-b2bi-toolkit

Define Permissions

oc adm policy add-scc-to-user anyuid -z default -n sterling-b2bi-toolkit

Locate the required information on the default storage volume

oc get pv -n openshift-image-registry

NAME       CAPACITY ACCESS MOD  RECLAIM POLICY  STATUS  CLAIM                                              STORAGECLASS    
...                               
pvc-99...  100Gi    RWX           Delete          Bound   openshift-image-registry/image-registry-storage  ibmc-file-gold      
...

Get the details of the PV

oc describe pv pvc-99...


...
failure-domain.beta.kubernetes.io/region=us-south
failure-domain.beta.kubernetes.io/zone=dal10
...
Type:   NFS (an NFS mount that lasts the lifetime of a pod)
Server: fsf-xxxxxxx-xx.adn.networklayer.com
Path:   /IBMxxSEVxxxxxxx_xx/data01
...

Create file my-toolkit-pv-pvc.yaml, change from previous command.

cp toolkit-pv-pvc.yaml my-toolkit-pv-pvc.yaml

Allocate PV/PVC

oc create -f my-toolkit-pv-pvc.yaml

Deploy Toolkit Container

Deploy toolkit

oc create -f toolkit-deploy.yaml

Copy files to Toolkit Container

Get pod information

oc project sterling-b2bi-toolkit

oc get pods

NAME                         READY   STATUS    RESTARTS   AGE
sterling-b2bi-toolkit-59..   1/1     Running   0          73m

Export Toolkit Pod

export  MY_TOOLKIT_POD=sterling-b2bi-toolkit-59..

Connect to Pod and setup directories

oc rsh pod/$MY_TOOLKIT_POD

cd /var/nfs-data/

mkdir resources logs documents

useradd -u 1010 b2biuser
chown b2biuser:b2biuser logs 
chown b2biuser:b2biuser resources 
chown b2biuser:b2biuser documents

exit

Copy files to pod

oc cp db2jcc4.jar $MY_TOOLKIT_POD:/var/nfs-data/resources/
oc cp db2jcc_license_cu.jar $MY_TOOLKIT_POD:/var/nfs-data/resources/
oc cp local_policy.jar $MY_TOOLKIT_POD:/var/nfs-data/resources/

Validate

oc rsh $MY_TOOLKIT_POD ls -l /var/nfs-data/resources/

Deploy Sterling B2Bi on OpenShift

Pre-install

Create a new project on OpenShift for Tookit

oc project sterling-b2bi-app

Extract files from ibm-b2bi-prod-2.0.0.tgz

tar -xzvf ibm-b2bi-prod-2.0.0.tgz

Change directory and setup permissions on OpenShift

cd ibm-b2bi-prod/ibm_cloud_pak/pak_extensions/pre-install/clusterAdministration

oc apply -f ibm-b2bi-scc.yaml --validate=false
oc apply -f ibm-b2bi-cr-scc.yaml --validate=false
oc apply -f ibm-b2bi-psp.yaml
oc apply -f ibm-b2bi-cr.yaml

cd ../../../../..

Change Rolebinding

cd ibm-b2bi-prod/ibm_cloud_pak/pak_extensions/pre-install/namespaceAdministration

sed 's/{{ NAMESPACE }}/'$MY_SB2BI_PROJECT'/g' ibm-b2bi-rb-scc.yaml > my-ibm-b2bi-rb-scc.yaml
sed 's/{{ NAMESPACE }}/'$MY_SB2BI_PROJECT'/g' ibm-b2bi-rb.yaml > my-ibm-b2bi-rb.yaml

oc create -f my-ibm-b2bi-rb-scc.yaml
oc create -f my-ibm-b2bi-rb.yaml

cd ../../../../..

Configure Storage for B2Bi

Locate the required information on the default storage volume

oc get pv -n openshift-image-registry

NAME       CAPACITY ACCESS MOD  RECLAIM POLICY  STATUS  CLAIM                                              STORAGECLASS    
...                           
pvc-99...  100Gi    RWX           Delete          Bound   openshift-image-registry/image-registry-storage  ibmc-file-gold      
...

Get the details of the PV

oc describe pv pvc-99...

...
failure-domain.beta.kubernetes.io/region=us-south
failure-domain.beta.kubernetes.io/zone=dal10
...
Type:   NFS (an NFS mount that lasts the lifetime of a pod)
Server: fsf-xxxxxxx-xx.adn.networklayer.com
Path:   /IBMxxSEVxxxxxxx_xx/data01
...

Create file my-b2bi-pv.yaml, change from previous command:

cp b2bi-pv.yaml my-b2bi-pv.yaml

Allocate PV/PVC

oc create -f my-b2bi-pv.yaml

Configuring passphrase for B2Bi, DB secret and MQ secret

Change file b2i-secrets.yaml
Create secrets

oc create -f b2bi-secrets.yaml

Deploy with Helm

Create file my-b2bi-override.yaml, and change

cp b2bi-override.yaml my-b2bi-override.yaml

Deploy with Helm

cd ibm-b2bi-prod

helm install sterling-b2bi-app --namespace sterling-b2bi-app --timeout 120m0s -f ../my-b2bi-override.yaml .

You can check install using this commands:

$ oc get pods
NAME                                    READY   STATUS    RESTARTS   AGE
sterling-b2bi-app-b2bi-db-setup-bltg5   1/1     Running   0          24s

$ oc logs -f sterling-b2bi-app-b2bi-db-setup-bltg5

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

b2bi-db2-mq-openshift-ibmcloud

b2bi-db2-mq-openshift-ibmcloud

README.md

Deploying Sterling B2Bi on Openshift using the IBM Cloud

Create a new project on OpenShift for B2Bi

Deploy DB2 on OpenShift

Deploy Container

Create Database

Deploy MQ on OpenShift

Deploy Container

Setup Container Images on Registry

Upload images to Registry

Deploy Sterling Toolkit on OpenShift

Configure Storage for Tookit

Deploy Toolkit Container

Copy files to Toolkit Container

Deploy Sterling B2Bi on OpenShift

Pre-install

Configure Storage for B2Bi

Configuring passphrase for B2Bi, DB secret and MQ secret

Deploy with Helm

Files

b2bi-db2-mq-openshift-ibmcloud

Directory actions

More options

Directory actions

More options

Latest commit

History

b2bi-db2-mq-openshift-ibmcloud

Folders and files

parent directory

README.md

Deploying Sterling B2Bi on Openshift using the IBM Cloud

Create a new project on OpenShift for B2Bi

Deploy DB2 on OpenShift

Deploy Container

Create Database

Deploy MQ on OpenShift

Deploy Container

Setup Container Images on Registry

Upload images to Registry

Deploy Sterling Toolkit on OpenShift

Configure Storage for Tookit

Deploy Toolkit Container

Copy files to Toolkit Container

Deploy Sterling B2Bi on OpenShift

Pre-install

Configure Storage for B2Bi

Configuring passphrase for B2Bi, DB secret and MQ secret

Deploy with Helm