I can't remember, when I worked for the State and they were moving some
DB2 data to a SQL server somewhere, I worked with the DBA's and setup a
Unix process (on Z) and a migration directory for them to unload the
data using a DB2 utility - IIRC they use a secure FTP process on a
server to pick up the data, if I can find the procedure I setup I can
provide this if interested.
Carmen
On 2/8/2023 1:25 PM, Bob Bridges wrote:
That'd be my thought. DB2 to flat file, then through (probably) REXX to CSV
format, then download to the PC. Or get a REXX to read the DB2 tables
directly, though that's probably slower; I'd think QMF would be faster for the
first extract, assuming you have a lot of data to process. If you're not a
REXXer but do know VBA or VBS, you can convert to CSV after you download the
flat files, though that may be a little harder.
(So it can't possibly be a dumb answer, Lionel, if both you and I like it.)
CSV...that might be a lot of data. Is Access an option, instead? More trouble
to access (no pun intended) but it does a better job when the bytes are many.
---
Bob Bridges, robhbrid...@gmail.com, cell 336 382-7313
/* We see that many articulate secularists are well-meaning and law-abiding
men....So we conclude...that their philosophies are just as good guides to
action as Christianity. What we don't see is that they are not acting on their
philosophies. They are acting, out of habit or sentiment, on an inherited
Christian ethic which they still take for granted though they have rejected the
creed from which it sprang. Their children will inherit somewhat less of it.
-Joy Davidman, _Smoke on the Mountain_ (1955) */
-----Original Message-----
From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> On Behalf Of
Lionel B. Dyck
Sent: Wednesday, February 8, 2023 12:23
May be a dumb answer but can't you migrate the data into a distributed database
of some sort?
-----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
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
--
Carmen
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
