JR33761: ENABLE PARALLELISM IN BW LOAD STAGE.

APAR status

• Closed as program error.

Error description

• SAP BI 7
  BW PACK 4.2.1
  DS 7.5.2
  HPUX 11.X
  
  They have a couple of ds jobs which loads data into BW . The
  jobs are being called from BW and use the same source system.
  One job seems to process multiple data packets and the other
  job is process data packet sequentially.
  
  Want to be able to enable parallelism in BW load stage.
  

Local fix

• NA
  

Problem summary

• Loading large amounts of data is too slow when using the
  Sequential Execution mode.
  

Problem conclusion

• Enabled BW Load stage to run in parallel.
  Note: the recommended job configuration is BW Load stage with
  one input link - this will allow the engine maximum flexibility
  to partition the load.
  
  Please note the following environment variable is introduced:
  
  ASC_BWLOAD_NODE_SYNC_TIMEOUT - Timeout (in seconds) for all
  nodes/links to register for a Parallel load. Increase this value
  for complex loads. Default is 10 seconds.
  
  IMPORTANT NOTE:
  ===============
  There are some limitations for cleanup of temporary files in
  case of job abort on PX. In order to maximize the cleanup
  capabilities the following
  patch should be installed: JR34990.
  Even with patch JR34990 installed there are still a couple of
  scenarios when the cleanup will not occur (e.g. when forcefully
  stopping a running job in
  DS Director or when the job aborts because of a stage other than
  the BW stage). In that case the user has to manually run the
  cleanup utility after job
  aborts (otherwise the next job run may not work correctly,
  hanging on execution or producing unexpected results)
  
  Description of the cleanup tool (jobReset):
  
  If the BW Load job aborts, it may be necessary to cleanup the
  temporary files by running the jobReset utility.
  Open a command prompt window to the DS Server and:
  - source dsenv
  cd <IIS Install Folder>/Server/DSEngine
  . ./dsenv
  
  - run the job reset utility
   cd $DSSAPHOME/DSBWbin
  ./jobReset  <Connection Name> <Source System> <InfoSource>
  <InfoSource Type> <JobName>
  
  where  <InfoSource Type> = MASTER | MASTERTEXT | TRANSACTION |
  MASTERHIERARCHY
  
  for example:
  cd  /hpithome/IBM/InformationServer/Server/DSBWbin
  ./jobReset SAPBW8 PACK09 IS1 MASTER bwload
  
  You should get a confirmation message: "jobReset - Successful"
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DSTAGE PCK 4 SA

• Fixed component ID

  5724Q5400

Applicable component levels

• R432 PSY

     UP