IBM Maximo: Migrate MAXDB to RH OpenShift (db2ucmas76-01.yaml)

From Wiki

Paste the yaml below, change storageClassName: "lvms-vg1", to your storage class.

Current Version - Detailed version

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 - Simplified Version

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


Ver também