Re: Which of the SYSIBM tables/views show the row count for

Simon

Well spoken! I think Dave has helped us by pointing out a woeful lack in marketing yet again on the part of IBM. For how many years was the database on the S38 and the AS400 known as the database without a name?

You point out what I would believe - that everything Dave wants in an RDBMS are in the DB2 flavor on the iSeries. And he does say that his reasons for saying it is not a "real" RDBMS are due, in part, to how it is used and the cultures of iSeries shops as against other shops. I think that it goes too far to say something is not a "real" something or other, merely because people don't use it properly.

Basically, any DBA can do anything he/she does now on Oracle or SQL Server (except for proprietary extensions, for which there are ways to get around things). IBM has kits for converting from both of those RDBMS to iSeries DB2.

But we are still stuck with the woeful lack of marketing to the world about this gem we work with. Even developerWorks, IBM's own site for propagating information about this kind of thing, has relatively few items about the iSeries - more all the time. But IBM would do well to use its own site to disseminate information to the broader community.

I also believe that DB magazine has almost nothing about the DB2 on iSeries - how can we or anyone make that better? We again are harmed almost by the blessing - and curse - of this most advanced and capable system.

Whew! Time to go to rehearsal and sing some beautiful music!

I've snipped the message, interested readers can find it in the archives.

Cheers
Vern