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.