Topic
  • 1 reply
  • Latest Post - ‏2016-12-14T10:01:28Z by FJYC_Magwati_Valentine
dereal
dereal
2 Posts

Pinned topic metadata database cannot be retrieved

‏2013-10-11T12:51:41Z |

i get the DWE7001E error when opening the infosphere warehouse console in browser.".....metadata database cannot be retrieved......". this is the error in the system.out log

RES37601E: The system cannot obtain an SQL connection for metadata database for the following reason com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2043][11550][3.63.138] Exception java.net.ConnectException: Error opening socket to server /10.0.6.233 on port 50,001 with message: Connection refused. ERRORCODE=-4499, SQLSTATE=08001

 

i checked the port, db2comm and tco/ip configurations are set correctly.  how am i to resolve this problem? there are control flows running every night and i find the database down every morning. please help.

 

  • FJYC_Magwati_Valentine
    1 Post

    Re: metadata database cannot be retrieved

    ‏2016-12-14T10:01:28Z  

    1. Check if your db2 is running, if not start it.

    2. Try to backup & restore the backup image of the metadata db and try to run your control flows.