RE: Data Erased-- Please help
If you initialized disk space, then all the data is gone . . . . Informix
initialized all the internal data structures which keep track of where (and
what) everything is.
Sorry.
> -----Original Message-----
> From: Raj [mailto:r411@hotmail.com]
> Sent: Thursday, July 20, 2000 9:26 AM
> To: informix-list@iiug.org
> Subject: Data Erased-- Please help
>
>
> Hi,
> I am trying to make a temp db space using the command
> onspaces -d
> tempdbs1 -t -p /usasdb/tempdbs1 -o 8 -s 500000. It came back with> memory segment fault, and produced a core dump and said
> shared memory not
> initialized. Then I used onmonitor and it came back saying I have to
> initilizae diskspace. I said yes, and all of my data was
> gone. How can I
> get the data back? I am using coldfusion as a front end and
> it cannot find
> the data source.
> We are using solaris 2.6, INFORMIX-OnLine Version 7.24.UC2.
> and my onconfig file is.
>
> #*************************************************************
> *************
> #
> # INFORMIX SOFTWARE, INC.
> #
> # Title: onconfig.std
> # Description: INFORMIX-OnLine Configuration Parameters
> #
> #*************************************************************
> *************
>
> # Root Dbspace Configuration
>
> ROOTNAME rootdbs # Root dbspace name> ROOTPATH /usasdb/root_chunk # Path for device
> containing root dbspace
> ROOTOFFSET 0 # Offset of root dbspace into device
> (Kbytes)
> ROOTSIZE 500000 # Size of root dbspace (Kbytes)>
> # Disk Mirroring Configuration Parameters
>
> MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
> MIRRORPATH # Path for device containing> mirrored root
> MIRROROFFSET 0 # Offset into mirrored device (Kbytes)>
> # Physical Log Configuration
>
> PHYSDBS rootdbs # Location (dbspace) of physical log
> PHYSFILE 1000 # Physical log file size (Kbytes)>
> # Logical Log Configuration
>
> LOGFILES 6 # Number of logical log files
> LOGSIZE 500 # Logical log size (Kbytes)>
> # Diagnostics
>
> MSGPATH /usasdata/informix/online.log # System
> message log file path
> CONSOLE /dev/console # System console message path
> ALARMPROGRAM /usasdata/informix/etc/no_log.sh # Alarm program path
> #ALARMPROGRAM /usasdata/informix/etc/log_full.sh # Alarm> program path
> TBLSPACE_STATS 1>
> # System Archive Tape Device
>
> TAPEDEV /dev/null # Tape device path
> TAPEBLK 16 # Tape block size (Kbytes)
> TAPESIZE 10240 # Maximum amount of data to> put on tape
> (Kbytes)
>
> # Log Archive Tape Device
>
> LTAPEDEV /dev/null # Log tape device path
> LTAPEBLK 16 # Log tape block size (Kbytes)
> LTAPESIZE 10240 # Max amount of data to put> on log tape
> (Kbytes)
>
> # Optical
>
> STAGEBLOB # INFORMIX-OnLine/Optical staging area
>
> # System Configuration
>
> SERVERNUM 0 # Unique id corresponding to a OnLine> instance
> DBSERVERNAME usassvr # Name of default database server
> DBSERVERALIASES usassvrtli # List of alternate dbservernames
> DEADLOCK_TIMEOUT 60 # Max time to wait of lock> in distributed
> env.
> RESIDENT 0 # Forced residency flag (Yes
> = 1, No = 0)
>
> MULTIPROCESSOR 0 # 0 for single-processor, 1 for> multi-processor
> NUMCPUVPS 1 # 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 20000 # Maximum number of locks
> BUFFERS 1000 # Maximum number of shared buffers
> NUMAIOVPS # Number of IO vps
> PHYSBUFF 32 # Physical log buffer size (Kbytes)
> LOGBUFF 32 # Logical log buffer size (Kbytes)> LOGSMAX 6 # Maximum number of logical log files
> CLEANERS 1 # Number of buffer cleaner processes
> SHMBASE 0xa000000 # Shared memory base address
> SHMVIRTSIZE 8000 # initial virtual shared> memory segment size
> SHMADD 8192 # Size of new shared memory segments
> (Kbytes)
> SHMTOTAL 0 # Total shared memory
> (Kbytes). 0=>unlimited
> CKPTINTVL 300 # Check point interval (in sec)
> LRUS 8 # Number of LRU queues
> LRU_MAX_DIRTY 60 # LRU percent dirty begin> cleaning limit
> LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit
> LTXHWM 50 # Long transaction high water mark> percentage
> LTXEHWM 60 # Long transaction high water mark
> (exclusive)
> TXTIMEOUT 0x12c # Transaction timeout (in sec)
> STACKSIZE 32 # Stack size (Kbytes)>
> # System Page Size
> # BUFFSIZE - OnLine no longer supports this configuration parameter.
> # To determine the page size used by OnLine on
> your platform
> # see the last line of output from the command,
> 'onstat -b'.
>
>
> # Recovery Variables
> # OFF_RECVRY_THREADS:
> # Number of parallel worker threads during fast recovery or an offline
> restore.
> # ON_RECVRY_THREADS:
> # Number of parallel worker threads during an online restore.
>
> OFF_RECVRY_THREADS 10 # Default number of offline worker> threads
> ON_RECVRY_THREADS 1 # Default number of online> worker threads
>
> # Data Replication Variables
> # DRAUTO: 0 manual, 1 retain type, 2 reverse type
> DRAUTO 0 # DR automatic switchover
> DRINTERVAL 30 # DR max time between DR> buffer flushes (in
> sec)
> DRTIMEOUT 30 # DR network timeout (in sec)
> DRLOSTFOUND /usasdata/informix/etc/dr.lostfound # DR> lost+found file
> path
>
> # CDR Variables
> CDR_LOGBUFFERS 2048 # size of log reading buffer
> pool (Kbytes)
> CDR_EVALTHREADS 1,2 # evaluator threads
> (per-cpu-vp,additional)
> CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)
> CDR_QUEUEMEM 4096 # Maximum amount of memory> for any CDR queue
> (Kbytes)
>
> # Backup/Restore variables
> BAR_ACT_LOG /tmp/bar_act.log
> BAR_MAX_BACKUP 0
> BAR_RETRY 1
> BAR_NB_XPORT_COUNT 10
> BAR_XFER_BUF_SIZE 31>
> # Read Ahead Variables
> RA_PAGES # Number of pages to attempt> to read ahead
> RA_THRESHOLD # Number of pages left before> nex