Friday, November 8, 2013

Redbook DB2 11 for z/OS Technical Overview

Hi DB2 user,

IBM just published a draft version of a new Redbook "DB2 11 for z/OS Technical Overview, SG24-8180-00":
http://www.redbooks.ibm.com/redbooks.nsf/RedpieceAbstracts/sg248180.html?Open

Abstract
IBM DB2 11 for z/OS is the fifteenth release of DB2 for MVS. It brings performance and synergy with the new System z hardware and new opportunities to drive business value in the following areas:
Unmatched reliability, availability, and scalability

Improved data sharing performance and efficiency
Even less downtime by removing growth limitations
Simplified management, improved autonomics, and reduce planned outages
with more online schema changes and utilities improvements
Save money, save time

Aggressive CPU reduction goals
Additional utilities performance and CPU improvements
Save time and resources with new autonomic and application development capabilities
Simpler, faster migration
SQL compatibility, divorce system migration from application migration
Access path stability improvements
Better application performance with SQL and XML enhancements
Enhanced business analytics

Faster, more efficient performance for query workloads
Accelerator enhancements
More efficient inline database scoring enables predictive analytics
The DB2 11 environment is available either for brand new installations of DB2, or for migrations from DB2 10 for z/OS subsystems only.

This IBM Redbooks publication introduces the enhancements made available with DB2 11 for z/OS. The contents help database administrators understand the new functions and performance enhancements, start planning for exploiting the key new capabilities, and justify the investment in installing or migrating to DB2 11.


Table of Contents
Chapter 1. DB2 11 for z/OS at a glance
Chapter 2. Synergy with System z
Chapter 3. Scalability
Chapter 4. Availability
Chapter 5. Data sharing
Chapter 6. SQL
Chapter 7. Application enablement
Chapter 8. XML
Chapter 9. Connectivity and administration routines
Chapter 10. Security
Chapter 11. Utilities
Chapter 12. Installation and migration
Chapter 13. Performance
Appendix A. Information on IFCID changes

Appendix B. Summary of relevant maintenance



Regards,

DB2usa.


Monday, August 15, 2011

Redbook Security Functions with DB2 10 for z/OS

Hi User,

IBM just published a draft version of a new Redbook "Security Functions with DB2 10 for z/OS, SG24-7959-00":
http://www.redbooks.ibm.com/Redbooks.nsf/RedpieceAbstracts/sg247959.html?Open

Abstract
DB2 9 and 10 for z/OS have added functions in the areas of security, regulatory compliance, and audit capability which provide solutions for the most compelling requirements.
DB2 10 enhances the DB2 9 role-based security with additional administrative and other finer-grained authorities and privileges. This authority granularity helps separate administration and data access that provide only the minimum appropriate authority.
The authority profiles provide better separation of duties while limiting or eliminating blanket authority over all aspects of a table and its data. In addition, DB2 10 provides a set of criteria for auditing for the possible abuse and overlapping of authorities within a system.
In DB2 10, improvements to security and regulatory compliance focus on data retention and protecting sensitive data from privileged users and administrators. Improvements also help to separate security administration from database administration.
DB2 10 also lets administrators enable security on a particular column or particular row in the database complementing the privilege model.
This IBM® Redbooks® publication provides a detailed description of DB2 10 security functions from the implementation and usage point of view.
.

Table of Contents
Chapter 1. Regulations
Chapter 2. Introduction to security for DB2 for z/OS
Chapter 3. RACF and DB2
Chapter 4. Administrative authorities and security-related objects
Chapter 5. Roles and trusted context
Chapter 6. Data access control
Chapter 7. Cryptography
Chapter 8. End user authentication
Chapter 9. Audit policies
Chapter 10. Implementing data access control
Chapter 11. Remote client applications access
Chapter 12. Database monitoring and the audit application
Chapter 13. Auditing and IBM InfoSphere Guardium
Chapter 14. DB2 temporal support
Appendix A. Spiffy Computer company security setup



Regards,

DB2usa.


Labels: ,


Monday, August 8, 2011

DB2mag Summer 2011

Hi DB2 user,

Summer 2011 issue of DB2mag is available on line:

- DB2mag Summer 2011

- DB2mag Archives (since Spring 2009)
- DB2mag Archives (Winter 1996-Spring 2009)

Note: DB2mag became IBMDatabasemag and then IBM Data Management magazine.


- Solid-state drives: Changing the data world
Say hello to your new friend.
by Paul Pendle

- Go back in time
Get started with temporal data, a timely new DB2 feature
by Sasirekha Rameshkumar

- The rise of the developer DBA
Let the database take care of itself. The DBA of the future has more important things to do.
by Robert Catterall

- PLANs + COLLECTIONs + VERSIONs + PACKAGEs + DBRMs = Confusion
Revisiting program preparation on DB2.
by Bonnie Baker



Regards,

DB2usa.

Labels: , , ,


Monday, July 4, 2011

z/Journal (June - July 2011 issue)

Hi DB2 user,

Articles from June - July 2011 issue of z/Journal are available online: http://www.mainframezone.com/z-journal

Note: z/Journal moved to mainframezone.com .

- DB2 for z/OS Search and Scroll Techniques
by Dan Luksetich

- A First Look: DB2 10 DSNZPARM Changes
by Willie Favero

- Partitioning Pros and Cons
by Craig Mullins


Regards,

DB2usa.

Labels: , , , ,


Monday, June 27, 2011

Redbook DB2 10 for z/OS Performance Topics

Hi User,

IBM just published a draft version of a new Redbook "DB2 10 for z/OS Performance Topics, SG24-7942-00":
http://www.redbooks.ibm.com/abstracts/sg247942.html?Open

