Creating a large indexed subfile on MPE/iX

[Robert Mills]

Walter,

Suggest that you upgrade to 8.49.E. We have been running it since May
last year and have not had any problems. 


regards,
 
Robert W.Mills
Business Systems Development Analyst
Group Information Systems & Technology
Pinnacle Entertainment
DDI: +44 (0)20 8309 3604 


-----Original Message-----
From:
powerh-l-bounces+robert.mills=pinnacle-entertainment.co.uk at lists.sowder.
com
[mailto:powerh-l-bounces+robert.mills=pinnacle-entertainment.co.uk at lists
.sowder.com] On Behalf Of Walter J. Murray
Sent: 10 April 2008 02:49
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.