DavidMarek
Programmer
I have a large application that needs to share data. Initially the data will be read from an IMS datbase but there are 2 options to pass the data around to the other programs that need it.
1. Via Linkage. This would involve creating large copybooks for each program (so that the programs are unique and not dependant on one large copybook), but there is a storage overhead plus the cost of moving the data around to the subprograms.
2. DB2 declared temporary tables. The data is inserted into a temp DB2 table then the subprograms that need data, SELECT the information they need.
Do you have any advice on the performance benefits of the DB2 option? The application is large, several hundred COBOL programs and roughly 500K on the table.
Thanks,
1. Via Linkage. This would involve creating large copybooks for each program (so that the programs are unique and not dependant on one large copybook), but there is a storage overhead plus the cost of moving the data around to the subprograms.
2. DB2 declared temporary tables. The data is inserted into a temp DB2 table then the subprograms that need data, SELECT the information they need.
Do you have any advice on the performance benefits of the DB2 option? The application is large, several hundred COBOL programs and roughly 500K on the table.
Thanks,