2698989 - DTP job performance degradation post upgrading BW kernel PL 500 of release 749 - SAP IQ

• Data Transfer Process (DTP) jobs in BW that are making DataStore Object requests to pull in NLS archived data from SAP IQ  start running considerably slower post upgrading BW to Kernel release 749, Patch Level 500
  
  
• ST12 tracing on the BW side shows these types of errors

  C *** ERROR => parse error at field 2; statement: INSERT INTO "/BIC/OMTLT_2018092409461154335" ( "DOC_NUMBER", "S_ORD_ITEM" )

  VALUES ( ? , ? )/*USE_IQ_LOAD*/

  /* R3:CL_SQL_STATEMENT==============CP:1114 T:/BIC/OMTLT_2018092409461154335 */

  [dbsyb.c 34532]

  C {root-id=D89D676186C81EE8AFFBC6C634572FE0}_{conn-id=00000000000000000000000000000000}_0

  C *** ERROR => meta data length 1 <= 1

  [dbsyb.c 55623]

  C *** ERROR => creation of load specification failed.

  [dbsyb.c 34532]

  C could not start iq load - failback to standard DML operation.

  C *** ERROR => could not lock table before array insert to IQ - table name is unknown.

  [dbsyb.c 34532

• Looking at corresponding INSERT operation messages seen in the iqmsg file or the srv server log on the SAP IQ side, batch inserts suddenly switch to single row inserts. For example

  09/24 23:09:44. Insert for '/BIC/OMTLT_2018092421094454585' completed in 0 seconds.  31522 rows inserted.

  09/24 23:09:48. Insert for '/BIC/OMTLT_2018092421094840691' completed in 0 seconds.  32724 rows inserted.

  09/24 23:09:49. Insert for '/BIC/OMTLT_2018092409461154335' completed in 0 seconds.  1 rows inserted.<< ---- Single Array Inserts start instead of batch

  09/24 23:09:49. Insert for '/BIC/OMTLT_2018092409461154335' completed in 0 seconds.  1 rows inserted.

  09/24 23:09:49. Insert for '/BIC/OMTLT_2018092409461154335' completed in 0 seconds.  1 rows inserted.

   … etc.

• SAP IQ request level logging for tracing the SQL executed shows that instead of requesting a write LOCK TABLE and running a batch  LOAD TABLE statement  only single row INSERT INTO is run.

• BW Kernel release 749
• DBSL version 749 Patch Level < 600
• SAP IQ 16.0 SP11.*

sybase, slow, fails, 'BW/NLS', CR816778, CR#816778, 816778, DBSL, 'Job Work', failback, longer, locking, fetch, DBCO, 'trace data', ZMIEUO15, ZMIEUO20 , KBA , rsda_syb 011 , bidtpr , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem