Expert Knowledgebase
DB2 and Database Management with Craig Mullins
Any word on when IBM will end support for DB2 V6?
(21 JUN 2004)
Have you heard anything about when support for DB2 V6 was going to be dropped. Early this year, I had heard IBM might drop support at the end of this past June. But so far, I haven't seen anything official.
DB2 compression
(21 JUN 2004)
DB2 compression -- we run a fairly large SAP R/3 system currently just over 1TB on the DB2 universal database. We are thinking about implementing DB2 compression on some of the larger tables (tests indicate a s...
The logical data model
(21 JUN 2004)
I work in a data-modeling environment with the responsibility of logically modeling (LM) data for mainframe and server databases. LM for the OLTP systems are done to 3rd NF. Recently, the DBA recommended LM for...
How does DB2 manage the memory allocations/deallocations in an AIX environment?
(21 JUN 2004)
How does DB2 manage the memory allocations and deallocations in the AIX environment? Is there a reason that DB2 allocates more memory than configured?
Example, I have a database instance created with five ...
Using an open cursor to scroll forward and backward
(21 JUN 2004)
Given a table, my application specification requires me to position somewhere in the middle of the set of records and then fetch records either forward (increasing sort key order) or backward depending on user ...
Referencing additional columns in a DCLGEN
(21 JUN 2004)
Can a DCLGEN that contains an extra column have an adverse effect on SQL statements that update the table even if the extra column is not referenced in the UPDATE statement?
The role of the DBA
(21 JUN 2004)
1. How important is the database management system on the firm?
2. How to maintain the database management system?
3. How often is the proper upgrading of an information system?
4. How does an information...
Creating a DB2 trigger to execute a storage procedure
(21 JUN 2004)
I have been tasked with creating a DB2 trigger to execute a stored procedure whenever a row is updated, added or deleted from several DB2 tables.
Since the stored procedure needs to operate on several tabl...
Making sure your I/O routine doesn't degrade performance
(21 JUN 2004)
Our company supports and maintains mainframe financial systems. In order to maintain a common set of source code, we use a concept of I/O routines that are passed function codes by calling programs (batch and ...
How to access DB2 from CICS or MS
(21 JUN 2004)
I would like to know the proper way to access DB2. The scenario is two
LPARs, one running z/OS with CICS and IMS and the other running z/OS.e with DB2. What is required to access DB2 from either CICS or IMS? ...
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
