MVSFORUMS.com

semigeezer

Hi All,

I'm completely baffled by the LOAD utility. I have 3 small tables to load, so in batch call DSNUTILB with 3 LOAD statements with REPLACE.

The output statements say the tables were all loaded, including numbers of records, messages about indexes etc... But only the last one has records in it. If I execute 3 separate job steps, the same thing happens. Only the last one has records in it. But, if I execute only 1 statement (any of the 3), it works fine and that table is loaded.

The doc clearly says that the LOAD utility is used to "load one or more tables"

Is there some magic to getting the LOAD utility to correctly update more than 1 table per JOB?
Thanks
_________________
New members are encouraged to read the How To Ask Questions The Smart Way FAQ at http://www.catb.org/~esr/faqs/smart-questions.html.

kolusu · Posted: Wed May 04, 2011 1:27 pm Post subject:

semigeezer,

It depends on the type of Tablespace. Partitioned?

Kolusu

semigeezer · Posted: Wed May 04, 2011 2:22 pm Post subject:

I'm not sure. I'm new to this (no site help) so I'm not sure where to look for that. I found that I should (?) have 1 load statement with multiple INTO TABLEs but I the error messages then say that to use INDDN on each table I need PART integer and I can't seem to figure that out (any value I give there seems to be invalid).

I have a job that recreates these tables using INSERT statements but it takes forever to run so I was hoping to make this quicker.

Sorry I'm not providing much info -- I just don't know what to look for
_________________
New members are encouraged to read the How To Ask Questions The Smart Way FAQ at http://www.catb.org/~esr/faqs/smart-questions.html.

kolusu · Posted: Wed May 04, 2011 3:17 pm Post subject:

semigeezer,

I assuming you are using REPLACE YES option to load the tables. Change that to LOAD RESUME and you should be fine with the data in all the tables.

Kolusu

semigeezer · Posted: Fri May 06, 2011 1:04 am Post subject:

I'll give it a try tomorrow. Thanks
_________________
New members are encouraged to read the How To Ask Questions The Smart Way FAQ at http://www.catb.org/~esr/faqs/smart-questions.html.

schintala · Posted: Tue May 10, 2011 1:49 pm Post subject:

Just curious, are those tables are in one table space as segmented. If it so, you may have to change load control card to load them properly. Looks to me those tables are in one table space. Check it out.