Move DBB metadata store from filesystem to DB2

[davidjwriter]

Migrate DBB Metadata Store from File System to DB2

Problem

Bank-of-Z currently uses a file system-based metadata store for DBB. IBM's DBB team highly recommends using DB2 metadata storage for production environments, positioning the file system approach as more of a "testing ground." As Bank-of-Z aims to be an exemplar of proper z/OS tool usage, we should migrate to DB2 metadata storage.

Current Configuration

File: dbb-app.yaml (lines 267-270)

- task: MetadataInit
  variables:
   - name: fileLocation
     value: /usr/local/sandboxes

Proposed Solution

Migrate to DB2 metadata store by:

1. Create DBB metadata tables in DB2 (separate from application tables)
2. Update dbb-app.yaml configuration:

   - task: MetadataInit
     variables:
      - name: jdbcUrl
        value: jdbc:db2://hostname:port/DBBMETA
      - name: jdbcDriver
        value: com.ibm.db2.jcc.DB2Driver
      - name: user
        value: ${DBB_DB2_USER}
      - name: password
        value: ${DBB_DB2_PASSWORD}

3. Add JCL script to initialize DBB metadata tables (similar to .setup/jcl/Db2-create.jcl)
4. Update setup scripts to include DBB metadata table creation
5. Document DB2 metadata store setup and configuration