IBM Z and LinuxONE IBM Z

IBM Z

The enterprise platform for mission-critical applications brings next-level data privacy, security, and resiliency to your hybrid multicloud.

 View Only
Back to discussions
Expand all | Collapse all

DALLASC DB2 system is not working for any DDL or DML activity -- DALLASC- DB2 sub systems --- 192.86.33.83

  • 1.  DALLASC DB2 system is not working for any DDL or DML activity -- DALLASC- DB2 sub systems --- 192.86.33.83

    Posted Mon April 03, 2023 09:58 AM

    Hi Team,

    The DALLASC DB2 system is not working.. I am trying to create a new Table.

        SQL Error [57033]: UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT. REASON CODE 00C9008E, TYPE OF RESOURCE 00000304, AND RESOURCE NAME DSNDB06 .SYSTSTAB.X'0000004E'.X'0C'. SQLCODE=-913, SQLSTATE=57033, DRIVER=4.31.10



    Looks like the Database itself is messed up, need to do the Reorg/Runstats or any other refresh activity on this DB2 database/DALLASC.

    Can any one please look into this or suggest in order to bring back my Database.

    Thanks,
    Lakhan




    ------------------------------
    Lakhan Lal
    ------------------------------


Related Content