Central PA Regional DB2 User Group - June 7, 2017

Odessa Fennen

Central PA Regional DB2 User Group - June 7, 2017

Central PA Regional DB2 User Group
Date: Wednesday, June 7, 2017
Place: Giant Super Food Store Community Room, 3301 Trindle Road, Camp Hill, PA 17011
Cost: FREE
Reservations: Email: Odessa Fennen - [login to unmask email]<mailto:[login to unmask email]>

Agenda for June 7, 2017
8:30-9:00 Breakfast & Announcements
Sponsored By IBM

9:00-10:15 "Let Me Make This Clear (Things That Plenty of DB2 for z/OS People Get Wrong)"
Presenter: Robert Catterall, IBM
Some aspects of DB2 for z/OS technology are plain as day; others, less so. Questions I get from DB2 users worldwide have highlighted for me things that a lot of folks - even very experienced DB2 people - get wrong. In this session I'll try to bring clarity to oft-misunderstood areas of DB2 for z/OS technology.
10:15-10:30 Break

10:30-11:45 "Going Native: Leveraging DB2 for z/OS Native SQL Procedures and Other SQL PL Routines"
Presenter: Robert Catterall, IBM
Native SQL procedures were introduced with DB2 9 for z/OS, and SQL Procedure Language (SQL PL) was extended to user-defined functions (UDFs) with DB2 10. DB2 11 delivered SQL PL support for array parameters, and introduced autonomous native SQL procedures DB2 12 provided additional SQL PL enhancements, including the ability to use SQL PL in the definition of database triggers. This session will provide information that attendees can use in the development, management, and monitoring of native SQL procedures, "native" SQL UDFs, and DB2 12 advanced triggers. It will also cover exploitation of SQL PL routines to enhance DB2 for z/OS performance, scalability, and security -- particularly for client- server applications.

11:45 -1:00 Lunch - Sponsored By: IBM

1:00 - 2:15 Presenter: Randy Ebersole, IBM

* "DB2 System Profiles- How Can They Help?"
More and more complexity of distributed access to DB2 for z/OS requires a more granular ability to manage resources. This technical session will show how DB2 system profiles can be used to monitor threads for remote TCP/IP access to DB2(r) servers. Additionally, details will be provided on how to use system profiles to manage resources by particular clients, applications, and users, and prioritize resources accordingly.

* "DB2 12 Continuous Delivery - Start Planning"
DB2 12 introduces continuous delivery of new capabilities and enhancements in a single service stream as soon as they are ready. The result is that you can benefit from new capabilities and enhancements without waiting for an entire new release. This presentation will discuss how to begin planning for continuous delivery by considering how you will be able to control the timing of the activation and adoption of new features, with the option to continue to apply corrective and preventative service without adopting new feature function.
2:15 - 2:30 Break

2:30 - 3:45 "Protecting Your Crown Jewels"
Presenter: Howie Hirsch, IBM
This presentation will give an overall view of how to protect your most critical assets on z/OS. We will discuss overall strategy including DB2, RACF, Guardium, zSecure, encryption, database and file activity monitoring and how they feed your SIEM for actionable items in real-time. We will learn about a statement of direction regarding z/OS encryption. We will drill down into ways to protest your "crown jewels" from being accessed by inappropriate parties, and will alert you when they it has been accessed by authorized credentials.

3:45 - 4:00 Closing





________________________________

This e-mail and any attachments to it are confidential and are intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this e-mail without the author's prior permission. The views expressed in this e-mail message do not necessarily represent the views of Highmark, its diversified business, or affiliates.

Odessa Fennen

Central PA Regional DB2 User Group - June 7, 2017
(in response to Odessa Fennen)
Still plenty of open seats!


Central PA Regional DB2 User Group
Date: Wednesday, June 7, 2017
Place: Giant Super Food Store Community Room, 3301 Trindle Road, Camp Hill, PA 17011
Cost: FREE
Reservations: Email: Odessa Fennen - [login to unmask email]<mailto:[login to unmask email]>

Agenda for June 7, 2017
8:30-9:00 Breakfast & Announcements
Sponsored By IBM

9:00-10:15 "Let Me Make This Clear (Things That Plenty of DB2 for z/OS People Get Wrong)"
Presenter: Robert Catterall, IBM
Some aspects of DB2 for z/OS technology are plain as day; others, less so. Questions I get from DB2 users worldwide have highlighted for me things that a lot of folks - even very experienced DB2 people - get wrong. In this session I'll try to bring clarity to oft-misunderstood areas of DB2 for z/OS technology.
10:15-10:30 Break

10:30-11:45 "Going Native: Leveraging DB2 for z/OS Native SQL Procedures and Other SQL PL Routines"
Presenter: Robert Catterall, IBM
Native SQL procedures were introduced with DB2 9 for z/OS, and SQL Procedure Language (SQL PL) was extended to user-defined functions (UDFs) with DB2 10. DB2 11 delivered SQL PL support for array parameters, and introduced autonomous native SQL procedures DB2 12 provided additional SQL PL enhancements, including the ability to use SQL PL in the definition of database triggers. This session will provide information that attendees can use in the development, management, and monitoring of native SQL procedures, "native" SQL UDFs, and DB2 12 advanced triggers. It will also cover exploitation of SQL PL routines to enhance DB2 for z/OS performance, scalability, and security -- particularly for client- server applications.

11:45 -1:00 Lunch - Sponsored By: IBM

1:00 - 2:15 Presenter: Randy Ebersole, IBM

* "DB2 System Profiles- How Can They Help?"
More and more complexity of distributed access to DB2 for z/OS requires a more granular ability to manage resources. This technical session will show how DB2 system profiles can be used to monitor threads for remote TCP/IP access to DB2(r) servers. Additionally, details will be provided on how to use system profiles to manage resources by particular clients, applications, and users, and prioritize resources accordingly.

* "DB2 12 Continuous Delivery - Start Planning"
DB2 12 introduces continuous delivery of new capabilities and enhancements in a single service stream as soon as they are ready. The result is that you can benefit from new capabilities and enhancements without waiting for an entire new release. This presentation will discuss how to begin planning for continuous delivery by considering how you will be able to control the timing of the activation and adoption of new features, with the option to continue to apply corrective and preventative service without adopting new feature function.
2:15 - 2:30 Break

2:30 - 3:45 "Protecting Your Crown Jewels"
Presenter: Howie Hirsch, IBM
This presentation will give an overall view of how to protect your most critical assets on z/OS. We will discuss overall strategy including DB2, RACF, Guardium, zSecure, encryption, database and file activity monitoring and how they feed your SIEM for actionable items in real-time. We will learn about a statement of direction regarding z/OS encryption. We will drill down into ways to protest your "crown jewels" from being accessed by inappropriate parties, and will alert you when they it has been accessed by authorized credentials.

3:45 - 4:00 Closing





________________________________

This e-mail and any attachments to it are confidential and are intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this e-mail without the author's prior permission. The views expressed in this e-mail message do not necessarily represent the views of Highmark, its diversified business, or affiliates.

Stan Goodwin

Central PA Regional DB2 User Group - June 7, 2017
(in response to Odessa Fennen)
anybody from PHEAA or PennDot
Thank You & have a good day...

Stan Goodwin,
Technical Sales Specialist
DB2 Advisor for System Z
IBM Mid-Atlanitc Region
Phone: 720-342-9832
Email: [login to unmask email]

'The mass of mankind, who think more of present evil, however trifling,
then of the past grievances, however oppressive, begin to connect present
evils with present rule, and having lost, in some degree, the memory of
their ancient wrongs, desire to recall a dynasty which, thus viewed, bears
a not an unfavorable comparison with their present state'.... Mary
Frances Cusak, 'History of Ireland'.





From: "Fennen, Odessa M" <[login to unmask email]>
To: "[login to unmask email]" <[login to unmask email]>
Date: 05/25/2017 04:11 PM
Subject: [DB2UGCENPA] - RE: Central PA Regional DB2 User Group -
June 7, 2017



Still plenty of open seats!


Central PA Regional DB2 User Group
Date: Wednesday, June 7, 2017
Place: Giant Super Food Store Community Room, 3301 Trindle Road, Camp
Hill, PA 17011
Cost: FREE
Reservations: Email: Odessa Fennen – [login to unmask email]

Agenda for June 7, 2017
8:30-9:00 Breakfast & Announcements
Sponsored By IBM

9:00-10:15 "Let Me Make This Clear (Things That Plenty of DB2 for z/OS
People Get Wrong)"
Presenter: Robert Catterall, IBM
Some aspects of DB2 for z/OS technology are plain as day; others, less so.
Questions I get from DB2 users worldwide have highlighted for me things
that a lot of folks - even very experienced DB2 people - get wrong. In
this session I'll try to bring clarity to oft-misunderstood areas of DB2
for z/OS technology.
10:15-10:30 Break

