Skip to main content

developerWorks >  Information Management  >  Forums  >  DB2 for z/OS forum  >  developerWorks

help me please i have a problem in restricted DB    Point your RSS reader here for a feed of the latest messages in this thread


     

 
 

My developerWorks
 Welcome, Guest
Sign in or register
This question is not answered.

Permlink Replies: 5 - Pages: 1 - Last Post: Nov 18, 2009 8:10 AM Last Post By: SDas Threads: [ Previous | Next ]
eng.mahmoudabbas

Posts: 3
Registered: Nov 11, 2009 06:58:51 AM
help me please i have a problem in restricted DB
Posted: Nov 11, 2009 07:01:25 AM
 
Click to report abuse...   Click to reply to this thread Reply
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
eng.mahmoudabbas

Posts: 3
Registered: Nov 11, 2009 06:58:51 AM
Re: help me please i have a problem in restricted DB
Posted: Nov 12, 2009 05:53:51 AM   in response to: eng.mahmoudabbas in response to: eng.mahmoudabbas's post
 
Click to report abuse...   Click to reply to this thread Reply
Attachment photos.rar (126.5 KB)
These images to clarify
this pictures Respectively
momi

Posts: 87
Registered: Jan 07, 2007 10:49:29 AM
Re: help me please i have a problem in restricted DB
Posted: Nov 16, 2009 02:22:04 AM   in response to: eng.mahmoudabbas in response to: eng.mahmoudabbas's post
 
Click to report abuse...   Click to reply to this thread Reply
Hi

I can't see your photos right now, but maybe the problem is that the database itself is in restricted state, and not a specific tablespace.
One can stop a database by using
-stop db(a)
this will not change the tablesapces status, although, none of them will be available
maybe that is the reason you get the funny output
try
-start db(a)
-dis db(*) sp(*) res

and see if that solves your problem
eng.mahmoudabbas

Posts: 3
Registered: Nov 11, 2009 06:58:51 AM
Re: help me please i have a problem in restricted DB
Posted: Nov 17, 2009 08:59:43 AM   in response to: momi in response to: momi's post
 
Click to report abuse...   Click to reply to this thread Reply
THANKS A LOT BUT
I tried run reorg utility and stop & start DB , but did not get any change
momi

Posts: 87
Registered: Jan 07, 2007 10:49:29 AM
Re: help me please i have a problem in restricted DB
Posted: Nov 18, 2009 03:11:54 AM   in response to: eng.mahmoudabbas in response to: eng.mahmoudabbas's post
 
Click to report abuse...   Click to reply to this thread Reply
Hi
can you post here the commands you run and their output?
Valued Contributor SDas

Posts: 239
Registered: Jul 23, 2008 01:24:04 PM
Re: help me please i have a problem in restricted DB
Posted: Nov 18, 2009 08:10:36 AM   in response to: eng.mahmoudabbas in response to: eng.mahmoudabbas's post
 
Click to report abuse...   Click to reply to this thread Reply
eng.mahmoudabbas, I can't open the RAR attachment, but if this is the same problem you posted in another forum (where I could see the attachments), then yout databases are not in a restricted status. The two (slightly) different commands

DIS DB(*) SP (*) res
DIS DB(A) SP (*) res

have (slightly) different output formats but both show the database in RW status with no restrictions. You might be misinterpreting the RESTRICTED in the output 'header' as indicating they are restricted but this is just informing you of the type of report that is being displayed.
 Tags
Help

Use the search field to find all types of content in My developerWorks with that tag.

Use the slider bar to see more or fewer tags.

Popular tags shows the top tags for this particular type of content or application that you're viewing.

My tags shows your tags for this particular type of content or application that you're viewing.

 

MoreLess 


Point your RSS reader here for a feed of the latest messages in all forums