Cancel MSSCOMPRESS job

[yakcinar]

Hello,

Our system is running on MS SQL Server 2008 R2 SP3 Version 10.50.6000.34.

We are trying to use MSSCOMPRESS tool for our system.

BKPF table is about 200 GB and it is being compressed with options ONLINE, Force Data Rebulid and Force Index Rebuild.

It took more than a day and now it is blocking some processes.

What happens when we cancel the job?

I could not find an explicit explnation about cancelling compression jobs and failed jobs.

Can you help about the issue, please?

Regards,

Yuksel AKCINAR

[clas_hortien · Accepted solution]

Hello,

as you did it online, the compression job created a second temporarily table, compressed BKPF into it, added all the changes that you did during the compression run and is now most probably waiting to switch the Meta data from the original table to this new table. The last step then would be to drop the old table.

Unfortunatly is a schema modification lock (SCH-M) necessary to do the meta data switch. This lock is incompatible will all other locks and will block all incoming locks until it gets through. When it gets through the compression will be done instantly.

When you now cancel the compression the new build table will be thrown away and the job is finished. This runs very fast as well.

Best regards

   Clas Hortien

[Former Member]

Hi Yuksel,

Have you taken DB backup before compression? For us 105 GB table took 4.5 hours and reduced to 29 GB approx. If you have taken backup, you can try cancelling from SM37 and restart during off peak time. In case of any issue you can restore DB from the backup.

Thanks,
Kavitha Rajan

[Sriram2009]

Hi Yuksel

1. During the compression job failed / cancel time have you got any error message in SM21 log and SM37 Job  log?

2. what is your DB over all size? if possible ran the "CHECKDBCC" on MS Sql MMC for Database Consistency Checks

3. Could you share you SAP Version & SAP Basis SP & Kernel level?

BR

SS