Page 1 of 2

How to prevent ABEND 0852?

PostPosted: Sat Mar 09, 2013 11:20 pm
by Mehdi shri
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.

Re: How to prevent ABEND 0852?

PostPosted: Sat Mar 09, 2013 11:26 pm
by Akatsukami
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.

Re: How to prevent ABEND 0852?

PostPosted: Sun Mar 10, 2013 10:38 am
by Mehdi shri
Dear Akatsukami
How I can reload data base when I can't unload it?

Re: How to prevent ABEND 0852?

PostPosted: Sun Mar 10, 2013 11:55 am
by NicC
Presumably you backed it up after the initiai load? Or you still have the initial load data?

Re: How to prevent ABEND 0852?

PostPosted: Sun Mar 10, 2013 2:28 pm
by Mehdi shri
I have not any backup from this database.

Re: How to prevent ABEND 0852?

PostPosted: Sun Mar 10, 2013 3:02 pm
by NicC
Now you know why you should back things up.

Have you actually tried unloading the database?

Re: How to prevent ABEND 0852?

PostPosted: Sun Mar 10, 2013 4:01 pm
by Mehdi shri
Yes I do it very much. But now I want only to know How I can find or repair(or remove) bad pointer.
Thanks

Re: How to prevent ABEND 0852?

PostPosted: Sun Mar 10, 2013 4:42 pm
by NicC
Well, I think the third point in Akatsukami's post is your only option. Might not be the only option but certainly the best.

Re: How to prevent ABEND 0852?

PostPosted: Mon Mar 11, 2013 3:59 am
by dick scherrer
Hello,

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

Also recommend Working with your dba.

Re: How to prevent ABEND 0852?

PostPosted: Mon Mar 11, 2013 7:10 pm
by Ed Goodman
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.