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

Delete All data from IMS database


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

New User


Joined: 10 Sep 2009
Posts: 68
Location: Liverpool

PostPosted: Wed Aug 31, 2011 3:35 pm
Reply with quote

Sorry for the topic but in here we do not have any utility to either load or Unload the data....

Is there a way to delete all tje parent and the child segments from the existing IMS database???
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Wed Aug 31, 2011 3:37 pm
Reply with quote

if somebody in Your organization had read the effing manuals he/she/they would know about DFSDDLT0 icon_cool.gif
( not for bulk work, but very usable )

to delete all data, did You consider deleting the datasets and redefining them ???
Back to top
View user's profile Send private message
narasimha.g

New User


Joined: 10 Sep 2009
Posts: 68
Location: Liverpool

PostPosted: Wed Aug 31, 2011 3:44 pm
Reply with quote

enrico-sorichetti wrote:
if somebody in Your organization had read the effing manuals he/she/they would know about DFSDDLT0 icon_cool.gif
( not for bulk work, but very usable )

to delete all data, did You consider deleting the datasets and redefining them ???


No.... IS there any particular way of finding the IMS dataset name if we know the DBD or the database name???
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Wed Aug 31, 2011 3:57 pm
Reply with quote

Quote:
No.... IS there any particular way of finding the IMS dataset name if we know the DBD or the database name???


it would be better if You learned to post properly...

OK, NO so nobody cared about reading the manuals... interesting icon_cool.gif

NOT OK, what does the question have to to do with the initial issue ? icon_evil.gif

again if somebody in Your organization had read the (note the tone change) fucking manuals
You/Your support would know the answer ...

-- hint
when using dynamic <database> allocation there is IMS <configuration> table that establishes the relation between a DBD and the relevant/related DATASETS ,
up to You/Your support to find out more about it in the manuals

but the best place would be the application documentation
Back to top
View user's profile Send private message
narasimha.g

New User


Joined: 10 Sep 2009
Posts: 68
Location: Liverpool

PostPosted: Wed Aug 31, 2011 4:04 pm
Reply with quote

enrico-sorichetti wrote:
Quote:
No.... IS there any particular way of finding the IMS dataset name if we know the DBD or the database name???


it would be better if You learned to post properly...

OK, NO so nobody cared about reading the manuals... interesting icon_cool.gif

NOT OK, what does the question have to to do with the initial issue ? icon_evil.gif

again if somebody in Your organization had read the (note the tone change) fucking manuals
You/Your support would know the answer ...

-- hint
when using dynamic <database> allocation there is IMS <configuration> table that establishes the relation between a DBD and the relevant/related DATASETS ,
up to You/Your support to find out more about it in the manuals


Sorry for that... But The "No" was for that i have not tried deleting the dataset and re-creating it... and the problem is I moved last week to this project and the support we have is the IBM support from South Africa which would take ages to communicate and get an answer.... icon_sad.gif We don even have an unload and upload utility for IMS databases.....
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Wed Aug 31, 2011 4:17 pm
Reply with quote

Quote:
and the problem is I moved last week to this project and the support we have is the IBM support from South Africa which would take ages to communicate and get an answer....

plain horse manure icon_evil.gif
what has that got to do with proper forum expectations ?
remember we reply on our own time and at no charge
we are not a free consultancy service nor a substitute of Your support
if You/Your organization has issue with the support provider let somebody with the proper autorithy pursue the issue at depth

in another reply I just pointed You to the IMS manuals ,
www.ibmmainframes.com/viewtopic.php?t=55870&highlight=
it' s a big load but just start meditating on them

IT is not cheap,
Your organization should be aware of that and should expect to provide the proper tools and utilities
or spend people time in providing the same facilities with <in house> written tools
Back to top
View user's profile Send private message
narasimha.g

New User


Joined: 10 Sep 2009
Posts: 68
Location: Liverpool

PostPosted: Wed Aug 31, 2011 5:42 pm
Reply with quote

Sorry Enrico....
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Wed Aug 31, 2011 5:57 pm
Reply with quote

nothing to be sorry,
we are here to help, but also to make people understand what they can reasonably ask and expect around here...

and what not to whine about icon_biggrin.gif

complaining about issues with Your support will not certainly improve Your benevolence factor
and might often receive much stronger replies
Back to top
View user's profile Send private message
Ed Goodman

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Wed Aug 31, 2011 7:43 pm
Reply with quote

Please don't try to delete/define the databases on your own. IMS has tracking and recovery built in, and if you start doing things like that, you will be very very sorry.

I would bet that someone in Africa has jobs to do a proper delete/define and initialize of the databases in your test region.

However, if you want to do it yourself, use a COBOL program that does GN/DLET calls on the root, with checkpoints every so often. This will leave you with an empty database, but that database will be "disorganized" and you may have performance issues depending on its size.
Back to top
View user's profile Send private message
narasimha.g

New User


Joined: 10 Sep 2009
Posts: 68
Location: Liverpool

PostPosted: Wed Aug 31, 2011 7:50 pm
Reply with quote

enrico-sorichetti wrote:
nothing to be sorry,
we are here to help, but also to make people understand what they can reasonably ask and expect around here...

and what not to whine about icon_biggrin.gif

complaining about issues with Your support will not certainly improve Your benevolence factor
and might often receive much stronger replies


icon_smile.gif icon_smile.gif icon_smile.gif icon_smile.gif
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Wed Aug 31, 2011 7:53 pm
Reply with quote

Quote:
IMS has tracking and recovery built in,


sometime replying writing everything from A to Z gets a bit boring,
the assumption is that the TS knows the rules of his environment
and should be able to follow them as described in the manuals,
I never implied a rough idcams delete/define icon_redface.gif
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Wed Aug 31, 2011 11:39 pm
Reply with quote

The FABNRVRS utility gives a nice xref between dbd's, psb's, acb's and dd names belonging to a physical dbd. After that scan your jcl for the ddnames, link all that information together and there you are. I created an IMS xref in 1999 with all that information, and oh my gosh people were so happy to be freed of the burden to find that out for them selves.
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 db2 vs static data COBOL Programming 1
No new posts External data queue (changes?) CLIST & REXX 0
No new posts Pull data using date difference betwe... DB2 6
No new posts fast data scrambling PL/I & Assembler 10
No new posts How to save SYSLOG as text data via P... All Other Mainframe Topics 4
Search our Forums:

Back to Top