quarterly history of DB2 data

[login to unmask email]

quarterly history of DB2 data
We have in-house auditors, customers, etc that need a point-in-time
snapshot of the database on a quarterly basis (going back 5 years). Our
DBA's are responsible for COBOL programs that pull data off the DB2 tables
and write each row to a flat file. Customers then use Passport for
information retrieval and report writing against the flat files. Oracle is
dropping support for the Passport products in the near future and we as
DBA's would like to get out of the business of maintaining COBOL programs.
We've had some demos by SAS, Cognos, and others but I'm getting signals
that the money isn't there for a data warehousing solution. We are in the
process of purchasing QMF for Windows. This will work for accessing the
database and other VSAM files we have, but as I understand it, QMF can not
access flat files. Can anyone recommend an approach that will put the
quarterly DB2 data in a format that is accessible to products such as QMF?
Is it possible to use the file generated from DSNTIAUL (to eliminate COBOL
programs)? Or should I change the COBOL programs to write VSAM files?





Tom Abbott

[login to unmask email]



RICK (SBCSI) DAVIS

Re: quarterly history of DB2 data
(in response to Thomas_Abbott@HESC.COM)
Tom,
I was going to try to suggest some things to you but after reading
your email I realized I wasn't too sure what is where.
You mention VSAM, DSNTIAUL, Oracle, COBOL, QMF for Windows, DB2 and
flat files. These could be quite a mixed bag on several platforms. Could you
be more specific about what is where?
One question that can be asked is how are you establishing or
determining the point-in-time? This would normally be a considerable effort
for, what appears to be, an entire system unless, of course, you have the
luxury of shutdown everything down and taking your "snapshot".

Regards,
Rick Davis

"This e-mail and any files transmitted with it are the property of SBC, are
confidential, and are intended solely for the use of the individual or
entity to whom this e-mail is addressed. If you are not one of the named
recipient(s) or otherwise have reason to believe that you have received this
message in error, please notify the sender at 314-235-6854 and delete this
message immediately from your computer. Any other use, retention,
dissemination, forwarding, printing, or copying of this e-mail is strictly
prohibited."

-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Wednesday, December 20, 2000 1:15 PM
To: [login to unmask email]
Subject: quarterly history of DB2 data

We have in-house auditors, customers, etc that need a point-in-time
snapshot of the database on a quarterly basis (going back 5 years). Our
DBA's are responsible for COBOL programs that pull data off the DB2 tables
and write each row to a flat file. Customers then use Passport for
information retrieval and report writing against the flat files. Oracle is
dropping support for the Passport products in the near future and we as
DBA's would like to get out of the business of maintaining COBOL programs.
We've had some demos by SAS, Cognos, and others but I'm getting signals
that the money isn't there for a data warehousing solution. We are in the
process of purchasing QMF for Windows. This will work for accessing the
database and other VSAM files we have, but as I understand it, QMF can not
access flat files. Can anyone recommend an approach that will put the
quarterly DB2 data in a format that is accessible to products such as QMF?
Is it possible to use the file generated from DSNTIAUL (to eliminate COBOL
programs)? Or should I change the COBOL programs to write VSAM files?

Tom Abbott

[login to unmask email]



Sanjeev (CTS) S

Re: quarterly history of DB2 data
(in response to RICK (SBCSI) DAVIS)
Starting from point by point.
You get the flat file data given by cobol programs using DB2. Now you have
VSAM, DB2 and Flat files as the data storage in your installation. It seems
you need something which can give your auditors the quearterly data....But
in what kind of format, from which all data source, for what kind of
analysis....it it OLAP kind of analysis stuffs you require. For this kind of
requirement, i can write any number of programs, cunsomize everything in my
Windows NT using my own written programs(don't have any now), replications
and may be the OLAP kits provided by IBM .
This will be one time effort. Program maintenance will not be a problem
because this kind of requirements changes less frequently.Give everything to
your auditors in web, it will help you getting good remarks from them as
well.

HTH
Regards
Sanjeev
> -----Original Message-----
> From: [login to unmask email] [SMTP:[login to unmask email]
> Sent: Thursday, December 21, 2000 12:45 AM
> To: [login to unmask email]
> Subject: quarterly history of DB2 data
>
> We have in-house auditors, customers, etc that need a point-in-time
> snapshot of the database on a quarterly basis (going back 5 years). Our
> DBA's are responsible for COBOL programs that pull data off the DB2 tables
> and write each row to a flat file. Customers then use Passport for
> information retrieval and report writing against the flat files. Oracle
> is
> dropping support for the Passport products in the near future and we as
> DBA's would like to get out of the business of maintaining COBOL programs.
> We've had some demos by SAS, Cognos, and others but I'm getting signals
> that the money isn't there for a data warehousing solution. We are in the
> process of purchasing QMF for Windows. This will work for accessing the
> database and other VSAM files we have, but as I understand it, QMF can not
> access flat files. Can anyone recommend an approach that will put the
> quarterly DB2 data in a format that is accessible to products such as QMF?
> Is it possible to use the file generated from DSNTIAUL (to eliminate COBOL
> programs)? Or should I change the COBOL programs to write VSAM files?
>
>
>
>
>
> Tom Abbott
>
> [login to unmask email]
>
>
>
>
>
-----------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------
This e-mail and any files transmitted with it are for the sole use
of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message. Any unauthorised review, use, disclosure,
dissemination, forwarding, printing or copying of this email or any action taken in
reliance on this e-mail is strictly prohibited and may be unlawful.

Visit us at http://www.cognizant.com
----------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------