Expert Knowledgebase
DB2 and Database Management with Craig Mullins
Performance impact of secondary extents, tables and indexes
(10 FEB 2005)
Compared to other performance issues, what is the performance impact of secondary extents, tables indexes? Is the impression correct that Load/Reorg leaves the free space (PCTFREE and FREE PAGES) unused and lea...
Determining how indexes are being used
(10 FEB 2005)
If I have five indexes on a table, what is the best way to determine if all, some or none of the indexes are being used?
How and when to use DB2 scrollable cursors
(10 FEB 2005)
I have a select query that returns 1000 rows and I want to display the rows from 200 to 500. Could you please let me how to code after the where clause? I know how to get the first 100 rows using -- FETCH FIRST...
What authority non-DBAs need to create triggers
(10 FEB 2005)
What authority would a non-DBA need to create a DB2 trigger? We are using Endevor and processors to create triggers. We were successful in
creating stored procedures and thought triggers required similar autho...
Three rules of thumb for triggers
(10 FEB 2005)
We have had a lot of discussions about triggers. Some say it's better to write the code in an application program and some say it's better with a trigger.
If we should use either one, when should we use it?...
Making efficient schema changes
(10 FEB 2005)
From a DBA's perspective, what is the most efficient way to make schema changes? Drop and reload the environment, DDL specific changes, other? What are the pros and cons to each approach and why would our DBA r...
What difference does a 1 = 1 predicate make?
(10 FEB 2005)
What difference does a 1 = 1 predicate make? For example, consider the following SQL queries:
SELECT LASTNAME, FIRSTNAME, ADDR1 FROM EMP
SELECT LASTNAME, FIRSTNAME, ADDR1 FROM EMP WHERE 1 = 1
Is ...
Best way to read over 700,000 rows of COBOL
(10 FEB 2005)
I'm using COBOL on a mainframe and am sequentially reading over 700,000 rows. I'm using a table to join to another DB2 table. What is the best way to do this?
DB2/UDB on Unix/Linux vs. DB2/OS/390
(10 FEB 2005)
Do you have a reference that describes the difference between DB2/UDB on Unix/Linux (8.1) vs. DB2/0S/390 version 8?
Trigger basics in DB2 and OS/390
(10 FEB 2005)
I recently read your article here and I have a question.
TableA is a high transaction table. TableB is essentially a copy of TableA with indexes for reporting. I want to create an insert/update trigger on...
|
|
|
|
|
|
|
| TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of . |
|
| |
All Rights Reserved, , TechTarget |
|
|
|
|
|
