Capture Users using DB2 Connect Gateway

Dave Nance

Capture Users using DB2 Connect Gateway


Hi all any help appreciated.
We are switching over our Gateway servers to new machines. We still have users connecting via the old servers. We can find who is currently using them by listing applications. Any ideas on how to capture all who have used the server during a specific time period? The old servers that we are putting out of service are running DB2 V9.7FP2. Thanks.
Dave Nance 

Daniel Luksetich

Capture Users using DB2 Connect Gateway
(in response to Dave Nance)


you could increase the diagnostic level.

another option would be a checking audit policy.

Dan

On 11.02.2017 09:15, Dave Nance wrote:

> Hi all any help appreciated.
>
> We are switching over our Gateway servers to new machines. We still have users connecting via the old servers. We can find who is currently using them by listing applications. Any ideas on how to capture all who have used the server during a specific time period? The old servers that we are putting out of service are running DB2 V9.7FP2. Thanks.
>
> Dave Nance
>
> -----End Original Message-----


Links:
------
[1] http://www.idug.org/p/fo/st/?post=183607&anc=p183607#p183607
[2] http://www.idug.org/p/fo/si/?topic=19
[3] http://www.idug.org/p/us/to/
[4] http://www.ESAIGroup.com/idug
[5] http://www.idug.org/p/cm/ld/fid=2

Daniel Luksetich

Capture Users using DB2 Connect Gateway
(in response to Daniel Luksetich)


oops, audit policy is NOT an option for a Gateway.

On 11.02.2017 09:25, Daniel Luksetich wrote:

> you could increase the diagnostic level.
>
> another option would be a checking audit policy.
>
> Dan
>
> On 11.02.2017 09:15, Dave Nance wrote:
>
>> Hi all any help appreciated.
>>
>> We are switching over our Gateway servers to new machines. We still have users connecting via the old servers. We can find who is currently using them by listing applications. Any ideas on how to capture all who have used the server during a specific time period? The old servers that we are putting out of service are running DB2 V9.7FP2. Thanks.
>>
>> Dave Nance
>>
>> -----End Original Message-----
>
> -----End Original Message-----


Links:
------
[1] http://www.idug.org/p/fo/st/?post=183608&anc=p183608#p183608
[2] http://www.idug.org/p/fo/si/?topic=19
[3] http://www.idug.org/p/us/to/
[4] http://www.ESAIGroup.com/idug
[5] http://www.idug.org/p/cm/ld/fid=2

Kenneth Lee

Capture Users using DB2 Connect Gateway
(in response to Daniel Luksetich)
Without IBM’s Configuration Manager tool, it’s not that simple for Db2 gateway.
We use SMF/MXG report to go thru Requesting Location Name/IP Address, Corr_ID(JDBC or ODBC clients) and Auth_ID, etc.

Kenneth Lee

