--> LUW tests run on DB2 for LUW version 11.5 (running in a docker image: https://hub.docker.com/r/ibmcom/db2)
--> z/OS tests WERE NOT TESTED and only provided as a reference althouge the syntax and tests should be correct.
--> The JCL's are built by a Phython program
-->< Run with SYSADM authority
Process description
Job DB2IVP1
List of tests:
* Drop all IVP database left from previous runs (DBIVP*)
--- simple table tests
* Create database
* create tablespace
* Create table1 with all types of columns
* Create index on table1
* Test insert/select/update/delete operation on table1
-- Referential integrity tests
* Create table2 with Primary Key
* Create table3 with Forign Key
* Create RI from table3 to table2
* Test insert/select/delete operations on table2
-- BLOB and CLOB tests
* Create table4 with CLOB object
* insert CLOB into table4
* select CLOB from table4
* Create table5 with BLOB object
* insert BLOB into table4
* select BLOB from table4
--