212: Cannot add index. 2: No such file or directory.
Posted in 1999
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