Thanks for this site ! Any similar for DB2
-
Hi there,
to piggy-back on another thread, I would like to ask, if you know of anything similar for DB2?
Thanks in advance!
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
This was removed by the editor as SPAM
-
Hi there,
quote:
to piggy-back on another thread, I would like to ask, if you know of anything similar for DB2?I had the impression that DB/2 is quite commonly used by members of this community. My company is moving towards DB/2 as a second platform and informationally being ahead would be nice and useful for me.
Any ideas or hints?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Sorry to hear that Frank, I support DB2 on NT and AIX along with SQL Server. Although as of late I am doing mostly SQL Server.
I haven't found any good sites, but really question why anyone would use DB2 on anything but the mainframe (I have some experience on it there too).
I can easily support many more SQL Servers that DB2 DBs, even with the rookie developers they have let loose on SQL server.
KlK, MCSE
KlK -
Hi Kevin,
quote:
Sorry to hear that Frank, I support DB2 on NT and AIX along with SQL Server. Although as of late I am doing mostly SQL Server.I haven't found any good sites, but really question why anyone would use DB2 on anything but the mainframe (I have some experience on it there too).
you hit the point!
Our mainsystems run DB/2 on a mainframe, so I think some consulting company has suggested, it would be a nice idea to have also a NT version for easy transfer between those systems.
I'm indifferent on this, because I have no experience with DB/2.
But the good point is, that the Oracles' will be kicked out
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Well don't let them convince you the conversion from MF to FP (Fischer Price) is an easy thing.
If nothing else the FP version tends to be a release or so ahead.
We've looked a few conversions, gave up quickly.
The reality today is any mainstrem DBMS is capable of handling almost any environment. Build the the systems right (Ah that's the problem) and SQL can handle as big a load as any (almost, OK MFers).
I just see too many systems written by people who don't know, or don't care enough to do it right.
How about a simple change to a monthly process to take it from 12 hours to 3 minutes. They bought a bigger box to cut it down to the 12 hours.
Fix a heavily used SP and cut down reads by 98 % and CPU by 86 %. While this one took a while, it was a realitively simple change.
Too many IT workers, not enough IT Professionals.
That's my new RANT.
KlK, MCSE
KlK -
quote:
Well don't let them convince you the conversion from MF to FP (Fischer Price) is an easy thing.If nothing else the FP version tends to be a release or so ahead.
We've looked a few conversions, gave up quickly.
right now here is a multi-coloured environment where everyone is able to use everything. This should be consolidated in the future. One platform is SQL Server, because apart from the mainframe we rely on Microsoft technologies. Oracles, MySQLs, Access will sooner or later be kicked out.
I am unbiased in this, but for we use DB/2 on the host, I think to use it on Windows, too, is not a bad decision at all.
But I wonder, what source of information DB/2 DBA's use when there is no such thing as a forum, mailing list. Do they all buy premium support contracts from IBM?
quote:
Too many IT workers, not enough IT Professionals.That's one problem we have to live with.
It's only getting really difficult when those 'IT workers' are in management positions.
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Just for the heck of it I typed the url http://www.db2central.com.
I came up with a plain looking Login/Password page. It makes me wonder...
Are there DB2 sites like this out there but you have to know some sort of secret handshake to get in?
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek) -
I've just remembered
They have a DB2 mailing list. I just wonder, if it is active ?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Frank I just reread part of your note.
DB2 on Windows is a mistake, I don't know what IBM was thinking but the problems are infinite. It works, and is stable so don't get me wrong, but compared to SQL server forget it.
All those nice things that are built into SQL server, like deleting old backups (sounds simple but we had to write scripts to handle that, although the same problem on AIX too)
Unless you set the DB up just right it fragments heavily, unlike SQL Server using a single large dataset, DB2 creates a seperate file for each table and index.
Using the Control Center, IBMs version of EM (and I use the term very loosely) is fairly stable as of the 7. later versions. I used to cancel 7.1s more often then I closed it.
Try things like Alter view, interestingly they give you the option but you can't do anything.
Use the DB2look tool to export the DDL, each object is one long string, forget formatting. So if you have a complex view and you don't have a pretty original expect to spend time making it readable before you can change it.
Finally, that lovely Control Center attempts to connect to the DB with your NT userid, but doesn't seem to get the password right so it locks it out constantly. Again that is true on AIX also.
And the security integration with NT does NOT work as the books indicate.
One note I have not spent a lot of time with the 8.? versions all of my experience is with 7.?. Although I did fire up 8.1 enough to try a few things and did not notice a lot of differences.
The changes they are touting for 8 look nice if you have monster DBs, but we don't.
KlK, MCSE
KlK -
quote:
DB2 on Windows is a mistake, I don't know what IBM was thinking but the problems are infinite. It works, and is stable so don't get me wrong, but compared to SQL server forget it.I guess you know those situation where you cannot argue with sound and logical arguments!
Someone who decides, wants to have DB/2 and that person has greater influence than me.
But who am I to judge on management decisions ??
I haven't got the requires entrepreneurial long sight and after all it's not my money
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
When somebody else is spending the money, well I suppose there is nothing you can do. Often though if you present a case based on facts at a higher enough level, their minds can be changed and you will be amazed at how ill informed some of the higher management are. Also if you present to a higher level it will do wonders for your profile.
I have found decisions over DBMS (Oracle and DB@) tend to be made over an expensive bottle of wine. Where as SQL Server is brought in at the technical level, because it just works.
Declan
-
quote:
When somebody else is spending the money, well I suppose there is nothing you can do. Often though if you present a case based on facts at a higher enough level, their minds can be changed and you will be amazed at how ill informed some of the higher management are. Also if you present to a higher level it will do wonders for your profile.I know how ill informed top management sometimes is. I'm doing this myself frequently, to keep those guys out of operational business.
quote:
I have found decisions over DBMS (Oracle and DB@) tend to be made over an expensive bottle of wine. Where as SQL Server is brought in at the technical level, because it just works.That's where the really important decision are always made. On the golf yard ?!? or over a bottle of wine, or both ?
Anyway, I've seen bills for six bottles of wine with the total amount of some thousand dollars. So who cares about spending some 100,000 $ on software licenses, installation, implementation and training. But beware if you ask for a book on SQL Server for 100$. That's totally different
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply