SAP Knowledge Base Article - Preview

2371160 - FAQ: BW archiving to SAP IQ performance considerations

Symptom

The BW system has a connected SAP IQ Near-Line Storage solution. The archiving (especially the write phase) takes longer than expected.


Read more...

Environment

  • SAP NetWeaver 7.3
  • SAP NetWeaver BW 7.31   (SAP NW BW 7.3 EnhP 1)
  • SAP NetWeaver BW 7.40
  • SAP NetWeaver 7.40
  • SAP NetWeaver 7.50
  • SAP BW/4HANA

Product

SAP BW/4HANA all versions ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.3

Keywords

DbSlExecute - Error 99 (dbcode -265) on DDLExecute
DbSlExecute - <@DBSL_SET_PARAM SYBASE_IQ_LOAD_MULTIPLE_FILES=1 >
dbdssyb: DBSL99 SQL-265
[IQ Error SQL-265:42S02][Sybase IQ]Procedure '@DBSL_SET_PARAM' not found could not start iq load - failback to array insert could not lock table before array insert to IQ - table name is unknown semantic grouping parallel archiving parallel dap slow archiving process GET_NEXT_OBJECT CL_RSDA_REQUEST_READER SYSTEM_NO_ROLL_MEMORY sql error 403 performing EXE internal error: Error executing query [SAP][ODBC Driver][SAP IQ]IQ heap memory limit exceeded   , KBA , BW-WHM-DST-ARC , Archiving , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.