support for DB2 z/OS

Db2 - related issues
Post Reply
jzhang18
Posts: 1
Joined: Tue Sep 25, 2012 12:41 pm

support for DB2 z/OS

Post by jzhang18 » Tue Sep 25, 2012 12:45 pm

The jdbc driver in Dbschema is working for me to connect to DB2 z/OS V9.1.
but then it starts to be wrong. DB2 z/OS uses SYSIBM schema to hold all system catalogs. DB2 LUW uses SYSCAT schema.
Dbschema uses SYSCAT to query without detecting what kind of DB2 it connected. Please fix this.
thanks
-Jack

donose.mihai
Posts: 470
Joined: Thu Apr 07, 2011 11:05 am

Re: support for DB2 z/OS

Post by donose.mihai » Thu Sep 27, 2012 2:53 pm

Hello Jack,

In a few days we'll release a beta update that should resolve this issue.

Wladimir82
Posts: 1
Joined: Fri Oct 19, 2012 6:36 pm

Re: support for DB2 z/OS

Post by Wladimir82 » Fri Oct 19, 2012 7:04 pm

I have the same problem with DB2 for AS/400. I am using dbschema Build 3652.
The library for system tables is SYSIBM instead of SYSCAT.
As workaround I use Database "Others" with jtopen jdbc library. That works for reverse engeneering moderately well. Modifying tables results in various exceptions but dbschema does not claim to support DB2/400 (new name: DB2 for i).

mitzanu
Posts: 1
Joined: Sat Jun 25, 2011 10:25 am

Re: support for DB2 z/OS

Post by mitzanu » Sat Oct 20, 2012 12:35 pm

Hello,

please update Dbschema to the latest beta version and let us know if this has been resolved.

Go to Edit -> Configuration -> Automatic Updates -> Update Source -> Beta -> Save and Close | go to Help -> Check for updates, after the updates completes, restart DbSchema

Regards,

Mihai

mithcd143
Posts: 27
Joined: Fri Jun 14, 2013 3:52 pm

Re: support for DB2 z/OS

Post by mithcd143 » Fri Jun 21, 2013 5:56 pm

Does this beta update helps with this issue?

malik789
Posts: 1
Joined: Fri Oct 10, 2014 9:39 am

Re: support for DB2 z/OS

Post by malik789 » Fri Oct 10, 2014 9:40 am

As workaround I use Database "Others" with jtopen jdbc library. That works for reverse engeneering moderately well. Modifying tables results in various exceptions but dbschema does not claim to support DB2/400 (new name: DB2 for i).

Grahamfubre
Posts: 20
Joined: Sat Feb 24, 2018 5:58 pm

support for DB2 z/OS

Post by Grahamfubre » Wed Mar 07, 2018 12:50 pm

Hi Sefro,

Thanks for you answer...

I will look at the different links you let and see if i can manage...

Regards

Post Reply