IBM Maximo: Migrate MAXDB to RH OpenShift (db2ucmas76-01.yaml)
Paste the yaml below, change storageClassName: "lvms-vg1", to your storage class.
apiVersion: db2u.databases.ibm.com/v1
kind: Db2uCluster
metadata:
annotations:
name: db2u-maxdb
namespace: db2u
spec:
account:
imagePullSecrets:
- ibm-registry
privileged: true
addOns:
graph: {}
qrep:
infraHost: xxx.ibm.com
infraIP: x.x.x.x
license: {}
rest: {}
environment:
database:
dbConfig:
AUTO_REORG: 'OFF'
AUTO_RUNSTATS: 'ON'
AUTO_DEL_REC_OBJ: 'ON'
DATABASE_MEMORY: AUTOMATIC
MAXFILOP: '61440'
DFT_TABLE_ORG: ROW
WLM_ADMISSION_CTRL: 'NO'
REC_HIS_RETENTN: '60'
LOCKLIST: AUTOMATIC
NUM_DB_BACKUPS: '60'
SORTHEAP: automatic
MIRRORLOGPATH: /mnt/backup/MIRRORLOGPATH
AUTO_TBL_MAINT: 'ON'
DBHEAP: AUTOMATIC
AUTHN_CACHE_DURATION: '10'
DEC_TO_CHAR_FMT: NEW
SHEAPTHRES_SHR: automatic
LOGARCHMETH1: 'DISK:/mnt/bludata0/db2/archive_log/'
AUTO_MAINT: 'ON'
STAT_HEAP_SZ: AUTOMATIC
PCKCACHESZ: AUTOMATIC
NUM_IOSERVERS: AUTOMATIC
AUTHN_CACHE_USERS: '100'
AUTO_DB_BACKUP: 'OFF'
STMTHEAP: '20000'
CUR_COMMIT: 'ON'
LOCKTIMEOUT: '300'
DDL_CONSTRAINT_DEF: 'YES'
LOGBUFSZ: '1024'
TRACKMOD: 'YES'
LOGSECOND: '156'
STMT_CONC: LITERALS
DFT_QUERYOPT: '5'
SOFTMAX: '0'
NUM_IOCLEANERS: AUTOMATIC
CATALOGCACHE_SZ: '800'
CHNGPGS_THRESH: '40'
AUTO_REVAL: DEFERRED
LOGPRIMARY: '100'
APPLHEAPSZ: 8192 AUTOMATIC
LOGFILSIZ: '32768'
name: MAXDB
settings:
dftTableOrg: ROW
dbType: db2wh
instance:
dbmConfig:
AGENT_STACK_SZ: '1024'
FENCED_POOL: '50'
HEALTH_MON: 'OFF'
KEEPFENCED: 'NO'
MON_HEAP_SZ: AUTOMATIC
RQRIOBLK: '65535'
password: 'db2inst1'
registry:
DB2_USE_ALTERNATE_PAGE_CLEANING: 'ON'
DB2_SKIPINSERTED: 'ON'
DB2_WORKLOAD: MAXIMO
DB2_4K_DEVICE_SUPPORT: 'ON'
DB2_FMP_COMM_HEAPSZ: '65536'
DB2_MINIMIZE_LISTPREFETCH: 'Y'
DB2_SKIPDELETED: 'ON'
DB2_INLIST_TO_NLJN: 'YES'
DB2_OBJECT_STORAGE_LOCAL_STAGING_PATH: /mnt/backup/staging
DB2_CDE_REDUCED_LOGGING: 'REDUCED_REDO:NO'
DB2_FMP_RUN_AS_CONNECTED_USER: 'NO'
DB2AUTH: 'OSAUTHDB,ALLOW_LOCAL_FALLBACK,PLUGIN_AUTO_RELOAD'
DB2_EVALUNCOMMITTED: 'YES'
DB2_BCKP_PAGE_VERIFICATION: 'TRUE'
ldap:
enabled: false
mln:
total: 1
license:
accept: true
podConfig:
db2u:
resource:
db2u:
limits:
cpu: '6'
memory: 16Gi
requests:
cpu: 500m
memory: 3Gi
size: 1
storage:
- name: meta
spec:
accessModes:
- ReadWriteOnce
resources:
requests:
storage: 10Gi
storageClassName: lvms-vg1
type: create
- name: data
spec:
accessModes:
- ReadWriteOnce
resources:
requests:
storage: 20Gi
storageClassName: lvms-vg1
type: template
- name: backup
spec:
accessModes:
- ReadWriteOnce
resources:
requests:
storage: 10Gi
storageClassName: lvms-vg1
type: create
- name: activelogs
spec:
accessModes:
- ReadWriteOnce
resources:
requests:
storage: 10Gi
storageClassName: lvms-vg1
type: template
- name: tempts
spec:
accessModes:
- ReadWriteOnce
resources:
requests:
storage: 10Gi
storageClassName: lvms-vg1
type: template
version: s11.5.9.0-cn2
Version 1
apiVersion: db2u.databases.ibm.com/v1
kind: Db2uCluster
metadata:
name: db2ucmas76-01
namespace: db2u
spec:
license:
accept: true
account:
privileged: true
environment:
database:
settings:
codeset: UTF-8
territory: US
name: MAXDB
ldap:
enabled: false
dbType: db2wh
version: s11.5.9.0-cn2
podConfig:
db2u:
resource:
db2u:
limits:
cpu: '6'
memory: 16Gi
requests:
cpu: 500m
memory: 3Gi
storage:
- name: meta
type: create
spec:
accessModes:
- ReadWriteOnce
resources:
requests:
storage: 10Gi
storageClassName: lvms-vg1
- name: data
type: template
spec:
accessModes:
- ReadWriteOnce
resources:
requests:
storage: 20Gi
storageClassName: lvms-vg1
- name: backup
type: create
spec:
accessModes:
- ReadWriteOnce
resources:
requests:
storage: 10Gi
storageClassName: lvms-vg1
- name: tempts
type: template
spec:
accessModes:
- ReadWriteOnce
resources:
requests:
storage: 10Gi
storageClassName: lvms-vg1
- name: archivelogs
type: create
spec:
accessModes:
- ReadWriteOnce
resources:
requests:
storage: 10Gi
storageClassName: lvms-vg1
size: 1