a couple of processes come to mind, 2 companies I worked for use Change
Data Capture, once a 3rd party product now part of IBM's WebSphere
suite, this product can replicate DB2 data to DB2 or SQL sever, the
other process I saw was a product from Oracle, I don't recall the
product name but it can also move , replicate data to DB2 in any other
platform IIRC, SQL or an Oracle DB
Carmen
On 2/8/2023 11:23 AM, Lionel B. Dyck wrote:
May be a dumb answer but can't you migrate the data into a distributed database
of some sort?
Lionel B. Dyck <><
Website: https://www.lbdsoftware.com
Github: https://github.com/lbdyck
“Worry more about your character than your reputation. Character is what you
are, reputation merely what others think you are.” - - - John Wooden
-----Original Message-----
From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On Behalf Of Tom
Longfellow
Sent: Wednesday, February 8, 2023 11:12 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: The Local death of DB2 z/OS --- what is the best way to preserve the
data once the mainframe is gone
The death warrant on our DB2 for z/OS has been issued.
The people with decades of data stored in the tables are asking the obvious
questions. How do we see into our ancient history as we have always done?
My answer is simple: you can't.
The all knowledgeable planners have come up with the idea of Extract it into
CSV files and walk away. I have many concerns about this process that I will
not go into now.
As a good little worker Bee, I am trying to do what I am told. Here is where
the fun begins. My good friend Google (and IBM) says 'Use IBM Data Studio to
perform the Extract to CSV utility function. My installed version of IBM Data
Studio (V4.1.3) does NOT have that option in the menus displayed by the
documentation.
Does anyone have a workable way to Extract DB2 Tables to CSV files?
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions, send email to
lists...@listserv.ua.edu with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
--
Carmen
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
