Page 1 of 1

PHP & os/390 question

Posted: Mon Aug 04, 2003 4:58 pm
by rxsid
Hi all,

I realize this may be a very obtuse question that perhaps no one out there has an answer to, but here goes....

Does anyone know how I could use PHP to establish a connection to a mainframe (os/390), then browse a VSAM file to look for a certain date range, extract those dates into an array, then close the connection.

I know how to issue an ftp function to actually download the VSAM file I need...however, this file is extremely large (which presents connection problems, etc).

Any ideas??

Thanks.

Posted: Mon Aug 04, 2003 10:10 pm
by fractalvibes
I feel your pain.... I'd suggest you post your question here:
http://groups.google.com/groups?hl=en&l ... es.ibm-db2

also, as it will probably take a certain amount of middle-ware. I tried a similar thing a couple of years ago, an ASP script calling a DB2 stored procedure written in COBOL running on the OS/390...turned out there were some os/390 memory management/task control block/etc. issues
that prevented this from being implemented, and IBM recommended against it strongly...I managed to completely bring down an entire DB2 subsytem (test, thank God!) and the server I was calling from.

So....they created processes to replicate data daily from VSAM to DB2,
used DB2 Connect and all is well, mostly.

No, I do not work for IBM, but developing ASP apps which must talk with DB2 has not always been an easy task!

Phil


I think with DB2 V 8 or perhaps 7.2, not sure!, there are some Data Integration products available now to access most anything; so try that DB2 list above - I think you will get some responses, and most likely from IBM DB2 people included.

Also - consider this a valuable site for DB2 info:

http://www7b.boulder.ibm.com/dmdd/