Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to determine DB2 OS?

 
Dmitry Danilov
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

Does anybody know how to determine operating system of DB2 through jdbc?
Looks like one could use DataBaseMetaData.getDatabaseProductName(), which in case of Windows will return something like 'DB2/NT'. But what about other OS'es like Unix, z/OS and OS/400?
 
Ulf Dittmer
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I would imagine that the DB2 documentation lists the various possibilities.
 
Dmitry Danilov
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ulf, you'll be laughing mate, but I spent a whole day seeking high and low...
 
Guy Allard
Ranch Hand
Posts: 776
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It's IBM, and the documentation will be there, but not all in one place.

The value for each platform will be listed in the platform specific DB2 documentation.

And I saw at least one case (a filed APAR, a bug) where a driver was retruning only 'DB2' when connected to zOS.

Good luck.

Guy
 
Dmitry Danilov
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Guy, cheers mate
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic