Trying to create a seedlist from 3 existing tables using the SHUFFLE function. The Mainframe job completed with Return Code 0 but only one seed list is populated out of 3. What would cause this and how do I fix it? Also, my database is not getting updated.
If you are running PROC GTMSKDB (mask in place) but you have DBUPDATES=N in your //STEP05.PARMCD input, then you will experience this issue.
We suggest rerunning with DBUPDATES=Y.
It was verified the GTMSKDB proc (program GTXMSK) is only a partial execution of shuffling:
Use the DB2 mask in-place program (GTXMSK) to populate a seedlist for the SHUFFLE (create a mapping CSV with the required SHUFFLE and run the program with the SHUFFLEONLY=Y option in the PARMCD file), then use the SEQLOV function in the DB2 unload run in place of the SHUFFLE function.
Two items were needed to resolve this issue: