Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
If a new segment type is to be added.

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

New User


Joined: 31 May 2007
Posts: 38
Location: America

PostPosted: Mon Jan 19, 2009 9:14 am    Post subject: If a new segment type is to be added.
Reply with quote

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

ameenansari

New User


Joined: 18 Sep 2006
Posts: 11
Location: chennai

PostPosted: Mon Jan 19, 2009 11:35 am    Post subject: If a new segment type is to be added.
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Jan 19, 2009 11:52 am    Post subject:
Reply with quote

What if the segment to be added is parent ?
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Mon Jan 19, 2009 7:03 pm    Post subject:
Reply with quote

Just think about how IMS will resolve it's POINTERS. Is it HDAM - HIDAM?
Back to top
View user's profile Send private message
DST

New User


Joined: 31 May 2007
Posts: 38
Location: America

PostPosted: Thu Jan 22, 2009 9:04 am    Post subject: Reply to: If a new segment type is to be added.
Reply with quote

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
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Thu Jan 22, 2009 7:11 pm    Post subject:
Reply with quote

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

New User


Joined: 31 May 2007
Posts: 38
Location: America

PostPosted: Fri Jan 23, 2009 4:15 am    Post subject:
Reply with quote

Thanks Sandy.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Fri Jan 23, 2009 4:17 am    Post subject:
Reply with quote

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
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 Setting Font Type for XMIT satish.ms10 All Other Mainframe Topics 3 Fri Sep 15, 2017 10:01 pm
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts SORT JSON type of data maxsubrat DFSORT/ICETOOL 8 Wed Apr 19, 2017 6:01 pm
No new posts Ccompar BLOB (images of type jpg) on ... nihad DB2 0 Sun Feb 05, 2017 3:13 pm
No new posts Query using SUBSTRING on a column of ... sasanka DB2 5 Mon Jul 04, 2016 1:01 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us