Help/Systems



HOME    SUBSCRIBE

  The Four Hundred

Editor: Timothy Prickett Morgan       Managing Editor: Shannon Pastore
Contributing Editors: Joe Hertvik
Shannon O'Donnell
Victor Rozek
Alex Woodie

    Symtrax

    In the December 17, 2001,  Issue:

    Warning: IBM Tells VARPG Developers Not to Use SP4

    by Shannon O'Donnell

    If you're one of those folks who just couldn't wait to download Service Pack 4 for the WebSphere Development Studio (5769-WDS) development package, you may be in for a problem if you develop and distribute applications using VisualAge for RPG.

    In a December 6 posting to the VARPG newsgroup, IBM Toronto's Clauss Weiss, long recognized as the leader of all things VARPG, said that the WDS Service Pack 4, which was just made available November 14, contains a bug that will cause your communications connection to drop when calling an OS/400 program from a VARPG application.

    Apparently only two lines of code in the communications module were changed, but as any programmer will tell you, it doesn't take much to make a program stop working correctly. According to Weiss, the symptom you'll see, besides the communication session dropping, is a socket reset message in the job log.

    Weiss goes on to say that IBM Toronto is recommending that you do not use SP4 in your VARPG development environment and that you absolutely do not package the SP4 runtime in your distributables. IBM is working on a fix for this problem, which probably won't be available until the next service pack is released.

    If you have already installed SP4 and you are developing applications in VARPG, you should uninstall the new service pack immediately. However, since there is no easy way to uninstall a service pack, your only solution is to uninstall the complete WebSphere Development Studio package, reboot your PC, reinstall WebSphere Development Studio, and then install the last known working service pack, SP3. As long as you don't manually delete your project files using Windows Explorer, or a similar tool, you shouldn't lose any of your work. When WebSphere Development Studio is reinstalled, it will not overlay your existing project files.

     

    SPONSORED BY HELP/SYSTEMS

    ROBOT/REPLAY 2.0 AUTOMATES ISERIES BATCH JOBS that require input before processing begins. Use it with JD Edwards, JBA, BRMS, MAPICS, BPCS, PRISM, Infinium, and others. Stores your keystrokes in a reusable object, similar to a PC macro. New feature eliminates object/device conflict. Supports FTP and TCP/IP.

    Visit: http://www.helpsystems.co m/ad_in.cgi?ad_id=32




    MAPICS Ports OS/400 ERP Suite to Java

    by Timothy Prickett Morgan

    Longtime OS/400 application software vendor MAPICS two weeks ago announced the general availability of a Java-based version of the MAPICS ERP for iSeries suite of software, formerly known as MAPICS XA.

    MAPICS has a long history in the IBM midrange. It was founded in 1980 and soon became part of Big Blue itself. After being spun out from IBM, MAPICS was acquired by various companies and was involved in a merger with Marcam Solutions, a specialist in enterprise software for process manufacturers that complemented MAPICS' own expertise in discrete manufacturing software. That marriage didn't last long, because synergies between the organizations did not pan out, and MAPICS was reincorporated in 1998 as a separate company and headquartered in Atlanta, long a hot-bed of OS/400 application development because of IBM's nearby General Services Division, which handled software for IBM's midrange platforms. (Marcam subsequently was eaten by Invensys, a British factory controller maker and ERP software vendor that also owns the Wonderware and Baan software suites.) In January 2000, MAPICS bought Pivotpoint, a vendor of ERP, SCM, and CRM applications for the Windows server platform.

    A year earlier, MAPICS had announced a deal with International Business Systems, the Swedish OS/400 applications software vendor, to create a Java-based application suite based on IBM's SanFrancisco frameworks, a set of application templates IBM developed and promoted before the Enterprise JavaBean standard was established. According to sources at MAPICS, the IBS partnership was abandoned two years ago when it became clear to MAPICS that the best thing it could do was offer customers distinct ERP applications, extended with CRM and SCM modules, that were tailored specifically for the OS/400 or Windows platform.

    This strategy seems to be exactly the opposite of that chosen by Intentia International, another big Swedish OS/400 application vendor that also happens to be one of the biggest midrange ISVs in the world. Intentia is on its second generation of Java applications in the Movex NextGen suite, which was ported from RPG running on OS/400, to Java running on OS/400 and Windows. To each his own. MAPICS firmly believes that creating one ERP platform for both OS/400 and Windows is the wrong approach. Then again, it has two very distinct application code bases and customer installed bases, and bringing them together would be impossible without upsetting its 3,500 customers worldwide. Intentia didn't have any Windows customers to try to appease with a Java release based on its RPG code.

    At the end of October, MAPICS announced that it had ported the core MAPICS ERP for iSeries modules from RPG to Java, and that it had ported the code so it would run on top of IBM's WebSphere application server and link to other applications through XML interfaces. This new version is known as MAPICS ERP for iSeries Release 7. All of the functionality of the MAPICS suite for OS/400 servers will be ported from RPG to Java by the end of 2002. While this port to Java would, in theory, allow MAPICS to move the MAPICS for iSeries ERP suite to Unix, Windows, or Linux platforms, the company has no plans to do so at this time. MAPICS is, for the moment, committed to serving the OS/400 market with the revamped and caffeinated MAPICS XA suite. However, during the next 12 to 18 months, the company will be porting the OS/400 code to Linux--but only Linux as it runs on the iSeries. It does not plan to support its application suite on pSeries, xSeries, or zSeries servers running Linux. That option will, however, obviously be open for MAPICS as it delivers the Linux functionality on the iSeries.

    MAPICS is offering customers toolkits to convert their prior generations of MAPICS applications to Release 7. The toolkit, according to company sources, will work with any prior generation of MAPICS applications, but the easiest ports will be for customers on more modern releases who used the MAPICS Integrator tool to make their modifications to the MAPICS suite. MAPICS ERP for iSeries Release 7 will run on any AS/400 or iSeries server that supports OS/400 V4R5 or V5R1. MAPICS is using BMC Software's Best/1 performance tool, licensed by IBM for its own performance tools, to help customers do capacity planning as they move from RPG to Java modules. MAPICS says that iSeries Model 270 and Model 8XX servers, by virtue of their faster processors, more capacious main and L2 memories, and higher bandwidth, will do better running the new MAPICS suite than prior AS/400 servers. MAPICS does not yet have any general rules of thumb when it comes to upgrading from RPG to Java versions, since it is only working with limited information from early adopter customers.

    For existing customers on maintenance contracts, the upgrade to MAPICS ERP for iSeries Release 7 is free; the cost for the core financial ERP modules is $2,000 per seat, with SCM and CRM modules costing extra. A typical customer will spend about $50,000 for a suite of applications, according to the company.

    The question now is how long MAPICS will support its RPG suite. That's a good question for Intentia as well. More on that in a future issue of The Four Hundred.

    In a separate series of announcements, MAPICS has also enhanced its ERP for Extended Systems, the Windows-based suite formerly known as Point.Man, as well as its Supply Chain Management Solution, also a Windows suite and formerly known as Thru-Put. MAPICS has also announced a special suite of its OS/400 applications designed specifically for metal manufacturers.

     

    SPONSORED BY BCD SOFTWARE

    See why WebSmart beat out 26 other vendors and was Voted the BEST iSeries e-Business / e-Commerce tool in the marketplace.

    New Version. Build your own, or use/customize the 70+ Free templates and e-Commerce applications. Develop professional apps in a couple of days not months.

    Quickly deploy elegant, robust and secure B2B & B2C apps. Including: Inquiries, reporting, maintenance, wireless (WML, XML, HDML), ordering, product catalogs, shopping carts, EIS & more.

    Automatically produces dynamic HTML CGI programs written in ILE/RPG. 128-bit AES encryption. Utilizes iSeries400 database and security features for scalability and reliability. Complete, portable PC-based design tool. Unlimited developers and end-users.

    Easy-to-use, requires little or no Web or iSeries400 programming and best of all it's affordably priced.

    Ask for BCD's 15-point opinion e-mail on why WebSmart is better than WebSphere:

    1. Ability to run on smaller iSeries 400s without having to upgrade hardware.

    2. Significantly faster applications...

    WebSmart users include: Affinity Ins., Airways Freight, Arrow Environmental, Behr Process, Broward County Schools, Calvin Klein, D.J. Powers, Formica Corp., Goodyear, Hightech Health, Hoshizaki America, Kauai Electric, Legacy Partners, Midwest Trophy, MSU, Oregon Dept., of Veterans Affairs, State of California, Testor Corp., Weigh-Tronix...

    Also try CATAPULT, voted best e-mail / Automated Report Distribution Tool.

    Download WebSmart - and - CATAPULT now for FREE.

    Call 630-986-0800, e-mail sales@bcdsoftware.com or visit http://www.BCDsoftware.com

    BCD, Winner of 18 Industry Awards.




    The Name Game: iSeries Regatta Model 52

    by Timothy Prickett Morgan

    There is a rumor going around that, rather than call the iSeries Regattas the iSeries 900s, IBM might instead call them the iSeries Model 52 servers. This seems as plausible and logical as any other IBM naming scheme, though I cannot confirm IBM's intentions in this regard.

    However, the speculation surrounding why IBM might call the Regatta machines the Model 52s seems to have missed the obvious. IBM would not call them the Model 52s simply to get away from the Model 270 and Model 8XX way of designating iSeries machines, thus abandoning the low-end and high-end designations it has traditionally used in the OS/400 server line, although this would be one side effect of this new branding. IBM is probably planning to call these iSeries machines the Model 52s because they run OS/400 V5R2. It seems likely that somewhere within IBM, someone was arguing to call the pSeries 690 the pSeries Model 52 as well, because the machine was supposed to be running AIX 5L Version 5.2. There is nothing mysterious about this, except that AIX 5.2 seems to be running about a year late, given these hypothetical naming conventions. The other mystery is why IBM's marketeers didn't simply call the pSeries 690 machines the Model 51s from the get-go, thus establishing the brand and the naming convention.

    IBM is also said to be considering adding L, M, and H extensions to the Model 52 moniker to denote low-end, midrange, and high-end versions of the hardware. IBM has been doing this internally for years, at least in the pSeries line. The pSeries 690, for example, was internally known as Regatta H. Other RS/6000 machines had Light and Heavy designations as well.

    IBM can call the iSeries Regattas anything it wants to--as long as they are not late, perform well, and are attractively priced. This is what will get customers buying machines, which is the important thing. No one, except perhaps cattle rustlers, really cares this much about branding.

     

    SPONSORED BY RJS SOFTWARE SYSTEMS, INC.

    Save TIME AND MONEY with our
    AS/400 - iSeries Report & Data Delivery Systems

    RJS Software Systems, Inc. - http://www.rjssoft.com

    Delivering AS/400 reports via email, web, Lotus Notes, Domino or CD.

    Whether it's Native AS/400 or PC-based, we have the solution.

    * WinSpool/400 report download and conversion
    * Text converters (ASCII, RTF, PDF, HTML, Spreadsheet)
    * Form converters (AFP, EZ/Print, Formation,
       Formsprint, CreatePrint to PDF)
    * Split reports with AS/400 Report Splitter
    * Email Report Server, Web Report Server
    * Domino Report Server
    * Batch Report Server delivery to LAN, IFS and FTP
    * SMTP/400, POP/400 & FTP/400 Email/Transfer APIs
    * Query and Convert AS/400 Files with DataExport/400
    * Web-Based AS/400 Data Access via Active Server Pages

    For a FREE FULLY FUNCTIONAL DEMO CD, please visit our Web site at http://www.rjssoft.com.

    Contact us at 888-RJS-SOFT or email us at sales@rjssoft.com




     

    IBM Updates PTFs for V4R4, V4R5, and V5R1

    by Timothy Prickett Morgan

    IBM has updated the HIPER PTFs for OS/400 V4R4, V4R5, and V5R1 once again, as is nearly a weekly practice at the company. It has also tweaked the PTFs for the standard and advanced editions of WebSphere V3R5 on OS/400 V4R5 and V5R1. OS/400 V5R1 had had some tweaks to the DB2/400 database. OS/400 V4R5, V4R4, and V4R2 all had tweaks for the Network Station thin-client management features embedded into the operating system.

    You can read the latest OS/400 PTF Guide at www.itjungle.com/ptf/DLB-PTF_120801_V3N46.htm.

    The PTF Guide is put together by our partner company, DLB Associates, which will also be composing the in-depth weekly newsletter PTF News for the OS/400 community. The Four Hundred subscribers will receive PTF News automatically when that newsletter is launched.

     

    SPONSORED BY TRAMENCO

    Introducing a New Source for Training and Mentoring

    Follow this link to a vital new source for how-to technical information: www.tramenco.com.

    Unlike companies that offer training as an afterthought, The Training and Mentoring Company (Tramenco) is dedicated to just one thing: Advancing your career by giving you the skills you need to solve real-world business problems.

    You get the best information from the world's leading experts--Howard Arner, Kelly Conklin, Don Denoncourt, Susan Gantner, Skip Marchesani, Glen Marchesani, Shannon O'Donnell, Craig Pelke, and Richard Shaler.

    Choose from a menu of training options to fit your needs: onsite seminars, public seminars, mentoring, consulting, books, CBTs, and Web-based training.

    And make plans to attend the 2002 iSeries Connection Conference, the multi-day, multi-track conference that was the only sold-out iSeries training event this year, co-sponsored by the Education Connection and Tramenco.

    For more information about Tramenco's career enhancing opportunities, call (800) 421-8031 or go to www.tramenco.com.




    Resolutions, Accelio Partner for OneWorld Documents

    by Alex Woodie

    J.D. Edwards & Company has recertified a document management system, jointly developed by Resolutions and Accelio, to run on its OneWorld and OneWorld XE ERP suites. The software, called eResolveDMS for Accelio Present Central, gives OneWorld users document management capabilities that are easier to use and more powerful than the native Report Design Aid component JDE ships with OneWorld, sources with the companies said.

    eResolveDMS for Accelio Present Central is made up of three components. Accelio Design, developed by Accelio, is a Windows-based, WYSIWYG program for shaping document appearance in its final format. eResolveDMS (called eRP Output Wizard until last Friday) is developed by Resolutions, runs natively on OS/400, Unix, and Windows platforms, and acts as the communications director and interface between OneWorld and the Accelio print engine. The Accelio print engine, called the Accelio Present Central, also installs on any OneWorld platform and delivers a document in the required format, including print, email, fax, and HTML, or prepares it for archiving.

    OneWorld uses PDF as its native document format. When eResolveDMS detects that OneWorld has created a document, it "reads" the PDF data and applies any additional delivery or formatting information that the user has programmed into it. For example, users can add a rule that documents associated with a specific customer be distributed via email, fax, the Web, hardcopy printout, or any combination thereof. eResolveDMS then hands this enhanced metadata to the Accelio Present Central print engine to execute the delivery.

    This functionality is substantially more robust than what JDE offers with its Report Design Aid, said Steve Luke, president and CEO of Resolutions. "RDA is very good at producing the actual data that needs to be put on the page. But it's not good at creating a visually appealing document or a dynamically changing document." Additionally, changes to the system don't require the services of a high-priced consultant; users with three to five days of training can be proficient, he said.

    Resolutions is a Duluth, Georgia, company that writes document management software for ERP and MRP systems running on major platforms, as well as utilities for AS/400 and iSeries servers, such as Tools/400 and WizPak400. Formerly known as Enterprise Resolutions, the company and its founders have had close working relationships with the Accelio organization for years. Resolutions has also sold document management systems for JDE's RPG-based ERP suite for OS/400, WorldSoftware, since 1993, and has sold products integrated with OneWorld, which runs on OS/400, Unix, and Windows operating systems, since 1998.

    Accelio is an Ottawa, Ontario, company that offers a range of document management solutions and print engines for ERP systems from such vendors as SAP, PeopleSoft, and Oracle, as well as JDE. The company changed its name from JetForm Corporation to Accelio, and announced new names for all of its products, on September 12. JetForm has used OS/400 print engine technology developed by Resolutions for years.

    eResolveDMS for Accelio Present Central is being sold and supported in North America by Resolutions. Accelio is selling the product in Europe and relying on Resolutions personnel stationed in Ireland and Germany for support. Pricing for eResolveDMS for Accelio Present Central ranges from $20,000 to $39,995. For more information, go to www.eresolve.com or www.accelio.com.

    As I See It: The Digital Inquisition

    by Victor Rozek

    In Malaysia, the crime is punishable by fine and imprisonment of up to five years. In the neighboring Philippines, violators also pay stiff fines but serve up to nine years in prison. In these nations and a growing number of others, police raid suspected criminal establishments and confiscate property on the basis of anonymous tips fed to them by a private association. For all practical purposes, third world law enforcement agencies--whose governments frequently display exceptionally low regard for human rights--act as the enforcement arm for this private business alliance.

    Just what kind of an association has the power to command police raids in Malaysia and the Philippines? And, for that matter, what crime could possibly be so urgent and globally threatening that a group representing private businessmen headquartered in another hemisphere could spearhead police strikes half a world away?

    The association that wields such extraordinary power is the Business Software Alliance. The crime is using unlicensed software.

    The BSA is a trade association comprised of some of heaviest hitters in the hardware and software industry. Included in its ranks are IBM, Microsoft, Apple, Intel, Adobe, Symantec, and Novell, among others. The BSA's operations range globally, and its primary mission, if you strip away the public relations babble, is to unearth, threaten, and punish copyright violators. The alliance, accurately if grandiosely, refers to itself as "the voice of the world's software and Internet industry before governments and with customers in the international marketplace." And it is a voice determined to be heard.

    From the perspective of software producers, the task of ridding the world of software piracy is enormous, and the losses they incur are intolerable. BSA estimates that one out of every three applications installed worldwide is pirated. For PC applications the total is slightly higher and stands at 36 percent. For software providers, those figures translate to approximately $12 billion in losses each year. The prospect of decreasing piracy and recovering even a portion of those losses has created some questionable alliances and a reliance on bullying when appeals to reason fail.

    Putting methodology aside for a moment, the threat of arrest and prosecution is having a slow but measurable impact. According to a BSA-funded study conducted by the International Planning & Research Corporation, since 1994 the total percentage of global software piracy has declined by 13 points, from 49 to 36 percent. That number, however, is likely to be partially offset by the study's omission of many consumer applications, such as games, home education software, personal finance packages, and tax programs.

    But the overall global decline doesn't begin to reflect the realities in Eastern Europe and Asia. In Vietnam, for example, although the trend is inching downward, the study estimates that a full 98 percent of that country's install base is pirated. In China, 91 percent has been plagiarized. In Russia, 89 percent of the software is illegally installed. There are, in fact, over 25 nations that pirate more than 70 percent of their software. Remarkably, these figures reflect a period of time in which Asian economies have been in decline. The percentages can be expected to rise when economies rebound.

    Although piracy percentages are high in Eastern Europe and Asia, revenue loses are comparatively modest because of the nominal number of computer systems in use. In Vietnam, with the highest percentage of piracy, losses are estimated at only $10 million annually.

    By contrast, in the United States and Western Europe, the piracy rate is much lower (25 percent for the U.S. and 34 percent in Western Europe), although the cost to software manufacturers totals nearly $7 billion, or 60 percent of the annual world total.

    It is not surprising, therefore, that the BSA is aggressively pursuing violators at home as well as abroad. But how does the alliance uncover transgressors? After all, what company would advertise its own complicity? Since the BSA has no way of accurately determining who is running what software, it relies on anonymous tips. Anyone with a grudge or a guilty conscience is encouraged to turn in his employer. In some areas, rewards are offered for tips leading to the conviction of copyright violators. Citizen snitches are characterized as being "civic minded" but are more likely to be either greedy, angry, or recently fired.

    Nonetheless, the strategy shows signs of working. In May of last year, the BSA announced the results of its "sweeps week," an extensive investigative effort designed to identify digital evildoers. One hundred fifty-nine software pirates were unmasked, and fines were assessed totaling $6.2 million. In the wake of September 11, the organization's enforcement efforts seem to have slowed, but BSA sweeps are an ongoing strategy designed to target suspect states or geographic areas. You can be assured a sweep will be coming soon to a region near you. Resistance, if not futile, will certainly be expensive.

    Let us postulate that you are the owner of a midsize company. One day you receive a registered letter from the Business Software Alliance that says it has reason to believe you are in violation of copyright laws. It demands that you immediately initiate a full and complete audit of every computer system and every piece of software on the premises to determine the extent of noncompliance. Further, you will be required to pay as yet unspecified penalties, purchase new, licensed software to replace illegal copies, and destroy all unlicensed programs.

    If you're like me and you don't like people pushing on you, your first reaction might be to tear up the letter and tell the BSA to file it where screen savers don't shine. But that would be a high-risk reaction. Remember, the BSA represents the likes of IBM and Microsoft, companies that can bury you in litigation. In the end, what will cost you more, an audit and possible penalties or protracted litigation during which you will be forced to audit your systems anyway as part of the discovery process?

    If it's heavy-handed, it's intended to be. Basically, from the moment you receive the letter, you're guilty unless you can prove you are not. And proving it is likely to cost you a good deal of time and money.

    The right to defend intellectual property has unarguable merit, but beyond the question of rights is the question of methods. The process by which intellectual property is being defended is flawed. Accusations of copyright violations, stoked by the unchallenged authority of the BSA and its influence on law enforcement agencies, form the functional basis of a Digital Inquisition. Alleged violators are likely to be punished by the sheer force of the accusation, and respondents are compelled to prove their innocence, rather than be proven guilty.

    Should they resist and be convicted, the legal penalties applied in the United States are not unlike those in Malaysia or the Philippines: a fine of up to $250,000 and up to five years in prison, with mandatory restitution that can run into the millions.

    The BSA strategy, however, may be losing support in the court of public opinion because the intent of the accused is seldom considered. The threat of prosecution is not limited to deliberate violators or companies that copy software illegally for the purpose of resale. Last year, for example, Microsoft went after a poor school district in Philadelphia. The district, so destitute it requested government assistance simply to pay its 27,000 employees, was threatened with legal action unless all 264 schools and administrative offices could prove that every piece of Microsoft software had a verifiable license.

    For small, struggling, or financially strapped institutions caught in the BSA net, moral and practical considerations collide. "The law," as Anatole France observed, "forbids rich and poor alike to sleep under bridges." But if the choice, as it was in Philadelphia, is teaching children or paying for each and every software license, where is the moral high ground?

    Undeniably, a company that invests time, money, and intellectual resources to produce a product has a right to be compensated. Ironically, however, the absolutism displayed by the BSA and its member organizations may ultimately produce the opposite of its intended result. Lurking around the corner is the open source community, which grew out of a dislike for proprietary software and the heavy-handed dominance exercised by a handful of industry giants. Both business and education are increasingly drawn to consider open source options, which do not impose copying restrictions and can be modified and even marketed by the user. The Internet solves the problem of distribution, and the only thing the open source concept lacks is reliable support, which, in the traditional model, is frequently costly or likewise unavailable.

    Seeking to avoid mounting pressure from the software industry, the government of Argentina is even considering requiring all government offices to use open source software as an expedient alternative to licensing fees, unwanted upgrades, and dependence upon foreign corporations. "Free," it has been noted, is a powerful marketing concept, and more than one enterprise would welcome the opportunity to zero out its annual software budget.

    The reality is that conflict over property is as old as property itself, and whether it's intellectual or material, it cannot simultaneously serve the interests of ownership and entitlement. One thing is certain: Where ethics exist, enforcement is unnecessary. Where ethics are lacking, perspective helps. "Thieves respect property," observed writer G.K. Chesterton. "They merely wish the property to become their property that they may more perfectly respect it."

    Lazy Software Debuts New Database for OS/400

    by Timothy Prickett Morgan

    Lazy Software is a British startup company created by three of the founders of former OS/400 application development tool maker Synon. They have banded together to create a new database management system that is not a relational database, like OS/400's integrated DB2/400 database and other similar products, but which is based on a different, associative database model. The people behind Synon have created Sentences, Lazy Software's associative database management system, because they believe the associative model is better than the relational model, since it simplifies the programming necessary to create databases and applications. Anything that makes application development simpler has a natural affinity with the OS/400 platform, which has always prided itself on its ability to mask many of the complexities of relational databases and the management of their features from programmers. The interesting bit is that Sentences is written entirely in Java and has been labeled ServerProven for the iSeries, pSeries, and xSeries eServer platforms from IBM. That earns the Sentences database the distinction of being the first commercial non-IBM, non-DB2 database available for the OS/400 platform.

    After selling Synon to Sterling Software in 1998 for just under $80 million, Simon Williams, CEO of Lazy Software, thought about what problem he wanted to tackle next in the software business. Williams conceived and developed the Synon/2 computer- aided software engineering and object-oriented programming tool and its follow-on, Obsydian. The Synon tool was acquired by about 5,000 OS/400 software houses and OS/400 user companies and was one of the most popular development tools in use on the platform. Sterling was quickly absorbed into the Computer Associates empire after Synon was acquired by Sterling, and the Synon tools are still available today as Jasmine Developer 2E and COOL:Plex.

    Having a little bit of experience in the application development field, Williams came to the surprising conclusion that the relational database model of storing information was one of the big problems making application development more complex, more costly, and more difficult to maintain. The name Lazy Software comes from the idea that applications should be easier to create, and also that it is often the seemingly lazy mathematician who thinks up the best solution to the problem. Both Albert Einstein and Niels Bohr, for instance, were not known as the sharpest tacks in the drawer, until they completely turned our view of the universe inside out after putting some thought into it. The Lazy Software name pays homage to all the nerds and geeks who fully think a problem through before applying brute force.

    To turn Sentences from an idea into a real product, Williams asked two of his former co-founders at Synon, Melinda Horton and Simon Haigh, to join his company. Horton built and ran Synon's Professional Services Division and established the company's support and training operations; eventually, she took over the job of managing the development of Synon/2 and Obsydian. As executive vice president of engineering at Lazy Software, she has managed to take the ideas developed by Williams and make them a reality implemented in Java. She is getting lots of help from a team of database developers from the former Ardent Software, which was acquired by Informix a few years ago, which itself is now a part of IBM. Haigh, president and chief operating officer of Lazy Software, was Synon's first head of sales and marketing; he built the Synon channel that enabled Synon to hit annual revenues of $34 million in six years.

    Lazy Software is headquartered in High Wycombe, Buckinghamshire, and has recently opened offices in the United States, in Chicago and Dallas, to begin a marketing push here last week. The company, despite these troubled times, has been able to secure $11 million in venture funding in the past year from Advent Venture Partners, Commerzbank AG, and Metropolitan Venture Partners. The company has 40 employees and 45 customers, all of whom are early adopters of a new database technology.

    The ideas underpinning Sentences are sophisticated, and they are not new. They are new with a practical twist. Sentences is based on an associative model of data that was developed at IBM's Hursley labs in England many years ago called Triple Store. (You'll remember that IBM researcher Edgar Codd invented the relational model of data, an idea that Oracle stole and implemented with minicomputers and then built into a huge driver of the application and server business.) With relational databases, you build many tables that contain data in columns and keys for data running down the rows. These tables have varying sizes of rows and columns, giving them different shapes and keys. Program components of applications that are based on relational databases have to be built with the shape of tables in mind. If you change a table, you have to change the application programs that rely on that table; if you change an application, you have to make sure the table's structure is changed to match it. This is a lot of busywork to Williams' way of thinking. Getting two databases to talk to each other is also problematic, since they have different structures--hence the need for data transformation middleware.

    Moreover, applications based on a relational model must also deal with many different tables simultaneously. Back in 1969, when IBM developed the relational database, a big application database might be comprised of 50 tables. Juggling and dicing and slicing these tables as part of the application was not that big of a deal. Fast-forward three decades: The mySAP.com and R/3 ERP suites from SAP AG contain between 16,500 and 19,200 tables in their databases. Indexing, joining, and performing other operations on these database tables eats mountains of MIPS.

    With the associative model, a database table has four, and only four, columns, which Williams says is necessary and sufficient to describe any and all kinds of data and relationships. Each row is assigned a numeric key that is associated with a bit of data; complex associations between data are spread out across multiple rows, with pointers linking these rows together. The structure of the database never changes. Moreover, because the pointers are in the database, they show the linkage between data in a different part of the database, by default and by design; you don't have to run a query to shake out the columns and rows across many relational database tables. You just query the data that is associated with a particular pointer. Applications have one giant table, they know the shape of it, and what you are doing mostly in an application is surfing up and down that table looking up and changing the data behind the pointers, which is stored adjacent to those pointers in the table.

    Sentences does not rely on any particular query language or development tool to create applications. If you install it on an AS/400 or iSeries server equipped with Java, you can use Java, RPG, or COBOL to create an application. Sentences is supported on OS/400, Windows, Unix, and Linux platforms, and only requires a Java Virtual Machine. Version 1.0 of Sentences was announced in October 2000 and was pushed only in the United Kingdom. Sentences 2.0 was announced last October in the U.K., and is entering the North American market now. Reuters and Commerzbank are among the early adopters of the software, and the associative model behind Sentences has enabled them to develop and implement applications in a matter of weeks, instead of a year or more. Lazy Software runs its business on a Windows server, including sales, support, financial, and other applications, using a Sentences database that is about 350 GB in size. A lot of that database is comprised of the 4,000 hot prospects for the Sentences database.

    Right now, Williams says that Sentences scales pretty well for databases up to around 6 GB in size. Having such a large table behind the database makes indexing more difficult, and the company is inventing a whole new way to tune performance based on its experience with customers. Sentences Version 3.0, which should be available in the summer of 2002, will focus on making scalability enhancements, and by Version 4.0, maybe available in early 2003, Williams says that his product will be ready to go head-to-head with Oracle's and IBM's relational databases on even the biggest jobs. Williams does not for a second believe that customers will port to his database just for the sake of using new technology; companies have more than a trillion dollars in creating applications for relational databases, and they cannot afford to easily move. Williams says the situation is analogous to the advent of the microwave oven. No one wanted one for years, and then people found them useful for things like reheating food, and then everyone wanted one in their kitchen. I like this analogy, but there is a better one that Williams is well aware of: Back in the late 1960s and early 1970s, just about everybody used a mainframe for data processing, and they used a flat-file database from IBM or Cullinet (eaten by Computer Associates decades ago), such as IMS or IDMS. Then along came Oracle with relational databases, and over the course of the next decade, application by application, bit by bit, the relational database replaced the flat-file database. IBM had to put DB2 on its mainframes and a relational database inside the System/38. You might be looking at changing databases again in a few years if Sentences really works out.

    For new, discrete applications, Sentences seems worth some tire kicking, and particularly at the price. Sentences Version 2.0 costs $49,500 per server, with an unrestricted license that is not gauged against the number of processors, users, or transaction volume. That price also includes education and consulting services for two months for developing an application based on Sentences. Under a special new technology adopters deal, Lazy Software is offering customers the same bundle for $9,750, and if they are in any way unhappy with the results, they can keep Sentences under a perpetual license and the application they developed for this low price. You can find out more about Lazy Software and download a trial version of Sentences at www.lazysoftware.com.

     

    SPONSORED BY SYMTRAX

    Goodbye paper, hello savings! Automatically convert iSeries and AS/400 reports to popular PC formats, like Excel, Word, Access, HTML and more, with COMPLEO.

    Totally reformat reports to get them just the way you want. Distribute reports via email or the web. Compleo is an easy to use, award-winning product that is used by over 4000 companies around the world.

    SYMTRAX REFORM, another Symtrax product, works hand-in-hand with Compleo to reduce your need for pre-printed forms. Implement secure check printing, complete with MICR fonts. Design all form types from your PC, or just use a REFORM template for checks, purchase orders, invoices and more.

    For automatic printing, faxing and emailing of your forms, COMPLEO and REFORM work together in order to give you a secure, powerful solution for all your report needs.

    DOWNLOAD TRIAL COPIES NOW AT http://www.symtrax.com/fhn

    Call 1-800-627-6013 or 310-216-9536 with questions, or send them to sales@symtrax.com.




    Five Minutes with Sandy Carter on WebSphere and the iSeries

    by Joe Hertvik

    I recently spoke with Sandy Carter, IBM's vice president of WebSphere marketing. We talked about WebSphere marketing on the iSeries, the new eServer iSeries Powered by WebSphere product, and IBM's future iSeries WebSphere plans.

    How's WebSphere doing on the iSeries?

    Very well. IBM has just announced the pretested, integrated eServer iSeries Powered by WebSphere server, which is a solution for the iSeries marketplace. Other vendors and customers, such as the Unix guys, they'll take technology, but iSeries customers want a solution to their problems. That's what they've grown up with; that's what the cult has been formed around.

    So we believe that this package is critical to success there, because it is an application server-Web serving solution for iSeries customers. They can protect their investment, so they don't have to replace what they currently have. The server can be added into their current infrastructure. It interfaces nicely with other iSeries applications, such as J.D. Edwardsand MQSeries for AS/400.

    The iSeries also depends a lot on the channel, and the channel is extremely happy because everything is pretested and integrated together. Because of that work, our lab installation times have consistently tested out at about an hour to get everything up and running. That's a big benefit for Business Partners and customers who are trying to decrease their costs and increase their productivity.

    But what will make it successful for iSeries customers?

    When we went to COMMON, we spoke to many iSeries customers and Business Partners. Our key step here is the education, the training partners, making sure everyone is completely trained on WebSphere. This is a new beast for them. And many of the questions they asked were common questions: "I want to do it; I've heard about it, but what is it?" This offering is leveraging the WebSphere brand; it's Powered by WebSphere for iSeries. We believe this server is a big deal. Buell Duncan and I unveiled this together, and I teased that I was the first IBM software executive to unveil a piece of hardware.

    The iSeries is completely behind this server, and IBM is also completely behind it. Based on our research, iSeries customers are looking for a solution. Statistically, in the next two years, over 72 percent of the iSeries customers want to have WebSphere Commerce Suite on the iSeries in their shops. That's huge. We believe that this is the time, and that we're at the right part of the curve for iSeries.

    Are we looking at another iSeries Powered by WebSphere machine that has WebSphere Commerce Suite bundled at some point?

    Potentially! What a great idea. Coming soon. Another perfect solution for this space.

    The integrated Commerce server would have been nice to put out right now, because the Powered by WebSphere box seems like a developer's machine.

    The iSeries Powered by WebSphere really allows you to Web-enable your applications. And when we did the market intelligence, Web-enablement was step one. Step two was the WebSphere Commerce Suite piece.

    Are there any other WebSphere gaps that will be filled on the iSeries as time goes on?

    Obviously not right away, because iSeries adoption tends to be slower than in other customers sets, but we do have plans for the WebSphere Portal Server to go on iSeries. That's good, because the Portal Server today doesn't have the collaboration features in it that will make it really cool. In 2002, Portal Server goes to iSeries with the cool collaboration pieces on it.

    Aside from the Commerce piece, the Portal Server seems to be the WebSphere application that generates the most buzz. It seems to be the most needed right now.

    Yes, but on the iSeries right now, they're followers; they're not leaders. The Portal Server is in its infancy. You'll soon see a lot of references about how people are using it, but the Portal Server is new; it's an emerging thing. Usually the iSeries customers adopt more slowly.

    There's always been a gap between when IBM releases a product, like WebSphere V4.0, on the other platforms first and when--two months later --it comes out on the iSeries. Can you explain why it takes longer to release WebSphere products on the iSeries?

    Well, first, you'll see that time period getting shorter. But part of the reasoning there is that iSeries is considered a solution, and it qualifies for much higher testing. The iSeries actually does its own testing [with a product like WebSphere] to make sure everything works together. That extra testing adds additional development cycle time. So the iSeries customers should feel great, because iSeries WebSphere releases are now up to an integrated-solution-testing quality level. It just takes more time to do that.

    And it isn't just IBM. I think you see that pretty consistently throughout other iSeries vendors; that they offer their products on other platforms first. Generally, the testing around the iSeries takes longer to do.

    Why has it taken so long to get other WebSphere products--like the Portal Server, the WebSphere Edge Server, and the Site Analysis piece--on the iSeries?

    Site Analysis will be part of the WebSphere Portal Server. Part of this is that, when you offer a new solution, you go out on a platform that has early emerging adopters, people who are willing to take that risk--bleeding edge people. You make the product successful, and then you roll it out to other people. That's exactly what IBM has done.

    Does that mean most WebSphere products will eventually wind up on the iSeries?

    Yes. If the product is successful, it will end up on the iSeries. You wouldn't propagate an unsuccessful product on multiple platforms...one would hope.

    On the iSeries, you can run Linux, Windows, and AIX applications, and IBM is testing a version of WebSphere that runs under a Linux partition. Will we see a move toward supporting a non-OS/400 WebSphere on iSeries, or are we really looking at keeping it native?

    We are evaluating that. We're looking at some fast adoption in Europe of the acceptance of Linux on the iSeries. And WebSphere will go where its customers will go. So, if a lot of customers start adopting Linux, that's where we'll be. That's actually a very good thing for IBM. Buell has predicted that Linux on iSeries will be one of the hottest things in Europe. The goal is ubiquity, and you go with the goal.

    Will IBM be supporting two, possibly three, different versions of WebSphere running on the iSeries? Because you can run it under AIX in the Portable Application Solutions Environment, too.

    I don't see AIX, but I do see WebSphere under Linux. I know we're evaluating Linux right now.

    WebSphere under Windows running on the Integrated xSeries Server would be another possibility.

    Yes.

    Why was the decision made to offer only a 10 percent discount on the eServer iSeries Powered by WebSphere product? That seems like a low discount to move those boxes.

    Well, there's a 33 percent discount on the WebSphere V4.0 software.

    But only until February 8, and then the bundle price goes to a 10 percent discount.

    That's correct. When you're in marketing, you put promotions out early on to drive acceptance, and then you learn from the results. About the 10 percent level, you have to talk to iSeries, because we made the software decision that we wanted this to be very successful, so we put a 33 percent discount on the software. And, overall, the bundle carries a 10 percent discount. I believe the iSeries group felt the box was extremely competitive with that price.

    Is the 33 percent discount for WebSphere V4.0 being offered anywhere else other than the iSeries?

    No, it's not. If you do the numbers, as compared even to a Windows box, the Powered by WebSphere offering is very competitively priced.

    I think iSeries is doing very well, overall. If you listen to Buell, there are only two servers in the entire industry--not just IBM--that grew during the third quarter 2001. One was iSeries, and the other was zSeries. And that wasn't just with current customers; it was with new customers, as well.

     

    SPONSORED BY E-400 LTD.

    FOUR STEP GUIDE TO
    EASY iSeries WEB DEVELOPMENT

    Step 1 - Identify your needs

    * deliver fast web applications on secure iSeries or AS/400
    * extend programming skills such as RPG, COBOL
    * use existing infrastructure (even small servers such as model 150)
    * achieving training in hours and produce results in days
    * deliver real ROI to my business

    Step 2 - Discard what you don't want

    * yet more interactive resource and hardware upgrades
    * restrictive templates, bossy wizards and visual constraints
    * screen scrapers, code generators and 5250 emulation
    * poor productivity and slow application performance
    * new programming languages to learn
    * additional client licenses and expensive training

    Step 3 - Read what experts and customers say

    "What E-400 have managed to achieve is possibly the best web development tool I have seen to date.... If you have an AS/400 and are looking for a web presence, you could do yourself or your company a lot of good by taking a look at FreeStyle-400."
    David George, 400times.co.uk Product Review

    "We were 99% committed to the Java route for our Internet / Intranet development until we found out about FreeStyle-400. FreeStyle-400 allowed us to use our existing pool of developers without any costly training, sub-contracting or steep learning curves...."
    John Hunter, MIS Manager, AVX Ltd.

    Step 4 - Talk to us about FreeStyle-400

    Talk to our professional partners or us on how you could leverage existing skills and resources to develop e-business projects.

    UK/Europe - E-400 Ltd. at +44 (0)1757 248000
    US/Canada - Net400 Inc. at 888-8-NET400
    Australia/New Zealand - AH Technology at (61-3) 9886 9699

    Alternatively visit www.freestyle-400.com/tfh for a demo or further information.




    IBM Withdraws More AS/400 Iron from Marketing

    by Timothy Prickett Morgan

    Just before the Thanksgiving holiday, IBM withdrew from its product catalog a number of older AS/400 models, as well as some iSeries and AS/400 features.

    As of November 20, IBM has withdrawn PCI ISDN features 2750, 2751, 4750, and 4751, which were announced during the Northstar generation. Customers who still need ISDN connectivity can get alternatives, which IBM explains in a document at www- 1.ibm.com/servers/eserver/iseries/support/planning/isdnalt.htm.

    Upgrades from the Model 436-2102, 436-2104, and 436-2106 Advanced/36 servers to the Apache generation Model 6XX servers were withdrawn. And selected upgrades within the Apache Model SXX server line were also withdrawn.

    Effective December 29, 2001, IBM will stop converting selected base interactive green-screen processor features for Model 720, 730, and 740 servers to maximum interactive features for other models in the 7XX line. This appears to be IBM's way of getting customers to move to a Model 8XX machine if they need to add green screen users or more interactive processing capacity. IBM had already announced that Model 170 processor conversions, including the "Bumblebee" Dedicated Server for Domino configurations, had been withdrawn. IBM had already withdrawn processor conversions and interactive feature card conversions between Model 7XX machines. Processor conversions and interactive processor conversions within each 7XX family--720, 730, or 740--are still available, but probably not for long.

    Effective March 1, 2002, IBM will no longer sell the 1.6 GB read cache accelerator for the PCI RAID controller features 2748, 4748, and 9748 within the Model 8XX line.

    And, finally, as of November 20, 2001, IBM is also no longer selling the feature 5150 external battery backup for Model 830 servers and Model SB3 mixed-mode servers.

     

    SPONSORED BY MAXIMUM AVAILABILITY LIMITED

    Check all your IT requirements:

    * High Availability
    * Disaster Recovery
    * Planned Downtime Elimination
    * Workload Balancing

    All of the above start, and may be entirely met, with:

    *NoMax (tm)

    the affordable real-time Data Replication software from Maximum Availability Ltd.

    Call us or write us for a free 30 day trial.

    Install *NoMax in a couple of hours (with our on-line help if necessary) and manage it through a state of the art GUI.

    In the North America call: 1-310-566-7272
    From other countries call: +64 9 415 7008
    info@maxava.com
    http://www.maxava.com




    WebSphere PTFs Foreshadow Version 3.5.x Withdrawal

    by Joe Hertvik

    IBM recently announced new Group PTFs for WebSphere Application Server 3.5.x that provide fixes to IBM's legacy version of WebSphere. These new PTFs bring installations of WebSphere 3.5.x up to the Version 3.5.5 level.

    The Group PTF numbers for OS/400 V4R5 are the following:

    * SF99138--for WebSphere Application Server, Advanced Edition 3.5.x
    * SF99142--for WebSphere Application Server, Standard Edition 3.5.x

    The Group PTF numbers for OS/400 V5R1 are the following:

    * SF99146--for WebSphere Application Server, Standard Edition 3.5.x
    * SF99147--for WebSphere Application Server, Advanced Edition 3.5.x

    Group PTFs cannot be ordered for OS/400 V4R4 and below, since IBM officially stopped supporting V4R4 on May 31, 2001. For V4R4, WebSphere PTFs top out at Version 3.5.4, and can be obtained by ordering SF99141 for Standard Edition 3.5.x or SF99137 for Advanced Edition 3.5.x. You can still order any WebSphere fix that was available before OS/400 V4R4's end-of-service date; you just won't be able to order any new fixes for running Version 3.5.x under V4R4.

    IBM's psychology on WebSphere support on the iSeries is interesting. According to sources, IBM says that WebSphere support on an iSeries version ends when one of two things happens. If an OS/400 version reaches end-of-support, WebSphere support for that platform also ends as well, regardless of whether or not WebSphere is still supported on more recent OS/400 versions. Conversely, if IBM stops supporting a version of WebSphere, that version is no longer supported under all versions of the iSeries, regardless of which OS/400 versions are supported at the time. iSeries customers are affected by this system of withdrawal because it effectively creates two end-of-service dates for WebSphere on OS/400: WebSphere support is deactivated whenever IBM withdraws support for either a version of OS/400 or a version of WebSphere.

    This policy is responsible for two WebSphere deactivation dates in 2002 that should be highlighted in red on the calendar of anyone using WebSphere on the iSeries. First, IBM is withdrawing support for OS/400 V4R5 on July 31. In the WebSphere world, this will have two effects. As happened with OS/400 V4R4, WebSphere 3.5.x will no longer be supported on V4R5. This is to be expected, but what you may not realize is that IBM will also withdraw support for the newer WebSphere 4.0 under V4R5 on that date as well, because of the double-jeopardy rule of WebSphere deactivation (i.e., active WebSphere versions will not be supported on non-supported OS/400 platforms). So, if you're running WebSphere 3.5.x or 4.0 on an OS/400 V4R5 machine, you're supported today, but the clock is definitely ticking, and it's only eight months or so before you lose support for WebSphere under V4R5 and for OS/400 V4R5 itself.

    The second critical deactivation date will be December 31, when IBM pulls support for WebSphere 3.5.x. At that point, IBM will not support WebSphere 3.5.x on any OS/400 platform, and WebSphere 4.0 (along with any successor introduced by then) will be the only WebSphere platform still supported on OS/400 V5R1 and on the new operating system, V5R2, which is expected to be available by then.

    The moral is that WebSphere OS/400 V4Rx users should start thinking about upgrade plans for 2002 if they want to retain support next year. Not only will you need to think about WebSphere end-of-service dates, you'll also have to consider OS/400 end-of-service dates and how they will affect your WebSphere installation.

    We're Going to Spring Common; How About You?

    by Timothy Prickett Morgan

    If you're going to the spring 2002 COMMON conference and expo in Nashville in mid-April, you had better register by December 31, 2001, so you can lock in your registration fee at $995. After that, the registration fees will go up, and by a significant amount in some cases.

    The standard rate of registration for individuals is expected to rise to $1,395 after March 4. That's an increase of 40 percent, which COMMON apparently needs to make its numbers. Group registration fees will rise to $1,275 per person after March 4. COMMON is also offering an early bird rate for people who register between January 1 and March 3. Individuals registering under the early bird rate will pay $1,150 per person, and those coming in under a group early bird rate will pay $975. COMMON is obviously trying to promote groups of people attending the show and signing up as early as possible during this tough economic time.

    Though COMMON has had to raise its rates, the combination of information, events, and training makes the show a decent investment for those who attend. Like anything else in life, what you get out of a show like COMMON is only what you put into it.

    The show is being held in the Opryland Hotel complex, and people booking accommodations can get attractive rates on hotel rooms. COMMON has implemented early bird hotel rates for the first time in order to coax OS/400 shops to send people to the show. The first 400 people reserving a traditional room in the Opryland Hotel who reserve through the COMMON Web site will pay $149 a night for a room, and those going for the garden view rooms will pay only $169 per night. As an added bonus, anyone who registers through COMMON for hotel accommodations will automatically be entered in the COMMON Cents lottery, worth $500 cash.

    COMMON will have over 700 sessions, covering WebSphere, Linux on the iSeries, Java, RPG IV, logical partitioning within OS/400, Domino, DB2/400, networking and security, and a whole slew of other topics. Spring COMMON will run from April 14 through April 18. The Guild Companies team will be there, and, for those of you who can't make the show, we will be providing full coverage of the events and the product announcements, as well as the rumors.

     

    Advertising Information

    Please see our advertising opportunities and pricing at http://www.itjungle.com/advertising.html

    Or contact Timothy Prickett Morgan at

    Phone: 212 942 5818

    Email: tpm@itjungle.com.

    Subscription Information

    To unsubscribe, change your email address, or sign up for any of Guild Companies' free email newsletters, visit http://www.itjungle.com. Hit the SUBSCRIBE button on the homepage and it will lead you to our online subscription system, where you can subscribe, update your subscription or unsubscribe to our newsletters.

    When you sign up for one of our e-newsletters, you can be assured that your e-mail address will NEVER be sold to an outside company.

    Contact the Editors

    Do you have a gripe?
    Do you have some inside dope?
    Do you have an opinion you want published?
    Our mailboxes are always open.
    Email the editors: editors@itjungle.com

    Vendors, please email Press Releases and other announcement material to editors@itjungle.com




     


    BCD
     
     
    Copyright © 1996-2008 Guild Companies, Inc. All Rights Reserved. This document may be redistributed freely and enthusiastically by email only in its unedited form.
    The Four Hundred is a registered trademark of Guild Companies, Inc. ISSN 1049-7757 IBM, AS/400, iSeries, OS/400, and eServer registered trademarks of International Business Machines Corp. All other product names are trademarked or copyrighted by their respective holders.