[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| Title: | Informix Conference |
|
| Moderator: | KOLFAX::MCCATHERN |
|
| Created: | Wed Feb 02 1994 |
| Last Modified: | Thu Jun 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 221 |
| Total number of notes: | 620 |
220.0. "Informix crashed 3 times in 2 weeks!!!" by MSAM03::RAHMAN () Wed May 28 1997 12:51
Hi,
I have very serious customer in Malaysia running SAP R3 3.0C on
informix 7.12UC1X8. The machine is 4100 5/400-2, 1GB mem.
Disk subsystem is SW500, HSZ40, BA350JA (3 units) with 4 x RZ29-VA for each.
THe problem is the database crashed 3 times for the last 2 weeks. As indicated
by uerf and online...log, it points to disk failure. OUr MCS enginner has
the disks but the problem happened again. MCS engineer performed dianostic on
the disk and found no problem with the disks. There is no particular pattern
asto which disks this will occur.
Since there are no other possibility i can think of, i suspect that one or two
chunks that exceeded the partition size allocated that had caused the
informix overlapped the data onto the other partition towards the end of the
chunk. If possible please verify if this is the case and this can happen.
sapdata assignment:
lrwxrwxrwx 1 informix informix 11 May 26 23:07 data1 -> /dev/rrz34g
lrwxrwxrwx 1 informix informix 11 May 26 23:07 data2 -> /dev/rrz34h
lrwxrwxrwx 1 informix informix 12 May 26 23:11 data3 -> /dev/rrzb33g
lrwxrwxrwx 1 informix informix 12 May 26 23:11 data4 -> /dev/rrzb33h
lrwxrwxrwx 1 informix informix 12 May 28 22:46 data5 -> /dev/rrzc35g
lrwxrwxrwx 1 informix informix 12 May 28 22:47 data6 -> /dev/rrzc35h
lrwxrwxrwx 1 informix informix 12 May 26 23:15 data7 -> /dev/rrzb34g
lrwxrwxrwx 1 informix informix 12 May 26 23:16 data8 -> /dev/rrzb34h
lrwxrwxrwx 1 informix informix 12 May 26 23:17 data10 -> /dev/rrzc33h
lrwxrwxrwx 1 informix informix 12 May 26 23:17 data9 -> /dev/rrzc33g
lrwxrwxrwx 1 informix informix 11 May 26 23:20 data11 -> /dev/rrz35g
lrwxrwxrwx 1 informix informix 11 May 26 23:20 data12 -> /dev/rrz35h
lrwxrwxrwx 1 informix informix 12 May 26 23:23 data13 -> /dev/rrzc34g
lrwxrwxrwx 1 informix informix 12 May 26 23:23 data14 -> /dev/rrzc34h
Below are the informix onstat -d,
INFORMIX-OnLine Version 7.12.UC1X8 -- On-Line -- Up 14:56:13 -- 217232 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
6a84158 1 2 1 3 M informix rootdbs
6abaa18 2 1 2 1 N informix psapdocu
6abaaa8 3 1 3 2 N informix psapsource
6abab38 4 1 4 3 N informix psapel30c
6ababc8 5 1 5 1 N informix psapddic
6abac58 6 2001 6 1 N T informix tmpdbs1
6abace8 7 1 7 1 N informix psappool
6abad78 8 1 8 5 N informix psapbtab
6abae08 9 1 9 4 N informix psapes30c
6abae98 10 1 10 1 N informix psapload
6abaf28 11 1 11 1 N informix psapprot
6abafb8 12 1 12 5 N informix psapclu
6abb048 13 1 13 1 N informix psapuser1
6abb0d8 14 1 17 2 N informix psapstab
6abb168 15 2 19 2 M informix logdbs
6abb1f8 16 2 20 1 M informix physdbs
16 active, 2047 maximum
Chunks
address chk/dbs offset size free bpages flags pathname
6a841e8 1 1 8 25000 0 PO- /informix/POS/sapdata/physdev1/data1
6a842e0 1 1 8 25000 0 MO- /informix/POS/sapdata/physdev2/data3
6a843d8 2 2 25008 55000 12097 PO- /informix/POS/sapdata/physdev1/data1
6a844d0 3 3 80008 7500 3263 PO- /informix/POS/sapdata/physdev1/data1
6a845c8 4 4 87508 313842 109381 PO- /informix/POS/sapdata/physdev1/data1
6a846c0 5 5 401350 47250 27125 PO- /informix/POS/sapdata/physdev1/data1
6a847b8 6 6 8 1047241 1047188 PO- /informix/POS/sapdata/physdev1/data2
6a848b0 7 7 25008 550512 149363 PO- /informix/POS/sapdata/physdev2/data3
6a849a8 8 8 8 834862 5 PO- /informix/POS/sapdata/physdev2/data4
6a84aa0 9 9 8 1047241 54 PO- /informix/POS/sapdata/physdev3/data6
6a84b98 10 10 8 5000 2647 PO- /informix/POS/sapdata/physdev4/data7
6a84c90 11 11 12508 430937 336982 PO- /informix/POS/sapdata/physdev4/data7
6a84d88 12 12 8 975264 99559 PO- /informix/POS/sapdata/physdev4/data8
6a84e80 13 13 975272 10000 6099 PO- /informix/POS/sapdata/physdev4/data8
6a84f78 14 8 8 1047241 12 PO- /informix/POS/sapdata/physdev5/data9
6a85070 15 8 8 1047241 462834 PO- /informix/POS/sapdata/physdev5/data10
6a85168 16 3 5008 7500 7497 PO- /informix/POS/sapdata/physdev4/data7
6a85260 17 14 8 1047241 6 PO- /informix/POS/sapdata/physdev6/data11
6a85358 18 14 8 1047241 635954 PO- /informix/POS/sapdata/physdev6/data12
6a85450 19 15 8 10492 439 PO- /informix/POS/sapdata/physdev3/data5
6aba540 19 15 465937 10492 0 MO- /informix/POS/sapdata/physdev4/data7
6a85548 20 16 10500 12000 1947 PO- /informix/POS/sapdata/physdev3/data5
6aba638 20 16 453937 12000 0 MO- /informix/POS/sapdata/physdev4/data7
6a85640 21 9 585212 462000 352097 PO- /informix/POS/sapdata/physdev3/data5
6a85738 22 1 448600 5000 0 PO- /informix/POS/sapdata/physdev1/data1
6aba730 22 1 575520 5000 0 MO- /informix/POS/sapdata/physdev2/data3
6a85830 23 1 453600 195000 176605 PO- /informix/POS/sapdata/physdev1/data1
6aba828 23 1 834870 195000 0 MO- /informix/POS/sapdata/physdev2/data4
6a85928 24 15 22500 175000 4997 PO- /informix/POS/sapdata/physdev3/data5
6aba920 24 15 476429 175000 0 MO- /informix/POS/sapdata/physdev4/data7
6a85a20 25 8 985272 50000 49997 PO- /informix/POS/sapdata/physdev4/data8
6a85b18 26 12 1035272 10000 9997 PO- /informix/POS/sapdata/physdev4/data8
6a85c10 27 12 1045272 1975 1972 PO- /informix/POS/sapdata/physdev4/data8
6a85d08 28 8 8 349992 349989 PO- /informix/POS/sapdata/physdev7/data13
6a85e00 29 12 651429 100000 99997 PO- /informix/POS/sapdata/physdev4/data7
6a85ef8 30 9 350000 1250 1247 PO- /informix/POS/sapdata/physdev7/data13
6aba448 31 4 8 992 989 PO- /informix/POS/sapdata/physdev7/data14
31 active, 2047 maximum
DISK LAYOUT from disklabel command:
-----------------------------------------------------
# /dev/rrzb33c:
type: SCSI
disk: HSZ40
label:
flags:
bytes/sector: 512
sectors/track: 113
tracks/cylinder: 20
sectors/cylinder: 2260
cylinders: 3708
sectors/unit: 8378028
rpm: 3600
interleave: 1
trackskew: 0
cylinderskew: 0
headswitch: 0 # milliseconds
track-to-track seek: 0 # milliseconds
drivedata: 0
8 partitions:
# size offset fstype [fsize bsize cpg]
a: 32 0 unused 1024 8192 # (Cyl. 0 - 0*)
b: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
c: 8378028 0 unused 1024 8192 # (Cyl. 0 - 3707*)
d: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
e: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
f: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
g: 4188998 32 unused 1024 8192 # (Cyl. 0*- 1853*)
h: 4188998 4189030 unused 1024 8192 # (Cyl. 1853*- 3707*)
-----------------------------------------------------
# /dev/rrzc33c:
type: SCSI
disk: HSZ40
label:
flags:
bytes/sector: 512
sectors/track: 113
tracks/cylinder: 20
sectors/cylinder: 2260
cylinders: 3707
sectors/unit: 8378028
rpm: 3600
interleave: 1
trackskew: 0
cylinderskew: 0
headswitch: 0 # milliseconds
track-to-track seek: 0 # milliseconds
drivedata: 0
8 partitions:
# size offset fstype [fsize bsize cpg]
a: 32 0 unused 1024 8192 # (Cyl. 0 - 0*)
b: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
c: 8378028 0 unused 1024 8192 # (Cyl. 0 - 3707*)
d: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
e: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
f: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
g: 4188998 32 unused 1024 8192 # (Cyl. 0*- 1853*)
h: 4188998 4189030 unused 1024 8192 # (Cyl. 1853*- 3707*)
-----------------------------------------------------
# /dev/rrz34c:
type: SCSI
disk: HSZ40
label:
flags:
bytes/sector: 512
sectors/track: 113
tracks/cylinder: 20
sectors/cylinder: 2260
cylinders: 3707
sectors/unit: 8378028
rpm: 3600
interleave: 1
trackskew: 0
cylinderskew: 0
headswitch: 0 # milliseconds
track-to-track seek: 0 # milliseconds
drivedata: 0
8 partitions:
# size offset fstype [fsize bsize cpg]
a: 32 0 unused 1024 8192 # (Cyl. 0 - 0*)
b: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
c: 8378028 0 unused 1024 8192 # (Cyl. 0 - 3707*)
d: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
e: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
f: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
g: 4188998 32 unused 1024 8192 # (Cyl. 0*- 1853*)
h: 4188998 4189030 unused 1024 8192 # (Cyl. 1853*- 3707*)
-----------------------------------------------------
# /dev/rrzb34c:
type: SCSI
disk: HSZ40
label:
flags:
bytes/sector: 512
sectors/track: 113
tracks/cylinder: 20
sectors/cylinder: 2260
cylinders: 3707
sectors/unit: 8378028
rpm: 3600
interleave: 1
trackskew: 0
cylinderskew: 0
headswitch: 0 # milliseconds
track-to-track seek: 0 # milliseconds
drivedata: 0
8 partitions:
# size offset fstype [fsize bsize cpg]
a: 32 0 unused 1024 8192 # (Cyl. 0 - 0*)
b: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
c: 8378028 0 unused 1024 8192 # (Cyl. 0 - 3707*)
d: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
e: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
f: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
g: 4188998 32 unused 1024 8192 # (Cyl. 0*- 1853*)
h: 4188998 4189030 unused 1024 8192 # (Cyl. 1853*- 3707*)
-----------------------------------------------------
# /dev/rrzc34c:
type: SCSI
disk: HSZ40
label:
flags: dynamic_geometry
bytes/sector: 512
sectors/track: 113
tracks/cylinder: 20
sectors/cylinder: 2260
cylinders: 3707
sectors/unit: 8378028
rpm: 3600
interleave: 1
trackskew: 0
cylinderskew: 0
headswitch: 0 # milliseconds
track-to-track seek: 0 # milliseconds
drivedata: 0
8 partitions:
# size offset fstype [fsize bsize cpg]
a: 131072 0 unused 1024 8192 # (Cyl. 0 - 57*)
b: 262144 131072 unused 1024 8192 # (Cyl. 57*- 173*)
c: 8378028 0 unused 1024 8192 # (Cyl. 0 - 3707*)
d: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
e: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
f: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
g: 4188998 32 unused 1024 8192 # (Cyl. 0*- 1853*)
h: 4188998 4189030 unused 1024 8192 # (Cyl. 1853*- 3707*)
-----------------------------------------------------
# /dev/rrz35c:
type: SCSI
disk: HSZ40
label:
flags: dynamic_geometry
bytes/sector: 512
sectors/track: 113
tracks/cylinder: 20
sectors/cylinder: 2260
cylinders: 3707
sectors/unit: 8378028
rpm: 3600
interleave: 1
trackskew: 0
cylinderskew: 0
headswitch: 0 # milliseconds
track-to-track seek: 0 # milliseconds
drivedata: 0
8 partitions:
# size offset fstype [fsize bsize cpg]
a: 131072 0 unused 1024 8192 # (Cyl. 0 - 57*)
b: 262144 131072 unused 1024 8192 # (Cyl. 57*- 173*)
c: 8378028 0 unused 1024 8192 # (Cyl. 0 - 3707*)
d: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
e: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
f: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
g: 4188998 32 unused 1024 8192 # (Cyl. 0*- 1853*)
h: 4188998 4189030 unused 1024 8192 # (Cyl. 1853*- 3707*)
-----------------------------------------------------
# /dev/rrzb35c:
type: SCSI
disk: HSZ40
label:
flags: dynamic_geometry
bytes/sector: 512
sectors/track: 113
tracks/cylinder: 20
sectors/cylinder: 2260
cylinders: 3707
sectors/unit: 8378028
rpm: 3600
interleave: 1
trackskew: 0
cylinderskew: 0
headswitch: 0 # milliseconds
track-to-track seek: 0 # milliseconds
drivedata: 0
8 partitions:
# size offset fstype [fsize bsize cpg]
a: 131072 0 unused 1024 8192 # (Cyl. 0 - 57*)
b: 262144 131072 unused 1024 8192 # (Cyl. 57*- 173*)
c: 8378028 0 unused 1024 8192 # (Cyl. 0 - 3707*)
d: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
e: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
f: 0 0 unused 1024 8192 # (Cyl. 0 - -1)
g: 4188998 32 unused 1024 8192 # (Cyl. 0*- 1853*)
h: 4188998 4189030 unused 1024 8192 # (Cyl. 1853*- 3707*)
-----------------------------------------------------
| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 220.1 | | EVTAI1::SAMIE_F | francoise [email protected] | Thu Jun 05 1997 09:36 | 9 |
| Overlaps can be detected by oncheck -ce or -pe
May be you have another problem. Are you running Dunix 4.0x? If so, have you set
vm parameter new-wire-method = 0 ?
Please give us an extract of the online message log
Francoise
|