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
 

 

Doubts on Splits of an IMS database

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

New User


Joined: 09 Oct 2006
Posts: 36

PostPosted: Fri Jul 27, 2007 9:52 am    Post subject: Doubts on Splits of an IMS database
Reply with quote

Hi all, I have several questions:
1, why an IMS databse is always split into different splits, say for a database SS, it is split into SS01, SS02,...
- I guess this is for faster access and effective management, right?

2, Need a simple description about how storage is management in IMS databse, say if i want to add some records into my IMS databse, but the storage is not sufficient at that time, what will happen?
- For a database have split as SS01, SS02 and SS03, does there exist a concept as like: SS01 split is "full"? I mean is there a time when i can not add my records into a specific split when this split is "Full" ?

3, in PSB we define DBDNAME as SS01, or SS02..., how the split is mapped to its actual file?

thank u all guys icon_rolleyes.gif
Back to top
View user's profile Send private message

Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Fri Jul 27, 2007 12:57 pm    Post subject:
Reply with quote

Quote:
why an IMS databse is always split into different splits

This is not Always. It depends on database setup.
Quote:
faster access and effective management, right?

This is correct, and done mostly if the database is very huge in size.

Normally the database is split based on key range, so when inserting new segment identifies correct split and inserts.
If there is no space then there will be error.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


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

PostPosted: Sat Aug 04, 2007 2:32 am    Post subject:
Reply with quote

Treat them as entirely separate databases. When they were split, they were split because of faster access because they were big. You need to know what the key value ranges are for each database. You will then decide where to insert based on that range. Don't forget that you will define them as separate databases in your PSB, PCBs, and linkage. You will need separate subroutines for each.
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 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
No new posts Database access from COBOL amitmahalkar DB2 1 Wed Jan 27, 2016 11:33 am
No new posts Database backup on IMS DB HABBIE IMS DB/DC 1 Wed Aug 12, 2015 9:02 pm
No new posts Database name in Z/OS HABBIE DB2 6 Fri Aug 07, 2015 5:52 pm


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