 |
|
|
|
|
DB2 and the fetch-first clause
Expert: Craig Mullins | 06 Jan 2004
EXPERT ANSWER - 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 I limit the ...
|
|
|
Rollback changes coming undone
Expert: Craig Mullins | 19 Dec 2003
EXPERT ANSWER - 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 processing, the ...
|
|
|
Freeing up OBIDs
Expert: Craig Mullins | 05 Dec 2003
EXPERT ANSWER - 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 of objects so ...
|
|
|
What will be the impact of DB2 V8?
Expert: Craig Mullins | 03 Dec 2003
EXPERT ANSWER - 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?
|
|
|
Date arithmetic in COBOL
Expert: Craig Mullins | 20 Nov 2003
EXPERT ANSWER - 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 ...
|
|
|
Why deadlocks occur and what to do about them
Expert: Craig Mullins | 17 Nov 2003
EXPERT ANSWER - 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 RS6K CICS and ...
|
|
|
Generating images of DB tables
Expert: Craig Mullins | 17 Nov 2003
EXPERT ANSWER - Is there any short side to using triggers for generating before and after images of DB tables? If so, what are they?
|
|
|
Reducing DB2 batch windows
Expert: Craig Mullins | 13 Nov 2003
EXPERT ANSWER - 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.
|
|
|
Running a 24x7 environment
Expert: Craig Mullins | 06 Oct 2003
EXPERT ANSWER - 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 noticeably?
|
|
|
How to access DB2 from CICS or MS
Expert: Craig Mullins | 26 Sep 2003
EXPERT ANSWER - 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?
|
|
|
|
|
|
|
