Troubleshooting
Problem
A user attempted to load data from Db2 for z/OS to a remote Db2 for Linux, UNIX, and Windows location using the cross-loader utility. This action resulted in message DSNU1188I with SQL code -805.
Symptom
The following message was issued:
DSNU1188I 059 09:57:29.30 DSNUGSQL - SQLCODE = -805, SQLSTATE = 51002, INVALID APPLICATION STATE FROM DB2 UDB for AIX, Linux, HP-UX, Sun, and Windows TOKENS DSNUTIL.DSNUGSQL 0X0E5F1F1D09F14040
Cause
The problem occurred because the user did not bind the package
DSNUTIL.DSNUGSQL to the remote location.
DSNUTIL.DSNUGSQL to the remote location.
Resolving The Problem
To resolve this problem, run the following batch job from the local Db2 for z/OS subsystem to bind the package to the remote location that is defined in the communication database (CDB):
DSN SYSTEM(DBA1)
BIND PACKAGE(remotelocation.DSNUTIL) MEMBER(DSNUGSQL) -
LIBRARY('prefix.SDSNDBRM') -
VALIDATE(RUN) ISOLATION(CS)
END
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
31 March 2020
UID
ibm15692880