Db2

 View Only

  • 1.  DMC: SQL1024N A database connection does not exist.

    Posted Thu December 02, 2021 11:42 AM
    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


  • 2.  RE: DMC: SQL1024N A database connection does not exist.

    Posted Thu December 09, 2021 01:24 AM
    It looks like not kept in the same context but uses two separate transactions. will try to reproduce and get you back

    ------------------------------
    YUAN FENG
    ------------------------------

    Original Message


  • 3.  RE: DMC: SQL1024N A database connection does not exist.

    Posted 23 days ago

    I have a similar problem except that I am using Windows 11.

    The CONNECT TO statement completes successfully

    but a simple LIST TABLES statement fails with the connection error.

    Has this problem been resolved and if so what is the solution ?



    ------------------------------
    Trevor Clarkson
    ------------------------------

    Original Message