aramich@cs.vu.nl (Michielse ARA) (03/23/90)
I'm looking for someone who's familiar with Data Manager (Query Manager)
running on IBM's PS/2, and who's willing to help me out on some
problems.
We run three DB2-(sub)systems in a MVS environment (IBM 3090 maninframe)
We allow endusers to run queries against some databases using QMF
or SPUFI.
For cpu-consuming queries (we have a lot of them) we would
like to be able to download a DB2 table to DM (on PS/2).
In the OS/2 manual the following strategy is suggested :
1 - export the data (using QMF) in QMF-format.
2 - start a host-session (from the PS/2).
3 - download the data using SQLQMFM
4 - import the data in Data Manager
Our problem with this strategy is that you'd have to create
a table in Data Maganager first which is an exact copy of the
DB2-table. (I'm talking about tables consisting of 50-150 columns).
An acceptable solution would be to EXPORT the CREATE-statements
as well and IMPORT them in Data Manager. (We can easily generate
them from our Data Dictionary or even the DB2-catalog).
Is there an easy way to do this ?
Better would be to be able to update Data Managers catalog
to avoid executing a lot of CREATE statements.
Is there anyone who has tried this (succesfully) or knows
how the Data Manager catalog is physically stored ?
Any other information concerning Data Manager is also welcome.
Toine Michielse
Fac. Math. & Computer Sciences
V.U. Amsterdam.