Re: IDS 9.4 instance can't initialize dbspace
Gary Quiring wrote:
> Continuing the saga from my ontape restore to a different server I am
> taking the suggestions to use archecker and IDS 9.4 to do a table
> restore. My current server is 9.4.
> I created an IDS 10 directory and changed all the paths and ENV vars to
> use the new location for an instance. When I try to initialize the new
> instance it chokes on:
> oninit: Not enough room in ROOT DBspace.
> Requested 1017076K, ONCONFIG value 'ROOTSIZE' 1008538K.
> My OS is HP-UX 11 with IDS9.4 UC
> Every time I increase the size it wants more. I increased the size 6
> times and it keeps wanting more space. I reduced my logs to 3 and IDS
> 10 insists on the physical space being the same as the rootsize. No
> matter how big I make the root it wants a little more than I
> configured.
> Onconfig:
> ROOTNAME dbroot # Root dbspace name> ROOTPATH /mnt/data/ids10/ids10root
> ROOTOFFSET 0 # Offset of root dbspace into device
> (Kbytes)
> ROOTSIZE 1008538 # Size of root dbspace (Kbytes)> PHYSDBS dbplog # Location (dbspace) of physical log
> PHYSFILE 1008538 # Physical log file size (Kbytes)
> LOGFILES 3 # Number of logical log files
> LOGSIZE 2500 # Logical log size (Kbytes)> MSGPATH /u/ids10/online.log # System message log file path
> CONSOLE /dev/console # System console message path
> TAPEDEV /dev/null # Tape device path
> TAPEBLK 512 # Tape block size (Kbytes)
> TAPESIZE 10240 # Maximum amount of data to put on tape
> (Kbytes)
> LTAPEDEV /dev/null
> LTAPEBLK 32 # Log tape block size (Kbytes)
> LTAPESIZE 2000 # Max amount of data to put on log tape
> (Kbytes)
> SERVERNUM 1 # Unique id corresponding to a OnLine> instance
> DBSERVERNAME dev1_ids10 # Name of default database server> DBSERVERALIASES dev1_ids10_net # List of alternate dbservernames
> DEADLOCK_TIMEOUT 60 # Max time to wait of lock in> distributed env.
> RESIDENT 1 # Forced residency flag (Yes = 1, No =
> 0)
> NETTYPE ipcshm,3,200,CPU # Configure poll thread(s) for shared> mem
> NETTYPE tlitcp,3,130,NET # Configure poll thread(s) for shared> mem
> MULTIPROCESSOR 1 # 0 for single-processor, 1 for> multi-processor
> NUMCPUVPS 3 # Number of user (cpu) vps
> SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps> to one
> NOAGE 0 # Process aging
> AFF_SPROC 0 # Affinity start processor
> AFF_NPROCS 0 # Affinity number of processors
> # Shared Memory Parameters
> #LOCKS 2000000 # Maximum number of locks
> LOCKS 500000 # Maximum number of locks> #BUFFERS 800000 # Maximum number of shared buffers
> BUFFERS 200000 # Maximum number of shared buffers
> NUMAIOVPS 3 # Number of IO vps
> PHYSBUFF 32 # Physical log buffer size (Kbytes)
> LOGBUFF 32 # Logical log buffer size (Kbytes)
> CLEANERS 1 # Number of buffer cleaner processes
> SHMBASE 0xa000000> #SHMVIRTSIZE 8000 # initial virtual shared memory
> segment size
> SHMVIRTSIZE 16384 # initial virtual shared memory segment> size
> #SHMADD 8192 # Size of new shared memory segments
> (Kbytes)
> SHMADD 12288 # Size of new shared memory segments
> (Kbytes)
> SHMTOTAL 0 # Total shared memory (Kbytes).
> 0=>unlimited
> CKPTINTVL 300 # Check point interval (in sec)
> LRUS 128 # Number of LRU queues
> LRU_MAX_DIRTY 1.000000 # LRU percent dirty begin cleaning limit
> LRU_MIN_DIRTY 0.000000 # LRU percent dirty end cleaning limit
> TXTIMEOUT 0x12c # Transaction timeout (in sec)
> STACKSIZE 32 # Stack size (Kbytes)
> DYNAMIC_LOGS 2
> LTXHWM 70
> LTXEHWM 80