How to prevent ABEND 0852?



IBM's hierarchical database management system with a Database Manager (IMS DB) and a Transaction Manager(IMS DC)

How to prevent ABEND 0852?

Postby Mehdi shri » Sat Mar 09, 2013 11:20 pm

Dear friends
In our M/F application testing envirounment I give ABEND 0852 after submitiing job that only get data from a database named (CLACTTDB). I searched about it and understood this is caused by bad or invalid pointer. Know I want to findout a way to repair this pointer or find the segment which has lost the pointer and delete this segment. It is no matter that any portion of data deleted because this is our testing environment.
Is there any way?
Or whitch utility I can use to find out location of bad pointer or bad segment which due to this abend.
Thanks a lot.
Mehdi shri
 
Posts: 138
Joined: Sun Jan 16, 2011 6:30 pm
Has thanked: 57 times
Been thanked: 0 time

Re: How to prevent ABEND 0852?

Postby Akatsukami » Sat Mar 09, 2013 11:26 pm

Read about IMS abend U0852.

Basically
  1. Make sure that you're using the correct DBD. If that doesn't work,
  2. Reload the data base. If that doesn't work,
  3. Get assistance from your DBAs.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: How to prevent ABEND 0852?

Postby Mehdi shri » Sun Mar 10, 2013 10:38 am

Dear Akatsukami
How I can reload data base when I can't unload it?
Mehdi shri
 
Posts: 138
Joined: Sun Jan 16, 2011 6:30 pm
Has thanked: 57 times
Been thanked: 0 time

Re: How to prevent ABEND 0852?

Postby NicC » Sun Mar 10, 2013 11:55 am

Presumably you backed it up after the initiai load? Or you still have the initial load data?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: How to prevent ABEND 0852?

Postby Mehdi shri » Sun Mar 10, 2013 2:28 pm

I have not any backup from this database.
Mehdi shri
 
Posts: 138
Joined: Sun Jan 16, 2011 6:30 pm
Has thanked: 57 times
Been thanked: 0 time

Re: How to prevent ABEND 0852?

Postby NicC » Sun Mar 10, 2013 3:02 pm

Now you know why you should back things up.

Have you actually tried unloading the database?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: How to prevent ABEND 0852?

Postby Mehdi shri » Sun Mar 10, 2013 4:01 pm

Yes I do it very much. But now I want only to know How I can find or repair(or remove) bad pointer.
Thanks
Mehdi shri
 
Posts: 138
Joined: Sun Jan 16, 2011 6:30 pm
Has thanked: 57 times
Been thanked: 0 time

Re: How to prevent ABEND 0852?

Postby NicC » Sun Mar 10, 2013 4:42 pm

Well, I think the third point in Akatsukami's post is your only option. Might not be the only option but certainly the best.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: How to prevent ABEND 0852?

Postby dick scherrer » Mon Mar 11, 2013 3:59 am

Hello,

Where is the data from the initial load (asked earlier, but you did not answer)?

Also recommend Working with your dba.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: How to prevent ABEND 0852?

Postby Ed Goodman » Mon Mar 11, 2013 7:10 pm

I've seen a pointer repair tried about 20 times. It only worked once. There is a pointer checker utility and it will show you the offset of the pointer that it pointing to the wrong place. There is some sort of utility to try and fix it. It's not something that will usually work.

It's a lot like on the PC, when you try to undelete a file. Sure, you can put the file description back in the FAT, but unless nothing else has used any of the space, it won't make a valid file appear.
Ed Goodman
 
Posts: 341
Joined: Thu Feb 24, 2011 12:05 am
Has thanked: 3 times
Been thanked: 17 times

Next

Return to IMS DB/DC

 


  • Related topics
    Replies
    Views
    Last post