Hi Steve, please do a SELECT * FROM SYSTEM.SYSDROP and post the output. Thanks.
Steve_Domarski/[EMAIL PROTECTED] wrote:
I recently had a pool fill up leaving only 20 pages left. I decided to move
some of the DBSpaces to another pool. All went well but the DBSpaces I
moved were not cleared in the "SELECT * FROM SYSTEM.SYSDBSPACES" list for
the pool I took them from. The DBSpaces dropped now have eight NOT symbols
as the owner name and 5 leading spaces and the DBSpaces number as a DBSpace
name. They are no-longer accessible for use. I was able to resolve the
space problem by adding another extent to the pool but the DBSpaces are
still inaccessible.
I found the DBSPNUM startup parm in the Operations guide that indicated
that I needed to use STARTUP mode P and SYSMODE S. I did that for DBSPNUM =
* as well as specific DBSpace numbers no relief.
Does anyone have any other ideas.
Steve Domarski 352-368-8350
Property Appraisers Office Marion County Florida USA
"Great minds discuss Ideas.
Average minds discuss events.
Small minds discuss people. " - Admiral Hyman Rickover
With best regards,
...Roland Chung
Senior Technical Specialist (S/390,VM/VSE,DB2/VSE&VM)
MAXC Consultants Inc.
Voice/Fax: 416-469-3280 (If busy, call: 416-469-2268)
197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6
** Life is short. Stop once in a while and smell the roses. **
