| Author |
Topic |
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
 Posted - 2003-08-19 : 04:43:10
|
| Hi there,as it seems my company is moving towards DB/2 as a second platform, is there a similar site (forum) for DB/2 ?Cheers,Frank |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-03 : 14:55:01
|
| No...But go ahead and ask here...I know a little DB2Brett8-)SELECT @@POST=NewId()That's correct! It's an AlphaNumeric! |
 |
|
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
Posted - 2003-09-04 : 03:41:27
|
| Thanks for your offer. I will come back to it, when I need to. But I wonder, how DB/2 DBA's enhance their knowledge. Are they born with it or do they all have premium support contracts with IBM?Cheers,Frank |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-04 : 11:05:09
|
quote:
Originally posted by Frank Kalis
or do they all have premium support contracts with IBM?
You being funny?Break out the manuals Frankie....http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/libraryand subscribe to this forum...Brett8-)SELECT @@POST=NewId()That's correct! It's an AlphaNumeric! |
|
|
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-04 : 11:32:05
|
| Subscribe means you'll get an email for the forum...look at other topics main page..there will be a subscribe option...just click on it...when do you start you descendance in to db2?Brett8-)SELECT @@POST=NewId()That's correct! It's an AlphaNumeric! |
|
|
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
Posted - 2003-09-04 : 11:46:03
|
Ah yes, subcription....I'm struggling with this point. Snitz supports I think three or more different levels of subscription. for most categories here subscription seems to be set to topic level. So you have to watch carefully to catch all interesting topics. and I think I'll miss a lot of those topics here. And in addition the standard notification mail from Snitz isn't really meaning full at all. Just a notice that someone else has replied. I mailed graz some time ago a slight modification I did myself here to make it more meaningful, but haven't heard anything yet.As for the start of DB/2. This is just a plan right now. Our mainframe uses it and some smart consultants came up with the idea that it must also be a good solution on windows. If it start at all, it will somewhen ?!? in 2004 or 2005. but I thought it doesn't hurt me to stay informationally ahead of the rest  Cheers,Frank |
|
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2003-09-04 : 12:07:20
|
| Ahhh but Frank - remember:DB2 is the label attached to a suite of unrelated products. DB2 on the mainframe is different from DB2 on AIX is different from DB2 on a PC ... they had independent product development teams, they support different standards, and it is absolutely NOT TRUE that DB2 is a platform independent product. Fire those consultants and stick with SQL Server.Jonathan{0} |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-04 : 12:28:19
|
quote:
Originally posted by setbasedisthetruepath
Ahhh but Frank - remember:DB2 is the label attached to a suite of unrelated products. DB2 on the mainframe is different from DB2 on AIX is different from DB2 on a PC ... they had independent product development teams, they support different standards, and it is absolutely NOT TRUE that DB2 is a platform independent product. Fire those consultants and stick with SQL Server.Jonathan{0}
True....I'm sure the deployment is different on different platforms...and I'm sure the GUIs (what no GUI on the mainframe?) may be different...but the objects, catalogs, sql are the same...Also, most of our larger client/server udb deployments are AIX based...no windows there...like Oracle, they seem to have less problems on unix based o/s's...And if you've never been exposed to O/S390...and they're telling you have to go there...might as well by a gun...I still have to make return trips every so often...(like now..) Brett8-)SELECT @@POST=NewId()That's correct! It's an AlphaNumeric! |
|
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2003-09-04 : 12:47:25
|
quote:
True....I'm sure the deployment is different on different platforms...and I'm sure the GUIs (what no GUI on the mainframe?) may be different...but the objects, catalogs, sql are the same...
Well, let me know how your experience differs, but I'm saying the above is not true - the SQL is different. You can execute certain commands on "mainframe DB2" that are not implemented on other platforms. So you can't necessarily migrate a mainframe DB2 database to an AIX DB2 installation and expect it to work flawlessly. Same in reverse.I had an unpleasant experience dealing with this several years back overseeing a banking conversion. Everyone *assumed* that we could take DB2 objects on the mainframe and simply migrate them to AIX or to Windows; that's not always the case. What a headache!Jonathan{0} |
|
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2003-09-04 : 12:56:29
|
quote:
True....I'm sure the deployment is different on different platforms...and I'm sure the GUIs (what no GUI on the mainframe?) may be different...but the objects, catalogs, sql are the same...
Well, let me know how your experience differs, but I'm saying the above is not true - the SQL is different. You can execute certain commands on "mainframe DB2" that are not implemented on other platforms. So you can't necessarily migrate a mainframe DB2 database to an AIX DB2 installation and expect it to work flawlessly. Same in reverse.I had an unpleasant experience dealing with this several years back overseeing a banking conversion. Everyone *assumed* that we could take DB2 objects on the mainframe and simply migrate them to AIX or to Windows; that's not always the case. What a headache!Jonathan{0} |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-04 : 13:23:11
|
| Like what commands? I'd be amazed to find that DB2 O/S390 is more feature rich...additionally, what version? Back around 5, they definetly were light years apart...I'm not so sure now with V8I downloaded it a while ago for windows...got to get around to installing it...Let you know how it looks...but the application programming and reference guide is for all platforms...Anyway...what's new about V8http://www-3.ibm.com/software/data/db2/udb/pdfs/db2q0.pdfBrett8-)SELECT @@POST=NewId()That's correct! It's an AlphaNumeric! |
|
|
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
Posted - 2003-09-05 : 02:00:42
|
quote:
Fire those consultants and stick with SQL Server.
 I like this sound.After all the same consultants suggested to use Java to harmonize our IT structure, kick out Oracles (not that I don't like this one), use XP ....I had a funny discussion them with how to pronounce SQL ? I don't really think they are clever and smart at all, but I'm definitely sure they earn twice as much as I  Cheers,Frank |
|
|
|
|
Anything similar for DB/2?