ERROR-136, RESTORE DATABASE ONLINE NOT PERMITTED

, , ,
1

Hello all,

I am trying to restore a database and want to make sure I have all the pieces and parts.
The SDSF hold queue had a run of a restore that ran clean.
I did a sj to get the original JCL. Now I am trying to verify the JCL work again.
I am getting this error:

ERROR-136, RESTORE DATABASE ONLINE NOT PERMITTED

What do I need to do to take the database off line?
Could it be that the backup file was used once and the restore was clean that the Database is smart enough that I don’t need to do another restore?

Thank you

2

You “take the database offline” by stopping the job or STC with either

P <taskname>

or

F <taskname>,ADAEND

where is the job- or STC name.

3

Thank you Wolfgang,
I am getting the following in my log file:

ADAEXIT2 0000104 CALLED FOR PLOG, FLAGS=X’4040’ RETURN TO NUCLEUS

It just seems to repeat.

Seems to me that the task need to end or get purged from the system.
How can I do that?

Steve

4

I need to add that this is causing a beep on the console in ops.
It is driving them a little crazy that is not a long road.

5

I found the log switch jcl.

6

Sorry for being late to reply, just one thing to add then - there are user exits (UEX2 for dual logs and UEX12 for multi-logs) to automatically submit the log save/switch JCL.