From: Daniel Luksetich [mailto:[login to unmask email]
Sent: Thursday, November 02, 2017 12:27 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Capture Users using DB2 Connect Gateway


oops, audit policy is NOT an option for a Gateway.




On 11.02.2017 09:25, Daniel Luksetich wrote:

you could increase the diagnostic level.

another option would be a checking audit policy.

Dan




On 11.02.2017 09:15, Dave Nance wrote:




Hi all any help appreciated.

We are switching over our Gateway servers to new machines. We still have users connecting via the old servers. We can find who is currently using them by listing applications. Any ideas on how to capture all who have used the server during a specific time period? The old servers that we are putting out of service are running DB2 V9.7FP2. Thanks.

Dave Nance




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

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

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

This message is confidential and subject to terms at: http://www.jpmorgan.com/emaildisclaimer including on confidentiality, legal privilege, 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.

Bill Gallagher

Capture Users using DB2 Connect Gateway
(in response to Kenneth Lee)
I did the same thing at my previous job.

An MXG job that read SMF data, filtering on plan name “DISTSERV” to get all distributed connections.

Then, you can filter further on other fields as appropriate.

Bill Gallagher
DB2 Database Administrator
State of Connecticut
Department of Children and Families
Office: 860-263-1389
[login to unmask email]<mailto:[login to unmask email]>


From: Lee, Kenneth [mailto:[login to unmask email]
Sent: Thursday, November 02, 2017 2:56 PM
To: '[login to unmask email]' <[login to unmask email]>
Subject: [DB2-L] - RE: Capture Users using DB2 Connect Gateway

Without IBM’s Configuration Manager tool, it’s not that simple for Db2 gateway.
We use SMF/MXG report to go thru Requesting Location Name/IP Address, Corr_ID(JDBC or ODBC clients) and Auth_ID, etc.

Kenneth Lee

From: Daniel Luksetich [mailto:[login to unmask email]<mailto:[login to unmask email]>]
Sent: Thursday, November 02, 2017 12:27 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Capture Users using DB2 Connect Gateway


oops, audit policy is NOT an option for a Gateway.




On 11.02.2017 09:25, Daniel Luksetich wrote:

you could increase the diagnostic level.

another option would be a checking audit policy.

Dan




On 11.02.2017 09:15, Dave Nance wrote:




Hi all any help appreciated.

We are switching over our Gateway servers to new machines. We still have users connecting via the old servers. We can find who is currently using them by listing applications. Any ideas on how to capture all who have used the server during a specific time period? The old servers that we are putting out of service are running DB2 V9.7FP2. Thanks.

Dave Nance




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

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

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

This message is confidential and subject to terms at: http://www.jpmorgan.com/emaildisclaimer http://www.jpmorgan.com/emaildisclaimer including on confidentiality, legal privilege, 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-----

J&#248;rn Thyssen

RE: Capture Users using DB2 Connect Gateway
(in response to Dave Nance)

Hi Dave,

Are you aware that you can let users connect directly to Db2 for z/OS and avoid performance(!) and operational overhead of Db2 Connect servers? IBM has recommended direct connections for many years. 

Best regards,

Jørn Thyssen

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

Views are personal. 

Bill Gallagher

Capture Users using DB2 Connect Gateway
(in response to Jørn Thyssen)
There’s still an advantage to using a DB2 Connect gateway. An example would be if you want to “shut off” a block of users from accessing DB2 for some specific period of time, perhaps during an application code depoyment.

Bill Gallagher
DB2 Database Administrator
State of Connecticut
Department of Children and Families
Office: 860-263-1389
[login to unmask email]<mailto:[login to unmask email]>


From: Jørn Thyssen [mailto:[login to unmask email]
Sent: Friday, November 03, 2017 1:06 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Capture Users using DB2 Connect Gateway


Hi Dave,

Are you aware that you can let users connect directly to Db2 for z/OS and avoid performance(!) and operational overhead of Db2 Connect servers? IBM has recommended direct connections for many years.

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

Views are personal.

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

J&#248;rn Thyssen

RE: Capture Users using DB2 Connect Gateway
(in response to Bill Gallagher)

Hi Bill,

You can block/limit users/applications with Db2 profiles.

Best regards,

Jørn Thyssen

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

Views are personal. 

Charles Brown

Capture Users using DB2 Connect Gateway
(in response to Jørn Thyssen)


Sent from my iPad

> On Nov 3, 2017, at 2:34 PM, Jørn Thyssen <[login to unmask email]> wrote:
>
> Hi Bill,
>
> You can block/limit users/applications with Db2 profiles.
>
> Best regards,
>
> Jørn Thyssen
>
> Rocket Software
> 77 Fourth Avenue • Waltham, MA • 02451 • USA
> E: [login to unmask email] • W: www.rocketsoftware.com
>
> Views are personal.
>
>
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
>
> This email has been sent to: [login to unmask email]
> Setup a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU
> ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See
> http://www.ESAIGroup.com/idug
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>

Charles Brown

Capture Users using DB2 Connect Gateway
(in response to Charles Brown)
Hello Dave,
I like Bill's recommendation very much. Meaning-- just do it the old fashioned way. Referring to -- you can shut down db2 connect running on the middleware, gateway for a while. Ops! The help desk, call center or operators will find you in a heartbeat with names of impacted end users.
Like most of us, I'd encourage you keep your gateway server. It helps during upgrades and of course provides you with a single point of failure. Thanks to the SCCM folks -- applying fixpacks, upgrades couldn't be any smoother. I have used db2 connect for more than 15 years -- yet I'm not aware of any performance or operational overhead when configured appropriately. I'm basing my assertion on the fact that depending on your workload demand or traffic, the product can be configured to do either connection concentrator or the default connection pooling. Once configured optimally watch your DDF runs cooler and inexpensively. However, I had a little problem (an understatement) when I migrated mine from NT to Zlinux. But shortly after, I migrated to Linux servers. Since then, you've guessed it - little or no problem -- meaning work like a charm.
You can tell -- I'm such a big fan of the product.

Charles,
NZ, InfoSphere(IIS) dba

Sent from my iPad

> On Nov 4, 2017, at 2:17 AM, Charles Brown <[login to unmask email]> wrote:
>
>
>
> Sent from my iPad
>
>> On Nov 3, 2017, at 2:34 PM, Jørn Thyssen <[login to unmask email]> wrote:
>>
>> Hi Bill,
>>
>> You can block/limit users/applications with Db2 profiles.
>>
>> Best regards,
>>
>> Jørn Thyssen
>>
>> Rocket Software
>> 77 Fourth Avenue • Waltham, MA • 02451 • USA
>> E: [login to unmask email] • W: www.rocketsoftware.com
>>
>> Views are personal.
>>
>>
>> -----End Original Message-----
>
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
>
> This email has been sent to: [login to unmask email]
> Setup a data refresh task in less time than it takes to make a cup of coffee + save up to 90% in CPU
> ESAi's BCV5 & XDM fast data refresh & Test Data Mgmt products will make you a hero to users. See
> http://www.ESAIGroup.com/idug
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>