Idea Details

RC/Migrator: Include NUMRECS clause in default IBM Load Model

Last activity 07-12-2019 11:25 AM
Srinivas Adupa's profile image
01-23-2019 05:58 AM

Intent: I want NUMRECS clause of IBM LOAD to be part of CA RC/Migrator's IBM Load default Model. 

 

More information: While loading data into 1) larger table 2) multi table tablespace (with limited resources in LPAR), it is good to include NUMRECS in the load card to efficiently allocate SORT work datasets by Db2. So, I want NUMRECS to be included in default IBM LOAD model of CA RC/Migrator. 

 

 

Please vote if you want NUMRECS to be included in default IBM LOAD models.

 

Thanks,

Srinivas Adupa. 


Comments

01-23-2019 06:32 AM

Completely agree with you Steve and thanks for the suggestion. 

RC/Migrator does not generate NUMRECS currently in Analysis output. It might cause some difficulty (or allocating sort work files inappropriately) while loading the larger data. This idea is about to include NUMRECS into IBM LOAD default model of RC/Migrator with the value from RTS. 

Validation while execution would be very nice to have as added advantage but negative side is is it will eat up CPU. 

 

Thanks, 

Srini. 

01-23-2019 06:24 AM

Base this on RTS from the source table. Not sure if it's possible but it would be great if there was a way to validate at execution that the value inserted into NUMRECS at Analysis time was correct or reasonably close.