ksam versus c-isam

[Peter Bateman]

>From: "Guy Werry" <guy.werry at hbms.ca>

Good idea, Gerry! The last time I had to do it, we got bcheck from Cognos.

C-ISAM is base file system for Informix databases. So you will sometimes 
hear
Informix DBAs talking about running bcheck on the base C-ISAM files in the 
database.

Regards,
Peter

>Pierre,
>
>My bcheck is located in /usr/bin/bcheck.  Our environment dates from 
>1993/94, and I didn't set it up, but to the best of my knowledge we just 
>dealt through Cognos and all of the utilities came through them.
>
>Is your problem that an indexed subfile is being corrupted?  If so, then 
>just write a qtp program to access the damaged subfile sequentially and 
>write out a new indexed subfile and then rename the files.  After all, it 
>will just be the indexes that are getting corrupted, not the actual data.
>
>Or, you could contact Cognos' support - they may have bcheck available.
>
>Guy L. Werry
>Senior Systems Analyst
>Hudson Bay Mining & Smelting Co., Limited.
>
>-----Original Message-----
>From: Portelance, Pierre (Montreal) [mailto:portelancp at bowater.com]
>Sent: Tuesday, May 02, 2006 9:05 AM
>To: Guy Werry; powerh-l at lists.sowder.com
>Subject: RE: ksam versus c-isam
>
>
>
>Thanks, but it seems that bcheck comes with informix.
>
>We don't have informix, we use eloquence for database.
>
>All the libraries for c-isam came with powerhouse, so we can't find bcheck.
>
>
>-----Original Message-----
>From: Guy Werry [mailto:guy.werry at hbms.ca]
>Sent: Tuesday, May 02, 2006 8:54 AM
>To: powerh-l at lists.sowder.com
>Subject: RE: ksam versus c-isam
>
>
>Yes, there is.  C-ISAM includes a utility named 'bcheck' that will verify 
>the integrity of the indexes and re-build them if necessary.
>
>If the file is large it can be rather slow, but it works well otherwise.
>
>Guy L. Werry
>Senior Systems Analyst
>Hudson Bay Mining & Smelting Co., Limited.
>
>-----Original Message-----
>From: powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com
>[mailto:powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com]On Behalf Of
>Portelance, Pierre (Montreal)
>Sent: Tuesday, May 02, 2006 7:00 AM
>To: powerh-l at lists.sowder.com
>Subject: ksam versus c-isam
>
>
>We are migrating from an hp3000 to an unix .
>
>On the 3000, some of our files are ksam files.  If the system crashes while 
>a ksam file is open in a powerhouse screen, we have to issue a ksamutil 
>command "keyinfo"  to recover the ksam file.
>
>Is there something similar on the unix ?
>
>Pierre Portelance
>
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: &quot;subscribe&quot; in message body to 
>powerh-l-request at lists.sowder.com
>Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to 
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>Add 'site:lists.sowder.com powerh-l' to your search terms to search the 
>list archive at Google.
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: &quot;subscribe&quot; in message body to 
>powerh-l-request at lists.sowder.com
>Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to 
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>Add 'site:lists.sowder.com powerh-l' to your search terms to search the 
>list archive at Google.
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: &quot;subscribe&quot; in message body to 
>powerh-l-request at lists.sowder.com
>Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to 
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>Add 'site:lists.sowder.com powerh-l' to your search terms to search the 
>list archive at Google.

_________________________________________________________________
Take charge with a pop-up guard built on patented Microsoft® SmartScreen 
Technology  
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines 
  Start enjoying all the benefits of MSN® Premium right now and get the 
first two months FREE*.