COBOL-DB2 program or JCL LOAD-REPLACE utility

Sagar_mainframe · Posted: Thu Apr 28, 2011 8:02 pm

If I have to delete all exixting rows and load new data the table with around 50,000 rows daily.Which approach will be faster??

COBOL-DB2 program or JCL LOAD-REPLACE utility

Also I want to know which approach will NOT LOCK the table while deleting and inserting records.

Escapa · Posted: Thu Apr 28, 2011 8:13 pm

DB2 load utility as it is ment to do that... but I did not understand what you are trying to say by this..

daveporcelan · Posted: Thu Apr 28, 2011 8:23 pm

I agree the load utility is designed for that, but at 50,000 records, Cobol would not be that long.

The Load utility may put the table into check pending status, a situation you will need to rectify (reset the flag). If this happens, the table is not 'locked' but it can not be accessed until the check pending flag is reset.

Nic Clouston · Posted: Thu Apr 28, 2011 11:04 pm

Sagar_mainframe · Posted: Fri Apr 29, 2011 12:20 pm

I have to load around 50000 rows daily and delete the existing rows before loading.

1st approach: JCL-COBOL-DB2 pogram - First delet the records and then read the file and insert the record. Finally commit all the records.

2nd approach: JCL- Load-replace utility - This will also delete the records and replace it with new records.

So out of these two approaches which one is faster?

dbzTHEdinosauer · Posted: Fri Apr 29, 2011 2:18 pm

2nd approach is much quicker.

and db2 does not have records, it has rows.

if you would learn correct terminology and use it in your conversations,
you would get where you want to go, quicker.