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
 

 

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 Query using SUBSTRING on a column of ... sasanka DB2 5 Mon Jul 04, 2016 1:01 pm
No new posts Invalid frequency code, dataset descr... Bhanu Praveen JCL & VSAM 4 Fri Feb 05, 2016 10:43 am
No new posts Copy from VB to FB with added sequenc... bommu DFSORT/ICETOOL 4 Thu Sep 24, 2015 2:14 am
No new posts Data Type and Size senthamizh DB2 2 Fri Aug 21, 2015 2:34 pm
No new posts How to send MSGID & CORRELID for ... Sathiyendran Java & MQSeries 4 Mon Jul 20, 2015 2:08 pm


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