i have a problem in restricted DB on mainframe
when i write command "DIS DB(*) SP (*) res"
it's show a particular database let's name (A)
when i write command "DIS DB(A) SP (*) res"
it's show "no spaces found " at the same time the name of the DB remains restricted at the top of the screen.
why?and the solution to remove this restricted of DB

note: i am using db2 v8

THANKS FOR ANY HELP

mahmoudabbas, can you show the output of both commands?

this pictures Respectively

mahmoudabbas, neither of the displays shows database DIVORCE in a restricted status. Both displays show its status at RW.

I think you might be talking about where it says restricted in the comment line near top of page??? That means you asked for objects that were in restricted mode, so you get the restricted header message, but the content of that report shows nothing is restricted. So, you have no problem with your DIVORCE database.

Dave Nance

thanks for you
but I know it did not cause any problem
and this the only database that shows all the time at status = RW but no one does not know why.
why?

RW is the status that you typically want all of your databases to be in. That means the database is open for Read/Write activity. It will only go out of that status if you run a utility of some type against it or start it in some other status such as RO (Read Only). Either you are making a big deal about your database always being operational or you are not explaining your situation correctly.
Dave Nance

THANKS A LOT BUT
I tried run reorg utility and stop & start DB , but did not get any change

change from RW? How about explaining exactly what you are after here? From what we have gone over thus far it does not seem that you have any issue at all.

Dave Nance