IBM Support

DSNT408I SQLCODE = -818 in TDS dialog after PM04508 ( GA PTF )

Troubleshooting


Problem

Cannot access the TDSz dialog after UK55389 is applied

Symptom

The following messages are seen in the TDS z/OS dialog:


SQL Error occurred in module 'DRLEINI1'. SQL return code -818 at line 1165 :
DSNT408I SQLCODE = -818, ERROR: THE PRECOMPILER-GENERATED TIMESTAMP
18B39C191F383F5A IN THE LOAD MODULE IS DIFFERENT FROM THE BIND TIMESTAMP
1884B3C0054DB290 BUILT FROM THE DBRM DRLPSQLX

Cause

PM04508 / PM10178

Resolving The Problem

After installing the PTFs for PM04508 and PK10178, which will include PTF UK55389 and

some or all of PTFs UK55390, UK55391, UK55392, UK55393, UK55394, UK55395, depending

on which FMIDs were installed, access to the TDS dialog will not be possible.

To correct this, rerun the DRLJDBIN (BIND) job from SDRLCNTL or LOCAL.,CNTL.

The only part of DRLJDBIN that must be re-executed is:

DSN SYSTEM(DB91)


BIND PLAN(DRLPLAN) MEMBER(DRLPSQLX) -
ACTION(REPLACE) RETAIN ISOLATION(CS) -
ENCODING (EBCDIC)

The other statements will fail if executed again but this will cause
no harm. (For example, CREATE STOGROUP will fail if the
STOGROUP was created by a previous run of DRLJDBIN).

[{"Product":{"code":"SSH53X","label":"Tivoli Decision Support for z\/OS"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"--","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"1.8.1","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
10 September 2019

UID

swg21425579