WorkingScripts

As many PeopleSoft developers and managers I have suffered through my share of nVision Tuning efforts and until very recent we could not get our reports to run under 4 hours, until the recent change…
In any case here are a few points from my experience:
We experienced an almost almost 5 fold increase in performance when we did a PS_LEDGER reorg with PSCLEDGER index option as follows:

   1:  

   2: db2 "reorg table PSFSSYS.PS_LEDGER index PSFSSYS.PSCLEDGER allow read access indexscan"

   3: db2 "RUNSTATS ON TABLE PSFSSYS.PS_LEDGER FOR INDEX PSFSSYS.PSCLEDGER"

   4: db2 "reorgchk current statistics on table PSFSSYS.PS_LEDGER"

Also it is great to cleanup treeselectors, to make sure that static selectors did not get out of sync with trees, this can be done on a regular basis, see a sample script below. Please note that the number in the end of the treeselector name xx – corresponds to the chartfield length:

   1:  

   2: -- Delete TreeSelectors

   3: Delete from PSFSSYS.PSTREESELECT05;

   4: Delete from PSFSSYS.PSTREESELECT06;

   5: Delete from PSFSSYS.PSTREESELECT10;

   6:  

   7: -- Delete Tree Control table for the respective selectors above

   8: delete from PSFSSYS.pstreeselctl

   9: where length in (5,6,10);

For details about PeopleSoft nVision architecture and structure please make sure to read the Red Paper by clicking below

PeopleSoft nVision Red Paper

Tags: PeopleSoft nVisoin