I regularly see people ask how to access data on UNIX or Windows from apps on IBM's z/OS (mainframe) operating system.  However, I haven't been able to find anything that discusses the options.  Therefore, I'm using this post to provide the basics about one solution - using IBM's InfoSphere Federation Server as an interface.

This solution is for people running DB2 on z/OS.  It's probably best discussed with a simple example and a picture.  So, my example is - let's say you…

Hi:

In IBM Mexico we are looking for an DB2 Database Administrator. The person in this position will have two to three years of experience and strong technical experience. Please find the full job description for this position on our website: http://www.ibm.com/mx/employment/  Job Code ITD-0409585

I am sure you all know that you can configure db2 admin server and health monitor to send emails, but how do you send email from within

db2 luw itself. Much like SQLMAIL feature in our friend SQL Server , DB2 now have a mail feature. Starting from DB2 V9.7, there is an additional database configuration called SMTP_SERVER and built in stored procedure …

Testing DB2 OLEDB Provider using Microsoft Excel

 It is well known that from DB2 control center, one can test connectivity using configuration assistant for various providers like OLEDB , CLI , JDBC , ADO…