IBM Mainframe Forum

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.

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.

Dear Akatsukami
How I can reload data base when I can't unload it?

Presumably you backed it up after the initiai load? Or you still have the initial load data?

I have not any backup from this database.

Now you know why you should back things up.

Have you actually tried unloading the database?

Yes I do it very much. But now I want only to know How I can find or repair(or remove) bad pointer.
Thanks

Well, I think the third point in Akatsukami's post is your only option. Might not be the only option but certainly the best.

Hello,

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

Also recommend Working with your dba.

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.