STORE command failing with DQ027E - REQUEST FAILED DUE TO SYSTEM ERROR - DB RETURN 94 (170) QEXEI

Products

• Datacom
• DATACOM - AD
• Datacom/AD
• Datacom/DB
• Datacom/Server

Issue/Introduction

STORE command in Dataquery online fails with

  DQ027E - REQUEST FAILED DUE TO SYSTEM ERROR - DB RETURN 94 (170) QEXEI  

after upgrade to Datacom version 12.0

Environment

Release: Datacom

Cause

With Datacom 12.0 and beyond, any database being used with SQL Data Definition Language (DDL) statements needs to be optimized in Multi-User (meaning ACCESS NOOPT can NOT be coded for this DBID).

This is a requirement as documented in APAR RI23671.  Internally for this STORE command an EXEC SQL CREATE TABLE is executed. This is a DDL statement resulting in a Datacom return code 94 (170) when the database is not optimized in Multi-User.

Resolution

Remove the DBID from ACCESS NOOPT in the Multi-User startup cards .