CN103838625B - Data interaction method and system - Google Patents
Data interaction method and system Download PDFInfo
- Publication number
- CN103838625B CN103838625B CN201410068857.7A CN201410068857A CN103838625B CN 103838625 B CN103838625 B CN 103838625B CN 201410068857 A CN201410068857 A CN 201410068857A CN 103838625 B CN103838625 B CN 103838625B
- Authority
- CN
- China
- Prior art keywords
- information
- output information
- mission operations
- operation output
- main frame
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Landscapes
- Debugging And Monitoring (AREA)
Abstract
The invention discloses a data interaction method and system. The method comprises the steps that job initial information input by a user is obtained, the job initial information at least comprises a job name, a program name and environment configuration information, and task job information is generated by splicing; according to the task job information, a task job is submitted to a host job queue; the host job queue is scanned, job output information is obtained, and after the job output information is subjected to formatting, formatting job output information is generated; and the formatting job output information is analyzed, and analyzed job output information is generated and is output and displayed at a user end.
Description
Technical field
The present invention relates to host data processing technology field, more particularly to a kind of method and system of data interaction.
Background technology
With the development of banking, the business being deployed on mainframe computer is more and more, and substantial amounts of end day business is needed
Want host batch to be processed, the process of host batch mainly passes through operation（Job）Mode realizing.Host operating system
Z/OS enters subsystem JES by operation（Job Entry Subsystem）Operation in system is controlled and is managed, is wrapped
Include from its exterior and receive operation, be scheduled, manage output of operation etc. to the operation in system, it is now widely used to be
JES2。
Main frame Z/OS transmits much information by the inside card reader that creates in system initialization to JES2, as run
The job control language JCL of task（Job Control Language）, START and MOUNT orders, TSO LOGON application etc..
While JES2 receives input data flows, also for one job identifier of each job assignment and by each operation
The control statement of JCL, JES2 and input data SYSIN of operation are stored in DASD data sets, and these data sets are referred to as
SPOOL data sets.JES2 is exactly to select operation to be processed from these SPOOL data sets.
Because JES2 does not have in itself interactive operation interface, therefore, it is many at present shared eventually using main frame timesharing is logged in
End TSO/E（Time Sharing Options/Extensions）Method, the submission of operation is carried out by hand and is checked, or
By main frame scheduling instrument TWS（Tivoli Workload Scheduler）The scheduling and timing for carrying out operation is submitted to.
When user needs to perform main frame operation, it is necessary to log on main frame TSO and write JCL operations and be submitted to JES2 queues
To complete, check that job run and output situation are also required to the system under main frame TSO and show lookup tool SDSF (System
Display and Search Facility) a series of instruction of interface input completing.And made using TWS instruments
The operation that the scheduling and timing of industry are submitted to is increasingly complex, needs to prepare TWS and job script in advance, by creating long-term plan
LTP（Long Term Plan）A batch jobs operation meter is customized with the method for current planning CP (Current Plan)
Draw, production plan can not be adjusted halfway, job run and being checked for output situation similarly need and checked in SDSF.
So, the exploitation and test that batch jobs are carried out in main frame submits relatively difficult to, has very high technology to want to user
Ask, while also consuming more resource and cost.
The content of the invention
Using prior art carry out in main frame batch jobs exploitation, test, submit to and advise it is relatively difficult and right
User has very high technical requirements, while also consuming more resource and cost.To solve foregoing problems, the present invention is proposed
A kind of method and system interacted with main frame operation, by interacting to main frame job queue formula and accessing existing skill is overcome
The inefficiency of art, the problems such as using difficulty.
To reach above-mentioned purpose, the present invention proposes a kind of method of data interaction, including：Obtain user input at least
Including the operation initial information including job name, program name, environment configuration information, assembly generates Mission Operations information；According to institute
Mission Operations information is stated, Mission Operations is submitted to main frame job queue；The main frame job queue is scanned, operation output letter is obtained
Breath, generates after the operation output information formatting is processed and formats operation output information；The parsing formatting operation is defeated
Go out information, generate the operation output information after parsing in user side output display.
To reach above-mentioned purpose, the invention allows for a kind of system of data interaction, the system include platform end and
Host side；The platform end includes：Operation assembly device, platform output device；The host side includes：Operation master control device and
Operation output information grabbing device；Wherein, operation assembly device, for obtain user input at least include job name, program
Name, environment configuration information generate Mission Operations information in interior operation initial information, assembly；Operation master control device, for basis
The Mission Operations information, submits Mission Operations to main frame job queue；Operation output information grabbing device, it is described for scanning
Main frame job queue, obtains operation output information, formatting operation is generated after the operation output information formatting is processed defeated
Go out information；Platform output device, for parsing the formatting operation output information, generates the operation output information after parsing and exists
User side output display.
By the method and system of the data interaction of the present invention, the crawl and analysis to job information in main frame queue is real
Environment modification, automatically batch submission, the monitoring of main frame operation are now initiated from platform end, is improve timely with what main frame operation was interacted
Property, accuracy, automaticity, reduce human intervention, effectively lifted to main frame operation and the efficiency of batch processing, ensure enterprise
Production test it is stable with it is efficient；And also main frame queue can repeatedly be interacted, it is more efficiently completed every host complex
Flow process and task.
Description of the drawings
Accompanying drawing described herein is used for providing a further understanding of the present invention, constitutes the part of the application, not
Constitute limitation of the invention.In the accompanying drawings：
Fig. 1 is the method flow diagram of the data interaction of one embodiment of the invention.
Fig. 2 is the structural representation of the data interaction system of one embodiment of the invention.
Fig. 3 A are the structural representation of operation assembly device in Fig. 2.
Fig. 3 B are the structural representation of operation master control device in Fig. 2.
Fig. 3 C are the structural representation of operation output information grabbing device in Fig. 2.
Fig. 3 D are the structural representation of platform output device in Fig. 2.
Fig. 4 is the method flow diagram of the data interaction of a specific embodiment of the invention.
Fig. 5 is the schematic diagram of the Mission Operations information of a specific embodiment of the invention.
Fig. 6 is the schematic diagram of the main frame job queue of a specific embodiment of the invention.
Fig. 7 is the schematic diagram of the job run result of a specific embodiment of the invention.
Fig. 8 is the schematic diagram of the platform end output display of a specific embodiment of the invention.
Specific embodiment
Hereinafter coordinate schema and presently preferred embodiments of the present invention, the present invention is expanded on further to reach predetermined goal of the invention institute
The technological means taken.
Fig. 1 is the method flow diagram of the data interaction of one embodiment of the invention.As shown in figure 1, the data interactive method bag
Include：
Step S101, obtain user input at least including at the beginning of the operation including job name, program name, environment configuration information
Beginning information, assembly generates Mission Operations information.
Step S102, according to Mission Operations information, submits Mission Operations to main frame job queue.
Step S103, scans main frame job queue, obtains operation output information, after the formatting of operation output information is processed
Generate and format operation output information.
Step S104, parsing form is turned into industry output information, generates the operation output information after parsing and exports in user side
Show.
In above-mentioned steps, step S101 and step S104 are in the platform end execution residing for user, step S102 and step
S103 is performed in host side, to complete data interaction.
The step of the present embodiment in S101, specifically comprise the following steps：
Step S1011, first, job name that user input host task operation is used, program name, environment configuration information,
Phase relation is in interior operation initial information before and after operation maximum return code, operation.
Step S1012, inquires about environment configurations table and obtains and operation initial information according to the operation initial information of user input
Corresponding configuration data.It is as shown in table 1 an example of configuration data：
Table 1
| Job name | Data base | Job library path | Maximum return code | Perform numbering |
| CBA5013 | GB02 | Job.aaaa.lib() | 4 | 1 |
| …… | …… | …… | …… | …… |
Step S1013, checks the legitimacy of configuration data, if configuration data cannot be generated or illegal,
User is needed to re-enter operation initial information.
Step S1014, according to configuration data, analyzes the implementation status of pre-execution Mission Operations, and pre-generatmg modification environment is matched somebody with somebody
The SQL statement put.
Step S1015, by SQL statement and the assembled generation Mission Operations information of configuration data.
The step of the present embodiment in S102, specifically comprise the following steps：
Step S1021, performs the SQL statement in Mission Operations information, changes at least including including program state control table
Task execution environment parameter.
Step S1022, according to the configuration data in Mission Operations information, closes according to item before and after Mission Operations inventory and operation
System, submits according to this corresponding Mission Operations to main frame job queue.
The step of the present embodiment in S103, specifically comprise the following steps：
Step S1031, when main frame job queue performs Mission Operations, scans main frame job queue, the fortune to Mission Operations
Row monitoring state, by comparing with preset configuration table, the Job execution time or operation for obtaining Mission Operations is returned
Code is returned, abnormality processing is carried out.
Preset configuration table includes the parameters such as job name, program name, default return code, is as shown in table 2 preset configuration table
One example：
Table 2
| Job name | Program name | Maximum execution time（min） | Return code maximum permissible value |
| ABC | AAA | 10 | 4 |
| …… | …… | …… | …… |
When the Job execution time value in preset configuration table is exceeded, interrupt and perform this subjob；
When operation return code is more than the maximum permissible value in preset configuration table, interrupts and perform this subjob.
Step S1032, scans main frame job queue, and according to configuration data the execution feelings of its corresponding Mission Operations are judged
Condition, after the completion of operation tasks carrying, captures the operation output information of Mission Operations.
Step S1033, generates after the formatting of operation output information is processed and formats operation output information.
The step of the present embodiment in S104, specifically comprise the following steps：
Step S1041, parsing form is turned into industry output information, generates the operation output information output display after parsing to use
Family.
Step S1042, user is selected and is judged according to the operation output information after parsing, and initiating new operation please
Ask, be input into new operation initial information, repeatedly interacted.
Carry out the method that work data is interacted with main frame by above-mentioned, crawl to job information in main frame queue and point
Analysis, realizes that the environment for initiating main frame operation from user side is changed, batch is submitted to, monitoring automatically, overcomes current manual mode and steps on
Land main frame is submitted to and checks batch jobs implementation status, empirically judging batch processing implementation status, in promptness, accurately
Property, automaticity aspect cannot guaranteed difficulty, reduce human intervention, effectively lifted to main frame operation and batch processing
Efficiency.
Based on same inventive concept, additionally provide in the embodiment of the present invention it is a kind of carry out that work data interacts with main frame be
System, as described in the following examples.Due to the principle of data interaction system solve problem it is similar to data interactive method, therefore number
The enforcement of data interactive method is may refer to according to the enforcement of interactive system, is repeated part and is repeated no more.It is used below, term
" unit " or " module " can realize the software of predetermined function and/or the combination of hardware.Although described by following examples
System is preferably realized with software, but hardware, or the realization of the combination of software and hardware is also may and to be contemplated.
Fig. 2 is the structural representation of the data interaction system of one embodiment of the invention.As shown in Fig. 2 the system includes
Platform end 1 and host side 2；Platform end 1 includes：Operation assembly device 11, platform output device 12；Host side 2 includes：Operation is total
Control device 21 and operation output information grabbing device 22.Wherein,
Operation assembly device 11, for obtaining at least existing including job name, program name, environment configuration information for user input
Interior operation initial information, assembly generates Mission Operations information.
Operation master control device 21, for according to Mission Operations information, submitting Mission Operations to main frame job queue.
Operation output information grabbing device 22, for scanning main frame job queue, obtains operation output information, and operation is defeated
Go out to be generated after information formatization is processed and format operation output information.
Platform output device 12, for parsing form industry output information is turned into, and is generated the operation output information after parsing and is existed
User side output display.
In order to carry out apparent explanation to data interaction system, with reference to Fig. 3 A to Fig. 3 D for each in system
Individual device is described in detail.
Fig. 3 A are the structural representation of the operation assembly device at platform end in Fig. 2.As shown in Figure 3A, operation assembly device 11
Including：Configuration data acquisition module 111, validity checking module 112, SQL statement generation module 113, assembling module 114.Its
In,
Configuration data acquisition device 111 is used to inquire about environment configurations table and obtain according to operation initial information initially to believe with operation
Cease corresponding configuration data.
Validity checking module 112, for checking the legitimacy of configuration data, if configuration data cannot be generated
Or it is illegal, then need user to re-enter operation initial information.
SQL statement generation module 113, for according to configuration data, analyzing the implementation status of pre-execution Mission Operations, pre- life
Into the SQL statement of modification environment configurations.
Assembling module 114, for SQL statement and configuration data assembly to be generated into Mission Operations information.
In the present embodiment, first, when user initiates job request, can be in the operation initial information of the input of platform end 1；
There is its special form because host side 2 processes JCL operations, so the Mission Operations information that platform end 1 is submitted to has to comply with master
Machine JCL job specifications.Operation assembly device 11 can inquire about environment configurations table to obtain corresponding main frame according to operation initial information
DB2 database/job library/production plan（Plan）Deng system configuration scenarios, Mission Operations situation, pre- life need to be performed by analysis
It is then assembled to generate Mission Operations letter into the SQL statement in interior task execution environment parameter such as program execution state table is changed
Breath, is sent Mission Operations information to host side 2 by modes such as FTP, SOCKET, and transmitting path can be file=jes, submit to
Into the job queue of the subsystem JES2 of host side 2.
Fig. 3 B are the structural representation of the operation master control device of host side in Fig. 2.As shown in Figure 3 B, the operation of host side 2
The Mission Operations information that 21 receiving platform end of master control device 1 sends, the device includes：
Ambient parameter modified module 211, for performing Mission Operations information in SQL statement, modification at least include program
State control table is in interior task execution environment parameter.
Mission Operations submit module 212 to, for the configuration data in Mission Operations information, according to Mission Operations inventory
With n-th-trem relation n before and after operation, in submitting the subsystem JES2 job queues of corresponding Mission Operations to host side 2 to according to this.
Fig. 3 C are the structural representation of the operation output information grabbing device of host side in Fig. 2.As shown in Figure 3 C, operation is defeated
Going out information scratching device 22 includes：
Main frame job queue monitoring module 221, for scanning main frame job queue, is carried out to the running status of Mission Operations
Monitoring, by comparing with preset configuration table, obtains Job execution time or the operation return code of Mission Operations, carries out different
Often process；
When the Job execution time value in preset configuration table is exceeded, interrupt and perform this subjob；
When operation return code is more than the maximum permissible value in preset configuration table, interrupts and perform this subjob.
Operation output information handling module 222, for scanning main frame job queue, judges that its is corresponding according to configuration data
The implementation status of Mission Operations, after the completion of operation tasks carrying, captures the operation output information of Mission Operations.
Operation output information formatting module 223, is turned into for generating form after the formatting of operation output information is processed
Industry output information.
Fig. 3 D are the structural representation of the platform output device at platform end in Fig. 2.As shown in Figure 3 D, platform output device 12
Including：
Operation output information parsing module 121, for parsing form industry output information is turned into, and the operation generated after parsing is defeated
Go out information；Mistake numbering in operation output information after parsing can be converted to detailed Chinese output information by the module, raw
Into the job run result of a specification.
Output display module 122, for by the operation output information output display after parsing to user.
Interaction judge module 123, is selected and is judged for user according to the operation output information after parsing, initiates new
Job request, new operation initial information is input into, so as to realize the multiple interaction with host side 2.
Said system can be separately positioned on user side（Such as windows platform, Linux platform）With host side（Such as IBM master
Machine）, user can pass through platform end 1 and communicate with the subsystem JES2 in host side 2, by good Mission Operations batch prepared in advance
It is submitted to main frame job queue；The unique JobID values of fixation that Mission Operations are endowed when running into main frame queue, position specific
Main frame job position, obtains relative position value Pos being endowed during Mission Operations end of run and carrys out positioning operation running status.
System is got behind the state of Mission Operations and position, is shown and the ST methods in lookup tool SDSF using system
Main frame queue the job list is obtained from Data buffer SPOOLing, by given filter parameter model PREFIX and DDNAME
The interim Hosts file of condition filter, circular definition and reading storage operation output information is carried out, interim main frame is defined and generate
File, obtains the operation return code and output details of job run, so as to realizing the monitoring to Mission Operations, control and managing
Reason.
With reference to foregoing teachings, Fig. 4 is the method flow diagram of the data interaction of a specific embodiment of the invention.As shown in figure 4,
Data interactive method includes：
Step S401, user initiates job request at platform end, is input into operation initial information.
Step S402, inquires about environment configurations table and generates configuration data according to initial information.
Step S403, judges whether configuration data can generate, if legalIf cannot generate or not conform to rule returns step
Rapid S401, if can generate and it is legal if execution step S404.
Step S404, generates SQL statement, and generates Mission Operations information with configuration data assembly, sends to host side.
Step S405, host side receives Mission Operations information, performs SQL statement, changes task execution environment parameter.
Step S406, submits Mission Operations to main frame job queue.
Step S407, monitor task operation is compared with preset configuration table, obtains Job execution time or operation return code,
Carry out abnormality processing.
Whether step S408, operation return code, more than maximum permissible value in preset configuration table, is to interrupt this subjob, no
Then execution step S409.
Whether step S409, the Job execution time exceed the value in preset configuration table, is to interrupt this subjob, otherwise after
Continuous execution step S410.
Step S410, judges whether Mission Operations queue is finished, and is then execution step S411, otherwise return to step
S406。
Step S411, captures the operation output information of the corresponding Mission Operations of configuration data.
Step S412, generates after the formatting of operation output information is processed and formats operation output information, and back pass is to platform
End.
Step S413, platform end receives and formats operation output information and parse, and generates the operation output information after parsing
Carry out output display.
Whether step S414, user is repeatedly interacted, and carries out repeatedly interaction then return to step S401, initiates new operation
Request, otherwise terminates this data interaction.
In order to carry out apparent explanation to above-mentioned data interactive method and device, with reference to a specific enforcement
Example is illustrating, however, it should be noted that the embodiment merely to the present invention is better described, is not constituted to this
It is bright improperly to limit.
In a particular embodiment, the program for being arranged on platform end is made up of JAVA programs, for input information to be converted to
The main frame JCL of standard（Job Control Language）Operation, and upload files to host side；It is arranged on the work in host side
Tool is by main frame operation JCL（Job Control Language）Operation and mastery routine REXX（Restructured extender
executor）Program is constituted.Wherein, JCL operations are used to configure the parameters such as DB2 database/job library/production plan, fixed
Adopted input-output file, and generate desired parameters calling REXX programs, REXX programs are used to completing Mission Operations submitting to, call
System tool obtaining queuing message, location tasks job run state, lower biography job run output result etc..Finally by platform
JAVA programs result passed under being changed and be represented.
Concrete operations flow process is as follows：First, user starts desktop tool, input initial job information etc., the assembled dress of operation
Put obtain interface input job name, program name, environment configuration information, batch number, whether change PABPC table PROCSTAT etc. letter
Breath, as shown in table 3.Operation assembly device is by above- mentioned information match query environment configurations table, as shown in table 4, assembled generation task
Job information AUTSUB11, and Mission Operations information AUTSUB11 is uploaded to into host side.
Table 3
Table 4
| ID | AREA | ENV | SUBAREA | FILENAME | JCLLIB |
| 43 | It is domestic | Comprehensive A | Personal subregion | %.T.CBBSP.B0%.% | NGPCBBS.TP.CBBS.% |
| 44 | It is domestic | Comprehensive A | To centimetre area | %.T.CBBSC.B0%.% | NGPCBBS.TC.CBBS.% |
| 45 | Domestic number is handed over | Comprehensive A | Personal subregion | %.T.CBBSP.B2%.% | NGPCBBS.TP.DSWP.% |
| 46 | Domestic number is handed over | Comprehensive A | To centimetre area | %.T.CBBSC.B2%.% | NGPCBBS.TC.DSWP.% |
| 47 | Abroad | Comprehensive A | It is Asia-Pacific | %.T.CBBSA.B0%.% | NGPCBBS.OT.CBBS.% |
| 48 | Abroad | Comprehensive A | European Area | %.T.CBBSA.B0%.% | NGPCBBS.UT.CBBS.% |
| 49 | Abroad | Comprehensive A | America area | %.T.CBBSA.B0%.% | NGPCBBS.MT.CBBS.% |
Host side is received after Mission Operations information AUTSUB11, submits Mission Operations to main frame queue.With reference to Fig. 5 institutes
Show, be the schematic diagram of Mission Operations information, job name, program name, environment configuration information are input into as job parameter, are divided into
Two job steps of AUTO and PRNT, AUTO job steps call main frame operation master control device, PRNT job steps to call operation master control to fill
Put, operation output information grabbing device.
Operation master control device according to the configuration information that obtains from AUTSUB11 submit to operation task operation CBA5013 and
CBA5113, is the schematic diagram of the main frame job queue of a specific embodiment of the invention, by PCOMM instruments with reference to shown in Fig. 6
Main frame is logged in, is checked after interface into SD.ST main frame queues, be filtered into and just look at the sectional drawing that this user submits operation to.It is highlighted
The AUTSUB11 of display represents that operation is currently running, and CBA5013 and CBA5113 are represented with dimmed font, shows that job state is
Have been filed on waiting to run, Pos states are 18 and 19, operation ID is J0157844 and J0157845.
Operation is submitted to after operation, the running status of operation output information grabbing device monitor task operation, and by task
After the Information locating Mission Operations such as job name, the operation ID and Pos state of operation, system is read from main frame distribution management table every
Parameter, is monitored according to Mission Operations information and parameter to job queue, crawl each job step of Mission Operations SYSOUT steps
Rapid output information, and be formatted process to operation output information, at the end of Mission Operations are performed, host side is by form
Operation output information after change is transferred to the platform output device at platform end, is a specific embodiment of the invention with reference to shown in Fig. 7
Job run result schematic diagram.
Platform termination is received after the operation output information after formatting, and first operation output information is parsed, and generates solution
Job execution result after analysis, as shown in figure 8, Fig. 8 is the schematic diagram of the platform end output display of a specific embodiment of the invention.
Platform output device carries out output displaying to the Job execution result and output information after parsing, user can according to implementing result and
Output information does next step and selects and judge, for example：User can be input into new request send to operation assembly device initiate it is new
Mission Operations are asked, so as to realize the multiple interaction with main frame.
By the method and system of the data interaction of the present invention, the crawl and analysis to job information in main frame queue is real
Environment modification, automatically batch submission, the monitoring of main frame operation are now initiated from platform end, is improve timely with what main frame operation was interacted
Property, accuracy, automaticity, reduce human intervention, effectively lifted to main frame operation and the efficiency of batch processing, ensure enterprise
Production test it is stable with it is efficient；And also main frame queue can repeatedly be interacted, it is more efficiently completed every host complex
Flow process and task.
Particular embodiments described above, has been carried out further in detail to the purpose of the present invention, technical scheme and beneficial effect
Describe in detail it is bright, should be understood that the foregoing is only the present invention specific embodiment, the guarantor being not intended to limit the present invention
Shield scope, all any modification, equivalent substitution and improvements within the spirit and principles in the present invention, done etc., should be included in this
Within the protection domain of invention.
Claims (10)
1. a kind of method of data interaction, it is characterised in that include：
Obtain user input at least includes the operation initial information including job name, program name, environment configuration information, assembled to give birth to
Into Mission Operations information；
According to the Mission Operations information, Mission Operations are submitted to main frame job queue；
The main frame job queue is scanned, operation output information is obtained, is generated after the operation output information formatting is processed
Format operation output information；
The parsing formatting operation output information, generates the operation output information after parsing in user side output display；
Wherein, the operation initial information for obtaining user input, assembly generates Mission Operations information to be included：
The operation initial information of user input is obtained, environment configurations table is inquired about according to the operation initial information and is obtained and the work
The corresponding configuration data of industry initial information；
The legitimacy of the configuration data is checked, if the configuration data cannot be generated or illegal, user is needed
Re-enter operation initial information；
According to the configuration data, the implementation status of pre-execution Mission Operations is analyzed, pre-generatmg changes the SQL languages of environment configurations
Sentence；
By the SQL statement and the assembled generation Mission Operations information of the configuration data；
Wherein, the main frame job queue is scanned, obtains operation output information, after the operation output information formatting is processed
Generating formatting operation output information includes：
The main frame job queue is scanned, the running status of the Mission Operations is monitored, by entering with preset configuration table
Row is compared, and obtains the Job execution time of the Mission Operations, carries out abnormality processing；
When the Job execution time value in the preset configuration table is exceeded, interrupt and perform this subjob.
2. method according to claim 1, it is characterised in that described according to the Mission Operations information, submits to task to make
Industry to main frame job queue includes：
The SQL statement in the Mission Operations information is performed, is changed at least including the tasks carrying including program state control table
Ambient parameter；
Configuration data in Mission Operations information submits corresponding Mission Operations to main frame job queue.
3. method according to claim 2, it is characterised in that the scanning main frame job queue, obtains operation defeated
Go out information, generate after the operation output information formatting is processed and format operation output information, also include：
The main frame job queue is scanned, the running status of the Mission Operations is monitored, by entering with preset configuration table
Row is compared, and obtains the operation return code of the Mission Operations, carries out abnormality processing；
When the operation return code is more than the maximum permissible value in the preset configuration table, interrupts and perform this subjob.
4. method according to claim 3, it is characterised in that the scanning main frame job queue, obtains operation defeated
Go out information, formatting operation output information is generated after the operation output information formatting is processed also to be included：
The main frame job queue is scanned, the implementation status of its corresponding Mission Operations is judged according to the configuration data, work as institute
State after the completion of job task performs, capture the operation output information of the Mission Operations, and by the operation output information form
Change is generated after processing and formats operation output information.
5. method according to claim 4, it is characterised in that the parsing is described to format operation output information, generates
Operation output information after parsing includes in user side output display：
The user is selected and is judged according to the operation output information after the parsing, initiates new job request, input
New operation initial information.
6. a kind of system of data interaction, it is characterised in that the system includes platform end and host side；The platform end bag
Include：Operation assembly device, platform output device；The host side includes：Operation master control device and operation output information crawl dress
Put；Wherein,
Operation assembly device, for obtain user input at least including the work including job name, program name, environment configuration information
Industry initial information, assembly generates Mission Operations information；
Operation master control device, for according to the Mission Operations information, submitting Mission Operations to main frame job queue；
Operation output information grabbing device, for scanning the main frame job queue, obtains operation output information, by the operation
Output information formatting is generated after processing and formats operation output information；
Platform output device, for parse it is described formatting operation output information, generate parsing after operation output information with
Family end output display；
Wherein, the operation assembly device includes：
Configuration data acquisition module, obtains initial with the operation for inquiring about environment configurations table according to the operation initial information
The corresponding configuration data of information；
Validity checking module, for checking the legitimacy of the configuration data, if the configuration data cannot give birth to
Into or it is illegal, then need user to re-enter operation initial information；
SQL statement generation module, for according to the configuration data, analyzing the implementation status of pre-execution Mission Operations, pre-generatmg
The SQL statement of modification environment configurations；
Assembling module, for the SQL statement and configuration data assembly to be generated into Mission Operations information；
Wherein, the operation output information grabbing device includes：
Main frame job queue monitoring module, for scanning the main frame job queue, enters to the running status of the Mission Operations
Row monitoring, by comparing with preset configuration table, obtains the Job execution time of the Mission Operations, carries out abnormality processing；
When the Job execution time value in the preset configuration table is exceeded, interrupt and perform this subjob.
7. system according to claim 6, it is characterised in that the operation master control device includes：
Ambient parameter modified module, for performing the Mission Operations information in SQL statement, modification at least include program state
Control table is in interior task execution environment parameter；
Mission Operations submit module to, and corresponding Mission Operations are submitted to main frame for the configuration data in Mission Operations information
Job queue.
8. system according to claim 7, it is characterised in that the main frame job queue monitoring module is additionally operable to obtain institute
The operation return code of Mission Operations is stated, abnormality processing is carried out；
When the operation return code is more than the maximum permissible value in the preset configuration table, interrupts and perform this subjob.
9. system according to claim 8, it is characterised in that the operation output information grabbing device also includes：
Operation output information handling module, for scanning the main frame job queue, judges that its is corresponding according to the configuration data
Mission Operations implementation status, after the completion of the job task is performed, capture the operation output information of the Mission Operations；
Operation output information formatting module, it is defeated for generating formatting operation after the operation output information formatting is processed
Go out information.
10. system according to claim 9, it is characterised in that the platform output device includes：
Operation output information parsing module, for parsing the formatting operation output information, generates the operation output after parsing
Information；
Output display module, for giving the user by the operation output information output display after parsing；
Interaction judge module, is selected and is judged for the user according to the operation output information after the parsing, is initiated
New job request, is input into new operation initial information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410068857.7A CN103838625B (en) | 2014-02-27 | 2014-02-27 | Data interaction method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410068857.7A CN103838625B (en) | 2014-02-27 | 2014-02-27 | Data interaction method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103838625A CN103838625A (en) | 2014-06-04 |
| CN103838625B true CN103838625B (en) | 2017-05-17 |
Family
ID=50802156
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410068857.7A Active CN103838625B (en) | 2014-02-27 | 2014-02-27 | Data interaction method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103838625B (en) |
Families Citing this family (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104182683B (en) * | 2014-07-30 | 2017-10-13 | 中国工商银行股份有限公司 | A kind of monitoring method of online transaction, apparatus and system |
| CN104933618B (en) * | 2015-06-03 | 2018-05-11 | 中国银行股份有限公司 | Core banking system batch jobs run the monitoring method and device of data |
| CN106484866B (en) * | 2016-10-10 | 2019-09-03 | 中国银行股份有限公司 | A kind of batch data processing method and processing device |
| CN110381106A (en) * | 2019-05-09 | 2019-10-25 | 中国银行股份有限公司 | A kind of job processing method and device |
| CN110380936B (en) * | 2019-07-23 | 2021-05-14 | 中国工商银行股份有限公司 | Test method and device |
| CN110515864B (en) * | 2019-08-14 | 2020-12-04 | 中国建设银行股份有限公司 | Method and device for automatically submitting operation to large host based on operation and maintenance terminal |
| CN112035230B (en) * | 2020-09-01 | 2023-08-18 | 中国银行股份有限公司 | Task scheduling file generation method, device and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101042648A (en) * | 2007-04-20 | 2007-09-26 | 北京航空航天大学 | Plug-in component, system and method for providing unionize interface for multicell application |
| CN101645022A (en) * | 2009-08-28 | 2010-02-10 | 曙光信息产业(北京)有限公司 | Work scheduling management system and method for a plurality of colonies |
| CN102226890A (en) * | 2011-06-10 | 2011-10-26 | 中国工商银行股份有限公司 | Monitoring method and device for host batch job data |
-
2014
- 2014-02-27 CN CN201410068857.7A patent/CN103838625B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101042648A (en) * | 2007-04-20 | 2007-09-26 | 北京航空航天大学 | Plug-in component, system and method for providing unionize interface for multicell application |
| CN101645022A (en) * | 2009-08-28 | 2010-02-10 | 曙光信息产业(北京)有限公司 | Work scheduling management system and method for a plurality of colonies |
| CN102226890A (en) * | 2011-06-10 | 2011-10-26 | 中国工商银行股份有限公司 | Monitoring method and device for host batch job data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103838625A (en) | 2014-06-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103838625B (en) | Data interaction method and system | |
| US9852196B2 (en) | ETL tool interface for remote mainframes | |
| US11087249B2 (en) | Method and apparatus for triggering execution of a workflow over a network | |
| US11651272B2 (en) | Machine-learning-facilitated conversion of database systems | |
| US20170011135A1 (en) | Conversion Automation through Data and Object Importer | |
| US20220207268A1 (en) | Form extractor | |
| CN110389834A (en) | A kind of method and apparatus for submitting deep learning training mission | |
| US20150081832A1 (en) | Managing seed data | |
| US8024706B1 (en) | Techniques for embedding testing or debugging features within a service | |
| US20140041059A1 (en) | Analyzing apparatus validating system and program for the system | |
| US9471479B2 (en) | Method and system for simulating job entry subsystem (JES) operation | |
| US20090241075A1 (en) | Test chip validation and development system | |
| CN111651470A (en) | Unified SQL execution and query method and system | |
| JPH06348766A (en) | Method and device for incorporating tool | |
| CN115080663A (en) | Distributed database synchronization method, system, device and medium | |
| US20220138089A1 (en) | Smart test executor | |
| US7734665B2 (en) | System and method for providing database utilities for mainframe operated databases | |
| JP4583260B2 (en) | General-purpose computer operation procedure creation device, program, and storage medium | |
| Cisco | Installing ISM | |
| US20080022258A1 (en) | Custom database system and method of building and operating the same | |
| US8631393B2 (en) | Custom database system and method of building and operating the same | |
| US20220382236A1 (en) | Shared automated execution platform in cloud | |
| CN111881155B (en) | Data query method, data query device and electronic equipment | |
| US20220147568A1 (en) | Mapping expression generator | |
| CN112819554B (en) | Service processing method and device based on page operation and computer equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |