BEx Analyzer and DB2 10.5 BLU Tables

[alexandrepoitras]

Greetings !

We have upgrade our BI system to be able to use DB2 10.5 BLU Acceleration In-Memory Column-Oriented tables.

I am currently testing some BEx query to see the performance benefits from BLU compared to before.

We've converted the related tables to Column-Oriented table and we are looking to use BEx Analyser to run these BEx Queries.

Unfortunately, it seems that the BEx Analyser is unable to read the converted Column-Oriented Tables.

It does not seems to work, as I receive a message telling me that no records are found. ('No Applicable Data Found.)

I've installed the lastest patch for SAP Gui (NW Presentation 7.0 -­­> 50120297_6.ZIP).

Anyone have tried this ?

Thanks a lot !

[maria_shen · Accepted solution]

Hello,

I am not sure if below notes have been completely checked.

1889656 - DB6: Mandatory SAP NW BW corrections for BLU Acceleration

1819734 - DB6: Use of BLU Acceleration

1825340 - DB6: Use of BLU Acceleration with NetWeaver BW

If so, I recommend to create a SAP ticket and we will continue to help you.

Thanks and kind regards

Maria

[alexandrepoitras · Accepted solution]

Hi Maria.

1889656 - DB6: Mandatory SAP NW BW corrections for BLU Acceleration: Has been read but as STACK 11 is not released yet (SAPKW73011) we have proceed with manual corrections suggested for 730 (1302831, 1321783,1307493, 1298340).

1819734 - DB6: Use of BLU Acceleration: Has been read and applied.

1825340 - DB6: Use of BLU Acceleration with NetWeaver BW : Has been read and applied

A SAP Ticket is already open since yesterday. I am waiting for their inputs about my issue.

[maria_shen · Accepted solution]

Hello Alex,

Thank you for your feedback.

Let's continue to communicate via SAP ticket.

Kind regards

Maria

[Former Member · Accepted solution]

HI guys

We are now evaluating BLU with BW 7.3.  I would be interested in how this is going please?

Lee Lewis

[alexandrepoitras · Accepted solution]

We are currently in processing with SAP.

As soon as we have a solution, we will post an update.

Stay tuned !

[maria_shen · Accepted solution]

Hello Lewis,

As Alex said, currently it is being processed within SAP ticket.

On the other hand, below guide which may be known to you, may also help.

SAP NetWeaver BW 7.3 and Higher - Administration Tasks IBM DB2 for Linux, UNIX, and Windows

Chapter 7 Improving Database Performance Using BLU Acceleration

Kind regards

Maria

[Former Member · Accepted solution]

We have DB2 10.5 FP1 BLU on SAP BW 7.4 SP6 on AIX 6.1 TL9 and converted the majority of BW table spaces.  The hardest part was getting all the required notes applied up to 7.4 from 7.3.1

We then ran across problems where the majority of our bex queries short dumped. This turns out to be related to the input variable user exit EXIT_SAPLRRS0_001 and others.

See note 1823174  BW 7.4 Changes to Customer Specific Programs

You can use the Code Inspector Tool (transaction SCI) to systematically detect and resolve these problems. You should, if possible, run a check both before and after the upgrade. With the attached program, you can then identify all problems that did not occur until

Once we applied the adjustments, we were able to execute our bex queries and finding response times improving roughly 30%-40%. The tablespace sizes decreased  75%, i.e. 250GB to 64GB and more disk space is freed since the secondary indexes are no longer required and are deleted.

So far so good!

Lee Lewis