Hi Natarajan,
When i ran the above query as in SPUFI, it ran in 40 sec, rows retrieved was 2.
But when i ran the same query in COBOL program, it took 2+ hours to complete.
I'm planning to reduce down the "where" condition.
Do you have any further idea.
Search found 6 matches
- Fri May 08, 2009 7:26 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: DB2 PERFORMANCE TUNING TIPS
- Replies: 9
- Views: 35197
- Fri Feb 13, 2009 12:00 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: DB2 PERFORMANCE TUNING TIPS
- Replies: 9
- Views: 35197
Re: db2 performance tuning tips
Thanks for the response. It works for me.
- Wed Feb 04, 2009 1:21 am
- Forum: ASSEMBLER
- Topic: Need Interview FAQ's for Assembler
- Replies: 8
- Views: 49104
Need Interview FAQ's for Assembler
Dear Friends, I have attended few interview's for Assembler. I have been asked few queston only as 1. Difference between DS & DC 2. Types of Instruction 3. Different data types 4. Types of registers R1-R16 5. How to call subprogram 6. Move command. As i'm kind of beginner in assembler and able to ma...
- Wed Feb 04, 2009 1:11 am
- Forum: PL/I
- Topic: Need Interview FAQ's for PL/1
- Replies: 1
- Views: 7416
Need Interview FAQ's for PL/1
Dear Friends,
I Need Interview FAQ's for PL/1. Please let me know any links or bunch of FAQ's with or without answers.
Thanks in Advance.
I Need Interview FAQ's for PL/1. Please let me know any links or bunch of FAQ's with or without answers.
Thanks in Advance.
- Thu Jan 29, 2009 8:57 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: How to tune the performance of DB2 Query
- Replies: 0
- Views: 2976
How to tune the performance of DB2 Query
Hi, Please help me in my below DB2 query to run faster. Currently it is taking around 1 hour to complete. SELECT A.C_AC_ID_C ,A.C_N ,A.C_AC_PRNT_ID_C ,A.C_AC_EF_D ,E.OFCE_ID_C ,B.DOC_RQR_D ,B.DOC_TYP_C ,C.DOC_TYP_T ,D.INTL_ID_C ,E.DEPT_ID_C ,B.DOC_STAT_TYP_C FROM CAC.TC_AC_COMBD A, CAC.TDOC_STAT B, ...
- Wed Jan 28, 2009 7:49 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: DB2 PERFORMANCE TUNING TIPS
- Replies: 9
- Views: 35197
Hi, Please help me in my below DB2 query to run faster. Currently it is taking around 1 hour to complete. SELECT A.C_AC_ID_C ,A.C_N ,A.C_AC_PRNT_ID_C ,A.C_AC_EF_D ,E.OFCE_ID_C ,B.DOC_RQR_D ,B.DOC_TYP_C ,C.DOC_TYP_T ,D.INTL_ID_C ,E.DEPT_ID_C ,B.DOC_STAT_TYP_C FROM CAC.TC_AC_COMBD A, CAC.TDOC_STAT B, ...