IBM has provided the OS/390 Java programmer with two access mechanisms to access DB2 data: Java Database Connectivity (JDBC) and SQLJ. Learn what will work best for you. Receive an overview of Java with DB2 in the OS/390 environment, view code snippets illustrating each access mechanism, and compare the strengths and weaknesses of JDBC versus SQLJ.
Marsh & McLennan Companies Inc. needed to find a way to reduce the amount of time clerks spent searching through stored data in order to answer inquiries. The move from a microfiche-based storage system to a computer output to laser disk (COLD) system in 1996 saved the firm 13,800 hours per year in time, previously spent searching for payroll, benefits and human resources information.
The Bank of America knows that keeping a competative edge means continually analyzing customer needs. Its Enterprise Data Warehouse, a DB2 database used for data mining, helps them meet their business goals. Recently, the bank upgraded the CPU processor to support this important application. Learn what steps were taken, and the results of the process.
The "Wild West" days of disaster recovery planning were a simpler time for networks. The hardware was tough, businesses had greater tolerances to outages and IT managers rode the range confident the homestead was safe. Today, businesses rely on the uninterrupted performance of its IT structure. More than trust in the resilience of hardware is required to safeguard an organization's information assets.
Although many business processes are being rapidly Web-enabled, the current integration of e-commerce and customer relationship management (CRM) solutions is a logical match with a potentially dramatic impact on the bottom line. CRM software needs to be integrated with the Web simply because that's where the customers are.
In today's OS/390 environment, hardware costs have declined substantially, while software costs are increasing dramatically to consume an ever-larger share of the IT budget. But, not all vendors price their products accordingly. A new tool for managing DB2 for OS/390 has entered the market, promising to save DB2 shops about $100,000 a year and allow for a more productive DB2 staff.
If your data is not available, your applications cannot run, and therefore, your company is losing business. Lost business translates into lower profitability and, perhaps, a lower stock valuation for your company. These are all detrimental to the business, so the DBA must do everything to ensure that databases are kept online and operational.
We're still hearing raging debates about "top down" architectures versus "bottom up" construction approaches to building data warehouse and data mart systems. The charges and counter-charges fly back and forth, with both sides claiming that theirs is the one, true, single way to build an EDW. This article examines the alternative architectures available, some of the market forces that are shaping the current and future BI architecture environment, and factors to consider when choosing your architectural path.
Watervliet Arsenal, the nation's oldest manufacturing arsenal, has two types of firepower; high-tech, high-powered weaponry; and the firepower that resides in a new document management system that went live in May of last year - Process Innovator, the first totally Web-centric Product Data Management and Electronic Document Management (PDM/EDM) system.
By combining organizational and technical solutions, companies hope to create a streamlined, Web-enabled organization running on integrated information and powered by super information engines along the fast track to 21st century success. Will it work?
When major pharmaceutical manufacturer Pfizer Inc. was looking for a way to deliver relevant, up-to-date sales and marketing information to its sales managers and representatives, it chose VIT's SeeChain for its portal and supply chain performance management applications.
Fast-food giant Wendy's International Inc. implements Innovation Data Processing's FDR/UPSTREAM, enabling the company to further utilize existing automation tasks through established backup and recovery procedures.
By giving “wheels” to conventional middleware, mobile agents have created a new class of intelligent, self-directed agents able to remotely execute processors at the data source and feed information to users. Even better, they manage to do it while reducing network overhead.
Heralded as the “Holy Grail of IT,” cross-platform information sharing actually has more to do with the security, integration and transaction of the data and less to do with simply providing users with common access.
As companies grow and their employee bases increase, database administrators struggle with DB2 security issues and ways to enhance their systems by time and cost-saving processes.
Employer's Reinsurance has deployed Cisco Database Connection and StarQuest's StarSQL Enterprise Edition data access middleware to connect thousands of Windows NT desktops located throughout the world via TCP/IP to its centralized IBM DB2 databases.
In a data sharing environment, where multiple DB2 subsystems read and update tables in shared mode, database recovery becomes more complex behind the scenes. Discover the major components involved in database recovery changes made in DB2 to support database recovery and some performance issues related to tecovery.
Bell Atlantic Mobile automates its backup and recovery process, managing REORGS for DBAs.
This article will examine the background of "mirroring," and the design challenges that accompanied the development of this remote copy solution.