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 <[email protected]> On Behalf Of Tom Longfellow Sent: Wednesday, February 8, 2023 11:12 AM To: [email protected] 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 [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