Abstract

DB2 10 can reduce the total DB2 CPU demand from 5-20% when you take advantage of all the enhancements. Many CPU reductions are built in directly to DB2, requiring no application changes. Some enhancements are implemented through normal DB2 activities through rebinding, restructuring database definitions, improving applications, and utility processing. The CPU demand reduction features have the potential to provide significant total cost of ownership savings based on the application mix and transaction types.
Improvements in optimization reduce costs by processing SQL automatically with more efficient data access paths. Improvements through a range-list index scan access method, list prefetch for IN-list, more parallelism for select and index insert processing, better work file usage, better record identifier (RID) pool overflow management, improved sequential detection, faster log I/O, access path certainty evaluation for static SQL, and improved distributed data facility (DDF) transaction flow all provide more efficiency without changes to applications. These enhancements can reduce total CPU enterprise costs because of improved efficiency in the DB2 10 for z/OS.
DB2 10 includes numerous performance enhancements for Large Objects (LOBs) that save disk space for small LOBs and that provide dramatically better performance for LOB retrieval, inserts, load, and import/export using DB2 utilities. DB210 can also more effectively REORG partitions that contain LOBs.
This IBM Redbooks publication® provides an overview of the performance impact of DB2 10 for z/OS discussing the overall performance and possible impacts when moving from version to version. We include performance measurements that were made in the laboratory and provide some estimates.
Keep in mind that your results are likely to vary, as the conditions and work will differ.
In this book, we assume that you are somewhat familiar with DB2 10 for z/OS.
See DB2 10 for z/OS Technical Overview, SG24-7892-00, for an introduction to the new functions.

Table of Contents
Chapter 1. Introduction
Chapter 2. Subsystem
Chapter 3. Synergy with z platform
Chapter 4. Table space design options
Chapter 5. Sample workloads
Chapter 6. SQL
Chapter 7. Application enablement
Chapter 8. Distributed environment
Chapter 9. Utilities
Chapter 10. Security
Chapter 11. Installation and migration
Chapter 12. Monitoring and Extended Insight
Appendix A. Recent maintenance




Regards,

DB2usa.


Labels: ,


Monday, May 16, 2011

DB2mag Spring 2011

Hi DB2 user,

Spring 2011 issue of DB2mag is available on line:

- DB2mag Spring 2011

- DB2mag Archives (since Spring 2009)
- DB2mag Archives (Winter 1996-Spring 2009)

Note: DB2mag became IBMDatabasemag and then IBM Data Management magazine.


- Tuning SQL at the Senate
E pluribus unum
by Ives Brant

- Securing DB2 data
Grant privileges to a what, not a who.
by Robert Catterall

- New ORDER BY information, Part 2
The impact of using the RANDOM index option on ORDER BY sort avoidance.
by Bonnie Baker



Regards,

DB2usa.

Labels: , ,


Monday, May 9, 2011

z/Journal (April - May 2011 issue)

Hi DB2 user,

Articles from April - May 2011 issue of z/Journal are available online: http://www.mainframezone.com/z-journal

Note: z/Journal moved to mainframezone.com .

- Save MIPS With Effective DB2 for z/OS Indexes
by Rick Weaver

- DB2 for z/OS and REBIND
by Jim Kurtz

- Empowering Technicians for the Changing World
by Troy Coleman

- Best Practices in DB2 Storage Management
by Craig Mullins


Regards,

DB2usa.

Labels: , ,


Monday, April 4, 2011

z/Journal (February - March 2011 issue)

Hi DB2 user,

Articles from February - March 2011 issue of z/Journal are available online: http://www.mainframezone.com/z-journal

Note: z/Journal moved to mainframezone.com .

- The Forensics of DB2 Network Traffic
by Wendy Wong

- Top-10 Reasons to Move to DB2 10
by Michael Jones

- DB2 10 for z/OS: The Most Secure DB2 Yet
by Willie Favero

- Dynamic SQL vs. Static SQL
by Craig Mullins


Regards,

DB2usa.

Labels: , , ,


Monday, March 7, 2011

DB2mag Winter 2010

Hi DB2 user,

Spring 2011 issue of DB2mag is available on line:

- DB2mag Winter 2010

- DB2mag Archives (since Spring 2009)
- DB2mag Archives (Winter 1996-Spring 2009)

Note: DB2mag became IBMDatabasemag and then IBM Data Management magazine.


- The Database Revolution
Today they're indispensable. Sixty years ago they didn't even exist as an idea. How did we get here?
by Carl Olofson

- DB2 Indexes and Query Performance: Part 2
2No new indexes? No problem.
by Robert Catterall

- New ORDER BY Information
Avoiding sorts with data-partitioned secondary indexes.
by Bonnie Baker



Regards,

DB2usa.

Labels: , ,


Monday, February 28, 2011

z/Journal (October 2010 - January 2011 issues)

Hi DB2 user,

Articles from October 2010 - January 2011 issues of z/Journal are available online: http://www.mainframezone.com/z-journal

Note: z/Journal moved to mainframezone.com .

- How DB2 for z/OS Application Requirements Affect Database Design
by Lockwood Lyon

- The DB2 Catalog Gets a Makeover
by Willie Favero

- Skip-Level Migration
by Willie Favero

- Revolutionary Technology for Data Warehouse and BI Workloads
by Patric Becker and Cuneyt Goksu

- Consider Capping to Control Costs
by Craig Mullins

- Rebinding for Optimal DB2 Access Paths
by Craig Mullins


Regards,

DB2usa.

Labels: , ,