by Bill Hedberg
Do you need to get System 1032 data into a report you are writing in Microsoft Word for your professional journal? Or into a PowerPoint presentation for a conference? You can install the System 1032 ODBC Driver and bring the data in through Microsoft Access 7.0.
If you are new to Microsoft Access or have not yet configured a connection to an ODBC data source, it might not be obvious how to do this. This article describes how to configure Microsoft Access to connect to a System 1032 ODBC data source.
For practice, use the following procedure to connect Microsoft Access to the S1032_IVP Data Source supplied with the System 1032 ODBC Driver installation kit. This procedure creates an empty database in Microsoft Access into which you can put System 1032 tables. This procedure assumes that you have already configured your client PC with System 1032 ODBC Driver data sources.
For more information on the System 1032 ODBC Driver, don't miss the IMPACT'98 presentation, "ODBC and OLE DB: Battle of the Acronyms."
National Australia Bank (NAB) has purchased the high-performance database marketing system, MarketPulse from CCA.
George Beatty, Head of Credit Card Services for NAB said, "MarketPulse excels in fast analysis of very large databases. It will give us new insights into customer needs and improve our ability to deliver the right services to our large base of credit card customers." Beatty said that MarketPulse was chosen after a worldwide search and extensive research.
For further information about NAB, see their Web site at http://www.national.com.au.
Excitement mounts as IMPACT'98 nears. The conference will be held this year in Miami, Florida. Model 204 sessions will run from May 31 to June 3, and System 1032 sessions will run from June 1 to June 3.
IMPACT'98 will feature an impressive lineup of papers from the user community, and some exciting presentations from CCA representatives.
User papers:
ODBC Connectivity to System 1032 Kevin Unck, Pomona College
Going to System 1032 from the Internet EZ Server Jerry Caldwell, 3M
From Database Fields to Web Page Susan Selhorst, Harvey Mudd College
This presentation describes how Harvey Mudd College has begun to make System 1032 data more generally available through Web pages.
CCA Presentations:
User Papers:
Data Transfer and Messaging at Centrelink Centrelink, Australian Government Service Delivery Agency
This presentation outlines Centrelink's various modes of data transfer with particular emphasis on IBM MQSeries as the preferred messaging transport vehicle.
To M.P. or not to M.P. Steve Betts, Marks & Spencer
This presentation describes the approach to evaluating the ability and cost effectiveness of Multi- Processor Option in expanding the capacity of the Marks & Spencer Model 204 system.
Automated Change Management System for Model 204 Paul McPhee, Calgary Police Service
This presentation walks through the change management process, highlighting the technical details.
Security in the Year 2000 Alex Kodat, Sirius Software
This presentation examines the security holes that the new technologies create, strategies for dealing with these holes, and tactics for managing the complex security environment of a modern computer network.
Weaving the Web with Model 204 Charlie Arehart, SystemManager
This tutorial and group discussion examines several alternatives for web-enabling Model 204.
MP/204 is the Model 204 multiprocessing facility, which makes full use of multiprocessor configurations on IBM mainframes and compatibles running MVS.
With MP/204, a single Online can exploit several processors simultaneously, executing user requests in parallel. Parallel processing increases throughput by giving the Model 204 address space additional CPU resources. An Online configured for MP/204 can handle more volume in a fixed amount of time, or reduce response time for multiple users for a fixed amount of work.
The amount of throughput gained by using the MP/204 feature depends on several factors, including CPU resources available, the amount of work that can be offloaded, and the benefit of offloading compared to the cost of task switching.
For users whose peak Model 204 load is near the limit of the engine size available, MP/204 is an attractive option. For large users whose Model 204 workload exceeds the power of a single processor, or for users who run out of time in overnight batch windows, the MP/204 feature is absolutely essential.
If your processing runs easily within one engine in the desired timeframe, the MP/204 option is not necessary.
You can think of performance in two ways:
Introduction of MP/204 significantly improves the response time experienced by individual users, because multiple users are simultaneously serviced, and the total throughput that a Model 204 system can deliver is greatly increased.
While many factors affect system performance and each site has its own unique characteristics, the following rule of thumb is a good starting point when deciding whether to implement MP/204, and how many subtasks to have:
These figures are indicative only. In the largest sites, where MP/204 is essential, Model 204 system managers must tune their environment to match the characteristics of their own processing.
For further information about MP/204, see the Model 204 System Manager's Guide, and be sure to attend the IMPACT'98 presentation titled "Scaling New Heights - Multiprocessing in Model 204."
Copyright © 2003 Computer Corporation of America. All right reserved. Published in the United States of America.
500 Old Connecticut Path, Framingham, MA 01701 webmaster@cca-int.com Copyright 2006
