Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Request help in loading HALDB database

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
Sandhyabalaji1

New User


Joined: 20 Apr 2009
Posts: 4
Location: Columbus

PostPosted: Fri Jun 26, 2009 8:38 pm    Post subject: Request help in loading HALDB database
Reply with quote

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
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10231
Location: italy

PostPosted: Fri Jun 26, 2009 8:43 pm    Post subject: Reply to: Request help in loading HALDB database
Reply with quote

are You simply trying to understand what is going on, or are You facing issues ??
Back to top
View user's profile Send private message
Sandhyabalaji1

New User


Joined: 20 Apr 2009
Posts: 4
Location: Columbus

PostPosted: Mon Jun 29, 2009 7:08 pm    Post subject: Reply to: Request help in loading HALDB database
Reply with quote

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.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10231
Location: italy

PostPosted: Mon Jun 29, 2009 7:30 pm    Post subject: Reply to: Request help in loading HALDB database
Reply with quote

just curious, what about looking at the docs ??
Back to top
View user's profile Send private message
Sandhyabalaji1

New User


Joined: 20 Apr 2009
Posts: 4
Location: Columbus

PostPosted: Mon Jun 29, 2009 8:16 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Sandhyabalaji1

New User


Joined: 20 Apr 2009
Posts: 4
Location: Columbus

PostPosted: Tue Jun 30, 2009 12:06 am    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Jun 30, 2009 12:49 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts loading a Modified Mapset Susanta CICS 2 Tue Mar 14, 2017 5:43 pm
No new posts Dynamic array request/response contai... Suja.Sai CICS 2 Tue Jan 24, 2017 11:37 am
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 1 Mon Jan 02, 2017 11:16 am
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us