|
View previous topic :: View next topic
|
| Author |
Message |
narasimha.g
New User
Joined: 10 Sep 2009
Posts: 68
Location: Liverpool
|
|
|
|
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 |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10888
Location: italy
|
|
|
|
if somebody in Your organization had read the effing manuals he/she/they would know about DFSDDLT0 
( not for bulk work, but very usable )
to delete all data, did You consider deleting the datasets and redefining them ??? |
|
| Back to top |
|
|
narasimha.g
New User
Joined: 10 Sep 2009
Posts: 68
Location: Liverpool
|
|
|
|
| enrico-sorichetti wrote: |
if somebody in Your organization had read the effing manuals he/she/they would know about DFSDDLT0
( 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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10888
Location: italy
|
|
|
|
| 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
NOT OK, what does the question have to to do with the initial issue ? 
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 |
|
|
narasimha.g
New User
Joined: 10 Sep 2009
Posts: 68
Location: Liverpool
|
|
|
|
| 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
NOT OK, what does the question have to to do with the initial issue ?
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....  We don even have an unload and upload utility for IMS databases..... |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10888
Location: italy
|
|
|
|
| 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
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 |
|
|
narasimha.g
New User
Joined: 10 Sep 2009
Posts: 68
Location: Liverpool
|
|
|
|
| Sorry Enrico.... |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10888
Location: italy
|
|
|
|
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 
complaining about issues with Your support will not certainly improve Your benevolence factor
and might often receive much stronger replies |
|
| Back to top |
|
|
Ed Goodman
Active Member
Joined: 08 Jun 2011
Posts: 556
Location: USA
|
|
|
|
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 |
|
|
narasimha.g
New User
Joined: 10 Sep 2009
Posts: 68
Location: Liverpool
|
|
|
|
| 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
complaining about issues with Your support will not certainly improve Your benevolence factor
and might often receive much stronger replies |
 |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10888
Location: italy
|
|
|
|
| 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  |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
| 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 |
|
|
|
|
