212: Cannot add index. 2: No such file or directory.
Posted in 1999
Topics: Storage & Space Management, Server Administration, Transactions, Locking & Isolation, Logging & Checkpoints, Networking & sqlhosts Configuration, Versions, Editions & End-of-Life
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BF2D73.25F95750
Content-Type: text/plain;
charset="iso-8859-1"
well here is the weekend and I am getting this.
any help with params in the onconfig would be appreciated.
thanks in advance.
dgux av3650 R4.20MU05 generic AViiON PentiumPro IDS 7.31.UC2
-->
CREATE INDEX sdh_idx_3 ON ship_det_hist (
sd_bol_num ASC
) IN prd_dbs_idx1 ;
212: Cannot add index. 2: No such file or directory.sysadm:
-->Name Volume Temp Size Type
+cdpad V 107 partition on
sd(apsc(pci(1),B,0,7),5,0)
+release V 541024 partition on
sd(apsc(pci(1),B,0,7),5,0)
+root V 23000 partition on
sd(apsc(pci(1),B,0,7),5,0)
+usr V 4500 partition on
sd(apsc(pci(1),B,0,7),5,0)
dbfile V 702602 partition on disk(RAID_5_0)
dbtmp V 270000 partition on disk(RAID_5_0)
dev_data1_chunk V 4000016 partition on disk(RAID_5_0)
dev_idx1_chunk V 4000016 partition on disk(RAID_5_0)
dev_log1_chunk V 1000016 partition on disk(RAID_1_0)
dev_root1_chunk V 500016 partition on disk(RAID_1_0)
dev_sort1 V 300000 partition on disk(RAID_5_0)
dev_sort2 V 300000 partition on disk(RAID_5_0)
dev_sort3 V 300000 partition on disk(RAID_5_0)
dev_temp1_chunk V 400016 partition on disk(RAID_5_0)
dev_temp2_chunk V 400016 partition on disk(RAID_5_0)
dev_temp3_chunk V 400016 partition on disk(RAID_5_0)
dump V 262000 partition on disk(RAID_1_0)
home V 508000 partition on disk(RAID_5_0)
informix V 1272000 aggregation of 4 pieces
prd_data1_chunk V 4000016 partition on disk(RAID_5_0)
prd_idx1_chunk V 4000016 partition on disk(RAID_5_0)
prd_log1_chunk V 1000016 aggregation of 2 pieces
prd_root1_chunk V 500016 partition on disk(RAID_1_0)
prd_temp1_chunk V 400016 partition on disk(RAID_5_0)
prd_temp2_chunk V 400016 partition on disk(RAID_5_0)
prd_temp3_chunk V 400016 partition on disk(RAID_5_0)
prdsort1 V 300000 partition on disk(RAID_5_0)
prdsort2 V 300000 partition on disk(RAID_5_0)
prdsort3 V 300000 partition on disk(RAID_5_0)
root V 100000 partition on disk(RAID_1_0)
scratch V 849970 partition on disk(RAID_5_0)
swap V 1572864 partition on disk(RAID_1_0)
tmp V 816000 partition on disk(RAID_5_0)
usr V 708000 aggregation of 2 pieces
usr_opt_X11 V 180000 aggregation of 3 pieces
usr_opt_cddoc V 100000 partition on disk(RAID_1_0)
usr_opt_dgisd V 20000 partition on disk(RAID_1_0)
usr_opt_networker V 90000 aggregation of 2 pieces
usr_opt_sdk V 100000 aggregation of 2 pieces
var V 650000 aggregation of 3 pieces
var_opt_networker V 50000 aggregation of 2 pieces
wmsdev V 599960 aggregation of 2 pieces
wmsprod V 399984 partition on disk(RAID_5_0)
disk(RAID_1_0) 8205750 physical for
sd(apsc(pci(1),F,0,7),0,1)
disk(RAID_5_0) 32822784 physical for
sd(apsc(pci(1),F,0,7),0,0)
sd(apsc(pci(1),B,0,7),5,0) 571512 physical for
sd(apsc(pci(1),B,0,7),5,0)
-->
onconfig:
ROOTNAME prd_dbs_root # Root dbspace name
ROOTPATH /usr/informix/prd/cur_ver/links/prd_root1_chunk
ROOTOFFSET 4 # Offset of root dbspace into device
(Kbytes)
ROOTSIZE 122000 # Size of root dbspace (Kbytes)MIRROR 1 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing mirrored root
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)PHYSDBS prd_dbs_log1 # Location (dbspace) of physical log
#PHYSDBS prd_dbs_root # Location (dbspace) of physical log
PHYSFILE 3750 # Physical log file size (Kbytes)
LOGFILES 16 # Number of logical log files
LOGSIZE 7500 # Logical log size (Kbytes)
MSGPATH /usr/informix/logs/online_prd.log
CONSOLE /dev/console # System console message path
ALARMPROGRAM /usr/informix/prd/cur_ver/etc/log_full.sh
#ALARMPROGRAM /usr/informix/prd/cur_ver/etc/no_log.sh
SYSALARMPROGRAM /usr/informix/prd/cur_ver/etc/evidence.sh
TBLSPACE_STATS 1
#TAPEDEV /dev/rmt/0 # Tape device path
TAPEDEV /dev/null # Tape device path
TAPEBLK 16 # Tape block size (Kbytes)
TAPESIZE 2000000 # Maximum amount of data to put on tape
LTAPEDEV /dev/null #Log tape device path
#LTAPEDEV /dev/rmt/0 #Log tape device path
LTAPEBLK 16 # Log tape block size (Kbytes)
LTAPESIZE 3010000 # Max amount of data to put on logSTAGEBLOB # Informix Dynamic Server/Optical
SERVERNUM 1 # Unique id corresponding to a Dynamic
DBSERVERNAME wms_prd # Name of default database serverDBSERVERALIASES wms_prd_tcp # List of alternate dbservernames
NETTYPE tlitcp,2,100,NET # Configure poll thread(s) for nettype
NETTYPE ipcshm,2,100,CPU # Configure poll thread(s) for nettype
DEADLOCK_TIMEOUT 60 # Max time to wait of lock in
RESIDENT 0 # Forced residency flag
MULTIPROCESSOR 1 # 0 for single-processor, 1 for
NUMCPUVPS 2 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu
NOAGE 0 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 2 # Affinity number of processors
LOCKS 150000 # Maximum number of locks
BUFFERS 30000 # Maximum number of shared buffers
NUMAIOVPS 2 # Number of IO vps
PHYSBUFF 128 # Physical log buffer size (Kbytes)
LOGBUFF 128 # Logical log buffer size (Kbytes)LOGSMAX 50 # Maximum number of logical log files
CLEANERS 8 # Number of buffer cleaner processes
SHMBASE 0x20000000 # Shared memory base address
SHMVIRTSIZE 71680 # initial virtual shared memory
SHMADD 10240 # Size of new shared memory segments
SHMTOTAL 0 # Total shared memory
Related threads
- Conversion to differeent characters sets
- Control of CLIENT_LOCALE and DB_LOCALE at connection (doc issue?)
- Problem in changing locale via dbexport/dbimport
- Re: Matches not Work in 7.30
- DATABASE vs CONNECT TO: Invalid characters error?