Toad World® Forums

New install of Toad for DB2 Z/OS

ERROR [42724] [IBM] SQL1109N The specified DLL “GSKit Error: 202” could not be loaded. SQLSTATE=42724

While trying to connect to my databases.

SSL Client key information is blank.

I have my current “Path” set to:

C:\app\PT42970\product\11.2.0\client_3;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%systemroot%\System32\WindowsPowerShell\v1.0;%systemroot%\System32\WindowsPowerShell\v1.0;C:\Program Files (x86)\1E\NomadBranch;C:\Program Files (x86)\BlueZone\6.1;C:\Program Files\CREDANT\Shield v6.8.2;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\Program Files (x86)\QuickTime\QTSystem\

Since I do Oracle work as well.

Hi,

We have seen this error after DB2 10.5 64-bit installation. What helped here was machine reboot, since the installation is changing your PATH.

After that you should see gsk8 added in your path and the error message should be gone:

C:\Program Files\IBM\SQLLIB\BIN>echo %PATH%

C:\Program Files\IBM\SQLLIB\BIN…\db2tss\bin;C:\PROGRA~1\IBM\SQLLIB\BIN…\db2tss\bin;C:\Program Files\IBM\SQLLIB\BIN;C:\Program Files\IBM\SQLLIB\FUNCTION;C:\Windows\system32;C:\Windows;C:\Windows\system32\wbem;C:\Windows\system32\windowspowershell\v1.0;c:\program files\ibm\gsk8\lib64;c:\program files (x86)\ibm\gsk8\lib

Hope it helps

Zdenek

Morning. I figured that would do
it… but it didn’t. I am going to add the path manually if at all
possible. Just haven’t had time lately… fighting fires…

Robert W Morrison

Database Admin Sr.

ECS Database Technologies

4653 E. Main St. Whitehall, OH 43213

Locator: B4-YC59-01-M

614-856-5332 (office)

R.Morrison@PNC.Com

From:
“Zdenek.Sohnel”
bounce-ZdenekSohnel@toadworld.com

To:
toaddb2@toadworld.com,

Date:
02/09/2015 08:55 AM

Subject:
RE: [Toad for
IBM DB2 - Discussion Forum] New install of Toad for DB2 Z/OS


RE:
New install of Toad for DB2 Z/OS

Reply by Zdenek.Sohnel
Hi,

We have seen this error after DB2 10.5 64-bit
installation. What helped here was machine reboot, since the installation
is changing your PATH.

After that you should see gsk8 added in your
path and the error message should be gone:

C:\Program Files\IBM\SQLLIB\BIN>echo
%PATH%

C:\Program Files\IBM\SQLLIB\BIN…\db2tss\bin;C:\PROGRA~1\IBM\SQLLIB\BIN…\db2tss\bin;C:\Program
Files\IBM\SQLLIB\BIN;C:\Program Files\IBM\SQLLIB\FUNCTION;C:\Windows\system32;C:\Windows;C:\Windows\system32\wbem;C:\Windows\system32\windowspowershell\v1.0;c:\program
files\ibm\gsk8\lib64;c:\program files (x86)\ibm\gsk8\lib

Hope it helps

Zdenek

To reply, please reply-all to
this email.

Stop
receiving emails

on this subject.

Or Unsubscribe
from Toad for IBM DB2 - General

notifications altogether.

Toad for IBM DB2 - Discussion Forum

Flag
this post as spam/abuse.

The contents of this email are the property of PNC. If it was not addressed to you, you have no legal right to read it. If you think you received it in error, please notify the sender. Do not forward or copy without permission of the sender. This message may be considered a commercial electronic message under Canadian law or this message may contain an advertisement of a product or service and thus may constitute a commercial electronic mail message under US law. You may unsubscribe at any time from receiving commercial electronic messages from PNC at http://pages.e.pnc.com/globalunsub/

PNC, 249 Fifth Avenue, Pittsburgh, PA 15222; pnc.com

Changed… No affect.

C:\app\PT42970\product\11.2.0\client_3;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%systemroot%\System32\WindowsPowerShell\v1.0;%systemroot%\System32\WindowsPowerShell\v1.0;C:\Program
Files (x86)\1E\NomadBranch;C:\Program Files (x86)\BlueZone\6.1;C:\Program
Files\CREDANT\Shield v6.8.2;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\Program
Files (x86)\QuickTime\QTSystem;C:\Program Files\IBM\SQLLIB\BIN\icc64;C:\Program
Files\IBM\SQLLIB\BIN\icc

