I don't know much about IBM DB2 databases. We have some SSIS packages which are presently run through a JAVA website by user once they get email notification of completion of Updates in a DB2 database.
我对IBM DB2数据库知之甚少。我们有一些SSIS包,一旦他们收到DB2数据库中更新完成的电子邮件通知,用户就会通过JAVA网站运行这些包。
Now they want to automate the process i.e automatically triggering the SSIS packages to run after updates in DB2.
现在,他们希望自动化该过程,即自动触发在DB2中更新后运行的SSIS包。
The DB2 users say that they do the updates in DB2 though some batch. I am not sure what they mean by "batch". Can anyone who is good in DB2 explain about "batch" and how to connect to the SSIS server or the JAVA program from that batch.
DB2用户表示他们通过某些批处理在DB2中进行更新。我不确定“批处理”是什么意思。任何擅长DB2的人都可以解释“批处理”以及如何从该批处理连接到SSIS服务器或JAVA程序。
It looks like it may need connecting from mainframe servers to windows server?
看起来它可能需要从大型机服务器连接到Windows服务器?
I don't know Java but I am good in C#/VB.Net/SQL. Any solution in C# is also welcome.
我不懂Java,但我很擅长C#/ VB.Net / SQL。 C#中的任何解决方案也是受欢迎的。
1 个解决方案
#1
1
A program on an IBM Mainframe which runs in "batch" is one that has no interaction with users.
以“批处理”运行的IBM大型机上的程序是与用户无交互的程序。
Batch programs typically carry out the main workload of systems. Users enter "stuff" in the "online" system. When the online is finished, the Batch programs are run to process all the "stuff" against "existing stuff" and provide "new stuff" for the next online session.
批处理程序通常执行系统的主要工作量。用户在“在线”系统中输入“stuff”。当在线完成时,运行批处理程序以处理针对“现有东西”的所有“东西”并为下一个在线会话提供“新东西”。
The gap between the online sessions is often termed the "Batch Window". Online has to be "up" at a particular time, so all the Batch programs have to complete within the Batch Window.
在线会话之间的差距通常被称为“批处理窗口”。在线必须在特定时间“启动”,因此所有批处理程序必须在批处理窗口内完成。
That's the simplistic version of the "traditional" process. These days, there is some blurring, but a "batch" program runs without interaction.
这是“传统”过程的简单版本。这些天,有一些模糊,但“批处理”程序运行没有交互。
There are many ways in which a batch program can let another system know that a particular state has been reached. These can involve the Scheduler product on the Mainframe, message queues, file transfers, email, etc.
批处理程序可以通过多种方式让另一个系统知道已达到特定状态。这些可能涉及大型机上的Scheduler产品,消息队列,文件传输,电子邮件等。
The Mainframe "Production Control" people for your Mainframe site very probably have a preferred way for you to do this already in place and being used.
大型机网站的主机“生产控制”人员可能已经有了一种首选方式,您可以在现场使用并使用它们。
You need to locate them. Talk nicely to anyone you know who works with the Mainframe, call the Help Desk, ask your colleagues. Via whatever method, you need to find the people who already know what you should be doing at your site. And that isn't us.
你需要找到它们。与您认识的使用大型机的任何人交谈,致电服务台,询问您的同事。通过任何方法,您需要找到已经知道您应该在您的网站上做什么的人。那不是我们。
In the unlikely event that no means already exists, they are still the people who will decide, and along with the equivalent people on the Windows side. It won't be something you are taking from the internet, or inventing yourself.
在不太可能发生的情况下,他们仍然是将要决定的人,以及Windows端的同等人员。这不是你从互联网上获取的东西,也不是你自己创造的东西。
#1
1
A program on an IBM Mainframe which runs in "batch" is one that has no interaction with users.
以“批处理”运行的IBM大型机上的程序是与用户无交互的程序。
Batch programs typically carry out the main workload of systems. Users enter "stuff" in the "online" system. When the online is finished, the Batch programs are run to process all the "stuff" against "existing stuff" and provide "new stuff" for the next online session.
批处理程序通常执行系统的主要工作量。用户在“在线”系统中输入“stuff”。当在线完成时,运行批处理程序以处理针对“现有东西”的所有“东西”并为下一个在线会话提供“新东西”。
The gap between the online sessions is often termed the "Batch Window". Online has to be "up" at a particular time, so all the Batch programs have to complete within the Batch Window.
在线会话之间的差距通常被称为“批处理窗口”。在线必须在特定时间“启动”,因此所有批处理程序必须在批处理窗口内完成。
That's the simplistic version of the "traditional" process. These days, there is some blurring, but a "batch" program runs without interaction.
这是“传统”过程的简单版本。这些天,有一些模糊,但“批处理”程序运行没有交互。
There are many ways in which a batch program can let another system know that a particular state has been reached. These can involve the Scheduler product on the Mainframe, message queues, file transfers, email, etc.
批处理程序可以通过多种方式让另一个系统知道已达到特定状态。这些可能涉及大型机上的Scheduler产品,消息队列,文件传输,电子邮件等。
The Mainframe "Production Control" people for your Mainframe site very probably have a preferred way for you to do this already in place and being used.
大型机网站的主机“生产控制”人员可能已经有了一种首选方式,您可以在现场使用并使用它们。
You need to locate them. Talk nicely to anyone you know who works with the Mainframe, call the Help Desk, ask your colleagues. Via whatever method, you need to find the people who already know what you should be doing at your site. And that isn't us.
你需要找到它们。与您认识的使用大型机的任何人交谈,致电服务台,询问您的同事。通过任何方法,您需要找到已经知道您应该在您的网站上做什么的人。那不是我们。
In the unlikely event that no means already exists, they are still the people who will decide, and along with the equivalent people on the Windows side. It won't be something you are taking from the internet, or inventing yourself.
在不太可能发生的情况下,他们仍然是将要决定的人,以及Windows端的同等人员。这不是你从互联网上获取的东西,也不是你自己创造的东西。