ksam versus c-isam

[Guy Werry]

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: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" 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: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" 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.