HP3000 QUIZ SORT ISSUE (Linkages with sort to Large)

[Ken Langendock]

First of all stop using quiz to extract your data.

While QUIZ is safe and easy to use, it is DUMB.

 

Create yourself a QTP extract with SET LOCK FILE UPDATE (Since you are not
updating anything but a subfile you are safe).

 

Now take your access statement and split it up into files that MUST be in
the record complex and ones that do now have to be there.

The files that do not have to be in the records complex (like reference
files) can now be pushed to OUTPUT phase reads.

 

Here is a sample:

 

ACCESS Students &

  LINK StudentId OF Students &

    TO Student Id &

    OF CourseSchedules &

  LINK CourseId of CourseSchedules &

    TO CourseId &

    OF Courses &

  LINK SchoolId OF Students &

    TO SchoolId &

    OF Schools

  LINK StateId OF Schools &

    TO StateId &

    OF States &

       ALIAS SchoolStates

  LINK StateId OF Students &

    TO StateId &

    OF States &

       ALIAS StudentStates

 

IN QTP

 

ACCESS Students &

  LINK StudentId OF Students &

    TO Student Id &

    OF CourseSchedules 

 

OUTPUT Courses &

       ADD &

       UPDATE &

       NOITEMS &

       IF 1 EQ 2 &

       VIA   CourseId &

       USING CourseId of CourseSchedules 

 

OUTPUT Schools

       ADD &

       UPDATE &

       NOITEMS &

       IF 1 EQ 2 &

       VIA   SchoolId &

       USING SchoolId OF Students 

 

OUTPUT States &

       ALIAS SchoolStates

       ADD &

       UPDATE &

       NOITEMS &

       IF 1 EQ 2 &

       VIA   StateId &

       USING StateId OF Schools 

 

OUTPUT States &

       ALIAS StudentStates

       ADD &

       UPDATE &

       NOITEMS &

       IF 1 EQ 2 &

       VIA   StateId &

       USING StateId OF Students 

 

SUBFILE sfwhatever &

               KEEP &

               INCLUDE all fields from the access statement, &

                                all fields from the output phase reads.

               

This works faster and does not have a MASSIVE sort work area.

 

Trust me

 

Ken

 

From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Stanfield, Randy (Carrollton, TX)
Sent: February 9, 2017 3:30 PM
To: powerh-l at lists.sowder.com
Subject: HP3000 QUIZ SORT ISSUE (Linkages with sort to Large)

 

I know I've seen the issue before. Not sure if it was on the HP3000 list or
the Powerhouse list.

 

We've had a Quiz report files abort and cause a System failure abort 500.
Which causes the HP3000 to shutdown. 

 

SYSTEM ABORT 500 FROM SUBSYSTEM 185

SECONDARY STATUS:  INFO = -58, SUBSYS = 107

SYSTEM HALT 7, $01F4

 

************* SYSTEM ALERT **************

 

The quiz causing the process is only really reporting about 292,000 records
because it subfiles at an item break. But with all the records processing is
about 1,200,000 records.

 

We have a "set report limit 10,000,000" by lowering the Report limit to
5,000,000 no problem occurs. 

 

The record linkages with a straight report sum all build a record of 3374.
Which the actual subfile created is only 888.

 

ACCOUNT=  TESTSW      GROUP=  WHSE    

 

FILENAME  CODE  ------------LOGICAL RECORD-----------  ----SPACE----

                  SIZE  TYP        EOF      LIMIT R/B  SECTORS #X MX

 

REPALL            3374B  FA        1000       1000   2    13184 34 32

 

ACCOUNT=  TESTSW      GROUP=  WHSE    

 

FILENAME  CODE  ------------LOGICAL RECORD-----------  ----SPACE----

                  SIZE  TYP        EOF      LIMIT R/B  SECTORS #X MX

 

IV170103  644     888B  FA      277978   10000000   2   964288  * 32

 

 

I know we can pre-sort the file, remove some of the linkages in the request
or lower the report limit. 

 

Is there anything else that can be checked or done to elevate the system
abort? 

 

Running Cognos version 8.29c on MPE USER VERSION: C.75.03

 

 

 

Randy Stanfield

 

 

 

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20170209/6f58b01e/attachment-0001.htm>