MVSFORUMS.com

Jim / Kolusu,

years ago I used BPXWDYN to dynamically allocate a tape dataset. However I had to request a security change to allow my userid to dynamically mount tapes.

perhaps this has chang ...

One thing to consider is that the Initialize verb does NOTHING to FILLER areas and as such they would have garbage in them without the preceeding MOVE SPACES

n DB2 the column is defined as decimal, in COBOL the host variable should be usage COMP-3.

select polno into :ws-pol-num from policy where polno = :pol-num

I declared ws-pol-num pic 9(16 ...

If you are only using this new index to delete rows from the table, you might consider the following which would be more efficient.

Set up an on demand REORG job which includes a DISCARD parameter. ...

I believe that Enterprise COBOL would align "01" levels at a 16 byte boundary.

Check the address of W-TBL and J to see if that is the case. If so that explains why J was not overlaid by ...

Bauer, are you attempting to reduce the size of the data in memory OR are you attempting to reduce the size of the data when stored on DASD.

If you are attempting to reduce the size on DASD, then ...

Nic,

try the following query as a "leap day" appears to correctly adjust the date correctly.

SELECT DATE('2020-02-29') - 1 YEAR FROM SYSIBM.SYSDUMMY1

result ==> 2019-02-28

Michael,

This is not to start a flame war about coding styles. I've always found that organizations produce better code if they have some coding standards and attempt to adhere to them.

I starte ...

PERFORM 100-OPEN-CURSOR THRU 100-EXIT.

PERFORM WITH TEST AFTER UNTIL SQLCODE NOT EQUAL ZERO
PERFORM 200-FETCH-CURSOR THRU 200-EXIT
END-PERFORM.

IF SQLCODE NOT EQUAL +100
PERFORM 8000- ...

Santosh,

REOPT(ALWAYS) is something that I've seen used when the data is skewed. So far I don't know if you have shown that the data distribution is skewed. If the data is not skewed or you are acc ...

Santosh, optimizing SQL queries is not trivial, if you want to get more help on this perhaps you could send me an email (see my signature).

remember that the explain cost is an ESTIMATE based on t ...

Santosh,

the access path for SPUFI is accessing the current DB2 stats to determine the access path

the access path for the SP is using the DB2 stats at the time the BIND was done on the SP

mo ...

Santosh,

I suspect that the data is skewed and does not have a uniform distribution. I have a few questions.

How many rows exist on the table with SECURITY = "ABCD" ?

How many rows ...

Kolusu / Sharss,

there is no need to recompile your programs to take advantage of a new index on a DB2 table.

To accomplish this you just need to do DB2 BIND's on the packages which use that tab ...

If you have the Strobe tool from Compuware or a similar tool from another vendor I would suggest that you use that to analyze the performance.

Are any of the files in your job VSAM ? If so I would ...