Creating a large indexed subfile on MPE/iX

[Deskin, Bob]

PowerHouse 8.39 does not really understand KSAM64. KSAM64 support was
added to PowerHouse 8.49D. In 8.49D and up you can use the file equation
to point to KSAM64 and you'll get a KSAM64 subfile.

The current version is 8.49E.

Bob Deskin
Senior Product Manager
Application Development Tools
COGNOS, an IBM company
+1 613-738-1338 ext 7268
bob.deskin at cognos.com
bob.deskin at ca.ibm.com
http://powerhouse.cognos.com
 

-----Original Message-----
From: powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com
[mailto:powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com] On
Behalf Of Walter J. Murray
Sent: April 9, 2008 9:49 pm
To: powerh-l at lists.sowder.com
Subject: Creating a large indexed subfile on MPE/iX

[also posted to 3000-L list]

Environment:

  PowerHouse  8.39.C1
  HP e3000 MPE/iX 7.5

Is there any way go get QTP to use KSAM 64 instead of KSAM XL when
creating an indexed subfile?

I have a programmer who ran into trouble with a QTP run trying to create
a large indexed subfile.  The record size is 556 bytes, and the length
of the index is 42 bytes.  With a SIZE of 5,000,000 it works.  With a
size of 7,000,000 it fails.  With this size, the file exceeds the
maximum size of a KSAM XL file, which is approximately 4 GiB.

I suggested trying to force the file to be KSAM 64 by issuing a FILE
command:

  :FILE fname;KSAM64

He reported that it didn't work.  It appeared that the FILE command was
not honored.

I then suggested building the subfile prior to the QTP run:

:BUILD fname;REC=-556,7,F,ASCII;DISC=7000000; &
KSAM64;KEY=(B,515,42,DUP);ULABEL=20;CODE=644

He says this didn't work either.

Searching the COGNOS knowledge database, I found the following:

1.  PowerHouse versions 8.39 and older does not support KSAM64 files.

2.  KSAM64 files are supported in PowerHouse for 8.49C.  They are
specified as KSAMXL [sic] in PDL.

3.  KSAM64 files are supported in PowerHouse for 8.49D.  They are
specified as ORGANIZATION INDEXED TYPE KSAM64 in PDL.

I have two questions:

Q1.  Is there any way to get this to work in version 8.39?

Q2.  When the New Features document says that KSAM64 files are supported
in 8.49D, does that also mean that PowerHouse will use KSAM64, when
necessary, for a large indexed subfile?  (If so, this would be one more
reason for us to upgrade.)

Thanks.

Walter  

Walter J. Murray


-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.