Expert Knowledgebase
DB2 and Database Management with Craig Mullins
Running a 24x7 environment
(21 JUN 2004)
What solutions are there for real 24x7 database managers? We run CICS in a multi-way Syplex attached to IMS on each LPAR. Is there a way to do IMS database maintenance with out disrupting the online system noti...
Reducing DB2 batch windows
(21 JUN 2004)
What recommendations do you have to get rid of and/or reduce the DB2 batch windows? I need an application available 24/7 which uses CICS(PLEX), DB2 and COBOL.
Generating images of DB tables
(21 JUN 2004)
Is there any short side to using triggers for generating before and after images of DB tables? If so, what are they?
Why deadlocks occur and what to do about them
(21 JUN 2004)
We already tried to update the rows of the same table in order but why are we still getting deadlocked to the same program? We use DB2 V6 for OS/390 and CICS TS V1.3 on OS/390 V2.9. The transaction came from RS...
Date arithmetic in COBOL
(21 JUN 2004)
I have your book "DB2 Developers Guide" 4th edition -- excellent by the way but like others, I am having trouble with date arithmetic.
I understand that date durations have to be decimal 8, I have coded:
...
What will be the impact of DB2 V8?
(21 JUN 2004)
I've heard that DB2 V8 will greatly enhance performance because of its ability to take advantage of the 64-bit architecture. What kind of performance enhancements can we expect from 64-bit and DB2 V8?
Freeing up OBIDs
(21 JUN 2004)
We're running DB2v6 on z/OS 1.4. We often create and drop a lot of objects so we get SQLCODE -497 saying that limit of 32k OBIDs has been exceeded. It seems that DB2 does not automatically free OBIDs after drop...
Rollback changes coming undone
(21 JUN 2004)
I have a cursor that selects "n" rows from a table based on certain conditions. For each of the rows selected, certain functions have to be performed that updates a few tables. If there is any error while proce...
DB2 and the fetch-first clause
(21 JUN 2004)
I'm an applications architect for a large PBM running DB2 version
6.1.2. Is there any way to limit the number of rows returned from a cursor? For example, if I know the result set is a total of 100 rows can ...
Cost vs. advantage of moving from IMS DB to DB2
(21 JUN 2004)
My customer is wondering about the possible advantages of converting his IMS DB/DC system to IMS DC/DB2. The application currently performs well with an internal response time of less than .5 seconds on average...
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
