• Share
  • ?
  • Profiles ▼
  • Communities ▼
  • Apps ▼

Blogs

  • My Blogs
  • Public Blogs
  • My Updates

This community can have members from outside your organization. DB2 Performance Tuning

  • Log in to participate

▼ Tags

▼ Similar Entries

Use a non-zero NPGTH...

Blog: Db2 for z/OS ...
Paul_McWilliams 110000JT36
Updated
1 people likes thisLikes 1
CommentsComments 1

Linux on IBM Z perfo...

Blog: Ingolf's z/VS...
Ingolf24 120000DRN3
Updated
0 people like thisLikes 0
No CommentsComments 0

Building baas: (serv...

Blog: IBM and Googl...
MJonker 100000GP4U
Updated
1 people likes thisLikes 1
No CommentsComments 0

Compiling with the D...

Blog: COBOL Cafe
DavidHT 0700000V0U
Updated
0 people like thisLikes 0
No CommentsComments 0

Cache Invalidation U...

Blog: CSE-WebSphere...
ShoebBihari 3100001AME
Updated
1 people likes thisLikes 1
No CommentsComments 0

▼ Similar Ideas

使用Flashcopy Image Co...

Ideation Blog: 主机知刊
tianna 310001QCY5
Updated
Votes 2 No CommentsComments 0

Re: 2014 2nd Edition...

Ideation Blog: IBM PureData-...
shubho 270001FMSR
Updated
No Votes 0 No CommentsComments 0

Statistics in Netezz...

Ideation Blog: IBM PureData-...
DeepashriKrishnaraja 270001C7Y3
Updated
Votes 1 CommentsComments 3

Importance of settin...

Ideation Blog: IBM PureData-...
DeepashriKrishnaraja 270001C7Y3
Updated
Votes 2 CommentsComments 5

Understanding Netezz...

Ideation Blog: IBM PureData-...
vinoy 270001RPDP
Updated
Votes 2 CommentsComments 2

▼ Archive

  • January 2018
  • December 2017
  • October 2017
  • August 2017
  • July 2017
  • April 2015
  • March 2015
  • January 2015
  • September 2014
  • June 2014
  • April 2014
  • March 2014
  • February 2014
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011

▼ Blog Authors

DB2 Performance Tuning

View All Entries
Clicking the button causes a full page refresh. The user could go to the "Entry list" region to view the new content.) Entry list

Getting Ready for DB2 10: The Competitive Advantage

DaveBeulke 2700023WUN | | Tags:  10 db2 performance | 4,403 Views

Whether you are currently using DB2 Version 8 or Version 9, getting ready for all the CPU efficiencies in DB2 10 is easy. Your company may not be thinking about migrating to DB2 10 yet, but DB2 10 is getting huge industry wide support as the cost savings began to be realized by management. Everyone wants to save money and with everyone trying to squeeze their budgets, a faster adoption of DB2 10 is in your future. It is best to be prepared, so here are a few things you can do  in DB2 Version 8 that will make it easier to get to DB2 10.

Embrace System Managed Storage SMS

No, I am not Darth Vader telling you to embrace the dark side, but to let you know that DB2 10 catalog and directory use SMS. Using SMS is a hard thing to do for many companies and personally, I am not a real big fan of SMS. DB2 10 and additional improvements in storage have made me think twice and SMS may be more help than a problem. Being a performance geek, I recommend limiting or not sharing storage volumes within the DB2 SMS definitions. The SMS performance key, if possible, is to segregate the DB2 SMS definitions completely, yes completely, away from other storage definitions. SMS horror stories about the I/O troubles are well known and through my consulting clients I see SMS at the center of many I/O problems. Embrace SMS but be diligent guarding your DB2 system’s I/O performance and especially your DB2 catalog and directory data sets.

Sharpen Your Security

I am a big supporter of compliance, protecting data assets, security audits and all the security team’s efforts for protecting the company and all the business information. DB2 10 offers more privileges and authority granularity in your DB2 systems and security experts will need to embrace these features to separate out your data access, utility operations and day-to-day work. Start auditing your security usage of your systems area, various DBA support groups, different local and distributed applications, and analyze their needs. Do the activities require data access? Could the DB2 DBA work maybe been done using a different security level such as DB2 SYSOPR or another security authority? More DB2 10 security privileges and authority granularity improvements are going to affect your security profiles. Get ready and start the security analysis now.

Learn more about DB2 10 through the replay of Roger Miller’s and my 2010 webcast: DB2 10 for z/OS – Helping you improve operational efficiencies and gain competitive advantage. The webcast replay is available here…

http://www-01.ibm.com/software/os/systemz/webcast/13apr/index.html?S_TACT=100GU00M&S_CMP=SP

  • Add a Comment Add a Comment
  • Edit
  • More Actions v
  • Quarantine this Entry
Notify Other People
notification

Send Email Notification

+

Quarantine this entry

deleteEntry
duplicateEntry

Mark as Duplicate

  • Previous Entry
  • Main
  • Next Entry
Feed for Blog Entries | Feed for Blog Comments | Feed for Comments for this Entry