(Robert Catterall) A few days ago, I delivered a presentation on DB2 for z/OS performance monitoring and tuning for the DBA team at a large financial institution. At one point during the session, an attendee asked this question: “Which of our buffer pools should we page-fix?”
Tag: IBM
DB2 11 for z/OS Extended RBA/LRSN Migration
(David Simpson) Many companies are planning a migration to DB2 11 for z/OS because of the support for expanding the RBA and LRSN. Planning for the expansion is a post-migration task that will require some thought. Let’s take a look at the process.
Optimizing Database Performance, part 5: Database Reorganization
(Craig S. Mullins) Relational technology and SQL make data modification easy. Just issue an INSERT, UPDATE, or DELETE statement with the appropriate WHERE clause and the DBMS takes care of the actual data navigation and modification.
DB2 for z/OS: Which Buffer Pools Should You Page-Fix?
(Robert Catterall) A few days ago, I delivered a presentation on DB2 for z/OS performance monitoring and tuning for the DBA team at a large financial institution. At one point during the session, an attendee asked this question: “Which of our buffer pools should we page-fix?”
Big Data Analytics with IBM Cognos Dynamic Cubes
(David Cushing, MaryAlice Campbell and Avery Hagleitner) With IBM Cognos Business Intelligence, you have a proven enterprise business intelligence (BI) platform with an open-data access strategy. Because Cognos Business Intelligence uses a business language that is relevant to consumers, you can pul
How to grant privileges for a windows username on a new schema
(Jack Vamvas) Question: I am new to DB2 and have a question about the post SQL0286N A default table space could not be found – DBA DB2
Load Testing in a Big Data Environment — Big Data Issues
(Lockwood Lyon) Big data means exactly that: lots and lots of data. This may also be accompanied by large transaction volumes and an analytics suite that analyzes the data. In a load test, one must create a production-like environment, and that means storing a lot of data in your test system.
Big Data Analytics with IBM Cognos Dynamic Cubes
(David Cushing, MaryAlice Campbell and Avery Hagleitner) With IBM Cognos Business Intelligence, you have a proven enterprise business intelligence (BI) platform with an open-data access strategy. Because Cognos Business Intelligence uses a business language that is relevant to consumers, you can pul
How to grant privileges for a windows username on a new schema
(Jack Vamvas) Question: I am new to DB2 and have a question about the post SQL0286N A default table space could not be found – DBA DB2
Load Testing in a Big Data Environment — Big Data Issues
(Lockwood Lyon) Big data means exactly that: lots and lots of data. This may also be accompanied by large transaction volumes and an analytics suite that analyzes the data. In a load test, one must create a production-like environment, and that means storing a lot of data in your test system.
