IBM Mainframe Forum Index
Log In
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register

HALDB data refresh/copy from production to tes

IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message

New User

Joined: 28 Dec 2016
Posts: 1
Location: India

PostPosted: Mon Jan 02, 2017 11:16 am
Reply with quote

Hi All,

I am new to IMS(experienced in DB2 for z/OS), and trying to get familiar with regular tasks such as data refresh, backup, recovery, pcbgen, etc.

I am trying to understand how data refresh is done in IMS. In DB2 usually its through unload-load. My environment is having HALDB databases and IMS version is 12.

It will be helpful , if someone can give me steps(and if possible sample jcls) for doing data refresh in IMS.
Back to top
View user's profile Send private message

New User

Joined: 05 Dec 2016
Posts: 4
Location: India

PostPosted: Fri Jan 20, 2017 3:51 pm
Reply with quote

Various methods.

You could do an unload/load.
If you have FileAid/IMS installed, you could do an extract/load.
If your production and test database definitions are the same, you could recover your test database from a production image copy.
You could write a program which extract the data from production and another program which will insert the extracted data into your test database.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC


Similar Topics
Topic Forum Replies
No new posts compare two file to find position/dat... SYNCSORT 2
No new posts Secondary index error while loading d... IMS DB/DC 2
No new posts SKIP LOCKED DATA in UPDATE statement DB2 9
This topic is locked: you cannot edit posts or make replies. Copy list of files from PS to another... CLIST & REXX 11
No new posts How to find which file contains my se... DFSORT/ICETOOL 6
Search our Forums:

Back to Top