Search found 6 matches

by kumar_log@hotmail.com
Fri May 08, 2009 7:26 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DB2 PERFORMANCE TUNING TIPS
Replies: 9
Views: 35197

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.
by kumar_log@hotmail.com
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.
by kumar_log@hotmail.com
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...
by kumar_log@hotmail.com
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.
by kumar_log@hotmail.com
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, ...
by kumar_log@hotmail.com
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, ...