Trying to improve performance

[rdeardorff@spi-ind.com]

We are seeing some errors in the Valence joblogs that we are trying to track down. These errors are

Result of SELECT more than one row.
Pointer not set for location referenced.
The entry type does not match with the expected type..
Indicator variable required.
Keyword AS not expected. Valid tokens: FULL LEFT CROSS INNER RIGHT EXCEPTION.

there are others as well, but I am having a difficult time tracking what specific RPG program is throwing those messages. I am certain some of the performance issues we are seeing is the handling of these errors.

Suggestions??

[robert.swanson]

I would suggest you turn on full logging in Portal Admin > Settings (if you haven't already), then use the timestamp of the exception messages in the job log to locate the corresponding program calls and/or SQL statements in the Valence log.

Here's a good blog post that explains how it works:

https://cnxcorp.com/tip-month/investigate-behind-the-scenes-activities-with-valence-logs/

FYI, for Valence 6.4 we are working on incorporating additional logging features that will integrate IBM's SQL Error Logging Factility (SELF) into the log viewer, making the process of tracking down the root cause of SQL exceptions a little easier.

[rdeardorff@spi-ind.com]

ok thank you. We will take a look