Managed File Transfer

 View Only
Expand all | Collapse all

IBM Sterling Connect:Direct - Locking Native DB2 File

  • 1.  IBM Sterling Connect:Direct - Locking Native DB2 File

    Posted Thu May 21, 2020 11:17 AM
    During testing, we discovered a problem while posting multiple files to the same native DB2 file [Series] file the job CDSMGR  user cdadmin, is keeping the member level lock and will never release it. 


    Has anyone run into this before?







    File . . . . . : GPC5010P Type . . . . . : PHY
    Library . . : ENDRES ASP device . . : *SYSBAS

    Type options, press Enter.
    4=End job 5=Work with job 8=Work with job locks



    GPC5010P                 CDSMGR        CDADMIN              DATA *SHRUPD HELD
                                       CDSMGR        CDADMIN              DATA *SHRUPD HELD
                                       CDSMGR        CDADMIN              DATA *SHRUPD HELD


    Work with Job Locks

    CDADMIN QSYS *USRPRF *SHRRD HELD
    *SHRRD HELD
    *SHRRD HELD
    GRP_QA QSYS *USRPRF *SHRRD HELD
    *SHRRD HELD
    *SHRRD HELD
    NDMCDLOBJ CDLIB *FILE-PHY *SHRRD HELD YES
    QPGMR QSYS *USRPRF *SHRRD HELD






    Display Open Files

    Job . . : CDSMGR User . . : CDADMIN Number . . . : 018219
    Number of open data paths . . . . . . . . . . : 2


    Member/ Record File I/O ----Open--- Relative
    File Library Device Format Type Count Opt Shr-Nbr Record
    NDMCDLOBJ CDLIB NDMCDLOBJ NDMCDLOBJ PHY 10 I NO 137
    GPC5010P ENDRES GPC5010P GPC5010P PHY 2 IO NO


    ------------------------------
    Jeff Endres
    ------------------------------

    #filetransfer
    #DataExchange


  • 2.  RE: IBM Sterling Connect:Direct - Locking Native DB2 File

    Posted Fri May 22, 2020 01:05 AM

    Hi Jeff,

    This query is pretty detailed - I would suggest you raise a Support ticket for the same. I'm sure the Connect:Direct for z/OS support team would be happy to resolve your case.

    Thank you,

    Tanvi Kakodkar

    Community Success Manager at IBM Sterling



    ------------------------------
    Tanvi Kakodkar
    Supply Chain Community Manager
    IBM
    ------------------------------