Request help in loading HALDB database

Sandhyabalaji1 · New User Joined: 20 Apr 2009 Posts: 4 Location: Columbus

Hi All,

Every six months, we have a process which inserts around two million data in to IMS HALDB database. currently, we make use of DL/I insert for inserting the records. We thought of using the Load utility instead. Currently we use BMC load utility to reload the production unloads to test IMS HALDB database. When I took a look, the production unload has headers attached to it with all the partition information. I am not aware of the rest of the header information.

Can anyone of you please help me in understanding the format expected by the BMC load utility? Please let me know, if I have to provide more information.

Thanks,
Sandhya

enrico-sorichetti · Posted: Fri Jun 26, 2009 8:43 pm

are You simply trying to understand what is going on, or are You facing issues ??

Sandhyabalaji1 · New User Joined: 20 Apr 2009 Posts: 4 Location: Columbus

Thanks for the reply. None of us in the team are aware of how to format the load data as expected by the load utility. Till date, we are using the IMS HALDB load utility to load the production unloads. Now, we are trying to load records which are output from a process. Any help will be appreciated in guiding me as how to format the load records as expected by the load utility. Also, if some one has used HALDB load utility without using production unloads, please share your experience.

Thanks.

enrico-sorichetti · Posted: Mon Jun 29, 2009 7:30 pm

just curious, what about looking at the docs ??

Sandhyabalaji1 · New User Joined: 20 Apr 2009 Posts: 4 Location: Columbus

Thanks for the response. Unfortunately, we dont have any BMC manual at our place. All the manuals are located in Arizona and our people over there conveyed that much of information is not present which might be helpful in this scenario.

Sandhyabalaji1 · New User Joined: 20 Apr 2009 Posts: 4 Location: Columbus

I have one more query regarding the same topic. Is the initial load of an IMS database always through DL/I inserts? Is DL/I inserts are the only option to load data, if unloads are not applicable for loading? Anyhelp will be highly appreciated.

Thanks

dick scherrer · Posted: Tue Jun 30, 2009 12:49 am

Hello,

No, dl/i inserts is not the only way to load data. . .

Suggest your organization very quickly hire (or rent) someone qualified before major damage is done to your environment.