Latest revision as of 16:59, 11 October 2023

This documentation is in DRAFT!!!! Working on it.

Running DB2 as Container

Create db2data directory

# mkdir -p /opt/db2data

Pull images

podman pull icr.io/db2_community/db2

Running Db2

podman run -d --name maxdb --privileged=true -p 50000:50000 -e LICENSE=accept \
-e DB2INST1_PASSWORD=passw0rd -e DB2INSTANCE=ctginst1 -e DBNAME=maxdb76 \
-v /opt/db2data:/database db2_community/db2

Cheking Logs

podman logs -f maxdb

Create Tablespaces in maxdb76

Connect to container

podman exec -ti maxdb bash -c "su - ctginst1"

Create tablespaces

db2 CONNECT TO maxdb76
db2 CREATE BUFFERPOOL MAXBUFPOOL IMMEDIATE SIZE 4096 AUTOMATIC PAGESIZE 32 K
db2 CREATE REGULAR TABLESPACE MAXDATA PAGESIZE 32 K MANAGED BY AUTOMATIC STORAGE INITIALSIZE 5000 M BUFFERPOOL MAXBUFPOOL
db2 CREATE TEMPORARY TABLESPACE MAXTEMP PAGESIZE 32 K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL MAXBUFPOOL
db2 CREATE REGULAR TABLESPACE MAXINDEX PAGESIZE 32 K MANAGED BY AUTOMATIC STORAGE INITIALSIZE 5000 M BUFFERPOOL MAXBUFPOOL
db2 GRANT USE OF TABLESPACE MAXDATA TO USER MAXIMO
db2 CREATE SCHEMA maximo AUTHORIZATION maximo
db2 GRANT DBADM,CREATETAB,BINDADD,CONNECT,CREATE_NOT_FENCED_ROUTINE,IMPLICIT_SCHEMA,LOAD,CREATE_EXTERNAL_ROUTINE,QUIESCE_CONNECT,SECADM ON DATABASE TO USER MAXIMO
db2 GRANT  CREATEIN,DROPIN,ALTERIN ON SCHEMA MAXIMO TO USER MAXIMO
db2 connect reset

restart db2

db2stop force
db2start

Running WAS as Container

Create WAS directory

# mkdir -p /opt/was/config /opt/was/app

Pull images

podman pull icr.io/appcafe/websphere-traditional:latest

Running WAS

podman run -d --name mywassrv -h was-server -p 9043:9043 -p 9443:9443 \
-v /opt/was/config:/etc/websphere websphere-traditional:latest

Cheking Logs

podman logs -f mywassrv

Login in WAS Console

First get password

podman exec mywassrv cat /tmp/PASSWORD

Now access in browser

https://<ip of the server>:9043/admin

To login

user: wsadmin
password: <from the output of Podman exec>

Ver também