MVSFORUMS.com

Thanks Kosulu,

I did. It did not improve. DBA is on leave this week, and after he returns, I shall put before him the various options, and let him decide.

Regards,
Satyam..

Can you advise or provide any suggestions for this performance resolution.

Option 3:

EXEC SQL DECLARE NFOPEN1 CURSOR FOR
SELECT
CDBKXX_SERNUM
, CDBKXX_TRANQUAL
, CDBKXX_SEQNUM ...

Option 2:

EXEC SQL DECLARE NFSET1 CURSOR FOR
SELECT
A.CDBKXX_SERNUM
, A.CDBKXX_TRANQUAL ...

Option 1:

EXEC SQL DECLARE NFSET1 INSENSITIVE SCROLL CURSOR FOR
SELECT
A.CDBKXX_SERNUM
, A.CD ...

Few options were tried today as listed below

This change did not yield results, as per the following mail
The program ITSSD988 is not picking up the new index created because SELECT
clause has all the columns and DB2 think that it will be doub ...

Performance Stats : 422K Excp Counts & 08.23 mins.
The problem was 26 buffers were needed thus depleting db2 buffer resources for other jobs, hence DBA

Current SQL Query in production is

EXEC SQL DECLARE NFOPEN1 CURSOR FOR
SELECT
CDBKXX_SERNUM
, CDBKXX_TRANQUAL
...

SELECT C.ADLPPLNCD
,SUM(CASE WHEN MN = :MONTH-1 THEN C.CNT ELSE 0 END)
,SUM(CASE WHEN MN = :MONTH-2 THEN C.CNT ELSE 0 END)
,SUM(CASE WHEN MN = :MONTH-3 ...

Thanks Kosulu for your help as it really helped me. I am back from a long vacation. The production run was also good.

I used the above query to populate host variables and used in the following qu ...

ID Mon1 Mon2 Mon3 Mon4 Mon5 Mon6 Mon7 Mon8 Mon9 Mon10 Mon11 Mon12

Key1 1 0 0 0 0 0 1 1 0 0 0 3

Key2 0 0 0 1 ...

Thanks Kolusu. I wanted the data for the last 12 months, beginning from the current month. The query, I am trying to test is as below.

SELECT C.ID ...

Hi all,
Before I start, thanks to Kolusu, for the good SQL Challenge Question 1. I used it in multiple examples. One visualization is getting complicated. I do not know, If I can get the output the d ...

Thanks Kolusu, this helped me.

Satya...