Thursday, 22 June 2006
|
| Promising news for Oracle/Peoplesoft for IDS 10 Darren Jacobs 00:35:59 |
| |
----- Forwarded by Darren Jacobs/7001/Carmax on 06/21/2006 04:34 PM -----
Scott
Walters/7001/Carm
ax To
Darren Jacobs/7001/Carmax@Carmax,
06/21/2006 03:14 Larry Clark/7001/Carmax@Carmax,
PM Doug Johnson/7001/Carmax@Carmax,
Dave Banks/7001/Carmax@Carmax, Herb
Caldwell/7001/Carmax@Carmax
cc
Subject
Informix 10 Certification Request
for PeopleTools 8.49
See the attached PeopleSoft case for some encouraging news!
Of course, the latest PeopleTools available is 8.47 (which is what we are
using with our current PSoft Upgrade).
Oracle has not published when PeopleTools 8.49 will be released yet.
~Scott
----- Forwarded by Scott Walters/7001/Carmax on 06/21/2006 03:10 PM -----
derick.neal@oracl
e.com
To
06/21/2006 02:44 scott_walters@carmax.com
PM cc
Subject
Notes Correspondence of Case
4250091
Link:
http://www.peoplesoft.com/psp/portprd/CUSTOMER/CRM/c/CALLCENTER.RC_CASE_MAP.GBL?page=RC_CASE_NOTE&BUSINESS_UNIT=GBLSC&CASE_ID=4250091
Message Text:
Note Created Date : 06/21/2006 11:44AM
Note Summary : em to ct
Note Detail:
Hello Scott,
I've received an answer from our certification request team. I've pasted
their comments below.
Oracle plans to support Informix 10 with PeopleTools 8.49. After version
8.49 has completed testing Oracle will consider back-certifying.
At this point I will close this case. Please don't hesitate to give me a
call if you have any questions or concerns.
Thank you,
Derick Neal
|
| | Add comment |
|
| ODBC and F*&king IBM :-) Paul Watson 00:35:22 |
| | I've just uninstalled IDS10 from my laptop, now Data Direct and ALL my
ODBC connections now work. So re-install IDS10 and the ODBC is still
broken and I get an 'Unknown Error Message' driver version 2.90 or
-11355 driver version 3.30. [Data Director is fine]
However, ODBC connection under DBPing works 
Anybody got any ideas
Paul Watson
Tel: +44 1414161772
Mob: +44 7818003457
GO FURTHER with DB2
GET THERE FASTER with Informix.
Attend the IDUG 2006 European Conference.
Vienna, Austria. 2-6 October 2006
Visit http://www.iiug.org/conf for more information.
|
| |  1 answer | Add comment |
Wednesday, 21 June 2006
|
| Database Servers on Sun T1 or T2 - Niagara Informix_guy 22:17:31 |
| | Does anyone have any experience in running IDS 10 (or 9.4) on Sun T1 or
T2? If so, were there any special configurations used for IDS or the
O/S? I have done some limited testing of a production application with
only fair results. We found it difficult to keep the cpus busy. The
box was a T2 with 8 cores (= 32 cpus) and 32G of memory. We ran our
instance with 16 cpuvps using affinity and with 20 cpuvps without
affinity. The second test had slightly better performance. The
testing we did on a Sun 490 (= 8 cpu) had much better performance.
This question was asked 6 months ago with little response I'm hoping
more people have had an opportunity to test
|
| | Add comment |
|
| IDS and Baan Neil Truby 21:51:02 |
| | Can anyone tell me please the various versions of IDS supported on Baan?
thanks
--
Neil Truby t:01932 724027
Director m:07798 811708
Ardenta Limited e:neil.truby@ardenta.com
|
| | 2 answer | Add comment |
|
| Permissions on a View Chris S 21:44:25 |
| | Here's a snippet from the Informix 10 Manual: "When you create a view,
PUBLIC does not automatically receive any privileges for a view that
you create. Only you have access to table data through that view. Even
users who have privileges on the base table of the view do not
automatically receive privileges for the view."
Does this hold true for other DBA's on the same database? It seems as
this is the case through some testing I have done here but it seems odd
to me. If I do not explicity grant SELECT on my view to a DBA user,
then they cannot select from it.
Can anyone tell me if this is working as it's supposed to? It seems
strange to me that DBA's don't just get full permissions by default on
new views.
|
| | 6 answers | Add comment |
|
| korn shell executed using stored procedure....problem :( Guest 20:07:24 |
| | Hi all,
I have a korn shell script which executed using the "system" command in
a stored procedure.
Everything works fine when I ran the stored procedure inside the
server. However, it behave abnormally when i ran the stored procedure
in a sql editor (connected to the informix server using ODBC
connection). Does anyone have any idea what is the possible cause?
Thanks a lot for your help.
|
| | 5 answers | Add comment |
|
| Re: Looking for Replenishment Software Daniel Richardson 19:50:34 |
| | http://www.gillani.com/
Their Replenishment package is pretty good. You
should give them a try.
--- Brian Grellinger <Brian.Grellinger@dhiac.com>
wrote:
We have a custom Warehouse Distribution system> written in 4GL (Fourjs> BDL) using an IDS database.> About 150,000 part numbers and 10 years of> transaction history.> Our Parts Replenishment is a hand coded program that> lacks intelligence> for trends/spikes/etc.> Can anyone recommend a 3rd party Replenishment> package that works with> IDS and can be customized to integrate with our> software?> Plan B:> Is there a 4GL developer out there that has solid> ERP experience> looking for contract work?> Thanks.>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
|
| | Add comment |
|
| Correlation names Dirk Moolman 19:46:11 |
| |
Create trigger blabla
Referencing new as <correlation name>
Is there a default for correlation names in IDS, so that it is not
necessary to specify them in the create section ?
IDS 7.31
Dirk Moolman
Database and Unix Administrator
Digicare Technologies (HealthCorp)
The other day I was trapped on an escalator for hours....the power went
out!!!
The information on this e-mail including any attachments relates to the official business of DigiCare (Pty) Ltd. The information is confidential and legally privileged and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised and as such any disclosure, copying, distribution or any action taken or omitted in reliance on it is unlawful. Please notify the sender immediately if it has inadvertently reached you and do not read, disclose or use the content in any way. >
No responsibility whatsoever is accepted by DigiCare (Pty) Ltd if the information is, for whatever reason, corrupted or does not reach its intended destination. The views expressed in this e-mail are the views of the individual sender and should in no way be construed as the views of DigiCare (Pty) Ltd, except where the sender has specifically stated them to be the views of DigiCare (Pty) Ltd.>
|
| | 2 answer | Add comment |
Tuesday, 20 June 2006
|
| Checking indexes after large deletes Bozon 21:35:18 |
| | Is there a way to determine how "messed up" an index is after a large
number of deletes have been done to a table? I searched here and didn't
see anything. Is there an oncheck command or sysmaster table to look
at? If so what values should I look for? I have to make a case for
rebuilding indexes and having hard data would make my case stronger.
Thanks.
|
| | 20 answers | Add comment |
|
| Web data blade installation on RHEL4 Trev 13:34:16 |
| | Hi. We are experimenting with the Informix Web Data Blade on a Red Hat
Linux Enterprise 4. Not got to far so far.
Running the ./install script we get an error that appears to be related to
a -d paramater in the AWk command. (line 2 of install script)
Question. Has anyone had experience with installing the Web DataBlade in
the RHLE4 environment and if so, have they had this problem?
Thanks
|
| | 7 answers | Add comment |
|
| AW: checkpoint problem Tilman Model-Bosch 13:34:13 |
| | mchivaviro@okzim.co.zw wrote
I am runnind IDS 7.31 on HPUX 11 and my check points a taking > too long.> What do I need to change. LRU_MAX_DIRTY 1 # LRU percent dirty begin cleaning> LRU_MIN_DIRTY 0 # LRU percent dirty end cleaning limit
Try to increase LRU_MAX_DIRTY and LRU_MIN_DIRTY to 2 and 1
It might just be that the checkpoints take longer when cleaners never
sleep
as LRU_MIN_DIRTY is set to 0.
The CLEANERS are responsible for background page cleaning as well
as for checkpoint page cleaning.
Regards
Tilman
|
| | Add comment |
|
| I dropped from 3.5GB of RAM to 2.5GB and 4GL quit working Anthony 12:51:39 |
| | Help?
We made a physical move, and after some looking / poking around,
decided to move 1GB of RAM from our db server and put it into our mail
server. Simple change. Brought both systems up, one now reads 2GB (it
read 1GB before), and the other reads 2.5GB (it read 3.5GB before). No
configurations were changed (I'm the only admin, and did the physical
move and swap myself).
However, all of the 4GL reports quit working.
We're running Informix 7.31.UD8, on a RedHat 7.3 SMP (Dual Athlon MP
1900) system.
I can compile the 4GL progams perfectly, but when run, they show
"Segmentation Fault", when run as users root, informix, or myself
(anthony). No core file is produced.
I tried re-compiling all of the programs, but that hasn't helped at
all.
strace says this (I'm only including the last few lines):
open("/opt/informix/gls/lc11/en_us/0333.lco", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=2628, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
0) = 0x40151000
read(3, "FILE_TYPE=locale_object\nCOMPILER"..., 4096) = 2628
close(3) = 0
munmap(0x40151000, 4096) = 0
open("/opt/informix/gls/lc11/en_us/0333.lco", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=2628, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
0) = 0x40151000
read(3, "FILE_TYPE=locale_object\nCOMPILER"..., 4096) = 2628
close(3) = 0
munmap(0x40151000, 4096) = 0
open("/opt/informix/gls/lc11/en_us/0333.lco", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=2628, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
0) = 0x40151000
read(3, "FILE_TYPE=locale_object\nCOMPILER"..., 4096) = 2628
brk(0x8059000) = 0x8059000
--- SIGSEGV (Segmentation fault) ---
+++ killed by SIGSEGV +++
Thoughts?
Anything would be appreciated ...... I'm at a loss at the moment.
--
Anthony
|
| | 13 answers | Add comment |
|
| Re: Error executing statement. Superboer 10:33:25 |
| | Try setting sqlidebug;
export SQLIDEBUG=2:/somedirwithspace>/somefile
run your program and use sqliprint (from clientsdk) to print it.
Superboer.
Prateek Jain schreef:
On 6/19/06, Prateek Jain <prateekvjain@gmail.com> wrote:> > Hello friends,> > I have got a code which is executing fine in one machine> > but not within the other maching> > *EXECUTE cusor_name into variable_name*> > Its giving again difficult to trace errror 4373 gramatical mistake  > > --> > Regards,> > Prateek Jain> > --> Regards,> Prateek Jain> ------=_Part_9107_19851256.1150719068237> Content-Type: text/html; charset=ISO-8859-1> X-Google-AttachSize: 794> <br><br>> <div><span class="gmail_quote" >On 6/19/06, <b class="gmail_sendername">Prateek Jain</b> <<a href="mailto rateekvjain@gmail.com">prateekvjain@gmail.com</a>> wrote:</span>> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">> <div>> <div> </div>> <div>Hello friends,</div>> <div>I have got a code which is executing fine in one machine </div>> <div>but not within the other maching</div>> <div> </div>> <div><strong>EXECUTE cusor_name into variable_name</strong></div>> <div> </div>> <div>Its giving again difficult to trace errror 4373 gramatical mistake </div>> <div><br clear="all"><br>-- <br>Regards,<br>Prateek Jain </div></div></blockquote></div><br><br clear="all"><br>-- <br>Regards,<br>Prateek Jain> ------=_Part_9107_19851256.1150719068237--
|
| | 1 answer | Add comment |
|
| Re: i4gl install failed Vincent Yeung 05:33:33 |
| |
I have installed the i4gl 7.32 FC3 on the machine AIX 5.3
I have no problem during the installation and receved the completion
message.
WHen I run i4gl, it shows the error message:
exec( ): 0509-036 cannot load program i4gl because of the following
errors:
Actually, I have not seen any error message.
Please any one can help me.
Regards,
Vincent YEUNG
--
vincent yeung
------------------------------------------------------------------------
vincent yeung's Profile: http://www.dbtalk.net/m443
View this thread: http://www.dbtalk.net/t36771
|
| | 2 answer | Add comment |
|
| Dostats Segmentation Fault running Update Statistics for Procedure on
9.40.FC8 Colin Dawson 02:14:34 |
| |
I've just upgraded a server to 9.40.FC8 (from 7.31.FC7) and dostats works
fine when running on table but crashes when run against stored procedures.
Output below
Procedures:
alter_java_path...SUCCESSFUL (0 hrs 0 mins 0.021 Secs)
assign...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
assign...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
assign...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
assign...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
assign...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
assign...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
assign...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
blobexport...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
blobimport...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
blobinput...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
bloboutput...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
blobrecv...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
blobsend...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
bytetoblob...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
bytetoblob...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
cdrgcdisp...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
clientbinval_recv...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
clientbinval_send...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
clobexport...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
clobimport...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
clobinput...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
cloboutput...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
clobrecv...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
clobsend...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
collcast...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
collcast...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
collcast...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
collcast...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
collectionexport...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
collectionexport...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
collectionexport...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
collectionexport...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
collectionimport...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
collectioninput...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
collectionoutput...SUCCESSFUL (0 hrs 0 mins 0.002 Secs)
collectionoutput...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
collectionoutput...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
collectionoutput...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
collectionrecv...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
collectionsend...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
deepcopy...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
deepcopy...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
deepcopy...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
deepcopy...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
destroy...SUCCESSFUL (0 hrs 0 mins 0.002 Secs)
destroy...SUCCESSFUL (0 hrs 0 mins 0.002 Secs)
destroy...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
destroy...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
destroy...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
destroy...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
destroy...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
dosyscast...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
filetoblob...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
filetoblob...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
filetoclob...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
filetoclob...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
get_cursor_table...SUCCESSFUL (0 hrs 0 mins 0.001 Secs)
Parameters on invocation are
dostats -d <DB> -t none -Q 10 -p -E -v -r 0.25
-i@/informix/scripts/dostats_include_Fri
-i@/informix/scripts/dostats_include_daily
Has anyone else experienced this?
BTW I removed the "SPECIFIC" keyword from dostats before compilation
Regards
Colin
There are 10 types of people in the world, those that understand binary and
those that don't
_________________________________________________________________
Are you using the latest version of MSN Messenger? Download MSN Messenger
7.5 today! http://join.msn.com/messenger/overview
|
| | 2 answer | Add comment |
Monday, 19 June 2006
|
| running a procedure based on a schedule Gentian Hila 18:08:02 |
| | Hello,
Is there any way to schedule a procedure in IDS 9.40 to run at a
certain time and day ?
Thanks a lot
|
| | 6 answers | Add comment |
|
| AW: AW: ALTER FRAGMENT x UNIQUE CONSTRAINT Tilman Model-Bosch 16:06:26 |
| | david@smooth1.co.uk wrote>
What do you mean the flags changed,what flags, where?> A unique constraint implies a unique index to validate the uniqueness> efficiently.> What is a simple unique index? As opposed to what?> It was a unique index and now it is a unique index what is the> difference?
Connect to sysmaste database:
select s.partnum, hex(s.flags) flags , f.indexname
from sysptnkey s, bla:sysfragments f
where s.partnum = f.partn
and f.tabid = (select t.tabid from bla:systables t
where t.tabname = 'bla')
-- adjust database and table name to your settings
-- for attached indices, you'll have to join systables and sysindexes
instaed
-- of sysfragments.
partnum 2097331
flags 0x00000298
indexname 124_97
-- This is the result of the query before the ALTER FRAGMENT
partnum 2097332
flags 0x00000218
indexname 124_97
-- This is the result of the query after the ALTER FRAGMENT
Note, the differrence, flag 0x80 is missing ! This flag indicates a
unique index implements a unique key constarint.
A unique key that does not have this flag is a unique key, but
does not implement unique constraint.
The difference is that on a unique indes uniqueness will be checked
immediately, for a unique constraint it will fail only at commit time.
e.g suppose you have table bla , col1 ineger, and values 1,2,3,4 in the
table.
With unique constraint , the SQL statement
begin work;
update bla ste col1 = col1 + 1 ;
commit;
will succeed, as the uniques of the result will be check at commit time.
With an ordianry unique index , the stament will fail with -346/-100 ,
as the update of the first row ( 1 + 1 ) will collide with unique key
'2'
which is already there.
Superboer [superboer7@t-online.de] wrote: > and if the alter fragment changes the unq constraint to an unq index> then this is> a bug for sure.
As I said, I'd vote for a bug, but not sure whether this behaviour is
documented
somewhere (maybe in a place I did not search)
In any case , it is inconsistent behaviour. In system catalog tables of
the database
the unique constraint is still defined and enabled.
I reported this as an defect to our devlopment and we will see.
Reagrds
Tilman
|
| | Add comment |
|
| Drop diagnostic/violation table Reinhard Habichtsberg 12:53:47 |
| | IDS 9.40FC4W2
Trying to alter a table IDS generates the error:
-898 Cannot alter a table which has associated violations/diagnostics
tables.
The user has tried to add, drop, or modify a column in a table that has
a violations and diagnostics table associated with it.
Trying to drop the dia and vio tables with drop table foo.dia/foo.vio a new
error message appears:
-897 Cannot modify/drop a violations/diagnostics table.
The user has tried to alter or drop a table that is serving as a
violations table or a diagnostics table for another table.
I'm working as user informix and table owner is informix.
Reading manuals didn't help so I have no clue what to do.
Any help would be appreciated.
Reinhard.
|
| | 2 answer | Add comment |
|
| AW: ALTER FRAGMENT x UNIQUE CONSTRAINT Tilman Model-Bosch 11:52:02 |
| | reitota@gmail.com ..> I have recently used ALTER FRAGMENT to move a table from one > dbspace to> another, and this table had a unique constraint defined in a specific> column. After the move we began to experiment a curious IDS behaviour.> The application updates this column like this:>
update id set id = id + 1 where id >= value;> ...> Before the alter fragment this worked well, but after the operation we> began to experiment unique constraint violations. Most strange is that> this happens when we filter more than ten rows approximatelly. With> less than this, there is no problem at all. Also if I drop the> constraint and recreate it the problem goes away, but this is not> acceptable for big tables.>
Another point is that this happens with the version IВґm using 7.31> UD8, but also with versions 9.21, 9.40 and 10, as IВґve tested. I did> not find any restriction to the alter fragment and constraints in the> documentation up until now.> Does anyone know if this is a bug with the alter fragment > statement, or> any restriction with alter fragment and constraints?>
I reproduced the error on a test table and found out that the internal
index which exists to implement the UNIQUE constraint has been modified
to a simple unique index (key flags).
So the statement will fail depending on whether the value 'id+1' already
exists in the table or not.
The the UNIQUE constraint has been dropped from dbschema output , but is
still indicated as being active the system catalog tables.
I did not find this behaviour documented anywhere
So, I'd vote for bug 
Regards
Tilman
|
| | 3 answer | Add comment |
Friday, 16 June 2006
|
| LOAD file Zackary Evans 20:55:36 |
| | since I can't use the LOAD command inside a stored proc in
informix...how can I load a datafile into a table within a proc?
|
| | 2 answer | Add comment |
|
| Informix and ODBC Colin Dawson 19:14:13 |
| | Apologies if this has been round before.
Does anyone know a way of setting PDQPRIORITY through an ODBC connection?
I've found a way to SET ISOLATION DIRTY READ by adding a line to the
informix.sdb file.
Regards
Colin
There are 10 types of people in the world, those that understand binary and
those that don't
_________________________________________________________________
Are you using the latest version of MSN Messenger? Download MSN Messenger
7.5 today! http://join.msn.com/messenger/overview
|
| | 5 answers | Add comment |
|
| Any one want a job Paul Watson 17:49:58 |
| | Can you do that, I'll give you a job!!
Looking for some peeps, anyone interested?
www.oninit.com/careers
Cheers
Paul
Paul Watson
Tel: +44 1414161772
Mob: +44 7818003457
GO FURTHER with DB2
GET THERE FASTER with Informix.
Attend the IDUG 2006 European Conference.
Vienna, Austria. 2-6 October 2006
Visit http://www.iiug.org/conf for more information.
|
| | Add comment |
|
| OnLine tbtape restore - ISAM Format Error URBAN Leos 12:19:58 |
| | Hi,
we have our server down after hardware failure.
It is old server Pentium I with SCO Unix 5.0.4 and Informix OnLine 5.
I installed specified OS and Informix to other computer, new computer
has Celeron (333MHz) processor. There is also second difference - on new
"server" I didn't create separate partitions for informix data, I used
normal OS files (the length of files is 2048000 bytes).
Here is list of files:
-rw-rw---- 1 informix informix 2048000000 Jun 15 15:54 online1
-rw-rw---- 1 informix informix 2048000000 Jun 15 16:16 online2
Restoring from tape with "tbtape -r" was successful (no error message).
Restore entire INFORMIX-OnLine system.
Please mount the first system archive tape and press Return to continue...
Restoring system control information, please wait...
CHUNKS THAT WILL BE RESTORED
Full Pathname Of The Chunk Offset Size
/dev/rdsk/online202000000
/dev/rdsk/online102000000
Verifiying physical disk space, please wait...
Verifiying physical disk space, please wait...
Restoring dbspaces/BLOBSpaces, please wait...
Do you have another level of tapes to restore? (y/n) n
Initializing, please wait...
Roll forward should start wih log number 730
Is there a logical log tape to restore? (y/n) n
When I try to work with databases I get "Bad ISAM File format".
First of two databases display names of some (not all) tables, second
does not display nothing with "Cannot access system catalog".
Tbcheck returns "Bad ISAM File format".
In online.log are many records:
14:35:36 bfcheck: bad page: pg_addr 0 != bp->bf_pagenum 1000b0, userp =
80001bcc, pid = 622, uid = 201
14:35:36 -- WARNING: Fail Consistency Check -- pthdrpagetalloc:bad
partn page -- pid=622 user=201 us=80001bcc
What is wrong? I see three possible reasons:
- wrong tapes (but I tested 3 different tapes)?
- Celeron <> PentiumI (but OS and Informix are the same?)
- chunks are in normal files, not in separate partitions (but it worked
after installation without problems)
Do you have some tips?
Thank you very much.
Leos
|
| | 3 answer | Add comment |
|
| restoring just from logical log tape Dawaves 11:25:56 |
| | When I run 'ontape -r', it asks me if I want to restore from an archive
tape (an 8mm tape) after restoring from level0 backup (a DLT tape). Is
there any way to just go straight to that 8mm tape for restore and
bypass the hour I have to wait for the level0 restore to complete
before getting the prompt for archive tape restore?
thanks!
|
| | 2 answer | Add comment |
|
| ALTER FRAGMENT x UNIQUE CONSTRAINT Reitota@Gmail.Com 10:33:39 |
| | Hello All.
I have recently used ALTER FRAGMENT to move a table from one dbspace to
another, and this table had a unique constraint defined in a specific
column. After the move we began to experiment a curious IDS behaviour.
The application updates this column like this:
update id set id = id + 1 where id >= value;
where column id is the column with the unique constraint defined.
Of course I donВґt like this solution but, as we know, deferred
constraint allow this kind of construction, as constraint violations
are checked after the statement finishes, and then no violation occurs.
Before the alter fragment this worked well, but after the operation we
began to experiment unique constraint violations. Most strange is that
this happens when we filter more than ten rows approximatelly. With
less than this, there is no problem at all. Also if I drop the
constraint and recreate it the problem goes away, but this is not
acceptable for big tables.
Another point is that this happens with the version IВґm using 7.31
UD8, but also with versions 9.21, 9.40 and 10, as IВґve tested. I did
not find any restriction to the alter fragment and constraints in the
documentation up until now.
Does anyone know if this is a bug with the alter fragment statement, or
any restriction with alter fragment and constraints?
Thanks in advance.
rdtbra
|
| | 3 answer | Add comment |
|
