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
