|Special Issue||IDMS/SQL News||Summing up 2003-2006|
|Vol 15.1 Technical Information for Mainframe and IDMSâ Users October 2006|
A Note to our esteemed readers:
As you might have noticed, IDMS/SQL stopped active publication a few years ago. Now and then small notes appeared. Most clients have moved away from mainframe and IDMS. Though the original reasons for staying away from IDMS was (in 1990...) was related to 'relational' , client-server etc, in the end the real reasons which eventually removed the product from many places happened to be quite different - Web, Java, GUI interfaces etc.
Here we summarize some of the items which appeared on the front page in the last 3-4 years on IDMS/SQL Web Page.
IDMSDC - 110 days non-stop - crosses 100 million transactions
(as reported in March 2006) An IDMS DB/DC Partition has been up and running 110 days non-stop... spanning over the new year with no problems. The data speaks for itself. (as on 10th March 2006). Even after all these years of wonderful systems on S/370, Unix and Windows, one seldom sees a parallel to this one! No systems on this particular mainframe stays on (nonstop) not even a week! Modern systems run out of storage... A simple html page (local, not even the real web) with a lot of JPG images can break your PC storage even now! My word crashes for lesser reasons!
DCMT D TIME CURRENT TIME 08:36:30.77 CURRENT DATE 06/069 <---- STARTUP TIME 23:47:00.52 STARTUP DATE 05/324 <---- RUNAWAY INTV 00020 STALL INTV 00120 QUIESCE WAIT STALL INTERVAL TIMER INTV 00001 DCMT D ACT TAS Current max tasks 65 Times at max tasks 710 Allocated DCE/TCE 65 Number of tasks abended 4759 Number of tasks processed 100292369 <---- Number of tasks active 21
Also many counters on DCMT D STA SYS and DCMT D ACT REENT PRO have overflown and started from 0 again. Though these figures are not correct anymore, it is a great thing that the system survived all those 'zeroings'!
On behalf of IDMS/SQL, C O N G R A T U L A T I O N S!
Some Fresh Air for a Change!
- 15 September 2005
This week one of our well-wishers happened to attend a high-profile Java Conference in Europe (>1500 attendees). One of the presentations was on how to apply AOP (Aspect Oriented Programming) and JMX (Java Management Extensions) patterns while instrumenting your application for management, an issue related to distributed system management on Unix, Windows and Linux platforms. And the presenter talked about the normal lifetime of a software application now (5 or if you are very lucky 10 years) and went on to say "However I talked to one of the participants who mentioned an application clocking 1 million transactions/day still alive after more than 20 years in production. And the system is running on IDMS from Cullinet Software! No memory leaks!! No connection pool blockage!!!"
A couple of years back, DB2 Magazine had surprsingly mentioned IDMS as a database still in production at many sites.
This being the case, it is a pity that IDMS's own customers (and the vendor) are moving away from the database, eventhough all the front-ends (Java based, Application Server, Web etc) are all possible against IDMS today which can still outperform any other database in the market!
HP OpenView HP Ranked No. 1 in worldwide market share for distributed system management software
Linux - A Disappointing Experience!
One of the oldtime contributers- Manoo Tigè - sent this dispatch - Editor/IDMSSQL news, 20th July 2005
I installed my first Linux more than five years ago. That was a SuSE Linux V 6.3. I bought one for about 50 dollars. With no ADSL etc downloading was not economical those days. Also being a novice, I wanted a paper manual. And the 480 page well-printed manual was worth the price. This was real manual, not one of those 'Bibles' or 'in 21 days' stuff. This worked alright. Mostly I played with that. Soon one of my friends came and suggested RedHat 7.1 and we switched over to that. This too worked alright. KDE (K desktop) was superb. Again mainly used for playing games. But soon usage came down... Eventually the Linux disk (20 G) was reformatted to make room for my Windows needs. Now 5 years have passed. With millions of copies running in production, I assumed Linux must be a mature product now. Now comes the surprise. There is no longer free RedHat Linux. V 9 was the last one and that too not available anymore. In 2003, Red Hat abandoned its GNU Public License (GPL) version of Red Hat Linux in favor of Red Hat Enterprise Linux (RHEL). Instead Red Hat launched Fedora Project (~ free Linux like olden days). Now Fedora is in its 4th iteration. This should be alright. Afterall only the name is different. Fedora is RedHat 9.x in reality. I downloaded and installed the product today. ... The result was disappointing. Here are a few things (more in an article later)
It was a total disappointment that the system
failed/slow/difficult to use in the most common
operations of today. It is high time that a base set of
features is very very STABLE by now... but that is too
much to expect....from such a dynamic product...
PS: Google has a lot of comments against Fedora's flop.
IBM sells PC Division to Lenovo - 8th Dec 2004
finally IBM is leaving the PC market! Today (8th Dec 2004) Chinese firm Lenovo bought the IBM PC Division for $1.25 billion.
With low margins and no software of its own (Lotus etc are a failure), IBM was making no money with its PC division.
IDMS/SQL has long maintained a view that IBM made stragetic mistakes in several areas - PC one of them. DB2 was the other big blunder. DB2 only helped to kill the mainframe market... Oracle and other simple SQL databases on the Unix/Windows were the biggest beneficiary. IDMS/SQL always opposed conversion from IDMS to DB2. In certain cases where customer had gone for such solutions, in the end they all landed up in Oracle's pocket. Most of these applications never supported a proper OLTP.
Another area is the Java based 'serious' application development. Not long ago IBM withdrew their Visual Age Java Tool. Now the flagship is an ailing Websphere. Then there is the free Eclipse (IBM is behind this too). But the market here is taken by Weblogic...... and free products like JBoss..
With all these 'fantastic technologies' the in-house application development has almost come to a standstill. The failure was covered up by many companies by outsourcing the EDP division first to a local service bureau..Eventually the software development itself is outsourced - again first locally to some big consulting companies and then abroad!! This is the eventual SUCCESS of the new technology!! Does anyone know now how to make an input/output interactive application which can cleanly update a database??? No matter what the platform is!!!
News - 9/April/2004
3 Plead Guilty in Computer Associates Case
CA in big financial Scandal. As three former executives of Computer Associates pleaded guilty to securities fraud yesterday, the federal prosecutors investigating the company's accounting practices left little doubt that they were zeroing in on Sanjay Kumar, the company's chairman and chief executive.Charles B. Wang, the company's founder and its top executive during that period, retired in 2002. In 1998, Mr. Wang, Mr. Kumar and a third executive received a $1.1 billion bonus tied to the performance of the company's stock. Details Here from New York Times.
ADS Currency Failure
It's been a long time! Well let's start straight with an ADS problem hanging around at various sites without a proper solution for more than 5 years.
IDMS DC061001 V15 T58153 TASK:ADS2 PROG:ADSOMAIN; CURRENCY SAVE/RESTOREINTERNAL ERROR CODE IS 5 Code numbers and their associated meanings are shown below:' 'Code Meaning' ' ' '1 SAVING AREA CURRENCY, NO RECS IN SUBSCHEMA' '2 AREA CREC ID NOT IN CURRENT LIST ON SAVE' '3 SET CREC NOT IN MR53 OR OR52 ON RESTORE' '4 AREA CREC NOT IN SUBSCHEMA' '5 BAD STATUS FROM DBMS READ OF RECORD PREFIX' '6 ERROR ON NATIVE VSAM RESTORE' '7 DBKEY DEADLOCK ENCOUNTERED DURING CURRENCY RESTORE'
We know it is not a user code error, though
circumvented with special codes on READR AREA, not having
NOREADY etc. This has been debugged recently (Summer
2003) and reported to CA. The error comes in some
peculiar situations with using UNLINKED Indexes and
extremely difficult to pinpoint.
IDD - Network Schema (IDMSNTWK)
Here is an html help for all records and sets in IDMSNTWK (IDD Schema). Also contains the DMCL part of the catalog area. IDMSNTWK
Implementing and monitoring Shared Cache in a Sysplex
Environment. Presentation done at IUA Meeting in Paris -
June 2003. Note: Large file of 1.2m. Better right click
and save first before starting PowerPoint
N E W
Hello World from IDMS to Web N E W 15/May/2002 A Simple Introduction to Web Programming for IDMS/ADS using Vegasoft Webserver. In the coming edition of IDMS/SQL News we will have a detailed coverage of these. Until then have a look at this.
Web Access to DepartmentN E W 23/May/2002 Input, Output,
and all 4 DML operations against IDMS from the Web.
Back in Focus!
IDMS to DB2 Conversion!
IDMS/SQL News still get enquiries asking for help material in converting IDMS to DB2. As some of you have noted already, we have opposed any such conversions ever since the publication started in 1991. And we do so even more now! As per the predictions of 'Gartner Group' and other third-class analysts, all IDMS sites should have been converted to DB2/xyz by 1995. Now after 7 years the issue shouldn't arise at all.
We have seen some clients who have moved to DB2 for political reasons sitting and struggling with far inferior applications today. A few of them have again converted from DB2 to some Unix database. If DB2 is so good why did they convert within 5 years to another one? Also we have noticed some clients sitting with atrocious looking Unix applications after replacing state-of-the art IDMS systems. Very often such conversions are done by contractors and not site employees. Contract consultants don't care about the resulting systems because many of them invoice on hourly basis! We have concrete examples on all these.
As noted in another article: Many DB2 based systems made in the 90s are already being thrown away in preference to Unix based applications. IBM's own attempt to push DB2 Universal Database on Windows/OS2/Unix ended up in failures.
On the mainframe arena, there is even a shortage for getting new people to work on existing applications. In spite of being one of the very best databases on the market today, IDMS is sidelined, because of other architecture-related reasons. Logical Platforms like J2EE and "Application Servers" like Weblogic, Websphere, JBoss and many other free open source tools (ant, UML and xml tools) steal the show today. Database is no longer an issue. Any Unix based database with stored-procedure-based execution is enough. No one cares about the concurrency or performance. It just doesn't matter in a slow world of interpreted execution!
Also from San Francisco to Sydney and New York to New Delhi, we hear stories of ex-DB2 programmers with not less than 7 years experience, coming back to IDMS Projects even in 2002!!!How come one is not able to find a position in the market of the flagship product of IBM ??
We blame CA for taking an extremely passive attitude when all this nonsense was going on at customer sites. CA's sales person was only interested in signing the renewal contract. They have no idea or interest in what customers are doing. In spite of all these, we still maintain the view that IDMS can outperform all other systems in development cost, maintenance of applications, run time performance and today even for end user access using new front-ends like Web! This is because the underlying foundation with dictionary is still without equal in the industry!
In most site we know, IDMS/DB2 conversion, in the end helped Oracle! DB2 was just a bridge to eventually end up in Oracle - which seem to be the de-facto database on all Unix platforms!
Access CA-IDMS from Java
Vegasoft, Helsinki has announced Java Client Support for IDMS Database. Java applications can now exchange data with any application running under CA-IDMS/DC. The VG-Java Client communicates with the VG-Application Server running under CA-IDMS/DC/UCF . Communication protocol used internally is TCP/IP.
Vegasoft implementation does not need CA-Server or any other extra products on your PC or Network Servers. This makes implementation cleaner, easy to monitor and maintain, besides giving good performance. Integrity of the database is guaranteed by the proven code of IDMS/DB Central Version. More please visit
Here is the link to Bob's JavaClient Presentation at IUA Meeting. JavaClient at IUA Workshop
Web Server Presentation - Time to have a Closer Look
After coming to know about several Unix/xyz disasters, we yet again think in 2002 that mainframe IDMS is the solution for many applications. Today one can make Web applications with IDMS which can match and outperforum Unix based rubbish easily!
We will cover Vegasoft Web Product in detail in the coming months. Until then,
here is the link to Webserver Presentation at IUA done by veteran IDMS Technician Bob Currie of the Rocky Mountain group
|Just one more!
Where is Java Now?
In 2005 several Java gurus admitted that Java failed in several ways.We saw captions like ''web applications were a disaster!' EJB2.0 was a failure. Entity beans never worked..Container Managed Persistence never worked! One Java Guru went around the world giving seminar on 'Beyond Java!' and declared 'Java is not dead ... not yet!'.
More on this in the coming issues:
This issue located at http://www.reocities.com/idmssql/idms151.htm
IDMS/SQL is published quarterly on behalf of IDMS WatchDog Group, Scandinavia, Oslo-Helsinki-Hørsholm for free circulation among IDMS Users Worldwide. IDMS/SQL News is not a CA publication. CA-IDMS/DB, CA-IDMS/DC and CA-ADS are registered trademarks of Computer Associates International Inc. CICS, IMS- DB/DC, VSAM and DB2 are registered trademarks of International Business Machines Corporation. Technical examples are only guidelines and modifications might be required in certain situations and operating systems. Opinion expressed are those of the authors and do not represent the views of IDMS clients or related vendors. Permission is hereby granted to use or reproduce the information , only to IDMS Customers and Consultants, provided the material is distributed free of charge.