Probably just have to drop and reinstall

Any ideas.

Robert W Morrison

Database Admin Sr.

ECS Database Technologies

4653 E. Main St. Whitehall, OH 43213

Locator: B4-YC59-01-M

614-856-5332 (office)

R.Morrison@PNC.Com

From:
“Zdenek.Sohnel”
bounce-ZdenekSohnel@toadworld.com

To:
toaddb2@toadworld.com,

Date:
02/09/2015 08:55 AM

Subject:
RE: [Toad for
IBM DB2 - Discussion Forum] New install of Toad for DB2 Z/OS


RE:
New install of Toad for DB2 Z/OS

Reply by Zdenek.Sohnel
Hi,

We have seen this error after DB2 10.5 64-bit
installation. What helped here was machine reboot, since the installation
is changing your PATH.

After that you should see gsk8 added in your
path and the error message should be gone:

C:\Program Files\IBM\SQLLIB\BIN>echo
%PATH%

C:\Program Files\IBM\SQLLIB\BIN…\db2tss\bin;C:\PROGRA~1\IBM\SQLLIB\BIN…\db2tss\bin;C:\Program
Files\IBM\SQLLIB\BIN;C:\Program Files\IBM\SQLLIB\FUNCTION;C:\Windows\system32;C:\Windows;C:\Windows\system32\wbem;C:\Windows\system32\windowspowershell\v1.0;c:\program
files\ibm\gsk8\lib64;c:\program files (x86)\ibm\gsk8\lib

Hope it helps

Zdenek

To reply, please reply-all to
this email.

Stop
receiving emails

on this subject.

Or Unsubscribe
from Toad for IBM DB2 - General

notifications altogether.

Toad for IBM DB2 - Discussion Forum

Flag
this post as spam/abuse.

The contents of this email are the property of PNC. If it was not addressed to you, you have no legal right to read it. If you think you received it in error, please notify the sender. Do not forward or copy without permission of the sender. This message may be considered a commercial electronic message under Canadian law or this message may contain an advertisement of a product or service and thus may constitute a commercial electronic mail message under US law. You may unsubscribe at any time from receiving commercial electronic messages from PNC at http://pages.e.pnc.com/globalunsub/

PNC, 249 Fifth Avenue, Pittsburgh, PA 15222; pnc.com

Robert,

If you are showing your PATH environment variable in your previous post, it does not appear that it has been modified to include the gsk8 directories. Can you re-confirm that those are in the PATH and confirm exactly what directory names the gsk8 files are in?

Thanks

Jeff

Already did that and it is still not working
for windows 7… I am working with Dell Support on this one.

Thanks,

Rob.

Robert W Morrison

Database Admin Sr.

ECS Database Technologies

4653 E. Main St. Whitehall, OH 43213

Locator: B4-YC59-01-M

614-856-5332 (office)

R.Morrison@PNC.Com

From:
“Jeff Podlasek”
bounce-Jeff_Podlasek@toadworld.com

To:
toaddb2@toadworld.com,

Date:
02/12/2015 12:15 PM

Subject:
RE: [Toad for
IBM DB2 - Discussion Forum] New install of Toad for DB2 Z/OS


RE:
New install of Toad for DB2 Z/OS

Reply by Jeff Podlasek
Robert,

If you are showing your PATH environment variable
in your previous post, it does not appear that it has been modified to
include the gsk8 directories. Can you re-confirm that those are in
the PATH and confirm exactly what directory names the gsk8 files are in?

Thanks

Jeff

To reply, please reply-all to
this email.

Stop
receiving emails

on this subject.

Or Unsubscribe
from Toad for IBM DB2 - General

notifications altogether.

Toad for IBM DB2 - Discussion Forum

Flag
this post as spam/abuse.

The contents of this email are the property of PNC. If it was not addressed to you, you have no legal right to read it. If you think you received it in error, please notify the sender. Do not forward or copy without permission of the sender. This message may be considered a commercial electronic message under Canadian law or this message may contain an advertisement of a product or service and thus may constitute a commercial electronic mail message under US law. You may unsubscribe at any time from receiving commercial electronic messages from PNC at http://pages.e.pnc.com/globalunsub/

PNC, 249 Fifth Avenue, Pittsburgh, PA 15222; pnc.com