RE: Disabled Temp DBspace -- Revisited
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_000_01BCD560.410A6BF0
Content-Type: text/plain
Thanks, June.
We are currently testing out 7.23.FC1/FC4 on our development box -- it's
supposed to solve several problems for us; I guess this will be one more
that it solves!
=============================
Paul Mosser, Consulting DBA
Wells Fargo Bank
mosserp@wellsfargo.com
} ----------
} From: junet@informix.com
} Sent: Friday, October 10, 1997 5:31 AM
} To: informix-list@rmy.emory.edu
} Subject: Re: Disabled Temp DBspace -- Revisited
}
} mosserp@wellsfargo.com wrote:
} : We're running ODS 7.20.UC3 on a DEC 8200, O/S version 3.2.
}
} : The interesting part:
} : Browsing thru dejanews, I found that someone else had this problem
} over
} : a YEAR ago
} : on an AIX 4.1 platform w/ ODS 7.12.UC2. There was speculation then
} that
} : the problem
} : would be fixed in 7.2x. Obviously, it has not been fixed, at least
} not
} : on the DEC platform.
}
} Well, 7.20 has been out for more than a year (June 1996, as close as I
} can
} figure it). If you want a fix to a bug that was found a year ago, you
} have
} to get a version that was released less than a year ago. Your bug has
} been
} fixed in 7.14 and 7.21. FYI, 7.22 has been available on DEC since
} April.
}
} Maintenance on 7.1x and 7.2x goes on in parallel, therefore bugs that
} are
} fixed in 7.13, 7.14, etc may not be fixed in 7.20, 7.21, etc.
}
} : 15:22:56 Assert Failed: WARNING! pthdrpage:ptalloc:bad partn page
} : 15:22:56 Who: Session(24, informix@infx_srvr, 0, 97903240)
} : Thread(56, xchg_1.4, 5d32218, 3)
} : 15:22:56 Results: Cannot use TBLSpace page for TBLSpace 11534374
} : 15:22:56 Action: Run 'oncheck -pt 11534374'
}
} : <<< NOTE: Here's where the real problem began.
} : <<< This "oncheck" just gave us:
} : <<< Error opening TBLspace b00026. ??????
}
} Yes, because this was a temporary table, and therefore no longer
} exists.
} The bug is that some activity in your tempdbs was logged, and
} therefore,
} during recovery, OnLine tries to roll forward operations on a table
} that
} is no longer there.
}
} June
}
} ---- June Tong Informix Software
} ----
} ---- Senior Consultant (650) 926-6140
} ----
} ---- International Support junet@informix.com
} ----
} ---- Location-du-jour: Ashford, England
} ----
} *
} * Standard disclaimers apply
} *
} - Please do not send me requests/questions by mail. When I have the
} knowledge
} - and time permits, I try to answer questions on
} comp.databases.informix, but
} - travel schedule, time, and volume make responding to personal
} requests
} - difficult and often slow. Please call your local Informix Technical
} Support
} - organization for assistance with technical issues.
}
------ =_NextPart_000_01BCD560.410A6BF0
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IhkQAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQSAAQAnAAAAUkU6IERpc2FibGVkIFRlbXAgREJzcGFjZSAtLSBS
ZXZpc2l0ZWQAugwBCYABACEAAAAwNzRERjhCRDdENDFEMTExQTU3ODAwMDA4MzdFQkEwNwAQBwEg
gAMADgAAAM0HCgAKAAkAJgAYAAUANAEBBYADAA4AAADNBwoACgAJACIADwAFACcBAQ2ABAACAAAA
AgACAAEDkAYAdAsAABwAAAADAC4AAAAAAEAAOQBgUOZYmtW8AR4AcAABAAAAIwAAAERpc2FibGVk
IFRlbXAgREJzcGFjZSAtLSBSZXZpc2l0ZWQAAAIBcQABAAAAGwAAAAG81ZZdSb2F8j5BexHRk20A
APhFsgoAAMYYkgACAQkQAQAAAEcIAABDCAAATg4AAExaRnWZkxOv/wAKAQ8CFQKkA+QF6wKDAFAT
A1QCAGNoCsBzZXRuMgYABsMCgzIERgIAcHBycTEgCFUHsgKDMxcDxgcTAoM0D3poZWzRAyBEbGcC
gH0KgAjPxQnZOxhvMjU1AoAKgYMNsQtgbmcxMDMU8JcLChLxC/JjAEAgVBHAAG5rcywgSnVujGUu
CoUKhVdlIArAHR8QYwhwGHACMGx5IMp0B5B0C4BnIAhgBUAANy4yMy5GQzG6LyEgNCCAA6AIYSAN
sLJ2FwBvcAeAAjAgBuAAeCAtLSBpdCdBBCBzdXBwbxHwZH0gAG8jgAbwIjAjgCIhcpUHQCAToG8C
YGVtBCADAhAFwHVzOyBJIKZnClAEEXRoBAAgA/D9FxFiHxACIB8QBGAfQSbAzmEFQCNAJERzIQqP
HHXsMTgdAykVPSt/LDkpFWhQYXUDIE0j0BHwch8dsAhQAIAt0CBDREJBVx6XFxAEIEYKwGckMEKP
HXEpFQRgLiJwQHcv4upmMEIuBaBtKR8cfB4sKQr0bGkqkDAC0WkteDE0NA3wDNA2cwtZMe42MsAD
YCAQYwVAIxA4lq8ypzdLDDA4FkYDYTo5npM4FgyCIGod4XRAC4DxJcFtaXgyaznPODQGYA8CMDt/
PIs7MGlkYXl9HbBPOGAlUBRBG5AdsDGAOTk3IDU6MxPQzEFNPn86TVRvQL88iy09ti010CAwQD3w
eS5nJYAFsEmRZHVEnz+OdZxiajhRRr88i1JlTLBeRAQAAaAlcCQAVCWAcHUvIXMy0GMfECMRTpB2
nwQAI0AJgDSfNaMzNjcX/xTyHOM3ETglMU8yUycAOCKuOjKlTLAfACcfQXId4DMDACBhT0QF8CDR
MC4oVUMzIZJhFzBFQ8wgOAHQQ6FPLwXwJNH3AJAhoSEAMh4dTLAdUB8QfwuAIBAYcCA0MtFMoFYH
Qn0DYHcAkCBhJsBW8CIBav8AcAfQHaEmQAIQHeAkASgy3yRQB4AnkhcAEfAgEcBe8j8m4SU1IIAk
0VYHWHBZRXxBUh8gMGBWB1hCA6BB4ElYIDQuE9ALUQAw6z3hJwAvV2UxWhBYAFoQpiBbIh9Bd2Ej
cXAFkP8t0ChAWbImwAnwKBNWB2cx6yUmVgd3CGBsJAAnYTZAPngj8QuAIMI+IGWwT2L7UIAIYHMf
4B2wKHERwAQg/m44MCdRZ1FqIx2wKEElcP9mQAVAbEFiumhSWJJkJh4f/xcQHbBXsmvzbIMgkiXC
J9ZtWFJ5bYAFwCgd0kPCNnttIQQgYxgAYAFmQSZAY78AcDKlNkAmYB9BI0ApZaH8SWZzIAhgZiEi
oVhwaiHzJBJYcGJ1XYIoQWYyXrT/cxVigR2wdsIRwCIwMqUkIf5nEgBYYVl2eEcYcG1yI/HfJXAm
k3LoYoFloVkh0ngCf3FmdVdqRzZwY2EkACDRMfFloUZZSXDzEiBxZ3pAfwtwC2AlYSGSWJJdUVAB
QbcToAMQb81NC3EgEG4AcP9QASGhZSEi8IDlIvAwYAeR/yGhaoEy0QdAJXBw4WcxGHD/JcEfEHgB
fUN3MRhwf59j8N4zcPI2cB2wEgBjJ8BC0H9sNWobQ6GBIoujZaFaPjGjRCCCADo1NmWwQS4iHzsR
guEJgFZxYlBOSU7sRyElICbAZFSAYoBOoMMFMIghb2M6YmBBXDLfh9J7EI7fZbAe8GhGoQZgcwQQ
WbEoMouRPbY9onhwX3Nydi5RQ6FD8DnzG6CVkDApVgc9Az0DHVBbGHBgQCiPwB2weBGwZ2ZfgVCL
kTVkl4CBQDi9HbAzl8iUGU6QLrJzTLAeQwBwbEImAB8QVEJMXlNP45HSJbOdhzGPYDOwNDM3NJsP
lJFBOGDLWbFMsFId4CAnAiARsF0FkGsjAAUxnzYnWj48I6QQB7BPVEVMsCBI+1uhI2F3ZeNoUpkh
JRcnUb5nAHBvxqP0HVAm4SKhxf4iPUFtoabAJIEmAFX4pBL+RR+QBbEiYAnwIFKdgU/UomI2EDAy
NmWhP6xj/R4sWQeQHbAnYHUgnUImxP9mQVhwIBBPgAWwCsAf8U8C/20hXuOItmxAbWACIHsQBcD0
ZXhJMXNvxlsyeAIm4e9fFx8goQFQgHQf8GqBdsGzesFPcWRirqQYAGd7EP9tErBKHbAypUogBRAg
YRhw5wWgJNFC4m5MC4AoAQiB/yahJDADYBcRJcFmMAsgqrL/JPBm4odzrwGDE2eJJuGxGP+Ik2/N
HdIeLDiSlJFzk0aQtyBhwL/Bikk9xQYAbwGA/7ohHxCUkTj5v7VAcVmwBcCPLoV3EsYfxmIoNjWX
sPOXMKwQLTY2cHFAxmTD7//CgVuRhdBm4iUBTEAjsZBB38s/PV9VgMivy0VMknBm03ItSiAtaghh
TLCQAGj7JcFtEUUbcBtRJADRL8iNdioehtMwU8XRQsC6QWT/BAB0cAtwB4AR4B8gI7Af4PvSziMg
UHyjIgAkMGxCEfC3XuGzsRhwcSZxnJAv2CP9utNiH/AAwIRhlKJnUSZA63oyaENrbEB3TyGTZyMg
/7AzB3ElIASQPgCckF5yuRD/H/F3wQCAMcAFwNiYIaEycfxwLkLAAZF8wbIAPbat0f8goNYXuRB6
QQMgBPAW8Eog16/y3DKwFHYG8HWzsQDA/mulsk/QAiDUcF1yJDC6gb8kUMqC2AbWF9RwDdBpZqH/
dzFe4cMxZ1FrgF0wZaHWpf91IBcRtKOSYSUBwpdPYBGwPwMA6QLKxdYXBbCmwWl6/2bUJcJmQACQ
IDCF4wPwJsD/IAHp9gQBJnFvxlHfHIc4FgsypReRAPHQAB4AMUABAAAAEAAAAE1PU1NFUlA0Mzk5
MURBNwADABpAAAAAAB4AMEABAAAAEAAAAE1PU1NFUlA0Mzk5MURBNwADABlAAAAAAAMANgAAAAAA
AwAmAAAAAAACAfk/AQAAAGcAAAAAAAAA3KdAyMBCEBq0uQgAKy/hggEAAAAGAAAAL089V0VMTFMg
RkFSR08gJiBDTy4vT1U9V0ZCMS9DTj1OT04tRVhDSEFOR0UgUkVDSVBJRU5UUy9DTj1NT1NTRVJQ
NDM5OTFEQTcAAB4A+D8BAAAADQAAAE1vc3NlciwgUGF1bAAAAAAeADhAAQAAABAAAABNT1NTRVJQ
NDM5OTFEQTcAAgH7PwEAAABnAAAAAAAAANynQMjAQhAatLkIACsv4YIBAAAABgAAAC9PPVdFTExT
IEZBUkdPICYgQ08uL09VPVdGQjEvQ049Tk9OLUVYQ0hBTkdFIFJFQ0lQSUVOVFMvQ049TU9TU0VS
UDQzOTkxREE3AAAeAPo/AQAAAA0AAABNb3NzZXIsIFBhdWwAAAAAHgA5QAEAAAAQAAAATU9TU0VS
UDQzOTkxREE3AEAABzBQVah1mdW8AUAACDCQUCvtmtW8AR4APQABAAAABQAAAFJFOiAAAAAAHgAd
DgEAAAAjAAAARGlzYWJsZWQgVGVtcCBEQnNwYWNlIC0tIFJldmlzaXRlZAAACwApAAAAAAALACMA
AAAAAAMABhDMJIBHAwAHENYHAAADABA