DB2 Connect Manuals / Reference

Philip Sevetson

DB2 Connect Manuals / Reference
I'm trying to establish _what_ DB2 Connect version is being used by my agency, and I'm not finding anything useful with Web searching. Looking for "DB2 Connect manual" keeps pushing me to "DB2 for Linux, Unix, and Windows." Can someone please point me to any manual, anywhere, which will allow me to figure out _how_ to identify the version and fixpack of the product?

I've already asked my DB2 sysprog, who tells me that the version is "DB2 Connect 10.5 Fixpack." I can't understand that naming; it looks wrong, there _should_ be a _number_ after the word "Fixpack". But when I go looking for that number, I wind up at
https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads
which appears to be a DB2 _LUW_ reference, not a DB2 _connect_ reference.

What am I doing wrong, here?

-phil s.


Philip Sevetson
Computer Systems Manager
FISA-OPA
5 Manhattan West
New York, NY 10001
[login to unmask email]<mailto:[login to unmask email]>
212-857-1688 w
917-991-7052 m
212-857-1659 f
[cid:[login to unmask email]

**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
Attachments

  • image001.png (3.3k)

Philip Sevetson

DB2 Connect Manuals / Reference
(in response to Philip Sevetson)
Disregard previous request. We found what we need in the product compatibility matrix doc for V12.

-phil s.


Philip Sevetson
Computer Systems Manager
FISA-OPA
5 Manhattan West
New York, NY 10001
[login to unmask email]<mailto:[login to unmask email]>
212-857-1688 w
917-991-7052 m
212-857-1659 f
[cid:[login to unmask email]

From: Sevetson, Phil <[login to unmask email]>
Sent: Thursday, January 30, 2020 10:25 AM
To: '[login to unmask email]' <[login to unmask email]>
Subject: [DB2-L] - DB2 Connect Manuals / Reference

I'm trying to establish _what_ DB2 Connect version is being used by my agency, and I'm not finding anything useful with Web searching. Looking for "DB2 Connect manual" keeps pushing me to "DB2 for Linux, Unix, and Windows." Can someone please point me to any manual, anywhere, which will allow me to figure out _how_ to identify the version and fixpack of the product?

I've already asked my DB2 sysprog, who tells me that the version is "DB2 Connect 10.5 Fixpack." I can't understand that naming; it looks wrong, there _should_ be a _number_ after the word "Fixpack". But when I go looking for that number, I wind up at
https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads
which appears to be a DB2 _LUW_ reference, not a DB2 _connect_ reference.

What am I doing wrong, here?

-phil s.


Philip Sevetson
Computer Systems Manager
FISA-OPA
5 Manhattan West
New York, NY 10001
[login to unmask email]<mailto:[login to unmask email]>
212-857-1688 w
917-991-7052 m
212-857-1659 f
[cid:[login to unmask email]

**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
Attachments

  • image001.png (3.3k)

Mark Vickers

DB2 Connect Manuals / Reference
(in response to Philip Sevetson)
To answer the question if others need it.

Run the "DB2 Command Window - Administrator"
Type in "db2level"

e.g.
C:\Program Files\IBM\SQLLIB\BIN>db2level
DB21085I This instance or install (instance name, where applicable: "DB2")
uses "64" bits and DB2 code release "SQL11013" with level identifier
"0204010F".
Informational tokens are "DB2 v11.1.3030.239", "s1803021700",
"DYN1803021700WIN64", and Fix Pack "3".
Product is installed at "C:\PROGRA~1\IBM\SQLLIB" with DB2 Copy Name "DB2COPY1".

If you need the Enterprise Edition Server level, you will have to log into the server and run it there.

From: Sevetson, Phil [mailto:[login to unmask email]
Sent: Thursday, January 30, 2020 10:39 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 Connect Manuals / Reference

Disregard previous request. We found what we need in the product compatibility matrix doc for V12.

-phil s.


Philip Sevetson
Computer Systems Manager
FISA-OPA
5 Manhattan West
New York, NY 10001
[login to unmask email]<mailto:[login to unmask email]>
212-857-1688 w
917-991-7052 m
212-857-1659 f
[cid:[login to unmask email]

From: Sevetson, Phil <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Thursday, January 30, 2020 10:25 AM
To: '[login to unmask email]' <[login to unmask email]<mailto:[login to unmask email]>>
Subject: [DB2-L] - DB2 Connect Manuals / Reference

I'm trying to establish _what_ DB2 Connect version is being used by my agency, and I'm not finding anything useful with Web searching. Looking for "DB2 Connect manual" keeps pushing me to "DB2 for Linux, Unix, and Windows." Can someone please point me to any manual, anywhere, which will allow me to figure out _how_ to identify the version and fixpack of the product?

I've already asked my DB2 sysprog, who tells me that the version is "DB2 Connect 10.5 Fixpack." I can't understand that naming; it looks wrong, there _should_ be a _number_ after the word "Fixpack". But when I go looking for that number, I wind up at
https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads https://urldefense.com/v3/__https:/www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads__;!!Os7eWUw!_G_ttL2hBbKugiiN94wNg3AWAQYdYvcpPN3AxoJTrYjSPJRgkCTHxlIlbvawlXykH7DKYJE$
which appears to be a DB2 _LUW_ reference, not a DB2 _connect_ reference.

What am I doing wrong, here?

-phil s.


Philip Sevetson
Computer Systems Manager
FISA-OPA
5 Manhattan West
New York, NY 10001
[login to unmask email]<mailto:[login to unmask email]>
212-857-1688 w
917-991-7052 m
212-857-1659 f
[cid:[login to unmask email]

**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
________________________________
Attachment Links: image001.png (3 k) https://urldefense.com/v3/__https:/www.idug.org/p/fo/do/?download=1&fid=11421__;!!Os7eWUw!_G_ttL2hBbKugiiN94wNg3AWAQYdYvcpPN3AxoJTrYjSPJRgkCTHxlIlbvawlXykp0vQVBI$
Site Links: View post online https://urldefense.com/v3/__https:/www.idug.org/p/fo/st/?post=191496&anc=p191496*p191496__;Iw!!Os7eWUw!_G_ttL2hBbKugiiN94wNg3AWAQYdYvcpPN3AxoJTrYjSPJRgkCTHxlIlbvawlXykLHQ5kCQ$ View mailing list online https://urldefense.com/v3/__https:/www.idug.org/p/fo/si/?topic=19__;!!Os7eWUw!_G_ttL2hBbKugiiN94wNg3AWAQYdYvcpPN3AxoJTrYjSPJRgkCTHxlIlbvawlXykcRCQyuA$ Start new thread via email<mailto:[login to unmask email]> Unsubscribe from this mailing list<mailto:[login to unmask email]?Subject=Unsubscribe> Manage your subscription https://urldefense.com/v3/__https:/www.idug.org/p/us/to/__;!!Os7eWUw!_G_ttL2hBbKugiiN94wNg3AWAQYdYvcpPN3AxoJTrYjSPJRgkCTHxlIlbvawlXykg6q7YZQ$

This email has been sent to: [login to unmask email]<mailto:[login to unmask email]>

Try BCV5, the BCV5 Masking Tool, & XDM a rapid Refresh/Clone/TDM Suite for Db2 z & distributed.
DBARS -Audit,record,& block Db2 accesses to sensitive data real-time, NO audit trace or log required
http://www.ESAIGroup.com/IDUG https://urldefense.com/v3/__http:/www.ESAIGroup.com/IDUG__;!!Os7eWUw!_G_ttL2hBbKugiiN94wNg3AWAQYdYvcpPN3AxoJTrYjSPJRgkCTHxlIlbvawlXykd7CWICA$

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2 https://urldefense.com/v3/__http:/www.idug.org/p/cm/ld/fid=2__;!!Os7eWUw!_G_ttL2hBbKugiiN94wNg3AWAQYdYvcpPN3AxoJTrYjSPJRgkCTHxlIlbvawlXykX_p1kSM$

________________________________

J&#248;rn Thyssen

RE: DB2 Connect Manuals / Reference
(in response to Philip Sevetson)

Hi Phil,

Your link is correct. If you’re using a Db2 Connect Server (a.k.a. gateway) you should be able to find the version with the command db2level.

If you’re using direct connections you’ll likely see many different versions. You can find the versions in the SMF accounting records.


In Reply to Philip Sevetson:

I'm trying to establish _what_ DB2 Connect version is being used by my agency, and I'm not finding anything useful with Web searching. Looking for "DB2 Connect manual" keeps pushing me to "DB2 for Linux, Unix, and Windows." Can someone please point me to any manual, anywhere, which will allow me to figure out _how_ to identify the version and fixpack of the product?

I've already asked my DB2 sysprog, who tells me that the version is "DB2 Connect 10.5 Fixpack." I can't understand that naming; it looks wrong, there _should_ be a _number_ after the word "Fixpack". But when I go looking for that number, I wind up at
https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads
which appears to be a DB2 _LUW_ reference, not a DB2 _connect_ reference.

What am I doing wrong, here?

-phil s.


Philip Sevetson
Computer Systems Manager
FISA-OPA
5 Manhattan West
New York, NY 10001
[login to unmask email]<mailto:[login to unmask email]>
212-857-1688 w
917-991-7052 m
212-857-1659 f
[cid:[login to unmask email]

**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**



 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

2020 IBM Champion.

Views are personal. 

Mark Vickers

DB2 Connect Manuals / Reference
(in response to Jørn Thyssen)
Correct me if I am wrong but our IBM rep told us that direct distributed connections were not allowed, we had to go through the gateway EE Server ?

From: Jørn Thyssen [mailto:[login to unmask email]
Sent: Thursday, January 30, 2020 11:58 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 Connect Manuals / Reference


Hi Phil,

Your link is correct. If you’re using a Db2 Connect Server (a.k.a. gateway) you should be able to find the version with the command db2level.

If you’re using direct connections you’ll likely see many different versions. You can find the versions in the SMF accounting records.

In Reply to Philip Sevetson:
I'm trying to establish _what_ DB2 Connect version is being used by my agency, and I'm not finding anything useful with Web searching. Looking for "DB2 Connect manual" keeps pushing me to "DB2 for Linux, Unix, and Windows." Can someone please point me to any manual, anywhere, which will allow me to figure out _how_ to identify the version and fixpack of the product?

I've already asked my DB2 sysprog, who tells me that the version is "DB2 Connect 10.5 Fixpack." I can't understand that naming; it looks wrong, there _should_ be a _number_ after the word "Fixpack". But when I go looking for that number, I wind up at
https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads https://urldefense.com/v3/__https:/www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads__;!!Os7eWUw!8dibzMOvDLKFvY4HqcY6RKRknWLlZQrg2PmmvVti6Nq9nuavvF61r7iYFYXh9BgVdMxvjVE$
which appears to be a DB2 _LUW_ reference, not a DB2 _connect_ reference.

What am I doing wrong, here?

-phil s.


Philip Sevetson
Computer Systems Manager
FISA-OPA
5 Manhattan West
New York, NY 10001
[login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e>
212-857-1688 w
917-991-7052 m
212-857-1659 f
[cid:[login to unmask email]

**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]> • W: www.rocketsoftware.com http://www.rocketsoftware.com

2020 IBM Champion.

Views are personal.

-----End Original Message-----

Kenneth Lee

DB2 Connect Manuals / Reference
(in response to Mark Vickers)
I am afraid that your IBM rep was misunderstood.
IBM has been promoting direct connection for years unless you have some 2 phase commit application, which is not common.
We got rid of the gateways a long time ago.

Ken

From: Vickers, Mark [mailto:[login to unmask email]
Sent: Thursday, January 30, 2020 1:40 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 Connect Manuals / Reference

Correct me if I am wrong but our IBM rep told us that direct distributed connections were not allowed, we had to go through the gateway EE Server ?

From: Jørn Thyssen [mailto:[login to unmask email]<mailto:[login to unmask email]>]
Sent: Thursday, January 30, 2020 11:58 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2 Connect Manuals / Reference


Hi Phil,

Your link is correct. If you’re using a Db2 Connect Server (a.k.a. gateway) you should be able to find the version with the command db2level.

If you’re using direct connections you’ll likely see many different versions. You can find the versions in the SMF accounting records.

In Reply to Philip Sevetson:
I'm trying to establish _what_ DB2 Connect version is being used by my agency, and I'm not finding anything useful with Web searching. Looking for "DB2 Connect manual" keeps pushing me to "DB2 for Linux, Unix, and Windows." Can someone please point me to any manual, anywhere, which will allow me to figure out _how_ to identify the version and fixpack of the product?

I've already asked my DB2 sysprog, who tells me that the version is "DB2 Connect 10.5 Fixpack." I can't understand that naming; it looks wrong, there _should_ be a _number_ after the word "Fixpack". But when I go looking for that number, I wind up at
https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads https://secureweb.jpmchase.net/readonly/https:/urldefense.com/v3/__https:/www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads__;!!Os7eWUw!8dibzMOvDLKFvY4HqcY6RKRknWLlZQrg2PmmvVti6Nq9nuavvF61r7iYFYXh9BgVdMxvjVE$
which appears to be a DB2 _LUW_ reference, not a DB2 _connect_ reference.

What am I doing wrong, here?

-phil s.


Philip Sevetson
Computer Systems Manager
FISA-OPA
5 Manhattan West
New York, NY 10001
[login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]><mailto:[login to unmask email]%3e>
212-857-1688 w
917-991-7052 m
212-857-1659 f
[cid:[login to unmask email]

**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]> • W: www.rocketsoftware.com https://secureweb.jpmchase.net/readonly/http:/www.rocketsoftware.com

2020 IBM Champion.

Views are personal.

-----End Original Message-----

-----End Original Message-----

This message is confidential and subject to terms at: https://www.jpmorgan.com/emaildisclaimer including on confidential, privileged or legal entity information, viruses and monitoring of electronic messages. If you are not the intended recipient, please delete this message and notify the sender immediately. Any unauthorized use is strictly prohibited.

Chris Hoelscher

DB2 Connect Manuals / Reference
(in response to Mark Vickers)
I think that is incorrect – in fact we Have been elimination gateway servers for the past year – and relying solely on direct connect client software

Thank You,
Chris Hoelscher| Lead Database Administrator | IBM Global Technical Services| T 502.476.2538 or 502.407.7266

From: Vickers, Mark <[login to unmask email]>
Sent: Thursday, January 30, 2020 1:40 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 Connect Manuals / Reference

Correct me if I am wrong but our IBM rep told us that direct distributed connections were not allowed, we had to go through the gateway EE Server ?

From: Jørn Thyssen [mailto:[login to unmask email]
Sent: Thursday, January 30, 2020 11:58 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2 Connect Manuals / Reference


Hi Phil,

Your link is correct. If you’re using a Db2 Connect Server (a.k.a. gateway) you should be able to find the version with the command db2level.

If you’re using direct connections you’ll likely see many different versions. You can find the versions in the SMF accounting records.

In Reply to Philip Sevetson:
I'm trying to establish _what_ DB2 Connect version is being used by my agency, and I'm not finding anything useful with Web searching. Looking for "DB2 Connect manual" keeps pushing me to "DB2 for Linux, Unix, and Windows." Can someone please point me to any manual, anywhere, which will allow me to figure out _how_ to identify the version and fixpack of the product?

I've already asked my DB2 sysprog, who tells me that the version is "DB2 Connect 10.5 Fixpack." I can't understand that naming; it looks wrong, there _should_ be a _number_ after the word "Fixpack". But when I go looking for that number, I wind up at
https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.com%2Fv3%2F__https%3A%2Fwww.ibm.com%2Fsupport%2Fpages%2Fdb2-jdbc-driver-versions-and-downloads__%3B!!Os7eWUw!8dibzMOvDLKFvY4HqcY6RKRknWLlZQrg2PmmvVti6Nq9nuavvF61r7iYFYXh9BgVdMxvjVE%24&data=02%7C01%7Cchoelscher%40humana.com%7C5f2391d59f3f40b305d708d7a5b3e7fb%7C56c62bbe85984b859e511ca753fa50f2%7C1%7C0%7C637160064438810473&sdata=YuFbJXraS14%2BUMkcDEnIMAtY0BIUhOU77mIuiYGE2eg%3D&reserved=0
which appears to be a DB2 _LUW_ reference, not a DB2 _connect_ reference.

What am I doing wrong, here?

-phil s.


Philip Sevetson
Computer Systems Manager
FISA-OPA
5 Manhattan West
New York, NY 10001
[login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e>
212-857-1688 w
917-991-7052 m
212-857-1659 f
[cid:[login to unmask email]

**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]> • W: www.rocketsoftware.com https://nam03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.rocketsoftware.com&data=02%7C01%7Cchoelscher%40humana.com%7C5f2391d59f3f40b305d708d7a5b3e7fb%7C56c62bbe85984b859e511ca753fa50f2%7C1%7C0%7C637160064438820465&sdata=3Hc5j4gf4IhqRW8nmMSm8WZ%2FzEZFVw1cyxxJAEWT3pM%3D&reserved=0

2020 IBM Champion.

Views are personal.

-----End Original Message-----

-----End Original Message-----

The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability, sex,
sexual orientation, gender identity, or religion. Humana Inc. and its subsidiaries do not
exclude people or treat them differently because of race, color, national origin, age,
disability, sex, sexual orientation, gender identity, or religion.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.

J&#248;rn Thyssen

RE: DB2 Connect Manuals / Reference
(in response to Mark Vickers)

Hi Mark,

As others have stated this is very likely incorrect. The only exception would be if you have Db2 Connect licensed as concurrent users. For this specific licensing model you need the Db2 Connect Server to make sure you do not exceed your entitlement.

 

For other licensing models (Unlimited Enterprise and Enterprise (Authorized users)) you can use the Db2 Connect Server or connect directly. With the unlimited enterprise edition you can install the license on the Db2 for z/OS side so you do not have to worry about installing licensing files on the client side.

The recommendation is generally to use direct connections: it eliminates latency and it eliminates a server you have to manage.

In Reply to Mark Vickers:

Correct me if I am wrong but our IBM rep told us that direct distributed connections were not allowed, we had to go through the gateway EE Server ?

From: Jørn Thyssen [mailto:[login to unmask email]
Sent: Thursday, January 30, 2020 11:58 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 Connect Manuals / Reference


Hi Phil,

Your link is correct. If you’re using a Db2 Connect Server (a.k.a. gateway) you should be able to find the version with the command db2level.

If you’re using direct connections you’ll likely see many different versions. You can find the versions in the SMF accounting records.

In Reply to Philip Sevetson:
I'm trying to establish _what_ DB2 Connect version is being used by my agency, and I'm not finding anything useful with Web searching. Looking for "DB2 Connect manual" keeps pushing me to "DB2 for Linux, Unix, and Windows." Can someone please point me to any manual, anywhere, which will allow me to figure out _how_ to identify the version and fixpack of the product?

I've already asked my DB2 sysprog, who tells me that the version is "DB2 Connect 10.5 Fixpack." I can't understand that naming; it looks wrong, there _should_ be a _number_ after the word "Fixpack". But when I go looking for that number, I wind up at
https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads https://urldefense.com/v3/__https:/www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads__;!!Os7eWUw!8dibzMOvDLKFvY4HqcY6RKRknWLlZQrg2PmmvVti6Nq9nuavvF61r7iYFYXh9BgVdMxvjVE$
which appears to be a DB2 _LUW_ reference, not a DB2 _connect_ reference.

What am I doing wrong, here?

-phil s.


Philip Sevetson
Computer Systems Manager
FISA-OPA
5 Manhattan West
New York, NY 10001
[login to unmask email]<mailto:[login to unmask email]><mailto:[login to unmask email]%3e>
212-857-1688 w
917-991-7052 m
212-857-1659 f
[cid:[login to unmask email]

**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]> • W: www.rocketsoftware.com http://www.rocketsoftware.com

2020 IBM Champion.

Views are personal.

-----End Original Message-----



 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

2020 IBM Champion.

Views are personal. 

Charles Brown

DB2 Connect Manuals / Reference
(in response to Jørn Thyssen)
Re: “... Db2 Connect Server to make sure you do not exceed your entitlement...”

With all due respect, the db2 connect server does not provide governance on entitlement. The MAXDBAT parameter in DDF limits concurrent distributed thread and not a db2 connect server, the distributed thread gateway. Interestingly, IBM leaves the “police-ing” of max concurrent threads with you.

To answer the question on if the Db2 LUW Product can act as a db2 Connect server. Yes - db2 LUW can act as a db2 connect server.

Hope this helps.
Charles


Sent from my iPhone

> On Jan 30, 2020, at 2:07 PM, Jørn Thyssen <[login to unmask email]> wrote:
>
> Db2 Connect Server to make sure you do not exceed your entitlement.

Greg Palgrave

RE: DB2 Connect Manuals / Reference
(in response to Mark Vickers)

 

On a Linux/Unix system you can also use the db2ls command on the server to get a detailed list.

(db2ls - List installed Db2 products and features command)

e.g.

db2ls -q -b /opt/ibm/db2/V10.5

Install Path : /opt/ibm/db2/V10.5
Feature Response File ID Level Fix Pack Feature Description
---------------------------------------------------------------------------------------------------------------------
BASE_CLIENT 10.5.0.9 9 Base client support
JAVA_SUPPORT 10.5.0.9 9 Java support
SQL_PROCEDURES 10.5.0.9 9 SQL procedures
BASE_DB2_ENGINE 10.5.0.9 9 Base server support
CONNECT_SUPPORT 10.5.0.9 9 Connect support
DB2_DATA_SOURCE_SUPPORT 10.5.0.9 9 DB2 data source support

 

Cheers

Greg


In Reply to Mark Vickers:

To answer the question if others need it.

Run the "DB2 Command Window - Administrator"
Type in "db2level"

J&#248;rn Thyssen

RE: DB2 Connect Manuals / Reference
(in response to Charles Brown)

Hi Charles,

The normal way of licensing Db2 Connect is the Unlimited Enterprise Edition or the Enterprise Edition with authorized users.

If you have licensed Db2 Connect Enterprise Edition with concurrent users IBM requires you to run a Db2 Connect server so you can monitor the number of concurrent users. Using the db2licm utility you enroll your concurrent users license and specify how many concurrent users you have acquired. I am not 100% sure the Db2 Connect server will actually restrict access when your exceed the entitlement.

In Reply to Charles Brown:

Re: “... Db2 Connect Server to make sure you do not exceed your entitlement...”

With all due respect, the db2 connect server does not provide governance on entitlement. The MAXDBAT parameter in DDF limits concurrent distributed thread and not a db2 connect server, the distributed thread gateway. Interestingly, IBM leaves the “police-ing” of max concurrent threads with you.

To answer the question on if the Db2 LUW Product can act as a db2 Connect server. Yes - db2 LUW can act as a db2 connect server.

Hope this helps.
Charles


Sent from my iPhone

> On Jan 30, 2020, at 2:07 PM, Jørn Thyssen <[login to unmask email]> wrote:
>
> Db2 Connect Server to make sure you do not exceed your entitlement.



 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

2020 IBM Champion.

Views are personal. 

J&#248;rn Thyssen

RE: DB2 Connect Manuals / Reference
(in response to Jørn Thyssen)

Here's the reference: https://www-03.ibm.com/software/sla/sladb.nsf/lilookup/906EC607290C10E7852584C0000A3317?OpenDocument

Under "Floating User Single Install"

2. If the Program is licensed under the Floating User Single Install metric:

a) Licensee may not use the Db2 Connect client component(s) to directly access Db2 for z/OS, Db2 Server for VSE & VM, or Db2 for System i data servers.

 



In Reply to Jørn Thyssen:

Hi Charles,

The normal way of licensing Db2 Connect is the Unlimited Enterprise Edition or the Enterprise Edition with authorized users.

If you have licensed Db2 Connect Enterprise Edition with concurrent users IBM requires you to run a Db2 Connect server so you can monitor the number of concurrent users. Using the db2licm utility you enroll your concurrent users license and specify how many concurrent users you have acquired. I am not 100% sure the Db2 Connect server will actually restrict access when your exceed the entitlement.

In Reply to Charles Brown:

Re: “... Db2 Connect Server to make sure you do not exceed your entitlement...”

With all due respect, the db2 connect server does not provide governance on entitlement. The MAXDBAT parameter in DDF limits concurrent distributed thread and not a db2 connect server, the distributed thread gateway. Interestingly, IBM leaves the “police-ing” of max concurrent threads with you.

To answer the question on if the Db2 LUW Product can act as a db2 Connect server. Yes - db2 LUW can act as a db2 connect server.

Hope this helps.
Charles


Sent from my iPhone

> On Jan 30, 2020, at 2:07 PM, Jørn Thyssen <[login to unmask email]> wrote:
>
> Db2 Connect Server to make sure you do not exceed your entitlement.


 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

2020 IBM Champion.

Views are personal. 



 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

2020 IBM Champion.

Views are personal. 

Charles Brown

DB2 Connect Manuals / Reference
(in response to Kenneth Lee)
Re: … direct distributed connections were not allowed



Hello Ken, Phil, and Joan



* I have a feeling that direct distributed connections were not allowed simply because of license issues. Mind you, each workstation running the db2 connect driver MUST be distributed from a licensed db2 Connect otherwise connectivity to db2/z will be denied .
* Your IBM Rep has advised you to go through your gateway server. Why? It’s very likely because your site was configured using DB2 Connect Server as a single point of connectivity to several clients accessing db2/z.
* You’ve expressed “db2level” did not work or not found. It didn’t work because chances are your workstation has just the CLI driver ( http://www.ibm.com/services/forms/preLogin.do?source=swg-idsoc97 IBM Data Server Driver for ODBC) installed. The smallest footprint of the IBM Data Server Client packages. It doesn’t come with libraries and utilities
* Personally, contrary to the “promoted direct connection method” I prefer using the gateway for connectivity to db2/z. Why? Because the gateway is easy to manage, easy to administer or upgrade, it works in concert with DDF ( Distributed Database Facility) ), more importantly, It off loads DDF – referring to DDF runs cooler. Also, It requires fewer distributed threads defined (DBATS )



Re: identify the version and fixpack of the product?

* Finally and most importantly to answer your question on product version. Logon to the gateway machine. At the DOS prompt enter db2level. The output describes the version and FP level of the Db2 Connect Server you’re running. Your client version is irrelevant – a no count



Hope this helps



Thx!

Charles



From: Lee, Kenneth <[login to unmask email]>
Sent: Thursday, January 30, 2020 1:29 PM
To: '[login to unmask email]' <[login to unmask email]>
Subject: [DB2-L] - RE: DB2 Connect Manuals / Reference



I am afraid that your IBM rep was misunderstood.

IBM has been promoting direct connection for years unless you have some 2 phase commit application, which is not common.

We got rid of the gateways a long time ago.



Ken



From: Vickers, Mark [mailto:[login to unmask email] <mailto:[login to unmask email]> ]
Sent: Thursday, January 30, 2020 1:40 PM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2 Connect Manuals / Reference



Correct me if I am wrong but our IBM rep told us that direct distributed connections were not allowed, we had to go through the gateway EE Server ?



From: Jørn Thyssen [mailto:[login to unmask email] <mailto:[login to unmask email]> ]
Sent: Thursday, January 30, 2020 11:58 AM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2 Connect Manuals / Reference



Hi Phil,

Your link is correct. If you’re using a Db2 Connect Server (a.k.a. gateway) you should be able to find the version with the command db2level.

If you’re using direct connections you’ll likely see many different versions. You can find the versions in the SMF accounting records.


In Reply to Philip Sevetson:

I'm trying to establish _what_ DB2 Connect version is being used by my agency, and I'm not finding anything useful with Web searching. Looking for "DB2 Connect manual" keeps pushing me to "DB2 for Linux, Unix, and Windows." Can someone please point me to any manual, anywhere, which will allow me to figure out _how_ to identify the version and fixpack of the product?

I've already asked my DB2 sysprog, who tells me that the version is "DB2 Connect 10.5 Fixpack." I can't understand that naming; it looks wrong, there _should_ be a _number_ after the word "Fixpack". But when I go looking for that number, I wind up at
https://www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads https://urldefense.com/v3/__https:/www.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads__;!!Os7eWUw!8dibzMOvDLKFvY4HqcY6RKRknWLlZQrg2PmmvVti6Nq9nuavvF61r7iYFYXh9BgVdMxvjVE$
which appears to be a DB2 _LUW_ reference, not a DB2 _connect_ reference.

What am I doing wrong, here?

-phil s.


Philip Sevetson
Computer Systems Manager
FISA-OPA
5 Manhattan West
New York, NY 10001
[login to unmask email] <mailto:[login to unmask email]> <mailto:[login to unmask email] <mailto:[login to unmask email]%3e> >
212-857-1688 w
917-991-7052 m
212-857-1659 f
[cid:[login to unmask email]

**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] <mailto:[login to unmask email]> • W: www.rocketsoftware.com http://www.rocketsoftware.com

2020 IBM Champion.

Views are personal.



-----End Original Message-----



-----End Original Message-----

This message is confidential and subject to terms at: https://www.jpmorgan.com/emaildisclaimer including on confidential, privileged or legal entity information, viruses and monitoring of electronic messages. If you are not the intended recipient, please delete this message and notify the sender immediately. Any unauthorized use is strictly prohibited.



-----End Original Message-----

Mark Vickers

DB2 Connect Manuals / Reference
(in response to Jørn Thyssen)
Thanks everyone for your input on this.
This is my fuzzy understanding so far:

If you have a license for Db2 Connect Enterprise Edition, you may not use direct connect if you have the Floating User metric as we do.

But if we don’t use Db2 Connect EE, we can connect directly for free ?

If that is true, besides the zparms adjustment of dbats and ddf thresholds, busier ddf etc. why then would anyone got to the expense and maintenance of the Db2 Connect EE Server ?

From: Jørn Thyssen [mailto:[login to unmask email]
Sent: Friday, January 31, 2020 3:09 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 Connect Manuals / Reference


Here's the reference: https://www-03.ibm.com/software/sla/sladb.nsf/lilookup/906EC607290C10E7852584C0000A3317?OpenDocument

Under "Floating User Single Install"

2. If the Program is licensed under the Floating User Single Install metric:

a) Licensee may not use the Db2 Connect client component(s) to directly access Db2 for z/OS, Db2 Server for VSE & VM, or Db2 for System i data servers.




In Reply to Jørn Thyssen:

Hi Charles,

The normal way of licensing Db2 Connect is the Unlimited Enterprise Edition or the Enterprise Edition with authorized users.

If you have licensed Db2 Connect Enterprise Edition with concurrent users IBM requires you to run a Db2 Connect server so you can monitor the number of concurrent users. Using the db2licm utility you enroll your concurrent users license and specify how many concurrent users you have acquired. I am not 100% sure the Db2 Connect server will actually restrict access when your exceed the entitlement.

In Reply to Charles Brown:
Re: “... Db2 Connect Server to make sure you do not exceed your entitlement...”

With all due respect, the db2 connect server does not provide governance on entitlement. The MAXDBAT parameter in DDF limits concurrent distributed thread and not a db2 connect server, the distributed thread gateway. Interestingly, IBM leaves the “police-ing” of max concurrent threads with you.

To answer the question on if the Db2 LUW Product can act as a db2 Connect server. Yes - db2 LUW can act as a db2 connect server.

Hope this helps.
Charles


Sent from my iPhone

> On Jan 30, 2020, at 2:07 PM, Jørn Thyssen wrote:
>
> Db2 Connect Server to make sure you do not exceed your entitlement.





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]> • W: www.rocketsoftware.com http://www.rocketsoftware.com

2020 IBM Champion.

Views are personal.





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]> • W: www.rocketsoftware.com http://www.rocketsoftware.com

2020 IBM Champion.

Views are personal.

-----End Original Message-----

J&#248;rn Thyssen

RE: DB2 Connect Manuals / Reference
(in response to Mark Vickers)

Hi Mark,

 

If you have a license for Db2 Connect Enterprise Edition, you may not use direct connect if you have the Floating User metric as we do.

Correct.

 

But if we don’t use Db2 Connect EE, we can connect directly for free ?

No, you would need to license Db2 Connect in a different way. The most common license is the unlimited enterprise where you don't have to count users (the licensing metric is total number of Db2 MIPS + number of production Db2 sysplexes or production standalone subsystems).

 

If that is true, besides the zparms adjustment of dbats and ddf thresholds, busier ddf etc. why then would anyone got to the expense and maintenance of the Db2 Connect EE Server ?

That is also my view. In addition to the expense and maintenance it also adds latency. However, if you search the list you'll find threads where it is argued to keep the gateway server for firewall reasons.


In Reply to Mark Vickers:

Thanks everyone for your input on this.
This is my fuzzy understanding so far:

If you have a license for Db2 Connect Enterprise Edition, you may not use direct connect if you have the Floating User metric as we do.

But if we don’t use Db2 Connect EE, we can connect directly for free ?

If that is true, besides the zparms adjustment of dbats and ddf thresholds, busier ddf etc. why then would anyone got to the expense and maintenance of the Db2 Connect EE Server ?

From: Jørn Thyssen [mailto:[login to unmask email]
Sent: Friday, January 31, 2020 3:09 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 Connect Manuals / Reference


Here's the reference: https://www-03.ibm.com/software/sla/sladb.nsf/lilookup/906EC607290C10E7852584C0000A3317?OpenDocument

Under "Floating User Single Install"

2. If the Program is licensed under the Floating User Single Install metric:

a) Licensee may not use the Db2 Connect client component(s) to directly access Db2 for z/OS, Db2 Server for VSE & VM, or Db2 for System i data servers.




In Reply to Jørn Thyssen:

Hi Charles,

The normal way of licensing Db2 Connect is the Unlimited Enterprise Edition or the Enterprise Edition with authorized users.

If you have licensed Db2 Connect Enterprise Edition with concurrent users IBM requires you to run a Db2 Connect server so you can monitor the number of concurrent users. Using the db2licm utility you enroll your concurrent users license and specify how many concurrent users you have acquired. I am not 100% sure the Db2 Connect server will actually restrict access when your exceed the entitlement.

In Reply to Charles Brown:
Re: “... Db2 Connect Server to make sure you do not exceed your entitlement...”

With all due respect, the db2 connect server does not provide governance on entitlement. The MAXDBAT parameter in DDF limits concurrent distributed thread and not a db2 connect server, the distributed thread gateway. Interestingly, IBM leaves the “police-ing” of max concurrent threads with you.

To answer the question on if the Db2 LUW Product can act as a db2 Connect server. Yes - db2 LUW can act as a db2 connect server.

Hope this helps.
Charles


Sent from my iPhone

> On Jan 30, 2020, at 2:07 PM, Jørn Thyssen wrote:
>
> Db2 Connect Server to make sure you do not exceed your entitlement.





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]> • W: www.rocketsoftware.com http://www.rocketsoftware.com

2020 IBM Champion.

Views are personal.





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]> • W: www.rocketsoftware.com http://www.rocketsoftware.com

2020 IBM Champion.

Views are personal.

-----End Original Message-----


 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

2020 IBM Champion.

Views are personal. 

Charles Brown

DB2 Connect Manuals / Reference
(in response to Mark Vickers)
Re: “… you may not use direct connect if you have the Floating User metric as we do…”

Not compute! What is “Floating user metric”



Re: “..But if we don’t use Db2 Connect EE, we can connect directly for free ?..”

* That’s true but there are several other products and methods out there with less sophistication and expense. To name a few, TOAD, QMF for Windows, RazorSQL. Mind you I said inexpensive methods



Re: “..why then would anyone got to the expense and maintenance of the Db2 Connect EE…”

Reason being:

* You may not find a competitive product out there to access data stored in db2/z. The law of supply and demand
* You’ll get 24 x 7 technical support in the event of systems down issues – Sev 1 problems
* You’ll get Patches, Fixpacks, Apars, problem investigations and resolutions



Hope this helps

Charles





From: Vickers, Mark <[login to unmask email]>
Sent: Monday, February 3, 2020 9:45 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 Connect Manuals / Reference



Thanks everyone for your input on this.

This is my fuzzy understanding so far:



If you have a license for Db2 Connect Enterprise Edition, you may not use direct connect if you have the Floating User metric as we do.



But if we don’t use Db2 Connect EE, we can connect directly for free ?



If that is true, besides the zparms adjustment of dbats and ddf thresholds, busier ddf etc. why then would anyone got to the expense and maintenance of the Db2 Connect EE Server ?



From: Jørn Thyssen [mailto:[login to unmask email]
Sent: Friday, January 31, 2020 3:09 AM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2 Connect Manuals / Reference



Here's the reference: https://www-03.ibm.com/software/sla/sladb.nsf/lilookup/906EC607290C10E7852584C0000A3317?OpenDocument

Under "Floating User Single Install"

2. If the Program is licensed under the Floating User Single Install metric:

a) Licensee may not use the Db2 Connect client component(s) to directly access Db2 for z/OS, Db2 Server for VSE & VM, or Db2 for System i data servers.





In Reply to Jørn Thyssen:

Hi Charles,

The normal way of licensing Db2 Connect is the Unlimited Enterprise Edition or the Enterprise Edition with authorized users.

If you have licensed Db2 Connect Enterprise Edition with concurrent users IBM requires you to run a Db2 Connect server so you can monitor the number of concurrent users. Using the db2licm utility you enroll your concurrent users license and specify how many concurrent users you have acquired. I am not 100% sure the Db2 Connect server will actually restrict access when your exceed the entitlement.

In Reply to Charles Brown:

Re: “... Db2 Connect Server to make sure you do not exceed your entitlement...”

With all due respect, the db2 connect server does not provide governance on entitlement. The MAXDBAT parameter in DDF limits concurrent distributed thread and not a db2 connect server, the distributed thread gateway. Interestingly, IBM leaves the “police-ing” of max concurrent threads with you.

To answer the question on if the Db2 LUW Product can act as a db2 Connect server. Yes - db2 LUW can act as a db2 connect server.

Hope this helps.
Charles


Sent from my iPhone

> On Jan 30, 2020, at 2:07 PM, Jørn Thyssen wrote:
>
> Db2 Connect Server to make sure you do not exceed your entitlement.





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] <mailto:[login to unmask email]> • W: www.rocketsoftware.com http://www.rocketsoftware.com

2020 IBM Champion.

Views are personal.





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] <mailto:[login to unmask email]> • W: www.rocketsoftware.com http://www.rocketsoftware.com

2020 IBM Champion.

Views are personal.



-----End Original Message-----



-----End Original Message-----

J&#248;rn Thyssen

RE: DB2 Connect Manuals / Reference
(in response to Charles Brown)

Db2 Connect can be licensed in a number of different ways:

1) Unlimited Enterprise Edition (licensing metrics is MIPS + number of production DSG/SSIDs)

2) Enterprise Edition - authorized users

3) Enterprise Edition - floating users

4) Server Edition - (licensing metric is the size of your application server(s))

All of these versions have various restrictions and requirements. For example, if you license the floating users (concurrent users) you MUST use the Db2 Connect Server (gateway). For all other you can access DB2 for z/OS directly.

 

Also, unless Toad ships with their own Db2 jdbc driver you will still need one of the licenses above to be able to connect to Db2 for z/OS using the IBM Db2 jdbc driver. 

QMF does ship with a restricted license for the Db2 jdbc drivers which you can use for QMF only.

In Reply to Charles Brown:

Re: “… you may not use direct connect if you have the Floating User metric as we do…”

Not compute! What is “Floating user metric”



Re: “..But if we don’t use Db2 Connect EE, we can connect directly for free ?..”

* That’s true but there are several other products and methods out there with less sophistication and expense. To name a few, TOAD, QMF for Windows, RazorSQL. Mind you I said inexpensive methods



Re: “..why then would anyone got to the expense and maintenance of the Db2 Connect EE…”

Reason being:

* You may not find a competitive product out there to access data stored in db2/z. The law of supply and demand
* You’ll get 24 x 7 technical support in the event of systems down issues – Sev 1 problems
* You’ll get Patches, Fixpacks, Apars, problem investigations and resolutions



Hope this helps

Charles





From: Vickers, Mark <[login to unmask email]>
Sent: Monday, February 3, 2020 9:45 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 Connect Manuals / Reference



Thanks everyone for your input on this.

This is my fuzzy understanding so far:



If you have a license for Db2 Connect Enterprise Edition, you may not use direct connect if you have the Floating User metric as we do.



But if we don’t use Db2 Connect EE, we can connect directly for free ?



If that is true, besides the zparms adjustment of dbats and ddf thresholds, busier ddf etc. why then would anyone got to the expense and maintenance of the Db2 Connect EE Server ?



From: Jørn Thyssen [mailto:[login to unmask email]
Sent: Friday, January 31, 2020 3:09 AM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2 Connect Manuals / Reference



Here's the reference: https://www-03.ibm.com/software/sla/sladb.nsf/lilookup/906EC607290C10E7852584C0000A3317?OpenDocument

Under "Floating User Single Install"

2. If the Program is licensed under the Floating User Single Install metric:

a) Licensee may not use the Db2 Connect client component(s) to directly access Db2 for z/OS, Db2 Server for VSE & VM, or Db2 for System i data servers.





In Reply to Jørn Thyssen:

Hi Charles,

The normal way of licensing Db2 Connect is the Unlimited Enterprise Edition or the Enterprise Edition with authorized users.

If you have licensed Db2 Connect Enterprise Edition with concurrent users IBM requires you to run a Db2 Connect server so you can monitor the number of concurrent users. Using the db2licm utility you enroll your concurrent users license and specify how many concurrent users you have acquired. I am not 100% sure the Db2 Connect server will actually restrict access when your exceed the entitlement.

In Reply to Charles Brown:

Re: “... Db2 Connect Server to make sure you do not exceed your entitlement...”

With all due respect, the db2 connect server does not provide governance on entitlement. The MAXDBAT parameter in DDF limits concurrent distributed thread and not a db2 connect server, the distributed thread gateway. Interestingly, IBM leaves the “police-ing” of max concurrent threads with you.

To answer the question on if the Db2 LUW Product can act as a db2 Connect server. Yes - db2 LUW can act as a db2 connect server.

Hope this helps.
Charles


Sent from my iPhone

> On Jan 30, 2020, at 2:07 PM, Jørn Thyssen wrote:
>
> Db2 Connect Server to make sure you do not exceed your entitlement.





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] <mailto:[login to unmask email]> • W: www.rocketsoftware.com http://www.rocketsoftware.com

2020 IBM Champion.

Views are personal.





Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] <mailto:[login to unmask email]> • W: www.rocketsoftware.com http://www.rocketsoftware.com

2020 IBM Champion.

Views are personal.



-----End Original Message-----



-----End Original Message-----


 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

2020 IBM Champion.

Views are personal. 

Edited By:
Jørn Thyssen[Organization Members] @ Feb 03, 2020 - 05:40 PM (Europe/Copenhagen)

J&#248;rn Thyssen

RE: DB2 Connect Manuals / Reference
(in response to Jørn Thyssen)

In Reply to Jørn Thyssen:

Hi Charles,

The normal way of licensing Db2 Connect is the Unlimited Enterprise Edition or the Enterprise Edition with authorized users.

If you have licensed Db2 Connect Enterprise Edition with concurrent users IBM requires you to run a Db2 Connect server so you can monitor the number of concurrent users. Using the db2licm utility you enroll your concurrent users license and specify how many concurrent users you have acquired. I am not 100% sure the Db2 Connect server will actually restrict access when your exceed the entitlement.

FWIW, Db2 Connect development confirmed that if you enroll a "Floating User Install" license (a.k.a. concurrent users) there is code in place to enforce the maximum number of concurrent connections allowed through the Db2 Connect Server.
 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

2020 IBM Champion.

Views are personal.