View previous topic :: View next topic
|
Author |
Message |
DST
New User
Joined: 31 May 2007 Posts: 38 Location: America
|
|
|
|
hi,
If a new segment type is to be added to an existing database, do we need to unload and reload the whole database?
Thanks |
|
Back to top |
|
|
ameenansari
New User
Joined: 18 Sep 2006 Posts: 11 Location: chennai
|
|
|
|
DST,
You can insert the new segment at the end of the segments. There is no need for unload and reload.
-Ameen |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
What if the segment to be added is parent ? |
|
Back to top |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
|
|
|
|
Just think about how IMS will resolve it's POINTERS. Is it HDAM - HIDAM? |
|
Back to top |
|
|
DST
New User
Joined: 31 May 2007 Posts: 38 Location: America
|
|
|
|
Thanks, everybody, the database is a hidam.
I have two more questions.
1. Say I have 100 root segment occurences in my IMS database. Do I always get 100 records in my underlying ESDS? If so, what happens if I wanted to add a new segment but there is not enough space in that ESDS record?
2. If I need to add a new field to an existing IMS segement. Do I need to unload and reload?
thanks. |
|
Back to top |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
|
|
|
|
1. The absolutely safest and most practical thing to do is to unload your database. Take a look at how it is defined. Adjust for free space, etc. Then do a delete/define. Then do a reload.
2. Do you copybooks for your database? Is there filler defined at the end of each segment? Again, your segment length will be defined in your DBD. If you do not have enough length on that segment, then you will need to do an unload and reload - after running the appropriate DBD gen stuff. On the application side, take a look at the programs using that segment and adjust. |
|
Back to top |
|
|
DST
New User
Joined: 31 May 2007 Posts: 38 Location: America
|
|
|
|
Thanks Sandy. |
|
Back to top |
|
|
Sandy Zimmer
Active Member
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
|
|
|
|
You are welcome! Oh, if you have "pathcall" copybooks defined, they will also need adjusted if this is a child segment. Good luck! |
|
Back to top |
|
|
|