10:30-11:45 "Going Native: Leveraging DB2 for z/OS Native SQL Procedures
and Other SQL PL Routines"
Presenter: Robert Catterall, IBM
Native SQL procedures were introduced with DB2 9 for z/OS, and SQL
Procedure Language (SQL PL) was extended to user-defined functions (UDFs)
with DB2 10. DB2 11 delivered SQL PL support for array parameters, and
introduced autonomous native SQL procedures DB2 12 provided additional SQL
PL enhancements, including the ability to use SQL PL in the definition of
database triggers. This session will provide information that attendees
can use in the development, management, and monitoring of native SQL
procedures, "native" SQL UDFs, and DB2 12 advanced triggers. It will also
cover exploitation of SQL PL routines to enhance DB2 for z/OS performance,
scalability, and security -– particularly for client- server applications.

11:45 -1:00 Lunch - Sponsored By: IBM

1:00 – 2:15 Presenter: Randy Ebersole, IBM
· “DB2 System Profiles- How Can They Help?”
More and more complexity of distributed access to DB2 for z/OS requires a
more granular ability to manage resources. This technical session will
show how DB2 system profiles can be used to monitor threads for remote
TCP/IP access to DB2® servers. Additionally, details will be provided on
how to use system profiles to manage resources by particular clients,
applications, and users, and prioritize resources accordingly.
· “DB2 12 Continuous Delivery – Start Planning”
DB2 12 introduces continuous delivery of new capabilities and enhancements
in a single service stream as soon as they are ready. The result is that
you can benefit from new capabilities and enhancements without waiting for
an entire new release. This presentation will discuss how to begin
planning for continuous delivery by considering how you will be able to
control the timing of the activation and adoption of new features, with
the option to continue to apply corrective and preventative service
without adopting new feature function.
2:15 – 2:30 Break

2:30 – 3:45 "Protecting Your Crown Jewels"
Presenter: Howie Hirsch, IBM
This presentation will give an overall view of how to protect your most
critical assets on z/OS. We will discuss overall strategy including DB2,
RACF, Guardium, zSecure, encryption, database and file activity monitoring
and how they feed your SIEM for actionable items in real-time. We will
learn about a statement of direction regarding z/OS encryption. We will
drill down into ways to protest your "crown jewels" from being accessed by
inappropriate parties, and will alert you when they it has been accessed
by authorized credentials.

3:45 – 4:00 Closing






This e-mail and any attachments to it are confidential and are intended
solely for use of the individual or entity to whom they are addressed. If
you have received this e-mail in error, please notify the sender
immediately and then delete it. If you are not the intended recipient, you
must not keep, use, disclose, copy or distribute this e-mail without the
author's prior permission. The views expressed in this e-mail message do
not necessarily represent the views of Highmark, its diversified business,
or affiliates.


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]
Learn how ESAi's fast data refresh & Test Data Management products can
save up to 90% in CPU, I/O
and manual efforts compared to typical solutions. Be a hero to your users
with BCV5 & XDM. 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




Attachments

  • blankfilename.txt (17.8k)

Odessa Fennen

Central PA Regional DB2 User Group - June 7, 2017
(in response to Odessa Fennen)

Still plenty of open seats!


Central PA Regional DB2 User Group
Date: Wednesday, June 7, 2017
Place: Giant Super Food Store Community Room, 3301 Trindle Road, Camp Hill, PA 17011
Cost: FREE
Reservations: Email: Odessa Fennen - [login to unmask email]<mailto:[login to unmask email]>

Agenda for June 7, 2017
8:30-9:00 Breakfast & Announcements
Sponsored By IBM

9:00-10:15 "Let Me Make This Clear (Things That Plenty of DB2 for z/OS People Get Wrong)"
Presenter: Robert Catterall, IBM
Some aspects of DB2 for z/OS technology are plain as day; others, less so. Questions I get from DB2 users worldwide have highlighted for me things that a lot of folks - even very experienced DB2 people - get wrong. In this session I'll try to bring clarity to oft-misunderstood areas of DB2 for z/OS technology.
10:15-10:30 Break

