aspose file tools*
The moose likes JDBC and the fly likes how to determine DB2 OS? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to determine DB2 OS?" Watch "how to determine DB2 OS?" New topic
Author

how to determine DB2 OS?

Dmitry Danilov
Ranch Hand

Joined: Jan 27, 2004
Posts: 38
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
Marshal

Joined: Mar 22, 2005
Posts: 42611
    
  65
I would imagine that the DB2 documentation lists the various possibilities.


Ping & DNS - my free Android networking tools app
Dmitry Danilov
Ranch Hand

Joined: Jan 27, 2004
Posts: 38
Ulf, you'll be laughing mate, but I spent a whole day seeking high and low...
Guy Allard
Ranch Hand

Joined: Nov 24, 2000
Posts: 776
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

Joined: Jan 27, 2004
Posts: 38
Guy, cheers mate
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to determine DB2 OS?