IBM Data Server Driver and DB2 12 for z/OS for JDBC Type 4 Connections using Application Compatibili

Daniel Luksetich

IBM Data Server Driver and DB2 12 for z/OS for JDBC Type 4 Connections using Application Compatibili
Hello,

This is the final article on the IDUG web site this month on Db2 12
continuous delivery and application compatibility. It contains links to the
other articles as well as other resources on this very important topic.

https://www.idug.org/p/bl/ar/blogaid=803



In my opinion all of this is a must read for anyone migrating to Db2 12 for
z/OS.



Cheers!

Dan



Daniel L Luksetich

DanL Database Consulting



IBM GOLD Consultant

IBM Champion for Analytics

IDUG Content Committee Past-Chairman

IDUG DB2-L Administrator

IBM Certified Database Adminstrator - DB2 11 DBA for z/OS

IBM Certified System Administrator - DB2 11 for z/OS

IBM Certified Application Developer - DB2 11 for z/OS

IBM Certified Advanced Database Administrator - DB2 10.1 for Linux UNIX and
Windows



Peter Backlund

[LUW] - question about IXF
(in response to Daniel Luksetich)
I have a problem with the IXF format of backup/restore.

I am exporting my table to an .IXF-file - no problem!

I am restoring it using "import - of ixf create into"
Everything (table, indexes, triggers) is restored - except my check constraints

So my question is
WAD?
IBM's error?
My error?

Best regards to everyone,

Peter - now retired; half the year in Spain
--

+--------------------------------+---------------------------------+
| Peter G Backlund | E-mail: [login to unmask email] |
+--------------------------------+---------------------------------+
| Phone: 0046(0)70 - 764 7554 | Skype: BacklundDB2 |
+--------------------------------+---------------------------------+
| May - September | October - April |
+------------------------------------------------------------------+
| Råsundavägen 94 | Calle Alella 55, Apt 2B |
| S-169 57 SOLNA | 03185 Torrevieja |
| Sweden | Spain |
+--------------------------------+---------------------------------+
| Playing with DB2 since 1981 ... and forever! |
+------------------------------------------------------------------+

David Williams

[LUW] - question about IXF
(in response to Peter Backlund)

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0008304.html

"Referential constraints and foreign key definitions are not preserved when recreating tables from PC/IXF files. (Primary key definitions are preserved if the data was previously exported using SELECT *.)"

Yet https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0020149.html

mentions "A foreign key constraint (also referred to as a referential constraint or a referential integrity constraint)"

and "A (table) check constraint (also called a check constraint)"

hence a check constraint is NOT a referential constraint.

This mean that the first link above does not document what happens to check constraints!!

I would ask for a documentation fix...

Regards,
David.


> On 04 December 2018 at 14:33 Peter Backlund <[login to unmask email]> wrote:
>
>
> I have a problem with the IXF format of backup/restore.
>
> I am exporting my table to an .IXF-file - no problem!
>
> I am restoring it using "import - of ixf create into"
> Everything (table, indexes, triggers) is restored - except my check constraints
>
> So my question is
>
> > WAD?
> > IBM's error?
> > My error?
> >
> Best regards to everyone,
>
> Peter - now retired; half the year in Spain
>
> --
>
> +--------------------------------+---------------------------------+
> | Peter G Backlund | E-mail: [login to unmask email] |
> +--------------------------------+---------------------------------+
> | Phone: 0046(0)70 - 764 7554 | Skype: BacklundDB2 |
> +--------------------------------+---------------------------------+
> | May - September | October - April |
> +------------------------------------------------------------------+
> | Råsundavägen 94 | Calle Alella 55, Apt 2B |
> | S-169 57 SOLNA | 03185 Torrevieja |
> | Sweden | Spain |
> +--------------------------------+---------------------------------+
> | Playing with DB2 since 1981 ... and forever! |
> +------------------------------------------------------------------+
>
>
>
> -----End Original Message-----

Peter Backlund

[LUW] - question about IXF
(in response to David Williams)
Thanks David, for your reply!

I have furthermore discovered that triggers are retained, but marked with 'X' - have to be recreated.

So to summarize, after restoring (create) a table using IXF, I have to recreate
check constraints
triggers
referential constraints
Not a real problem - just do it!

Peter

On 2018-12-04 16:29, David Williams wrote:
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0008304.html

"Referential constraints and foreign key definitions are not preserved when recreating tables from PC/IXF files. (Primary key definitions are preserved if the data was previously exported using SELECT *.)"

Yet https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0020149.html

mentions "A foreign key constraint (also referred to as a referential constraint or a referential integrity constraint)"

and "A (table) check constraint (also called a check constraint)"

hence a check constraint is NOT a referential constraint.

This mean that the first link above does not document what happens to check constraints!!

I would ask for a documentation fix...

Regards,
David.


On 04 December 2018 at 14:33 Peter Backlund <[login to unmask email]> wrote:


I have a problem with the IXF format of backup/restore.

I am exporting my table to an .IXF-file - no problem!

I am restoring it using "import - of ixf create into"
Everything (table, indexes, triggers) is restored - except my check constraints

So my question is

WAD?
IBM's error?
My error?

Best regards to everyone,

Peter - now retired; half the year in Spain

--

+--------------------------------+---------------------------------+
| Peter G Backlund | E-mail: [login to unmask email] |
+--------------------------------+---------------------------------+
| Phone: 0046(0)70 - 764 7554 | Skype: BacklundDB2 |
+--------------------------------+---------------------------------+
| May - September | October - April |
+------------------------------------------------------------------+
| Råsundavägen 94 | Calle Alella 55, Apt 2B |
| S-169 57 SOLNA | 03185 Torrevieja |
| Sweden | Spain |
+--------------------------------+---------------------------------+
| Playing with DB2 since 1981 ... and forever! |
+------------------------------------------------------------------+



-----End Original Message-----
-----End Original Message-----



--

+--------------------------------+---------------------------------+
| Peter G Backlund | E-mail: [login to unmask email] |
+--------------------------------+---------------------------------+
| Phone: 0046(0)70 - 764 7554 | Skype: BacklundDB2 |
+--------------------------------+---------------------------------+
| May - September | October - April |
+------------------------------------------------------------------+
| Råsundavägen 94 | Calle Alella 55, Apt 2B |
| S-169 57 SOLNA | 03185 Torrevieja |
| Sweden | Spain |
+--------------------------------+---------------------------------+
| Playing with DB2 since 1981 ... and forever! |
+------------------------------------------------------------------+