DBIO-DB2-0.900000

Changes for version 0.900000 - 2026-06-23

First release. IBM DB2 driver for DBIO with native introspection, diff, DDL generation and test-deploy-and-compare deployment.
Storage
- DB2 storage driver, autodetected from dbi:DB2: DSNs
- -db2 shortcut and DBIO::DB2 schema component pin the driver
- DateTime::Format::DB2 datetime parsing, "-quoted identifiers, schema-qualified table references, last_insert_id support
SQLMaker
- DB2 LIMIT/OFFSET dialect via apply_limit: ROW_NUMBER() OVER() for offset, FETCH FIRST n ROWS ONLY otherwise
Introspect (SYSCAT + information_schema)
- tables, columns, indexes and foreign keys from SYSCAT
- GENERATED AS IDENTITY captured as is_auto_increment for DBIO::Generate
- PK-backing index tagged origin=>'pk' so inherited table_uniq_info drops it; built on DBIO::Introspect::Base canonical shape
Diff
- native DB2 model diff (table/column/index/foreign key) on DBIO::Diff::Op, using changed_column_fields / changed_index_fields / changed_fk_fields from DBIO::Diff::Compare
- foreign-key changes on existing tables emitted as ALTER TABLE ADD/DROP CONSTRAINT (drop-then-add for a changed FK)
DDL
- generate DB2 DDL from Result classes
- emit named inline FOREIGN KEY constraints (deterministic fk_<table>_<cols> names) that round-trip through introspection
- emit CREATE VIEW for non-virtual views (from view_definition) after all tables
Deploy
- test-deploy-and-compare deployment on DBIO::Deploy::Base (install/diff/apply/upgrade), with DB2-specific target model built via a throwaway CREATE SCHEMA