back porting from DB2 UDB V8 Unix to DB2 v7.2 on zOS

Posted on 2004-11-17
Medium Priority
Last Modified: 2011-09-20

We performing backporting of one of our applications from
DB2 UDB V8 Unix to DB2 v7.2 on zOS.

Can somebody say, if the following queries make sense on
DB2 v7.2 on zOS? At least several of syscat views we are
using seems not to be available on DB2 7.2 on zOS.

There is a full list of queries we need:

1) select schemaname from syscat.schemata order by schemaname

2) select tbl.tabname, tbl.tabschema, 'BASE TABLE', tbs.tbspace
from syscat.tables tbl, syscat.tablespaces tbs
where type = 'T' and tbl.tbspaceid = tbs.tbspaceid and tbl.tabschema = :user
order by tbl.tabname"

3) select colno, colname, typename, length
from syscat.columns
where tabname = :table and tabschema = :user
order by colon

4) select constname, tabschema, tabname, definer, refkeyname,
reftabschema, reftabname, deleterule, updaterule, fk_colnames, pk_colnames
from syscat.references where tabname = :table and tabschema = :user

5) ALTER TABLE ownerName.tableName ADD CONSTRAINT Constname
FOREIGN KEY Fk_colnames REFERENCES Reftabschema.Reftabname

6) ALTER TABLE ownerName.tableName DROP FOREIGN KEY FK_Constname;


Question by:davidgor
  • 2
LVL 13

Expert Comment

ID: 12611844
i think you have to query the sysibm tables in zOS

Author Comment

ID: 12611969

It's nice comment :-) but what tables do I need?

In addition, on Unix we have used syscat views which are views for
sysibm tables.
LVL 13

Accepted Solution

ghp7000 earned 300 total points
ID: 12614689
this link explains all the catalog tables in Z os:

in unix windows, the catalog table setup is different, the syscat views are available, but you can still query the sysibm tables


Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question