SSL support for natvie DB2 LUW (non-SQLJ/JDBC)

On Jul 24, 3:01 pm, "Frank Swarbrick"
wrote:
> I can't tell if this does or does not address .NET clients. Does it?
>
> Thanks,
> Frank

Hi,

That support is available on V91 FP5:

http://publib.boulder.ibm.com/infoce...c/c0053516.htm

and will come out when FP2 is available.

Frank Swarbrick wrote:

> Where would be the best place to check for the newest fixpacks, so that I
> can look for it when it comes out for 9.5?

http://www-933.ibm.com/eserver/support/fixes/

Select "Information Management", then "DB2", then "9.5.*", then your
platform, and hit continue. Then select "Recommended", "continue" (this
selects the most current fix pack). Then select the group (there should
only be one, I think) - you should be able to just hit "select all". Now
you have a choice - use Download Director (IBM's Java applet that can
download a file in a swarm mode similar to peer-to-peer, but all
connections will be to IBM, not to others, so it's not really peers - can
help maximise your bandwidth usage to get the file as fast as possible),
or, if Java doesn't work well for you, regular HTTP mode. Select one (DD
is default), and hit "continue." Now you'll have a list of everything for
your platform in the latest 9.5 fix pack. Choose what to download, and
you're off.

Alternately, instead of selecting "recommended", if you want a particular
fix pack, you can try selecting "Text" and putting in "FP2". That
currently will return nothing (FP2 isn't available yet), but once FP2 is
available, the search will return what you 're interested in. This works
fine when you want to know that a particular fix pack is out, but not as
useful when you just want the latest (as IBM suggests you do ;-) ).

>>> On 7/25/2008 at 12:28 PM, in message ,
Darin McBride wrote:
> Frank Swarbrick wrote:
>
>> Where would be the best place to check for the newest fixpacks, so that
> I
>> can look for it when it comes out for 9.5?
>
> http://www-933.ibm.com/eserver/support/fixes/
>
> Select "Information Management", then "DB2", then "9.5.*", then your
> platform, and hit continue. Then select "Recommended", "continue" (this
> selects the most current fix pack). Then select the group (there should
> only be one, I think) - you should be able to just hit "select all". Now
> you have a choice - use Download Director (IBM's Java applet that can
> download a file in a swarm mode similar to peer-to-peer, but all
> connections will be to IBM, not to others, so it's not really peers - can
> help maximise your bandwidth usage to get the file as fast as possible),
> or, if Java doesn't work well for you, regular HTTP mode. Select one
> (DD
> is default), and hit "continue." Now you'll have a list of everything
> for
> your platform in the latest 9.5 fix pack. Choose what to download, and
> you're off.
>
> Alternately, instead of selecting "recommended", if you want a
> particular
> fix pack, you can try selecting "Text" and putting in "FP2". That
> currently will return nothing (FP2 isn't available yet), but once FP2 is
> available, the search will return what you 're interested in. This
> works
> fine when you want to know that a particular fix pack is out, but not as
> useful when you just want the latest (as IBM suggests you do ;-) ).

Thanks.

This actually led me to a page that seems even more useful:
http://www-1.ibm.com/support/docview...id=swg21293566

This is the page for "DB2 Version 9.5 for Linux, UNIX and Windows APARs by
fix pack".
Nice!

Frank

Hello,

Version 9.5 Fix Pack 2 is available. You can download it using the
links listed in earlier postings. The V9.5 Information Center has
been updated as well:

http://publib.boulder.ibm.com/infoce.../c0053323.html

Links for the SSL support are available from there.

>>> On 8/26/2008 at 3:06 AM, in message
<5d83950d-b7b4-4a91-ae10-acbe3c658d4a@59g2000hsb.googlegroups.com>,
louisem wrote:
> Hello,
>
> Version 9.5 Fix Pack 2 is available. You can download it using the
> links listed in earlier postings. The V9.5 Information Center has
> been updated as well:
>
> http://publib.boulder.ibm.com/infoce.../com.ibm.db2.l
> uw.wn.doc/doc/c0053323.html
>
> Links for the SSL support are available from there.

Great!

Now I have a question... I have DB2 9.5 Express-C installed on my
workstation. We also have DB2 9.5 ESE (I think) installed on some Linux
servers. Assuming we get FP2 loaded on the Linux servers, what can I do to
get this functionality on my PC from a client perspective? I'm not
concerned about the server part of FP2 on my workstation. I know that
Express-C doesn't offer (free) fix packs. But I do want to be able to
connect using SSL from my workstation to the Linux servers.

Thanks,
Frank

Frank Swarbrick wrote:

>>>> On 8/26/2008 at 3:06 AM, in message
> <5d83950d-b7b4-4a91-ae10-acbe3c658d4a@59g2000hsb.googlegroups.com>,
> louisem wrote:
>> Hello,
>>
>> Version 9.5 Fix Pack 2 is available. You can download it using the
>> links listed in earlier postings. The V9.5 Information Center has
>> been updated as well:
>>
>> http://publib.boulder.ibm.com/infoce.../com.ibm.db2.l
>> uw.wn.doc/doc/c0053323.html
>>
>> Links for the SSL support are available from there.
>
> Great!
>
> Now I have a question... I have DB2 9.5 Express-C installed on my
> workstation. We also have DB2 9.5 ESE (I think) installed on some Linux
> servers. Assuming we get FP2 loaded on the Linux servers, what can I do
> to
> get this functionality on my PC from a client perspective? I'm not
> concerned about the server part of FP2 on my workstation. I know that
> Express-C doesn't offer (free) fix packs. But I do want to be able to
> connect using SSL from my workstation to the Linux servers.

Option 1: Wait for Express-C at FP2 or later level. I have no idea if this
is planned or not, so you may be waiting a looooong time.

Option 2: Buy Express-C FTL. This will give you the ability to use the
general fix packs.

Option 3: Download and install Data Server Client. This is free and DOES
come with fix pack support. You'll have to install it to a new location,
say /opt/ibm/db2/9.5.client. And then you'll have to create a new instance.
But that instance will have SSL support.

Non-Option 4: grab the client libraries from the server and copy them over.
Not really sure how this works, but it may work. Not recommended because
it's unlikely to be supported. Mind you, neither is Express-C, so it's not
going to jeopardise anything that way.