| View previous topic :: View next topic |
| Author |
Message |
deepa12
Beginner
Joined: 05 Apr 2005
Posts: 131
Topics: 64
Location: chennai
|
 Posted: Mon Feb 13, 2006 3:39 am Post subject: re. a table space in RO status |
 |
|
I have a SEGMENTED tablespace SEGSIZE=4
It is in readonly status
It is not in checkpending or any pending status.
Pls tell me how to make the table space readwrite
_________________
deepa |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Mon Feb 13, 2006 8:32 am Post subject: |
|
|
deepa12,
You can use START DATABASE command to set the tablespace in read write mode. If you have authority you can issue the following command from option 7 from DB2I primary option menu.
| Code: |
-START DATABASE (dbname) SPACENAM (tablespacename) ACCESS (RW)
|
Hope this helps...
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
Manudamodar
Beginner
Joined: 10 Feb 2006
Posts: 7
Topics: 3
|
| Posted: Mon Feb 13, 2006 12:18 pm Post subject: Re: re. a table space in RO status |
|
|
| deepa12 wrote: | I have a SEGMENTED tablespace SEGSIZE=4
It is in readonly status
It is not in checkpending or any pending status.
Pls tell me how to make the table space readwrite |
Deepa
You can also use Repair utility with 'NO CHECK PEND' option to remove the check pending status |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Mon Feb 13, 2006 12:30 pm Post subject: |
|
|
Manudamodar,
Did you read deepa's post clearly ? I guess you missed this line
| Quote: |
It is not in checkpending or any pending status.
|
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
Manudamodar
Beginner
Joined: 10 Feb 2006
Posts: 7
Topics: 3
|
| Posted: Mon Feb 13, 2006 5:09 pm Post subject: |
|
|
| kolusu wrote: | Manudamodar,
Did you read deepa's post clearly ? I guess you missed this line
| Quote: |
It is not in checkpending or any pending status.
|
Kolusu |
Oops !!! Thats right kolusu!!! I misread the post..Tx again for correcting.. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
