SEO

Franz Grutzmacher said:
> Hi All
>
> Hope there is still a few people running or knowing something about this
> old dinosaur of ours.
>
> I am getting index corruption from time-to-time on one of your main
> tables (486000 records). This table is being accessed for reports and
> maintenance ever minute of the day, especial over month ends.
>
> The SE-Admin manual is talking about the secheck utility, but I am
> having a gut feeling this was for SE7 (not for our release). I can’t
> find the secheck on our software or in the Informix bin directory.

secheck and bcheck are the same thing.

A couple of ideas:

1. Can you drop and recreate the indexes?
2. bcheck -y filename.dat

> So currently to solve the problem on the index corruption, I need to
> unload the data, drop the table and recreate the table and indexes. But
> this takes the system down for half a day and I don't know if this is
> the best practice.
>
> Any ideas? And don’t try the “update Informix”, that is a big no-no
> option. Is there any settings I can set to improve the systems working?
> Man how do I miss the online tools.
> Do anybody know where I can get the secheck util, and if it will work
> for us?
> Even IBM is playing that upgrade card on this old monster.
>
> SCO Unix 5.0.5
> Informix SE 4gl and SQL version 4.17.UC1
>
> bcheck reports:
> Checking dictionary and file sizes.
> Index file node size = 1024
> Current C-ISAM index file node size = 1024
> Checking data file records.
> Checking indexes and key descriptions.
> Index 1 = unique key
> 0 index node(s) used -- 1 index b-tree level(s) used
> Index 2 = unique key (0,1,0) (1,4,2) (5,4,2)
> 9132 index node(s) used -- 4 index b-tree level(s) used
> Index 3 = duplicates (18,4,2)
> 10124 index node(s) used -- 4 index b-tree level(s) used
> Index 4 = duplicates (5,4,2)
> 8263 index node(s) used -- 4 index b-tree level(s) used
> Index 5 = duplicates (27,6,0)
> 12659 index node(s) used -- 4 index b-tree level(s) used
> Index 6 = duplicates (26,1,0)
> 4696 index node(s) used -- 3 index b-tree level(s) used
>
> ERROR: 1 duplicate data record pointer(s)
>
> Thanx
> Franz
> www.bybelgenootskap.co.za / www.biblesociety.co.za
>
> DISCLAIMER: The information transmitted is intended only for the person or
> entity to which it is addressed and may contain confidential and/or
> privileged material. Any review, retransmission, dissemination or other
> use of, or taking of any action in reliance upon, this information by
> persons or entities other than the intended recipient is prohibited. If
> you received this in error, please contact the sender and delete the
> material from any computer.
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>


--
Bye now,
Obnoxio

Information within this post contains forward looking statements within
the meaning of Section 27A of the Securities Act of 1933 and Section 21B
of the S E C Act of 1934. Statements that involve discussions with respect
to projections of future events are not statements of historical fact and
may be forward looking statements. Don't rely on them to make a decision.

The poster is not a reporting company registered under the Exchange Act of
1934.

I have received a life peerage from Her Majesty, who is not an officer,
minister or affiliate Labour party member.

I intend to recover my loan now, which could cause the parliamentary
majority to go down, resulting in losses for you. Today's Labour party
has: an accumulated deficit and a reliance on loans from officers and
affiliates to pay expenses. It is not an operating political party. The
party is going to need financing to continue as a going concern. A failure
to finance could cause the party to go out of business. This report shall
not be construed as any kind of investment advice or solicitation. You can
lose all your money by investing in this party.