SAP Knowledge Base Article - Preview

2524082 - Why query plan shows up in the log file - SAP ASE

Symptom

A query plan is written to the ASE errorlog:

00:0002:00000:00012:2017/08/23 12:53:17.37 server  Optimized using Serial Mode
00:0002:00000:00012:2017/08/23 12:53:17.37 server
00:0002:00000:00012:2017/08/23 12:53:17.37 server
00:0002:00000:00012:2017/08/23 12:53:17.37 server      STEP 1
00:0002:00000:00012:2017/08/23 12:53:17.37 server          The type of query is COND.
00:0002:00000:00012:2017/08/23 12:53:17.37 server
00:0002:00000:00012:2017/08/23 12:53:17.37 server       1 operator(s) under root
00:0002:00000:00012:2017/08/23 12:53:17.37 server
00:0002:00000:00012:2017/08/23 12:53:17.37 server         |ROOT:EMIT Operator (VA = 1)
00:0002:00000:00012:2017/08/23 12:53:17.37 server         |
00:0002:00000:00012:2017/08/23 12:53:17.37 server         |   |SCALAR Operator (VA = 0)
00:0002:00000:00012:2017/08/23 12:53:17.37 server
00:0002:00000:00012:2017/08/23 12:53:17.37 server
00:0002:00000:00012:2017/08/23 12:53:17.37 server
00:0002:00000:00012:2017/08/23 12:53:17.37 server  QUERY PLAN FOR STATEMENT 60 (at line 435).
00:0002:00000:00012:2017/08/23 12:53:17.37 server  Optimized using Serial Mode


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise all versions ; Sybase Adaptive Server Enterprise all versions

Keywords

showplan, console, terminate , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.