10:30-11:45 "Going Native: Leveraging DB2 for z/OS Native SQL Procedures and Other SQL PL Routines"
Presenter: Robert Catterall, IBM
Native SQL procedures were introduced with DB2 9 for z/OS, and SQL Procedure Language (SQL PL) was extended to user-defined functions (UDFs) with DB2 10. DB2 11 delivered SQL PL support for array parameters, and introduced autonomous native SQL procedures DB2 12 provided additional SQL PL enhancements, including the ability to use SQL PL in the definition of database triggers. This session will provide information that attendees can use in the development, management, and monitoring of native SQL procedures, "native" SQL UDFs, and DB2 12 advanced triggers. It will also cover exploitation of SQL PL routines to enhance DB2 for z/OS performance, scalability, and security -- particularly for client- server applications.

11:45 -1:00 Lunch - Sponsored By: IBM

1:00 - 2:15 Presenter: Randy Ebersole, IBM

* "DB2 System Profiles- How Can They Help?"
More and more complexity of distributed access to DB2 for z/OS requires a more granular ability to manage resources. This technical session will show how DB2 system profiles can be used to monitor threads for remote TCP/IP access to DB2(r) servers. Additionally, details will be provided on how to use system profiles to manage resources by particular clients, applications, and users, and prioritize resources accordingly.

* "DB2 12 Continuous Delivery - Start Planning"
DB2 12 introduces continuous delivery of new capabilities and enhancements in a single service stream as soon as they are ready. The result is that you can benefit from new capabilities and enhancements without waiting for an entire new release. This presentation will discuss how to begin planning for continuous delivery by considering how you will be able to control the timing of the activation and adoption of new features, with the option to continue to apply corrective and preventative service without adopting new feature function.
2:15 - 2:30 Break

2:30 - 3:45 "Protecting Your Crown Jewels"
Presenter: Howie Hirsch, IBM
This presentation will give an overall view of how to protect your most critical assets on z/OS. We will discuss overall strategy including DB2, RACF, Guardium, zSecure, encryption, database and file activity monitoring and how they feed your SIEM for actionable items in real-time. We will learn about a statement of direction regarding z/OS encryption. We will drill down into ways to protest your "crown jewels" from being accessed by inappropriate parties, and will alert you when they it has been accessed by authorized credentials.

3:45 - 4:00 Closing





________________________________

This e-mail and any attachments to it are confidential and are intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this e-mail without the author's prior permission. The views expressed in this e-mail message do not necessarily represent the views of Highmark, its diversified business, or affiliates.

Gerald Zimmer

Central PA Regional DB2 User Group - June 7, 2017
(in response to Odessa Fennen)
Odessa,

I will be there for the training.

Thanks
Gerry

From: Fennen, Odessa M [mailto:[login to unmask email]
Sent: Wednesday, May 31, 2017 10:38 AM
To: '[login to unmask email]'
Subject: [DB2UGCENPA] - Central PA Regional DB2 User Group - June 7, 2017


Still plenty of open seats!


Central PA Regional DB2 User Group
Date: Wednesday, June 7, 2017
Place: Giant Super Food Store Community Room, 3301 Trindle Road, Camp Hill, PA 17011
Cost: FREE
Reservations: Email: Odessa Fennen - [login to unmask email]<mailto:[login to unmask email]>

Agenda for June 7, 2017
8:30-9:00 Breakfast & Announcements
Sponsored By IBM

9:00-10:15 "Let Me Make This Clear (Things That Plenty of DB2 for z/OS People Get Wrong)"
Presenter: Robert Catterall, IBM
Some aspects of DB2 for z/OS technology are plain as day; others, less so. Questions I get from DB2 users worldwide have highlighted for me things that a lot of folks - even very experienced DB2 people - get wrong. In this session I'll try to bring clarity to oft-misunderstood areas of DB2 for z/OS technology.
10:15-10:30 Break

10:30-11:45 "Going Native: Leveraging DB2 for z/OS Native SQL Procedures and Other SQL PL Routines"
Presenter: Robert Catterall, IBM
Native SQL procedures were introduced with DB2 9 for z/OS, and SQL Procedure Language (SQL PL) was extended to user-defined functions (UDFs) with DB2 10. DB2 11 delivered SQL PL support for array parameters, and introduced autonomous native SQL procedures DB2 12 provided additional SQL PL enhancements, including the ability to use SQL PL in the definition of database triggers. This session will provide information that attendees can use in the development, management, and monitoring of native SQL procedures, "native" SQL UDFs, and DB2 12 advanced triggers. It will also cover exploitation of SQL PL routines to enhance DB2 for z/OS performance, scalability, and security -- particularly for client- server applications.

11:45 -1:00 Lunch - Sponsored By: IBM

1:00 - 2:15 Presenter: Randy Ebersole, IBM

* "DB2 System Profiles- How Can They Help?"
More and more complexity of distributed access to DB2 for z/OS requires a more granular ability to manage resources. This technical session will show how DB2 system profiles can be used to monitor threads for remote TCP/IP access to DB2(r) servers. Additionally, details will be provided on how to use system profiles to manage resources by particular clients, applications, and users, and prioritize resources accordingly.

* "DB2 12 Continuous Delivery - Start Planning"
DB2 12 introduces continuous delivery of new capabilities and enhancements in a single service stream as soon as they are ready. The result is that you can benefit from new capabilities and enhancements without waiting for an entire new release. This presentation will discuss how to begin planning for continuous delivery by considering how you will be able to control the timing of the activation and adoption of new features, with the option to continue to apply corrective and preventative service without adopting new feature function.
2:15 - 2:30 Break

2:30 - 3:45 "Protecting Your Crown Jewels"
Presenter: Howie Hirsch, IBM
This presentation will give an overall view of how to protect your most critical assets on z/OS. We will discuss overall strategy including DB2, RACF, Guardium, zSecure, encryption, database and file activity monitoring and how they feed your SIEM for actionable items in real-time. We will learn about a statement of direction regarding z/OS encryption. We will drill down into ways to protest your "crown jewels" from being accessed by inappropriate parties, and will alert you when they it has been accessed by authorized credentials.

3:45 - 4:00 Closing





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

Stan Goodwin

Central PA Regional DB2 User Group - June 7, 2017
(in response to Odessa Fennen)
Odessa, are we at a count where cancellation should be considered?
Thank You & have a good day...

Stan Goodwin,
Technical Sales Specialist
DB2 Advisor for System Z
IBM Mid-Atlanitc Region
Phone: 720-342-9832
Email: [login to unmask email]

'The mass of mankind, who think more of present evil, however trifling,
then of the past grievances, however oppressive, begin to connect present
evils with present rule, and having lost, in some degree, the memory of
their ancient wrongs, desire to recall a dynasty which, thus viewed, bears
a not an unfavorable comparison with their present state'.... Mary
Frances Cusak, 'History of Ireland'.



Attachments

  • blankfilename.txt (17.8k)

Stan Goodwin

Central PA Regional DB2 User Group - June 7, 2017
(in response to Odessa Fennen)
User group ignore this message was meant for something else.
Thank You & have a good day...

Stan Goodwin,
Technical Sales Specialist
DB2 Advisor for System Z
IBM Mid-Atlanitc Region
Phone: 720-342-9832
Email: [login to unmask email]

'The mass of mankind, who think more of present evil, however trifling,
then of the past grievances, however oppressive, begin to connect present
evils with present rule, and having lost, in some degree, the memory of
their ancient wrongs, desire to recall a dynasty which, thus viewed, bears
a not an unfavorable comparison with their present state'.... Mary
Frances Cusak, 'History of Ireland'.





From: Stanley Goodwin <[login to unmask email]>
To: [login to unmask email]
Date: 05/31/2017 11:34 AM
Subject: [DB2UGCENPA] - RE: Central PA Regional DB2 User Group -
June 7, 2017



Odessa, are we at a count where cancellation should be considered?
Thank You & have a good day...

Stan Goodwin,
Technical Sales Specialist
DB2 Advisor for System Z
IBM Mid-Atlanitc Region
Phone: 720-342-9832
Email: [login to unmask email]

'The mass of mankind, who think more of present evil, however trifling,
then of the past grievances, however oppressive, begin to connect present
evils with present rule, and having lost, in some degree, the memory of
their ancient wrongs, desire to recall a dynasty which, thus viewed, bears
a not an unfavorable comparison with their present state'.... Mary
Frances Cusak, 'History of Ireland'.




Attachment Links: blankfilename.txt (18 k)
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]
Learn how ESAi's fast data refresh & Test Data Management products can
save up to 90% in CPU, I/O
and manual efforts compared to typical solutions. Be a hero to your users
with BCV5 & XDM. See
ttp://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




Attachments

  • blankfilename.txt (17.8k)
  • blankfilename.txt (17.8k)