DB2 TRANSACTION LOG - BI_PROCESS CHAIN JOB

[Former Member]

Hi,

We have a problem in "SAP EHP 1 for SAP NetWeaver 7.0" system.

Every weekend , a job which runs BI_PROCESS_COMPRESS job runs for a very long time increasing the transaction log % beyond threshold and we have to kill the job.

System details :

Database system      DB6

Operating system     AIX

SAP Kernel :  720_EXT_REL

Kernel Patch number : 201

The job log is shown as below.

..................................................................................................................................

31.05.2014 09:36:02 Job started                                                                                            00           516          S

31.05.2014 09:36:02 Step 001 started (program RSPROCESS, variant &0000001287768, user ID ALEREMOTE)                        00           550          S

31.05.2014 09:36:02 Start process COMPRESS COMPRESS_ZSD_C12 in run 4Y1CVGENSDUHBEABWQUMTBE9Y of chain COMPRESS_WEEKLY     RSPC          156          S

31.05.2014 09:36:07 Performing check and potential update for status control table                                        RSM1          490          S

31.05.2014 09:36:09 FB RSM1_CHECK_DM_GOT_REQUEST called from PRG RSSM_PROCESS_COMPRESS; row 000200                         RSM          053          S

31.05.2014 09:36:09 Request '972.284'; DTA 'ZSD_C12'; action 'C'; with dialog 'X'                                          RSM          054          S

31.05.2014 09:36:09 Leave RSM1_CHECK_DM_GOT_REQUEST in row 70; Req_State ''                                                RSM          055          S

31.05.2014 09:36:09 FB RSM1_CHECK_DM_GOT_REQUEST called from PRG RSSM_PROCESS_COMPRESS; row 000200                         RSM          053          S

31.05.2014 09:36:09 Request '972.429'; DTA 'ZSD_C12'; action 'C'; with dialog 'X'                                          RSM          054          S

31.05.2014 09:36:09 Leave RSM1_CHECK_DM_GOT_REQUEST in row 70; Req_State ''                                                RSM          055          S

31.05.2014 09:36:09 FB RSM1_CHECK_DM_GOT_REQUEST called from PRG RSSM_PROCESS_COMPRESS; row 000200                         RSM          053          S

01.06.2014 08:02:53 Job also cancelled due to process termination. See the system log

..............................................................................................................................

The job is cancelled as we received many alerts due to ccm4x.

This happens every weekend.

What does the job " BI_PROCESS_COMPRESS' actually do?

How can we overcome this?

Thanks and regards,

uday.

[ashish_vikas]

BI_PROCESS_COMPRESS is a BI job for Cube compression.

please check with BI if it can be scheduled with split in variant so that one job doe's not do everything.

best regards

ashish