New to DMC (3.1.6.1) and testing the migration from DSM jobs. I have a DB2 LOAD job that I cannot get to run successfully. I continue to receive:
SQL1024N A database connection does not exist.
I have a CONNECT statement prior to the load and it successfully connects. The next statement (LOAD) fails with the error:
Database :??
Instance : ??
Host name : ??
Authorization Id: db2admin
Run method : CLP
Date : Dec 2, 2021 10:28:51 AM
Status : Error
CONNECT TO PERF
LOAD FROM /home/db2admin/downloads/ASUM70PR.CSV OF DEL MODIFIED BY COLDEL, TIMESTAMPFORMAT="YYYY-MM-DD-HH:MM:SS.UUU" MESSAGES
/home/db2admin/downloads/ASUM70PR.MSG INSERT INTO DB2ADMIN.ASUM70PR
=======================================================================================
CONNECT TO PERF
Run time (seconds): 2.003
Status : Success
Database Connection Information
Database server = DB2/LINUXZ64 11.1.4.6
SQL authorization ID = DB2ADMIN
Local database alias = PERF
=======================================================================================
LOAD FROM /home/db2admin/downloads/ASUM70PR.CSV OF DEL MODIFIED BY COLDEL, TIMESTAMPFORMAT="YYYY-MM-DD-HH:MM:SS.UUU" MESSAGES
/home/db2admin/downloads/ASUM70PR.MSG INSERT INTO DB2ADMIN.ASUM70PR
Run time (seconds): 2.002
Status : Error
SQL1024N A database connection does not exist. SQLSTATE=08003
------------------------------
Robert Chavez
------------------------------
#Db2